This project presents a dynamic and interactive Power BI dashboard built for AtliQ Hardware, a global company specializing in the sales of computers and computer accessories. The dashboard aims to provide data-driven insights for multiple departments across the organization, helping the business make smarter, faster decisions.
🔗 LinkedIn Post
📊 View Live Dashboard
AtliQ Hardware is a rapidly growing global business that sells computers and computer accessories through three primary channels:
- 🛒 Retailers
- 📦 Distributors
- 🔗 Direct Sales
Despite its international expansion, the company faced a major setback after launching stores in the United States based on intuition, limited surveys, and basic Excel analysis. Competitors, equipped with strong analytics teams, were making far more informed decisions.
As a result, AtliQ Hardware decided to invest in building a dedicated analytics team to adopt a data-driven decision-making approach and maintain competitiveness in the hardware market.
Due to lack of advanced data analytics capabilities, AtliQ Hardware suffered a significant loss in its US market expansion. The leadership team realized that relying on intuition and spreadsheets was no longer viable in a competitive, data-driven industry.
The objective of this project was to:
- Build a centralized and interactive analytics dashboard using Power BI
- Provide detailed, role-specific insights for departments including Sales, Finance, Marketing, Supply Chain, and Executives
- Empower the company to make smarter, faster, and data-backed decisions
Through this project, I strengthened my understanding of core and advanced Power BI concepts:
- ✅ Data validation techniques
- 📅 Development of date tables using M Language
- 🔗 Snowflake-style Data Modeling
- 🧮 Creating Calculated Columns and Measures using DAX
- 📝 Dynamic Titles based on applied filters
- 🔄 Bookmarking to switch between visuals
- 🎨 Conditional Formatting with icons and background color
- 🔘 Page navigation using buttons
- ☁️ Publishing reports to Power BI Service
- Power BI Desktop
- Power BI Service
- DAX & M Language
- MySQL (as data source)
- DAX Studio
- Excel (for pre-validation)
- Connected to a MySQL database by providing credentials
- Imported all necessary tables for building the report
- Employed a Snowflake Schema for a well-structured data model
- Established proper relationships between fact and dimension tables
- Created Date Table using M Language for time-based analysis
- Used provided mock-ups as a visual reference
- Created calculated columns and DAX measures as required
- Designed department-specific views to serve:
- Finance
- Sales
- Marketing
- Supply Chain
- Executives
- Navigation between pages using buttons
- Applied dynamic filtering, conditional formatting, and bookmarks
- Added a support page for help resources
- Published and shared via Power BI Service
A snapshot of the AtliQ Hardware Power BI Dashboard
This project was completed as a part of my advanced data analytics journey — combining technology, business acumen, and storytelling through visuals.
Feel free to connect on LinkedIn for collaboration or discussion.