AtliQ Hardwares, a leading hardware company specializing in PCs, printers, mice, and computers with a global reach, faces the challenge of optimizing sales and improving net gross margins.
This project tackles the analysis of a vast dataset comprising over half a million records of unorganized sales data, demanding extensive ETL efforts. Objective is to unearth strategic insights that will empower AtliQ Hardwares to make informed decisions and effectively track key performance indicators (KPIs). The ultimate aim is to drive substantial improvements in the company's performance in the years ahead, centered around net sales and net gross margin.
◆ Unlocking the potential within this dataset holds the key to maximizing AtliQ Hardwares' sales and profitability.
◆ By harnessing the power of data analytics, I aim to transform challenges into opportunities and facilitate data-driven decision-making.
◆ Join me on this journey to uncover the hidden treasures within AtliQ Hardwares' sales and finance data, enhancing their global market presence and fianancial health.
◆ Comprehensive Analysis: Conducting a thorough examination of net sales data, exploring dimensions such as year, country, product, division, and more.
◆ Target Alignment: Achieved alignment with strategic objectives by meticulously assessing market performance in comparison to predefined targets.
◆ Key Observations: Produced in-depth insights illuminating critical aspects of sales operations.
◆ 𝗠𝗲𝘁𝗿𝗶𝗰 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁: Created and implemented vital financial metrics, including Net Sales, COGS, Gross Margin, and GM %, to facilitate the creation of the P&L statement.
◆ 𝗗𝗲𝗰𝗶𝘀𝗶𝗼𝗻-𝗠𝗮𝗸𝗶𝗻𝗴 𝗜𝗺𝗽𝗮𝗰𝘁: These metrics play a crucial role in producing valuable insights, enabling informed and data-driven decision-making.
𝗧𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹 𝗦𝗸𝗶𝗹𝗹𝘀 ✔️ Proficiency in ETL methodology (Extract, Transform, Load). ✔️ Skills to generate a date table using Power Query. ✔️ Ability to derive fiscal months and quarters. ✔️ Establishing data model relationships with Power Pivot. ✔️ Proficiency in incorporating supplementary data into an existing data model. ✔️ Utilizing DAX to create calculated columns.
𝗦𝗼𝗳𝘁 𝗦𝗸𝗶𝗹𝗹𝘀 ✔️ Refined understanding of Sales & Finance Reports. ✔️ Designing user-centric reports with empathy in mind. ✔️ Optimization of report generation through meticulous fine-tuning. ✔️ Developing a systematic approach to devising a report-building plan.
• Microsoft Excel
• Power Query for Data Cleaning & Transformation
• Pivot Table for Data Summarization
• Power Pivot for Data Modelling
• DAX Measures for Calculated Columns
• Conditional Formatting to highlight pertinent data points for stakeholders