From Raw Pharma Data to Star Schema: SQL Server + Power BI Explained!

Transform raw Pharma Data into powerful insights using SQL Server and Power BI!
complete source file: https://drive.google.com/drive/folder...
In this tutorial, you’ll learn how to design and build a complete Star Schema for pharma sales data, create dimension and fact tables in SQL Server, and load everything into Power BI for analytics and dashboards.

Whether you're a beginner or experienced in data engineering, this step-by-step walkthrough will help you understand:

🔹 How to inspect raw pharma datasets
🔹 Designing an efficient Star Schema
🔹 Creating Dim & Fact tables in SQL Server
🔹 Performing ETL to populate your model
🔹 Connecting Power BI to SQL Server
🔹 Building a clean, optimized data model
🔹 Preparing your data for reporting & dashboards

Perfect for Data Analysts, Power BI users, SQL learners, and anyone working with healthcare or pharma datasets.
00:00 – Introduction

Brief overview of the tutorial and what the session will cover.

00:08:02 – Pharma Raw Data Overview
00:12:33 – Overview of Completed Project
00:18:07 – Inspection of Raw Pharma Data for Star Schema Transformation
00:20:04 – Working in SQL Server: Creating a Database for Importing Raw Data
00:22:03 – Import Process of Pharma Raw Data
00:24:06 – Reviewing the Data Model in Star Schema
00:28:00 – SQL Tutorial: Creating a Star Schema from Pharma Raw Data
00:30:07 – SQL for Channel Dimension
00:32:04 – SQL for Sub-Channel Dimension
00:36:04 – Creating Distributor Dimension
00:38:17 – Creating Country Dimension
00:44:09 – Creating City Dimension
00:48:03 – Creating Customer Dimension
01:02:04 – Creating Month Dimension
01:08:05 – Removing Redundant Column from Pharma-Data Table
01:18:00 – Testing Transformed Data in SQL Server + Power BI
01:39:51 – Working on Product Details Page

Building and refining product-level analysis.

01:41:16 – Top 10 Products Using Top N Filter

Applying Top N logic to highlight best-selling products.

01:46:02 – Start Working on Pharmacy Data Analysis Dashboard (Executive Summary)
01:48:10 – Formatting the Matrix Visual for Monthly Product Sales

Styling and improving the matrix visual.

01:51:42 – Working on Customer Details Page

Constructing customer-level analytics.

01:58:03 – Ending Remarks

Wrap-up and final thoughts.

02:18:03 – Working on Distributor & Customer Analysis
02:42:04 – Working on Sales Team Analysis Dashboard