Tableau

1. Data Collection:

• Data related to sales was collected and stored in a database.
• The data was verified to ensure its accuracy and currency.

2. Data Cleaning:

• The data was checked for errors and missing values.
• SQL and Python were used to clean and prepare the data.

3. Requirement Definition:

• Tableau software was chosen to create an interactive dashboard.
• An Excel sheet containing the cleaned data was uploaded to Tableau.

4. Visualization Creation:

• Fields were dragged and dropped to create various visualizations:
  • KPIs for total sales, total profit, and average discount rate
  • Top 5 and bottom 5 selling products

5. Dashboard Creation:

• The visualizations were arranged and formatted within a dashboard.