Microsoft Senior AI developer just showed how they build AI agents with Claude at Microsoft.
34-minutes. free. By Microsoft team
Opus 4.7 + 1,400+ pre-built MCP tools
plug Claude into agent → give it tools → ship to production
worth more than any $500 vibe-coding course.
House for rent @ M Arisa Kuala Lumpur
Premium 1LVR 1BR 1BHR M Arisa | 39th Floor (Nice View) | WiFi | Parking | Shuttle to LRT | King Bed | WFH/Gaming Setup | Projector Bedroom | Iced Water Dispenser | Air Conditioner | Water Heater Bathroom | 62" 4K LED TV |
pm @ +60196224016
House for rent @ M Arisa Kuala Lumpur
Premium 1LVR 1BR 1BHR M Arisa | 39th Floor (Nice View) | WiFi | Parking | Shuttle to LRT | King Bed | WFH/Gaming Setup | Projector Bedroom | Iced Water Dispenser | Air Conditioner | Water Heater Bathroom | 62" 4K LED TV |
pm @ +60196224016
𝗦𝗼𝗺𝗲𝗼𝗻𝗲 𝗴𝗮𝘃𝗲 𝗺𝗲 𝘁𝘄𝗼 𝗖𝗦𝗩 𝗳𝗶𝗹𝗲𝘀 𝗮𝗻𝗱 𝘀𝗮𝗶𝗱 “𝗯𝘂𝗶𝗹𝗱 𝗺𝗲 𝗮 𝘄𝗮𝗿𝗲𝗵𝗼𝘂𝘀𝗲.”
“Two sources. Website and mobile app. Should be straightforward.”
Sure. No problem.
(It was absolutely not straightforward.)
𝗙𝗶𝗿𝘀𝘁 𝘀𝘂𝗿𝗽𝗿𝗶𝘀𝗲: 𝘁𝗵𝗲 𝗱𝗮𝘁𝗮.
Before I wrote a single transformation:
→ Currency symbols corrupted at byte level
→ 23 different names for 6 product categories
→ Dates stored in 4 different formats across both files
→ Mobile app hiding promo discounts inside gross totals with no separate column
The data had been “working” for two years.
𝗟𝗲𝘀𝘀𝗼𝗻 𝗼𝗻𝗲: 𝘄𝗼𝗿𝗸𝗶𝗻𝗴 𝗮𝗻𝗱 𝗰𝗹𝗲𝗮𝗻 𝗮𝗿𝗲 𝗻𝗼𝘁 𝘁𝗵𝗲 𝘀𝗮𝗺𝗲 𝘁𝗵𝗶𝗻𝗴.
So I built a proper pipeline:
→ Bronze — raw ingestion, nothing touched, every column NVARCHAR
→ Silver — cleaned, typed, deduplicated, standardised
→ Gold — star schema, surrogate keys, USD conversion, analytical flags
76,685 order lines. Two messy sources. One unified fact table.
𝗧𝗵𝗲𝗻 𝘁𝗵𝗲 𝗮𝗻𝗮𝗹𝘆𝘀𝗶𝘀.
→ RFM segmentation — 22,000+ customers scored and labelled
→ Market basket — what website customers actually buy together
→ Promo effectiveness — the discounts weren’t moving AOV. At all.
→ $500K ad spend recommendation — every dollar backed by two years of revenue data
𝗙𝗶𝗻𝗮𝗹 𝗻𝘂𝗺𝗯𝗲𝗿𝘀:
✅ $9.48M revenue modelled
✅ 7 dimension tables, 1 fact table
✅ 4 analytical deliverables
✅ Full Analytical Engineering project
The warehouse wasn’t the hard part. Trusting the data enough to build on it was.
Full documentation and code:
https://t.co/1H9liLtEm2
#DataEngineering #SQL #DataWarehouse #DataAnalytics #Datafam
You're just one accident, one diagnosis, one unexpected phone call away from a completely different life
So stay humble and never take anything for grant