Data Analytics

BI Dashboards & SQL Insights

Power BI dashboards, ETL pipelines, SQL data models, and KPI reporting systems built for real business intelligence use cases.

Work in Progress: This section is currently under active development. Additional enterprise data pipelines and BI case studies are being formatted for deployment and will be updated soon.

▶

Click to open live interactive report

Power BI Advanced DAX SaaS Metrics Cohort Analysis

InstaWP — SaaS Revenue & Cohort Matrix (PoC)

Engineered an executive-level BI solution using simulated data to demonstrate scalable B2B SaaS analytics. Transformed complex relational structures into actionable subscription metrics—including MRR, LTV, and a dynamic 12-month Customer Cohort Retention matrix via advanced DAX.

SSIS Python SQL Server T-SQL

Automated ETL Data Pipeline

Built a multi-source ETL pipeline using SSIS and Python to extract, validate, transform, and incrementally load institutional data into a normalized SQL Server warehouse — including stored procedures, views, and scalable schema design.

Power BI DAX KPI Design Data Modeling

Sales & Operations KPI Report

Developed an interactive KPI reporting dashboard with custom DAX measures, drill-through pages, and dynamic date intelligence — enabling operations teams to monitor performance in real time across departments and time periods.