Portfolio projects completed during the Business Intelligence Analytics program at TripleTen Bootcamp.
| Project number | Title | Description |
|---|---|---|
| 1 | Zomato Revenue Analysis (Power BI + SQL) | Analyzed Zomato marketplace performance using PostgreSQL and Power BI to identify revenue trends, customer behavior, and operational insights across restaurants and cities. |
| 2 | Shopify App Performance Analysis (Power BI) | Built an interactive Power BI dashboard analyzing Shopify App Store data to identify factors influencing app success, including ratings, reviews, developer responsiveness, and market trends using DAX calculations and data modeling. |
| 3 | Venture Capital Investment Analysis (SQL) | Queried and analyzed startup, funding, acquisition, and investor data using SQL to generate insights on venture capital trends, company performance, and investment opportunities for stakeholder reporting. |
| 4 | Superstore Returns Analysis Dashboard (Tableau) | Developed an interactive Tableau dashboard to identify key drivers of product returns by analyzing return rates across customers, products, geography, and time, with actionable recommendations to reduce return volume and improve profitability. |
| 5 | Superstore Business Performance Dashboard (Tableau) | Built an interactive Tableau dashboard analyzing Superstore profitability, product losses, advertising opportunities, and return rates to identify strategies for improving overall business performance. |
| 6 | Profit Analysis by Product Sub-Category (Tableau) | Created an interactive Tableau dashboard analyzing profit performance across product sub-categories, yearly trends, and geographic regions to identify top-performing and underperforming business areas. |
| 7 | E-Commerce Cohort Analysis (Excel) | Built an interactive spreadsheet analysis using raw website event logs to measure user conversion from product views to purchases, create monthly acquisition cohorts, and calculate customer retention trends to support growth strategy decisions. |