DataBird Capstone Project
Final project of the DataBird Business Data Analyses Bootcamp
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
We used
- python
- jupyter-notebook
- Tableau software
- converter_to_csv
- Metabase
- sql
- excel
- DbDesigner.net
- dbdiagram.io
- cf data_dictionnary.html for raw data
- cf project_explanation.html for data clean
- july 2020, presentation with the databird board 31th july
- finishing the folder for archive in August 2020
- Aurelie, Simon, Fahmi, Stephanie