Data visualisation

  • État: Closed
  • Prix: $77
  • Propositions reçues: 3
  • Gagnant: Celispahn

Résumé du concours

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

Compétences recommandées

Commentaire de l'employeur

“Great work, thanks”

Image de profil liamo, Australia.

Meilleures propositions de ce concours

Afficher plus de propositions

Tableau de clarification publique

  • Kingharryjoe
    Kingharryjoe
    • il y a 3 semaines

    Please wait for my entry

    • il y a 3 semaines
  • saliba04
    saliba04
    • il y a 1 mois

    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.

    • il y a 1 mois
    1. saliba04
      saliba04
      • il y a 1 mois

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

      • il y a 1 mois
    2. liamo
      Titulaire du concours
      • il y a 4 semaines

      Yes, 1736 is correct

      • il y a 4 semaines
  • akashdesky
    akashdesky
    • il y a 1 mois

    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.

    • il y a 1 mois
    1. liamo
      Titulaire du concours
      • il y a 4 semaines

      Sorry thats all I have.

      • il y a 4 semaines
  • Celispahn
    Celispahn
    • il y a 1 mois

    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?

    • il y a 1 mois
    1. liamo
      Titulaire du concours
      • il y a 1 mois

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

      • il y a 1 mois
  • HuynhWilson
    HuynhWilson
    • il y a 1 mois

    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?

    • il y a 1 mois
    1. liamo
      Titulaire du concours
      • il y a 1 mois

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

      • il y a 1 mois

Montrer plus de commentaires

Comment commencez des concours

  • Publiez votre concours

    Publiez votre concours Rapide et facile

  • Obtenez des tonnes de propositions

    Obtenez des tonnes de propositions De partout dans le monde

  • Attribuez la meilleure proposition

    Attribuez la meilleure proposition Télécharger les fichiers - Facile !

Publier un concours maintenant ou rejoignez-nous maintenant !