Project Details

Boosting AtliQ Hardware with Data Insights:
AtliQ Hardware is a significant player in the hardware industry, offering a wide range of products including PCs, mouse, computers, networking, and storage solutions across many countries. They connect with customers through diverse channels such as retail stores, distributors, and their exclusive showrooms, both in physical locations and online platforms.

Key Skills Performance
✔ ETL using Power Query
✔ Data Modeling with Power Pivot
✔ Pivot Tables for Reports
✔ Advanced Formulas
✔ Visual Data Enhancement
✔ Data Transformation
✔ Data Modeling
✔ DAX
✔ Navigating Finance Metrics

Project Details

The Data:
I began by organizing the tables, connecting and structuring the data, and performing basic data quality assurance. Then, after learning about relational models, cardinality, and filter flow, I made my own data model.
Following to this, I used some of the interesting DAX functions to create new measures which will be useful for further analysis.
1)   Executive Dashboard – A high level summary of the entire data set.
2) Map – A visual to learn about using geospatial data & tooltips.
3) Product Details Dashboard: This dashboard is drill through Type, Which shows more details for particular products shown in the top 10 table of executive dashboard.
4) Customer Details: This dashboard displays customer level KPIs.
5 ) Decomposition Tree: I added decomposition tree using AI features available in Power Bi to show data (total orders) across different categories and subcategories.

Live Interactive Dashboard

Project Details

Power Bi Dashboards elements.
Finance View: Dive deep into P&L, Net Sales trends, and top-performing products & customers.
Sales View: Analyze customer & product performances, Net Sales & Gross Margin, alongside COGS & deductions.
Marketing View: Evaluate GM% & NP% performance across segments, operational expenses & NP.
Supply Chain View: Explore Forecast Accuracy, Net Error, ABS Error, with key metrics by customer & product.
Executive View: Strategic insights into Market Share trends, top 5 customers/products, and revenue trends.

Key Skills Mastered:
➡ETL process using Power Query
➡Data Cleaning in Power Query
➡Data Modelling techniques
➡Calculated columns and measures using DAX language.
➡Bookmark techniques, page navigation.
➡Personal Gateway for automatic data refresh.
➡Power Bi service.
➡Problem Solving mindset that I have developed by solving issues that had arisen during different phases of this project.

Live Interactive Dashboard

Project Details

Problem Statement
AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodra. They want to expand to other metro/tier1 cities in the next 2 years.

AtliQ Mart is currently facing a problem where a few key customers did not extend the annual contract due to service issues. It is speculated that some of the essential products were either not delivered on time or not delivered in full over a continued period, which could have resulted in bad customer service. Management wants to fix this issue before expanding to other cities and requested their supply chain analytics team to track the ’On time’ and ‘In Full’ delivery service level for all the customers on a daily basis so that they can respond swiftly to these issues.

Live Interactive Dashboard