Question
Develop a KPI dashboard for TYR Corp. TYR distributes and install four products. Data is available for the 2019 operations up to August. It
Develop a KPI dashboard for TYR Corp. TYR distributes and install four products. Data is available for the 2019 operations up to August. It includes per product sales (in $), inventory days, and rework (bad installations that required rework). For each month there is also two general data items, the number of new customers and the number of complaints. The company has as targets: inventory days: 10 days rework: 2% new customers/month: 250 complaints: 2 The dashboard should have 4-6 graphs that include sales, inventory days, rework, new customers and complaint information. Should have at least one pie chart. There should be several slicers (related to time and products). Aim to include targets in the plots. Include names of all team members in the Excel file (sheet called Team)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started