This project is about finding the sales analysis of Atliq Technologies using BI reports
Live Dashboard: https://www.novypro.com/project/atliq-sales-insights-project
Blog: https://medium.com/@Kavya2099/improving-sales-insights-with-power-bi-1430eee90fb6
AtliQ Hardware, with multiple branches across India, provides computer hardware and peripheral manufacturers to its clients. The sales director is encountering difficulties in comprehending the company's current issues and performance, as sales are decreasing below expectations.
Whenever the director seeks updates from regional managers regarding sales and the market, they tend to sugarcoat the truth and send excessive Excel files, adding to the director's frustration. The frustration is understandable, as humans often find it challenging to comprehend numbers from Excel files.
As a data analyst, a solution to address the sales director's problem at AtliQ hardware would be to BI dahsboards that can help with data visualization and analysis. The sales director can use dashboard that pulls in data from various sources, including the company's sales data, market trends, and regional manager reports. With the dashboard, the sales director can easily see the current state of the business, identify problem areas, and make data-driven decisions.
By having a clear, visual representation of the data, the sales director can also avoid relying on Excel files and sugar-coated reports from regional managers, which can lead to misunderstandings and frustration.
We are provided with the SQL dataset which contains customers, date, transactions, markets, and products tables. We need to provide insights using the data from those tables
- Finding Profit Margin, Sales Quantity and Revenue made in each year/month
- Analyzing top 5 customers and product by revenue
- Finding the Revenue Margin Contribution, Profit Margin Contribution and Profit % by each customer
- Finding the Revenue Margin Contribution, Profit Margin Contribution and Profit % by each Market
- Finding the Revenue trend by years
- Analyzing Revenue contribution by customer type
- There is a decrease in the revenue trend from 2017-2020
- Delhi NCR is the highest contributor in Revenue and Sales quantity by Market
- E-commerce gives the highest revenue contribution by customer type
- Surat gives highest profit % by market
- Central Market contributes to more Revenue