Udacity Accenture logo
Log InJoin for Free

Preparing and Modeling Data with Power BI

Course

This course is a crucial step in Power BI for anyone who needs to mash together multiple data sources, clean them, restructure them, and harmonize them into a single and efficient data model to support reporting. We’ll cover Power BI’s built-in Extract-Transform-Load (ETL) tool, Power Query, learn foundational data modeling principles, cover some introductory DAX (Data Analytics Expressions), and touch on troubleshooting and optimization.

This course is a crucial step in Power BI for anyone who needs to mash together multiple data sources, clean them, restructure them, and harmonize them into a single and efficient data model to support reporting. We’ll cover Power BI’s built-in Extract-Transform-Load (ETL) tool, Power Query, learn foundational data modeling principles, cover some introductory DAX (Data Analytics Expressions), and touch on troubleshooting and optimization.

Beginner

4 weeks

Real-world Projects

Completion Certificate

Last Updated March 15, 2024

Skills you'll learn:
Data transformation • Dax • Power query • Business reporting fluency
Prerequisites:
Intermediate spreadsheet use

Course Lessons

Lesson 1

Introduction to Preparing and Modeling Data

Meet your instructor, get an overview of the course, and learn some fundamental concepts about how Power BI is used to prepare data and generate easy-to-understand visual reports.

Lesson 2

Key Concepts in Data Modeling

Learn core concepts of data modeling in Power BI, including how to make your data model more efficient by splitting it into fact tables and dimension tables.

Lesson 3

Getting Your Data & Initial Transformations

Learn how to gather your data using the Get Data feature and tidy it up using basic transformations, so that it is ready for more advance transformations and data modeling.

Lesson 4

Bigger Transformations & Date Tables

Learn different ways we can take the data we have at our fingertips and use bigger transformations to morph it into what we need for our data model and, ultimately, our reporting.

Lesson 5

Relationships and Relationship-Related DAX

This lesson is all about relationships and filters. We'll cover relationship cardinality and direction, filter direction, implicit DAX, quick measure, and custom DAX functions that rely on filters.

Lesson 6

Reports and DAX for Common Reporting Needs

Go into greater depth on reports and DAX that is specifically helpful for reporting, including how to add basic components to your report and group the data using measures and calculated columns.

Lesson 7 • Project

Create a Data Model for Seven Sages Brewing Company

Create a data model to help Seven Sages Brewing Company better understand their sales and profitability.

Taught By The Best

Photo of Lenore R Flower

Lenore R Flower

Senior Business Intelligence Specialist

Lenore is a Senior Business Intelligence Specialist with a background in finance and a passion for empowering her colleagues to make data-driven decisions—even if the information they have to work with is a little rough around the edges.

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 Preparing and Modeling Data with Power BI 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

Preparing and Modeling Data with Power BI

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.