Tata_forage_Datavisualization_project

INTRODUCTION

This is a virtual internship Programme case study with the company TATA. This program is hosted through the site called “Forage”. This internship helps to learn data basics such as data cleaning, modelling, visualization and storytelling.

PROJECT SCENARIO

An online retail store has hired a consultant to review their  data and provide insights that would be valuable to the CEO and CMO of the business. The management wants to analyse what the major contributing factors are to the revenue so they can strategically plan for next year. Suggest metrics that would enable them to make the decision on expansion.

Dataset Summary

InvoiceNo   column has invoice number of each purchase made by customers

StockCode has the products stock code.

Description has the products description and information.

InvoiceDate has dates from when the purchase happened.

UnitPrice has the price of the product.

CustomerID tells us who purchased the product in numerical

Country is where the customer resides in.

DATA PREPARATION & DATA PREPROCESSING

ü  Excel to clean the dataset with the following steps:

ü  Removed Rows in the Quantity column showing negative numbers or below 1

ü  Removed Rows in the UnitPrice column that are below $0

ü  Removed Rows with blanks

***Added Revenue Column from multiplying UnitPrice with Quantity