VELNAR - Turning data into decisions
DEMONSTRATION PROJECT — SYNTHETIC DATA

← Back to Case Studies

Retail Business Intelligence Dashboard

Power BI & Business Intelligence. A demonstration of how fragmented retail data can be transformed into an interactive reporting environment.

Executive Overview tab with KPI cards and quick insights
Executive Overview: headline KPIs, quick insights and trend charts driven by one set of filters.
Sales by category, region, payment method, order status and top 10 products
Sales by category and region, payment mix, order status and the top 10 products.
Product Performance tab with gross profit by category and sales by brand
Product Performance: gross profit by category, sales by brand, top and bottom 10 products.
Secure sign-in screen of the sales dashboard
Branded, secure sign-in screen.

Business Challenge

Sales, inventory and customer data live in separate files and systems. Managers spend time reconciling reports instead of acting on them.

Data Structure

A star-schema model: a sales fact table linked to product, branch, customer and date dimensions, so every measure can be filtered consistently.

Dashboard Design

An overview page with KPI cards for Total Revenue, Total Orders and Average Order Value, followed by sales trend, product and branch views, with slicers for date, branch and category. The dashboard is organised into five views (Executive Overview, Product Performance, Customer Analysis, Sales Team & Shipping and Data Quality), with a secure sign-in, filters for month, region, category, brand, segment, city and payment method, and one-click CSV export.

Key Insights

Synthetic data only. The design shows how a single view can reveal which branches and products drive revenue and how sales move over time.

Business Recommendations

Standardise KPI definitions across branches, review weak-performing products against stock levels, and schedule data refreshes so reports stay current.

← Back to Case Studies