5d (edited) • General Discussion
Building a DP-700 Case Study from Scratch: Rental Analytics with Medallion Pattern
Building a case-study project for DP-700 certification prep and would love feedback on the concept (happy to discuss the implementation details later).
🎯 THE IDEA:
HobbyTools CZ – rental company with 3 locations, 50+ tools, profitability challenges
❌ PROBLEMS:
- Data scattered across Excel, SharePoint, paper
- Don’t know which equipment is losing money
- No prediction of tool failures
- Can’t measure team productivity per location
✅ SOLUTION – Fabric lakehouse with Medallion Pattern:
📋 INGESTION (Dataflow Gen2)
├─ SharePoint rentals
├─ Excel tools list
├─ Repair APIs
└─ IoT telemetry (usage hours)
🟤 BRONZE (Raw tables)
├─ bronze_rentals
├─ bronze_tools
├─ bronze_repairs
├─ bronze_staff
└─ bronze_tools_telemetry
🟡 SILVER (Cleaned + typed)
├─ silver_rentals (no duplicates, validated)
├─ silver_tools_health (damage rates)
├─ silver_repairs (categorized)
└─ silver_staff_daily (aggregated metrics)
🟢 GOLD (KPIs ready for BI)
├─ gold_rental_profitability (% loss per tool)
├─ gold_tool_reliability (damage rate)
├─ gold_maintenance_forecast (when to fix?)
├─ gold_staff_productivity (revenue per person)
├─ gold_category_performance (best ROI)
└─ gold_customer_lifetime_value
📈 POWER BI
├─ Rental Performance dashboard
├─ Tool Health Alerts
├─ Staff Productivity
└─ Financial Overview
🔧 TECH STACK:
✅ Dataflow Gen2 (no-code ingestion)
✅ PySpark (transformations)
✅ Delta Lake (versioned tables)
✅ Power BI (visualizations)
✅ Fabric Scheduler (orchestration)
🎓 WHY THIS PROJECT:
- ✅ Covers 100% of DP-700 exam topics
- ✅ Real-world business problem (not toy example)
- ✅ End-to-end workflow (ingestion → processing → visualization)
- ✅ Runnable with synthetic data (no need for real data)
🙋 QUESTIONS FOR YOU:
1) Is a rental business a good case study for Fabric?
2) Is the medallion structure solid or would you suggest a different approach?
3) Any additional KPIs you’d recommend tracking?
4) What do you find most challenging in DP-700 prep?
So what do you think?
Is it a good idea? Or if there are similar solutions stored here, will this be discussed as an end-to-end project here on Forge?
❓ 👏🎻
2
0 comments
Building a DP-700 Case Study from Scratch: Rental Analytics with Medallion Pattern
skool.com/fabricforge
Forge real Microsoft Fabric & Power BI skills through structured lectures, hands-on exercises, and a supportive learning community.
Leaderboard (30-day)
1
+27
2
+23
3
+15
4
+15
5
+13
Powered by