Charlotte
Data Analyst with a background in CRM.
Excel | SQL | Python | Power BI
SQL | IMDB Dataset
An exploratory data analysis on the IMDB dataset.
PYTHON
IN PROGRESS
Tableau | World Happiness Report
Dynamic analysis of the World Happiness Report (2005 - 2022)
CERTIFICATIONS
The Complete SQL Bootcamp: Go from Zero to Hero
UdemyRetrieving, Processing and Visualising date with Python
Cousera - University of MichiganTableau 2022 A-Z: Hands-On Tableau Training for Data Science
Udemy
© Untitled. All rights reserved.
SQL | IMDB Data Analysis
An exploratory analysis on the IMDB dataset. For more details on the dataset columns, please read here: https://www.imdb.com/interfaces/.1. Importing the dataset
7 tables were imported using the Python code above. Python was used for better efficiency.
name.basics.tsv - information on the people involved in the production of the movies.
title.akas.tsv - information on the different versions of titles in the IMDB movie dataset.
title.description.tsv - information on the titles of the movies and TV shows
title.crew.tsv - information about the directors and writers for all the titles.
title.episode.tsv - information about TV episodes
title.principals.tsv - contains the principal cast and crew information for movies and TV
title.ratings.tsv - Contains the IMDb rating and votes information for the movies & TV
2. Analysis
The goal of this analysis is to examine several different themes, including movie genres, ratings, director popularity, and movie runtime.i. What are some of the english-language Fantasy movies that are available in Singapore?
ii. What are some of the Top TV Series of all time, based on the number of votes and ratings they have received on IMDB?
Note: TV Series are filtered to be available in Singapore for relevance.
iii. Who are the best movie directors of all time, based on IMDB ratings & number of votes on
their movies?
Note: Movies filtered to english language for relevance.
iv. What are the Top 5 longest running movies?
