Data & BI Portfolio

Data & BI Portfolio
Five end-to-end analytics projects — from raw data to actionable insight. Built with Power BI, SQL, and Python. Designed for decision-makers.
Project 01
US Health Insurance Coverage Analysis Dashboard
Tools: Power BI • SQL • Python • Excel • DAX • Power Query
Project Overview
Interactive Power BI dashboard analyzing US health insurance coverage trends across demographics, states, and income levels using CDC and Census Bureau data.
Business Problem
Which populations remain underinsured, and what socioeconomic factors most strongly predict coverage gaps?
Key Insights
Southern states show the highest uninsured rates, strongly correlated with Medicaid non-expansion
Young adults aged 18–34 represent the largest underinsured demographic
Household income is the single strongest predictor of coverage status
Skills Demonstrated
Data Cleaning & Modeling
DAX & Power Query
SQL & Python
Dashboard Design & BI
Business Impact
Enables policymakers and insurers to target outreach programs, allocate resources efficiently, and design interventions for the most vulnerable populations.
Project 02
D2C Skincare Sales & Customer Analytics Dashboard
Tools: Power BI • SQL • Python • Excel • DAX • Power Query
Project Overview
End-to-end analytics solution for a direct-to-consumer skincare brand, tracking sales performance, customer segmentation, and product-level profitability.
Business Problem
Which customer segments drive the highest lifetime value, and which products contribute most to margin erosion?
Key Insights
Repeat purchasers account for 62% of total revenue despite representing only 28% of customers
Premium serums carry the highest margin but the lowest repurchase rate
Seasonal campaigns in Q4 generate 3× the average order value
Skills Demonstrated
Data Cleaning & Modeling
DAX & Power Query
SQL & Python
Dashboard Design & BI
Business Impact
Supports targeted retention campaigns, informed product pricing decisions, and optimized marketing spend allocation.
Project 03
Netflix Content Analysis Dashboard
Tools: Power BI • SQL • Python • Excel • DAX • Power Query
Project Overview
Comprehensive content intelligence dashboard analyzing Netflix's global library — genres, ratings, release trends, and regional distribution patterns.
Business Problem
What content strategies correlate with higher viewer engagement, and where are the gaps in Netflix's regional catalog?
Key Insights
Documentaries and international originals show the strongest rating-to-cost ratio
Asian content production has grown 140% since 2019, outpacing all other regions
TV series significantly outperform films in average viewer retention metrics
Skills Demonstrated
Data Cleaning & Modeling
DAX & Power Query
SQL & Python
Dashboard Design & BI
Business Impact
Provides content acquisition teams with data-driven recommendations for licensing priorities and regional investment strategies.
Project 04
NYC Taxi Trip Analysis Dashboard
Tools: Power BI • SQL • Python • Excel • DAX • Power Query
Project Overview
Large-scale trip data analysis covering millions of NYC yellow taxi rides — exploring fare patterns, demand hotspots, and temporal trends.
Business Problem
When and where does taxi demand peak, and what factors most influence fare variability and trip duration?
Key Insights
Friday evenings in Manhattan generate 40% higher average fares than weekday mornings
Weather events cause a measurable 15–20% spike in short-distance trip volume
Tip rates correlate strongly with trip duration, not fare amount
Skills Demonstrated
Data Cleaning & Modeling
DAX & Power Query
SQL & Python
Dashboard Design & BI
Business Impact
Helps fleet operators optimize driver deployment, supports dynamic pricing models, and informs city transport planning decisions.
Project 05
Credit Risk & Customer Behavior Dashboard
Tools: Power BI • SQL • Python • Excel • DAX • Power Query
Project Overview
Risk intelligence dashboard combining credit scoring models with behavioral segmentation to assess loan default probability and customer risk profiles.
Business Problem
Which customer attributes most accurately predict default risk, and how can lenders balance approval rates with portfolio safety?
Key Insights
Debt-to-income ratio outperforms credit score as a standalone default predictor
Customers with 2+ active credit lines show 30% lower delinquency rates
Early repayment behavior is a strong positive signal for future creditworthiness
Skills Demonstrated
Data Cleaning & Modeling
DAX & Power Query
SQL & Python
Dashboard Design & BI
Business Impact
Empowers lending teams to make faster, more accurate credit decisions while reducing portfolio risk exposure and regulatory compliance burden.
Made with