Data Analyst Project For Beginners (HR Analytics): 6 - Closing

Key Takeaways

we have created the dashboard but our stakeholders want more they have a real-time business needs such as sending alerts automatic data refresh setting security levels for data you will also understand how a data analyst scopes the requirement for future bills from this session [Music] [Music] okay so now we got the dashboard have any questions you have any anything to check i have one uh like uh can i get any notification over my email id like just like your triggers let's say if the attendance is less than 80 percent or 75 percent because uh um actually i'm very busy on a weekday right i don't have time to uh see dashboard each and every time it would be easier for me to understand the percentage yes you totally understand what you can do is like the next step is like we will publish this dashboard to the cloud okay so once you publish the dashboard you get an option there to create uh like you know this is this is you know in the power bi language lingo this is called a report so once you publish this report online you can create certain dashboard from the visuals so you can create a visual this visual you can add to a pin to a dashboard and from there you can create an alert so if the presence percentage is less than 70 send the email to pineal like uh email address into a couple of other people so that email will say the presence percentage is in 70 here the list of people who are present today and all the you know it will send the excel sheet along with you uh this this particular table along with that so we cannot yes we can do that it's it's possible that's great that's really interesting because even i would like to get that kind of notification yes uh and for the viewers uh we have covered publishing reports to power bi setting up notification all of this in our paid course on code basics dot io the course name is get job ready uh power bi data analytics so in that course we have covered all of these advanced concepts the link of the course you'll find in the video description below so check it out or just simply visit code basics dot io all right now moving on to our actual discussion so i know i'm kind of taking uh i'm playing two different roles double the instructor for code basic channel and athletics founder and manager uh so one question i have uh is right now we uploaded once fixed file okay but file will keep on uploading so i don't think it's it's it's gonna be very cumbersome for a click hr person to give you this file every day can we have some kind of automatic setup maybe we put file somewhere on cloud and just definitely that is that is definitely the point so either you know power bi offers integration to many things so what i did this right now is just to import text book directly just to show how it is done but ideally you know it can be put in a sharepoint folder a common drive and i think if this is the google sheet there is also option to directly connect to a google sheet i think yes you can also connect to a google sheet directly so if it is updated there are a lot of ways to do that and uh normally what i would prefer is to put it in the sharepoint folder and and it is connected to the sharepoint and the data gets updated every one hour every half an hour or something like that we can set up things like that and uh no one needs to you know like update the excel sheet or you know like do something so once you've created this and it's completely automated that's the solution all right next question i have this is pretty useful by the way so yeah using sharepoint is a good idea next question i have is i want to make this dashboard available to people in my organization obviously manager level people will have access of full dashboard but employees so that they can see the trend etc they need to have access of only the charts because i don't want employees to look uh you know check the business percentage and all of that for other employees you know it's not very healthy work environment yeah so can we have that visual level privileging yes there is a option in power bi uh that's called row level security and even object level security there is an option there in power bi we can do that um there is a there is a better option in terms of you know because if you create this dashboard and if people are saying blank space here it does it doesn't look correct it looks patchy all right what else yeah recommend is like publish a dashboard publish this dashboard for the management level people and uh give access to them so once you publish this dashboard on the cloud this creates a data set underneath so this dashboard or report sits on a data set so we can use the same data set on the cloud to create another dashboard with with just the trend not the not the underlying data so that is that is you know that i think is a better idea so there will be two different reports but both will be using the same data so same data set everything is same it's not like there are two separate entities they are the same entity but two different interfaces got it so like you have presence right now right so you can create presence view for all and all we have to do is just copy paste visuals so it is as as good as that very good yeah all right i have one more question i got pretty excited by the way after looking at this uh dashboard so the next question i have is i'm looking at the chart and most of the people they prefer working from home on friday so finally maybe in the future like when we go in this hybrid work model uh we can have fridays like work from home for all right and if people are working from home on that day then if you have some you'll maintain and some electricity work or you know some infrastructure repair uh we can should do that kind of work on friday usually we do saturday sunday also but then you know that can be good utilization of resources other thing we can do is when if you decide to go in hybrid work from home model where people are working only three days they're working from home on two days maybe we can ask people to take turns so that let's say there are the capacity of our office let's say is 80 people and we have 100 employees maybe we can ask them to take turn on a day so that we don't have to rent space for 20 additional people we can have people take turn and create a system where people come on alternate days and we can save on the rental cost all right great those are the only uh points i had uh thanks hamannan uh for helping us build this live and we are going to provide a link of this dashboard the data everything in the video description below so folks go check it out if you have any question post in a comment box below perfect it's a pleasure thank you thank you very much so how do you feel if you are hr manager yourself you probably found this useful because this was from your domain but even if you are not from hr you still found a project that you can use to learn data analytics and this is something you can put on your resume as well now i have a good news to share just like pinali you can also come on this show and we will help you build live data analytics dashboard you can be from any domain you can be chartered accountant you can be a salesperson a warehouse manager any domain wherever there is data there is data analytics so all you have to do is check video description below there is an email id send us an email and mention your use case what kind of data set you have what kind of business problem you are facing what is your domain and we will invite you on this channel so that way you will learn data analytics live with us and also you will get an opportunity to present yourself on this youtube platform i hope you found this series useful and i will see you in the next data analytics series [Music]