Project overview
-
AtliQ wants to make Data Driven Decision Making a part of their work culture.
-
Their first big step towards it is embedding a Power BI tool in the organisation, enabling better analysis of finance, sales, marketing and supply chain for informed decision-making.
-
4 years of sales data and 1 year of forecast data combined gives us the 1.8 million records to setup the business intelligence for AtliQ
Data Repository
Query Folding
Data Cleaning,
Analysis &
Visualization
AtliQ Hardware - BI Dashboard
Domain
Consumer Electronics
BUsiness Function
Business Intelligence
Live Dashboard
Project Details
Objective
A functional dashboard is implemented with key business metrics that allows the business stakeholders to use the tool in their business review meetings and in their decision making process such as :
-
customer negotiation, new product launch,
-
marketing promotions, finance budgeting, etc.
What I learned in this project
-
Power Query (Basic and Advanced Operations)
-
Basic and complex DAX formulas
-
Data modelling involving 10+ tables
-
Choosing the right visuals and formatting
-
Dashboard designing principles
-
Using bookmarks & Parameters
-
Deploying in Power BI service
-
Stakeholder Feedback Implementation
-
Sales, Marketing, Finance & Supply Chain metrics
Areas of focus
-
Building a Robust Data Model
-
Designing User-Centric Reports
-
Providing Drill-able Insights
