Mastering Data Stewardship: Hands-On

Data Management Overview

• Collecting, storing, securing, and using an organization’s data
• Data quality management
• Data distribution and consistency
• Big data management
• Data architecture and data modeling

Data Management Organizations

• Data Management Association (DAMA)

Data Management Roles and Responsibilities

• Data Architect
• Data Engineer
• Data Modeler

Data Management Processes

Data Management Workflow

• Data Collection
• Data Processing
• Data Distribution
• Data Discovery
• Data Analysis
• Data Archiving
• Repurposing

Data Management Services and Applications

Creating a Data Management Plan

Data Analytics Overview

Data Analytics Process

• Data collection
• Data storage
• Data processing
• Data cleansing
• Data analysis

Data collection

• Extract Transform Load (ETL)
• Extract Load Transform (ELT)

Data storage

• Data warehouses
• Data lakes
• Comparing data lakes and data warehouses

Data processing

• Centralized processing
• Distributed processing
• Batch processing
• Real-time processing
• Data cleansing
• Data analysis

Data Analytics

• Descriptive analytics
• Diagnostic analytics
• Predictive analytics
• Prescriptive analytics

Computing techniques used in data analytics

• Natural language processing
• Text mining
• Sensor data analysis
• Outlier analysis

Data Modelling Overview

Conceptual Data Models: Big picture view of data

• What data a system contains
• Data attributes and conditions or constraints on data
• What business rules data relates to
• How data is best organized
• Security and data integrity requirements

Logical Data Models: Mapping conceptual data classes to technical data structures

• Data types of various attributes
• Relationships between data entities
• Primary attributes or key fields in data

Physical Data Models: Mapping logical data models to a DBMS

• Data field types as represented in a DBMS
• Data relationships as represented in a DBMS
• Performance tuning

Data Modeling Techniques

• Hierarchical data modeling
• Graph data modeling
• Relational data modeling
• Entity-relationship data modeling
• Object-oriented data modeling
• Dimensional data modeling

Data Modeling Process

• Overview
• Identify entities and properties
• Identify relationships between entities
• Identify data modeling technique
• Optimize and iterate

Modern Data Architecture Overview

Scalable Data Lakes

Purpose-Built Analytics Services

Unified Data Access

Unified Data Governance

Data Governance Overview

• Policies and procedures an organization implements to manage data security, integrity, and responsible data use
• Regulatory compliance
• Data security and access control

Data Governance Organizations

• Data Governance Institute

Data Governance Roles and Responsibilities

• Data Governance Council/Data Administrator
• Data Steward
• Data Custodian

1. Hands-on Exercise: Creating a Data Lake
2. Hands-on Exercise: Collecting Data with Extract Transform Load (ETL)
3. Hands-on Exercise: Performing Data Cleansing
4. Hands-on Exercise: Performing Data Analytics
5. Hands-on Exercise: Implementing the Data Modelling Process
6. Hands-on Exercise: Creating Conceptual Data Models
7. Hands-on Exercise: Creating Logical Data Models
8. Hands-on Exercise: Creating Physical Data Models
9. Hands-on Exercise: Examining Data Modeling Techniques
10. Hands-on Exercise: Examining the Data Modeling Process