Data Resource Management Flashcards

Overview of Data Resource Management

• Data Resource Management is a critical unit within Information Technology Management Essentials.

• The core focus is on how organizations manage, organize, and utilize data to support both daily operations and strategic decision-making.

• Key topics included in this domain are:

  • Data management concepts.

  • Databases and database management systems (DBMS).

  • Big data and data analytics.

  • Tools and processes used to transform raw data into actionable information.

• The primary goal of studying these concepts is to build a clear understanding of how effective data management directly supports business performance and high-level strategy.

Fundamental Data Management Concepts

• Definition of Data Management: Refers to the collective practices, tools, and processes employed to manage data across an entire organization.

• Primary Objectives:

  • Accuracy: Ensuring data is correct.

  • Consistency: Ensuring data remains uniform across different systems.

  • Accessibility: Ensuring data is available to users precisely when it is needed.

• Case Study - Amazon: Amazon must manage customer data, order histories, and inventory data simultaneously. This management ensures that all information is updated in real time and is consistently available across all their interconnected systems.

Data vs. Information

• Data: Refers to raw and unorganized facts. By itself, data does not provide significant value.

  • Example: A list of numbers representing sales is considered raw data.

• Information: Refers to data that has been processed and organized to be meaningful.

  • Example: When raw sales numbers are organized into a report showing monthly trends, they become useful information.

• Data only gains value when it is organized and placed within a specific context.

Data Governance and Institutional Control

• Definition: Data governance involves the specific policies and procedures used to manage data within an organization.

• Functions:

  • Ensures data security.

  • Guarantees data accuracy.

  • Mandates proper usage of data.

• Example - Healthcare: A hospital utilizes data governance to control access to patient records, ensuring that sensitive medical and personal information is protected from unauthorized viewing.

Database Structure and Management Systems

• Database Storage: Data is stored in tables consisting of rows and columns.

  • Rows: Represent individual records (e.g., one specific student).

  • Columns: Represent specific fields of data (e.g., Student ID, Name, Major).

• Database Management System (DBMS): Software that allows users to create, manage, and interact with databases. It organizes data and enables the creation of relationships between different tables.

  • Notable Examples: MySQL and Oracle are widely used by businesses to manage large volumes of structured data.

• Key Database Components:

  • Primary Key: A field that uniquely identifies each record within a table.

  • Foreign Key: A field used to link two tables together.

    • Example: A $\text{Customer ID}$ in a customer table might serve as a foreign key in an orders table to connect specific customers to their purchase history.

  • Schemas: The overall structure or blueprint of the database.

Big Data Characteristics and Analysis

• Definition: Big data refers to extremely large data sets originating from diverse sources that are difficult to process using traditional data processing methods.

• Example - Social Media: Platforms collect massive amounts of user data every second, including posts, likes, and social interactions.

• The Four Vs of Big Data:

  1. Volume: The sheer amount of data generated.

  2. Variety: The different types/formats of data collected (e.g., text, video, audio).

  3. Velocity: The speed at which new data is generated and processed.

  4. Veracity: The reliability and accuracy of the data.

• Example - Netflix: Streaming services like Netflix must manage large volumes, different data types, and real-time updates to ensure recommendation accuracy.

• Data Mining: The process of analyzing large data sets to identify patterns, trends, and relationships to facilitate better decision-making.

  • Example: A retailer might use data mining to determine which specific products are frequently purchased together.

Data Types and Processing Tools

• Types of Data:

  • Structured Data: Highly organized and easily searchable in relational databases (e.g., a spreadsheet).

  • Unstructured Data: Has no predefined format or organization (e.g., videos, emails, social media posts).

  • Semi-structured Data: Falls between structured and unstructured data; it contains tags or markers to separate semantic elements but does not reside in a relational database.

• Processing Tools:

  • ETL (Extract, Transform, Load): A process that extracts data from various systems, transforms it into a suitable format, and loads it into a central repository like a data warehouse.

  • Hadoop: An open-source framework that allows for the storage and processing of massive data sets across clusters of computers/multiple systems.

The Data Management Process

• Core Steps:

  1. Collecting Data: Gathering raw data from sources.

  2. Validating Data: Checking data for accuracy and reliability before use.

  3. Storing Data: Placing data in secure, accessible environments.

  4. Converting Data: Transforming data into useful information.

• Three Steps for Effective Data Collection:

  1. Defining the Purpose: Identifying the specific goal (e.g., improving customer satisfaction).

  2. Developing Questions: Creating precise survey or inquiry points to gather the necessary facts.

  3. Selecting Tools: Choosing the appropriate software or methods (e.g., online survey tools) to collect the responses.

Master Data Management (MDM)

• Definition: A method of ensuring that an organization's most critical data is consistent and accurate across all departments.

• Goal: To provide a "single source of truth."

• Example: Customer information should be identical and synchronized across sales, marketing, and customer support systems to avoid discrepancies.

Business Impact and Analytics

• Return on Investment (ROI): Proper data management reduces errors and increases operational efficiency.

  • Poor Management Consequences: Inaccurate inventory data can lead to overstocking or lost sales due to stockouts.

• Predictive Analytics: The use of historical data to forecast future trends and behaviors.

  • Example: Retailers use this to forecast product demand during specific seasons.

• Business Intelligence (BI): Systems and tools that turn data into insights for managers.

  • Example: Dashboards and reports used to monitor real-time performance.

• Data Analysis vs. Data Analytics:

  • Data Analysis: Examining data to find meaning and understand past outcomes (e.g., identifying which products performed well).

  • Data Analytics: Identifying deeper relationships and trends to support business decisions (e.g., topic analysis of customer feedback).

• Business Analytics: Focuses specifically on using data to predict trends, determine pricing strategies, and gain a competitive advantage.

The Three Types of Analytics

1. Descriptive Analytics: Describes what has happened in the past (e.g., past sales reports).

2. Predictive Analytics: Forecasts what is likely to happen in the future (e.g., future sales projections).

3. Prescriptive Analytics: Suggests specific courses of action to improve outcomes and reach desired goals.

Challenges in Data Analytics and Business Intelligence

Organizations face eight primary challenges in this field:

1. Handling the high Volume of data.

2. Managing the Variety of data formats.

3. Keeping up with the Velocity of incoming data.

4. Effectively incorporating Artificial Intelligence (AI) and Machine Learning.

5. Ensuring Data Quality and Consistency (low quality leads to incorrect business decisions).

6. Managing Scalability as data needs grow.

7. Maintaining Data Privacy and Compliance with regulations.

8. Improving Collaboration, Communication, and Democratizing Data Access (adopting a data-driven culture).

Qualitative Return on Investment (ROI)

• Definition: Focuses on the intangible benefits of IT and data changes rather than just direct financial gain.

• Key Factors:

  • Improved operating efficiencies.

  • Better decision-making confidence.

  • Prevention of data loss.

  • Improved data accuracy leading to faster responses.

• This analysis provides stakeholders with the qualitative information necessary to make holistic decisions for the company.

Data Protection and IT Assets

• IT Assets: Technology investments (system upgrades) support data management by increasing processing speeds and reducing errors.

• Layered Data Protection: Security must be applied at three distinct levels:

  1. Data Level: Securing the actual files and records.

  2. System Level: Protecting the hardware and software environments.

  3. User Level: Controlling access through authentication (e.g., ensuring only authorized employees can access sensitive records).