Data Preparation and Modeling

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.

Beginner

4 weeks

Real-world Projects

Completion Certificate

Last Updated May 30, 2024

Skills you'll learn:

Power BI Calculated Columns and Measures • Data transformation • Dax • Power BI Proficiency

Prerequisites:

Data quality control • Chart types • Data analysis process

Course Lessons

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

Taught By The Best

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.

The Udacity Difference

Combine technology training for employees with industry experts, mentors, and projects, for critical thinking that pushes innovation. Our proven upskilling system goes after success—relentlessly.

Demonstrate proficiency with practical projects

Projects are based on real-world scenarios and challenges, allowing you to apply the skills you learn to practical situations, while giving you real hands-on experience.

Gain proven experience
Retain knowledge longer
Apply new skills immediately

Top-tier services to ensure learner success

Reviewers provide timely and constructive feedback on your project submissions, highlighting areas of improvement and offering practical tips to enhance your work.