Power BI - Data Analytics Essentials with Power BI
4.6 (1,729 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
34,058 students enrolled

Power BI - Data Analytics Essentials with Power BI

Get Started Quickly with Visualization, Data Prep and DAX on Power BI (Course continues to be updated)
Highest Rated
4.6 (1,729 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
34,058 students enrolled
Created by Ahmed Oyelowo
Last updated 7/2020
English
Current price: $139.99 Original price: $199.99 Discount: 30% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 7 articles
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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

“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, the bolts of the key concepts required to be a Power BI expert.

And not just that, the facilitator will be on ground, supporting any participant with challenges working with Power BI afterwards.

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
Course content
Expand all 74 lectures 04:46:23
+ Intro & Overview
12 lectures 47:31
Welcome!
00:33
Downloading Power BI Desktop
02:38
Understanding the Power BI User Interface
08:03

Check your knowledge

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
Editing Queries and Refreshing Data
00:00

Check your knowledge

Power Query Transformation
1 question
+ Visualizing Reports in Power BI
19 lectures 01:03:42
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
Sorting a Visual
03:20
Filtering a page with Filters Pane and Using Slicers
05:44
Controlling Visual Interactions on the Canvass
03:07
Using Shadows to enhance Reports
00:16

Check your knowledge

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
In this assignment, you will use the Super Store excel data to build a Power BI Report
Assignment
1 question
+ Understanding Data Modeling in Power BI
9 lectures 48:46
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
+ Introduction to DAX
19 lectures 01:05:54
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

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.

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
+ Visualizing the Measures
9 lectures 27:39
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
+ Data Preparation Techniques
6 lectures 32:50
Introduction to Data Preparation
01:10
Using Append method to combine Excel Worksheets
05:11
Using Workbook Property Method to combine Excel Worksheets
07:02
Comparing Append & Workbook Property Consolidation Methods
04:00
Consolidating Clean Excel Workbooks from a Folder
05:42
Consolidating un-clean Excel Workbooks from a Folder
09:45