Material Availability Dashboard
Internship · Bodyline (Pvt) Ltd — MAS Holdings
A Power BI dashboard that tracks material availability across categories and customers, integrating SAP data to deliver availability KPIs for supply-chain decision-making.
Built for an internal business context. The visuals on this site are illustrative — no company data, internal dashboards or proprietary information are shown.
Overview
A Power BI dashboard developed during my data analytics internship at MAS Bodyline to track material availability across categories and customers, delivering accurate availability KPIs for supply-chain decision-making.
Problem statement
Monitoring material availability means bringing together data from SAP and other operational sources. Without a consolidated analytical view, it takes more effort to understand availability and act on it.
Objectives
- Integrate SAP and operational data into a single analytical model.
- Track material availability across categories and customers.
- Deliver accurate availability KPIs to support supply-chain decisions.
Technologies
Data sources
- SAP data
- Operational data
Methodology
- 01
Transform
Cleaned and shaped source data with Power Query.
- 02
Model
Built optimised data models relating SAP and operational tables.
- 03
Measure
Wrote DAX measures for the availability KPIs.
- 04
Visualise
Developed the dashboard to track availability across categories and customers.
Implementation
- Integration of SAP and operational data
- Data transformation with Power Query
- Optimised data models
- DAX measures for availability KPIs
- Dashboard development