In this Excel video you will learn requirement gathering, data cleaning, processing, analysis and dashboard creation in Excel. Complete data analytics project for data analyst in Excel.
This video is specially made for beginners, intermediates, freshers, college students and recent pass outs. It will help in learning new skill. This video will help in getting a good hold on tools like Excel. By practicing this tool and developing similar dashboards one can even start with freelancing on international platforms.
Developing similar end to end deploy ready projects will help freshers/ beginners understanding the work flow of a project.
Book a 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - https://topmate.io/data_tutorials
For Important Data Analyst Materials and Other Resources - https://topmate.io/data_tutorials
Follow me on Facebook - https://www.facebook.com/profile.php?id=100095047697882&mibextid=ZbWKwL
Follow me on LinkedIn - https://www.linkedin.com/in/swapnjeet-s-58a673273
Data Download - https://docs.google.com/spreadsheets/d/1R_uaoZL18nRbqC_MULVne90h3SdRbAyn/edit?usp=sharing&ouid=116890999875311477003&rtpof=true&sd=true
Data Analyst Material available at very minimal cost of Rs. 999. This will include a complete Data Analyst Syllabus with video links, important pdf's, Q&A, this will also include Complete project on Excel (2 Projects), Tableau (2 Projects) and Power BI (1 Project). And the projects will be different from that uploaded on You Tube. If you are interested to buy contact me on my mail or WhatsApp.
For More info watch this Data Analyst Roadmap 2.0 video - https://youtu.be/_0i_VMeL-Zo
Details mentioned below-
email- [email protected]
WhatsApp - +91 9579005495
#exceltutorial #dataanalytics #dataanalystproject
For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
Steps Covered-
1. Requirement gathering from client
2. Identify the Stakeholders of the Project
3. Data cleaning as per the requirement
4. Data Processing by adding some customized columns in data
5. Data Analysis by Pivot Tables and Excel Functions
6. Data Visualization to create charts and custom sheets to show the insights
7. Report/ Dashboard creation from start to end
00:00 Introduction
01:03 Project Intro
02:27 Requirement Gathering
04:39 Stakeholders in Project
05:50 Metadata
07:19 Data Cleaning
12:15 Data Processing
15:03 Data Analysis
21:40 Data Visualization
32:57 Dashboard Building
01:30:47 Filter Panel
01:37:05 Panel Creation
01:39:25 Data Analysis Sheet Creation'
01:42:31 Outro
Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-
Tableau Dashboard-
Sales Overview Dashboard - https://youtu.be/NoppQVdd8U8
HR Dashboard - https://youtu.be/oAIubTqg-Kw
Ecommerce Sales Dashboard - https://youtu.be/pCpvlIr1yvs
IPL Dashboard - https://youtu.be/LX1LokapH4Q
Customer Complaint Dashboard - https://youtu.be/_EcRJQa3ZDM
Power BI Dashboard
HR Dashboard - https://www.youtube.com/watch?v=-sOHVl_iCHA&t=0s
Excel Dashboard
IPL Dashboard - https://youtu.be/urhI3pEBEBY
Ecommerce Sales Analysis - https://youtu.be/xHTUP1Dxu-M
Tableau Material available-
1. Tableau hand written notes
2. Tableau printed notes
2. Tableau important formulae print notes
3. Tableau important interview questionnaire
All these are available at very minimal cost of Rs.200 only, ping me on WhatsApp to get these.
Reach out to me for any personal or Business related Dashboard/ Report development on my email- [email protected]
WhatsApp - +91 9579005495
Related 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,
Disclaimer: All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for.
Data used in the video is a demo data, modified data and does not belong to any real time industry/ company/ government etc. Data used is only for practice purpose.