Skip to content

This is a predictive data analysis & data visualization [Google Data Studio] project based on E-commerce Store Open Source Data.

License

Notifications You must be signed in to change notification settings

SabbirAlFahad/E-commerce-Store-Data-Analysis-Yearly

Repository files navigation

E-commerce-Store-Data-Analysis-Yearly

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

About

This is a predictive data analysis & data visualization [Google Data Studio] project based on E-commerce Store Open Source Data.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published