Comprehensive Excel Project with Interactive Dashboard: From Data Gathering to Visualization

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- swapnjeet555@gmail.com 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- swapnjeet555@gmail.com 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.