Thank you so much Data Tutorials for helping build a dashboard confidently with your details guidance video. The outcome is exciting
@gaythria9376
Жыл бұрын
Great job!! Very informative 😊
@sagarpremupadhyay12
9 ай бұрын
क्या बोलू ,कोई शब्द ही नही रहा मेरे पास@ मन ही मस्त हो गया
@vetrip7153
Жыл бұрын
Thanks for the very informative video and detailed about the topic !! Recommended for the new learners :)
@abelejonathan4686
11 ай бұрын
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.
@Values247
Жыл бұрын
This is way far detailed and straight forward than all the several dashboard videos on KZitem. 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
@ronymurickan8976
8 ай бұрын
great work..nice way of presentation
@brunokadiat87
Жыл бұрын
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?
@kwizeraemmanuel1458
9 ай бұрын
Very helpful sir!
@shahabkingyt6082
Ай бұрын
it is very helpful thank you ❤
@tseongjay7574
10 ай бұрын
WOW. Thank you sir!
@datatutorials1
10 ай бұрын
Very welcome!
@ashokkumar007
Жыл бұрын
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
@kajalahuja1939
Ай бұрын
My boss got happy after I made the HR Dashboard after watching this video
@user-mz3sm6fl2k
5 ай бұрын
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.
@sundayamoo84
5 ай бұрын
can you share the link of the sql here please
@baburao.0188
8 ай бұрын
Thank you sir
@kunalkumaraiml2365
8 ай бұрын
Very insightful video, I make this project and share it on my resume for data analyst role.
@_--98
4 ай бұрын
@ did you selected in any company?
@kunalkumaraiml2365
4 ай бұрын
@@_--98 not yet !
@kawaljeetsinghrao7198
10 ай бұрын
Wonderful video. Sir, can you make a video on how to create a beautiful backgrounds.
@vishnuvardhan-fe4zj
Жыл бұрын
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.
@SagarsDataJourney
10 ай бұрын
can you create a videos on ,creating excel projects from downloading data from kaggle and cleaning the data
@sandhyakonda6169
Ай бұрын
SUPER
@januarisihite8796
Жыл бұрын
awesome idea
@datatutorials1
Жыл бұрын
Thanks a lot
@Khodexboi1
Жыл бұрын
This is awesome, please can you do a video on how to create a background for different dashboard
@datatutorials1
Жыл бұрын
Video already available on my channel
@laminsesay3592
Жыл бұрын
It's really perfect please help us to explain how to create background
@user-hq5gr9hk1j
8 ай бұрын
Yes pls
@tammyschmitt1991
7 ай бұрын
Yes, would love a video on creating backgrounds for excel
@datatutorials1
7 ай бұрын
The video is already uploaded on how to create a background
@tammyschmitt1991
7 ай бұрын
Where is this video on creating the background for dashboard
@jyothirmaivangara635
6 ай бұрын
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.
@datatutorials1
5 ай бұрын
Glad it was helpful!
@anuraggupta8002
4 ай бұрын
please make a video how to create a background in dashboard
@datatutorials1
3 ай бұрын
Already created and uploaded on channel
@bhuvaneswaisiva6223
11 ай бұрын
please create a video for creating dash board .. Thanks
@user-cs3hq9tb8j
9 ай бұрын
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...
@XYZ-rv6qf
10 ай бұрын
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..,?
@kameshsubramanian2553
6 ай бұрын
Could you please share link for youtube video on creating background
@estherchidinmanwakwuo
Жыл бұрын
Pls the dataset I downloaded doesn’t have attrition count in it so pls how can I include it in excel?
@mohanrajuamakatadu2586
9 ай бұрын
Hello Sir, can u do a vedio on creating Background Template
@jaynebarth2939
7 ай бұрын
PLEASE CAN YOU DO A VIDEO ON HOW YOU CREATED THE LAYOUT ON POWER POINT? PLEASEEEEE
@priyank-li9qc
10 ай бұрын
Yes it's very easy to create dashboard within time, plz can u create and upload a vedio.
@datatutorials1
10 ай бұрын
Video is already available
@bhavanapitale3758
2 ай бұрын
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
@emmanuelulu5878
11 ай бұрын
how do i create this visual frame with power point
@danielledeboer1915
Жыл бұрын
What is meant by "Attrition?" Is that current active headcount?
@datatutorials1
Жыл бұрын
Attrition is the departure of employees from the organization for any reason
@user-ql3nj8hk1n
11 ай бұрын
Please send the link of HR Analytics in Power BI
@1Mrsmock
6 ай бұрын
Where can I get the data you used?
@RachaelAlufa
18 күн бұрын
please i need link to download the data, can't download it with the one one the page
@abdulrashidsayed5357
Жыл бұрын
Its seems that there is an issue with "Technical degree and Genders." Hope that I am wrong in my approach..
@Rabbani_World_Flock
6 ай бұрын
There is no option of download menu by after clicking on link pls tell me❤❤🎉???
@Sristi-to6vh
7 ай бұрын
What did you do with the 'balance rating' and the percentage after that i didnt understand.please explain
@datatutorials1
7 ай бұрын
Didn’t get your quesy
@Cricstory0108
Ай бұрын
Are ye file Excel me kese import hoge
@jitheshj6870
Жыл бұрын
how did u calculate cf value can u plz explain
@datatutorials1
Жыл бұрын
That was a part of cleaning and preparing the data
@datatutorials1
Жыл бұрын
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
@gauravrai2569
Жыл бұрын
Hi sir my star rating is inverted ie from left to right how can I correct it
@datatutorials1
Жыл бұрын
Sort it in other way
@dorcasagyeman-duah6826
Жыл бұрын
I want to know how to create background for the dashboard
@datatutorials1
Жыл бұрын
kzitem.info/news/bejne/qoWw3IarnpuKnG0
@SAMProductions705
8 ай бұрын
Can you make a Dashboard for my employees ?
@Iamshilpikanaujia
16 күн бұрын
How to create dashboard backgrounds?
@raveenachoudhary9817
8 ай бұрын
I have a doubt job rating lies b/w 1 to 5, then 5 should be max right?? u have taken 4 as max?
@efeomoghene7911
8 ай бұрын
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
@seemarathi3296
Жыл бұрын
Plz
@raishradha
9 күн бұрын
data set
@reviewvideoes5006
Жыл бұрын
the file that you share has only a view only option how to download and like how to copy the designs?
@datatutorials1
Жыл бұрын
You have download option in File menu
@harish1838
11 ай бұрын
Thank you so much for ur timely even I was facing the same issue
@datatutorials1
11 ай бұрын
@harish1838 there is a download option available in row at last
@Fikadu-xs5sw
Жыл бұрын
How can I get the background
@datatutorials1
Жыл бұрын
Background link in description box
@NITINCHAVAN-vv9uy
4 ай бұрын
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
@NikhilGuptha-fy5le
2 ай бұрын
can u please send dashboard
@SAMProductions705
8 ай бұрын
Where to get the background from ?
@datatutorials1
8 ай бұрын
Link available in the description of the video
@dhruvgotawala2444
9 ай бұрын
from where can we get excel data ?
@datatutorials1
9 ай бұрын
Available in description
@seemarathi3296
Жыл бұрын
Hind me chahiye plz
@_MdArifurRahman
Жыл бұрын
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
@datatutorials1
Жыл бұрын
It’s available at link mentioned in description box
@lokeshmoolya5569
7 ай бұрын
My technical data is coming incorrect rest all data is working fine can anyone help me please?
@datatutorials1
7 ай бұрын
Check the raw data by applying filters
@ROHITSINGH-fv2fw
9 ай бұрын
U explain well but u can explain in hindi.we can understand much better
Пікірлер: 97