Finding The Right Choices Get On The Right Path
Data driven decision making to assist a new streaming service
@kaggle.jaymesantosneto_finding_the_right_choices_get_on_the_right_path
Data driven decision making to assist a new streaming service
@kaggle.jaymesantosneto_finding_the_right_choices_get_on_the_right_path
Greetings and welcome to the SOFABED data analysis case study! Throughout this case study, you will engage in a variety of real-world tasks as a junior data analyst. Your role will involve envisioning yourself as part of the team at SOFABED, a recently established streaming company that is in the process of developing its business plan and production strategies. To address essential business inquiries, you will be following the data analysis process, encompassing the key stages of asking, preparing, processing, analyzing, sharing, and acting. Along your journey, the Case Study Roadmap tables will be your valuable companions, providing guiding questions and essential tasks to ensure you remain on the right track. Let's embark on this exciting data analysis adventure together!
CREATE TABLE amazon_movies (
"id" VARCHAR,
"title" VARCHAR,
"type" VARCHAR,
"year" BIGINT,
"runtime" BIGINT,
"genres" VARCHAR,
"production_countries" VARCHAR,
"seasons" VARCHAR,
"imdb_id" VARCHAR,
"imdb_score" DOUBLE,
"imdb_votes" BIGINT,
"tmdb_popularity" DOUBLE,
"tmdb_score" DOUBLE
);CREATE TABLE amazon_series (
"id" VARCHAR,
"title" VARCHAR,
"type" VARCHAR,
"year" BIGINT,
"runtime" BIGINT,
"genres" VARCHAR,
"production_countries" VARCHAR,
"seasons" BIGINT,
"imdb_id" VARCHAR,
"imdb_score" DOUBLE,
"imdb_votes" BIGINT,
"tmdb_popularity" DOUBLE,
"tmdb_score" DOUBLE
);CREATE TABLE netflix_movies (
"id" VARCHAR,
"title" VARCHAR,
"type" VARCHAR,
"year" BIGINT,
"runtime" BIGINT,
"genres" VARCHAR,
"production_countries" VARCHAR,
"seasons" VARCHAR,
"imdb_id" VARCHAR,
"imdb_score" DOUBLE,
"imdb_votes" BIGINT,
"tmdb_popularity" DOUBLE,
"tmdb_score" DOUBLE
);CREATE TABLE netflix_series (
"id" VARCHAR,
"title" VARCHAR,
"type" VARCHAR,
"year" BIGINT,
"runtime" BIGINT,
"genres" VARCHAR,
"production_countries" VARCHAR,
"seasons" BIGINT,
"imdb_id" VARCHAR,
"imdb_score" DOUBLE,
"imdb_votes" BIGINT,
"tmdb_popularity" DOUBLE,
"tmdb_score" DOUBLE
);Anyone who has the link will be able to view this.