Thank you so much for this tutorial. it is like a real-world project task. You took the time to explain every step of the data analysis using Excel. I really enjoyed the SQL and Power Bi you did as well. Pls, we would like to know how you created the ppt.
Appreciated on your video. I am interested to know more about creating background for the dashboard. I am currently working as HR so i request you to share me some more videos on this related field. I am basic level in using excel but i am interested to know more topics like leave tracker, KPI. Thank you for the detailed tutorial it's really worthy of watching and I recommend to my friends.
This is way far detailed and straight forward than all the several dashboard videos on UA-cam. I will follow your channel and recommend to those around me that are new in data analysis like me. Pls help us create more dashboard in excel as most of us are using excel. Thank you kindly
Plz tell me. 1) How to create backgroud...? 2) kya client hamy btaye ga k usy kya findings chahye jis k according ham pivot table sy charts wegara generate kry gy. Like report insight k lia Question provide kry ga..,?
Thank you very much for a well detailed lecture. Your videos are worthy of recommendation. Meanwhile, I want to request you to do a video of how I can do a background on Power Point. Thank you sir.
Thank you for the tutorial, much appreciate. However I have a question: I have three sheets: Summary, 101 (for tenant 1), and 102 (for tenant 2). The Summary sheet has a table that summarize all the tenants info, with columns for Unit No, Balance Due, Tenant Name, Telephone. On the Tenant sheets (101 and 102), I want to link specific cells to the corresponding columns in the Summary sheet. This way, the Summary sheet will be automatically updated with information from the Tenant sheets. For example, on each Tenant sheet, there is a cell (I7) for Unit No. that I want to link to the Unit No column on the summary, Cell K5 to link to the Balance Due column, Cell C7 to link to the Tenant Names column, and Cell C9 to link to the Telephone column. In that I way, I will have first row for tenant 101 and all the details second row for tenant 102 and all the details, and so on. I know I can use “=’101’!I7 for refence, but what if I have 1000 tenants? This will be a lot of work. So I want a formula or VBA code to automatically and dynamically update the Summary sheet even if additional tenant sheets are added. Is it possible?
Hi, This data is not more complicated but as manufacturing background our data is much complicated like PRODUCTION REPORT , FINANCIAL ...ETC, can you please make some on this...
Thank you for this amazing dashboard creating forecasting report data , could you please help and share excel working sheet with me for practice data analytics
Branch Dashboard 1. Branch dashboard to discuss New and renewal business number with each branch. This dashboard will be discussed between Corporate team and Individual branch heads. a. Individual performance within the branch: i. Target FY from Individual target sheet (New, Cross sell and Renewal) Fields to be referred (Column C, E, F and G) ii. Placed Achievement form Brokerage + Fees sheet (New, Cross sell and Renewal) (Brokerage sheet: Column G, J, M, K, L) (Fees Sheet: B, D, E, F, G) iii. Invoiced Achievement from Invoice sheet (New, Cross sell and Renewal) Column (B, F, G, J) iv. Percentage of Achievement for Placed and Invoice - (Achieved/budget) v. No of meetings for current year - Meeting sheet (A, C, D) vi. Open Oppty - Opportunity report (Column: C, E, F, G) (Stage ‘Open’ Column G = Propose Solution & Qualify Opportunity) vii. Closed Won - Opportunity report (Column: C, E, F, G) (Stage ‘Won’ Column G = Won) viii. Conversion Ratio (Closed Won/Total Opportunity) ix. Further drill down to individual level top 10 open oppty and Win KPI List 1-No of Invoice by Accnt Exec 2-Yearly Meeting Count 3.1Cross Sell--Target,Achive,new 3.1New-Target,Achive,new 3.1Renewal-Target, Achive,new 4. Stage Funnel by Revenue 5. No of meeting By Account Exe 6-Top Open Opportunity Sir pls insurance excel project pls urgent excel Dashboard
hi need you guidance , while watching your vedio how to creat backgroud I can able to creat thanks for that but when I paste into excel not able to write anything or not able select that copy paste background, kindly help me
@data tutorials hi......would you please share if possible from where you have downloaded those images of icons that you are using on the dashboard? As some of them is not available in MS
Hi swapnajeeth really liked your work your videos are very useful for me and for my project. Can you please also make a video on how to make background for tablue dashboard the one which you made for hr analytics is simply superb.
Hello. When you filter the Job Satisfaction column in the dataset, the maximum number is 4. With that, I think it's safe to assume the scale is 4 instead of 5
![How to build an Interactive HR Dashboard in Excel | HR Analytics in Excel [2024]](http://i.ytimg.com/vi/0IFYY7a5pAo/mqdefault.jpg)
Thank you so much for this tutorial. it is like a real-world project task. You took the time to explain every step of the data analysis using Excel. I really enjoyed the SQL and Power Bi you did as well. Pls, we would like to know how you created the ppt.
can you share the link of the sql here please
क्या बोलू ,कोई शब्द ही नही रहा मेरे पास@ मन ही मस्त हो गया
Yes, would love a video on creating backgrounds for excel
The video is already uploaded on how to create a background
Where is this video on creating the background for dashboard
Thank you so much Data Tutorials for helping build a dashboard confidently with your details guidance video. The outcome is exciting
Appreciated on your video. I am interested to know more about creating background for the dashboard. I am currently working as HR so i request you to share me some more videos on this related field. I am basic level in using excel but i am interested to know more topics like leave tracker, KPI. Thank you for the detailed tutorial it's really worthy of watching and I recommend to my friends.
Glad it was helpful!
This is way far detailed and straight forward than all the several dashboard videos on UA-cam.
I will follow your channel and recommend to those around me that are new in data analysis like me.
Pls help us create more dashboard in excel as most of us are using excel.
Thank you kindly
Very insightful video, I make this project and share it on my resume for data analyst role.
@ did you selected in any company?
@@_--98 not yet !
Plz tell me.
1) How to create backgroud...?
2) kya client hamy btaye ga k usy kya findings chahye jis k according ham pivot table sy charts wegara generate kry gy. Like report insight k lia Question provide kry ga..,?
Thank you very much for a well detailed lecture. Your videos are worthy of recommendation. Meanwhile, I want to request you to do a video of how I can do a background on Power Point. Thank you sir.
Thanks for the very informative video and detailed about the topic !! Recommended for the new learners :)
It's beautiful thank you to dashboard
Thank you for the tutorial, much appreciate. However I have a question: I have three sheets: Summary, 101 (for tenant 1), and 102 (for tenant 2). The Summary sheet has a table that summarize all the tenants info, with columns for Unit No, Balance Due, Tenant Name, Telephone. On the Tenant sheets (101 and 102), I want to link specific cells to the corresponding columns in the Summary sheet. This way, the Summary sheet will be automatically updated with information from the Tenant sheets. For example, on each Tenant sheet, there is a cell (I7) for Unit No. that I want to link to the Unit No column on the summary, Cell K5 to link to the Balance Due column, Cell C7 to link to the Tenant Names column, and Cell C9 to link to the Telephone column. In that I way, I will have first row for tenant 101 and all the details second row for tenant 102 and all the details, and so on. I know I can use “=’101’!I7 for refence, but what if I have 1000 tenants? This will be a lot of work. So I want a formula or VBA code to automatically and dynamically update the Summary sheet even if additional tenant sheets are added. Is it possible?
can you create a videos on ,creating excel projects from downloading data from kaggle and cleaning the data
Yes it's very easy to create dashboard within time, plz can u create and upload a vedio.
Video is already available
It's really perfect please help us to explain how to create background
Yes pls
Great job!! Very informative 😊
Hi, This data is not more complicated but as manufacturing background our data is much complicated like PRODUCTION REPORT , FINANCIAL ...ETC, can you please make some on this...
My boss got happy after I made the HR Dashboard after watching this video
great work..nice way of presentation
This is awesome, please can you do a video on how to create a background for different dashboard
Video already available on my channel
it is very helpful thank you ❤
WOW. Thank you sir!
Very welcome!
Thank you for this amazing dashboard creating forecasting report data , could you please help and share excel working sheet with me for practice data analytics
Could you please share link for youtube video on creating background
Hello Sir, can u do a vedio on creating Background Template
Very helpful sir!
Are ye file Excel me kese import hoge
Wonderful video.
Sir, can you make a video on how to create a beautiful backgrounds.
Branch Dashboard
1. Branch dashboard to discuss New and renewal business number with each branch. This dashboard will be discussed between Corporate team and Individual branch heads.
a. Individual performance within the branch:
i. Target FY from Individual target sheet (New, Cross sell and Renewal) Fields to be referred (Column C, E, F and G)
ii. Placed Achievement form Brokerage + Fees sheet (New, Cross sell and Renewal) (Brokerage sheet: Column G, J, M, K, L) (Fees Sheet: B, D, E, F, G)
iii. Invoiced Achievement from Invoice sheet (New, Cross sell and Renewal) Column (B, F, G, J)
iv. Percentage of Achievement for Placed and Invoice - (Achieved/budget)
v. No of meetings for current year - Meeting sheet (A, C, D)
vi. Open Oppty - Opportunity report (Column: C, E, F, G) (Stage ‘Open’ Column G = Propose Solution & Qualify Opportunity)
vii. Closed Won - Opportunity report (Column: C, E, F, G) (Stage ‘Won’ Column G = Won)
viii. Conversion Ratio (Closed Won/Total Opportunity)
ix. Further drill down to individual level top 10 open oppty and Win
KPI List
1-No of Invoice by Accnt Exec
2-Yearly Meeting Count
3.1Cross Sell--Target,Achive,new
3.1New-Target,Achive,new
3.1Renewal-Target, Achive,new
4. Stage Funnel by Revenue
5. No of meeting By Account Exe
6-Top Open Opportunity
Sir pls insurance excel project pls urgent excel Dashboard
please create a video for creating dash board .. Thanks
Even though there is no blanks in my data set , even after downloading fresh I m getting blanks in pivot notable how to rectify it
Thank you sir
PLEASE CAN YOU DO A VIDEO ON HOW YOU CREATED THE LAYOUT ON POWER POINT?
PLEASEEEEE
There is no option of download menu by after clicking on link pls tell me❤❤🎉???
hi need you guidance , while watching your vedio how to creat backgroud I can able to creat thanks for that but when I paste into excel not able to write anything or not able select that copy paste background, kindly help me
@data tutorials hi......would you please share if possible from where you have downloaded those images of icons that you are using on the dashboard? As some of them is not available in MS
Flaticon website
please i need link to download the data, can't download it with the one one the page
please make a video how to create a background in dashboard
Already created and uploaded on channel
How to create dashboard backgrounds?
SUPER
Hi swapnajeeth really liked your work your videos are very useful for me and for my project.
Can you please also make a video on how to make background for tablue dashboard the one which you made for hr analytics is simply superb.
What did you do with the 'balance rating' and the percentage after that i didnt understand.please explain
Didn’t get your quesy
Pls the dataset I downloaded doesn’t have attrition count in it so pls how can I include it in excel?
awesome idea
Thanks a lot
Where can I get the data you used?
How can i make background layout can anyone help me pls? 🙏
Please create dashboard background
What is meant by "Attrition?" Is that current active headcount?
Attrition is the departure of employees from the organization for any reason
Can you make a Dashboard for my employees ?
I have a doubt job rating lies b/w 1 to 5, then 5 should be max right?? u have taken 4 as max?
Hello. When you filter the Job Satisfaction column in the dataset, the maximum number is 4. With that, I think it's safe to assume the scale is 4 instead of 5
how do i create this visual frame with power point
from where can we get excel data ?
Available in description
Its seems that there is an issue with "Technical degree and Genders." Hope that I am wrong in my approach..
how did u calculate cf value can u plz explain
That was a part of cleaning and preparing the data
We need to create an age range table and then use that table as a reference to specify the age groups for the main table. This is done using Vlookup
Please send the link of HR Analytics in Power BI
Nice But SPRB BRO
U explain well but u can explain in hindi.we can understand much better
My technical data is coming incorrect rest all data is working fine can anyone help me please?
Check the raw data by applying filters
can u please send dashboard
Where to get the background from ?
Link available in the description of the video
I want to know how to create background for the dashboard
ua-cam.com/video/IOzvRueiYi8/v-deo.html
data set
Hi sir my star rating is inverted ie from left to right how can I correct it
Sort it in other way
the file that you share has only a view only option how to download and like how to copy the designs?
You have download option in File menu
Thank you so much for ur timely even I was facing the same issue
@harish1838 there is a download option available in row at last
How can I get the background
Background link in description box
I need this raw data
Link available in description
HI Sir , really liked your work your videos are very useful for me and for my project. but i need your background PPT please send me
It’s available at link mentioned in description box
Hind me chahiye plz
Hind me chahiye
Plz
I want ur help sir can I get ur no