ExcelR Assignment Solution for BA and Data Analytics. Q9 -Dashboard. Navigation, Cards, Slicers 🤢🥶

ExcelR Assignment Solution for BA and Data Analytics. Q9 -Dashboard. Navigation, Cards, Slicers 🤢🤪



By this video you will learn how to create Dashboard and add Navigation, Cards, Charts, Link to the Website and Slicer (Using Finance Dataset).Learn the on hover and default option in Powerbi, use interactive Dashboard in Powerbi

This is an ExcelR assignement

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?

Data Load from website
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