DataBird Capstone Project

Arsenal Chirurgical

Final project of the DataBird Business Data Analyses Bootcamp

How to read this project?

All data resources and the final result cannot be shared. The data may contain sensitives informations as well as the final presentation. In this repository, the files have been chosen accordingly.

The map

tree -CAL 2
.
├── data
│   ├── data_created
│   ├── data_raw
│   └── data_sql
├── Data_dictionnary.html
├── images
│   ├── ArsenalFinal.png
│   ├── BlockSchemaFinal.png
│   ├── dataProcess.jpeg
│   ├── FavoriteContractSchemaFinal.png
│   ├── FosUsersFinal.png
│   ├── imageAncillaire.png
│   ├── LaboratorySchemaFinal.png
│   ├── LocationSpecSchemaFinal.png
│   ├── logoDefinitif.png
│   ├── LogSchemaFinal.png
│   ├── RequestFinal.png
│   └── ReservationSchemaFinal.png
├── notebook
│   ├── Data_dictionnary.ipynb
│   └── Project_explanation.ipynb
├── Prez-finale_modif.pdf
├── Project_explanation.html
├── README.md
├── script
│   ├── 202007_Aurel_DMI_by_request.ipynb
│   ├── 202007_Aurel_DMI_split_by_HI.ipynb
│   ├── 202007_Fahmi_Req_HI_Lab_OB_Users_clean.ipynb
│   ├── 202007_Fahmi_Rq_Seg_Dpt_Wrong.ipynb
│   ├── 202007_Fahmi_Rq_Seg.ipynb
│   ├── 202007_simon_analyse_Churn_retention_v1.ipynb
│   ├── 202007_simon_analyse_Mail.ipynb
│   ├── 202007_Stef_CA_pelican_cleasning.ipynb
│   ├── 202007_Stef_etl_SurgeonSpecialty.py
│   ├── 202007_Stef_Sendiblue_clean.ipynb
│   └── convertJupyterToHtml.py
└── SlidesTableauSoftware
    ├── Slide07_Aurelie
    ├── Slide08_Aurelie
    ├── Slide09_Aurelie
    ├── Slide10_Fahmi
    ├── Slide11_Fahmi
    ├── Slide13_Aurelie
    ├── Slide14_Stef
    ├── Slide15_Fahmi
    ├── Slide16_Fahmi
    ├── Slide18_Fahmi
    ├── Slide19_Aurelie
    ├── Slide20_Fahmi
    └── Slide21_Fahmi

21 directories, 29 files

Which techno used for this project?

We used

• python
• jupyter-notebook
• Tableau software
• converter_to_csv
• Metabase
• sql
• excel
• DbDesigner.net
• dbdiagram.io

Which data and How we clean them?

• cf data_dictionnary.html for raw data
• cf project_explanation.html for data clean

When and who write this project?

• july 2020, presentation with the databird board 31th july
• finishing the folder for archive in August 2020
• Aurelie, Simon, Fahmi, Stephanie