Microsoft Power BI
Course Outline
-
Introduction
- Overview of Basic Sales Analytics Session
- Bird-eye view of Sales Data
- Getting Started with Power BI
- Get Data in Power BI and Develop Relationships
- Develop Key Calculation Table and Calculate Total Sales
- Develop Dates Table
- Calculate Total Cost and Total Profits
- Calculate Total Unit Sold, Total Products and Profit Margin Percentage
- Dashboard – Page Background with Title and key cards
- Dashboard – Slicer of Years and Quarter
- Dashboard – Total Sales by Location, Dates and Salesperson
- Dashboard – Product-wise Sales with Map and Review of Sales Performance
-
Intermediate Sales Analytics Session
- Overview of Intermediate Sales Analytics Session
- Introduction of Intermediate Sales Analytics
- Product Insight – Calculate Top 5 Products
- Product Insight – Calculate Year on Year (YoY) Sales Growth
- Product Insight – Calculate Product Group Table and place it accordingly
- Product Insight – Create Scatter Chart with Product Growth Groups
- Product Insight Dashboard – Product Table Visualization
- Product Insight Dashboard – Scatter Chart and Top Products
- Product Insight Dashboard – Final Visualization and Product Review
- Customer Insight – Calculate Top 5 Customers
- Customer Insight – Time Intelligence Calculations
- Customer Insight – Customer Ranking in the Scatter Chart
- Customer Insight Dashboard – Final Visualization and Customer Review
- Sales Summary Dashboard – Final Visualization and Sales Review
- Sales Budget – Overview and Utilization of Time Intelligence Technique
- Sales Budget – Budget Formula and Final Visualization
Practice Session (Financial Report)
Dataset:
- Download Financial Data Files.
Hints:
Transformation:
- Check all data type
- Create Date table
- Create New Measurements
- Total Sales [Sum of Sales]
- Total Margin [Sum of Profit]
- Total COGS [Sum of COGS]
- Sales vs COGS [Total Sales – Total COGS]
- Profit % [Total Margin / Total COGS]
- Average Order [Total Sales / Total Number of Row*(use COUNTROWS Function)]
Modeling :
- Create Relationship between Financial & Date table
Practice Session (Cyber Security Breaches Analysis)
Cyber Security Breaches Dashboard
Sample Dashboard:
Dataset & Files:
Click here ! [ Code > Download Zip ]