Module 1: Identifying Basic Concepts of Data Schemas

• Identify Relational and Non-Relational Databases
• Understand the Way We Use Tables, Primary Keys and Normalization

Module 2: Understanding Different Data Systems

• Describe Types of Data Processing and Storage Systems
• Explain How Data Changes

Module 3: Understanding Types and Characteristics of Data

• Understand Types of Data
• Break Down the Field Data Types

Module 4: Comparing and Contrasting Different Data Structures, Formats and Markup Languages

• Differentiate Between Structured Data and Unstructured Data
• Recognize Different File Formats
• Understand the Different Code Languages Used for Data

Module 5: Explaining Data Integration and Collection Methods

• Understand the Process of Extracting, Transforming, and Loading Data
• Explain API/Web Scraping and Other Collection Methods
• Collect and Use Public and Publicly Available Data
• Use and Collect Survey Data

Module 6: Identifying Common Reasons for Cleansing and Profiling Data

• Learn to Profile Data
• Address Reduntant, Duplicated, and Unnecessary Data
• Work with Missing Values
• Address Invalid Data
• Convert Data to Meet Specifications

Module 7 : Executing Different Data Manipulation Techiques

• Manipulate Field Data and Create Variables
• Transpose and Append Data
• Query Data

Module 8: Explaining Common Techniques for Data Manipulation and Optimization

• Use Functions to Manipulate Data
• Use Common Techniques for Query Optimization

Module 9: Applying Descriptive Statistical Methods

• Use Measures of Central Tendency
• Use Measures of Dispersion
• Use Frequency and Percentages

Module 10: Describing Key Analysis Techniques

• Get Started with Analysis
• Recognize Types of analysis

Module 11: Understanding the Use of Different Statistical Methods

• Understand the Importance of Statistical Tests
• Break Down the Hypothesis Test
• Understand Tests and Methods to Determine Relationships Between Variables

Module 12: Using the Appropriate Type of Visualization

• Use Basic Visuals
• Build Advanced Visuals
• Build Maps with Geographical Data
• Use Visuals to Tell a Story

Module 13: Expressing Business Requirements in a Report Format

• Consider Audience Needs When Developing a Report
• Describe Data Source Considerations for Reporting
• Describe Considerations for Delivering Reports Dashboards
• Develop Reports or Dashboards
• Understand Ways to Sort and Filter Data

Module 14: Designing Components for Reports and Dashboards

• Choose Design Elements for Reports/Dashboards
• Utilize Standart Elements for Reports/Dashboards
• Create a Narrative and Other Written Elements
• Understand Deployment Considerations

Module 15: Distinguishing Different Report Types

• Understand How Updates and Timing Affect Reporting
• Differentiate Between Types of Reports

Module 16: Summarizing the Importance of Data Governance

• Define Data Governance
• Understand Access Requirements and Policies
• Understand Security Requirements
• Understand Entity Relationship Requirements

Module 17: Applying Quality Control to Data

• Describe Characteristics, Rules, and Metrics of Data Quality
• Identify Reasons to Quality to Quality Check Data and Methods of Data Validation

Module 18: Explaining Master Data Management Concepts

• Explain the Basics Master Data Management
• Describe Master Data Management Processes