The Complete Power BI Practical Course 2023

About Course

Course content FULLY UPDATED JUNE 2022!

Do you want to learn how to work with Microsoft Power BI?

Are you a beginner looking to become а proficient Power BI user?

If so, congratulations, as you have come to the right place!

This is a complete course that consists of four parts building on each other:

1. Power Query

2. Data modeling

3. DAX expressions

4. Building visually-pleasing and practical reports in Power BI

In the process, you will learn how to apply a number of best practices the course author has learned on the job while working for some of the largest companies in the world.

Everyone wants to create a beautiful dashboard. But only few people are able to do so because it isn’t an easy task.

By taking this course, you will learn how to:

Manipulate data with Power Query
Translate complex business logic into DAX expressions
Create data models inside Power BI
Understand the fundamentals of dashboard design
Build beautiful and interactive dashboards that can be presented to clients

All of this is shown step-by-step in a beginner-friendly manner.

This course is designed for students who like to learn by doing.

It contains over 15 hours of content, packed with real-life business scenarios along with quizzes and projects that allow you to apply what you have learned in practice. By completing the course you will acquire a solid understanding and will be able to jumpstart your career as Power BI developer.

We will not only teach you how to create stunning dashboards, but we will also introduce you to data modelling, data transformations, teach you how to write DAX, set up calculated columns and measures, generate roles, and of course share your dashboards with your team or clients.

Power BI allows you to connect to hundreds of data sources and quickly analyse your data for free. And, although Power BI desktop may not be available for Mac, this course will show you an easy solution that allows you to use Power BI desktop on your Mac for free for the next 12 months!

This course is suitable for complete beginners, intermediate and advanced users, as we’ll guide you every step of your journey with easy to understand explanations.

So, what are you waiting for?

Click ‘Buy now’ and start your Power BI journey today!

How to create data models inside Power BI
Get a good solid understanding of DAX
How to build beautiful and interactive dashboards that can be presented to clients
How to shape your data to meet the needs of the business
Get a full exposure of the dashboard creation and sharing process
Learn how to manipulate data using Power Query
Understand the fundamentals of dashboard design, no more boring dashboards
Students will learn how to work with Power BI independently
How to translate complex business logic into DAX expressions
Clear and easy to follow, step by step approach in each lesson
1 to 1 support using the Q&A feature
Create, style and format popular visuals such as Pie chart, Table chart, Trend line

Course Content

01 – What Does the Course Cover

001 What Does the Course Cover.mp4

00:00
002 How to Use This Course.mp4

00:00

02 – Power BI Overview

03 – Power BI Setup

04 – Course Resources

05 – Power Query

002 Importing Data.mp4

00:00
003 Data Types.mp4

00:00
004 Replacing Values.mp4

00:00
005 Merge Columns.mp4

00:00
006 Extract Values.mp4

00:00
007 Remove Duplicates.mp4

00:00
008 Remove Columns.mp4

00:00
009 Filters.mp4

00:00
010 Date Functions.mp4

00:00
011 Conditional Columns.mp4

00:00
012 Unpivot.mp4

00:00
013 Merge Queries.mp4

00:00
014 Parameters.mp4

00:00
015 Query Properties.mp4

00:00
016 Data Profiling.mp4

00:00
017 Web Scraping.mp4

00:00
018 Mathematical Functions.mp4

00:00

06 – Data Modeling

07 – DAX Expressions

001 Calculated Columns.mp4

00:00
002 Calendar Table.mp4

00:00
003 Building a Measure.mp4

00:00
004 Measures Table.mp4

00:00
005 CALCULATE.mp4

00:00
006 FILTER vs KEEPFILTERS.mp4

00:00
007 Iterators.mp4

00:00
008 RELATED vs RELATEDTABLE.mp4

00:00
009 SELECTEDVALUE.mp4

00:00
010 DIVIDE.mp4

00:00
011 Logical Operators.mp4

00:00
012 Variables.mp4

00:00
013 TREATAS.mp4

00:00
014 SWITCH.mp4

00:00
015 Text Functions.mp4

00:00
016 CONCATENATEX.mp4

00:00
017 Time Intelligence.mp4

00:00
018 Expression Based Titles.mp4

00:00
019 Tabular Editor.mp4

00:00
020 Calculation Groups.mp4

00:00

08 – Building Reports

001 Power BI Canvas.mp4

00:00
002 Drawing Shapes.mp4

00:00
003 Slicers.mp4

00:00
004 Filled Map.mp4

00:00
005 Matrix Table.mp4

00:00
006 Donut Chart.mp4

00:00
007 Interactive Tooltip.mp4

00:00
008 Gauge Visual.mp4

00:00
009 KPI Visual.mp4

00:00
010 Card Visual.mp4

00:00
011 Area Chart.mp4

00:00
012 Bookmarks.mp4

00:00
013 Format Painter.mp4

00:00
014 Stacked Column Chart.mp4

00:00

09 – 2020 Course Version

10 – Connecting to Data Sources

002 The Query Editor.mp4

00:00
003 Import vs DirectQuery.mp4

00:00
004 Importing Data from Excel Files.mp4

00:00
005 Importing Data from Excel Files – Continued.mp4

00:00
006 Data Modeling Explained & Key Concepts.mp4

00:00
007 First Data Model.mp4

00:00
008 Active vs Inactive Relationships.mp4

00:00
009 Entering Data Manually.mp4

00:00
010 Roles.mp4

00:00
011 Refreshing Data.mp4

00:00
012 Hierarchies.mp4

00:00
013 Ask a Question.mp4

00:00

11 – Practical Task Three

12 – Data Modelling

001 Introduction to Data Modelling.mp4

00:00
002 DAX.mp4

00:00
003 Calculated Columns.mp4

00:00
004 Measures.mp4

00:00
005 The Star Schema.mp4

00:00
006 The Snowflake Schema.mp4

00:00
007 Investigating the Filter Flow.mp4

00:00
008 Related vs Relatedtable.mp4

00:00
009 Bi-directional Cross-filtering.mp4

00:00
010 Calculate.mp4

00:00
011 Time Intelligence, Part 1.mp4

00:00
012 Time Intelligence, Part 2.mp4

00:00
013 All.mp4

00:00
014 Filter.mp4

00:00
015 Iterators.mp4

00:00
016 Logical operators.mp4

00:00
017 Switch.mp4

00:00
018 Text Functions.mp4

00:00
019 CONCATENATEX.mp4

00:00
020 Expression Based Titles.mp4

00:00

13 – Practical Task Four

14 – Creating Our First Data Visualization Report

001 Introduction.mp4

00:00
002 Report View.mp4

00:00
003 Slicers.mp4

00:00
004 Bar Chart.mp4

00:00
005 Bookmarks.mp4

00:00
006 Conditional Formatting.mp4

00:00
007 Field Formatting.mp4

00:00
008 Gauge Chart.mp4

00:00
009 Card Visuals Part 1.mp4

00:00
010 Card Visuals Part 2.mp4

00:00
011 Drillthrough.mp4

00:00
012 Filters.mp4

00:00
013 Map Vizuals.mp4

00:00
014 Custom Colors.mp4

00:00

15 – Practical Task Five

16 – Practical Task Six, Final Project

001 Task Six.html

00:00
002 Final Project, Part 1.mp4

00:00
003 Final Project, Part 2.mp4

00:00
004 Final Project, Part 3.mp4

00:00
005 Final Project, Part 4.mp4

00:00
006 Final Project, Part 5.mp4

00:00
007 Final Project, Part 6.mp4

00:00
008 Final Project, Part 7.mp4

00:00
009 Final Project, Part 8.mp4

00:00
010 Final Project, Part 9.mp4

00:00
011 Final Project, Part 10.mp4

00:00
012 Final Project, Part 11.mp4

00:00
013 Final Project, Part 12.mp4

00:00
014 Final Project, Part 13.mp4

00:00
015 Final Project, Part 14.mp4

00:00

17 – Bonus Lectures Power BI Service

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

01 – What Does the Course Cover

001 What Does the Course Cover.mp4

002 How to Use This Course.mp4

02 – Power BI Overview

001 Introduction to Power BI.mp4

002 Power BI Desktop vs Power BI Pro.mp4

003 Power BI Data Sources.mp4

03 – Power BI Setup

001 Power BI for MAC.mp4

002 Power BI for Mac Part 2.mp4

003 How to Install Power BI.mp4

04 – Course Resources

001 Download Course V2 Files.html

05 – Power Query

002 Importing Data.mp4

003 Data Types.mp4

004 Replacing Values.mp4

005 Merge Columns.mp4

006 Extract Values.mp4

007 Remove Duplicates.mp4

008 Remove Columns.mp4

009 Filters.mp4

010 Date Functions.mp4

011 Conditional Columns.mp4

012 Unpivot.mp4

013 Merge Queries.mp4

014 Parameters.mp4

015 Query Properties.mp4

016 Data Profiling.mp4

017 Web Scraping.mp4

018 Mathematical Functions.mp4

06 – Data Modeling

001 Data Modeling.mp4

002 Relationships.mp4

003 Role Level Security.mp4

07 – DAX Expressions

001 Calculated Columns.mp4

002 Calendar Table.mp4

003 Building a Measure.mp4

004 Measures Table.mp4

005 CALCULATE.mp4

006 FILTER vs KEEPFILTERS.mp4

007 Iterators.mp4

008 RELATED vs RELATEDTABLE.mp4

009 SELECTEDVALUE.mp4

010 DIVIDE.mp4

011 Logical Operators.mp4

012 Variables.mp4

013 TREATAS.mp4

014 SWITCH.mp4

015 Text Functions.mp4

016 CONCATENATEX.mp4

017 Time Intelligence.mp4

018 Expression Based Titles.mp4

019 Tabular Editor.mp4

020 Calculation Groups.mp4

08 – Building Reports

001 Power BI Canvas.mp4

002 Drawing Shapes.mp4

003 Slicers.mp4

004 Filled Map.mp4

005 Matrix Table.mp4

006 Donut Chart.mp4

007 Interactive Tooltip.mp4

008 Gauge Visual.mp4

009 KPI Visual.mp4

010 Card Visual.mp4

011 Area Chart.mp4

012 Bookmarks.mp4

013 Format Painter.mp4

014 Stacked Column Chart.mp4

09 – 2020 Course Version

001 Section info & Download Resources.html

10 – Connecting to Data Sources

002 The Query Editor.mp4

003 Import vs DirectQuery.mp4

004 Importing Data from Excel Files.mp4