This certification focuses on in-demand skills like data modeling, data visualization, and dashboarding and reporting covered in the following course series:
- Foundations of Business Intelligence
- The Path to Insights: Data Models and Pipelines
- Decisions, Decisions: Dashboards and Reports
The challenges presented in each course represent a single milestone within an entire project, based on the skills and concepts learned in that course.
The Cyclistic company’s Customer Growth Team is creating a business plan for next year. They want to understand how customers use their bikes; their top priority is identifying customer demand at different station locations.
The Project is divided into the following Sections:
-
Project Planning:
- Gather information from notes taken at the last Cyclistic executive meeting
- Identify relevant stakeholders for each task
- Organize tasks into milestones
- Complete project planning documents to align with stakeholders
-
Data Preparation
- Use project planning documents to identify key metrics and dashboard requirements
- Observe stakeholders in action to better understand how they use data
- Gather and combine necessary data
- Design reporting tables that can be uploaded to Tableau to create the final dashboard
-
Dashboard Design
- Use project planning documents to identify key metrics and dashboard requirements
- Upload target tables into Tableau
- Design charts and tables to share insights with stakeholders
- Create an effective dashboard using those charts and tables
Cyclistic has partnered with the city of New York to provide shared bikes.
- Primary Dataset - NYC Citi Bike Trips
- Secondary Dataset - Census Bureau US Boundaries
The main findings of the code can be found in the post available at tableau
Must give credit to Google Career Certificate and Coursera for providing the data.