Products and Categories Analysis





The dashboard created for the project

Overview

This project involved analyzing different best selling products under their respective categories for a consulting agency operating and managing in different markets.

Process

• Extracted data from live servers hosted on Azure
• Cleaned data using Excel and Python using different data cleaning techniques
• Narrowed down the top 3 most important regions of sale
• Performed EDA and feature importance to analyze according to the regions
• Created visualizations to highlight questions and parameters
• Compiled a dashboard to finalize the analysis and results

Output

The final output was given to the client in the form of a Tableau workbook containing visualizations and dashboard and a word document containing analysis and insights