Home

All courses

Microsoft Power BI - The Complete Masterclass

Business

Business Analytics & Intelligence

Microsoft Power BI

Microsoft Power BI - The Complete Masterclass

Master Power BI Desktop, Cloud & Mobile and advanced analytics with DAX (also Data Science)!

4.6

(4428)

18702 enrolled on this course

Last updated 11/2021

Nikolai Schuler

₹ 3999.0

₹ 5499.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

Do you want to learn the skills to
professionally analyze data
?
Do you want to learn all the steps to
create impressive reports
?
Then Microsoft Power BI is the right tool for you!
In this course you will learn – step by step –
everything that is important in Power BI to become an advanced Power BI report creator
.
That’s what you’ll learn:
Power BI Desktop, Power BI Cloud & Power BI Mobile!
✓ Understand everything from scratch
– step by step, very structured and practice-oriented
✓

Learn all the important tools
– know when and how to use them properly
✓ Connect different data sources
– from basics to advanced
✓

Create your data model
– and understand it
✓

Master DAX
– to do more advanced analysis on your data
✓

Get to know all the different visualizations
– and how to use them
✓

Storytelling with data
– learn how to visualize your data effectively
✓

Create interactive visualizations
– with drill throughs and drill downs
✓

Advanced analysis
– learn how to use R Script in Power BI (Data Science)
✓

Forecasting
– Advanced analytics which can be helpful in Data Science
✓

Row-Level Security
– Implement the security concept to control access to the data
This course is right for you if...
... you have never worked with Power BI and want to learn everything hands-on in one course.
... OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.
This is the course that covers everything in Power BI to become an advanced report devolopper!
Enroll now to get life long access!
Who this course is for:
Anyone that is looking for a complete and comprehensive intro to Power BI
Everyone that wants to also learn more advanced Power BI skills such as DAX for calculated columns and measures
Anyone that wants to pursue a career as a data analyst, data scientist or BI consultant
Anyone that has never used Power BI before and is looking for a hands-on approach to learn it

What you'll learn

Learn the complete workflow in Power BI from A to Z

Advanced analytics with DAX - calculated columns & measures

All-in-One: Power BI Desktop, Power BI Cloud & Power BI Mobile!

Learn how to design and implement professional reports

Learn storytelling with data to visualize your data effectively

Advanced features such as working with parameters, using R scripts, optimizing performance and

Row-Level Security

Performance optimizing

Storytelling with data

Python & R in Power BI

Forecasting & advanced analytics

Time intelligence

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Welcome!

1.2-What is Power BI?

1.3-Download & Installing Power BI Desktop

1.4-Getting to know the interface

1.5-Quick Interface Tour

1.6-Mini Project: Transform Data

1.7-Mini Project: Visualize Data

1.8-Mini Project: Creating a Data Model

1.9-Course Outline: What will you learn in this course?

1.10-How to lean best with this course?

1.11-All source files & course slides

2-Preparing our Project

2.1-Creating our initial project file

2.2-Working with the attached project files

3-Data Transformation - The Query Editor

3.1-Exploring the Query Editor

3.2-Connecting to our data source

3.3-Editing rows

3.4-Changing data types

3.5-Replacing values

3.6-Close & Apply

3.7-Connecting to a csv file

3.8-Connecting to a web page

3.9-Extracing characters

3.10-Splitting & merging columns

3.11-Creating conditional columns

3.12-A little note regarding the next lecture

3.13-Creating columns from examples

3.14-Merging Queries

3.15-Pivoting & Unpivoting

3.16-Appending Queries

3.17-Practice & Solution: Population table

3.18-The Fact-Dimension-Model

3.19-Practice: Load the dimension table

3.20-Organizing our queries in groups

3.21-Text to be used in the next lecture

3.22-Entering data manually

3.23-Creating an index column

3.24-Workflow & more transformations

3.25-Module summary

3.26-Exercise 1

4-Data Transformation - Advanced

4.1-Advanced Editor - Best practices

4.2-Performance: References vs. Duplicating

4.3-Performance: Enable / Disable Load & Report Refresh

4.4-Group by

4.5-Mathematical Operations

4.6-Run R Script

4.7-Using Parameters to dynamically transform data

4.8-M formula language: Basics

4.9-M formula language: Values, Lists & Tables

4.10-M formula language: Functions

4.11-M formula language: More functions & steps

4.12-Exercise 2

5-Creating a Data Model

5.1-Why a data model?

5.2-Create & edit relationships

5.3-One-to-many & one-to-one relationship

5.4-Many-to-many (m:n) relationship

5.5-Cross filter direction

5.6-Activate & deactivate relationships

5.7-Module summary

5.8-Exercise 3

6-Data Visualization

6.1-Our first visual

6.2-The format tab

6.3-Understanding tables

6.4-Conditional formatting

6.5-The Pie Chart

6.6-All about the filter visual

6.7-The filter pane for developers

6.8-Cross filtering & edit interactions

6.9-Exercise 4

6.10-Syncing slicers across pages

6.11-Creating drill downs

6.12-Creating drill throughs

6.13-The tree map visual

6.14-The decomposition tree

6.15-Understanding the matrix visual

6.16-Editing pages

6.17-Buttons & Actions

6.18-Bookmarks to customize your report

6.19-Analytics and Forecasts with line charts

6.20-Working with custom visuals

6.21-R Script to use

6.22-Get data using R Script & R Script visual

6.23-Asking questions - Q&A visual

6.24-Wrap up - data visualization

7-Power BI & Python

7.1-Python in Power BI - Plan of attack

7.2-Setting up Python for Power BI

7.3-Transforming data using Python

7.4-Python script I used in the next lecture

7.5-Creating visualizations using Python

7.6-Python script II used in the next lecture

7.7-Violin plots, pair plots & ridge plots using Python

7.8-Python script III used in the next lecture

7.9-Machine learning (BayesTextAnalyzer) using Python

7.10-Performance & Troubleshooting

8-DAX - The Essentials

8.1-Intro

8.2-The project data

8.3-DAX cheat sheet

8.4-All files for the DAX part

8.5-Measures vs. Calculated Columns

8.6-Automatically creating a date table in DAX

8.7-CALENDAR

8.8-Creating a complete date table with features

8.9-Script to be used in your future projects

8.10-Creating key measure table

8.11-Aggregation functions

8.12-The different versions of COUNT

8.13-SUMX - Row based calculations

8.14-DAX Exercise 1

8.15-DAX Solution 1

9-DAX - The CALCULATE function

9.1-CALCULATE - The basics

9.2-Changing the context with FILTER

9.3-ALL

9.4-ALLSELECTED

9.5-ALLEXCEPT

9.6-DAX Exercise 2

9.7-DAX Solution 2

10-DAX - Time Intelligence

10.1-Time Intelligence intro & DATEADD

10.2-Year-to-Date & Month-to-Date

10.3-TOTALYTD vs. DATESYTD

10.4-DATESBETWEEN

11-DAX - Advanced topics

11.1-Logical operators

11.2-Formatting & Commenting

11.3-Using Variables

11.4-Using quick measures in a smart way

12-Tell a story with your data - learn to visualize effectively

12.1-Intro - Best practices

12.2-Show empathy & indentify the requirements

12.3-Find the most suitable KPIs

12.4-Choose an effective visual

12.5-Make use of natural reading pattern

12.6-Tell a story using visual cues

12.7-Avoid chaos & group information

12.8-Wrap up - storytelling with data

13-Power BI Service - Power BI Cloud

13.1-How to go on now?

13.2-Power BI Pro vs Premium & Signing up

13.3-An alternative if you don't have a business email

13.4-Exploring the interface

13.5-Discovering your workspace

13.6-Little note on the next lecture - Uploading your report

13.7-Connecting Power BI Desktop & Cloud

13.8-Understanding datasets & reports

13.9-Working on reports

13.10-Updating reports from Power BI Desktop

13.11-Creating and working with workspaces

13.12-Installing & using a data gateway

13.13-Get Quick Insights

13.14-Creating dashboards

13.15-Sharing our results through Apps

13.16-Power BI Mobile App

13.17-Creating the layout for the Mobile App

13.18-Wrap up - Power BI Cloud

14-Row-Level Security

14.1-Intro

14.2-Creating a Row-Level Security

14.3-Row-Level Security in the Cloud

14.4-Row-Level Security & Data Model

14.5-Dynamic Row-Level Security

14.6-Dynamic Many-to-Many RLS

14.7-Hierarchical Row-Level Security

15-More data sources

15.1-JSON & REST API

15.2-Setting up a local MySQL database

15.3-Connecting to a MySQL database in Power BI

15.4-Connecting to a SQL database (PostgreSQL)

16-Next steps to improve & stay up to date

16.1-Congratulations & next steps

16.2-More data to practiсe

17-Bonus

17.1-Bonus lecture

Course Categories

Popular Courses

Microsoft Power BI - The Complete Masterclass

Description

What you'll learn

Requirements

Course Content

You May Like