Ask for help with the exercise here, but please do not reveal the entire solution.

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?

Did you get a chance to watch the MCP servers video in Fabric Fundamentals course? Hope this made some of the concepts clearer for you 🤓 Would you also like to see how to use MCP servers for Fabric in practice?

Give us feedback about the course: - What did you like? - What could be improved? - Something else you would like to comment? We are constantly looking for ways to improve so your feedback is valuable.

Would it be helpful if we created study guides for both exams here? These study guides would be a collection of official and community-created resources and would also highlight which of our courses are relevant for each exam. I have seen many people mention that they are planning to take these exams.