Microsoft Power BI - A Complete Introduction [2020 EDITION]
4.5 (36,568 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
118,011 students enrolled

Microsoft Power BI - A Complete Introduction [2020 EDITION]

Learn how to use Microsoft's Power BI Tools, including Power BI Desktop, Power BI Pro (Service) and PowerBI Developer
4.5 (36,568 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
118,011 students enrolled
Last updated 7/2020
English
English, French [Auto], 5 more
  • German [Auto]
  • Indonesian [Auto]
  • Italian [Auto]
  • Portuguese [Auto]
  • Spanish [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 23.5 hours on-demand video
  • 26 articles
  • 127 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • At the end of this course students will be able to analyse data from different data sources and create their own datasets
  • Students will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together
  • Students will have the required knowledge to dive deeper into Power BI and find out more about its advanced features
Requirements
  • For the majority of the course you must have a computer with Windows as operating system
  • Basic understanding of data analysis is a plus but not required
  • For multiple modules of this course a work or school email address is required to sign up
Description

[This course was completely updated (= re-recorded) to reflect all the latest Power BI Desktop, Power BI Pro (Service) and Power BI Mobile updates that took place recently. Enjoy this 100% up-to-date course]

---

You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?

Then the Power BI tools are the tools to choose for you!

In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks - and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes. 

This is what you will learn:

  • Get to know the different tools of the Power BI universe and learn how to use them

  • Understand Power BI Desktop and its components

  • Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps

  • How to work in the different views of the Data Model

  • How to create calculated columns and measures

  • How to build relationships between different tables

  • How to create a report with different interactive visualization types

  • Learn how to use Power BI Service (= Power BI Pro) to create dashboards and to share and publish your results

  • How to access your results from multiple devices using Power BI Mobile

  • How to create custom visuals using typescript and the Power BI Developer Tools

  • And more!


This is what this course offers, but is this the right course for you?

If you...

  • ...never worked with the Power BI tools before

  • ...have a basic understanding of selected tools of the Power BI universe and want to learn how these tools work together

  • ...want to understand the latest updated version of Power BI Service, including the newly introduced App Workspaces and the creation and publishing of Apps including your dashboards, reports and datasets

  • ..want to understand the basic concepts regarding the creation of customized visuals using the Power BI Developer Tools

...then this is the right course for you.

I would be really happy to welcome you in this course!

Manuel

Who this course is for:
  • People who never worked with Power BI and who want to understand how to use these tools
  • Anyone who is interested in learning how to connect the different Power BI tools with each other
  • People who want to understand how to create customized visuals with the Power BI Developer tools
Course content
Expand all 275 lectures 23:38:46
+ Introducing Power BI Desktop
8 lectures 23:29
Module Introduction
01:36
Using the Attached Project Files
04:01
Understanding the Power BI Desktop Workflow
02:34
Exploring the Interface of the Data Model
06:05
Understanding the Query Editor Interface
04:48
Important! Creating the Project File & Recommended Settings
04:10
Course Slides 2020
00:02
Useful Resources & Links
00:12
+ Working in the Query Editor
33 lectures 02:50:53
Module Introduction
01:48
Connecting Power BI Desktop to Source Files
07:08
Keeping & Removing Rows
06:19
Working with Filters
04:18
Removing Empty Rows
05:08
Saving the Project Draft
03:23
Appending Queries
07:08
Working with Columns
05:22
Replacing Values
05:34
[Please Read]: Important Hint for the Next Lecture
00:28
Formatting Data & Handling Formatting Errors
08:09
Pivoting & Unpivoting Data
10:18
Splitting Columns
08:15
Creating Groups & Cleaning Up our Project
05:16
What we Achieved & How to Continue
01:04
Theory Time: The Star Schema
05:27
How we Use the Star Schema in our Project
02:24
Query Duplicates vs References
07:20
Creating the DIM-Region Table & Removing Duplicates
09:33
Creating Tables Manually
04:03
Theory Time: Merging Queries
05:14
Understanding "Join Kind"
04:40
Merging Queries Applied
07:24
Finishing the DIM-Region Table
10:45
The Next Steps
01:06
Creating the DIM-Age Table
06:51
Understanding "Extract"
05:38
Working with Conditional Columns
04:04
Creating the FACT-Table
04:46
Understanding Basic Mathematical Operations
02:04
Performance Optimization
06:50
Solve the tasks outlined in the above video and compare your solution to mine (solution video + attached solution project).
Time to Practice - Query Editor
1 question
Wrap Up
02:53
Useful Resources & Links
00:12
+ Understanding the Data Model: Data & Relationship View
23 lectures 01:46:02
Module Introduction
01:28
Understanding Relationships
07:55
Cardinality: Many-to-One & One-to-One
04:53
Cross Filter Direction & Many-to-Many
06:29
Understanding Active Properties
03:08
M-Language vs DAX (Data Analysis Expressions)
03:11
M vs DAX - A Practical Example
11:28
Understanding the DAX Basics
02:39
The DAX Syntax
03:30
Supported DAX Data Types
02:06
Diving Into Operators
03:51
DAX Functions - An Overview
03:25
Understanding the CALENDAR Function
10:13
Applying the DAX Basics
04:42
Understanding IF & RELATED
06:52
Calculated Columns vs Measures
01:48
Creating our First Measures
05:26
Understanding CALCULATE & FILTER
03:38
Applying CALCULATE & FILTER in Measures
08:45
Creating Measures with Measures
04:59
Understanding "Data Category"
02:09
Welcome to the second assignment. In our last assignment we loaded our prepared data into the data model. Let’s see what we can do right now.
Time to Practice - Data Model & Relationships
1 question
Wrap Up
03:15
Useful Resources & Links
00:12
+ Creating Visuals in the Report View
20 lectures 01:53:30
Module Introduction
01:13
Understanding Basic Visual Concepts
03:12
Getting Started with Visuals & Reports
07:00
Creating our First Visuals
05:48
Understanding Tooltips & Interactions
06:52
Diving Intro Hierarchies & Drill Mode
06:32
Data Colors & Conditional Formatting
06:54
Formatting Report Pages
04:34
Formatting Visuals
09:04
Working with Report Themes
10:29
Using the Slicer
08:03
Understanding Default Summarization & Sorting
04:05
Working with Treemaps & Tables
09:30
Syncing Slicers
03:22
Understanding Filter Types (Visual, Page & Report)
07:02
Working with (Multi) Row Cards
04:51
Creating Combined Visuals & Waterfalls
08:35
Using Custom Visuals
02:36
Welcome to the last assignment. Now it’s time to finally visualize the data we prepared in the last assignments.
Time to Practice - Visualizations
1 question
Wrap Up
03:36
Useful Resources & Links
00:12
+ Taking the Project to the Cloud with Power BI Pro (Service)
20 lectures 01:35:55
Module Introduction
01:02
Why we Need Power BI Pro (Service)
04:19
Power BI: Service vs Pro vs Premium
03:25
No Business Email? An Alternative
00:20
Exploring the Power BI Pro Interface
04:41
Understanding Workspaces
03:00
Connecting Power BI Pro & Power BI Desktop
03:57
Understanding Datasets in Power BI Pro
05:13
Working with Reports
05:21
Creating Dashboards
06:38
Exploring "My Workspace"
05:10
Refreshing Data with Gateways
10:23
Sharing Data From "My Workspace"
06:54
Understanding Collaboration Workspaces
08:40
Workspaces vs Apps vs Content Packs
01:40
Publishing an App
10:50
Workspace or App - Which one Should I Choose?
02:09
Working with Power BI Mobile
09:17
Wrap Up
02:40
Useful Resources & Links
00:16
+ Other Data Sources
7 lectures 28:40

Let me introduce you to this module.

Module Introduction
01:21

JSON is a popular data format which allows you to work with nested/ structured data. Learn how to import JSON files in this lecture.

Importing JSON Data
06:28
Updated Star Wars API URL
00:08

What if you want to import data directly from a RESTful API? That's of course possible with Power BI and this lecture shows how it works.

Importing Data from REST APIs
05:00

I also want to show you how to import data from a MySQL server - so let's create one!

Preparation: Setting up a MySQL Server
08:09

This lecture teaches you how to import data from a MySQL Server and also explains how to get the data from any other SQL Server.

Importing Data from a MySQL Server (and other SQL Servers)
06:38

Let me wrap this module up.

Wrap Up
00:56
+ How to Stay Up-to-Date in the Power BI World?
3 lectures 07:01
Module Introduction
00:43
Helpful Resources
05:01
Using Preview Features
01:17
+ Creating Custom Visuals (Power BI for Developers)
15 lectures 01:49:21
Module Introduction
00:44
Why Custom Visuals?
05:01
The Required Tools
03:06
Setting Up & Installing the Required Tools
11:19
Creating a New Visual
06:05
Analyzing the Project & the Code
13:02
Rendering Content to the Screen
05:42
Using d3.js & a First Shape
12:26
Getting Started with the Bars
10:07
Rendering a Chart for Dummy Data
11:59
Binding Real Data
16:24
Coloring the Bars
04:26
Adding an Axis
05:37
Package & Wrap Up
03:14
Useful Resources & Links
00:09
+ Course Round Up
1 lecture 06:36
Congratulations! What you Learned & How to Continue
06:36