DP-600: Transforming COVID-19 Data: Star Schema, KPIs, and Feature Engineering
In this video, we focus on designing a star schema for COVID-19 analytics using Microsoft Fabric. Watch as we transform the raw COVID-19 dataset into structured data, applying feature engineering to calculate key metrics like cumulative cases, deaths, and rolling averages. We also demonstrate the integration of location and date dimensions, building a powerful semantic model for advanced data analytics.
Google classroom community:
https://classroom.google.com/c/Njk4MD...
Whether you're working with structured or unstructured data, this walkthrough will equip you with techniques to manage fact tables and dimensions in Microsoft Fabric.
Agenda:
00:00 Module 2 - Prepare and Serve Data - Transform data - Overview and Course Roadmap
02:40 Google classroom community overview
03:55 Data cleansing and Building Medallion LakeHouse Architecture
07:50 Build STAR SCHEMA: FACT and DIM tables with Medallion LH Architecture DEMO - using COVID 19 REAL WORLD Dataset
52:16 SCD Type 1 and Type 2 basics and COVID 19 use case
58:18 Star schema basics - Conceptual understanding
01:02:57 BRIDGE Table - Concept understanding
01:05:53 Summary
#DataAnalytics #MicrosoftFabric #COVID19Analytics #StarSchema #DataEngineering #DataTransformation #FeatureEngineering #PowerBI #DataScience #KPIAnalysis #BusinessIntelligence #DataModeling #BigData #Azure #DP600