You will be able to build an end-to to-end project all in Google Cloud.
Agenda
1. Build Database (Big Query) 4:26
2. Connect to Database with Python (Colab to Big Query) 19:20
3. Build a Churn Model (PyCaret) 30:01
4. Export Data to Big Query 44:50
5. Build Dashboard ( Looker Studio ) 55:30
6. Recommendations (Power Point/Google Slides) 1:50:00
Problem Statement:
We are having issues with keeping employees, so we would like a data analyst to help proactively find employees that are at risk.
Approach:
Select a pilot program with new employees.
Build an Auto ML model trained on previous data that can predict new employees will leave.
Deliverable:
Report/Dashboard
You can find the dataset here:
https://absentdata.com/data-analysis/where-to-find-data/
#datascience
#data
#googlecloud
#datastudio
#dataanalysis
#bigquery