Introduction-

AtliQ Hardware, a rapidly growing computer hardware company, faced challenges with outdated Excel-based analysis for managing large data volumes. They needed advanced analytics for data-driven decision-making and effective reporting. For which, I've created a customized report for various departments of AtliQ.

Tech Stack used-

• SQL
• Power BI Desktop & Power BI Service
• Excel
• DAX Studio
• Project Charter file

Power BI techniques implemented-

• Data modeling (established relationships between 15 tables)
• DAX measures
• Calculated columns
• Bookmarks
• Page navigation using buttons
• Applied Dynamic titles
• Conditional formatting (to highlight key metrics)
• Publishing & sharing reports on PowerBI Services

Dashboard View-

Home Page: Centralized hub for seamless Page navigation

Finance view: Financial metrics analysis

Sales view: Sales performance insights

Marketing view: Marketing strategy insights

Supply Chain view: Supply chain metrics & Operations optimization

Products view: Insights on Key products & customers

Executive view: Historical metrics customized for Executive members that enables strategic decision making

KPIs & Metrics-

• Key Performance Indicatos(KPIs):

  • Net Sales, Gross Marign%, Net Profit%, Forecast Accuracy%, Net Error & Absolute Error

• Key Metrics:

  • Profit & Loss Statement

  • Inventory Risk

  • Gross Margin & Gross Margin% Variance

  • AtliQ's Market Share & Revenue Contribution

Insights-

• Finance:
  • Exponential growth in Net Sales observed every year since inception, with a 353.5% growth in FY 2022
  • Rapid expansion since 2021 has resulted in a loss of 14%
  • Peak sales period occurs between October to December each fiscal year
• Sales:
  • Amazon and AtliQ Exclusive are key customers, contributing $496.9 million and $361.1 million in Net Sales, respectively
  • The best-selling product is "AQ HOME Allin 1 Gen 2," with Net Sales of $213 million in FY 2022
• Marketing:
  • The APAC region contributes the highest sales volume
  • Spain is the most profitable market, with a 7.7% Net Profit margin
  • The 'Notebook' segment and 'Business Laptop' category have the highest demand and Net Sales
  • Operational Expenses are consistently high due to rapid market expansion
• Supply Chain:
  • Forecast accuracy has been around 80% each fiscal year, but stockouts (OOS) and excess inventory issues are leading to missed sales opportunities and increased costs
• Products:
  • Top 5 markets by revenue are India, USA, South Korea, UK, and Canada
  • The AQ 5000 series Electron 8 5900X Desktop Processor has the highest Gross Margin % in the top 5 markets
• Executive:
  • The Retailer Channel and PCs Division are the highest contributors to revenue
  • The top 5 customers contribute to 38.7% of the revenue, with Amazon leading at 13.6%
  • AtliQ's Market Share increased to 5.9% in FY 2022
  • North America sub-zone contributes 26% of revenue, the highest
  • In South Europe, AtliQ’s Market share increased by up to 6.6%

Recommendations

• Continue evaluating financial metrics through yearly P&L statements
• During market expansion, optimize operational expenses to minimize losses
• Run promotional campaigns and social media contests for customers and consumers during the peak sales period of the festive season to further boost sales
• Optimize discount strategies for certain customers to increase Gross Margin and reward customers with better sales performance
• In South Korea, new customers can be acquired as no new customers have been gained in the last four years.
• Optimize inventory levels to reduce risks like stockouts (OOS) and excess inventory
• Involve cross-functional teams in the forecasting process to ensure effective planning and maximize resource utilization, reducing risks such as OOS or excess inventory
• Conduct surveys in the LATAM region to better understand consumer behavior and focus on products with the highest demand, ensuring better market penetration

Key Enhancements to Dashboard-

• Pop-ups for Information & to Find support for users enhanching User Experience
• Seamless Page Navigation
• Data refreshed button & Data last loaded button
• Color Blind Friendly color palettes themed dashboard for more inclusiveness

Conclusion-

Through this Business Insights 360 project, I've developed a customized report for AtliQ Hardware that is user-friendly, optimized the dashboard for swift performance & empowered AtliQ Hardware with strategic data driven decision making abilities.