Complete Excel Project with Interactive Dashboard | Resume Project | Step-by-Step Tutorial
Вставка
- Опубліковано 10 лют 2025
- Complete Hospital Emergency Room Data Project in Excel | Interactive Dashboard Tutorial | 🚑 Master Hospital Data Analysis with Excel!
In this video, we will build a full Emergency Room Data Project in Excel with an interactive dashboard to analyse key hospital insights. This project is ideal for Excel users, Data Analysts, and Healthcare Professionals looking to improve data-driven decision-making.
🔍 Key Insights Covered in the Dashboard:
✅ Total Number of Patients
✅ Average Wait Time to See a Patient
✅ Patient Admission Status (Admitted/Not Admitted)
✅ Patient Age Distribution
✅ Gender Analysis
✅ Department Referrals
✅ Percentage of Patients Seen Within 30 Minutes
📊 We will use Power query to Extract and Transform data, Power Pivot to Create relationship and Add DAX Formula then Pivot Tables to generate reports, AND Data Visualization techniques to create an interactive dashboard that helps hospitals optimize emergency room operations.
💡 Who Should Watch?
✔ Student, Job Seeker and Job Transitioner, Aspire to become Data Analyst
✔ Data Analysts & MIS Professionals
✔ Healthcare Administrators & Hospital Staff
✔ Excel Enthusiasts & Beginners
✔ Anyone Interested in Data-Driven Decision Making
Download Practice File :skillcourse.in...
📌 Don't forget to LIKE, SHARE & SUBSCRIBE for more practical Excel projects!
#ExcelDashboard #ExcelProject #HealthcareAnalytics #HospitalData #DataAnalysis #PowerQuery #EmergencyRoom #excelforbeginners #dataanalyst #dataanalysis
Check your Knowledge : Test on Project : skillcourse.in...
Download Practice File from GITHUB : - github.com/Sat...
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Course Website :bit.ly/skill_c...
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/le...
------------------------------------------------------------------------------------------------------------------------------
For Short tips : / @skill_course
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more_pro
------------------------------------------------------------------------------------------------------------------------------
My UA-cam Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu
Really great project thanks Satish sir..
Timestamps of Project. Thanks me later. 🙂
0:15 Project-Intro
4:32 Project Steps
10:27 Purpose of Project
12:06 KPI's Requirement
13:50 Charts to Create
14:55 Understanding of Data
21:30 Data Connection Importing Data Using Power Query
22:50 Data Cleaning using Power Query
48:00 Data Modeling-Power Pivot
50:52 DAX Calculations in Power Pivot
1:03:13 Creating Pivots
1:11:40 Dashboard Layouting
1:45:40 Charts Development & Formatting
2:47:45 ChatGPT & LinkedIn
2:54:10 Add Repository on GitHub
I have Posted on my linkedIN Id as well as atteded the test given , Thanks a lot sir for sharing the such an interesting Project
Total Marks Scored - 160
Total Time Taken (In Min.) - 5
Total Questions Attempted - 20
बेहतरीन पढ़ाते हैं sir आप thank u
1:53:30 Your dedication is beyond appreciation. The amount of energy and time you put into this project is far superior to most similar paid courses. Could you keep it up? I am learning a lot from you. The only hurdle is that I am using Excel 2026 and sometimes the tabs or buttons are different as compared to the latest version.
date tak sab kuch samaj me aa gaya hai aur aapka samjane aur padhane ka tarika bahot badiya hai
Sir bht amaza aya saath saath dashboard bnane me kafi kuch bahut ache se sikhaya aapne...aapki itni energy aur efforts k liy thank u very much from the deep of my heart & upload more such dashboard videos for practicing
Sir Got it, But Your system seems to be a Little Slow......... You are the Best !! Everything is Free Here.
Thank you so much sir. Maza aa gaya project dekhkar.. awesome project..bahut kuch sikha maine is project me. Thank you once again sir..
Best Best Best, sirrrrrrrr, to be very honest, you are the best teacher on youtube ❤️
Thank you so Satish Dhawle Sir❤
Yous have a such wonderful teaching skills ❤
Thank You So Much 🙏 Ur Teaching skills are amazing...
This one is definitely the best-articulated project video I have seen so far. Thank you sir🙏
Great project ❤
Best channel I found until this date ❤
Excellent explanations 🎉
score - 160
time taken - 4min
questions attempted - 20
Thank You So much sir biggest fan of u from nashik
Sir SQL per bhi Project banaoo Please
Very very thanks sir Excel project ke liye. 🙏🙏🙏🙏🙏🙏🙏🙏
got it. Thanku so much, clear till now
everything is clear sir
Expecting this project to be a milestone in our learning.
Excellent video Sir 😊
Excellent sir. Thank you so much for this excellent explanation. I learnt more from you.
Wonderful Satish Sir really not only your video but also the method of teaching I am really fortunate that found you on YouTub
e channel
Sir You teaching Style Is Number 01 You Are My best Teacher I am From Pakistan But I live In Saudi Arabia
Bhai. Mereliye kuch accountant ka kaam hoto bathao. 5yrs experience he
thank you, got it, awesome explanation
Got it Sir, You are excellent
Thank you soo muchh sir !! 😌💛
Very nice Sir.......👍👍👍👍👍👍👍👍👍👍👍👍
Thanks Sir ❤
Amazing dashboard Sir
Wow project super trick sir jii 🙏
Thank you sir ❤
Superb Sir
Good UpTo calendar query ❤
Excellent Thanks
Thank you ❤
Superb 🙂😌
That's great sir
thanks
😊
Thanks a. Lot
thank u so much sir
Thank you sir
Awesome ❤🎉
Great 💯💯
Sir ek video Super market grocery shop ka banao kyoun ki usme products jyada hotehai aur quantity bhi jyada hote hai with different prices
good
Sir, please teach Tableau as well, just like you are teaching SQL and Power BI.
Dear Sir ❤
We need an advance SQL training videos to fullfil a professional requirements.
Thanks
GOT IT SIR
Got it 🎉
thanks sir
Sir I love you
Thankyou so much sir maja aa gaya 😊🎉
video start at 4:10
sir power bi DAX formulas 2 ki video upload kariye ga
Marks obtained = 140/200
Time Taken = 3 mins
Total Questions = 20
Sir, Can we make the same dashboard in IT Helpdesk Data also, Can you please suggest it. Thank you for your kid support and guidance🙂🙏
Total Marks Scored - 170
Total Time Taken (In Min.) - 4
Sir and Also One Request Kindly Give him a Coupon Code To By Your All In one Course.
Thank You
Your Student For Last 3 Year
Najeeb Khan
God Give you More in more Success❤❤❤❤
Got..it
got it
Sir, can u make a SQL project with interactive dashboard?
Total Marks Scored - 190
Total Time Taken (In Min.) - 6
Total Questions Attempted - 20
Satish Sir How to make dynamic charts in PowerPoint , please make the video
Sir 1 video data analysis ka roadmap 2025 ka bana do ke kay kay course and learn karna hota hai
satish ji age group ke liye |if(choose(match( " function bhi use kar sakte hai na
If you don't mind I would like to tell please uploaded DAX second vedio if it is possible .
Sir Kindly Create one Course Full Video On MS Access and Power Query
Sir, can't find any power BI end to end dashboard project like this one Excel project , on your youtube chanel videos
sir maja aa rha hai
Sir, It would be really helpful if we had timestamp.
Dear sir, How can I activate the column quality check box? It is not showing in my MS Excel power query.
❤️🙌
Everything was clear...but why you wrote #duration(1,0,0,0)...what is the meaning of 0...
Sir when i am applying "Age grojup" it is in pivot option but if i check in power query i cant see this coloumn there...wanted to do some correction in group name so isiliy power query me jake dekha but waha ye coloumn nahi hai aur pivot lagate hua option aa raha hai..pls btae what mistake am i doing
loaded sir
Sir how we can join your paid class
Sir please upload Tableu the basic of Tail You, we are waiting for us
Sir, dataset mein toh jan, feb & march ky records nhi hain, toh all month names toh hamary calendar table ki waja sy show horhy hain yeh cheez toh clear h, but, jan, feb march ki values Q aur kesy show horahi hain??? jbky is month ky dataset mein records hee nhi hainn
Sir certificate kaise milega Advance Excel ka
Is anyone having an issue with the date column? My date column is showing text data type when I am changing it to date/time it is giving me error.
There is error showing in Patient Date even when converting to Date, please provide solution for it. Thanks
Sir calendar list is not coming
How to get latest version of excel
sir option is not coming for merge columns
Sir I got blanks in calendar ( Date ) how can I fix it sir
Sir practice file download nahi ho raha hai kya kare.download me error show kar raha hai.
how i will get new excel version....how to download??
sir text box me no line kar dia from setting but abhi bhi grescale line show ho raha hai textbox outline me...what to do?
Resolved: I didnt click No line in Line option
sir mera date or time formate error show kar raha hai formate change bhi kya lekin thik nahi hora kuch cells per apply hora hai or kuch per error a raha hai
Change format to date than select the admission date again and right click on it, Choose remove error. Finally it converted into date
@@harshupadhyay05I got the same error....I did as u suggested....but after I did remove the error then that data got vanished
Change your time format according to data suppose day/month/year that format in the data so keep same in your pc
Sir I hv changed the location of the Data and it is not working...how to fix it?
Sir, ppt wali file not available
Hii Sir Good Evening Sir In the sheet you have provided, some dates are not appearing in the format. I went to the format and change it, but even after changing it, the format did not change.
Modify date datatype as date before importing to power query. (Use text to column -date (DMY) function)
bro can you explain more in detail. i even have same problem
@@saketh2047 in file date column is in text(general format) so before moving in Power query just change date datatype to date (here format is dd/mm/yyyy which excel didn't identify as date so we need change format to Mm/dd/yyyy using text to column function in data tab )
steps-
Select date column >>data>>text to column>>delimited>next>next>choose column data format as Date (MDY) >>finish
(here we told excel that consider this as date which is in DMY format)
Now your date column will work as date.
Isme kon sa job milega. Please koi bataye
Sir ms office nhi chal raha product key nhi
Free m.kese download kru sir
connection
Sir, Home button shows close & apply instead of Close & load to data. then how can i proceed to the next step.
Anyone here please help.
Yes I sc