Data Analysis and reporting
Budget: $30 – $250 AUD
We have a list of data that we want you to analyze and create extensive reporting on.
The data consists of 10 batches of broken phones and we have recorded what parts were used, whether they were fixable or we had to destruct them, what it costs etc etc.
We have some ideas of KPI we want to report on, but would appreciate if you could add in a few other views and angles that you can pull reports from.
We want to see the data from another persons eyes.
Here are the starter KPI's to report on.
-What the destruction vs repair rate was on QTY and % batch by batch
-What the QTY split was per model per batch
-What the Repair vs destruction rate was by model
-What the FRP rate was per batch (would have FRP marked in faults)
-What the "End Cost Inc" was per model across all batches
-Split of faults per model
Then can you please add 5-10 more KPI reports.
We will provide the full spreadsheet to the successful candidate.
The data consists of 10 batches of broken phones and we have recorded what parts were used, whether they were fixable or we had to destruct them, what it costs etc etc.
We have some ideas of KPI we want to report on, but would appreciate if you could add in a few other views and angles that you can pull reports from.
We want to see the data from another persons eyes.
Here are the starter KPI's to report on.
-What the destruction vs repair rate was on QTY and % batch by batch
-What the QTY split was per model per batch
-What the Repair vs destruction rate was by model
-What the FRP rate was per batch (would have FRP marked in faults)
-What the "End Cost Inc" was per model across all batches
-Split of faults per model
Then can you please add 5-10 more KPI reports.
We will provide the full spreadsheet to the successful candidate.