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

Power BI Hands-On ETL Course 2023 | Real-World Business Case, available at $64.99, has an average rating of 4.6, with 39 lectures, based on 105 reviews, and has 2180 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who has basic to intermediate understanding of Power BI and is looking to take the reporting to the next level or Anyone who is looking to learn Power BI with a practical use case or Anyone who wants to design and develop professional reports or This course is not for you if your focus in on Power BI Service. This course is intended to improve your development and analytical skills or Anyone who wants to enhance their skillset as a data analyst or BI consultant It is particularly useful for Anyone who has basic to intermediate understanding of Power BI and is looking to take the reporting to the next level or Anyone who is looking to learn Power BI with a practical use case or Anyone who wants to design and develop professional reports or This course is not for you if your focus in on Power BI Service. This course is intended to improve your development and analytical skills or Anyone who wants to enhance their skillset as a data analyst or BI consultant.

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

Summary

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

Price: $64.99

Average Rating: 4.6

Number of Lectures: 39

Number of Published Lectures: 39

Number of Curriculum Items: 39

Number of Published Curriculum Objects: 39

Original Price: $94.99

Quality Status: approved

Status: Live

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

Who Should Attend

Anyone who has basic to intermediate understanding of Power BI and is looking to take the reporting to the next level
Anyone who is looking to learn Power BI with a practical use case
Anyone who wants to design and develop professional reports
This course is not for you if your focus in on Power BI Service. This course is intended to improve your development and analytical skills
Anyone who wants to enhance their skillset as a data analyst or BI consultant

Target Audiences

Anyone who has basic to intermediate understanding of Power BI and is looking to take the reporting to the next level
Anyone who is looking to learn Power BI with a practical use case
Anyone who wants to design and develop professional reports
This course is not for you if your focus in on Power BI Service. This course is intended to improve your development and analytical skills
Anyone who wants to enhance their skillset as a data analyst or BI consultant

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Power BI Overview and capabilities

Lecture 2: Business Scenario

Lecture 3: Walkthrough – Home Ribbon

Lecture 4: Walkthrough – Report Section, Data, Model

Chapter 2: Data Integration

Lecture 1: Integrating data from multiple data sources

Lecture 2: Data preparation

Chapter 3: Data Transformation

Lecture 1: Split columns | Fill down | Column from examples

Lecture 2: Remove rows | Transpose

Lecture 3: Append Queries | Add Conditional Column

Lecture 4: Optimizing the Data Model

Chapter 4: Data Modelling

Lecture 1: Creation of unique key column for setting up relationship

Lecture 2: Cross Filter Direction

Chapter 5: Data Exploration and Analysis

Lecture 1: Clustered column chart – Ask a question feature | Top N Analysis

Lecture 2: Competitor Analysis – Creation of Groups | Treemap visual

Lecture 3: YoY Analysis – Drilldown Capabilities

Lecture 4: Slicer | Creation of hierarchies

Chapter 6: DAX Calculations

Lecture 1: Measures vs Calculated Columns

Lecture 2: This Year vs Last Year Analysis | Custom Date dimension table

Lecture 3: % Growth Calculation

Chapter 7: Data Visualization

Lecture 1: Conditional Formatting on Matrix visual

Lecture 2: Importing a custom .JSON theme

Lecture 3: Using manufacturer logo images in slicer | Trend Analysis

Chapter 8: Storytelling in Power BI

Lecture 1: Using Bookmarks to present your data in a story

Lecture 2: Adding Bookmark buttons in your report

Lecture 3: Adding toggle buttons using Selection Pane and Bookmark Pane

Chapter 9: Finalizing the UI of Sales Report

Lecture 1: Adding Background | Azure Maps | Text boxes | Logo

Chapter 10: Advanced analysis using AI Visualizations

Lecture 1: Decomposition Tree

Lecture 2: Key Influencers

Lecture 3: Smart Narrative

Chapter 11: Advanced Power BI Features

Lecture 1: Analyze and Quick Insights

Lecture 2: Custom Tooltip

Lecture 3: Drillthrough from summary to detailed report

Chapter 12: Power BI Service

Lecture 1: Introduction to Power BI Service

Lecture 2: Overview and Microsoft tutorial for Power BI Service

Chapter 13: Some Additional Concepts

Lecture 1: Export to Excel | Export to PDF

Lecture 2: Performance Analyzer

Lecture 3: Latest Updates Documentation

Lecture 4: Major New Updates

Lecture 5: Thank you!!!

Instructors

Deepesh Vashistha
Microsoft Certified BI Consultant/Data Enthusiast

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 3 votes
4 stars: 28 votes
5 stars: 73 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu