ExcelR Assignment Solution for BA and Data Analytics. Q4 -Create the Waterfall Chart🥶😱

ExcelR Assignment Solution for BA and Data Analytics. Q4 - Create the Waterfall Chart to show Category-wise, Yearly Analysis using Superstore Dataset.
🤢🤪

By this video you will learn how to create waterfall chart in PowerBI and analyse the chart and data comparison, you can analyse the trend of the chart which will help company to decide in its goals achievement. Learn the on hover and default option in Powerbi, use interactive Dashboard in Powerbi

This is an ExcelR assignments

Q1. Power BI Platform
What is PowerBI and What are the various Platforms of Power BI?

Q2. Dax
Create a line and clustered column chart and compare this year vs last year's sales along with growth % using DAX? Refer superstore dataset

Q3. Data Modeling
Import data from 2023 Worldwide Box Office - Box Office Mojo and add the past 3 years of data in the Power Query editor, create a master table of the past 3 years of data, and load only master data in the Power BI query editor or Power BI desktop?

Q4. Waterfall chart
Create the Waterfall Chart to show Category-wise, Yearly Analysis using Superstore Dataset.


Data Load from website
Create Waterfall Chart in PowerBi
Analysis Waterfall chart yearly and category wise in PowerBi

Three year data load from website and create master table
load master table
create dashboard
Calculate Function in PowerBI
Sameperiodlastyear in PowerBI
Total Sale Function in PowerBI
Calculate Last Year Sale in PowerBI
Create and USE DAX in PowerBI

how to create Dashboards, in PowerBI,

how to create Navigation in PowerBI,

how to create Bookmark in PowerBI

how to create slicers in PowerBI,

how to create charts in PowerBI

how to add cards in PowerBI

how to make page navigation in PowerBI


best youtube channel is Vikas Educlass

best excel channel is Vikas EduClass

Vikas Educlass

learn Microsoft excel in hindi free

learn Excel with Vikas Educlass