End-to-End Healthcare Analytics: Build Your First Fabric Project

Welcome to the full FREE version of the CareOps Healthcare Analytics course using Microsoft Fabric! In this course, you'll learn how to build an end-to-end analytics solution for hospital operations using: Microsoft Fabric Lakehouse Delta Tables & OneLake SCD Type 2 Modeling for Patients Star Schema for Healthcare KPIs Power BI Integration Operational Fact Tables & Efficiency Metrics Purchase the FULL course using link - https://www.udemy.com/course/building... --- 00:00:00 Learners Expectations 00:03:22 Course structure and Real-world problem statement 00:16:47 CareOps Architecture Overview 00:24:57 Generating synthetic healthcare data using Faker Python Library 00:26:18 Creating datasets for Patient Info, Admission/Discharge, Bed Allocation, and Resource Allocation 00:41:06 Ingesting raw synthetic data into Delta tables - Part 1 01:10:50 Ingesting raw synthetic data into Delta tables - Part 2 01:33:17 Validating data quality with SQL queries 01:47:20 Cleansing and enriching raw data from the Bronze layer 02:00:18 Bed Allocation - Data Ingestion and SQL Validation 02:21:12 Implementing SCD Type 2 - Part A 02:37:19 Implementing SCD Type 2 - Part B 02:58:22 Implementing SCD Type 2 - SK Implementation 03:09:15 Creating dimensions (Dim_Date, Dim_Ward) 03:18:46 Building FactPatientAdmissions table and calculating key metrics 03:39:40 Moving transformed data to Fabric SQL DB 03:55:51 Creating a semantic model from fact and dimension tables 04:12:17 Using DAX to create measures 04:19:46 Comparing Precomputed and DAX Metrics 04:25:46 Designing reports and operational dashboards in Fabric 🔔 *Subscribe for more free deep-dive series* on OneLake, Eventstream, KQL, and Fabric projects 👍 Like the video if it helps, and drop your questions in the comments! #MicrosoftFabric #HealthcareAnalytics #Datavion #FabricCourse #OneLake #PowerBI #DeltaTables #SCDType2 #DP600 #DP700