KPIs Students Should Build in Power BI
Sales Performance
- Total Revenue — Sum of Revenue_GHS
- Total Orders — Count of Order_ID
- Average Order Value (AOV) — Revenue ÷ Orders
- Revenue by Month/Quarter/Year — Time intelligence trend line
Profitability
- Gross Profit — Revenue − COGS
- Gross Profit Margin (%) — Gross Profit ÷ Revenue
- Revenue vs COGS Comparison — Clustered bar chart
Product & Category Analysis
- Top 5 Best-Selling Products — By revenue and by quantity
- Sales by Category — Pie or donut chart
- Average Discount by Product — Which products are most discounted
Customer & Channel Insights
- Revenue by Customer Type — Walk-in vs Regular vs Corporate
- Revenue by Order Channel — In-Store vs Online vs WhatsApp etc.
- Revenue by Payment Method
Staff & Operations
- Revenue by Staff Member — Staff performance leaderboard
- Returns Rate (%) — Count of returns ÷ total orders
- Revenue by District — Map visual or bar chart
Time Intelligence (intermediate level)
- Month-over-Month Revenue Growth (%)
- Best-Performing Day of the Week
- Seasonal Trend Analysis (Q4 vs other quarters)
Download now
Download data
