Projects I worked on during the Business Intelligence Analyst TripleTen Bootcamp.
| Project Number | Title | Description | Tools |
|---|---|---|---|
| 1 | Zuber Ride-Share Data Analysis | This project analyzes ride-sharing data from Zuber in Chicago to uncover patterns in passenger preferences and assess the impact of weather on ride frequency, providing actionable insights for strategic decision-making. | SQL |
| 2 | Analyzing User Engagement and Retention Metrics for an E-commerce Platform | Analyzed raw transaction logs to build a conversion funnel, perform cohort analysis, and calculate retention rates for an e-commerce company | Google Sheets |
| 3 | Zomato Customer Segmentation Analysis | The Zomato Customer Analysis project segments users based on demographics and purchasing behaviors. By analyzing data, we identify preferences, popular cuisines, and ordering trends to inform targeted marketing strategies and enhance user engagement and satisfaction. | Tableau |
| 4 | Superstore Returns: Analyzing and Reducing Superstore Returns | Analyzed total returns and return rates to identify root causes and generate actionable insights. Utilized data visualization to explore sales correlations, product categories, customer behaviors, geographic trends, and seasonal patterns. Developed an interactive dashboard to enhance decision-making | Tableau |
| 5 | Airbnb Vacation Rental Market Analysis | Analyzed pricing strategies and occupancy rates to identify profitable opportunities in the vacation rental market | Google Sheets |
| 6 | Fresh Beats Music Streaming Data Analysis and Report | Developed a report summarizing key findings and recommendations for Fresh Beats, focusing on artist promotion effectiveness, user engagement, and genre promotion strategies to enhance business performance. | Google Docs |
| 7 | Shopify App Analysis | Analyzes Shopify App Store data to uncover factors influencing app success. Using Power BI, we visualize app statistics, user reviews, and developer responsiveness to provide insights that inform decision-making for app developers and stakeholders. | Power BI |
| 8 | Superstore Analysis: Enhancing Profitability and Operational Efficiency for SuperStore | Analyzed sales, advertising effectiveness, and product returns to provide actionable insights for improving profitability and operational strategies | Tableau |