In this Cyclistic bike-share case study, I analyzed usage patterns to identify differences between annual members and casual riders. The analysis was conducted in Python, following a systematic approach that included data preparation, cleaning, and analysis. I unified the datasets, removed duplicates and incomplete entries, and created additional columns such as ride length and day of the week for further analysis. The findings revealed that casual riders tend to take longer trips, particularly on weekends, while annual members have more consistent usage throughout the week, resulting in a higher overall number of rides. These insights led to actionable recommendations aimed at optimizing the bike-share system. I have attached both the Python code used for this analysis and a detailed Medium blog explaining the code and the insights derived from this case study.

This case study delves into the analysis of smart device usage data to uncover actionable insights for Bellabeat, a wellness-focused technology company. Leveraging datasets on activity and sleep patterns, I performed data cleaning and transformation in R to ensure data consistency and integrity. Key metrics, such as sleep efficiency and activity-to-sedentary ratios, were calculated to gain deeper insights. The findings revealed that many users have high sedentary minutes and suboptimal sleep efficiency, presenting opportunities for Bellabeat to target these segments with customized product features and marketing campaigns. By aligning these insights with Bellabeat's objectives, I developed recommendations to enhance customer engagement and promote growth through data-driven strategies. The Medium blog explaining the process and the GitHub file containing the Python script are attached here for reference. 

This case study explores the Amazon Top 50 Bestselling Books dataset (2009–2019) to identify trends and derive actionable insights for informed business decisions. By analyzing aspects such as genre, pricing, user ratings, and author performance, it uncovers differences between Fiction and Nonfiction, highlights top-performing authors, and tracks yearly sales trends. These insights inform strategies for optimizing inventory management, marketing, and pricing, emphasizing Nonfiction’s profitability and Fiction’s potential for building customer loyalty. For a more detailed understanding, refer to the attached Medium blog and accompanying Python code.

This case study delves into "The Movies Dataset" to uncover key trends and insights related to the film industry. Through an examination of genres, revenue, ratings, and popularity, I uncover patterns that contribute to box office success. Notable findings include the dominance of Action and Adventure genres, a positive relationship between ratings and revenue, and the influence of popularity on financial outcomes. These insights lead to actionable recommendations for strategic decision-making.

This analysis is done using Python, and you can refer to the attached Python code and my Medium Blog for a detailed explanation of the process.

This Python-driven case study explores historical avocado price and sales data across the United States, providing valuable insights for strategic business decision-making. By analyzing seasonal demand trends, regional preferences, and price sensitivity, we uncover critical market dynamics. Through robust data cleaning, transformation, and visualization techniques, we present six impactful charts that reveal how seasonality and product types influence avocado pricing and sales volumes.

Key findings include actionable strategies such as optimizing pricing during peak demand, focusing marketing efforts on high-demand regions, and capitalizing on the premium appeal of organic avocados. This analysis emphasizes the power of data-driven approaches in understanding market behavior, enabling businesses to enhance profitability while addressing consumer needs.

For an in-depth understanding of this analysis, refer to the attached Python code and Medium blog.