Thank you so much Data Tutorials for helping build a dashboard confidently with your details guidance video. The outcome is exciting

क्या बोलू ,कोई शब्द ही नही रहा मेरे पास@ मन ही मस्त हो गया

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.

This is way far detailed and straight forward than all the several dashboard videos on KZfaq. 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

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.

Yes, would love a video on creating backgrounds for excel

Very insightful video, I make this project and share it on my resume for data analyst role.

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.

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..,?

My boss got happy after I made the HR Dashboard after watching this video

Thanks for the very informative video and detailed about the topic !! Recommended for the new learners :)

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?

Great job!! Very informative 😊

It's really perfect please help us to explain how to create background

Are ye file Excel me kese import hoge

This is awesome, please can you do a video on how to create a background for different dashboard

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

It's beautiful thank you to dashboard

can you create a videos on ,creating excel projects from downloading data from kaggle and cleaning the data

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

it is very helpful thank you ❤

WOW. Thank you sir!

great work..nice way of presentation

Yes it's very easy to create dashboard within time, plz can u create and upload a vedio.

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.

Wonderful video. Sir, can you make a video on how to create a beautiful backgrounds.

Very helpful sir!

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

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

Could you please share link for youtube video on creating background

please i need link to download the data, can't download it with the one one the page

PLEASE CAN YOU DO A VIDEO ON HOW YOU CREATED THE LAYOUT ON POWER POINT? PLEASEEEEE

What is meant by "Attrition?" Is that current active headcount?

How to create dashboard backgrounds?

There is no option of download menu by after clicking on link pls tell me❤❤🎉???

Thank you sir

SUPER

Hello Sir, can u do a vedio on creating Background Template

please make a video how to create a background in dashboard

Its seems that there is an issue with "Technical degree and Genders." Hope that I am wrong in my approach..

I have a doubt job rating lies b/w 1 to 5, then 5 should be max right?? u have taken 4 as max?

What did you do with the 'balance rating' and the percentage after that i didnt understand.please explain

please create a video for creating dash board .. Thanks

awesome idea

Pls the dataset I downloaded doesn’t have attrition count in it so pls how can I include it in excel?

Where can I get the data you used?

Please create dashboard background

how do i create this visual frame with power point

how did u calculate cf value can u plz explain

Please send the link of HR Analytics in Power BI

from where can we get excel data ?

Can you make a Dashboard for my employees ?

Hi sir my star rating is inverted ie from left to right how can I correct it

Nice But SPRB BRO

can u please send dashboard

the file that you share has only a view only option how to download and like how to copy the designs?

My technical data is coming incorrect rest all data is working fine can anyone help me please?

I want to know how to create background for the dashboard

Where to get the background from ?

data set

U explain well but u can explain in hindi.we can understand much better

How can I get the background

Plz

Hind me chahiye plz

Hind me chahiye

I need this raw data

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

I want ur help sir can I get ur no