Lesson 1: Identifying Basic Concepts of Data Schemas
Topic 1A: Identify Relational and Non Relational Databases Exam Objective: 1.1
Identify basic concepts of data schemas and dimensions
Topic 1B: Understand the Way We Use Tables, Primary Keys, and Normalization
Exam Objectives: 1.1Identify basic concepts of data schemas and dimensions.
2.3 Given a scenario, execute data manipulation techniques.
5.1 Summarize important data governance concepts.
Lesson 2: Understanding Different Data Systems
Topic 2A: Describe Types of Data Processing and Storage Systems Exam Objective: 1.1
Identify basic concepts of data schemas and dimensions
Topic 2B: Explain How Data Changes Exam Objective: 1.1
Identify basic concepts of data schemas and dimensions
Lesson 3: Understanding Types and Characteristics of Data
Topic 3A: Understand Types of Data Exam Objective: 1.2
Compare and contrast different data types
Topic 3B: Break Down the Field Data Types Exam Objective: 1.2
Compare and contrast different data types.
Lesson 4: Comparing and Contrasting Different Data Structures, Formats, and Markup Languages
Topic 4A: Differentiate between Structured Data and Unstructured Data
Exam Objective: 1.3 Compare and contrast common data structures and file formats.
Topic 4B: Recognize Different File Formats Exam Objective: 1.3 Compare and contrast
common data structures and file formats
Topic 4C: Understand the Different Code Languages Used for Data Exam Objective: 1.3
Compare and contrast common data structures and file formats.
Lesson 5: Explaining Data Integration and Collection Methods
Topic 5A: Understand the Processes of Extracting, Transforming, and Loading Data Exam Objective: 2.1
Explain data acquisition concepts
Topic 5B: Explain API/Web Scraping and Other Collection Methods
Exam Objectives: 2.1 Explain data acquisition concepts.
1.3 Compare and contrast common data structures and file formats.
Topic 5C: Collect and Use Public and Publicly Available Data
Exam Objective: 2.1 Explain data acquisition concepts.
Topic 5D: Use and Collect Survey Data
Exam Objective: 2.1 Explain data acquisition concepts.
Lesson 6: Identifying Common Reasons for Cleansing and Profiling Data
Topic 6A: Learn to Profile Data Exam Objective: 2.2 Identify common reasons
for cleansing and profiling datasets.
Topic 6B: Address Redundant, Duplicated, and Unnecessary Data Exam Objective: 2.2
Identify common reasons for cleansing and profiling datasets.
Topic 6C: Work with Missing Values Exam Objective: 2.2
Identify common reasons for cleansing and profiling datasets.
Topic 6D: Address Invalid Data Exam Objective: 2.2
Identify common reasons for cleansing and profiling datasets.
Topic 6E: Convert Data to Meet Specifications Exam Objective: 2.2
Identify common reasons for cleansing and profiling datasets.
Lesson 7: Executing Different Data Manipulation Techniques
Topic 7A: Manipulate Field Data and Create Variables Exam Objective: 2.3
Given a scenario, execute data manipulation techniques.
Topic 7B: Transpose and Append Data Exam Objective: 2.3
Given a scenario, execute data manipulation techniques
Topic 7C: Query Data Exam Objective: 2.3
Given a scenario, execute data manipulation techniques.
Lesson 8: Explaining Common Techniques for Data Manipulation and Optimization
Topic 8A: Use Functions to Manipulate Data Exam Objective: 2.3
Given a scenario, execute data manipulation techniques.
2.4 Explain common techniques for data manipulation and query optimization.
Topic 8B: Use Common Techniques for Query Optimization Exam Objective: 2.4
Explain common techniques for data manipulation and query optimization
Lesson 9: Applying Descriptive Statistical Methods
Topic 9A: Use Measures of Central Tendency Exam Objective: 3.1
Given a scenario, apply the appropriate descriptive statistical methods.
Topic 9B: Use Measures of Dispersion Exam Objective: 3.1
Given a scenario, apply the appropriate descriptive statistical methods
Topic 9C: Use Frequency and Percentages Exam Objective: 3.1
Given a scenario, apply the appropriate descriptive statistical methods.
Lesson 10: Describing Key Analysis Techniques
Topic 10A: Get Started with Analysis Exam Objective: 3.3
Summarize types of analysis and key analysis techniques.
Topic 10B: Recognize Types of Analysis Exam Objective: 3.3
Summarize types of analysis and key analysis techniques.
Lesson 11: Understanding the Use of Different Statistical Methods
Topic 11A: Understand the Importance of Statistical Tests Exam Objective: 3.2
Explain the purpose of inferential statistical methods
Topic 11B: Break Down the Hypothesis Test Exam Objective: 3.2
Explain the purpose of inferential statistical methods
Topic 11C: Understand Tests and Methods to Determine Relationships Between Variables Exam Objective: 3.2
Explain the purpose of inferential statistical methods.
Lesson 12: Using the Appropriate Type of Visualization
Topic 12A: Use Basic Visuals Exam Objective: 4.4
Given a scenario, apply the appropriate type of visualization
Topic 12B: Build Advanced Visuals Exam Objective: 4.4
Given a scenario, apply the appropriate type of visualization
Topic 12C: Build Maps with Geographical Data Exam Objective: 4.4
Given a scenario, apply the appropriate type of visualization.
Topic 12D: Use Visuals to Tell a Story Exam Objective: 4.4
Given a scenario, apply the appropriate type of visualization.
Lesson 13: Expressing Business Requirements in a Report Format
Topic 13A: Consider Audience Needs When Developing a Report Exam Objective: 4.1
Given a scenario, translate business requirements to form a report.
Topic 13B: Describe Data Source Considerations For Reporting Exam Objective: 4.3
Given a scenario, use appropriate methods for dashboard development.
Topic 13C: Describe Considerations for Delivering Reports and Dashboards Exam Objective: 4.1
Given a scenario, translate business requirements to form a report.
4.3 Given a scenario, use appropriate methods for dashboard development.
Topic 13D: Develop Reports or Dashboards Exam Objective: 4.
Given a scenario, translate business requirements to form a report.
4.3 Given a scenario, use appropriate methods for dashboard development.
Topic 13E: Understand Ways to Sort and Filter Data Exam Objectives: 4.1
Given a scenario, translate business requirements to form a report.
4.3 Given a scenario, use appropriate methods for dashboard development
Lesson 14: Designing Components for Reports and Dashboards
Topic 14A: Design Elements for Reports and Dashboards Exam Objective: 4.2
Given a scenario, use appropriate design components for reports and dashboards
Topic 14B: Utilize Standard Elements Exam Objective: 4.2
Given a scenario, use appropriate design components for reports and dashboards.
Topic 14C: Creating a Narrative and Other Written Elements Exam Objective: 4.2
Given a scenario, use appropriate design components for reports and dashboards
Topic 14D: Understand Deployment Considerations Exam Objective: 4.3
Given a scenario, use appropriate methods for dashboard development
Lesson 15: Distinguishing Different Report Types
Topic 15A: Understand How Updates and Timing Affect Reporting Exam Objective: 4.5
Compare and contrast types of reports.
Topic 15B: Differentiate Between Types of Reports Exam Objective: 4.5
Compare and contrast types of reports.
Lesson 16: Summarizing the Importance of Data Governance
Topic 16A: Define Data Governance Exam Objective: 5.1
Summarize important data governance concepts.
Topic 16B: Understand Access Requirements and Policies Exam Objective: 5.1
Summarize important data governance concepts
Topic 16C: Understand Security Requirements Exam Objective: 5.1
Summarize important data governance concepts.
Topic 16D: Understand Entity Relationship Requirements Exam Objective: 5.1
Summarize important data governance concepts.
Lesson 17: Applying Quality Control to Data
Topic 17A: Describe Characteristics, Rules, and Metrics of Data Quality Exam Objective: 5.2
Given a scenario, apply data quality control concepts
Topic 17B: Identify Reasons to Quality Check Data and Methods of Data Validation Exam Objective: 5.2
Given a scenario, apply data quality control concepts.
Lesson 18: Explaining Master Data Management Concepts
Topic 18A: Explain the Basics of Master Data Management Exam Objective: 5.3
Explain master data management (MDM) concepts
Topic 18B: Describe Master Data Management Processes Exam Objective: 5.3
Explain master data management (MDM) concepts
Appendix A: Identifying Common Data Analytics Tools
Exam Objective: 3.4 Identify common data analytics tools
