Power BI - Data Analytics Essentials with Power BI

Get Started Quickly with Visualization, Data Prep and DAX on Power BI

(2,717 ratings)

56,902 students

Created by Ahmed Oyelowo

Last updated 10/2020

English

30-Day Money-Back Guarantee

What you'll learn

Simple methods to Analyze data with Power BI and gain Insights
Automate manual reporting processes with Power BI
Make reports available to stakeholders 24/7 on all devices
Select the appropriate charts for visualization (Data Visualization)
Create links in reports with Book Marks (Data Visualization)
Design Interactive Reports and Dashboards (Data Visualization)
Logical steps to build Data Models from (Data Modeling & DAX)
Understand concept of Fact and Dimension Tables (Data Modeling & DAX)
Simplified methods to write your own DAX Measures (Data Modeling & DAX)
Build your Calendar/Date Table from Scratch with DAX (Data Modeling & DAX)
Combine multiple Excel Workbooks (Data Preparation)
Combine Multiple Excel Worksheets (Data Preparation)
Master the rules for Data Preparation (Data Preparation)

Requirements

Basic Reporting
Fundamental Excel Knowledge is an added advantage
Knowledge of Excel Pivot Tables is an added advantage

Description

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!

Who this course is for:

Power BI Beginners
Interested in Data Analysis
Looking to earn the Power BI Certification
Business Intelligence enthusiasts
Data Science enthusiasts

6 sections • 75 lectures • 4h 46m total length

Welcome!
00:33
Preview04:07
Preview06:07
Downloading Power BI Desktop
02:38
Understanding the Power BI User Interface
08:03
Power BI Interface
1 question
Understanding the Case Study Data
04:24
Importing Data to Power BI
03:53
Understanding the Power Query User Interface
05:26
Intro to Transforming Data with Power Query
03:29
Intro to Transforming Data with Power Query Continued
05:05
Preview03:46
More Information on using copied M Scripts to Excel
00:30
Editing Queries and Refreshing Data
00:00
Power Query Transformation
1 question

Introduction to Power BI Reporting
03:36
Visualizing a timeline report with Line Chart
03:33
Formatting Power BI Charts
05:54
Adding a new chart to the canvass
03:23
Preview03:34
Sorting a Visual
03:20
Filtering a page with Filters Pane and Using Slicers
05:44
Controlling Visual Interactions on the Canvass
03:07
Preview01:56
Using Shadows to enhance Reports
00:16
Chart Elements
1 question
Working with Shapes and Text Box
03:03
Working with Report Themes
03:45
Re-Using a Report Page as Template
04:40
Adding a back button to return to a previous page
01:48
Designing a Report optimized for Mobile View
03:21
Publishing Reports to the Power BI Service
05:25
Introduction to Q & A
03:18
Selecting the right Visuals
03:12
Module Outro
00:46
Assignment
1 question

Introduction to Data Modeling
03:12
Why build a Data Model?
04:36
Step 1 - 4 of Building a Data Model
11:27
Step 5 of Building a Data Model
06:34
Preparing Data Model Files in Power Query
03:25
Extracting the Fact and Dimension Tables
04:44
Investigating & Resolving issues with Relationships 1
04:49
Investigating & Resolving issues with Relationships 2
07:46
Testing the Relationships in Report View
02:13
Data Modeling Quiz
1 question

Data Analysis Expressions (DAX)
00:33
Introduction to DAX
02:21
Using CALENDARAUTO() to generate a Calendar Table
05:02
Using FORMAT() Function to add Month, Year and Quarter Columns to Calendar
06:45
Connecting the Calendar Table to the Fact Table
03:26
Using the MONTH() Function to Create a Custom Sort Column for the Month Column
02:39
Writing simple Aggregation Measure
04:09
Aggregation Measures
00:19
Understanding Filter Context 1
03:57
Understanding Filter Context 2
02:31
Introduction to CALCULATE() function
05:31
Creating a shell table to keep Measures
02:35
Writing Time Intelligence Formulas - the PREVIOUSMONTH() Function
06:41
Calculating Month on Month Variance
03:42
Using the REMOVEFILTERS() function and Calculating Percentage share
04:50
Using SAMEPERIODLASTYEAR() to calculate SPLY Values
02:28
Calculating Year to Date Values
05:02
Automatic Measures with Quick Measures
03:06
Time intelligence Formulas
00:17

Customizing the Report Theme
01:51
Creating a Report Page Template
04:32
Visualizing Monthly Revenue vs SPLY on a Line Chart
02:53
Creating a Forecast from a Line Chart
04:31
Visualizing Monthly Variance with a Waterfall Chart
02:44
Creating a Matrix Table report with Data Bars
02:24
Creating a simple Donut Chart
01:46
Visualizing Current & Previous Period with Clustered Bar Chart
01:58
Visualizing Changes in ranking over time with Ribbon Chart
05:00

Ahmed Oyelowo

Microsoft Data Platform MVP | Certified Trainer (MCT)

4.4 Instructor Rating
2,885 Reviews
58,094 Students
2 Courses

Ahmed is a Microsoft Data Platform MVP, a Microsoft Certified Solutions Associate (BI Reporting), Microsoft Certified Trainer (MCT) and a Certified Advanced Financial Modeler (AFM) from the Financial Modeling Institute, Ontario, Canada.

He has developed cutting edge solutions and trained various corporate clients on Business Intelligence and Financial Modeling. He has been consulting & training on Power BI since it’s early days in 2015.

Ahmed has trained courses on:

1. Power BI

2. Power Query,

3. Financial Modelling

4. Advanced Data Analysis & Reconciliation and

5. Data Presentation.

He is the Managing Partner & Lead Trainer at Foresight BI & Analytics.

Power BI - Data Analytics Essentials with Power BI

What you'll learn

Requirements

Description

Who this course is for:

Course content

Intro & Overview13 lectures • 48min

Visualizing Reports in Power BI19 lectures • 1hr 4min

Understanding Data Modeling in Power BI9 lectures • 49min

Introduction to DAX19 lectures • 1hr 6min

Visualizing the Measures9 lectures • 28min

Data Preparation Techniques6 lectures • 33min

Instructor