Power BI - Data Analytics Essentials with Power BI

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

4.45 (6127 reviews)
Udemy
platform
English
language
Other
category
instructor
89,233
students
5 hours
content
Jul 2023
last update
$89.99
regular price

What you will 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)

Description

Many students who have taken this course have found it detailed and easy to understand. At the end of the course, you will be able to take my virtual Power BI Developer Internship program that also comes with a Certificate.

“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:

  1. Data Preparation

  2. Data Modeling

  3. Data Visualization

  4. 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!

Content

Intro & Overview

Welcome!
Introductions
About the Course
Downloading Power BI Desktop
Understanding the Power BI User Interface
Power BI Interface
Understanding the Case Study Data
Importing Data to Power BI
Understanding the Power Query User Interface
Intro to Transforming Data with Power Query
Intro to Transforming Data with Power Query Continued
Re-Using M Scripts and Loading Data to Power BI
Editing Queries and Refreshing Data
Power Query Transformation

Visualizing Reports in Power BI

Introduction to Power BI Reporting
Visualizing a timeline report with Line Chart
Formatting Power BI Charts
Adding a new chart to the canvass
Creating a Top N Report with a Bar Chart
Sorting a Visual
Filtering a page with Filters Pane and Using Slicers
Controlling Visual Interactions on the Canvass
Using Visuals Background to enhance Report Page
Chart Elements
Working with Shapes and Text Box
Working with Report Themes
Re-Using a Report Page as Template
Adding a back button to return to a previous page
Designing a Report optimized for Mobile View
Publishing Reports to the Power BI Service
Introduction to Q & A
Module Outro

Understanding Data Modeling in Power BI

Introduction to Data Modeling
Why build a Data Model?
Step 1 - 4 of Building a Data Model
Step 5 of Building a Data Model
Preparing Data Model Files in Power Query
Extracting the Fact and Dimension Tables
Investigating & Resolving issues with Relationships 1
Investigating & Resolving issues with Relationships 2
Testing the Relationships in Report View

Introduction to DAX

Data Analysis Expressions (DAX)
Introduction to DAX
Using CALENDARAUTO() to generate a Calendar Table
Using FORMAT() Function to add Month, Year and Quarter Columns to Calendar
Connecting the Calendar Table to the Fact Table
Using the MONTH() Function to Create a Custom Sort Column for the Month Column
Writing simple Aggregation Measure
Aggregation Measures
Understanding Filter Context 1
Understanding Filter Context 2
Introduction to CALCULATE() function
Creating a shell table to keep Measures
Writing Time Intelligence Formulas - the PREVIOUSMONTH() Function
Calculating Month on Month Variance
Using the REMOVEFILTERS() function and Calculating Percentage share
Using SAMEPERIODLASTYEAR() to calculate SPLY Values
Calculating Year to Date Values
Automatic Measures with Quick Measures
Time intelligence Formulas

Visualizing the Measures

Customizing the Report Theme
Creating a Report Page Template
Visualizing Monthly Revenue vs SPLY on a Line Chart
Creating a Forecast from a Line Chart
Visualizing Monthly Variance with a Waterfall Chart
Creating a Matrix Table report with Data Bars
Creating a simple Donut Chart
Visualizing Current & Previous Period with Clustered Bar Chart
Visualizing Changes in ranking over time with Ribbon Chart

Data Preparation Techniques

Introduction to Data Preparation
Using Append method to combine Excel Worksheets
Using Workbook Property Method to combine Excel Worksheets
Comparing Append & Workbook Property Consolidation Methods
Consolidating Clean Excel Workbooks from a Folder
Consolidating un-clean Excel Workbooks from a Folder

Screenshots

Power BI - Data Analytics Essentials with Power BI - Screenshot_01Power BI - Data Analytics Essentials with Power BI - Screenshot_02Power BI - Data Analytics Essentials with Power BI - Screenshot_03Power BI - Data Analytics Essentials with Power BI - Screenshot_04

Reviews

Emmanuel
October 6, 2023
great course, simple enough for outright beginners to understand and grasp a little pre-knowledge of excel won't be bad before commencing the course
Hinal
September 28, 2023
Majorly shown is on excel instead of repetitive stuff there could have been more advance to show how to upload the data from SQL server or PoweBI server or through online tool of Power BI. Too many repetitive videos related to charts and yet not all functions are explained.
Okunribido
September 10, 2023
It's a perfect match. Big ups to Ahmed Oyelowo a great tutor. Looking forward to completing the course.
Ishan
August 30, 2023
Teaching method was amazing and the content of course are very helpful. Thank you for such amazing course...
ESG-API
July 19, 2023
I thoroughly enjoyed doing 'Power BI - Data Analytics Essentials with Power BI'. This course is best for beginners to Power BI. The instructor explains clearly and uses real world project all across the course. Also, I will the wide breath of topics covered in the course - visualisation, data preparation, DAX, data modelling and much more. One area the course can be improved is adding more sample project as optional sections. This will enable learners to become more proficient in Power BI. Overall, this is a 5 star course. Thanks for an amazing experience!
Janardhan
June 15, 2023
I learnt many things from this course and I am confident enough to work on data modeling, data cleaning, connecting to folders, workbook and on and on... THANK YOU SIR
Peter
May 17, 2023
Amazing!!! Ahmed is quite Knowledgeable and has a unique way of breaking complex topics into sizeable chunks for easy consumption.
Javier
May 13, 2023
This course is well structured, pace is more than adequate and teacher talks precissely. Regarding subjetcs covered, I think it covers the topics necessary to get a solid base for keeping learning. Good KM0 for future Power BI users.
Lawal
May 8, 2023
I'm finding the presentations on this course interesting and impacting. Honestly, the instructor is good, uses simple language that makes me to understand each topic.
Dhananjay
March 31, 2023
I am totaly out of knowledge from in data visualisations tool i am not able to anaylysis the data of any other chart but when i learn power BI as tool and concept i am very comfortable with data and pie chat and all type of data
Jimoh
March 30, 2023
it was a great experience and enjoy every bit of learning specifically the data modelling explanation. the course is worth taking.
Lienke
March 19, 2023
the accent is annoying also the way he explains is very basic and minimal. Like "this section is important" but what do all the buttons mean?
Benjamin
March 9, 2023
Personally, I am an Accountant and ever since I have been heavily involved with Financial Reporting. This has drawn me closer to Data Analysis and at the same time making meaningful presentation for informed decision making. At the moment, I am involved with Supply Chain, which deals with heavy data. With this being said, I decided to be much more efficient and effective by learning and applying Data Analytics in my daily work.
Nikhil
January 24, 2023
This is very good Learning. The teacher explained every topic in detail and in an understanding manner.
Oyeshola
January 18, 2023
it is well detailed and informative. he explained every topic in a comprehensible way. i have followed the course and was able to do a visualization using superstore data. thank you.

Coupons

DateDiscountStatus
5/3/2020100% OFF
expired
6/5/2020100% OFF
expired
7/2/2020100% OFF
expired
9/3/2020100% OFF
expired
10/2/2020100% OFF
expired
11/1/2020100% OFF
expired
11/20/2021100% OFF
expired
2/21/2022100% OFF
expired
2/21/2022100% OFF
expired
2/22/2022100% OFF
expired
3/2/2022100% OFF
expired
3/4/2022100% OFF
expired
3/4/2022100% OFF
expired
5/2/2022100% OFF
expired
5/4/2022100% OFF
expired
6/1/2022100% OFF
expired
6/2/2022100% OFF
expired
6/2/2022100% OFF
expired
8/8/2022100% OFF
expired
8/9/2022100% OFF
expired
8/11/2022100% OFF
expired
9/2/2022100% OFF
expired
9/2/2022100% OFF
expired
10/2/2022100% OFF
expired
10/2/2022100% OFF
expired
10/4/2022100% OFF
expired
11/2/2022100% OFF
expired
11/2/2022100% OFF
expired
11/2/2022100% OFF
expired
12/2/2022100% OFF
expired
12/3/2022100% OFF
expired

Charts

Price

Power BI - Data Analytics Essentials with Power BI - Price chart

Rating

Power BI - Data Analytics Essentials with Power BI - Ratings chart

Enrollment distribution

Power BI - Data Analytics Essentials with Power BI - Distribution chart

Related Topics

2328046
udemy ID
4/18/2019
course created date
1/8/2020
course indexed date
Bot
course submited by