1 – Identifying Basic Concepts of Data Schemas
Identify Relational and Non-Relational Databases
Understand the Way We Use Tables, Primary Keys, and Normalization
2 – Understanding Different Data Systems
Describe Types of Data Processing and Storage Systems
Explain How Data Changes
3 – Understanding Types and Characteristics of Data
Understand Types of Data
Break Down the Field Data Types
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
5 – Explaining Data Integration and Collection Methods
Understand the Processes 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
6 – Identifying Common Reasons for Cleansing and Profiling Data
Learn to Profile Data
Address Redundant, Duplicated, and Unnecessary Data
Work with Missing Value
Address Invalid Data
Convert Data to Meet Specifications
7 – Executing Different Data Manipulation Techniques
Manipulate Field Data and Create Variables
Transpose and Append Data
Query Data
8 – Explaining Common Techniques for Data Manipulation and Optimization
Use Functions to Manipulate Data
Use Common Techniques for Query Optimization
9 – Applying Descriptive Statistical Methods
Use Measures of Central Tendency
Use Measures of Dispersion
Use Frequency and Percentages
10 – Describing Key Analysis Techniques
Get Started with Analysis
Recognize Types of Analysis
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
12 – Using the Appropriate Type of Visualization
Use Basic Visuals
Build Advanced Visuals
Build Maps with Geographical Data
Use Visuals to Tell a Story
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 and Dashboards
Develop Reports or Dashboards
Understand Ways to Sort and Filter Data
14 – Designing Components for Reports and Dashboards
Design Elements for Reports and Dashboards
Utilize Standard Elements
Creating a Narrative and Other Written Elements
Understand Deployment Considerations
15 – Understand Deployment Considerations
Understand How Updates and Timing Affect Reporting
Differentiate Between Types of Reports
16 – Summarizing the Importance of Data Governance
Define Data Governance
Understand Access Requirements and Policies
Understand Security Requirements
Understand Entity Relationship Requirements
17 – Applying Quality Control to Data
Describe Characteristics, Rules, and Metrics of Data Quality
Identify Reasons to Quality Check Data and Methods of Data Validation
18 – Explaining Master Data Management Concepts
Explain the Basics of Master Data Management
Describe Master Data Management Processes