Microsoft Power BI: The Complete Guide

Focused View

Malvik Vaghadia,Pathfinder Analytics

6:54:20

0 View

01 - Introduction and Set Up

001 Course Introduction.mp4

02:44

002 Power BI Ecosystem.mp4

01:34

003 Power BI Desktop Installation.mp4

04:03

004 Power BI Desktop Interface Overview.mp4

10:54

005 Course Project and Dataset Download (IMPORTANT).mp4

06:47

external-links.txt

02 - Part 1 Loading and Transforming Data

001 Part 1 Section Overview.mp4

00:54

002 Entering Data Manually.mp4

02:55

003 Saving Your Work.mp4

01:11

004 Loading the Races CSV Data.mp4

02:54

005 Removing Rows and Columns.mp4

04:55

006 Data Types.mp4

08:01

007 Working with Columns.mp4

03:08

008 Splitting Extracting Information from Columns.mp4

08:29

009 Simple Mathematical Operations.mp4

03:11

010 Duplicate, Index and Conditional Columns.mp4

06:09

011 Refreshing the Source Data.mp4

04:31

012 Sorting your Data.mp4

01:58

013 Filtering Values.mp4

02:12

014 Logically Ordering your Applied Steps.mp4

04:31

015 Replacing Values.mp4

02:01

016 Duplicate vs Reference.mp4

01:53

017 Appending Queries.mp4

06:22

018 Removing Duplicates.mp4

02:25

019 Transpose, Reverse Rows and Count Rows.mp4

02:46

020 Loading the Circuits JSON File & Assignment.mp4

05:39

021 Loading the Drivers Text File & Assignment.mp4

06:31

022 Loading the Constructors CSV File & Assignment.mp4

02:35

023 Loading the Results CSV File & Assignments.mp4

06:46

024 Group By.mp4

06:36

025 Pivoting and Unpivoting.mp4

04:45

026 Download the Part 1 Power BI Report.mp4

00:41

external-links.txt

03 - Part 2 Data Modelling

001 Part 2 Section Overview.mp4

00:45

002 Linking Tables via Relationships.mp4

13:44

003 One to Many Cardinality and Cross Filter Direction.mp4

07:32

004 Many to Many Cardinality.mp4

06:14

005 One to One Cardinality.mp4

02:52

006 Creating the Relationships for our Data Model (Assignment).mp4

07:02

007 Autodetect and Active Relationships.mp4

02:55

008 Data Modelling Approaches - STAR and SNOWFLAKE.mp4

04:56

009 Merging Tables - Join Types.mp4

04:27

010 Merging Tables Demonstration.mp4

07:06

011 Download the Part 2 Power BI Report.mp4

00:16

04 - Part 3 Visualizations in Power BI

001 Part 3 Section Overview.mp4

00:26

002 Visualization and Report Basics.mp4

10:16

003 Table and Matrix Visuals.mp4

12:07

004 Bar and Column Charts.mp4

08:08

005 Quick Note on Legends.mp4

03:09

006 Interactions.mp4

08:24

007 Drilldowns and Hierarchies.mp4

06:10

008 The Filter Pane.mp4

05:27

009 Small Multiples.mp4

01:22

010 Line and Area Charts.mp4

08:07

011 Combo Charts and Cross Filter Direction Revisited.mp4

04:56

012 Scatter Charts.mp4

04:24

013 Treemaps.mp4

02:34

014 Cards.mp4

02:42

015 Data Categories and Maps.mp4

06:04

016 Tooltips.mp4

04:51

017 Visual Elements.mp4

02:43

018 Additional Visualizations.mp4

04:00

019 Best Practice Tips and Formula One Report Requirements.mp4

06:47

020 Creating the Formula One Report Part 1.mp4

25:02

021 Creating the Formula One Report Part 2.mp4

17:54

022 Download the Part 3 Power BI Report.mp4

00:16

05 - Part 4 Power BI Online

001 Part 4 Section Overview.mp4

00:38

002 Power BI Online Overview.mp4

02:26

003 Power BI Pro Interface Tour.mp4

05:44

004 Publishing Reports to Power BI Pro.mp4

08:41

005 Dashboards.mp4

04:09

006 Refreshing Data.mp4

06:02

007 Collaboration Workspaces.mp4

07:16

06 - Part 5 Introduction to DAX (Data Analysis Expressions)

001 Part 5 Section Overview - Languages in Power BI.mp4

06:48

002 DAX Overview.mp4

07:02

003 Aggregation Functions.mp4

09:33

004 Filter Functions.mp4

07:12

005 Other Functions.mp4

03:57

006 Assignment Questions.mp4

10:55

007 Download the Part 5 Power BI Report.mp4

00:18

07 - Congratulations

001 Congratulations.html

Description

A comprehensive guide on how to master Power BI Desktop and Power BI Online. Featuring a Formula One course project.

What You'll Learn?

Develop a business intelligence solution end to end
Create interactive and visually rich Reports
Understand how Power BI Service enables collaboration
Work with a range of data sources and become an expert at Loading and Transforming data from multiple sources
Understand Data Modelling in Power BI
Understand Reporting Best Practice
Create multiple visualizations
How to master Power BI for your real world projects!

Who is this for?

Anyone looking to learn Power BI with a project based approach

Anyone interested in building a business intelligence solution end to end

Anyone looking to pursue a career in data analysis or business intelligence

What You Need to Know?

Windows Operating System

Some experience of Excel is a plus (but not essential)

More details

Description
Learn one of the most in demand business intelligence tools around and master the most important concepts in the Power BI Ecosystem.
This course is hands-on and you will LEARN BY DOING!

COURSE PROJECT
We will be using a Formula One Dataset to create an interactive report with some amazing visualizations.
Connect to various data sources including csv, excel, JSON and more.
Perform extensive data transformations to make our data ready for reporting.
Use relationships and data modelling methodologies to create an effective data model.
Explore all kinds of visualisations from Column Charts, Scatter Charts, Maps, Tooltips and more.
Use visual elements like action icons and buttons to navigate between pages in your report.
Explore the capabilities of Power BI Pro and how it can enable you to collaborate within your Organization
Leverage Data Analysis Expressions to add insight and analysis to our Power BI Report
By the end of the Formula One Analysis Project you will gain extensive skills and have experience of developing a business intelligence solution end to end.
You should gain more than enough experience to add value to your real world projects!

CURRICULUM
This course can be split into 5 key areas:
Loading and Transforming Data
Connecting to data sources in Power BI
Understanding Data Types
Transforming Columns in your Query
Adding Columns to your Query
Sorting and Filtering
Duplicating vs Referencing your Query
Transposing your data
Grouping and summarising your data
Pivoting and Unpivoting your data
Data Modelling
Table Relationships
One to Many, One to One and Many to Many Cardinality
Autodetect
â€œActiveâ€ vs â€œInactiveâ€ Relationships
STAR and SNOWFLAKE Modelling Approaches
Dimensions and Fact Tables
Joining Tables with the Merge Operation
Visualizations and Charts
Visualization and Report Basics
Tables and Pivot Tables
Matrix Visuals
Bar and Column Charts
Line and Area Charts
Combo Charts
Scatter Charts
Treemap Charts
Cards
Data Categories and Geographical Charts
Tooltips
Interactions between Visuals
Filters and Slicers
Adding small multiples
Visual Elements
Report Design Best Practice
Adding Interactivity to your Report
Power BI Service
Power BI Pro vs Premium Overview
Power BI Pro Interface Tour
Publishing Reports to Power BI Pro
Personal Workspaces
Dashboards
Apps
Collabortation Workspaces
Data Analysis Expressions (DAX)
Overview of the Langauges used in Power BI (M and DAX)
DAX Syntax Basics
Aggregation Functions
Filter Functions
Other Functions
DAX Documentation

The course is packed with lectures, code-along videos, assignment questions and detailed walkthroughs.
There should be more than enough to keep you engaged and learning! As an added plus you will also have lifetime access to all the lectures.
Who this course is for:
Anyone looking to learn Power BI with a project based approach
Anyone interested in building a business intelligence solution end to end
Anyone looking to pursue a career in data analysis or business intelligence

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Malvik Vaghadia

Instructor's Courses

Malvik is an Instructor specialising in Data Analytics and Visualization.He has spent 10+ years working for and consulting a number of publicly listed / unlisted companies as a Data and BI specialist. Over the course of his career Malvik has developed a skillset in data engineering, data analytics and visualisation, with expertise across a number of technologies and programming languages including SQL, Python and R. He has worked extensively with a number of leading software platforms including Azure, Hadoop, Spark, Databricks, MongoDB, Oracle, MySQL, MS SQL Server, Qlik and Microsoft Power Platforms.

Pathfinder Analytics

Instructor's Courses

Pathfinder Analytics excels in delivering high quality online courses in Data Analysis, Data Engineering and Business Intelligence.With a focus on providing practical, job-ready skills, Pathfinder Analytics has empowered students around the world with in demand data skills. Explore our offerings to enhance your expertise, master essential tools, and advance your career in data.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.