Building a Real NBFC Analytics Platform from Scratch | Azure SQL, Fabric & Power BI #dataengineering

# YouTube Video Script – NBFC Analytics Project Introduction

Hello everyone and welcome to a brand new end-to-end Data Engineering and Analytics project series.

In this project, I will be building a complete NBFC Analytics Platform using Azure SQL Database, Azure Data Factory, Microsoft Fabric, and Power BI.

The objective of this project is to simulate how a real NBFC organization manages and analyzes its business data to drive better decisions.

For this project, I have created and loaded multiple datasets including customer information, loan applications, active loans, EMI payments, and collections data into Azure SQL Database.

The project will be divided into three major phases.

In Phase 1, we will focus on SQL and solve real business problems that NBFC companies face every day.

Some of the business questions we will answer include:

* Which cities contribute the highest loan disbursement?
* What is the overall loan approval rate?
* Who are the highest-value customers?
* How is the loan portfolio growing month over month?
* Which customers are showing signs of delinquency?
* What is the Portfolio At Risk (PAR 30)?
* How efficient are our collection efforts?

To answer these questions, we will use advanced SQL concepts such as joins, aggregations, common table expressions, subqueries, ranking functions, and window functions.

In Phase 2, we will move into Microsoft Fabric and build a modern data engineering solution.

We will create data pipelines, ingest data into a Lakehouse, implement Bronze, Silver, and Gold layers, perform transformations using PySpark notebooks, and create business-ready data marts.

In Phase 3, we will connect the Gold layer to Power BI and build executive dashboards that help business leaders monitor portfolio performance, customer behavior, delinquency trends, and collection efficiency.

The final architecture of this project will be:

Azure SQL Database → Data Pipeline → Bronze Layer → Silver Layer → Gold Layer → Warehouse → Power BI Dashboard.

This project is designed to replicate real-world analytics and data engineering workflows used in NBFC organizations.

If you're interested in SQL, Microsoft Fabric, Azure, Power BI, Data Engineering, or Analytics, this series will provide a practical end-to-end implementation.

Let's begin with Phase 1 and start our SQL analysis.

Part 1 Coming Tomorrow:
Advanced SQL Analytics

Instagram handle: siddharth_punn10

Видео Building a Real NBFC Analytics Platform from Scratch | Azure SQL, Fabric & Power BI #dataengineering канала AI Data Simplified