This is a predictive data analysis & data visualization project based on E-commerce Store Open Source Data.
** Ultimate goals to achieve with this E-commerce open source data.
Questions:
How we are doing yearly?
Where the orders are coming from?
What day do we make the most average revenue/ money?
What products make the most revenue/ money?
Answer: Interactive Dashboard Link: https://datastudio.google.com/reporting/f92f2f4c-d569-4ecb-815b-8c3e1d74d3a6 Report also attached in this repository.
Tools & Extension used:
Google Data Studio,
Google Spreadsheet, Excel
Coupler.io [Google Workspace Marketplace]
Data Source: Open Data Source. Data Timeline = 2010 - 2012
Process:
==> LOADING DATA:
Data Cleaning, Data Validation, Data Modification
==> CALCUALTED FEILDS & FUNCTIONS: Adding Calculated Fields, Visualization Objectives, Using Functions, Pivot Tables and Sorting
==> BLENDING DATA & MAPS: Adding and Blending Data [ Ecommerce-Data.csv & US holidays.csv ], Left Join [ Ecommerce-Data.csv & US holidays.csv ], Finding Null Values, CONTROLS AND FILTERS, Date Controls, Comparing Dates, Drop Down Filter, Maps Integration