I have used Python for Data Cleaning and Exploratory Data Analysis
and after that I create four tables to make data model with power bi and create Movies Dashboard
first: Movies Notebook:
I used python and python packages(Pandas, NumPy) for data Assessing, Cleaning, EDA, and Draw Conclusions
first: Movies Dashboard:
this is Movie Dashboard contains three pages:
-
Movies Profits
-
Genre Details
-
Movie Details
- before creating dashboards I made some changes:
-
Validate Data Type
-
Using Power Query & DAX to add columns for Analysis purpose
-
Make Key Measures
-
Create a Data Model Between Tables