3.10.0 Overview

Module 4 introduces techniques to scale data and technologies for data analysis and business intelligence. 1:16 minutes

• Module 4: Overview Video

Target Competencies

• Assemble advanced queries using SQL
• Evaluate optimization techniques for data models
• Construct an ETL (extract, transform, and load) to a data infrastructure
• Use business intelligence technologies for data analysis
• Model data for analysis
• Summarize data using business intelligence tools
• Present data for analysis using business intelligence tools
• Interpret data for decision makers
• Construct data models for data analysis

Learning Objectives

• Create logical joins to query data
• Develop queries to populate data models
• Explain queried data results
• Write queries for optimal performance
• Demonstrate best practices in query structure
• Identify errors and required components of a query
• Create a basic data flow following the ETL process
• Create an ETL process that executes syntax
• Create an ETL process using a diverse set of tasks
• Explain the value of data analysis
• Identify different kinds of data used for analysis
• Compare data models
• Contrast data models
• Interpret data model results