Clean the data set if there are any inconsistencies. I have uploaded the picture of the directions. Make sure the excel file is ready to be used for Tableau.
Directions:
Data Exploration and Cleaning:
Import the dataset and examine the structure.
Clean the data if there are any inconsistencies or missing values.
Visualization:
Create a dashboard with the following visualizations:
Sales trends over time, broken down by product type.
Comparison of actual vs. budgeted sales and profits.
Profit margins by state and market size.
In-Depth Analysis:
Analyze how different factors (market size, state, product type) impact sales and profits.
identify the best and worst-performing products.
Insights and Recommendations:
Develop insights on how to increase profitability.
Suggest strategies to improve underperforming products or markets.
Download:
Bookshop.xlsx
CoffeeChain Query.xisx