This project is part of the Advanced Data Visualization with Tableau course, where I analyzed data collected from City Harvest, a small fictional grocery store in San Francisco. The goal was to visualize and gain insights into the store's sales, website development, online checkout process, and delivery radius using Tableau.
The datasets used for this project include:
- Grocery Sales Data: Contains information about the store's sales, including product categories, total units sold, revenue, promotions, costs, and profit.
- Website Project Data: Includes the project plan for creating the delivery website, with tasks, assigned team members, task durations, and start and end dates.
- Online Checkout Data: Provides details on the stages of the online delivery checkout process, including product selection, payment, and order completion.
- San Francisco Spatial Data: Holds geographic information about the neighborhoods in San Francisco, used for determining the delivery radius.
- Analyze sales data to identify trends and patterns.
- Visualize the website project plan and progress.
- Understand the customer journey through the online checkout process.
- Determine the optimal delivery radius using spatial data.
- Tableau for data visualization
- Excel/Google Sheets for basic data cleaning
- GitHub for version control and project documentation
- Sales dashboards showing product performance and revenue trends.
- Gantt charts for visualizing website project timelines.
- Funnel charts illustrating the online checkout process.
- Geographic maps highlighting delivery radius and customer locations.
Saved the Tableau visualizations to my Tableau Public account and also exported the visualizations in .pptx format which are uploaded in this repository. You can also access them using the below links. https://public.tableau.com/views/VisualizationsusingGrocerySalesData/Sheet1?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link https://public.tableau.com/views/VisualizationusingWebsiteProjectData/Sheet1?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link https://public.tableau.com/views/DataVisualizationusingOnlineCheckoutData/Sheet1?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link
- Identified top-performing product categories and sales trends.
- Gained insights into the progress and potential bottlenecks in the website development.
- Understood customer drop-off points in the online checkout process.
- Determined the optimal delivery radius based on customer density and geographic data.
This project was completed as part of the Advanced Data Visualization with Tableau course on Coursera.