Sales and Financial Insights for a Hardware Company with Excel

Tools used in this project
Sales and Financial Insights for a Hardware Company with Excel

About this project


Atliq Hardwares, an imaginary company, stands as a premier computer hardware producer based in India with a notable global presence. With a commitment to innovation and quality, Atliq has successfully expanded its operations beyond India's borders.

Tools used:

  • Microsoft Excel
  • Power Query (Data cleaning and transformation)
  • Power Pivot (Data Modeling)
  • Pivot Table
  • Dax Measures
  • Conditional Formatting

GitHub link: click here

Project Insights:

Sales Analytics:

I spearheaded the customer analysis efforts, diving deep into their preferences, behaviors, and locations for the years 2019, 2020, and 2021. By understanding our customers better, I contributed to tailoring our products and services to meet their needs, enhancing overall satisfaction and loyalty. Additionally, my involvement in product and market analyses provided crucial insights, guiding our expansion strategy into international markets.

Important Metrics:

  1. Net Sales Performanceundefined
  2. Market Performance vs Targetundefined
  3. Division & Platform level salesundefined
  4. Top 5 countries by salesundefined
  5. Top and bottom 5 Products by Quantity soldundefined
  6. Top 5 Products by salesundefined

Financial Analytics:

On the financial front, I led the analysis of profit and loss statements, dissecting our financial performance month by month and across quarters and years. This granular examination helped identify trends and areas for improvement. Moreover, my role extended to scrutinizing the intricacies of gross margin and cost of goods sold (COGS), contributing to better operational efficiency and pricing strategies.

Important Metrics:

  1. New Productsundefined
  2. Gross Margin % by sub-zonesundefined
  3. P & L by fiscal yearundefined
  4. P & L by Months and quartersundefined
  5. P & L for Marketsundefined
Discussion and feedback(0 comments)
2000 characters remaining