instructions tasks data exploration and cleaning import the 2 datasets
Search for question
Question
INSTRUCTIONS
Tasks:
Data Exploration and Cleaning:
Import the 2 datasets to excel and examine the structure.
Clean the data if there are any inconsistencies or missing values.
Then once the data is clean, upload each to tableau.
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.
Presentation:
Summarize your findings in a clear, concise presentation within Tableau.