Udacity Accenture logo
Log InJoin for Free

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.

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 July 2, 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 Power BI Workspace

In this lesson, you'll learn how to set up a Windows desktop workspace to use Power BI

Taught By The Best

Photo of Joseph Lozada

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.

  • Get help from subject matter experts

  • Learn industry best practices

  • Gain valuable insights and improve your skills

Unlock access to Data Preparation and Modeling and the rest of our best-in-class catalog

  • Unlimited access to our top-rated courses

  • Real-world projects

  • Personalized project reviews

  • Program certificates

  • Proven career outcomes

Full Catalog Access

One subscription opens up this course and our entire catalog of projects and skills.

Month-To-Month

4 Months

Average time to complete a Nanodegree program

*Discount applies to the first 4 months of membership, after which plans are converted to month-to-month.

Your subscription also includes:

Get Started Today

Data Preparation and Modeling

Month-To-Month


  • Unlimited access to our top-rated courses
  • Real-world projects
  • Personalized project reviews
  • Program certificates
  • Proven career outcomes

4 Months

Average time to complete a Nanodegree program

  • All the same great benefits in our month-to-month plan
  • Most cost-effective way to acquire a new set of skills
Discount applies to the first 4 months of membership, after which plans are converted to month-to-month.
Udacity Accenture logo

Company

  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

© 2011-2024 Udacity, Inc. "Nanodegree" is a registered trademark of Udacity. © 2011-2024 Udacity, Inc.
We use cookies and other data collection technologies to provide the best experience for our customers.