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'>https://topmate.io/data_tutorials
For Important Data Analyst Materials and Other Resources https://topmate.io/data_tutorials'>https://topmate.io/data_tutorials
Follow me on Facebook https://www.facebook.com/profile.php?...
Follow me on LinkedIn   / swapnjeets58a673273  

Data Download https://docs.google.com/spreadsheets/...

⭐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    • Data Analyst Roadmap 2.0 | 2023  202...  
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    • Tableau Dashboard from start to end (...  
HR Dashboard    • Tableau Dashboard from Start to End (...  
Ecommerce Sales Dashboard    • Build Tableau Dashboard from Start to...  
IPL Dashboard    • Tableau Dashboard | IPL Analysis (Par...  
Customer Complaint Dashboard    • Tableau Dashboard | Customer Complain...  

Power BI Dashboard
HR Dashboard    • Power BI Dashboard from Start to End ...  

Excel Dashboard
IPL Dashboard    • Excel Dashboard (Hindi) | IPL Analysi...  
Ecommerce Sales Analysis    • Dynamic Excel Dashboard from Start to...  

➖➖➖➖➖➖➖➖➖➖➖➖➖
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.