Power BI Hands-On ETL Course 2023 | Real-World Business Case

Master your skills in Power BI reporting and analysis with a complete real-world hands on use case

4.55 (104 reviews)
Udemy
platform
English
language
Data & Analytics
category
2,165
students
4 hours
content
Jan 2023
last update
$69.99
regular price

What you will learn

Complete end-to-end Power BI Report development using a real-world business case

Able to implement your BI skills to your professional or personal projects

Power BI's complete ETL process - data integration, transformation, modelling and visualization

Able to understand and explore your data using AI-Based Power BI visuals

Learning and implementing DAX calculations

Analyze your data for an effective storytelling using unique Power BI features like - drillthrough, custom tooltips, bookmarks

Description

Learn to design and develop amazing Power BI report as per industrial standards and best practices.

In this course, you'll learn all the unique features of Power BI Desktop to help you understand and gain confidence in -

  • Data Integration

  • Data Transformation

  • Data Modelling

  • Data Exploration

  • Data Visualization

  • Storytelling


Course content 

We'll be taking a practical approach by first understanding the business case, then as per our requirement will be working step-by-step practical approach to first clean our data, mashup and then start our work on visualizations.


In this extensive hands-on course, you will be under the shoes of a Data analyst who is developing a Power BI report for Chief Marketing Officer and Chief Financial Officer to help them uncover the business insights from their data and track major Sales and Financial KPIs.


You will be working and analyzing a Sales and market share analysis data where your focus would be to find out which product categories and manufacturers are generating the most revenue. Along with that, you will be doing a competitive analysis against other top manufacturers. 


  • We'll start by integrating the data from multiple data sources and then performing lot of transformations to prepare and clean our data and make it ready for reporting.

  • Once loaded, we'll start working on making a data model and working our way towards the visualizations.

  • We'll be doing a lot of data analysis and exploration by asking important questions throughout the course.

  • We'll also be working our way to answer some of the common questions while doing Sales analysis through DAX calculations and creating our own measures and calculated columns.

  • Our final goal will be to design a professional sales analysis report that can easily be used by the end users to gather the insights and help them take actions out of it.

  • Furthermore, we'll be using multiple AI-based Power BI visuals to do some advanced analysis on our data.


Content

Introduction

Power BI Overview and capabilities
Business Scenario
Walkthrough - Report Section, Data, Model
Walkthrough - Home Ribbon

Data Integration

Integrating data from multiple data sources
Data preparation

Data Transformation

Split columns | Fill down | Column from examples
Remove rows | Transpose
Append Queries | Add Conditional Column
Optimizing the Data Model

Data Modelling

Creation of unique key column for setting up relationship
Cross Filter Direction

Data Exploration and Analysis

Clustered column chart - Ask a question feature | Top N Analysis
Competitor Analysis - Creation of Groups | Treemap visual
YoY Analysis - Drilldown Capabilities
Slicer | Creation of hierarchies

DAX Calculations

Measures vs Calculated Columns
This Year vs Last Year Analysis | Custom Date dimension table
% Growth Calculation

Data Visualization

Conditional Formatting on Matrix visual
Importing a custom .JSON theme
Using manufacturer logo images in slicer | Trend Analysis

Storytelling in Power BI

Using Bookmarks to present your data in a story
Adding Bookmark buttons in your report
Adding toggle buttons using Selection Pane and Bookmark Pane

Finalizing the UI of Sales Report

Adding Background | Azure Maps | Text boxes | Logo

Advanced analysis using AI Visualizations

Decomposition Tree
Key Influencers
Smart Narrative

Advanced Power BI Features

Analyze and Quick Insights
Custom Tooltip
Drillthrough from summary to detailed report

Power BI Service

Introduction to Power BI Service

Some Additional Concepts

Export to Excel | Export to PDF
Performance Analyzer

Screenshots

Power BI Hands-On ETL Course 2023 | Real-World Business Case - Screenshot_01Power BI Hands-On ETL Course 2023 | Real-World Business Case - Screenshot_02Power BI Hands-On ETL Course 2023 | Real-World Business Case - Screenshot_03Power BI Hands-On ETL Course 2023 | Real-World Business Case - Screenshot_04

Reviews

Salil
September 9, 2022
I had some experience of working in Power BI, this course is really helping take it to next level. Thank you.
John
July 11, 2022
A very detail oriented course, really good in not only covering up the basics but also cleared lot of doubts related to DAX calculations.
Sam
June 30, 2022
This has been the perfectly aligned course for learning Power BI. All the sections are so streamlined and really helped in understanding. Thank you!
Karan
June 29, 2022
I liked this course and it is helping me keep up the pace with all new updates in Power BI. Instructor is also very responsive.
George
June 25, 2022
The use case has actually been helping me to understand many of the features of Power BI and Power Query,
Mahendra
June 16, 2022
Good concepts and practical approach. Please keep it updating with new Power BI features as they come
Sagar
June 13, 2022
Please add lectures for using SQL/Oracle databases and what are the challenges we can face while using them
Deepak
May 31, 2022
Great pace and delivery. The way the content has been setup in the course is really helpful and makes it easy to learn Power bi.
James
May 23, 2022
This has been one of the best course in terms of structure, data and all the Power BI topics covered.
Manas
May 17, 2022
I wanted to expand my skillset in Power BI as I'm aware of basic visualizations. This course does helps in knowing some good transformations and advanced concepts.
Sania
May 13, 2022
This course is fantastic, I am learning a lot, I did not have how to use Power BI and now I am in the advance level. The instructor makes very interesting the subject and he explains very well. I strongly recommend this course!
Kamal
May 13, 2022
A well taught course with lot of hands on work. I liked the use case which actually enable the enhanced learning. One do not need to put lot of effort and can simply learn things by doing watching the lessons and doing home work.
Manpreet
May 13, 2022
This really is helping in understanding all those small concepts which are hard to cover. Instructor is explaining really good.
Vikrant
May 13, 2022
Nicely framed course, above my expectations. All the things mentioned in the course is exactly what I was looking for.
Yash
May 12, 2022
Wonderful course and delivery by Deepesh. Learning a lot of things with the business case provided in the course.

Coupons

DateDiscountStatus
5/13/2022100% OFF
expired
5/25/2022100% OFF
expired
6/2/2022100% OFF
expired
6/23/2022100% OFF
expired
7/8/2022100% OFF
expired

Charts

Price

Power BI Hands-On ETL Course 2023 | Real-World Business Case - Price chart

Rating

Power BI Hands-On ETL Course 2023 | Real-World Business Case - Ratings chart

Enrollment distribution

Power BI Hands-On ETL Course 2023 | Real-World Business Case - Distribution chart

Related Topics

4681716
udemy ID
5/11/2022
course created date
5/13/2022
course indexed date
Bot
course submited by