This project provides informative insight from the visualizations of data for a top brand of a global lighting and entertainment manufacturer. These visualizations provide reporting to brand management on various metrics and further provide the ability to check brand and product consistency across the sales network.
In this project, the team has implemented the following for our visualizations:- Created & Configured an API with Google Analytics
- Created & Configured an API with Mapbox for plotting
- Created & Exported several datasets for various types of visualizations
- Conducted Web Scraping in Pandas of multiple websites
- Conducted ETL in Python
- Created a PostgreSQL schema and imported the data
- Setup Python Flask RESTful API with SQLAlchemy
How many Visitors visit the website?
- This visualization shows realtime visits, including weekly & yearly comparisons, using the power of chart.js with an API. Check it out!
What Product Pages are Visited Most?
- This visualization shows the amount of pageviews for the top 10 products on the website since January 1, 2020. Check it out!
Where are the Dealers who Sell the Product?
- This interactive visualization plots each domestic dealer in the United States. Check it out!
How are the Dealers' Websites representing the Top Product?
- This interactive visualization shows the results of web scraping dealers' sites. Check it out!