Stats Dematia Slide

--- title: Stats Dematia Slide tags: UNC slideOptions: transition: 'fade' theme: white spotlight: enabled: false --- <style> a > span.hidden-xs { visibility: hidden; } .caption{ visibility: hidden; } .navbar-default .navbar-brand { color: white; } .fa-file-text{ visibility: hidden; } body > nav > div.navbar-header > a:after{ content: 'UNC'; font-size: xx-large; font-weight: bold; } .navbar-collapse { background-color: lightsteelblue; color: white; } tr:nth-child(even) { background-color: #f2f2f2; } H1 { background-color: lightsteelblue; border-color: #d6e9c6; padding: 15px; margin-bottom: 20px; border: 1px solid transparent; border-radius: 4px; font-size: large; } H2 { background-color: lightsteelblue; border-color: #d6e9c6; padding: 10px; margin-bottom: 15px; border: 1px solid transparent; border-radius: 4px; font-size: medium; } th, td { font-size:14px; padding: 1px !important; } </style>  # Quelques chiffres ### Dossiers traités | Etape | Nb | |:----------------------------------- |:----------------:| |INSCRIPTION_FINALISEE |2376 |INSCRIPTION_ABANDONNEE |193| |ENTAME |109| |ATTENTE_MODIFS_PAR_ETUDIANT| 65| |ATTENTE_ENCAISSEMENT| 59| |DEPOSE| 6| <br><br><br> ### Statistiques  - Nombre d'entrées dans le journal: 390172 - Nombre de connexions ou tentatives de connexions: 34301 - Signaler un problème: - total: 1145 - avec un 'Bonjour' :smiley: : 211 - sans préciser le problème: 392 (->à bloquer dans l'application) - sans login et sans préciser le problème: 79 (->à bloquer dans l'application) - taux de signalement par connexion : 3,6% - **taux de signalement par connexion unique: 17,5%** ---  ## Workflow ![](https://i.imgur.com/Jgck4k0.png) | Etape | Moyenne en Jours | |:----------------------------------- |:----------------:| | 1. première connexion -> soumission | 3.9 | | 2. soumission -> déversement | 4.9 | | 3. déversement -> mise en paiement | 1.5 | | 4. mise en paiement -> finalisation | 7.4 |  **Temps moyen bout en bout: 17,7 jours** ---  ```vega { "title": "Nombre d'états par jour", "width": 1000, "height": 450, "data": { "url": "https://raw.githubusercontent.com/Tyvain/data/main/dematia.json"}, "transform": [ {"fold": ["DEBUT_DOSSIER", "SOUMISSION_DOSSIER", "DEVERSEMENT_SCOLARIX", "MISE_EN_PAIEMENT","DOSSIER_FINALISE"]} ], "mark": "bar", "encoding": { "x": {"field": "DAT", "type": "nominal"}, "y": {"field": "value", "type": "quantitative"}, "color": {"field": "key", "type": "nominal"} } } ``` ---  ## Analyse ```vega { "title": "Nombre de problèmes / connexions uniques par jour", "width": 1000, "height": 450, "data": { "url": "https://raw.githubusercontent.com/Tyvain/data/main/dematia.json"}, "transform": [ {"fold": ["CONNEXION_UNIQUE" , "ECHEC_CONNEXION_UNIQUE" , "SIGNALER" ,"ABANDON"]} ], "mark": "bar", "encoding": { "x": {"field": "DAT", "type": "nominal"}, "y": {"field": "value", "type": "quantitative"}, "color": {"field": "key", "type": "nominal"} } } ``` ---  ## Commits (charge de travail dev) ```vega { "title": "Nombre de commits par jour", "width": 1000, "height": 450, "data": { "url": "https://raw.githubusercontent.com/Tyvain/data/main/dematia-commit-per-day.json"}, "layer": [ { "mark": "bar", "encoding": { "x": {"field": "DAT","sort": "ascending"}, "y": {"aggregate": "count"}, "color": { "condition": { "test": "datum['DAT'] < '2023-03-04' && datum['DAT'] > '2023-01-18' || datum['DAT'] < '2022-09-02' && datum['DAT'] > '2022-08-13'", "value": "green" } } } } ] } ``` ---  ## Bilan - Le socle applicatif a tenu la charge pour cette première application grand publique. - Empêcher les 'signaler' vides - Améliorer la compréhension de page de connexion (UX) - Analyser plus en détail les 'signaler' pour identifier les plus fréquents ---  ## Sources - Ticket (sql): https://jira.unc.nc/browse/DIG-2349 - Data (json): - https://raw.githubusercontent.com/Tyvain/data/main/dematia.json - https://github.com/Tyvain/data/blob/main/dematia-commit-per-day.json - Data (csv): https://raw.githubusercontent.com/Tyvain/data/main/dematia.csv # Data par jour | DAT | CONNEXION | ECHEC CONNEXION | CONNEXION UNIQUE | ECHEC CONNEXION UNIQUE | ECHEC CONNEXION UNIQUE_PS | ECHEC CONNEXION UNIQUE UNC | SIGNALER UN PROBLEME | DEBUT DOSSIER | SOUMISSION DOSSIER | DEVERSEMENT SCOLARIX | MISE EN PAIEMENT | DOSSIER FINALISE | |:----------:|:---------:|:---------------:|:----------------:|:----------------------:|:-------------------------:|:--------------------------:|:--------:|:-------------:|:------------------:|:--------------------:|:----------------:|:----------------:| | 2023/01/18 | 2307 | 1699 | 531 | 198 | 71 | 127 | 212 | 990 | 431 | 42 | 21 | 6 | | 2023/01/19 | 1239 | 808 | 296 | 120 | 50 | 70 | 104 | 351 | 233 | 91 | 55 | 26 | | 2023/01/20 | 840 | 650 | 169 | 82 | 20 | 62 | 58 | 170 | 132 | 106 | 25 | 9 | | 2023/01/21 | 472 | 363 | 81 | 37 | 15 | 22 | 42 | 111 | 86 | | | | | 2023/01/22 | 329 | 140 | 61 | 28 | 8 | 20 | 16 | 81 | 67 | | | | | 2023/01/23 | 960 | 646 | 216 | 94 | 47 | 47 | 63 | 150 | 177 | 93 | 72 | 46 | | 2023/01/24 | 1350 | 1598 | 296 | 200 | 141 | 59 | 79 | 122 | 111 | 181 | 105 | 38 | | 2023/01/25 | 1136 | 809 | 258 | 118 | 74 | 44 | 56 | 104 | 125 | 211 | 93 | 24 | | 2023/01/26 | 1035 | 490 | 229 | 59 | 21 | 38 | 51 | 85 | 143 | 186 | 153 | 41 | | 2023/01/27 | 797 | 541 | 179 | 86 | 49 | 37 | 63 | 59 | 112 | 188 | 77 | 32 | | 2023/01/28 | 319 | 282 | 55 | 35 | 19 | 16 | 15 | 38 | 41 | | | | | 2023/01/29 | 375 | 279 | 79 | 46 | 9 | 37 | 16 | 42 | 52 | | | | | 2023/01/30 | 1204 | 618 | 270 | 83 | 33 | 50 | 42 | 80 | 129 | 273 | 153 | 103 | | 2023/01/31 | 1214 | 545 | 280 | 89 | 36 | 53 | 53 | 53 | 118 | 179 | 132 | 81 | | 2023/02/01 | 1148 | 484 | 264 | 55 | 22 | 33 | 32 | 59 | 136 | 133 | 143 | 44 | | 2023/02/02 | 1393 | 434 | 320 | 62 | 30 | 32 | 46 | 82 | 123 | 134 | 317 | 113 | | 2023/02/03 | 1200 | 638 | 270 | 89 | 47 | 42 | 40 | 40 | 111 | 92 | 121 | 96 | | 2023/02/04 | 374 | 89 | 74 | 15 | 9 | 6 | 11 | 15 | 37 | | | | | 2023/02/05 | 462 | 407 | 90 | 30 | 20 | 10 | 13 | 16 | 37 | | | | | 2023/02/06 | 1097 | 584 | 243 | 72 | 29 | 43 | 28 | 37 | 89 | 108 | 87 | 168 | | 2023/02/07 | 519 | 215 | 110 | 34 | 8 | 26 | 13 | 17 | 13 | 40 | 19 | 158 | | 2023/02/08 | 364 | 201 | 80 | 21 | 14 | 7 | 9 | 16 | 16 | 33 | 22 | 21 | | 2023/02/09 | 390 | 179 | 80 | 24 | 8 | 16 | 6 | 15 | 18 | 49 | 36 | 61 | | 2023/02/10 | 300 | 195 | 66 | 23 | 9 | 14 | 18 | 13 | 19 | 51 | 19 | 28 | | 2023/02/11 | 74 | 43 | 11 | 7 | 3 | 4 | 4 | 8 | 5 | 3 | | | | 2023/02/12 | 72 | 26 | 10 | 7 | 5 | 2 | | 1 | | | | | | 2023/02/13 | 321 | 191 | 70 | 23 | 6 | 17 | 10 | 24 | 23 | 27 | 55 | 57 | | 2023/02/14 | 225 | 158 | 55 | 20 | 9 | 11 | 10 | 4 | 12 | 40 | 21 | 45 | | 2023/02/15 | 158 | 66 | 37 | 15 | 7 | 8 | 3 | 4 | 6 | 30 | 30 | 27 | | 2023/02/16 | 174 | 63 | 42 | 13 | 8 | 5 | | 10 | 9 | 55 | 50 | 33 | | 2023/02/17 | 100 | 23 | 18 | 5 | 3 | 2 | 2 | 2 | 8 | 7 | 7 | 15 | | 2023/02/18 | 26 | 11 | 5 | 3 | | 3 | 4 | | 3 | | | | | 2023/02/19 | 27 | 25 | 3 | 3 | 1 | 2 | | 1 | 2 | | | | | 2023/02/20 | 103 | 20 | 23 | 3 | | 3 | | 2 | 3 | 11 | 5 | 25 | | 2023/02/21 | 79 | 31 | 16 | 6 | 2 | 4 | | 2 | 1 | 10 | 6 | 14 | | 2023/02/22 | 58 | 25 | 12 | 4 | 3 | 1 | | 2 | 3 | 4 | 5 | 13 | | 2023/02/23 | 76 | 12 | 15 | 3 | | 3 | | | 1 | 7 | 6 | 13 | | 2023/02/24 | 54 | 34 | 10 | 6 | 2 | 4 | | | | 4 | 1 | 7 | | 2023/02/25 | 26 | 15 | 3 | 3 | 2 | 1 | | 1 | 1 | | | | | 2023/02/26 | 18 | 6 | 2 | 1 | 1 | | | | | | | | | 2023/02/27 | 67 | 39 | 15 | 7 | 5 | 2 | 4 | 1 | 1 | 14 | 12 | 20 | | 2023/02/28 | 52 | 7 | 11 | 1 | | 1 | | | 1 | 5 | 1 | 10 | | 2023/03/01 | 48 | 37 | 8 | 5 | 2 | 3 | | 1 | 2 | 3 | 4 | 6 | | 2023/03/02 | 63 | 32 | 11 | 8 | 2 | 6 | | | 1 | 23 | 14 | 14 | | 2023/03/03 | 36 | 43 | 6 | 7 | 2 | 5 | 3 | | 2 | 21 | 1 | 7 |