Help Me With Sign Idaho Banking PPT

Industry sign banking alaska ppt safe

[Music] alone anyone how are you this is valid this mind from softe gram one of our friends on YouTube channel asked me to make fancy and pretty effective automated dashboard so today I am going to show you how to make good - poll this dashboard can summarize your data or in statistic or any performance as your business troll as you see here this dashboard example for HSE monthly dashboard or safety dashboard showing all record in monthly basis for example starting by date automated total manpower Luton an hour and some actions or unsafe actions or conditions with HD statistics like a positive or negative also safety observations which captured during the work at workplace also training hours and injuries records like frequency of lost time and what time want to see you you can do like this dashboard as per your request like profits or like business second thing in this video tutorial will learn two things first how to make the backend data of this dashboard on excel sheet I already prepared these that Apple excel sheet which we can use it filled about one and second we will make wooden help to design and make the skeleton of this dashboard let's start and see how can we link it between Excel and the dashboard on PowerPoint this link shall be automatically but in this case we will make in linking manually because automatic update of the data needs visual basic code and this would be on next on other video tutorial let's start for facing how to make it the back end back in on exertion and let's see this excel sheet which we really prepared our prepared as you see here will start the back end of the data an excel sheet I see here I already divided this excel sheet I prepare the data previously we do our charts or our dashboard on certain information like dates and powers as you seen from both heels I said just all I mainly three companies you can make more three company he was in and the newfound total of these men powers as a submissions also man hours each company you have to insert it in and you give you the total of man-hours leading indicators and lagging indicators these are performance indicators but this will not be included in our dashboard it shall be included another page but this idea who can be inserted to increase your dashboard also here we inserted the unsafe condition or unsafe acts it's divided to positive and negative and here we have a summarize for each items total of this acts also be used in our dash and this trick down for this observation seem like work permit traffic PPE and false and each item has its records and they finally have a total this for injured this for injuries and the records like each year as a performance it with 2017 till 2020 and severity it is records also related to the injuries and it is can be inserted also as a chart and last one is training our records and the old topics be used and C training like working at Heights working permit lifting excavation is example for using this data but you can insert what uni let's start first by first item will sedate here this the date as we said it functions equal today give you the currently if you will current date you can say its function equal today and between project this a function of the excels second thing you have to choose the forms of this day what type form you need it is up to you so when we go to the phone and we find here will use this bitter form but you can use it like this for all these up to you frankly I prefer to use this date for then I said ok this sanic steps to come across here which is a tracks which will be used or builded on the dashboard about what is this tracks H here we can make they did like a chart we making a searched normal chart for example we can take it Coulomb we can take normal column chart here and we remove everything from it just one visited yeah we remove this we can take this item make it delete also making format chart area filling no filled also lines or borders no lines for border also which are here no Phil no line data of this chart can say add data label this what we did so also make no fill to the columns and no why now as you see here the date is single as this D can automatically update once we change how every day once we change like just we resize the date and we can make enclosure he'll increase its size and blow for example forty precise size this main idea of this dashboard which it used the newer data and the data chart this is the first thing we did it for the date we have a charge will have charge of the direct second things we have to select our statistics mumble so we will insert another type of a chart and served here for example would exist x coulombs or yes the coulombs company Company B Company seen we can up to you live the axis just remote chart title and move line it and background no fell near no drove this years only show that a table add data labels on the style and order no lines field for jeepers this second one more thing to add it here in this chart right here is Atherton if I need the total to be mentioned with the dashboard and we do the same as we did in the date so I'll make it now and you have I have to increase the speed of the video to save your time relax and watch what we are [Music] okay so now we here we have a lamp our ready our data will be used first chart and the total manpower will insert it here put it here - we the same issues will go to man-hours but with different type of chart will show for example we can I can take man-hours and you you you hmm you you no field I can remove this axis that a data label also not take no line no Phil no Porter and I have to resize okay and I have to assert it here to be played used later for our dashboard also the same total we can take this like control D or Kobe monitor here chart design selected data we can use data for total of men are and save times and so on and the fair show a data label - please its various like this - you show in you now we have our data already well listed we live leading indicators and lag indicator as I mentioned before will come to unsaved add and conditions here we can use it to pie chart for percentage and also here we can use another chart so for in and save act or unsafe conditions or any percentages indicator you can use insert our pie chart with this track you have to see we'll do something it sorry we can to let chart selected at the beginning we'll take this to that we enter this our pie chart spy chart is divided to two sections while making the application for it we know later why I make it first to avoid read let the first one I've used a positive and second I put the negative so here we use positive first we can remove every data from 40 negative part we can go to fill option I'll see this option also filling a low fiddle blue and also the line no lie here also can say no the line and the color will be changing what we needed in the dashboard also this first one for positive the wolf and at the chart here no line no fail and we resize it to be like this this for positive also the records of positive will do as we did before the conscious take this control lordy yeah and we selected that actual design selected that roars or letter here for positive unsafe acts first positive positive here inter okay show that a table or a data label if no film and here we can resize smell clear mean but here in the middle so once I change this data the chart will change under that charity and for example if we make it here 200 let's change it and the charge also a change it and also the total change that's what we it's our boss we come here for the second part will be the same to the same so as repeat the video just sit back and watch what we do will making this for negative part [Music] here we back again as you see here we positive and negative but it intermittent increase its size later and so on okay so this section already done just only the total will do as we make it here on protein total number change data format change select data it was total unsafe act unsafe conditions just remove no feeling and data they were and so on okay next part of this observation says it's we can use column charts for the actions we will use on answer yeah our charge to pulse this up to you yeah you can select or change any the chart design up to you as you need this your dashboard and can do whatever just I'm here for showing you or just to give you example and you can change this parameter also in your is what you need we gotta change here should add data labels you can remove this part here also will take the total you short time after learning select them I'll speed up the video for tinnitus next to chart to avoid repeating how to avoid pouring on just your legs and watch what they do and be ready to go to the next step [Music] [Applause] [Music] here we coming to the last step for the excel preparation account which training hours answer take this type okay teacher Wolfgang background nothing we'll get nothing open your line no.9 and insert circuit first the shame that our liver okay this was our the first part of the video I think we can take total also train our control the duplication we stood here first week changes also data select data pshh no Phil no no no our back in excel sheet is our data is ready accessor our next second think of this video who have learned how to make the dashboard which already updated to with this background let's go and see how to design this how can you use could link it between these two port between Excel and PowerPoint here here is our dashboard and the beginning will start to design SS skeletons we have take a new sheet we can use circulated rectangle in this and you can yes you so increase its highest little bit six point five you to find him selects the colors will be back now shape outline you know online forgive me shadow you know who is this type of friend increase the distance over five control-d take other section here you you hey Willie and weak alignment yes this is the facings second take ultimately in what one here over they did you you evil night we'll use background select or let background brilliant film as reheated linear rather stop this rig then pink anniversary on a pink and here is orange you you you and - boy ii will reserve each section of HD data which we refer you can put another one of the first stations you you ship out long what line is it's gonna so that feel you nice color within control you change you you you is the head of each items will be used undyne here you you control gene and control D duplication to makes it [Music] [Applause] [Music] okay no it's our dashboard ready to accept all data first will group this control G for dropping also here control G and here for robbing control G okay coming to the insertion of the items insert text items for our dashboard insert text here and say date we'll use formed Oswald SWAT phone and port and white fella the same Neal we'll repeat this step for all corner just to speed up the video that we finish [Music] [Applause] [Music] here we we did all heading just forget this Tata will concern the iPhones icons I already pasted here to take all these iPhones I can select it from insertion here from part one icons or we can insert it from any any previous and Internet or LAN subsidized just gives it number graphics graphics folder can make a shadow okay you we put it to ten hours here detail unsafe attacks limitations we have positive we have negative so servation safety reservations training try to make your icon indicated your IQ and severity you sorry Rosie and injured first some injuries the total non-us you and total of three I think we could only take care of safety monthly - or is your title and you can crease it cover this you which chef Sandra and okay let's insert the data here as you see here this is the skeleton or the main skeletons of our dashboard just only we insert the data which were really dented with Excel and will be updated first we have to work with an alien protection sheet what is the steps here this our chart just only what take it as a copy ctrl C and we paste it in each place here sedate as well trophy the our day just change the color shows the size poor gospel okay under line to line can increase it more to be 16 or the teen we can change color to be the orange mainly 3 watch this verse I once our date or daily update coming this date will be changed automatically to the excel sheet you need just only making refresh short design refresh your data your data will be changes as we see later total manpower we select the also the charge of the first or technologies mob our ctrl-c ctrl-v what in here No or oddworld increase the site would be sixteen or eighteen up to if it's a wall and this total manpower should be update as we see here and excel sheet this Mars 730 for example company be 150 now lumbar 780 we go to our port number 708 change it to matter okay second step will take man-hours chart over here control in here modified scullers fight sighs so me quite colors so like access and company can move this up you can remove it you can live this up you I prefer to leave it to be indicate here will come here to travel or changes the shape of the poems previous interview before we making this I learned you as a video for simple coding designs would take the same here to have a good break this one with a copy of this control C and then when I come back to for example this columns just I make no filling fail to turn a time and as you see this and so second one will air patrol scene fitting picture to see Phil picture or text film clip or just I come to this chart mix hitting you Syria primary access series overlap I can decrease the overlap okay with Austria crazy to you [Music] you X you you this for for a surcharge you have nice and fancy chart we can go to the next item so next board total members also the same and first I take G on powers and so on so that I make it quick video to avoid attack [Music] [Applause] [Music] [Music] [Applause] so finally now we go to the last two things for just to take it a little if okay this chart we have to resize this chart since it's Connor it's the whites and we had at for my data series you sorry entity labels here it was missed next time first time okay and then we can modify its gonna make it gradient line up to change the line color here are finished over team can take it the first one second one red one orange here we wash my clothes okay this fourth Alice time injuries and loss chart our severity will be conserved heroes absolutely all most of the all charge on our dashboard ready this is you can as I mentioned in the beginning you can make it - port as in I can increase this time of slides for dashboard to be fit with you required that he change color feels like a color in color and dictation team this is you so so this is the last thing our our dashboard as you see here this our dashboard now we've seen how to update this dashboard sorry here if you like you have died in here nothing no lights let's show you how this dashboard can be updated or change it for last thing this last things excel sheet we can [Music] can't make a comparison you null point and Excel as we see here is a left side was this dead size in our back-end data and excel sheet also on right side and left side our dashboard if we changed any data here for them company to be for example 300 fine totally change it and here the data would be change it Company C for example 500 so data be sent 100 mm here data will be changed to time can we our data would be changed as data an excel sheet modified or updated this manual or we can say manual update or manually changing positive 300 they say air charter chart already changed to 300 and also routinely first important sync when you close the excel sheet Zini reopen again the dashboard will need not be updated automatically this is the third section which will be explained later in another video we make it up but at this time you have to go to your data and chart design and making a refresh for each join the data will be changing daily I hope we this was our our lessons today or healing today about monthly dashboard it was about each AC for technical people who are concerned about safety you can also make any dashboard like this for your bus ness for your training for your schools whatever anyway this dashboard will be inserted in a website soft grab the link download link could be found a clue safely and the for any comments or any duration related to this dashboard or any clarification please don't hesitate to write a column last things as you know your likes or comments is very important to us support us same time to improve our free learning for each one to ensure every sink or data reach to everyone who want to do something like this please don't forget to make like or subscribe to our channel to follow up and have fun thank you for watching and thank you all for listening and see you later next week bye