Project Overview:

Built dashboards where you can trace revenue numbers, sales Quantity, profit margin, revenue contribution, top customers, top products, etc., for a hardware company located all over India. I have published those documents on the web as well as in mobile applications.

https://app.powerbi.com/groups/me/reports/8797f05a-6016-4aaf-a56e-532305979789/ReportSectionaf7031103000119047e0?experience=power-bi

The dataset used (available on GitHub)

Data-visualization

Problem Statement:

“Atliq” is a hardware company located all over India. Sales have been declining for the past few months. The company wants insights into the issues regarding business. Tracking all the records in a dynamically growing market is challenging. Reviewing large Excel is tedious. It will be better if we provide dashboards for stakeholders.

Business Problem:

• Limited visibility into sales performance, profitability, and growth over time
• Difficulty in identifying areas for improvement in the sales process
• Need to increase revenue and optimize sales and marketing strategies

Project Planning using AIM’s Grid:

Purpose: To unlock sales insights that are not visible before for the sales team for decision support & automate them to reduce manual time spent in data gathering.

Stakeholders:

• Sales Director
• Marketing Team
• Customer Service Team