Jiahe's
Data Portfolio

Analyzing Data with SQL,Tableau, R and Python @Jiahe.

July 25, 2021

Cyclistic Case Study

To wrap up the Google Data Professional Certificate Course,I have selected the Cyclistic bike share analysis case study to work on. For the case study, I will perform the real-world tasks of a junior data analyst for the marketing team at Cyclistic, a bike-share company in Chicago. To answer key business questions, I followed the six steps of the data analysis process taught in the course which are: Ask, Prepare, Process, Analyze, Share and Act.

  • Data Cleaning & Data Exploration: Excel, SQL
  • Data Visualisation: Tableau

  • July 18, 2021

    Data Exploration on Global Covid Numbers

    Data exploration on current COVID-19 Dataset to have better understanding on current pandemic situation through a data driven analysis and visualization.

  • Data Cleaning & Data Exploration: Excel, SQL
  • Data Visualisation: Tableau