Microsoft Power BI 2022: The Complete Guide

- Description
- Curriculum
- FAQ
- Reviews
Learn one of the most in demand business intelligence tool in the world and master the most important concepts in the Power BI Ecosystem.
Power BI is an essential tool for anyone working with Data!
This course is hands-on and you will LEARN BY DOING!
COURSE PROJECT
We will be using a really cool Formula One Dataset to create an interactive report with some amazing visualizations.
- We will connect to various data sources including csv, excel, JSON and more.
- We will perform extensive data transformations to make our data ready for reporting.
- We will use relationships and data modelling methodologies to create an effective data model.
- We will explore all kinds of visualisations from Column Charts, Scatter Charts, Maps, Tooltips and more.
- We will use Visual Elements like action icons and buttons to navigate between pages in your report.
- We will explore the capabilities of Power BI Pro and how it can enable you to collaborate within your Organization
- We will use 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.
-
6Part 1 Section OverviewVideo lesson
-
7Entering Data ManuallyVideo lesson
-
8Saving Your WorkVideo lesson
-
9Loading the Races CSV DataVideo lesson
-
10Removing Rows and ColumnsVideo lesson
-
11Data TypesVideo lesson
-
12Working with ColumnsVideo lesson
-
13Splitting / Extracting Information from ColumnsVideo lesson
-
14Simple Mathematical OperationsVideo lesson
-
15Duplicate, Index and Conditional ColumnsVideo lesson
-
16Refreshing the Source DataVideo lesson
-
17Sorting your DataVideo lesson
-
18Filtering ValuesVideo lesson
-
19Logically Ordering your Applied StepsVideo lesson
-
20Replacing ValuesVideo lesson
-
21Duplicate vs ReferenceVideo lesson
-
22Appending QueriesVideo lesson
-
23Removing DuplicatesVideo lesson
-
24Transpose, Reverse Rows and Count RowsVideo lesson
-
25Loading the Circuits JSON File & AssignmentVideo lesson
-
26Loading the Drivers Text File & AssignmentVideo lesson
-
27Loading the Constructors CSV File & AssignmentVideo lesson
-
28Loading the Results CSV File & AssignmentsVideo lesson
-
29Group ByVideo lesson
-
30Pivoting and UnpivotingVideo lesson
-
31Download the Part 1 Power BI ReportVideo lesson
-
32Part 2 Section OverviewVideo lesson
-
33Linking Tables via RelationshipsVideo lesson
-
34One to Many Cardinality and Cross Filter DirectionVideo lesson
-
35Many to Many CardinalityVideo lesson
-
36One to One CardinalityVideo lesson
-
37Creating the Relationships for our Data Model (Assignment)Video lesson
-
38Autodetect and Active RelationshipsVideo lesson
-
39Data Modelling Approaches - STAR and SNOWFLAKEVideo lesson
-
40Merging Tables - Join TypesVideo lesson
-
41Merging Tables DemonstrationVideo lesson
-
42Download the Part 2 Power BI ReportVideo lesson
-
43Part 3 Section OverviewVideo lesson
-
44Visualization and Report BasicsVideo lesson
-
45Table and Matrix VisualsVideo lesson
-
46Bar and Column ChartsVideo lesson
-
47Quick Note on LegendsVideo lesson
-
48InteractionsVideo lesson
-
49Drilldowns and HierarchiesVideo lesson
-
50The Filter PaneVideo lesson
-
51Small MultiplesVideo lesson
-
52Line and Area ChartsVideo lesson
-
53Combo Charts and Cross Filter Direction RevisitedVideo lesson
-
54Scatter ChartsVideo lesson
-
55TreemapsVideo lesson
-
56CardsVideo lesson
-
57Data Categories and MapsVideo lesson
-
58TooltipsVideo lesson
-
59Visual ElementsVideo lesson
-
60Additional VisualizationsVideo lesson
-
61Best Practice Tips and Formula One Report RequirementsVideo lesson
-
62Creating the Formula One Report Part 1Video lesson
-
63Creating the Formula One Report Part 2Video lesson
-
64Download the Part 3 Power BI ReportVideo lesson

External Links May Contain Affiliate Links read more