Welcome to the Paris 2024 Olympic games Power BI Dashboard! This dashboard provides interactive visualizations and insights into the 2024 Olympic games data on a Power BI dashboard. A python script was used to download the Olympic dataset from Kaggle. Power BI desktop was then connected to python to load the dataset using custom scripts. The data were cleaned and transformed inside Power BI using Power Query and DAX. Finally, interactive figures were made to display the highlights of 2024 Paris Olympic Games, such as total medals by country, gender, and discipline.
Technologies
- Python: For data extraction and preprocessing
- Power BI: For creating interactive data visualizations
- DAX: Used in Power BI for creating dynamic and complex calculations
- Power Query: For data transformation and preparation in Power BI
- Canva: For designing the dashboard interface
Prerequisites
- Python (3.7+)
- Power BI Desktop
- Canva (optional, to design the background user interface)
- Kaggle API (to download datasets)
Steps
- Clone the repository
- Install python dependencies: copy code to bash 'pip install pandas numpy matplotlib seaborn'
- Download dataset: a) using the Kaggle API in python, or b) manually from Kaggle's website
- Load the data in Power BI
- Explore the data in Power BI and perform any necessary data cleaning and transformations
- Create interactive figures to visually explore the dataset
Sources