- Introduction
- Overview Dashboard
- Dataset
- EDA-Financial-Consumer-Data Notebook
- The Usage
The project aims to analyze the Financial-Consumer dataset to derive insights and facilitate data-driven decision-making for anyone interested in data analysis and dashboards using Pyhton and Power BI.๐
To get the project presentation click Here
This project addresses another businees problem In this context, I see myself as a data analyst employed at a news financial service company. The task involves visualizing data to help readers comprehend how countries have historically performed in Financial-Consuming.
To resolve this business problem, I followed several steps:
- Cleaning data in kaggle notebook.
- Exploratory Data Analysis (EDA) using Python.
- Utilizing the KNN algorithm to predict the missing values.
- Importing the output data to Power BI.
- Writing DAX formulas to extract specific measures.
- Building our final dashboard.
EDA and data cleaning
- Drop unnecessary columns
- Replace some missing values
- Remove duplicates
- Replace messing values with predictive values using KNN algorithm
- Use erangleing function
- Upload the final data to Power BI
Kaggle Notebook EDA notebook
Download the final dashboard from Here
Download the dataset from Here
Download the notebook from Here
Download the presentation from Here
For inquiries or further collaboration, please contact Saher Mohammed at [[email protected]] and Abdelrahman Ashour at [[email protected]].