Top 10 Data Analytics, Power BI (PL-300) & SQL Projects for Resume (2026 With Source Code)

1. Executive Revenue & Operations BI Cockpit (Power BI PL-300 Aligned)

Tech Stack: Power BI Desktop, Advanced DAX, Star Schema Modeling, Power Query (M), Row-Level Security (RLS).

Project Overview: Designed an interactive 4-page executive BI dashboard for a multi-regional enterprise with over $45M in annual ARR. Developed 35+ custom DAX measures for Year-to-Date (YTD), Quarter-over-Quarter (QoQ), and Moving Average revenue trends. Implemented dynamic security roles allowing regional managers to view only their assigned territories.

Resume Metric: "Architected an enterprise Power BI reporting cockpit replacing 14 manual Excel spreadsheets, saving 18 executive hours weekly."

2. E-Commerce Customer Lifetime Value (CLV) & RFM Segmentation in PostgreSQL

Tech Stack: PostgreSQL, Analytical Window Functions (NTILE, DENSE_RANK, LAG/LEAD), CTEs.

Project Overview: Analyzed 1.2M historical e-commerce transactions. Built modular SQL queries with recursive CTEs calculating Recency, Frequency, and Monetary (RFM) scores to classify customers into 5 distinct behavioral tiers: Champions, Potential Loyalists, At-Risk, and Churned.

Resume Metric: "Identified a 23% revenue leakage among dormant high-value customers through automated SQL RFM segmentation."

3. Financial Three-Statement Dynamic Valuation Model (Excel & Power Query)

Tech Stack: Microsoft Excel 365, Power Query, Dynamic Arrays (XLOOKUP, FILTER, UNIQUE), Scenario Manager.

Project Overview: Constructed a connected 3-statement corporate financial model (Income Statement, Balance Sheet, Cash Flow) with automated driver assumptions, Discounted Cash Flow (DCF) valuation, and Monte Carlo sensitivity matrices for M&A due diligence.

4. Healthcare Patient Wait Times & Resource Allocation Visual Storyboard

Tech Stack: Tableau Desktop, Level of Detail (LOD) Expressions, Dual-Axis Geo-Mapping.

Project Overview: Ingested hospital admission telemetry to monitor emergency room bottlenecks, bed occupancy rates, and triage-to-treatment turnaround times across 12 medical facilities.

5. Multi-Touch Marketing Attribution & CAC Pipeline (Python & SQL)

Tech Stack: Python, Pandas, NumPy, Plotly, PostgreSQL.

Project Overview: Built a data pipeline attributing user conversions across Google Ads, Meta, LinkedIn, and organic search using First-Touch, Last-Touch, and Linear Attribution models.

6. Supply Chain Logistics & Route Optimization Data Mart

Tech Stack: PostgreSQL, Star Schema Data Mart, Power BI.

Project Overview: Modeled shipping freight delays, on-time in-full (OTIF) fulfillment rates, and third-party logistics (3PL) carrier scorecard metrics.

7. SaaS Churn Early-Warning Dashboard & ARR Retention Matrix

Tech Stack: Power BI DAX, Cohort Retention Curves, Microsoft Fabric.

Project Overview: Calculated Net Revenue Retention (NRR), Gross Revenue Retention (GRR), and monthly logo churn cohorts across subscription tiers.

8. Banking Credit Card Fraud & Risk Analytics Dashboard

Tech Stack: Python, Scikit-Learn (Logistic Regression, Random Forest), Seaborn, Power BI.

Project Overview: Formulated predictive credit risk scoring pipelines evaluating borrower delinquency probabilities with SHAP explainability.

9. HR Workforce Analytics & Attrition Cost Model

Tech Stack: Tableau, Excel Power Query, SQL.

Project Overview: Analyzed employee turnover, compensation competitiveness, and hiring turnaround time to identify department-level burnout risks.

10. Real-Time Streaming Crypto & Market Analytics Web App

Tech Stack: Python, Streamlit, Plotly, WebSockets, Binance API.

Project Overview: Engineered a lightweight real-time financial market analytics web app with live order-book depth charts and volatility indicators.

Want to Build These Projects with 1-on-1 Mentor Guidance & a Paid Internship?

Join the AI Campus Flagship 6-Month Data Analytics & Power BI Track. Master Advanced SQL, Power BI (PL-300), Tableau, and Python, followed by a Guaranteed 6-Month Paid Corporate Internship* with monthly stipend.