Microsoft Power BI Desktop for Business Intelligence

Master Power BI Desktop for data analysis with hands-on assignments & projects from top-rated Power BI instructors

4.66 (121881 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
475,522
students
16 hours
content
Mar 2024
last update
$119.99
regular price

What you will learn

Build professional-quality business intelligence reports from the ground up

Blend and transform raw data into beautiful interactive dashboards

Design and implement the same tools used by professional analysts and data scientists

Showcase your skills with two full-scale course projects (with step-by-step solutions)

Explore powerful artificial intelligence tools and advanced visualization techniques

Learn from a #1 best-selling instructor and professional Power BI developer

Description

Welcome to the #1 best-selling Power BI Desktop course – completely rebuilt for 2023/2024!


If you’re a data professional or aspiring analyst looking to learn the top business intelligence platform on the market, you’ve come to the right place. With more than 100,000 perfect 5-star reviews from students around the world, this is the course you’ve been looking for.


Throughout the course, you’ll learn from top instructors on the Maven Analytics team and put your skills to the test with hands-on projects and unique, real-world assignments.


THE COURSE PROJECT:


You’ll play the role of Business Intelligence Analyst for AdventureWorks Cycles, a fictional manufacturing company. Your role is to transform raw data into professional-quality reports and dashboards to track KPIs, compare regional performance, analyze product-level trends, and identify high-value customers.


But don’t worry, we’ll be here to guide you along every step of the way, with intuitive, crystal clear explanations and helpful pro tips to take you from zero to expert – guaranteed.


This course is designed to follow the key stages of the business intelligence workflow, and simulate real-world tasks that data professionals encounter on the job:


STAGE 1: Connecting & Shaping Data

In this stage we’ll focus on building automated workflows to extract, transform, and load our project data using Power Query, and explore common data connectors, storage modes, profiling tools, table transformations, and more:


  • Data connectors

  • Storage & import modes

  • Query editing tools

  • Table transformations

  • Connecting to a database

  • Extracting data from the web

  • QA & Profiling tools

  • Text, numerical, date & time tools

  • Rolling calendars

  • Index & conditional columns

  • Grouping & aggregating

  • Pivoting & unpivoting

  • Merging & appending queries

  • Data source parameters

  • Importing Excel models


STAGE 2: Creating a Relational Data Model

In stage 2 we’ll review data modeling best practices, introduce topics like cardinality, normalization, filter flow and star schemas, and begin to build our AdventureWorks data model from the ground up:


  • Database normalization

  • Fact & dimension tables

  • Primary & foreign keys

  • Star & snowflake schemas

  • Active & inactive relationships

  • Relationship cardinality

  • Filter context & flow

  • Bi-directional filters

  • Model layouts

  • Data formats & categories

  • Hierarchies


STAGE 3: Adding Calculated Fields with DAX

In stage 3 we’ll introduce data analysis expressions (DAX). We’ll create calculated columns and measures, explore topics like row and filter context, and practice applying powerful tools like filter functions, iterators, and time intelligence patterns:


  • DAX vs. M

  • Calculated columns & measures

  • Implicit, explicit & quick measures

  • Measure calculation steps

  • DAX syntax & operators

  • Math & stats functions

  • Conditional & logical functions

  • The SWITCH function

  • Text functions

  • Date & time functions

  • The RELATED function

  • CALCULATE, FILTER & ALL

  • Iterator (X) functions

  • Time intelligence patterns


STAGE 4: Visualizing Data with Reports

Stage 4 is about bringing our data to LIFE with reports and dashboards. We’ll review data viz best practices, building and format basic charts, and add interactivity with bookmarks, slicer panels, parameters, tooltips, report navigation, and more:


  • Data viz best practices

  • Dashboard design framework

  • Cards & KPIs

  • Line charts, trend lines & forecasts

  • On-object formatting

  • Table & matrix visuals

  • Conditional formatting

  • Top N filtering

  • Map visuals

  • Drill up, drill down & drillthrough

  • Report slicers & interactions

  • Bookmarks & page navigation

  • Numeric & fields parameters

  • Custom tooltips

  • Importing custom visuals

  • Managing & viewing roles (RLS)

  • Mobile layouts

  • Publishing to Power BI Service


We’ll also introduce powerful artificial Intelligence tools like decomposition trees, key influencers, smart narratives and natural language Q&A, along with performance optimization techniques to keep your reports running smoothly at scale.


Ready to get started? Join today and get immediate, lifetime access to:


  • 15+ hours of high-quality video

  • 200+ page Power BI ebook

  • 25 homework assignments & solutions

  • Downloadable course project files

  • Expert Q&A support forum

  • 30-day money-back guarantee


If you’re looking for the ONE course to help you build job-ready Power BI skills, you’ve come to the right place.


Happy learning!

-Chris & Aaron (Maven Analytics)


See why this is one of the TOP-RATED Power BI courses in the world:


“I believe this is the best Power BI course out there. I spent £1400 to attend a 3-day Power BI crash course, and have to confess it’s nothing compared to the knowledge, skills, expertise and understanding derived from this course. I am forever grateful to Chris and the Maven Analytics team for doing such amazing work and to Udemy for making this available.”

-Isaac Mensah


"Resources are awesome. Presenter is brilliant. I found this course more useful than the official Power BI course from Microsoft. Things are easy to follow, and presentations are high quality."

-Jacobus M.


"Chris is a skilled communicator and does a great job of explaining a complex tool like Microsoft Power BI. His 'pro-tips' are great for new user productivity and gaining a sense of the big picture, and I value his best practices on building and managing Power BI queries and reports. I'm feeling much more confident to dig in and use Power BI on my own projects!"

-Bill Jerrow


“Simply put, this course is AMAZING! The instructor literally takes you step-by-step from knowing nothing about Power BI into nearly an expert! I have had experience working with Power BI even in a corporate setting in the past, and I was still blown away by the level of granularity Chris was able to casually explain in a way that made sense. The hands-on exercises are THE perfect way to reinforce the concepts you learn throughout the course and connect theory to application. Can't speak enough to how great this course is, I will definitely be coming back to it as a reference guide in my work and would recommend it to anyone looking to learn Power BI!”

-Ikenna Egbosimba


“I've been in university classrooms for much of my life and Chris is a university level instructor.”

-Allan Searl


Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, Tableau, Alteryx & Python!

Content

Getting Started

Course Structure & Outline
READ ME: Important Notes for New Students
DOWNLOAD: Course Resources
Introducing the Course Project
Setting Expectations

Introducing Microsoft Power BI Desktop

Introduction
Meet Microsoft Power BI Desktop
Downloading Power BI & Adjusting Settings
IMPORTANT: Regional Settings
Exploring the Power BI Desktop Interface & Workflow
Helpful Power BI Resources
QUIZ: Introducing Microsoft Power BI Desktop

Connecting & Shaping Data with Power BI Desktop

Introduction
Types of Data Connectors in Power BI Desktop
The Power BI Query Editor (aka Power Query)
Demo: Basic Table Transformations in Power BI
Power BI Demo: Working with Text Tools
Power BI Demo: Working with Numerical Values
Power BI Demo: Working with Date & Time Tools
PRO TIP: Creating a Rolling Calendar in Power BI Desktop
Power BI Demo: Generating Index & Conditional Columns
Power BI Demo: Grouping & Aggregating Records
Power BI Demo: Pivoting & Unpivoting Data
Merging Queries in Power BI Desktop
Appending Queries in Power BI Desktop
PRO TIP: Appending Files from a Folder
Configuring Power BI Data Source Settings
Configuring Power BI Query Refresh Settings
Additional Data Types & Categories in Power BI
Defining Hierarchies in Power BI Desktop
PRO TIP: Importing Models from Excel to Power BI
Power BI Data Connection Best Practices
QUIZ: Connecting & Shaping Data with Power BI Desktop
HOMEWORK: Connecting & Shaping Data with Power BI Desktop
HOMEWORK SOLUTION: Connecting & Shaping Data with Power BI Desktop

Creating Table Relationships & Data Models in Power BI

Introduction
What is a "Data Model"?
Principles of Database Normalization
Understanding Data Tables vs. Lookup Tables
Understanding Table Relationships vs. Merged Tables
Creating Table Relationships in Power BI Desktop
"Snowflake" Schemas in Power BI
Managing & Editing Table Relationships in Power BI Desktop
Managing Active vs. Inactive Relationships
Understanding Relationship Cardinality
Connecting Multiple Data Tables in Power BI Desktop
Understanding Filter Flow
Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
Hiding Fields from the Power BI Report View
UPDATE: New Power BI Desktop "Model" View
Power BI Data Model Best Practices
QUIZ: Creating Table Relationships & Data Models in Power BI
HOMEWORK: Creating Table Relationships & Data Models in Power BI
HOMEWORK SOLUTION: Creating Table Relationships & Data Models in Power BI

Analyzing Data with DAX Calculations in Power BI

Introduction
Meet Data Analysis Expressions (DAX)
Intro to DAX Calculated Columns
Intro to DAX Measures
RECAP: Calculated Columns vs. DAX Measures
Adding Columns & DAX Measures in Power BI Desktop
Implicit vs. Explicit DAX Measures
Filter Context Examples in Power BI
Step-by-Step DAX Measure Calculation
Understanding DAX Syntax & Operators
Common DAX Function Categories
DAX Demo: Basic Date & Time Functions
DAX Demo: Conditional & Logical Functions (IF/AND/OR)
DAX Demo: Common Text Functions
DAX Demo: Joining Data with RELATED
DAX Demo: Basic Math & Stats Functions
DAX Demo: COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
IMPORTANT: Order Line Items
DAX Demo: CALCULATE
DAX Demo: CALCULATE & ALL
DAX Demo: CALCULATE & FILTER
DAX Demo: Iterator Functions (SUMX, RANKX)
DAX Demo: Time Intelligence Formulas
DAX Best Practices in Power BI Desktop
QUIZ: Analyzing Data with DAX Calculations in Power BI
HOMEWORK: Analyzing Data with DAX Calculations in Power BI
HOMEWORK SOLUTION: Analyzing Data with DAX Calculations in Power BI

Visualizing Data with Power BI Reports

Introduction
Exploring the "Report" View in Power BI Desktop
Adding Simple Objects to the Power BI Report Canvas
Inserting Basic Charts & Visuals in Power BI
UPDATE: Conditional Formatting
Power BI Report Formatting Options
Power BI Report Filtering Options
Power BI Demo: Exploring Data with Matrix Visuals
Power BI Demo: Filtering with Date Slicers
Power BI Demo: Showing Key Metrics with Cards & KPI Visuals
Power BI Demo: Inserting Text Cards
Power BI Demo: Visualizing Geospatial Data with Maps
Power BI Demo: Visualizing Data with Treemaps
Power BI Demo: Showing Trends with Line & Area Charts
Power BI Demo: Adding Trend Lines & Forecasts
Power BI Demo: Goal Pacing with Gauge Charts
Editing Power BI Report Interactions
Power BI Demo: Adding Drillthrough Filters
Using Power BI Report Bookmarks
PRO TIP: Testing Scenarios with "What-If" Parameters
Managing & Viewing Roles in Power BI Desktop
PREVIEW: Custom Power BI Visuals (Log-in Required)
PREVIEW: Designing for Phone vs. Desktop Report Viewers
PREVIEW: Publishing to Power BI Service
Power BI Data Visualization Best Practices
QUIZ: Visualizing Data with Power BI Reports
HOMEWORK: Visualizing Data with Power BI Reports
HOMEWORK SOLUTION: Visualizing Data with Power BI Reports

NEW: Artificial Intelligence (AI) Visuals

Power BI Demo: Q&A Visual
Power BI Demo: Key Influencers Visual (Part 1)
Power BI Demo: Key Influencers Visual (Part 2)
IMPORTANT: Correlation vs. Causation
Power BI Demo: Decomposition Tree Visual

Wrapping Up

REFERENCE: Monthly Power BI Updates
Resources & Next Steps
More from Maven Analytics

Bonus Course Project: Maven Market

Introduction
PART 1: Connecting & Shaping the Data
PART 2: Creating the Data Model
PART 3: Adding DAX Measures
PART 4: Building the Report

Screenshots

Microsoft Power BI Desktop for Business Intelligence - Screenshot_01Microsoft Power BI Desktop for Business Intelligence - Screenshot_02Microsoft Power BI Desktop for Business Intelligence - Screenshot_03Microsoft Power BI Desktop for Business Intelligence - Screenshot_04

Reviews

Syed
November 14, 2023
Please provide desktop windows application with offline access, this will help where Internet connectivity is not available.
Olisaemeka
November 14, 2023
The course is well prepared and easy to understand. The instructors ensure ordinarily complex concepts are broken down through a simple step by step process.
Luiz
November 14, 2023
This course presented all the main tools to create a functional and simple dashboard. I already applied some of the main DAX functions and data visualization methods teached to create a model to the company I work for. Thanks a lot! It was a great time.
RJ
November 12, 2023
Good. Some restart points did not match up with where I was at when re-opening the course. Also, sometimes the speakers move too fast when going through the steps as I have to keep stopping the video and scrolling back a few seconds to a few minutes.
Suthasini
November 12, 2023
Honestly, If am doing it on a weekend while I am looking for job. This is a great course and great value. But, I study the course during my extremely packed workflow to upskill. The course got upgraded which change the learning material (data) and the content. I am not preparing to redo the whole thing. So, I just have to carry on with what I have and assume that what I learn is good. Tip: If you change the content of the course. Please leave a note and just say what I need to do by step to carry on with what they have left. Please don't expect students to go back and start from scratch unless you are expecting students to take this course and not employee. It is not going to happen and it is really frustrating.
P.
November 9, 2023
Super fijne cursus. Ik had eerder een live training gehad, maar deze vind ik zelfs nog fijner. Uitgebreid en duidelijke uitleg en rustig op eigen tempo erdoor heen met oefeningen en een fijn naslagwerk.
Chukwudi
November 9, 2023
Good course, explanations are good and the pro tips are pretty useful. Very impressive and easy to progress.
Otobong
November 9, 2023
It is great how everything is broken down for quick and easy assimilation. Even without previous Power BI experience, this course makes one enthusiastic about the learning
M
November 9, 2023
I had the old version of this course. and I'm surprised to see the totally new sessions to match the BI updates. Great efforts , thank you
Chairo
November 9, 2023
I am thrilled with my experience in this Power BI online course! As a beginner, the structured walkthroughs and real-world cases provided have been instrumental in helping me grasp the intricacies of Power BI. The instructor's demos are not only insightful but also easy to follow, allowing me to explore and apply my newfound knowledge independently. The hands-on approach has made the learning process engaging and practical. I appreciate the well-paced content that caters to beginners like myself. Highly recommended for anyone looking to dive into Power BI with confidence!
Monica
November 8, 2023
Clear, concise instructions. Easy to follow along. Teacher is not going too fast nor too slow. Voice is not monotone.
Kaushik
November 8, 2023
Expectation of the course is something i really liked as we as learners expect more than what is described in the overview very often
Srikanth
November 7, 2023
Excellent course, covers many topics. Suggesting to cover more topics and some complex model examples.
Mike
November 7, 2023
The course was surprisingly engaging, it managed to keep me interested and entertained. I would recommend it to others.
Rahib
November 7, 2023
Easy to follow along. Provides great insights into every step. Very informative for people new to Power BI.

Coupons

DateDiscountStatus
3/18/2020100% OFF
expired

Charts

Price

Microsoft Power BI Desktop for Business Intelligence - Price chart

Rating

Microsoft Power BI Desktop for Business Intelligence - Ratings chart

Enrollment distribution

Microsoft Power BI Desktop for Business Intelligence - Distribution chart
1570206
udemy ID
2/25/2018
course created date
6/9/2019
course indexed date
Bot
course submited by