- Status: Closed
- Prêmio: $77
- Inscrições Recebidas: 3
- Vencedor: Celispahn
Síntese do concurso
Data Miner or Data Analyst or Data Scientist..
I have a small spreadsheet of data and need someone to interrogate it for insights and then to visually represent the insights. The data is self explanatory, I'm happy to answer any questions. This task will require some deep thinking and creativity.
The data shows widgets installed at client sites, quantities installed by site and repeat installs where the widgets have failed.
At the foot of the spreadsheet there is an example of what can be found in the data.
X. Most important requirement is to find the insights in the data. Presentation comes second!
1. The excel column titled 'Install#' relates to the notion of First, second, third and fourth install. A second install is only necessary in cases where the widgets of the first install have failed. Similarly the 'third install' is only necessary at sites where the second install has failed and a fourth install was only required once. In most cases there was only ever one install.
3. Interpretations must be supported by the data.
4. The following is a description of the spreadsheet column names -
# : Client #1 is row 2
Install# : The number of install events(4) at client #1 site
Quantity Per Single Install : 94 widgets were required to complete a single install event at client# 1
Total Installed (Accounting for multiple installs) : 94 X 4 install events = 376 (widgets failed 3 times)
Quantity Failed : Assuming the final install has not failed 94 X 3 install events = 282
(For client #1 a full install requires 94 widgets) a second install means the original installed widgets must be removed and replaced with another 94 widgets etc..
happy to answer any questions.....
the repeat installs are important as are ratios and patterns
Feedback do Empregador
“Great work, thanks”