AtliQ Hardware Sales Analysis

AtliQ Hardware

• Is a company which supplies computer hardware and peripherals to many clients across India;
• The company has a head office in Delhi and regional offices throughout India.

Business Issue

The sales director is facing a lot of challenges such as:

The marketing is growing dynamically and then he’s struggling in terms of tracking the sales, needing more accurate insights about the company sales, and then take the necessary decisions.

Imagine the scenario:

The sales director need to know how the sales are going in all operations and the information provided by the regional sales managers are not being enough.
Just hearing the numbers or receive tons of excel files is far from being effective in terms of having a reliable overview of the business.
Instead, he want to be able to look at the data and understand what’s going on right away.

Solution

Create a simple and informative dashboard about the company sales.

ETL (Extract, Transform, Load)

Once I know the basic features of the data I have to work with, I imported the MySQL database into Power BI.

Data Transformation in Power BI

Once the data is imported in Power BI, we do ‘transform data’ i.e. using Power Query editor to perform certain operation on to the data. Ensuring correct data types, creating custom/conditional columns are some fundamental task performed in Power Query.

Modeling Schema in Power BI

Created 'one to many' relationship model between dimension table and fact table using primary key and foreign key concept.

Created Measures

Created required measures using aggregation, filter DAX functions.

Creating a Report in Power BI

A report is created in Power BI with various charts depicting Revenue by Market, Sales Quantity by Market, Revenue Trend, Top 5 Customers by Revenue, Top 5 Customers by Quantity, Revenue by Zone, Sales Quantity by Zone and KPI such as Total Revenue & Total Sales Quantity. All these charts can be filtered using Year and Months slicer.

Deployment in Power BI

In Power BI, You can directly publish the report online to your workstation. If you do not have the work email-id then you can save the file in ‘.pbix’ version. This helps another viewer see your work and understand the story or insights you’re communicating.

Final Report

Based on the dashboards insights, I have made some conclusions and recommendation that Sales Marketing team should/can consider making a sales strategy.

Conclusions

1. Sales were rapidly decreasing in 2020 compared to 2019.
2. Highest revenue generated from markets such as Delhi NCR, Mumbai, Ahmedabad, Bhopal, Nagpur and so on.
3. Highest quantities sold in Markets such as Delhi NCR, Mumbai, Nagpur, Kochi, Ahmedabad and so on.
4. The most important customer for company is Electricalsara Store by Revenue as well as quantity sold.

Recommendations

1. Make a new sales strategy for lucknow since its showing lowest revenue and negative profit margin and if possible so as for Surat and Bhubaneshwar also.
2. Try to increase sales quantity in Patna, Surat and Kanpur since they have lowest sales quantity.
3. Try to give special benefits to Electronics and Excel stores as they are most profitable customers.
4. Make campaign strategy for mid year as they are showing high sales among other months.