This repository provides a detailed analysis of Atliq Hardware’s Sales and Finance data for the years 2019–2021. It includes:
- Sales Reports: Insights into customer performance, market analysis, top-performing products, and more.
- Finance Reports: A comprehensive Profit & Loss statement segmented by year, month, and market, including a detailed gross margin analysis.
The goal of this repository is to provide actionable insights to help Atliq Hardware optimize its sales performance and improve profitability.
Atliq Hardware is a global B2B company specializing in the sale of computer hardware products such as:
- PCs 💻
- Mice and Keyboards ⌨️ 🖱️
- Printers 🖨️
- Other Computer Peripherals
The company serves clients worldwide, offering tailored hardware solutions to meet the unique needs of businesses. Atliq Hardware focuses on delivering high-quality products and aims to build long-term relationships with its clients.
-
B2B Business Model Image
In recent years, Atliq Hardware has faced significant financial losses.
To overcome these challenges, the company needs to:
- Optimize Sales Performance
- Improve Net Gross Margins
The goal of this project is to create a detailed Sales and Finance Report for Atliq Hardware covering the period 2019–2021. This report will help management make strategic decisions to improve efficiency and drive sustained growth.
- Microsoft Excel 📊
- Microsoft PowerPoint 🎞️
- ETL Methodology: Mastery of the Extract, Transform, Load process.
- Data Modeling: Establishing relationships between tables.
-
Power Query: Generating date tables and deriving fiscal months/quarters.
-
DAX Measures: Crafting calculated columns for advanced analytics.
- Designing user-friendly Sales & Finance Reports ✨
- Systematic report planning and optimization 📋
- Attention to detail in report fine-tuning 🔍
The Sales Report includes the following:
- Customer Performance Report
- Market Performance vs Target Report
- Top 10 Products
- Division-Level Report
- New Products (2021)
- Top 5 Products by Quantity
The Finance Report includes the following:
- Profit & Loss by Financial Year
- Profit & Loss by Financial Months
- Profit & Loss by Market
- Gross Margin % by Financial Quarters
-
New Product Growth: Products launched in 2021 showed steady growth compared to 2020. Atliq should focus on launching new products annually to sustain this growth.
-
Profit & Loss Analysis: Using KPIs like net sales, COGS, gross margin, and GM%, the financial trends highlighted areas for improvement. These insights will drive effective decision-making.
-
Seasonal Sales Boost: From October to December, net sales see a sharp rise due to the festive season. Atliq should introduce new products and provide discounts, coupons, and vouchers on platforms like Amazon, Atliq e-store, and Atliq Exclusive to further boost sales.
If you find this repository helpful, please give it a ⭐ to show your support!