Data visualisation

  • 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.

* Notes.
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

Habilidades Recomendadas

Feedback do Empregador

“Great work, thanks”

Foto do perfil liamo, Australia.

Principais inscrições deste concurso

Ver Mais Inscrições

Painel de Comentários

  • Kingharryjoe
    Kingharryjoe
    • 3 semanas atrás

    Please wait for my entry

    • 3 semanas atrás
  • saliba04
    saliba04
    • 1 mês atrás

    Hello, i calculate "quantity of widgets installed to replace failed widgets", it was 1736 and not 1731. I made the sum of "quantity per single install" that have "install#"1. Would you please clarify this idea. I will not be able to proceed with a good visualisation if i doesn't understand that.

    • 1 mês atrás
    1. saliba04
      saliba04
      • 1 mês atrás

      In the line 2, "install#" different from 1.

      • 1 mês atrás
    2. liamo
      Proprietário do Concurso
      • 4 semanas atrás

      Yes, 1736 is correct

      • 4 semanas atrás
  • akashdesky
    akashdesky
    • 1 mês atrás

    Hi, CH! Is it possible for you to provide more data. I mean the bigger dataset will be able provide a considerable number of data points corresponding to 3 and 4 no. of installs.

    • 1 mês atrás
    1. liamo
      Proprietário do Concurso
      • 4 semanas atrás

      Sorry thats all I have.

      • 4 semanas atrás
  • Celispahn
    Celispahn
    • 1 mês atrás

    As per your example with client #1. They installed 94 widgets 4 times, meaning 94x3=282 widgets failed but on the last attempt the 94 widgets were installed correctly. So 94 widgets were installed to replace the 282 that failed. Is that right?

    • 1 mês atrás
    1. liamo
      Proprietário do Concurso
      • 1 mês atrás

      Yes this is correct, however that final 94 could still fail and I would have to decide if I should replace them again!

      • 1 mês atrás
  • HuynhWilson
    HuynhWilson
    • 1 mês atrás

    Hello, I find out that from the row number 47 to 106, total of their "quatity per single install" equals to the number you named "Less quantity of widgets installed to replace failed widgets". So Do you mean these rows are not representative for new clients?

    • 1 mês atrás
    1. liamo
      Proprietário do Concurso
      • 1 mês atrás

      row 47 to 106 relate to clients where there has only been one install

      • 1 mês atrás

Mostrar mais comentários

Como começar com concursos

  • Publique seu concurso

    Publique seu Concurso Rápido e fácil

  • Receba muitas inscrições

    Obtenha Toneladas de Inscrições De todo o mundo

  • Premie a melhor inscrição

    Premie a melhor inscrição Baixe os arquivos, é fácil!

Poste um Concurso ou Junte-se a nós Hoje!