The data analysis part of this case study has been done by Tableau, and you can see the attached Medium blog and the shared Tableau Vizes for better understanding. This case study explores Cyclistic bike-share usage patterns, focusing on the differences between annual members and casual riders. Using 12 months of trip data, I followed a structured process of data preparation, cleaning, and analysis. 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.
Thought Process in Tableau
Video
The data analysis part of this case study has been done by Tableau, and you can see the attached Medium blog and the shared Tableau Vizes for better understanding. 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, 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.
Thought Process in Tableau
Video
The data analysis part of this case study has been done by Tableau, and you can see the attached Medium blog and the shared Tableau Vizes for better understanding. 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. 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.
Thought Process in Tableau
Video
The data analysis part of this case study has been done by Tableau, and you can see the attached Medium blog and the shared Tableau Vizes for better understanding. 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. 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.
Thought Process in Tableau
Video
The data analysis part of this case study has been done by Tableau, and you can see the attached Medium blog and the shared Tableau Vizes for better understanding. 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. 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.
Organic avocados consistently have higher average prices than conventional ones, reflecting their premium nature and possibly higher production costs.
Thought Process in Tableau
Video