This is the Dashboard of a company who runs a business of selling hardware and peripheral all over India. Company is facing a problem that the sales of the company are declining. So this Dashboard will help the sales manager to look deep where they need to make changes to improve their sales. In this Project, we use SQL to analyse the data and BI Tool Tableau for cleaning the data such as in zone and currency parameter , removing some of the Null values and to create the Dynamic Dashboard. So following problem statements are covered in this Dynamic Dashboard :
- Revenue breakdown by cities.
- Revenue breakdown by years and months.
- Top 5 customers by revenue and sales quantity.
- Top 5 products by revenue number.
- Profit margin in cities and many more.