30/05/2023
Data Analytics is for All📊📉💹
Full Portfolio project on Data Analytics and Dynamic Dashboard with Excel loaded.
Tool: Only Microsoft Excel
Project: Data Cleaning, Transformation, Analysis and Dynamic Dashboard Report
In this project an Accident Data recorded in 2021-2022 was analysed and the following KPIs and EDA
- Total Casualties
- Number of Casualty by Severity
- No. of Casualties by Road Type, Vehicle Type
- No. of Casualties by Road Surface
- No. of Casualties by Lightning Condition
- No of casualties by Location
As a beginner Data Analyst you can use as a portfolio project and non-data analyst who deals with data can also use to create real time dynamic dashboard reports
If you like what I do please Subscribe to and Share channel ❤️
Tech is the future and must be accessible to all✅
Africa In this Excel Data Analytics tutorial I created a full project portfolio on Dynamic dashboard...