Power BI - Data Analytics Essentials with Power BI
- Description
- Curriculum
- FAQ
- Reviews
Many students who have taken this course have found it detailed and easy to understand.
“In God we trust, all others must bring data”.
The famous quote by W. Edwards Deming has never been more true than it does in today’s world.
Far gone are the days business decision makers take critical decisions based on haunches, intuition and gut feelings.
These days, everyone has come to realise that better and more accurate decisions can be made when data is put into good use. And there is data everywhere. The problem is, there is a shortage in the number of people who can put it into good use.
The Power BI course is designed to arm participants with knowledge on using the most highly rated Data Analytics and Business Intelligence Tool, Power BI to go from data to insights.
Participants will quickly learn from a Microsoft Certified Trainer and MVP, the bolts of the key concepts required to be a Power BI expert.
Complex concepts are described in simplified manner to make the learners’ journey easier.
And not just that, the facilitator will be on ground, supporting any participant with challenges working with Power BI afterwards.
This course covers the essentials of Power BI Desktop including:
- Data Preparation
- Data Modeling
- Data Visualization
- DAX
In the Data Preparation section, I explained the rules for clean data structure. I also show how to connect Power BI to a system Folder, an approach that eases data updates for reports.
The Data Modeling section shows how you can eliminate redundant data from a large data set by separating the tables into Fact and Dimension Tables. You will see how to do this from scratch using a methodical approach.
In the Data Visualization section, I have included a write up that will guide you in ensuring that you always select the right kind of charts for your reporting and dashboards
Although, I have created a separate dedicated course for more in-depth explanations on DAX, the DAX content here is an excellent place to start your DAX Knowledge.
Enjoy the course!
-
1
Welcome! -
2
Introductions -
3
About the Course
-
4
Downloading Power BI Desktop
-
5
Understanding the Power BI User Interface
-
6
Power BI InterfaceCheck your knowledge
-
7
Understanding the Case Study Data
-
8
Importing Data to Power BI
-
9
Understanding the Power Query User Interface
-
10
Intro to Transforming Data with Power Query
-
11
Intro to Transforming Data with Power Query Continued
-
12
Re-Using M Scripts in Microsoft Excel and Loading Data to Power BI
-
13
More Information on using copied M Scripts to Excel
-
14
Editing Queries and Refreshing Data
-
15
Power Query Transformation
Check your knowledge
-
16
Introduction to Power BI Reporting
-
17
Visualizing a timeline report with Line Chart
-
18
Formatting Power BI Charts
-
19
The New Power BI Visualizations & Formatting Pane
-
20
Adding a new chart to the canvass
-
21
Creating a Top N Report with a Bar Chart
-
22
Sorting a Visual
-
23
Filtering a page with Filters Pane and Using Slicers
-
24
Controlling Visual Interactions on the Canvass
-
25
Using Visuals Background to enhance Report Page
-
26
Using Shadows to enhance Reports
-
27
Chart Elements
Check your knowledge
-
28
Working with Shapes and Text Box
-
29
Working with Report Themes
-
30
Re-Using a Report Page as Template
-
31
Adding a back button to return to a previous page
-
32
Designing a Report optimized for Mobile View
-
33
Create a Microsoft 365 Developer Account for Power BI
-
34
Publishing Reports to the Power BI Service
-
35
Introduction to Q & A
-
36
Selecting the right Visuals
-
37
Module Outro
-
38
Assignment
-
39
Introduction to Data Modeling
-
40
Why build a Data Model?
-
41
Step 1 - 4 of Building a Data Model
-
42
Step 5 of Building a Data Model
-
43
Preparing Data Model Files in Power Query
-
44
Extracting the Fact and Dimension Tables
-
45
Investigating & Resolving issues with Relationships 1
-
46
Investigating & Resolving issues with Relationships 2
-
47
Testing the Relationships in Report View
-
48
Data Modeling Quiz
Test your knowledge on Data Models
-
49
Data Analysis Expressions (DAX)
-
50
Introduction to DAX
-
51
Using CALENDARAUTO() to generate a Calendar Table
-
52
Using FORMAT() Function to add Month, Year and Quarter Columns to Calendar
-
53
Connecting the Calendar Table to the Fact Table
-
54
Using the MONTH() Function to Create a Custom Sort Column for the Month Column
-
55
Writing simple Aggregation Measure
-
56
Aggregation Measures
-
57
Understanding Filter Context 1
-
58
Understanding Filter Context 2
-
59
Introduction to CALCULATE() function
-
60
Creating a shell table to keep Measures
-
61
Writing Time Intelligence Formulas - the PREVIOUSMONTH() Function
-
62
Calculating Month on Month Variance
-
63
Using the REMOVEFILTERS() function and Calculating Percentage share
During the March 2020 update, the REMOVEFILTERS() function used in this lesson has stopped showing up in the Power BI Intellisense. So you will have to type out the full name of the function, open parenthesis and enter the arguments as shown in the video, then close the parenthesis as usual. It still works very fine.
-
64
Using SAMEPERIODLASTYEAR() to calculate SPLY Values
-
65
Calculating Year to Date Values
-
66
Automatic Measures with Quick Measures
-
67
Time intelligence Formulas
-
68
Customizing the Report Theme
-
69
Creating a Report Page Template
-
70
Visualizing Monthly Revenue vs SPLY on a Line Chart
-
71
Creating a Forecast from a Line Chart
-
72
Visualizing Monthly Variance with a Waterfall Chart
-
73
Creating a Matrix Table report with Data Bars
-
74
Creating a simple Donut Chart
-
75
Visualizing Current & Previous Period with Clustered Bar Chart
-
76
Visualizing Changes in ranking over time with Ribbon Chart
