This case study explores Cyclistic bike-share usage patterns, focusing on differences between annual members and casual riders. Using 12 months of trip data, I followed a structured process: data preparation, cleaning, and analysis using R, Python, SQL, Excel, Google Sheets, Tableau and Power BI. The data was unified, duplicates and incomplete entries were removed, and additional columns such as ride length and day of the week were calculated for analysis. Key findings revealed that casual riders typically take longer trips, especially on weekends, while annual members consistently ride throughout the week, contributing to a higher overall number of rides. These insights informed actionable recommendations to convert casual riders into members through targeted marketing campaigns and optimized bike availability during peak times. This analysis underscores the potential to enhance Cyclistic’s membership program and overall customer experience. 

This case study focuses on analyzing smart device usage data to provide actionable insights for Bellabeat, a wellness-focused tech company. Using datasets on activity and sleep patterns, I performed data cleaning and transformation in R, Python, SQL, Excel, Google Sheets, Tableau and Power BI, ensuring consistency and integrity. Key metrics, such as sleep efficiency and activity-to-sedentary ratios, were derived for deeper insights. The analysis revealed that many users exhibit high sedentary minutes and suboptimal sleep efficiency, highlighting opportunities for Bellabeat to target these segments with tailored product features and marketing campaigns. By aligning these insights with Bellabeat's goals, I developed recommendations to enhance customer engagement and drive growth through data-driven strategies. 

This case study analyzes the Amazon Top 50 Bestselling Books (2009–2019) dataset to uncover trends and provide actionable insights for business decisions. By examining key factors such as genre, pricing, user ratings, and author performance, the study highlights differences between Fiction and Nonfiction categories, identifies top-performing authors, and reveals yearly trends in book sales.

I performed data cleaning and transformation in R, Python, SQL, Excel, Google Sheets, Tableau and Power BI, ensuring consistency and integrity.

The findings guide strategies for inventory management, marketing, and pricing optimization, focusing on Nonfiction’s profitability and Fiction’s customer loyalty. Recommendations include leveraging author branding, targeting high-rated books with fewer reviews, and exploring demographic insights for future growth opportunities.

This case study explores "The Movies Dataset" to uncover trends and insights about the film industry. By analyzing data on genres, revenue, ratings, and popularity, I identify patterns that drive box office success. I performed data cleaning and transformation in R, Python, SQL, Excel, Google Sheets, Tableau and Power BI, ensuring consistency and integrity. Key findings include the dominance of Action and Adventure genres, the positive correlation between ratings and revenue, and the impact of popularity on financial performance. This analysis provides actionable recommendations for strategic planning in movie production and marketing.  

This case study delves into historical avocado price and sales data across the United States, uncovering trends that are vital for strategic business decision-making. By analyzing patterns in seasonal demand, regional preferences, and price sensitivity, the study highlights key dynamics in the avocado market. Through data cleaning, transformation, and visualization, six compelling charts provide insights into how factors like seasonality and product type influence pricing and sales volumes.

I performed data cleaning and transformation in R, Python, SQL, Excel, Google Sheets, Tableau and Power BI, ensuring consistency and integrity.

The findings reveal actionable opportunities for businesses, such as optimizing pricing strategies during peak demand periods, targeting marketing efforts in high-demand regions, and leveraging the premium appeal of organic avocados. This comprehensive analysis underscores the value of data-driven approaches to understanding market behavior, enabling stakeholders to maximize profitability while meeting consumer needs.