Don't want to get left behind? Learn to build with A.I. now 🤖
Back to courses

Power BI Bootcamp: Zero to Mastery

This Power BI Bootcamp will take you from absolute beginner in Power BI to being able to get hired in 2024 as a confident and effective Business Intelligence Analyst. You'll learn the full Power BI suite of tools, the M programming language, and the DAX formula language, all while analyzing real-world datasets and building enterprise-level projects.

25 Days

Average time students take to complete this course.

instructor
Taught by: Travis Cuzick
Last updated: April 2024

Course overview

We guarantee you that this is the best and most up-to-date Power BI Bootcamp or course that you can find. You'll not only learn Power BI basics and fundamentals that most courses cover. You'll also learn advanced topics, tools, and tricks to turn you into a top 10% Business Intelligence Analyst!

What you'll learn

  • Become a top 10% Business Intelligence Analyst to enhance your skill set and career opportunities
  • Analyze real-world datasets on fun subjects including Bigfoot and UFO sightings
  • Build both guided and independent Power BI projects so that you can put your Power BI skills into practice and deeply understand the material
  • Learn Power Query's built-in graphical tools to fetch data from a variety of external sources, clean and transform it, and load it into Power BI
  • Master the art and science of Power BI Data Modeling
  • Leverage the M programming language to apply and edit advanced transformations that go beyond the functionality built into the Power Query interface
  • How to create and customize Power BI's most useful visualizations
  • How to determine which visualizations are most appropriate for a given data analysis problem
  • Construct a Data Model consisting of multiple distinct datasets, by identifying and establishing appropriate relationships between these datasets
  • Create sophisticated metrics (KPIs) with the Power BI DAX programming language
  • Make DAX code more readable and maintainable using whitespace, comments, and variables, plus using measure tables to organize your measures
  • Learn why Power BI is the premier analysis & visualization tool

What is Power BI and why learn it?

Business Intelligence, commonly referred to as "BI", is one of the fastest growing and most in-demand fields in technology.

BI is a broad term that encompasses data mining, data analysis, performance benchmarking using KPIs (Key Performance Indicators), and descriptive analytics.

Power BI is the industry-leading complete Business Intelligence solution (“BI in a box”) from Microsoft. It's the go-to tool used in the real world.

Why? Because it combines capabilities for:

  • Fetching and transforming data from a wide variety of sources, everything from text files to spreadsheets to relational databases
  • Modeling that data by forming relationships between different data sources
  • Creating powerful calculations and KPIs using Power BI DAX (Data Analysis Expressions), the built-in formula language
  • Translating those KPIs into actionable intelligence using a wide range of fancy visualizations
  • Power BI’s components and their functionality, by design, align with a typical BI workflow

And its extensive suite of tools, including Power BI reports, visualizations and dashboards, can translate the results of any data analysis into visually compelling and meaningful presentations that will blow your audience away.

I'm intrigued... So why this Power BI Bootcamp?

There are many reasons but we'll stick to 3 key reasons.

First... we're guessing you're a busy person who values your time? (If not, what planet do you come from...)

If that does sound like you then you're in the right place because this bootcamp course is focused on efficiency (followed closely by having fun). We teach you everything you need to know and don't waste your time on things you don't.

The result? You never have to waste your time on confusing, out-of-date, incomplete Power BI tutorials ever again.

Instead, you'll learn everything from the Power BI fundamentals and best practices to using the most advanced features Power BI has to offer like:

  • Advanced Power Query
  • Power BI Dashboards for visualization
  • The DAX programming language
  • ... and more...

All in one course.

Second... Learning alone can be hard. We've been in your shoes. Thankfully, you don't have to learn alone.

By enrolling today, you’ll also get to join our exclusive live online community classroom to learn Power BI alongside thousands of students who are in your shoes while be supported by ZTM alumni, mentors, TAs and Instructors.

Third... You'll be learning from someone who has actually "walked the walk".

Your instructor Travis is an industry expert that has actual real-world experience using Power BI and working as a Data Solutions Engineer on massive datasets for some of the largest companies.

Still with us? Then buckle up because here is everything you'll learn in this Power BI Bootcamp to take you from Zero to Mastery:

The curriculum is presented in basic building blocks so that you can build your knowledge step-by-step.

No matter what your level, it's key to make sure you have a solid understanding of the fundamentals. So we cover those first.

But once you have those down, the fun really begins as we quickly ramp up to actually using the skills you're learning and covering advanced topics most courses don't cover.

Here's a section by section breakdown:

1. POWER BI 101

Whether you're an experienced Analyst or a complete beginner, you'll be provided with a strong foundation of Business Intelligence skills including Power BI basics and best practices.

But the most important part of learning is doing. That's why we get you using your new skills in this very first section where you'll start building two dashboards using real-world datasets.

  1. [Guided] a Power BI dashboard visualizing Bigfoot sightings in the US (this is serious business) which we'll tackle together
  2. [Independent] a Power BI dashboard visualizing UFO sightings (the conspiracy theory theme is purely coincidence) which you'll continue to evolve throughout the course

You’ll learn to fetch and transform data with Power Query, crunch out basic metrics and KPIs, and create visualizations to analyze the performance of those metrics and KPIs.

We'll keep diving deeper into these topics throughout the course. But after completing just this one section, you'll already know enough to be dangerous with Power BI (aka... you could start using it in your day-to-day).

2. VISUALIZING DATA WITH POWER BI

Next you'll learn about (and start using) the most useful Power BI visualizations, as you continue to work through and expand on both the Bigfoot sightings project and UFO sightings project.

You'll not only learn how to create and configure these visualizations in Power BI, but also when certain visualizations are more appropriate than others and why.

Understanding the why is probably the most important piece of information this course will teach you!

3. ADVANCED POWER QUERY IN POWER BI

While the basics of Power Query are covered in Power BI 101, this section will cover techniques for exploratory data analysis.

You'll also start learning the M programming language that underlies all Power Query transformations.

You'll even learn to create and edit advanced transformations which are beyond the scope of what can be accomplished with Power Query’s built-in graphical tools.

This section is where you'll start working on our two enterprise-level course projects:

  1. [Guided] A Business Intelligence solution for a restaurant chain
  2. [Independent] A Business Intelligence solution for a meal kit delivery service

These are the type of projects that will give you the confidence to become a top 10% Power BI user and make your portfolio stand out if you're looking to apply for BI Analyst roles.

4. POWER BI DATA MODELING

Data modeling in Power BI allows you to define relationships between separate data sources so that they can be combined in the same visualizations.

You'll learn both theory and best practices for modeling these relationships, while also working through the practical implementation of a working data model in Power BI.

You’ll have the opportunity to work through one complete data model as you follow along with the course lectures, and another as you continue with your second independent course project.

5. ANALYZING DATA WITH DAX PROGRAMMING LANGUAGE IN POWER BI

This is where you'll learn perhaps the most powerful component of Power BI: the DAX programming language (also known as the DAX formula language).

What is DAX in Power BI? Dare we describe it as spreadsheet formulas on steroids.

You'll start by creating derived columns in your data model based on complex logic, and then progress to defining portable metrics/KPIs that can be incorporated into visualizations.

Throughout the section, you'll learn the important foundational concepts necessary to really understand how these measures are being calculated in your visualizations. That way you're always able to interpret and explain the numbers you present.

Travis (your instructor) tells us that the DAX language is his personal favorite skill you'll learn in this course.

It provides practically unlimited options for defining sophisticated metrics and KPIs, which can then be smoothly incorporated into visualizations.

6. ADVANCED DAX PROGRAMMING LANGUAGE IN POWER BI

We're putting our money where our mouth is. We believe DAX is so important and powerful that we included this section to make sure you become a DAX master.

You'll explore advanced applications of the DAX programming language, including:

  • Time intelligence (for example, period-over-period comparisons, rolling averages, etc.)
  • Calculating rankings or top-N calculations within visualizations
  • Refactoring and optimizing your DAX code with more traditional programming techniques like comments and variables

You aren't going to find these advanced topics in most Power BI courses.

7. ADVANCED DATA VISUALIZATIONS & POWER BI DASHBOARDS

This is where everything comes together.

You'll get to combine all of the previous concepts you've learned, along with some new, advanced techniques, by creating a dynamic, user-driven dashboard.

A Power BI dashboard is one of the most powerful and persuasive tools available to you. Use these powers wisely!

You'll learn dashboard visualizations such as Gauges and KPI Cards as well as methods for giving users control over what they see on the report like:

  • Bookmarks
  • What-if parameters
  • Drill-through functionality
  • Widgets for selecting which metric is displayed in a visualization

What's the bottom line?

This course is not about making you just watch along so that when you are done with the course you don’t know what to do other than watch another tutorial... No!

This course will push you and challenge you to go from an absolute beginner in Business Intelligence and turn you into a confident Business Intelligence Analyst using Power BI 💪.

How do we know?

Because we've helped thousands of students gain the skills they needed to get hired at companies like Google, Tesla, Amazon, Apple, IBM, JP Morgan, Facebook, Shopify + other top companies.

They come from all different backgrounds, ages, and experiences. Many even started as complete beginners.

We strongly believe there's no reason it can't be you too.

And you have nothing to lose. Because you can start learning right now and if this course and the Zero To Mastery learning experience isn't everything you expected, we'll refund you 100% within 30 days. No hassles and no questions asked.

When's the best time to get started? Today!

There's never a bad time to learn in-demand skills. But the sooner, the better. So start learning Power BI today by joining the ZTM Academy. You'll have a clear roadmap to developing the skills to build your own projects, get hired, and advance your career.

Join Zero To Mastery Now

What you'll build

The best way you learn is by doing. Not just watching endless tutorials. That's why a key part of this course is the exercises you'll complete using real-world datasets and the massive enterprise-level project that you'll get to build. Plus it'll look great on your portfolio.

Bigfoot Sightings Dashboard Visualization

Bigfoot Sightings Dashboard Visualization

You'll build a dashboard that visualizes data on Bigfoot sightings across the United States. Can you find a pattern...?

UFO Sightings Dashboard Visualization

UFO Sightings Dashboard Visualization

You'll practice creating compelling dashboard visualizations by using real-world data on UFO sightings.

Southern Prefecture Restaurant: Build BI Solutions for a Restaurant Chain

Southern Prefecture Restaurant: Build BI Solutions for a Restaurant Chain

You'll build a fully dynamic BI solution for a restaurant chain featuring a complex data model and dozens of KPIs, plus a dynamic interface that allows users to adjust what-if parameters, specify which KPIs are to be displayed in a visualization, and more.

Oodles of Noodles: Build BI Solutions for a Meal Kit Delivery Service

Oodles of Noodles: Build BI Solutions for a Meal Kit Delivery Service

Your skills will culminate in this independent project where you'll build a fully dynamic, detailed BI solution for a meal kit delivery service. This project will push you and put your skills to the test!

Join Zero To Mastery Now

Course curriculum

To make sure this course is a good fit for you, you can start learning Power BI for free right now by clicking any of the PREVIEW links below.

Introduction

5 lectures

Power BI Bootcamp: Zero to Mastery2:38

PREVIEW

Exercise: Meet Your Classmates and Instructor

PREVIEW

Understanding Your Video Player (notes, video speed, subtitles + more)

PREVIEW

Course Resources

PREVIEW

Set Your Learning Streak Goal

PREVIEW

Section 1: Power BI 101

31 lectures

Introducing Power BI7:16

PREVIEW

Navigating the Power BI Interface4:51

PREVIEW

Installing and Configuring Power BI4:42

PREVIEW

ETL with Power BI9:37

PREVIEW

Fetching Data from Databases7:33

PREVIEW

Introducing Power Query9:37

PREVIEW

Applying Basic Transformations7:59

PREVIEW

Editing Transformations10:57

PREVIEW

Introducing the UFO Sightings Project1:13

PREVIEW

Exercise: UFO Sightings Project - Part 1

PREVIEW

Solution: UFO Sightings Project - Part I6:02

PREVIEW

Numeric Transformations12:29

PREVIEW

Date Transformations3:30

PREVIEW

Text Transformations15:15

PREVIEW

Conditional Transformations13:31

PREVIEW

Exercise: UFO Sightings Project - Part 2

PREVIEW

Solution: UFO Sightings Project - Part 211:38

PREVIEW

Introducing Matrix Visualizations15:37

PREVIEW

Adding Layers to Matrix Visualizations11:07

PREVIEW

Navigating Matrix Visualizations5:31

PREVIEW

Formatting Visualizations8:29

PREVIEW

Data Bars6:06

PREVIEW

Conditional Formatting Rules9:53

PREVIEW

Exercise: UFO Sightings Project - Part 3

PREVIEW

Solution: UFO Sightings Project - Part 312:46

PREVIEW

Introducing Measures4:45

PREVIEW

Creating Your First Measure10:30

BEGIN

Customizing Measures9:33

BEGIN

Exercise: UFO Sightings Project - Part 4

BEGIN

Solution: UFO Sightings Project - Part 47:12

BEGIN

Let's Have Some Fun (+ Free Resources)

BEGIN

Section 2: Visualizing Data with Power BI

23 lectures

Column Charts9:35

BEGIN

Column Chart Variations5:04

BEGIN

Bar Charts8:05

BEGIN

Line and Area Charts7:22

BEGIN

Combo Charts13:14

BEGIN

Visualizing Proportionality11:00

BEGIN

Exercise: UFO Sightings Project - Part 5

BEGIN

Solution: UFO Sightings Project - Part 57:46

BEGIN

Unlimited Updates

BEGIN

Customizing Chart Interactions11:08

BEGIN

Customizing Chart Formatting11:02

BEGIN

Map Charts11:19

BEGIN

Building Dashboards13:47

BEGIN

Formatting the Report Environment.6:17

BEGIN

Exercise: UFO Sightings Project - Part 6

BEGIN

Solution: UFO Sightings Project - Part 612:31

BEGIN

Filtering Individual Visualizations11:18

BEGIN

Filtering Multiple Visualizations11:29

BEGIN

Slicers8:18

BEGIN

Date Slicers 6:28

BEGIN

Exercise: UFO Sightings Project - Part 7

BEGIN

Solution: UFO Sightings Project - Part 710:04

BEGIN

Course Check-In

BEGIN

Section 3: Advanced Power Query

16 lectures

Previewing Data11:57

BEGIN

Configuring Refresh Options4:33

BEGIN

Merging Datasets15:10

BEGIN

Appending Datasets6:28

BEGIN

Aggregate Calculations13:00

BEGIN

Introducing Oodles of Noodles (Meal Kit Delivery Service Project)1:25

BEGIN

Exercise: Meal Kit Delivery Service Project - Part 1

BEGIN

Solution: Meal Kit Delivery Service Project - Part 110:29

BEGIN

Introducing the M Language11:16

BEGIN

M Behind the Scenes4:33

BEGIN

Creating Custom Columns with M11:59

BEGIN

Creating Custom Filters with M7:23

BEGIN

Using M Functions (Build a Calendar Table)10:57

BEGIN

Exercise: Meal Kit Delivery Service Project - Part 2

BEGIN

Solution: Meal Kit Delivery Service Project - Part 213:10

BEGIN

Implement a New Life System

BEGIN

Section 4: Modeling Data in Power BI

13 lectures

Introducing the Model View12:44

BEGIN

Understanding Relationships10:46

BEGIN

Relationships in Power BI - Part 19:57

BEGIN

Relationships in Power BI - Part 210:00

BEGIN

Using Related Data in Visuals8:30

BEGIN

Exploring Filter Context11:08

BEGIN

Calendar Tables11:00

BEGIN

Data Modeling Pitfalls9:47

BEGIN

Multiple Data Tables8:24

BEGIN

Two-Way Relationships14:09

BEGIN

Exercise: Meal Kit Delivery Service Project - Part 3

BEGIN

Solution: Meal Kit Delivery Service Project - Part 38:34

BEGIN

Exercise: Imposter Syndrome2:55

BEGIN

Section 5: Analyzing Data with DAX

13 lectures

Calculated Columns with DAX14:03

BEGIN

The IF Function5:26

BEGIN

SWITCH 1017:53

BEGIN

SWITCH 20110:59

BEGIN

The RELATED Function11:32

BEGIN

Exercise: Meal Kit Delivery Service Project - Part 4

BEGIN

Solution: Meal Kit Delivery Service Project - Part 4

BEGIN

Using DAX Functions in Measures15:33

BEGIN

The CALCULATE Function12:02

BEGIN

Going Deeper with CALCULATE9:31

BEGIN

The ALL Function14:14

BEGIN

Exercise: Meal Kit Delivery Service Project - Part 5

BEGIN

Solution: Meal Kit Delivery Service Project - Part 5

BEGIN

Section 6: Advanced DAX

15 lectures

Introducing Time Intelligence Functions14:37

BEGIN

The ISBLANK Function5:05

BEGIN

The DATEADD Function14:40

BEGIN

The DATESINPERIOD Function17:40

BEGIN

Solution: Meal Kit Delivery Service Project - Part 6

BEGIN

Exercise: Meal Kit Delivery Service Project - Part 6

BEGIN

Formatting and Commenting Code12:20

BEGIN

Variables12:06

BEGIN

The X Functions13:17

BEGIN

The RANKX Function7:25

BEGIN

The TOPN Function11:35

BEGIN

Creating a Measure Table13:52

BEGIN

Data Modeling and Analysis Best Practices8:06

BEGIN

Exercise: Meal Kit Delivery Service Project - Part 7

BEGIN

Solution: Meal Kit Delivery Service Project - Part 7

BEGIN

Section 7: Advanced Visualizations

13 lectures

Card Visuals10:13

BEGIN

Single-Value Cards6:19

BEGIN

KPI Cards7:48

BEGIN

Gauge Charts15:58

BEGIN

Analyzing Time Series Data12:15

BEGIN

Changing Measures Dynamically14:08

BEGIN

What-If Parameters14:58

BEGIN

Bookmarks10:58

BEGIN

Drillthrough11:13

BEGIN

Mobile View6:53

BEGIN

Exercise: Meal Kit Delivery Service Project - Part 8

BEGIN

Solution #1: Meal Kit Subscription Service Project - Part 813:16

BEGIN

Solution #2: Meal Kit Subscription Service Project - Part 89:50

BEGIN

Where To Go From Here?

6 lectures

Thank You!1:17

BEGIN

Review This Course!

BEGIN

Become An Alumni

BEGIN

Learning Guideline

BEGIN

LinkedIn Endorsements

BEGIN

Coding Challenges

BEGIN

Meet your instructor

Your Power BI instructor (Travis) isn't just an expert with years of real-world professional experience. He has been in your shoes. He makes learning fun. He makes complex topics feel simple. He will motivate you. He will push you. And he will go above and beyond to help you succeed.

Travis Cuzick

Hi, I'm Travis Cuzick!

Travis has been architecting and coding data solutions for well over a decade and for some of the biggest companies on the Fortune 500. Travis aims to make the learning process as efficient, intuitive, and fun (yes, fun!) for his students as possible.

SEE MY BIO & COURSES

Travis Cuzick

Data Solutions Engineer

Frequently asked questions

Are there any prerequisites for this course?

  • No prior knowledge required!
  • The Windows operating system is required (Power BI only works on Windows).
  • Some experience working with spreadsheets is helpful but not required. If you'd like to gain this knowledge before starting this Power BI Bootcamp then you can start with Travis' Excel Bootcamp (included with your ZTM Academy membership).

Who is this course for?

  • Both beginner and advanced data professionals looking to learn Power BI to improve their data analysis and visualization skills
  • Students who are interested in going beyond all of the "beginner" Power BI tutorials and courses out there
  • Data Analysts and Data Scientists looking for a powerful yet easy-to-use alternative to Python/R for transforming data and creating compelling visualizations
  • Business Intelligence Analysts, Data Scientists, Developers, Business Analysts, Product Managers, Sales/Marketers, and anyone who uses data to make business decisions
  • Anyone who wants to work in the fields of business intelligence, data analysis, and/or data science
  • Programmers who want to accelerate their career by adding data analysis and visualization skills to their toolkit
  • Decision makers, in business or elsewhere, looking for a straightforward solution to make sense of their data

Do you provide a certificate of completion?

We definitely do and they are quite nice. You will also be able to add Zero To Mastery Academy to the education section of your LinkedIn profile as well.

Can I use the course projects in my portfolio?

Yes, you’d be crazy not to in our slightly biased opinion! All projects are downloadable and ready to use the minute you join.

Many of our students tell us the projects they built while following along with our courses were what got them interviews and because they built the projects themselves, they could confidently explain and walk through their work during the interview.

You know what that means? Job offer!

Are there subtitles?

Yes! We have high quality subtitles in 11 different languages: English, Spanish, French, German, Dutch, Romanian, Arabic, Hindi, Portuguese, Indonesian, and Japanese.

You can even adjust the text size, color, background and more so that the subtitles are perfect just for you!

Still have more questions about the Academy?

Still have more questions specific to the Academy membership? No problem, we answer some more here.

Invest in a better you. For less than a coffee a day.

Choose your currency:
$ USD US Dollar
Lifetime
100% OFF$999
$999
Only pay once, ever
You're serious about advancing your career and never getting left behind
Start Learning Now

MOST POPULAR

Save 40% vs. monthly (that's $189 a year)
Annual
100% OFF$279 / year
$23 / month
$279 / year
You're committed to getting hired and starting a career in tech
Start Learning Now
Monthly
100% OFF$39 / month
$39 / month
You're ready to upskill and advance your career
Start Learning Now

Every ZTM membership includes:

Unlimited access to all courses, projects + workshops, and career paths
Access to our private Discord with 400,000+ members
Access to our private LinkedIn networking group
Custom ZTM course completion certificates
Live career advice sessions with mentors, every month
Full access to all future courses, content, and features
100% RISK FREE

We know you'll love ZTM. That's why we provide a no hassle, 30-day money back guarantee.