MovieNow Rental Analysis Using SQL(BigQuery) and Tableau by Andrew Kim

MovieNow Rental Analysis Using SQL(BigQuery) and Tableau

In this project, I analyze historical data from an online movie rental company in order to identify trends in customer preferences, engagement, and sales development. This highlights skills in SQL (PostgreSQL in BigQuery) like aggregate functions, joins, subqueries, OLAP, Common Table Expressions (CTE) and Window Functions. The main tools I use are SQL in Google BigQuery and Tableau. Here are the highlights: Tableau Dashboard: MovieNow Rental Analysis GitHub: MovieNow Rental Analysis Repository Slides: MovieNow Rental Analysis A more in-depth breakdown of the scenario is included below, followed by my full report....

Bike Share in Chicago Trend Analysis Using Spreadsheets, R and Tableau by Andrew Kim

Bike Share in Chicago Analysis Using R and Tableau

In this project, I analyze historical bike trip data from a Chicao bike-share company, using R and create powerful visualizations using Tableau. Tableau Dashboard: Bikeshare in Chicago GitHub: Bike Share in Chicago Repository Slides: Navigating Speedy Success A more in-depth breakdown of the scenario is included below, followed by my full report. Scenario Cyclistic is a bike-share company in Chicago with over 5,824 bikes that are geotracked and locked into a network of 692 stations across Chicago....