Industry-Integrated Projects
Unit I · Retail Sales Analysis & Excel Dashboard
- Clean & prepare transactional data; compute KPIs (AOV, CTR, revenue).
- Pivot-based category trends, region mix; slicers for month/segment.
Unit II · Healthcare Treatment Outcome Optimization
- Hypothesis testing on recovery outcomes; logistic regression (optional).
- Prescriptive what‑if and Solver for plan recommendations.
Unit III · Sales Performance Dashboard in Power BI
- Power Query transformations; star schema; visuals & bookmarks.
Unit IV · Customer Behavior & DAX KPIs
- CLV, repeat purchase rate, cohort retention with measures & calculated columns.