Course
The preparation phase is the most important step in data analysis. Before data can be effectively analyzed, an effective data model is required, and creating that data model may utilize a wide range of skills. This course teaches the skills needed to load, clean, and organize data in Power Query and create relational tables in Power Query and Power BI. After completing this course, students will be able to effectively source data in Power BI and create a clean and efficient data model for analysis.
The preparation phase is the most important step in data analysis. Before data can be effectively analyzed, an effective data model is required, and creating that data model may utilize a wide range of skills. This course teaches the skills needed to load, clean, and organize data in Power Query and create relational tables in Power Query and Power BI. After completing this course, students will be able to effectively source data in Power BI and create a clean and efficient data model for analysis.
4 weeks
Real-world Projects
Completion Certificate
Last Updated March 8, 2023
No experience required
Lesson 1
Introduction to Data Preparation & Modeling
Introduction to Data Preparation & Modeling lesson introduces students to the topics, highlights, and prerequisites of the course. And requirements to successfully complete the course are explained.
Lesson 2
Relational Data & Table Structure
Relational Data & Table Structure lesson teaches the core concepts around working with data from multiple sources and tables. It explains what relational data is and how it works.
Lesson 3
Power Query & M Overview
Power Query & M Overview lesson highlights the Power Query data wrangling system that is used within Power BI. Specific cleaning and organization tools and techniques are explored.
Lesson 4
Data Cleaning and Organization
Data Cleaning & Organization lesson takes a practical deep dive into Power Query. Here more complex data cleaning and organization strategies are practiced, and the M language is explained.
Lesson 5
DAX Language & Quantitative Analysis
DAX Language & Quantitative Analysis lesson dives into DAX, which is the primary analytical language of Power BI. Different foundational concepts around DAX calculations are covered.
Lesson 6 • Project
Population Statistics Data Model
The project asks students to gather data about the US economy to understand better the makeup of the economy and how it’s changing. Students will submit a PowerBI report at the end.
Lesson 7
Microsoft PowerBI Workspace
In this lesson, you'll learn how to set up a Windows desktop workspace to use Power BI
Joseph Lozada
Senior Business Intelligence Consultant
Joseph works at The Planet Group, engaging with clients in the energy industry across the US. He helps clients collect data, set up data infrastructure, and provide data analysis and forecasting to better understand their operations and finances. He also works as an adjunct instructor of Excel and Microsoft Power BI analytics at the Community College of Rhode Island.
Joseph Lozada
Senior Business Intelligence Consultant
Joseph works at The Planet Group, engaging with clients in the energy industry across the US. He helps clients collect data, set up data infrastructure, and provide data analysis and forecasting to better understand their operations and finances. He also works as an adjunct instructor of Excel and Microsoft Power BI analytics at the Community College of Rhode Island.
Get Started Today
