Skip to content

Latest commit

 

History

History
17 lines (13 loc) · 1.07 KB

File metadata and controls

17 lines (13 loc) · 1.07 KB

Tata-Data Visualization Virtual Experience Program on Forage-2023

TOOLS USED:

  1. Microsoft EXCEL
  2. Tableau Desktop

The main aim of the project gather the data, clean and process the data using excel. Finally create Dashboard using Tableau Desktop. --Gathered business requirements from stakeholders --Pre-processed the dataset by,

                                     Data Cleaning 
                                            The excel data regarding the products sold, along with the revenue generated by each country as cleaned using conditional formatting by checking, errors or missing values, If the unit price is above $0, If the quantity sold is equal to or above 1, Whether the date and time are in correct format.		 
                                     Data Calculations
                                            The revenue generated by each product was calculated by multiplying per unit price.
                                     Data Analysis
                                            Pivot tables were created to understand the trend of the data.