Project
2026: Microsoft Fabric – UK logistics
Scenario: A fictional UK-based logistics enterprise operates four source systems that, in real life, would sit in separate platforms: a Transport Management System (TMS), a Warehouse Management System (WMS), an ERP system handling sales orders, and a Fleet Management System (FMS).
The data is synthetic but built to be internally and cross-system consistent — shared customers, products, locations, carriers, and equipment; realistic costs, distances, and transit times; and dates that move logically from order to pick to pickup to delivery.
Goal
Microsoft Fabric & Power BI End-to-End Build
An end-to-end Microsoft Fabric build: Lakehouse, PySpark notebooks, medallion architecture (Bronze/Silver/Gold), and a Power BI semantic model and report on top.
Key Features
🏗️ Medallion lakehouse (Bronze → Silver → Gold)
📊 Galaxy schema across four source systems
🔗 Cross-system lineage
📐 65 DAX measures
📈 Five-page Power BI report
The project source files are availble on GitHub
DOWNLOAD FROM GITHUB
2. Sales & Customer Performance
3. Warehouse Distribution
4. Transport & Carrier Operations
5. Fleet & Maintenance
Let's Build Something
If you are interested in hiring me for a project, would like to collaborate, or have a question, Just drop me a message.
Darryl Brown
Data Analyst working with Microsoft Fabric, Power BI, Excel, SQL, Python and R. I love learning about tech, working on my NAS/Homelab and 3D printing and modelling.
