Full Data Analytics Portfolio Project - Creating Dynamic Dashboard with excel Part 1

Описание

#USA #UK #Kenya #Ghana #Nigeria #South Africa #india #indonesia

In this Excel Data Analytics tutorial I created a full project portfolio on Dynamic dashboard with Microsoft Excel

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✅

Download Links
https://docs.google.com/spreadsheets/d/12T_80iTa-kyik4nex5JPC4kKjHh6vHqZ?rtpof=true&usp=drive_fs

Watch also

Sales Analysis with PowerBI
https://www.youtube.com/watch?v=Yi-cd0iaybY

Data Cleaning with excel
https://youtu.be/LoIRnuH-ls8

Excel Use Case
https://youtu.be/sz9AIYbjbr8

Payroll Calculator with excel
https://youtu.be/VWIve3Kej0o


SUBSCRIBE!
Do you want to become a Data Analyst? This channel is about Data Analytics and my mission is to help you learn data analytics to start a career in Data Analytics. Please subscribe, share, like and click on notification bell so not to miss out on any content!


Voluntary Support
If you like my videos and want to buy me a coffee do so here
https://www.buymeacoffee.com/kwakutheanalyst


Websites:?
Website: https://gitdataanalytics.com
LinkedIn: https://www.linkedin.com/in/alex-kwaku-ayensu-darpah-595416169/
GitHub: https://github.com/rasdarps
Telegram: https://t.me/+_PwShocBkMAwZDg0


keywords:
data analyst project, data analyst project for beginners, data analyst portfolio project, data analysis project, data analyst projects for resume, data science project, data analyst excel project, excel tutorial, excel tutorial for beginners, end to end project for data analyst, excel project for data analyst, excel project, report in excel, dashboard in excel, data analyst portfolio project data analyst project data analysis project data analyst projects for resume data analyst sql project end to end project for data analyst sql project for data analyst project for beginners sql portfolio project data analyst sql project data analyst full project data analyst resume project sql project power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, Tableau, tableau dashboard, tableau tutorial, SQL, SQL project