The files on this page are pieces of the portfolio project for the Google Data Analytics Certificate Program.
The business task was to compare the performance of casual riders to member riders. The word file and the presentation files contain links to the datasets used for this analysis.
This analysis was done using R and is hosted on https://www.kaggle.com/code/mickells/google-data-analytics-capstone1
This dataset contains Historical Population data for every Country/Territory in the world by different parameters like Area Size of the Country/Territory, Name of the Continent, Name of the Capital, Density, Population Growth Rate, Ranking based on Population, World Population Percentage, etc.
Extensive Exploratory Data Analysis was performed using R and the files are hosted on https://www.kaggle.com/datasets/d893bc6eb4370c2fd7b87bcf41972963b607202a1683f576700c52e6ecd4ab2a
I love playing this game and I decided to do a project around it. This project involves developing Python scripts for automating the data extraction process. The python scripts were split into two(2): First part includes extracting the title, link, channel name, channel link, views and upload time while the second script extracts the link and the video length.
The data cleaning and preparation were performed using Power Query and Visualization was made using Tableau and Power BI Desktop.