4.54 out of 5
4.54
35367 reviews on Udemy

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
Instructor:
Manuel Lorenz
113,925 students enrolled
English More
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

[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

Introduction

1
Welcome to this Course!
2
What is Power BI?
3
Join our Online Learning Community
4
First Project 1/3: Installing Power BI Desktop & Source File Connection
5
First Project 2/3: Working in the Query Editor
6
First Project 3/3: The Data View & Creating our First Visuals
7
Course Outline - What's Inside the Course?
8
How to Get the Most out of the Course
9
Useful Resources & Links

Introducing Power BI Desktop

1
Module Introduction
2
Using the Attached Project Files
3
Understanding the Power BI Desktop Workflow
4
Exploring the Interface of the Data Model
5
Understanding the Query Editor Interface
6
Important! Creating the Project File & Recommended Settings
7
Course Slides 2020
8
Useful Resources & Links

Working in the Query Editor

1
Module Introduction
2
Connecting Power BI Desktop to Source Files
3
Keeping & Removing Rows
4
Working with Filters
5
Removing Empty Rows
6
Saving the Project Draft
7
Appending Queries
8
Working with Columns
9
Replacing Values
10
[Please Read]: Important Hint for the Next Lecture
11
Formatting Data & Handling Formatting Errors
12
Pivoting & Unpivoting Data
13
Splitting Columns
14
Creating Groups & Cleaning Up our Project
15
What we Achieved & How to Continue
16
Theory Time: The Star Schema
17
How we Use the Star Schema in our Project
18
Query Duplicates vs References
19
Creating the DIM-Region Table & Removing Duplicates
20
Creating Tables Manually
21
Theory Time: Merging Queries
22
Understanding "Join Kind"
23
Merging Queries Applied
24
Finishing the DIM-Region Table
25
The Next Steps
26
Creating the DIM-Age Table
27
Understanding "Extract"
28
Working with Conditional Columns
29
Creating the FACT-Table
30
Understanding Basic Mathematical Operations
31
Performance Optimization
32
Time to Practice - Query Editor
33
Wrap Up
34
Useful Resources & Links

Understanding the Data Model: Data & Relationship View

1
Module Introduction
2
Understanding Relationships
3
Cardinality: Many-to-One & One-to-One
4
Cross Filter Direction & Many-to-Many
5
Understanding Active Properties
6
M-Language vs DAX (Data Analysis Expressions)
7
M vs DAX - A Practical Example
8
Understanding the DAX Basics
9
The DAX Syntax
10
Supported DAX Data Types
11
Diving Into Operators
12
DAX Functions - An Overview
13
Understanding the CALENDAR Function
14
Applying the DAX Basics
15
Understanding IF & RELATED
16
Calculated Columns vs Measures
17
Creating our First Measures
18
Understanding CALCULATE & FILTER
19
Applying CALCULATE & FILTER in Measures
20
Creating Measures with Measures
21
Understanding "Data Category"
22
Time to Practice - Data Model & Relationships
23
Wrap Up
24
Useful Resources & Links

Creating Visuals in the Report View

1
Module Introduction
2
Understanding Basic Visual Concepts
3
Getting Started with Visuals & Reports
4
Creating our First Visuals
5
Understanding Tooltips & Interactions
6
Diving Intro Hierarchies & Drill Mode
7
Data Colors & Conditional Formatting
8
Formatting Report Pages
9
Formatting Visuals
10
Working with Report Themes
11
Using the Slicer
12
Understanding Default Summarization & Sorting
13
Working with Treemaps & Tables
14
Syncing Slicers
15
Understanding Filter Types (Visual, Page & Report)
16
Working with (Multi) Row Cards
17
Creating Combined Visuals & Waterfalls
18
Using Custom Visuals
19
Time to Practice - Visualizations
20
Wrap Up
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
35367 Ratings

Detailed Rating

Stars 5
18803
Stars 4
13532
Stars 3
2661
Stars 2
263
Stars 1
107
711d9d8903e75599f43078a0a40f1f48

Includes

24 hours on-demand video
26 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion