Skip to content
All projects
Data AnalyticsDemo not connected

Netflix Data Analysis

End-to-end cleaning in Excel, relational setup in MySQL, and a multi-page Power BI dashboard on ratings, categories and countries.

Problem

The raw Netflix catalogue data was inconsistent and needed substantial cleaning before it could answer questions about content mix and availability.

Approach

Cleaned the dataset in Excel with lookup, aggregation and text functions, loaded it into relational tables in MySQL Workbench, and connected Power BI for visual exploration.

Key features

  • 01Data wrangling with XLOOKUP, SUMIFS, nested IF and TRIM / LEFT / RIGHT
  • 02Relational tables in MySQL for Power BI connectivity
  • 03Content distribution by rating
  • 04Top categories and country availability views

Demo

A working deployment hasn't been connected for this project yet. It will appear here once a hosted link is added.

Next project

Ecommerce Price-Prediction Model