Sales and Finance Analytics for AtliQ Hardware

Overview:

This project focuses on analyzing sales and financial performance for AtliQ Hardware, a global supplier of electronic hardware. The goal was to create detailed reports that provide actionable insights for strategic decision-making, helping the company assess market performance, customer behavior, and financial health.

Objectives:

• Sales Analytics: Create reports analyzing customer performance and comparing market performance against sales targets.
• Finance Analytics: Generate Profit and Loss (P&L) reports by fiscal year, month, and market to track financial performance.

Key Components:

1. Sales Report:

   • Analyzed customer performance and compared actual market performance to targets.
   • Highlighted growth opportunities and effective discount strategies.

2. Finance Report (P&L):

   • Generated P&L reports for fiscal years, months, and markets.
   • Provided insights into profitability, gross margins, and cost management.

Tools & Technologies:

• Microsoft Excel:
  • Power Query: For ETL (data cleaning and transformation).
  • Power Pivot: For data modeling and relationships.
  • Pivot Tables & DAX: For advanced calculations and report generation.
  • Conditional Formatting: To highlight KPIs.

Skills Demonstrated:

• ETL & Data Modeling: Extracted, transformed, and loaded data for analysis using Power Query and Power Pivot.
• Advanced Excel & DAX: Utilized complex functions for calculations and insights.
• Data Visualization: Created charts to visually represent key findings.
• Real-time Business Applications: Gained knowledge in creating:
  • Project Priority Matrices for effective decision-making.
  • Scenario Planning Tools to support strategic planning.

Key Insights:

• Sales Analytics: Identified customer trends and areas for business expansion.
• Finance Analytics: Highlighted key financial metrics and provided a foundation for budgeting and forecasting.

Conclusion:

This project enhanced my technical skills in Excel, DAX, and data modeling, while also providing hands-on experience with real-time business applications like project prioritization and scenario planning. The reports delivered valuable insights that guided AtliQ Hardware’s strategic decisions and growth.

---

Feel free to explore the project files and dive deeper into the reports and analysis.