Step 1: Use Tableau for make data modeling
Data: Superstore.xlsx – Google Sheets
Data Exploration: Explore the dataset to understand its structure, variables, and any relevant data preprocessing steps required.
Data Cleaning and Preparation: Clean and preprocess the data as necessary, handling missing values, formatting issues, and ensuring consistency. You can do it on excel or on Tableau
Data modeling: Use Tableau to perform data modeling, define relationships, primary and foreign key
Step2: Use Tableau for Visualization and reporting:
Visualization: Create visualizations using tools like Tableau, or Python libraries such as Matplotlib or Seaborn. You should use appropriate chart types and visuals to effectively communicate insights from the data.
Managerial dashboard: Based on the analysis and visualizations, prepare a managerial dashboard summarizing their findings. The report should include an executive summary, key insights, trends, and recommendations based on the data analysis: all visualizations should change based on a parameter that you define.
Submit the steps you have taken to achieve the report in PDF format and submit the final report in .twb format