← Portfolio Dashboard / BI

Retail Sales & Inventory Warehouse

Kimball data warehouse and Power BI reporting giving a multi-site retailer a single view of sales and stock.

Delivered a dimensional data warehouse for a multi-site retailer using Kimball methodology. Modelled fact tables for sales and inventory movements against shared date, product, store and supplier dimensions, feeding a suite of Power BI dashboards.

Merchandisers gained daily visibility of sell-through, stock cover and slow-moving lines across all stores, replacing fragmented per-store reports with one governed source of truth.

Technologies Used

SQL Server T-SQL Kimball Power BI DAX SSIS

Related Projects

NH
Dashboard / BI

NHS Trust Operational BI Platform

Executive Power BI suite unifying A&E, bed capacity and staffing data into real-time operational dashboards.
IN
Dashboard / BI

Insurance Claims Analytics Dashboard

Claims performance dashboard tracking loss ratios, fraud indicators and settlement times for an insurer.