Project : Development of a Power BI Dashboard for Managing Key Quality Indicators of Raw Materials and Automating Action Plan Monitoring
Department : SQT Raw
Materials Required Specialty : Textile or Management
Knowledge Required : Business Intelligence Mastery
Tasks :
- Identify and collect relevant data related to raw materials, knitting processes, dyeing, and finishing
- Utilize internal databases, production management systems, or existing Excel files
- Structure data in PowerBI for optimal analysis (data cleaning, relationships between different production stages, creation of fact and dimension tables)
- Develop an interactive dashboard that enables real-time visualization of key performance indicators (KPIs) for each stage of the raw materials production process
- Implement an automated action plan monitoring system for each non-conformity identified in the production stages
- Integrate a notification and alert system into the dashboard to warn of delayed or unresolved actions
Supervisor : BIOTEX Quality Department Head