This is the Power BI end-to-end project: Global Super Store Sales & Performance Dashboard for beginners.
The video is quite long but very useful for beginners who are preparing for Power BI interviews and want to create an end-to-end project in Power BI. With this project, they can enhance their practical skills, so don’t skip any steps; otherwise, you might get confused.
What will you gain here?
With this end-to-end Power BI project, you will build confidence in Power BI and gain real-time practical experience. You can also add this project to your resume as a beginner and share the report on social media, such as LinkedIn.
Feel free to tag me on LinkedIn (sandeepraturi) in your post!
Create an account here if you don’t have one: https://app.powerbi.com/singleSignOn?
Report/ Dashboard Name: Global Super Store Sales & Performance Dashboard.
Dataset: Global Super Store Dataset – 2016
Image Icon: https://www.flaticon.com/
(The Global Super Store dataset is a widely used sample dataset for data analysis and visualization, mostly used in tools like Power BI, Tableau, and other analytics platforms. It represents fictional sales data for a global retail company, covering a range of categories such as orders, products, customers, and shipping details.)
Tables: Orders, People, Returns and Calendar Table
Filters: Market, Region/ country, Category/ Subcategory, Product name, and Year, Month and Day
Video contents includes:
1.Understand the requirements and data: Analyze the project goals and review the data to ensure it meets reporting needs.
2.Load the data into Power BI: Import the required datasets into Power BI from sources like Excel, SQL, or other platforms.
3.Transform the data: Clean, shape, and modify the data using Power Query to make it suitable for analysis and reporting.
4.Create relationships between tables: Establish relationships between tables using keys to enable data analysis across multiple tables.
5.Set the page size: Adjust the report page layout to fit the desired dimensions for better visual design and user experience.
6.Set the theme colors for the report: Apply consistent colors throughout the report to align with branding or improve readability.
7.Create visuals and DAX formulas for the KPIs: Build charts, tables, and calculations (using DAX) to display key performance indicators (KPIs).
8.Create RLS (Row-Level Security): Define security roles to control data access based on user permissions, limiting what data different users can see.
9.Publish the report to the workspace: Upload the report to Power BI Service, allowing users to access, share, and collaborate on it online.
Page Height & width
Canvas setting : height: 720 px, Width: 1500 px
Theme & Page Colors
Canvas Background color: #F1F1F1
Wallpaper Color : #F5F5F5
Theme Colors:
#4CB5F5, #1F3F49, #7E909A, #1C4E80, #A5D8DD, #EA6A47, #0091D5, #B3C100
Calendar Table
Calendar = ADDCOLUMNS( CALENDAR(MIN(Orders[Order Date]), MAX(Orders[Order Date])), "Year", YEAR([Date]), "Month", MONTH([Date]), "YearMonth", Format([Date], "YYYY-MMM"), "MonthSort", Format([Date], "MMM"), "Day", DAY([Date]) )
Calculated Column & Measures
Shipping Days = DATEDIFF(Orders[Order Date], Orders[Ship Date], DAY)
Total Returns = COUNT(Returns[Order ID])
Return Rate = DIVIDE([Total Returns], COUNT(Orders[Order ID]), 0)
Count of Ship = CALCULATE ( COUNT ( Orders[Ship Date] ), USERELATIONSHIP ( Orders[Ship Date], 'Calendar'[Date] ) )
