Transcript for:
Power BI and Analytics Training

okay so i hope i hope the recording is starting to get got started so wonderful i have uh quite a good internet speed the ping rate is quite low that's absolutely fine but uh if you feel uh if there is any disconnection uh kindly let me know so that i can actually help you on the same okay so hi hello everyone my name is i am owner of analytical firm here based off karnataka and i am also a corporate trainer for various companies uh i have trained um you know deloitte india access bank i have uh trained a company called as poly okay and various companies with 360 degree gm and my relationship with 360 digit mg is nearly something like um nearly a year okay so i specialize in power bi and analytical dashboarding and here what we will be doing is we will be trying to understand analytics from bottom okay so how a dashboard is going to be built how the dashboard is going to be published and what are the various things that we have to take care of it okay and this is a session which is for beginners to advance which basically means if you don't have any prior knowledge on power bi if that's absolutely fine we will be starting everything from the scratch okay so this is about the program and adding to that the program consists of something like 30 hours of training and it contains everything related to introduction to power bi installation connecting to the sql i mean connecting to the database um adding to that data preparation using power bi using advanced dax uh to calculate uh things in power bi and doing wonderful visualizations last but not least publishing dashboarding row level securities and gateway refresh so these are the major topics that will be covered in this topic and this is something which is normally essential for any power bi developer that he needs he need to do in his day-to-day activities hope you are clear on this particular part guys do you have any questions on this do you have any questions on this do you have any questions on this no no no no wonderful so you can be on mute because uh if everyone start uh you know coming on discord it can be really difficult for me to recognize so that's the reason i request everyone to use chat rather than discord if there is any questions or concern okay you can come on discord and you we can actually discuss it in detail okay good good guys i got only one round two response how what are these guys how good is this yes okay wonderful wonderful so so so first this is going to be more of theoretical session but this session is going to be a foundation for you the reason why i'm calling it as a foundation is because this session will help you to understand which specific power bi license to be used what is the architecture behind power bi so what are the various types of dashboards uh that are available in power bi adding to that what is the life cycle of a dashboard okay how a dashboard has been built what is the process behind it adding to that why we are speaking about power bi so there are various business intelligence tool and out of which we are speak we are speaking about power bi and we are giving more emphasis on power bi today in this session we will be understanding all of them okay so i will just go through the agenda for this particular session okay i hope you are able to see my screen if you are not able to see my screen just being on uh chat i will be there to help you out today in this session uh just give a minute annotate oh i know it hasn't disappeared okay that's fine so today in the session what we'll be doing is we will be understanding what is meant by business intelligence i don't know what is your background you might be coming from programming background development background you might be coming from testing background you might be a fresher as well we don't know but this course has been designed for people who are coming from various other domains so here in this session we will be understanding what is meant by business intelligence what is meant by power bi what is meant by that bi terminology and we will be understanding the core concepts of bi okay what is meant by uh strategic dashboards what are meant by operational dashboards what are my technical dashboards and all these things and i will also provide you the basic introduction to power bi like what is power bi okay and uh what are the various different components of power bi so we will be understanding them in a very detailed aspect okay so adding to that uh in our next session we will be connecting the power bi with various various different data source we will be creating uh pity dashboards okay and along with that we'll be also understanding how the dashboards are going to be working okay so these are the things that we will be doing in this session okay adding to that uh i also want to ask you how many of you have power bi in your system just say yes or no on the chat i'll be waiting for your reply guys i will be waiting for your reply no no yes no sanjay don't have sanjay goyal don't have power bi uh nitin don't have power bi okay and rahul sharma don't have ashwini sharma don't have okay and uh how about others okay how about others that's wonderful guys that's wonderful thank you for letting me know so now what we will do is we will also install power bi in our system okay people who have power bi i will teach you how to upgrade your power bi to a lower version to a higher version that's also we are going to learn isn't it very easy okay so these are the topics that we are going to cover in the session okay so now let me let me go ahead and start ahead with the presentation so so now before i start explaining uh you know what is meant by power bi or anything okay we we badly need to understand okay we badly need to understand uh what is meant by what is meant by bi basically the business intelligence or why business intelligence is basically been used business intelligence okay is very very simple okay like um it's it's like a dashboard okay like uh which is available in your car when you drive your car okay there is a dashboard in front of your car which provides specific information like what is the speed of the car which gear you are driving okay what is at your back what is at your friend okay and adding to that uh it also provide you uh various information like what is the engine condition okay whether uh you know abs has been applied or not okay or some other information which are very much essential to drive your car similarly to run an organization to run an organization we require specific information like what is my sales okay why my sales is going down who is the best salesperson okay or else it might be um campaign management like which is that specific campaign which is making more revenue or generating more leads okay what is my cost per click what is my what is my client acquisition ratio so management like to see or like to understand okay i gave you two exams two examples but interestingly there are much more examples which are out in the market okay so for that particular thing for that particular thing there is a whole vicious cycle okay so the cycle is first of all okay before you build any kind of dashboard i repeat again before you build any kind of dashboard okay you need to have a question you need to have the question which basically mean like you want to understand what you want to identify in the dashboard okay what is the business problem few of the business problem i can quote is uh businesses having um you know something like one lakh rupees and they don't know where to invest and how to invest a dashboard can help okay there is something called as marketing mix dashboard marketing mixed modeling dashboard which can actually help you to invest okay that one lakh rupee money into various different campaigns okay or else or else it might be a manpower forecasting dashboard which can help you understand how many persons you need in the next so-and-so days okay how many person you have to hire for so-and-so days do you have the capacity to manage those people in your office do you have that workspace in your office so these are some things which can be really essential or else it might be talent management dashboard okay like what type of talent i have okay there might be a person who might be really good with dashboarding but unfortunately his skill hasn't been explored okay so you can basically see hey we have various different projects but uh we have one candidate who is in power bi who is a really good power bi expert but his talent has not been used or utilized so these kind of information or insights can be received from the dashboard for that particular thing you need to have some questions you need to have a problem okay do you agree with me guys or do you have any questions or concerns here only two response only two response only two response yes wonderful so i am a guy who want my team to be interactive we have only 11 people and okay we can actually utilize this uh time and money in a very uh beautiful manner because uh if you start discussing things okay we can understand software in a very deeper manner okay we can we can lay a really good base for you so that's the reason we are asking you to be really interactive okay hope you're clear on this particular matter okay that's wonderful guys that's wonderful so what i was actually saying is the first thing is you need to have a business problem or else you need to have certain questions in your mind like why am i getting so many people from facebook okay why my leads are getting so many people from maybe okay uh facebook targeting may have a really good uh this thing what i can say turnover ratio okay or as you may have put a larger amount of money for the advertisement rather than go for google you have paid only something like 10 000 10 000 rupees but for facebook you have allocated something like 90 000 rupees obviously obviously you tend to get more right so what is that specific factor so that can be understood with the help of a dashboard okay so first first if i have a question okay and i want to answer it i badly need to have a data i badly need to have a data the second most important thing the second most important thing is to get relevant data to get the data which is actually important like for example today it is going to rain or no it's not going to rain so if i want to understand whether it is going to rain or whether it is not going to rain i need to have information related to what is the temperature what is the humidity whether the um you know area is cloudy or not whether we have large amount of what is the wind okay um all these are very crucial aspects okay similarly similarly when we speak about a business okay so if you want to understand uh why my sales are going up you need to have sales data isn't it something like that so the second most important concept is data and unfortunately unfortunately ninety percent of the data what you tend to get even uh from an organization they may not be um you know prepared well most of the startups these days uh do not collect data in a very structured manner okay most of the bigger organization do tend to get uh data in a very structured manner they have sql servers they have what i can say um you know you know azure warehouse okay big data hive software data has been stored in a very structured manner okay you can get information you can get information from how old is the data or else okay you know you can also get information on fact and dimensions as well so all these things can be used but fortunately or unfortunately sometimes okay data might be coming from different source as well like data might be coming from google adwords google data might be coming from sql server data might be coming from an api okay so there might be different type of data source which you have to get after getting the data and there might be tiny amount of data preparation or it's a large amount of data preparation okay so the third step which is also important is the data preparation you have to prepare the data and last but not the least you are going to prepare that report and then you are going to solve the business problem so this is the whole cycle first there is a question okay from there you are going to get the data you are just going to clean the data prepare the data then you are going to create the dashboard or reports that is essential for uh the organization then you are going to provide it to the managers or supervisor or even a sales you know representative it might be anything okay so you can actually provide that so this is the whole cycle of business intelligence life cycle hope you are clear on this particular part do you have any questions here do you have any questions here [Music] how about others about others how about others okay how about rajesh how about akash it's a just basic cycle before going further steps ashwini um what really happens here this is not a basic step okay this is the whole life cycle itself so this is the path this is the path how you are going to build the dashboard tomorrow and uh your manager is going to come and he's going to say hey i want um you know customer churn analysis dashboard so in that case this is the whole life cycle that you are going to take so if you are doing any mistake for example okay let's assume if you are not doing the data if you are not asking the right question to the manager okay so what really happens is okay data getting the data will get affected preparing the data will get affected okay and uh interpretation of the data will get affected adding to that okay you are not able to answer the question which has been asked by your manager do you agree with me this is the whole life cycle do you agree auto calculated from online system or data is auto calculated from online system akash okay just a moment um is the data needs preparation okay or um akash that's a really good question okay so in msbi we have something called as analysis services ssas it's also called as so which actually have a capability to um you know what i can say run some analytical uh this thing as well but uh even in power pi you can do data preparation you can do data cleaning okay so this can actually happen in two ways you can clean the data in the sql server or the source itself or as you can clean the data here as well both can be possible hope you are clear with this akash okay that's great that's wonderful yes that's wonderful okay so now i know everyone are clear on data preparation part so what i will do is let me go to the next part okay so okay let me see i have another question okay how can software assure data collection of business questions um so software can actually so for example let's say i think someone is not on mute amit amit kumar kulkarni thank you amit okay so i will give you a small understanding here okay for example you want to understand what is your sales amount okay so in that case what i will do is let me go to one of my dashboard that i have created for a u.s based company [Music] this is the one so this is a khans khan's khan's cons let let me go here re-added yes update 2 so this is a uh dashboard related to um performance of uh sales people in a game okay so there is one game like ipl or something like that um and uh when the game is actually happening there are various people like you know uh in in us so there are people who tend to sell snacks they are also people who tend to sell uh beer as well so these kind of i mean there are various levels of uh listing information so what really happens is now the business was actually having various questions like they were actually asking okay who are those people who i need to keep in my organization and who are the people whom i want to fire okay because keeping uh sales people okay it's quite an expensive thing for an organization and they want to understand which is the top salesman who which say salesman is not performing well so what we have done is we have we have created them a line so this is the name of the person this is the name of the person and if you see that in a very deeper manner okay you are able to identify which specific salesman is below the sales average and which specific salesman is above average can you see that so what is the average sales and what is the total sales what i have done for this specific game there is an event there is an event which is happening okay and there are various steps of events out of which we have selected only one event and we are trying to understand okay we are also trying to understand okay information like how many refunds he is getting okay how many uh open sales he had made what is the average sales he had made okay what is the sales uh you know what is the net sales he had made all these things all these things are available here and what is his role okay what type of role it is okay whether it is uh um you know lead bartender or beer polar okay what what specific role he's serving okay these type of information can be understood using a dashboard hope you are clear on this particular part of sweeney okay wonderful ashwini thank you very much okay so now so now what i'm going to do is let me hop on to the dashboard hope you're able to see my screen guys okay so okay so when we speak about power bi you basically need to ask me a question why are you teaching me power bi why are you why why are you not teaching any other bi services okay there are numerous types of bi services in market so you have something called as mode you have something called as looker you have something called as tableau okay you have something called as quick view okay chart i o you have python and r as well in python you have something called as dash python dash which is actually used for building dashboards in r we have something called as shiny r where we can also build dashboard is and along with that you have sql server power bi so this is something what we are learning but what we are actually saying is there are numerous amount of bi softwares which are actually available in market okay and out of which we are only concentrating on power bi because power bi is the market leader power bi is the market leader so this is bit old this is this is bit old this is the research which was been conducted in the year 2019 by one of the most prominent gardener so if you want to read about the organization if you want to know what the company is actually doing you will be able to understand it in a very deeper aspect so what they have done is they tried to analyze okay which is the technology which is actually uh good or bad or something like that so they were able to create something called as bcg metrics i don't know whether you know about bcg okay so this is something called as bcg matrix so here okay you are going to be basically understanding the niche players challengers leaders market leaders visionaries you try to understand these people okay and you try to classify those people and in that microsoft power bi is the leading software in bi industry okay secondly there are also comes a couple couple of uh you know what i can say software's like tableau quick okay and hotspot and i adding to that uh adding to that there are also some of the uh tools like salesforce sas sap okay uh which can actually be a market market leader in that case it's it's actually in something called as bcg you can you can read about this bcg matrix that's if you have done mba you'll be able to understand this bcg matrix really clean and clear okay so this is the information which is actually available so which basically speak about that microsoft is the best bi tool we will be understanding why i'm calling this as the best bi tool in a very detailed aspect when i discuss about the architecture and the products which are along with microsoft power ba hope you are clear on this particular part i think i have one question let me see what is it i have a question from yes uh bcg boston consultancy group okay so it's a company it's it's still a company you can actually google it out okay so they have uh one patented um approach to classify that you can you can google it out you will be able to understand it it's a thought it's it's a process how you analyze and visualize um the sector or a market okay so how can this assure okay i think that has been answered okay that's wonderful do you have any questions guys do you have any questions on this this metrics will help us to make dashboard no this won't help us to make dashboard that this help you to understand which is the best software to build the dashboard hope you are clear on this particular path okay okay thank you ashwini how about others guys how about this do you have any questions do you have any questions i got only one questions from sanjay goyal rather say no how about others how about others i don't want to call everyone's name vijay thank you very much okay how about rahul how about nitin how about uh akash raghavendra rajesh okay that's wonderful that's wonderful so till now we have understood okay various things related to the dashboard okay but now what we will do is what we will do is we will try to understand okay what are the various types of dashboards that we can actually build okay let me discuss this later but let me discuss why i am actually saying power bi is one of the best tool out in market okay so this is something called as um you know progress of analytics or it is also called as hierarchy of analytics as well okay so if you ask what are the various hierarchies of analytics so you will be able to see this particular chart i don't know how many of you people have come across this particular visualization but this visualization speak about the levels which is actually involved in data analysis and data analytics okay and here okay the first thing which is actually going to uh be analyzed is called as descriptive analytics what is meant by descriptive analytics so people who are coming from a statistical background they will be able to understand hey descriptive analytics means mean median mode yes it's it's very very simple uh descriptive analysis means the information which specify the um column like age so let's assume you have a column called as age so what is the minimum age what is the maximum age what is the average age what is the median what is the mode so all these things comes under something called as descriptive analysis okay and uh the descriptive analysis is a part of power bi and uh in power bi we have something called as a column profiling okay wherein you will be able to understand all these questions like mean medium more central tendency minimum maximum range all these things in power bi and power bi is able to handle this specific information okay hope you're in i hope you're clear on this particular part that is called as descriptive analytics if you have any questions of concern come on discord and let me know and if you feel that uh you know i'm a bit fast kindly let me know so that i can actually slow down because i want the session to be very dynamic i want the session to be very interactive okay i want the session to be very robust okay so if you feel that i want to be slow i can also be slow based on your request am i fast or slow or am i okay just let me on the chat i am waiting for your reply you are okay nathan is saying wonderful nathan how about others rather saying okay how about others vijay is saying okay normal okay thank you someone who say fast someone who say fast raul sharma is saying okay going well wonderful thanks thanks thanks for that going well how about others how about others okay that's wonderful i got many response let me continue so descriptive analysis is all about the describing the data and i want to ask you do you have any questions related to descriptive analysis any questions related to descriptive analysis yes or no if you have any questions come on discord i assume there are no questions okay so just let me proceed ahead so after understanding the descriptive analysis the second most important thing is called as diagnostic analysis what is diagnostic analysis diagnostic analysis is all about understanding what is that factor which is actually influencing like like like so for example if you go to hospital if you see that the person is going to have cancer okay let's let's assume xyz person is having some cancer let's assume it's blood cancer or tumor or something like that so there is a diagnosis process which will actually happen what they will do they will go they will understand certain things like they will say okay there is a tumor then there might be a tumor i mean you know tumor cancer or in blood if there is one specific uh variant or if the if there is one specific levels of what i can say component which is very high then we are going to say oh he is having blood cancer something like that okay so a factor will be influencing another factor okay so we will be understanding what is that specific factor like in a simple way in a business analytics so what we tend to do is um for example um uh you know we are having a sales from a very specific region is very very high like um ice creams are sold really high in rajasthan okay and we don't know why okay in diagnostic analysis we will try to understand okay we have a region called rajasthan in that region we are having high sales we will try to chunk it down which specific district in rajasthan whether it is jaisalmer whether it is you know udaipur whether it is jaipur whether it's the pushkar which specific area if we are able to find all the areas are having equal this thing then we will try to understand what is the temperature in rajasthan then we will get okay the temperature out in rajasthan is something like 40 to 50 degree celsius so that's an oh summer is going to summaries that particular particular factor which is actually influencing the sales of the ice cream then you will try to target which are those other places where uh there is high amount of temperature you will be able to find there are some place in gujarat there are some place in maharashtra there are some places in karnataka there are some place in andhra pradesh which have a higher level of temperature in summer so then you start try to modify your business strategy in such a way that you will be able to cater um your ice cream or try to cater your ice cream for these locations as well hope you are able to get it how diagnostic analysis can actually help your business say yes or no i have three questions okay i think three comments let me see okay um i have nithin is saying i need to ask i have question on descriptive analysis yes nitin yes nathan you can come on discord i'm extremely sorry anything okay uh there is a echo is it better now yes it is better now what i was saying understand it clean and clear okay if someone is there uh you know who can help me out with the this thing that would be wonderful guys is it clear now is it better yes yes it is it is it is better but let's have you had a little bit of echo that's absolutely fine yes is that when we look into it the progression of analytics it talks about some descriptive analytics about being past matter only but generally in our case it's not like that also sometimes we are forecasting the things or sometimes we are trying to visualize the future also so descriptive analytics will include that part also as i understand is that what happened means that what basically we want it could be two things i can say that okay suppose i am saying just giving you an example from our context that one of the geography sales is happening very high now i am going to investigate why it is happening but i can also do that analytics for saying that i want to increase my sales in these geographies and that can also be the part of my descriptive analytics is my understanding correct on that count descriptive analytic means this is something what i want to analyze um descriptive analysis means okay you are going to describe so here descriptive analysis means okay so let's assume your sales are going up okay what is the amount that your sales can go up okay so there will be a range right so uh let's assume your production capabilities uh for something like one lakh rupees and uh you are keeping something like 20 lakh margin and the total amount of sales that you can make the highest is one like 20 you cannot make something like five lakhs okay isn't it until and unless there is a huge demand okay so descriptive analysis can actually help you to understand what is the maximum sales i can make what is the minimum sales i can make okay what is my bep so these are some of the questions that can be understood with descriptive analysis diagnostic analysis means which specific factor which is actually influencing like if you have sales what is that thing which is actually affecting the sales is it the discount if you are giving high amount of discount people are buying is it that particular thing no okay is it that geography there is one specific geography where your sales are high there are other geographies whereas your where your sales are low something like this is it that particular thing or else uh you know it might be something like anomalies something like that so you will be able to identify or understand it in diagnostic analysis and adding to that you also spoke about something called as forecasting forecasting normally comes under something known as predictive analytics it is completely different from descriptive analysis and diagnostic analysis yes there is a linkage between descriptive analysis diagnostic analysis and predictive analysis which basically mean if your descriptive analysis is going to be bad then your diagnostic analysis will be also bad if your diagnostic analysis is bad then obviously your predictive analysis is also going to be bad so there is a link or there is a hierarchy okay or there is a time link between these things okay hope you are clear on this particular partner let me rephrase my query like i am saying taking the same example suppose i say that okay my sales in the northern geographies are low and my first thing which i want to understand is that if i have to grow my sales in the north whether it can be part of my descriptive analysis or not or i have to go back to the first data point itself that what notably drive in the sales and from that if i have to increase my sales then what all needs to be done via diagnostic analytics is this that always descriptive analysis will have only one specific column okay you spoke that sales in north or south okay sales in north or south sales is one column north and south is our second column you cannot have two columns in descriptive analysis there will be only one column in descriptive analysis okay clear now okay hope you are clear on this particular part sir so if it is going to be two columns like sales as well as north then it is diagnostic analysis okay so uh ashwini sharma is saying factors which affect our objective means like yes you are absolutely right uh which is that particular factor which is affecting our business in in statistical terminology it is also called as same significant factor and insignificant factor hope you know about that okay yes you are absolutely partially right okay uh okay wonderful so any other questions guys any other questions i assume so no let me continue okay so we understood descriptive analysis diagnostic analysis and after these two uh you know analysis there is the higher level of analysis which is actually called as predictive analysis what will actually happen tomorrow what will actually happen tomorrow okay like um sales okay sales today 2022 is something like 1 lakh 20 and what will be my sales in uh in the month of uh um what i can say december or in the month of november so that specific thing forecasting comes under predictive analysis there is a huge difference between forecasting and prediction but normally it has been um you know clubbed along with predictive analytics itself forecasting do come under predictive analytics so here um what i was actually saying is to predict anything okay you will be using this specific thing called as predictive analytics what will actually happen tomorrow okay so this uh thing can be um used in various industries like supply chain industry like uh um you know uh inventory management because they want to do uh eoq techniques and all so in that in that case they also try to understand i have a capacity where i can actually store something like 100 box of goods but my sales are going up and down so do i need to buy a different warehouse where i can store another 1000 box or something like that all these decisions can be made using predictive analytics okay so i assume that you are clear on this predictive analytics part yes or no yes or no i got only two response i got only to response funjay and ashwini sharma how about others you say yes nathan is it i mean pronouncing your name correctly or is it something else kimandas yes yes kevin does okay wonderful thank you okay akash thank you very much guys thank you very much so last but not the least we have something called as prescriptive analysis like i gave you one of the example like there is uh did you have using diagnostic analysis you have done one of the uh this thing what i can say uh conclusion that whenever there is a high amount of temperature then the sales of the ice cream is also going to go up you understood it and along with that you have also identified some mapping like in there are some places like vidar and all these regions in maharashtra and you have ahmedabad and all these regions where um temperature is going to go high and along with that you also have chambal breeder be that where also temperature is going to go high you have some places uh in andhra pradesh like uh you have place like what i can say karnal guntur okay where temperature is going to go high similarly in karnataka you have certain places like um raichur uh balari and all these places where temperature are going to be very high you identify these places then what you do is you you channelize your supply chain you will ask your supply chain hey i want to target these specific locations okay and dispatch so and so so and so goes to these locations as well so this dispatching this suggestion recommendation is going to be provided by using something called as prescriptive analysis prescriptive analysis specifically what is prescriptive you go to a doctor you will say hey i have so and so problem i have so i have a so-and-so problem with my this thing i have fever i have cold i have red eyes something like that using or understanding if he will do the diagnosis and after doing the diagnosis he will prescribe some drugs like paracetamol or it might be painkillers or these kind of things isn't it so this prescription can be provided for a business problem so these are the specific hierarchy which are going to be involved in involving regular business so power bi is one specific technology which can actually handle something called as descriptive analysis wherein you have something called as a column profiling wherein you can understand or do uh descriptive analysis you also have couple of um visualizations like a bar box plot visualization histogram visualization in power bi varying you can actually use box plot histogram and plot the this thing what i can say variables as well you can do this specific thing descriptive analysis diagnostic analysis you can do univariate analysis multivariate analysis you can uh you can bring three uh different uh what i can say uh what i can say variables and try to understand like um complicated stack bar chart um or hierarchical stack marks or clustered charts using these things you can analyze multiple multiple uh this thing what i can say columns in that particular thing just give me a minute i think i have one question can you explain basic difference between predictive and prescriptive basic difference between predictive and perspective so what will actually happen in predictive analysis you are going to predict okay so what is my sales tomorrow but prescriptive analysis will actually suggest you okay you are having high amount of sales okay then you don't have uh your uh warehouse at that specific level so you have to increase your warehouse you have to buy different uh warehouse wherever and you can actually accommodate the extra uh this thing what i can say uh amount of box that you are producing or else uh you have to procure the raw materials the raw materials price is going to go up or something like that okay if there is raw materials pricing height then you are also going to say that hey there is a raw material pricing height though so for that particular thing you also need to increase your mrp as well so these types of suggestions can be provided by prescriptive prescriptive analytics predictive analytics is going to say okay tomorrow your sales is 1 lakh 50 000 that's it it won't do anything but prescriptive prescription analysis is going to fine tune it is going to help you to provide with specific information hope you are able to get it hello my voice is clean yes your voice is clear sir uh as you said uh predictive analysis means we predict the what's the volume of how much volume we can sell in tomorrow okay yes but according to the predictive how we can prescript uh prescribe uh how can we prescribe uh this is the only good we can sell but there is some uh kind of constant about the space at our spare house my means to say prescriptive analysis must be before predictive then relative analysis must be at last at last you're absolutely right you're absolutely right so before formulating this thing for example what we tend to do is we create some alerts okay so um so there will be analysis which will be done and i want to say if my sales is going to go up more than 500 units then there need to be email that need to be sent to me okay which need to say hey your your sales has gone up by 500 units so that's the reason you have to plan your supply chain efficiently so these are the steps that you have to take so something like this can be embedded in power bi so so that the dashboard will be fine it will be running as it is okay and one specific trigger like if the sales go down below something like 100 units then there need to be an email that need to be sent hey um your sales is going down so that's the reason uh you have to take some crucial action wherein you have to fire so and so people from your uh this thing what i can say region or team or this particular thing because you are not meeting the bp or break-even point for the organization so something like this okay so these alerts can be actually sent uh so these alerts are nothing but prescriptive analytics alerts okay which are coded prior itself okay before the event for example if the event has reached 500 you have coded something like six months seven months eight months nine months back itself that if it is going to happen then this is going to be your logic okay this is this is your plan that need to happen so this is going to be prior okay as you have told you are absolutely right this these actions need to be taken prior before predictive analytics okay so that's the reason predictor analytics and prescription analytics need to happen hand in hand if sometimes diagnostic analysis and predictive prescriptive analytics will happen like you are going to diagnose and there is no predictive part directly prescriptive part but something like this even those kind of scenarios will also appear there is no mandatory rule that predictive analytics need to be there to do prescriptive analytics something like that hope you are clear on this particular part yes or no clean clear ashwini has another question but you can come on discord me you can discuss this my question uh another question is like without prescription how we can predict so means prescriptive analysis must be before the predictive analysis yes you are predictive analytics before without prescription how we can predict any analysis and any uh constant any concern any issues um so so these are some of the some of the things that need to be coded prior itself like so let's assume you are doing forecasting okay and uh you in that forecasting you want to see that if my tomorrow's forecast is more over 1000 units or something like that then i have to plan my different supply chain i have to hire another bus i have to have a higher ends other than see so there is in all the companies there is something called as budgeting unit okay so those are financial experts who do budgeting okay for selling 1 000 unit of goods in my in my company the cost involved is so and so and the budgeting unit or the budgeting people they their job is to cut down the cost in such a way that the logistic cost is low the inventory cost is low the uh supply chain cost is low the sales cost is low okay which is also called a cog assessment so all this cost needs to come down okay and they need to be high amount of margin which need to be left for the organization and these types of information like if the tomorrow the sales is going to go up so in that case these budgeting people will come into the picture i don't know you have worked in a financial department or not but there is a team called as budgeting department who tend to do all these tasks and the budgeting department will say hey if the tomorrow if you are planning to do 12 000 unit sales then these are the steps or these are the um cost that are going to involve sometimes the cost might be high sometimes the cost might be low so they also do budgeting on logistics as well like if i'm going to go for a tata is how much cost is going to occur if i'm going to hire a 407 what is the cost i'm going to incur if i'm going to hire a uh you know mini truck what is going to be the cost and if i'm going to say a large truck how much is going to cost so all these things all these things need to be done prior itself so budgeting team is one such team which will do that particular task and i don't think um you know um you know there is lots of you know no speaking that need to be done from an operational department okay so in your team the budgeting will team will come into the picture they will say hey these are the things that you have to do uh for so and so so and so so things okay and uh this is it before before itself the budgeting team will provide okay so hey if you are planning to go up for sale so and so so then this is the cost that are going to involve and these are the steps that you have to take and budgeting team will provide that particular thing and you have to incorporate it into your dashboards like if the budgeting team is going to say hey um you know if you are planning to go for 1200 units then you have to buy another tata ace something like that okay so you are buying tata s that is a cost which is actually involved right so what companies tend to do is if there is a forecast like if there is say saying that 1200 uh you know units will be sold they will say okay 1200 units okay that will they will say okay then if the actual is also 1200 units and if it is going to hit something like three to four months okay then they will try to upscale then they will take loan they will take some uh you know what i can say uh they will hire some people and they will they will facilitate the demand so this is how all the organization in entire world not only in the entire world will actually happen and this is the standard concept in supply chain hope you are clear on this particular part ashwini i think i have answered your question yes vijay i think you have another question right just continue with the same example in the same case my understanding is that our prescriptive analytics will be bounded by whatever data we are the databases there is descriptive analytics part only just continue with your example suppose i want to make my sales from 1000 units to 1200 units now that's when i can say that i can go there i may say that i have the enough warehouses also there i have my sales team to do that i have advertising budget also for that i have considered all those things but all those things would come into the picture only if my basic data is having those kind of details that 4000 units how much budget has to be there if i want to do 1200 units then what should be the budget and if i am saying even all these are covered i may be missing out that i don't have that kind of working capital with me because that is not part of basic data so my only thing was that we can go and provide a prescriptive analytics i can go and say that yes boss you can do it from 300 to 1200 because we have these kind of things with us because my database is kept but it might be possible even constraining factor i'm missing out i am not concerned that for that time this much cash would be required which is not there in my data then it will not get highlighted in my prescriptive analytics as well yes you are partially right okay yes i i also need to admit with your answer okay um yes that is something which happens in regular business and we need to be bound with that fine okay so these are the things and uh interestingly power bi is able to handle all of them okay like uh you know you can do diagnostic analysis as i have prepped by previously told like you can plot paragraph cluster bar graph pie charts and all these things you can you can incorporate something called slicers you can do diagnostic analysis predictive analytics yes a power bi is capable to handle machine learning algorithms as well it won't run in power bi but there will be spark which will run independently outside power bi and the data will be plugged into power bi something like this so you can get uh you know predictive data into power bi and do the visualization i was a part of a data science team way back uh between 2018 to 2019 uh wherein um we used to build analytical dashboards um you know on customer analytics so who is my customer how his buying pattern of customers are what is his profit he's actually making so all these things so we used to do something whereas customer segmentation business forecasting demand forecasting so for all these things we used to have predictive models okay they used to provide the data it used to be lying in the block storage so we used to fetch that bit data from blob and we used to visualize it in our you know what against a tablet okay so this is the hierarchy given you can also plug in the data into power bi and actually visualize it and adding to that if you also want if you think that a i have a script python script you can also incorporate python or our script into power bi and do local uh you know what i can say processing as well if you feel that your data is not very complicated or very big or something like that you can also incorporate these kind of things to predict uh you know specific events so power bi can also handle predictive analytics and prescriptive analytics as i have told you that you can uh create custom alerts custom go you also have these days you also have something called as goals as well you can you can do you can do custom emailing as well so all these things can be done in powerpi so that uh you know if there is some uncertainties or something like that in tomorrow case so you get a prior warning or something like that or you just get a warning email so these types of prescriptive analytics can be um incorporated in power bi so in simple way in simple way you can involve all the hierarchy of uh business analytics in power pl and interestingly interestingly so when you speak about descriptive analytics this can be very very easy very very easy but when we speak about uh prescriptive analytics and all these things this can be very very tough okay and the chance of going error is very very high in prescription analytics and the chance of going having the error in descriptive analytics is very very low so it is a small uh this thing but most of the organization are actually trying to aim optimization this specific information like they you know by just by the sales okay they want to know what is actually happening in the organization something like that hope you are able to clear on this i mean hope you are clear on this particular part any questions guys any questions it's clear sanjay say yes how about others rahul sharma ah rahul sharma which i that's absolutely fine guys okay thanks for your comment thanks for your comment so now you have understood what are the various types of levels and what are the various types of complications that are actually available in preparing the dashboard so now let me go to my another slide which is actually called as types of dashboard so if you are a power bi developer then what are the various types of dashboards that you may actually come up with or you may build so majorly you will be building something called as where is this you will be building something called strategic dashboard operational dashboard analytical dashboard or technical dashboard so these are the only four different types of dashboard that you will be creating in this uh this thing okay there is no pure line or a you know what i can say difference between um strategic dashboard and the analytical dashboard for example here in strategic dashboard i might be using kpi so even in analytical dashboard i might be using kpi as well so these things can actually change but but the but the purpose of these dashboards are different what i basically mean by that is if you are speaking about strategic dashboard this type of dashboards are normally used by um [Music] high level people like you know the manager the ceo the cxo so what they want to understand is they don't want to understand which region is making what type of profit they are more interested in what is my uh you know what i guess my profit what is my uh you know cost which is actually involved okay how much tax i have to pay okay how much uh you know violation has actually happened in my uh you know this thing how much discount we are providing they want to see a holistic picture of the organization rather than a very detailed aspect okay so they don't want too much of detailing so for those kind of things strategic dashboards are really essential so where they stand so most of the organization 90 of the organization do come up with something called as strategy goals like you know they they say that this is our vision this is our mission we want to achieve we want to open something like 200 stores in the next uh what i can say five years so they have provided verbal statement in board meeting okay now the manager need to accomplish accomplish that they have to have uh 200 or 500 whatever they have promised stores in india so so in that dashboard they will be having one of the aspect wherein there will be how many stores we have opened okay in the month of january how many stores we opened in the month of february how many stores we have opened okay what is the increase of storage how many what is the rate that i'm actually increasing my stores okay what is the cash availability how much profit i'm making from each stores okay these are some of the information that um you know a manager or a ceo like to see so for that for that okay there is a set of dashboards which are called as strategic dashboards which will actually help help an organization to achieve the long-term vision okay help help them to achieve the long-term vision and something what they have actually uh you know promised in the board meeting so all these things will be involved in strategic dashboard hope you are clear on this particular strategic dashboards clear and clear guys any questions any questions rather is clear how about others go will say now um this isn't noise but girl do you have any questions okay that's fine you mean no questions okay i got it okay that's absolutely fine okay so um operational dashboards okay so this is another set of dashboards which are normally used by mid-level managers like they want to understand they want to compare one aspect with another aspect like let's say assume there is a digital marketing manager okay he's in mid-level manager who want to understand which specific campaign is making what amount so there is campaign number one campaign number two campaign number three which campaign is uh making good revenue which specific ad is providing me more leads whether the ads from facebook are having height conversion ratios or was it what it is he will try to understand the patterns behind it okay what is happening why i'm getting too many leads from um uh campaign number one or something like that so all these things come under operational management and i'm just giving you a small brief understanding operation dashboard can be um you know what i can say digital marketing dashboard or else it can be something like financial operation dashboards like that what is my cash availability how much cash disposal i'm how much cash dispose i'm making okay what is the cash burn ratio they they create something like cash burn ratio how much amount of how much how what is the rate of amount i'm burning my cash something like this things come under something called as operational dashboard okay um operational dashboards can actually help you to give a complete overview on a specific segments like financial operational dashboard like digital marketing operational dashboard or else uh you know what i can say um production operation dashboard like how much production are making which lane because they when you actually go to a factory they might be having multiple lanes multiple conveyor belts which conveyability is fast which kind of variability is low how many products i am getting from which machine okay how much breakdown that machine is actually having which is the good machine which is the bad machine all these things can be understood compared okay using operational dashboard hope you are clear on this particular part do you have any questions do you have any questions any questions guys no ashrae sharma say no how about others how about amit kumar rajesh ravindra sanjay rahul sharma how about others guys why i'm getting very less response how about others i'm extremely sorry guys uh sorry to say this because we are in um what i can say um remote environment and in this environment what really happens is we cannot see you okay and unfortunately okay there might be some internet glitch or something like that okay so if you are clear on that particular thing we both can actually test okay which either there is a internet issue from mind or your end because i have a really good internet okay yet what is it can you can we show example why explaining types um yes we can do that i will i will show you okay i hope uh there are couple of dashboards which are actually available i will show you okay what happened example okay that's wonderful let me open google okay operational dashboard operational dashboard let me say finance sorry nice so there is one example of a financial dashboard okay so what are the information that are available here i'm extremely sure quick ratio current ratio okay what is the current ratio is what is the amount that i'm having in my hand okay cash balance how much cash balance i'm having okay what is daily sales outstanding okay what i have to provide to the organization inventory outstanding okay uh payables outstanding the amount that i have to pay okay something like this so this is a very small cash management dashboard okay this is only cash management dashboard operational dashboard operational revenue dashboard what is the revenue okay something like this can you see that similarly these are operational dashboard like operating dash mode for finance operational dashboard for supply chain okay supply chain okay so you are you can see that uh okay this is not a really good supply chain ah this can be good a good okay supply chain dashboard okay just give a minute later it is loading okay how many trucks i have okay and uh i'm sorry guys i mean the quality is bit poor but what they are saying is what is the truck what is the efficiency what is the distance they have covered all these things what is that our average number of our the truck is traveling and all this information supply chain or this thing what i can say hope you are able to get it and uh warehouse information warehouse dashboard okay what is my bep and all these things oh sorry eoq economic order quantity okay is what is my inventory term okay whether my inventory is low or high all this information can be seen here hope you are able to get it okay this these are operational dashboard strategic dashboard strategic of strategic spelling okay that's absolutely fine a strategic dashboard like um what what is the risk amount what is the project budget okay overdue task okay so this is i think this might be related to it sector i assume so because they have some deadline deadline as well project log project project uh so probably it might be related to some project execution so uh project summary start date end date when it will start when it will end all this information hope you are able to understand so or else uh or something like this okay what is your growth okay how what is your projected growth what is your current growth okay so normally all the companies like reliance they will say my next target is something like uh four lakh units or something like that so every quarter they will come and they will say okay this this month we have made so and so profit and we have plans to increase our sales sales to so and so okay amount so no company will say we have a plan to decrease our sales so no one will say but most of the companies will say that okay these these are our plans this is our this is our execution and all these things okay investors are also going to invest on these stocks based on this uh this even um you know you when you have an ipa and all these things they have something called the red herring perspectives and all so which we speak about what the company is going to do using your money okay like today we have lic uh ipo right so they have disclosed the red herring perspective they have told what are the plans that we are going to take in the next uh you know five years okay so all this has been well documented and they are going to follow okay so if they are not going to follow they are answerable so all the investors will hold hold their world not literally hold their caller but something very similar they will ask why you told so and so so but you failed so it is a bad impression for an organization so all these things all these dashboards are going to do that particular task so these are strategic dashboard i showed you operational dashboard now i will show you something called as technical dashboard oh analytical dashboard let me show analytical analytical dashboard i'll let my dashboard analytical dashboards like um you know you have something like in sales you have something called a sales funnel let's let's assume you have something like 100 leads out of those 100 leads uh you are selling your product to only five people so out of 100 leads only five clients got converted what happened with those 95 people where in which specific area they are getting stuck why they are getting stuck you know do they have a problem with uh you know budget rising product what is what is that particular thing that is actually holding a customer to buy our product that can be understood something by using something called as a sales funnel so sales funnel diagram actually looks something like this okay and adding to that uh okay we will show some nice one ah see here this is a sales revenue profit analysis okay so how sales and profit are going to correlate so here i think you might be also having cost as well cost of sales and all these things component which will be involved see you will be able to identify which specific location my sales is coming and all these things so there is quite a bit of analytical thing which is actually involved uh there are also organizations which also involve couple of machine learning algorithms as well like there will be buying backend there will be machine learning algorithm that will run and after running that the output will get uh featured in that and uh in in my organization we also had um various machine learning algorithms and we used to also see which specific algorithm is making what amount of profit like um you know let's assume your model is making something like 95 percent of accuracy then obviously when it go to 95 accuracy then you you might you might be thinking whether there is any uh overfitting issue which is actually happening so if there is no overfitting or something like that okay that is fine if the um if the model is making something like from 95 it is going to 85 then what is the threshold that need to for example if we also used to create a threshold like if the model accuracy is going to go below 80 then we have to do an overhaul on the model something like that so we used to create this threshold upper boundary lower boundary average boundary so we used to create a range if the model if the machine learning model is running it need to have an accuracy in between this particular this particular range if it is going to go up it used to be called as good if it is going to go down okay we used to raise our alarm okay we had an alert mechanism which we have kept whenever the uh sales amount used to go down they use they used to be an official email that used to be sent to the model uh manager so the data scientist used to okay oh this particular model has poorly performed then he used to talk to the chief data scientist and used to report him saying that sir this model has gone uh off balance we i think we have to do an overhaul then there used to be a process wherein they used to fine-tune the algorithm whether they used to experiment with different algorithms whether they used to continue the same algorithm something like this so we um we have also and people can also use uh these kind of analytical dashboard for that particular purpose as well hope you're clear on this particular analytical dashboard clean and clear clean and clear i have four questions let me see can you see production dashboard you can google it down okay production dashboard on google you will be able to get numerous production dashboard why are you typing here i'm just saying that okay let me do it for you my friend okay um production dashboard how much you are producing okay so i think i have pre-created something called as production dashboard let me see do i have it it's i created way back in 2019 you schedule optimization dashboard where is this schedule optimization [Music] no i don't have it no worries something like this production date okay what is the waste product that your plant is uh giving what is the expenses man power diesel recovered okay actual okay i mean basically the actual recoverable rejected products how much the product got rejected qcqa okay defective products okay damaged products others okay rejection ratios so along with that you also have something called as a total production okay active machines how many machines are active okay sales revenue and all these things in my next tutorial if possible i will also show you one schedule optimization dashboard so we have used schedule optimization that is an algorithm along with schedule optimization we have also used lanes like um you have let's assume you have four different production machines okay and they will have uh maintenance they will have uh overhaul they will have breakdown so we used to channelize okay this machine need to produce so and so equipments for so and so time and we need to run on so we used to plan that schedule optimize and we used to plan that production unit for these machines so even that dashboard was available and that dashboard can be used by people who are line managers okay so for that it was really helpful so similarly see here okay workflow production okay this is another listing how many work people they are actually having so these are these are some of the dashboards which are actually available for uh um what i can say production hope you are able to get it sorry clean and clear sanjay is having one question yes sanjay how can i help you uh yes yes question is actually like you said we are using four types of dashboards like strategy cooperation analytical impact okay tactical what i have seen like again you can say monitoring performance or analytics means day to day we can uh monitor the performance [Music] strategic dashboard or can say operational dashboard like the same data can be used for other dashboards also right yes yes you are absolutely right and i will i will raise your topic okay when i will be teaching you data flows i will be incorporating this because this is one of the strategy what we tend to use okay and this is this you have raised one of the most uh interesting thing because see um we tend to keep data refresh okay so uh uh sanjay i just want to add little bit extra on this okay so let's assume you are having 100 dashboards and using one single data source let's assume let's assume what really happens is if you try to refresh all the dashboard with different different query what will actually happen is the load on the server will actually get increased the server there is a high chance that the server will fail so in power bi what we also have is we can actually create something called as master data set and using that master data set we can create hundred different dashboards okay so this integration collaborations can be done okay and uh yes you are 100 right like for example um if i am into hr industry okay so some of the financial information will be coming from financial data some of the information like talent and all these things will be coming from project manager the project manager will say hey i want a guy who is having skills in python who is having skills in what i can say java and these kind of things similarly hr they they only know how much amount how much salary i'm paying what is the ctc um you know what is the performance review which we have done previously okay whether this candidate is meeting the expectations laid by the organization so all this information can be an internal which is generated inside the hr department itself but they have to get some information from financial department they have to get some information from uh project department okay so all these things integration and all these things okay will normally tend to happen here these types of combinations tend to happen here and there and yes you're absolutely right um um we in in whenever we build dashboards we normally tend to have these kind of things i agree with your point sanjay okay that's wonderful uh camantas do you want another dashboard so last but not the least we have something called as a technical dashboards so these type of dashboards are normally used for monitoring performance analytics kpi so majorly technical dashboards are being used by blue collar employees analytical dashboard and operational dashboards are going to be used by um you know mid-level managers or something like that so this is the overall picture how dashboards are being used and consumed okay basically the hierarchy okay hope you are clear on this particular part guys if you have any questions feel free to ask me i'm going to help you out okay that's wonderful any questions guys any questions any questions from nitin rahul rajesh i have no questions from ravindra akash has been a little bit active amit kumar very less response from amit kumar okay and rajesh yes rajesh you have to be little bit active as well okay vijay vijay is quite active okay okay wonderful guys wonderful thank you very much thank you very much okay so till now what you have understood is what are the various different methods that power bi can actually help you now we will jump and understand what is meant by power bi what is meant by power bi in a simple way guys in a simple way power bi is a sas based product okay software as a solution where is this a space somewhere it might be written somewhere here ha sas bcs it is out here which basically means it's a product that can be installed in your system and along with that it can also be accessed from the server as well okay and you can you can use it as an application or as a web uh service as well okay so majorly there are three different majorly majorly there are three different products which are actually available when you actually buy power bi okay so when you buy power bi there is a uh you know application called as power bi desktop okay which will get installed in your system let me show you that okay power bi desktop something like this something like this adding to that there is also something called as power bi desktop report server power bi report server power bi report server ah so this one so this is also a tool okay so the main difference between power bi desktop and power bi [Music] bi desktop the main difference between power bi desktop and power bi report server is there will be something called as rs which will be written here on the logo so power bi logo is something like this there will be something called as red red black color rs which will be written on this so this will be used for report server for building dashboards i mean reports sorry okay um you cannot build dashboards using uh you know report servers application so this is one of the product which is also available along with this thing so you have power bi desktop and you have power bi desktop report server these two applications okay majorly it is called as power bi desktop itself okay we will open power bi desktop we will show how to power how power uh need to be installed and all these things within something like 30 minutes on average on an average and adding to that this is this is called as power bi desktop and adding to that you also have something called as power bi ah just remember apps dot apps apps dot power bi okay dot com so adding to that you also have something called as power bi service okay which can be accessed using something called as apps.powerbear.com okay so this specific license okay i mean if you have license or if you even don't have license you can actually have it okay and um you can actually see various types of what i can say uh this thing so you can see reports you can see dashboards okay see here we have a dashboard we have a report okay we can also have something called as workspace all these things okay inside this so you are going to build your dashboard in your system and adding to that adding to that you are going to publish that particular uh this thing what against the report into something called as power bi power base service okay so when you do that that dashboard will come into this particular era in this particular area and here you have various types of workspace okay so work spacially workspace means like departments like you have finance department you have operational department you have uh you know budgeting department something like some of the departments so um so this will actually help you to segregate your work in a different way and use it and adding to that you also have development pipelines like you know i don't know whether you are coming from software background or not uh you know you you have something whereas development environment testing environment and production environment all these three environments will be available in this uh you know power pla so all these things are available in this particular service so whenever you buy power bi okay so you will get power bi desktop and adding to power play desktop you will be also having something called a power bi uh this thing as well what i can say um service as well that will be provided even though if you have free license i repeat again even though if you have free license you will get a free free account see here you will get a free account you can actually use it no worries okay so we will be teaching you how to get this particular account as well we will be also helping you in a very detailed aspect as well but right now what i was actually trying to show is number one you have power bi desktop you have power bi service our peer service is something like this this is this power bi service and last but not the least you you also have something called as power via mobile apps so power bi can be also accessed using mobile as well you can you can access those dashboards for mobile as well normally you know when you are building strategy dashboards and all you don't know where is your cxo you he might be in greece he might win athens he might be in france he might be us you okay so we don't know so for that particular thing dashboards building on a mobile applications can be really handy and helpful uh wherein when they can actually actually access their dashboard and understand what is going in their organization on a day-to-day basis hope you are able to get it so if you say if you are using mobile uh you know iphone ios android it doesn't get we don't care okay so for example play store if you are using play store pl a store play store st or play store let's assume you are using play store okay and you can say power bi okay i'm just showing for play store because it can be easily accessed okay see here you can actually install power bi and use power bi for your business so even it is available for ios as well no worries okay see it doesn't require even special setups or something like that but if you want to use i repeat again i repeat again if you want to use power bi in apple systems there are certain uh you know what i can say hiccups that you might come up come up come up okay so if your client is saying hey i'm using mac or something like that then you know there are something called as virtualbox or you know sandbox that are required to create a small environment inside our you know your mac computer where you can run power bi and microsoft applications okay because microsoft is a uh this thing right what i can say a different entity and they are competitors right so they don't allow um you know power bi to run in their system so they have a back gate okay to run these systems i mean proven these softwares so you have these options to use it so majorly you have one you have two and along with that you also have something as three major projects major products that are going to be used adding to that adding to that there is also something called as gateway g a t e w a y gateway power bi so there are two types of gateway one is called as personal mode uh second is called as on premises mode okay um that can be used just so something like this so this gateway is one specific tool which will sit in your system and it will try to refresh the data on a time to time basis for example uh let's assume you are having the data coming from sql server like searching okay so what this power bi gateway will do is it will try to fetch okay the previous data and current data and refresh the data accordingly for once in a day you want to refresh the data at exactly 12 o'clock noon so then there will be a trigger that will get generated and the gateway will do the refresh facilitate facilitate the dashboard refresh and uh this thing what i can say provide you the updated information so for that particular thing we have this gateway nobody is we will be using all these one okay we will be installing power bay gateways we will be installing powerbait we will be having popular services i'm just giving you a high level bird eye view what are the various technologies that we are going to learn in this particular tutorial okay so there is also something called as power be a gateway that we will be discussing after something like four or five sessions okay and this is this is normally used to refresh the data clean and clear clean and clear do you have any questions do you have any questions on these three things on these three things power bi desktop power via service power via mobile applications and gateway are you clear on this part yes or no if you are not clear feel free to let me know i'm there to help you out okay any questions i'm there to help you out so rahul sharma is saying no radhoad is saying no uh gorillas is saying no rahul sharma is saying no kimon das is saying no how about others how about others how about others vijay um akshay okay akshay how about others okay wonderful i got some significant response so these are some of the uh you know what i can say applications that we'll be discussing in this thing apart from this there are also some of the uh this thing what i can say um applications like pac-dated report builder okay that's one of the application wherein you can actually create report like i don't know whether you are from uh there is something like just letting you move it okay ag nated report builder uh power we have magnetic ripple power yeah so i think you might we have i think you may have seen something like this okay something like this so which which might be in your annual reports or something like that right okay there will be some this thing there will be some information right here okay or else uh something like oh these are dashboards right huh something like this something like this okay so these are these are actually called as magnetic reports and there is there is something called stagnated report builders there is a different applications which will actually get involved in this but whenever we use a power ba pro or power bi premium um okay this this specific thing can be used by high-end licenses not not on low-end licenses not on free version or pro version you cannot access this these these are a bit expensive extremely sorry so these are a bit expensive and [Music] these also cost a bit of uh extra amount okay that is something so uh majorly uh for our uh this thing we will be using power bi desktop power bi service and power bi mobile applications so these are the main things that we will be covering and adding to that when we speak about magnetic report builders or you know power bi report report server as well so these require dedicated sql servers like they they require something called a sql server analysis studio and they also require sql server reporting studios or reporting servers as well so when only you have these two things then only you will be able to use those applications you cannot build any kind of dashboards or any kind of this thing using uh you know sql servers or something like that okay so you need dedicated uh report servers so then only you will be able to access these kind of things okay hope you are clear on this particular but these are the ways basic products which are actually available when you actually buy a power bi license okay clean and clear clean and clear if you have any questions feel free to ask i am there to help you out any questions guys i got only one response uh okay how to work power bi mobile apps um that's a good question that's a good question by the way let me open okay okay so i hope you will be able to see my screen power bi desktop haven't got opened okay wonderful now the power peer desktop has been opened okay so this is my power bi desktop i don't uh want to discuss all the aspects of power bi but i will quickly jump into something called as view okay because question is hidden hidden here you have something called as mobile layout you have something called as mobile layout i can just click on this okay see here now i have mobile layout i can scroll like how i scroll on my mobile right i can actually scroll this here something like this i will be able to see so the layout is the same okay the process of building is uh you know the layout is different the process of building the dashboard is same you are going to build the dashboard how you build the regular dashboard hope you are clear on this particular part a roth hood click here clean clear upload okay that's wonderful so you build the dashboard then you publish the dashboard to power ps service from power bi service you know you know you will be able to access that from your mobile as well so something this is the whole architecture so uh to provide you better clarity on the architecture let me open the architecture itself okay how all of the products i showed you power peer desktop i showed you power the gateway i showed you by power bi mobile applications and all these things how they are going to help you to build your dashboard and consume the dashboard so now let me explain this specific information in a very detailed aspect okay we have very detailed aspect okay so now let me uh open my this thing what i guess annotation okay wonderful so you have two methods number one is you let's assume you have a data source like you know the data might be coming from sql server sharepoint salesforce azure okay or hadoop big data anything okay so this data will get imported to power bi service or else or else you can directly plug this data into power bi desktop as well i don't know why i actually closed my power bi this thing okay let me open my rbi again or video desktop okay so what really happens is you can load the data into power bi desktop or else you can load the data from power bi applications as well so here in power bi services you have data set c here okay so here in data set you have an option to load the data sets from here as well so you can get the data i think it's getting late huh so you can get the data like you can store the data something like this okay so you can say my data okay which is which are the my data and everything you can you can change the data source you can do various types of settings and all these things so one num one of the option is to get the data in power bi uh this thing what against the data sets and from there you can plug into power bi this thing so here in power bi you have something called as power bi data sets can you see that you can get the data set from here as well or else or else what we can also do is okay we can directly plug the data here as well okay so there are multiple approaches so that's the reason here in the visualization you have one of the option you can get the data to power player services or else you can get the data to power the desktop then what you will do is you will do the analysis like you will you will create the dashboard here you will create the dashboard here then after creating the dashboard then what you will do is here here you have something called as publish can you see that publish you are going to click on this particular thing then you are going to publish that particular dashboard into into something called as distributed into something called as power via service okay in that service you can do various things like you know one of the option is gateway refresh you want to refresh the data or else you in that service you can you can just push that particular this thing to other people like um people can actually access those dashboard from their mobile tablets or desktop okay anything can be possible so these are the various methods how the dashboard is going to be built in a very simple way step one you plug the data you build the dashboard okay after building the dashboard you will publish the dashboard after publishing the dashboard you will set the gate at data data gateway refresh after setting the data data you get a data refresh so the data will get refreshed and you will be able to access that same dashboard from power bi service or power bi mobile applications hope you are clear on this particular part i have two questions i assume so if we prepare dashboard in desktop and then can we access same in mobile it depends on licensure um i this is a very technical question i don't want to answer it right now okay um i will i will explain this when i speak about the three licenses which are actually available for power bi okay then i will be providing you the clarity sanjay okay please repeat just missed uh ashwini can you help which specific part you have missed so that i can repeat uh now i got no god you got so this is the major architecture what you are going to follow when you are building the dashboard okay so as i have opened power bi desktop let me base basically run through what is power bi desktop and what are the various look and feel that you are actually having with power bi desktop okay are you ready are you ready are you ready only one response only one person out of 11 people are ready only four response only four response only before response how about others how about others how about others only six six response only six response only six response seven response huh how about others eight response how about others how good are those guys we can learn any technology if we are going to be interactive okay and um the reason why i'm saying we have to be interactive there is a very hardcore science power bi can look really beautiful and really easy but when you try to do it right okay there might be some bottlenecks that you are going to come up with so that's the reason i request i beg to be interactive there is a huge difference between right click left click and double click in power bi okay and these are the only three operations that are going to be used in power pi yet uh sometimes as a beginner it can be really tedious and hectic so that's the reason um the initial part you have to be really interactive to learn the software really good i want to request this again and again okay okay guys okay okay so now this is power bi desktop so can you see here this is something empty so which basically mean uh if i'm able to enter my email id if i'm going to say yes and if i'm able to login i will be able to see my name here okay and add it to that power bi is a microsoft tool power bi is a microsoft tool that is the reason the look and feel of power bi is very very similar to microsoft word microsoft powerpoint microsoft excel you can see cut copy paste can you see here cut copy paste formatting which are very very common in power bi uh softwares like word uh word excel and all these things similarly you will be also able to see something called home insert modeling view help external tools as well isn't it so even that is also very very similar for example if i open power bi uh you know this particular power point i also have home insert drawer design transition animation so the the look and feel of the dashboard is very very same the upper part the upper part okay adding to that you have something called as these collapse buttons you have something called as these collapse buttons these collapse buttons can be opened these collapse buttons can be opened or closed as per your comfortability okay so here is your data so if you load the data into power bi so this data will be right here and adding to that you also have something called as visualization so for example if you want to create a line bar chart so you have an option to create this line bar chart here adding to that adding to that if you want to put any kind of slice extremely sorry if you want to put any kind of filters you also have filter options right here as well you can apply some filters as well adding to that this is called as a report view this is called as data table this is called as data model so there are three different views i can click on this report okay i will be able to see this particular information if i'm going to click on this table i will be also able to see this particular information similarly if i'm going to click on this information i will be also able to see this particular information so what is this this information so if i'm going to see this data table i will be able to see the data table information like relational column like excel sheet and here if i am going to see about model so this is all about modeling or creating relationship between one table to another table okay so if you know schema okay something very similar will actually happen something like this see here how one table will be related to another table so that particular thing will be in this specific in this particular area so i will do what i will do is i will quickly load a data i will say an excel i don't know which specific data i have i have something called as a personal dashboard no i don't want to use this kulati i don't want to use gulati's information i want to use something let me see let me see let me see huh i think i have some backend data okay uh yes power bi 360 training data set so let's assume i have one data okay so i don't worry i will be teaching how i'm going to load this data and everything how i am going to import this data so i have some navigators i am just going to click on this data here see here here i have a glimpse of the data its not the complete data set its just a glimpse of the data i have only 23 rows and all the columns okay which are available here i can say load the data will get loaded into power play this is so easy okay it's so easy that you just need to click there is no coding which is actually required to do uh to load power bi uh data files okay and similarly right now if you see here if you see here there is a new table which is called as order table which got imported into power pair inside power bi and if i'm going to open this i am able to see all the columns which are actually available i have something called as category city okay i have country and all this information i have also some numerical information how i am saying this as numerical information because it is having the summation sign can you see that it is having summation sign so this is how i can say this is a numerical column and similarly you have a tiny uh calendar so this tiny calendar say it is a date format so what i will do is this is in a long table i mean i'm not able to see the data what are the values and everything so for that particular thing what i will do is i will just go to just go to something called as power bi data table so this is called as data as soon as i click on data table i will be able to see a relational table like this it will it will get loaded huh it will get loaded so see here i'll be able to see all the columns which are actually available here adding to that i have the total number of rows which are actually available here there are 9994 rows in this data set and i can see all of them when i was loading the data i was able to see only 23 rows but now i am able to see all the rows which are actually available here can you see that see here these are the row what dancing so adding to that adding to that if you are actually having plan if you are actually having plan to create a relationship between one table to another table okay so this relationship can be built here okay like you have order table you have sales table you can you can combine you can create something cardinality in power bi okay so you can create those cardinality in this specific area we will be discussing this we will be doing live projects on this particular thing but i just want to make you familiar with the technology what you are learning okay hope you are able to get it hope you are able to get it so this is the basic look and feel of the uh what i can say power pair dashboard and this is the area where you are going to build the dashboard what i mean is this dotted line can you see that this dotted line is your compound for example compound so for example if you want to construct your home you will build your house inside a compound right inside your fence fenced nest you know net right similarly okay you can only build a you know what i can say dashboard inside this dotted lines okay then you might be scratching your head hey sangmesh this small or this so much big i don't want i have only three visualization for only these three visualizations such a big space i don't want such a big space can i reduce the area yes you can do that you have an option called as form at your report page okay here you have something less canva settings here you can basically play around with the size as well like i want this size width to be something like 750. or else no i want to increase the width i will call this 1 500 oh sorry 1 1 400 1400 height let me make it as 1000 i can increase the size everything is durable for example if i have one visualization if i'm going to create a line visualization i just go here i will just click on this visualization now i have this visualization inside this dotted line i cannot take this visualization outside this dotted line can you see that i cannot take this outside the dotted line okay i can resize this here i can resize this okay i'm just using my mouse i'm just using my clicks that's it i'm not doing anything else okay and i can resize it out here and adding to that adding to that i can move this anywhere from here to here and interestingly i can interestingly i can also control all of this visualization from my control panel as well so there are there are multiple options where i can actually use this uh dashboard so this tiny bit of piece is called as tile it's called as tile okay so this is a very small understanding about uh power bi and the power bi desktop okay so do you have any questions on this do you have any questions on this do you have any questions on this do you have any questions on this yes [Music] so as i have discussed with the po um we are going to make you a pro in power pi which basically means we will involve you to all the levels like you will be involved to power bi free license power bi pro license and power bi premium license as well and all of them will take your pan card details and credit card or debit card details and you can you can have it free okay or else if your organization is ready to shell out money you can get a premium license or a premium trial version as well so what i was actually planning is i was planning to um you know get individual license for all of them okay individual power bi license for all of them so that they can use practice uh on their own or else if you are ready to provide official license for all of them that is a trial version you can also do that what started you have the understanding gone god because suppose you are going to train us on the future times like whatever you are talking about these bi tools and other things if we don't have the basic a infrastructure with us we may not be able to practice them so it should not happen that we are running behind and you are running ahead here in the schedule in absence of the required infrastructure we will we will actually uh because here probably we can ask her also see when he's training us we get all these normal excel sheets right now with us in our systems which is being uploaded now therefore the bi tools there are 30 days free trial option is there which probably can be uploaded then there are the licenses which we have obtained from the microsoft and accordingly those has to be uploaded into the systems so what he's proposing is a trainer that he will tell us about the basic excel then there is some premium or professional and a couple of type of bi tools and he will take us through all of them then i was asking what is our understanding with him because it should not happen he's teaching us but we don't have that basic excel with us to practice it so here we will just simply see it but we will not be able to use it at that point of time till we get those kind of uh excel sheets with us so that is something to be but everyone what he's talking about is that there is a basic free version then there is a pro version and there is a premium version so in our course he is going to cover all three of them so till the time we are in a basic version probably we will be able to use this free downloaded version if you have any questions or concern on licensing part or something like that we can actually work on that i mean you have to probably see me okay hey sange i'm giving a premium license for all of my teammates then it is going to work out and this session today i will give you the entire information about the licensing part okay after this session when you when we end our session at five o'clock you will be in such a situation that what specific license is required for what specific business issue okay so then only i will also help you if you want to get in touch with us uh you know you can get in touch with us with uh sirisha she will be able to help you out with uh the licensing part if you want to get a license trial license for the entire organization you can also do that or else if you say that hey um you know i let let the employees um pay for their uh this thing individual license itself i will also help them how to get individual licenses as well so even that will also work for the if they are going for individual license they have they need their pan card details and they need their debit card or credit card so these are the two information that are required and if it is uh for uh this thing what against the organization then i hope uh you know about it or if you have any difficulty getting it i have i can also do that so it's very simple i will just go to my power bi service curious what it cost for our one license do we need to pay one time or do we need to pay annually and how much is the amount approximate not exactly sir this is this is going to be a trial version currently hope you are able to see that i used a 90-day trial okay and i have been teaching power bi from last how many months uh nearly one year or more than one year okay i started corporate training since january 2021 okay it's over one year okay and i'm using only power bi pro power via premium license okay that to trial version okay i use this i will end my trial okay and whenever there is a requirement i will go for another license something like that this is this is how i am actually working okay okay so what i say is get go for a trial this is why you want to shell out your money okay um so if you want to buy it then there are two uh licenses which are actually popular for individuals one is called as uh power bf pro second is called as power player premium after this uh session i mean after completing this specific power bi desktop i will move to power bi licenses i will show you what are the various licenses which are actually available with power bi and i will also guide you with all these things okay okay so we we are not in a hurry we don't need a license as of now we don't need a license we will need a license um something like three or four session afterwards okay so next session will be on data preparation using power query after that we will learn tax then we will do visualization after doing all the visualization and everything then we will understand power be a premium i mean for power bi services till then we won't touch for next three to four sessions okay we won't touch power bi service okay hope you're clean and clear on this particular part i'm extremely sorry guys i'm not able to hear you if anyone is able to translate that it would be really good it could be really great yeah what i'm saying can you just repeat how you have uploaded this excel file from your desktop sure sir sure sir no worries i will do that nicely actually see in our excel files that that is actually a good question being very frank with you so um power bi also comes with something called as power bi uh power query or query transformation so this is one such area where you can actually prepare the data and everything so we will not speak all of them right now but i will just do a basic thing i will just remove this power bi i'm just going to click on these three dots which is available here okay i'm just going to click on this then i'm going to go for delete from model i'm just going to click on this delete from model okay it is going to give me a prompt i'm just going to say yes okay as soon as i say yes okay um this table will get vanished okay so now i don't have this table and interestingly um i will be using this word again and again okay same destination but different routes what is meant by same destination different routes there are multiple ways to load the data okay so you have an excel workbook for example if you want to load an excel workbook you have an option called as excel workbook right here you have an excel workbook right here you you can also have something called as get data right here as well you can click on here you can say excel workbook or else you can click on here you can say excel workbook you can click on here you can say excel workbook or else you can click on get data here as well and when i'm going to click on this there will be a new pop-up window that will appear which will be called as navigator which will be called as navigator okay now i have clicked it okay it is going to open okay now i have something called as navigator okay here i have various types of files can you see that i have various types of files database power platform azure platform online services and all these things so here what i can do is i can click on you know files i can click on files okay and i can choose excel file okay and i can say connect i will do it again i can either click on here i then click on here either click on here or either click on here okay okay there will be something called yes sorry sorry to interrupt actually in between uh your actually the network there might be some problem in the network can you please repeat it once again sure sir no worries actually some problems no worries i'm there to help you out okay so there are multiple routes for the same destination which i mean that you have multiple ways to load the data into power bi which basically mean you can load the data excel data from here you can you can load excel data from here as well you can click on here you can get the excel data or else you can click on here and get the excel data as soon as you say i want to get the excel data let's assume i will take this particular thing okay so there will be a pop-up that will appear okay which will ask me to choose the excel file as soon as i choose and say okay as soon as i choose and say okay there is a navigator which will actually pop up there will be a navigator that will actually get pop up okay so right now okay this excel file i will show you i will open that excel file so that you are able to understand it um i will say d uh i will say power bi i will say data set so here i have csv file if you see this particular thing i have one csv which is called as 2017. i have one worksheet excel worksheet which is called as 2018. i have something called as people which is called as uh csv okay which is in a csv format let me open this particular excel so that you will be able to understand it is getting opened on my different screen just in a minute let me bring bring it out here uh right now so i'm just going to take this particular take this particular sheet out here you'll be able to see that this excel is having only one specific uh this thing but against a page called as order page you can load this for example uh let's assume you don't have one uh you know first row is blank or something like that so all these things can be handled using power query i will be teaching uh power query in our next session tomorrow session we will have a dedicated session where we will do various types of transformation on this data okay but meanwhile okay so let's assume you have another sheet called as uh i will call this as blank like sales i don't know i will say um hi hello hello bye something like this okay and i'm going to save this i will say save okay so now what i will do is i will uh i will refresh this data see here i will refresh this data so now i have order and now i have something called as sales can you see that so if i'm going to click here if i'm going to click here okay i will be able to see the column called as high hello bye similarly if i am going to click here i will be able to see i will be able to see all the sample rows all the sample rows and sample columns all the columns and very limited rows only 23 rows so to load i have to click load but i have to click it prior so if i'm going to click on this there will be something called as load that will appear if i don't click on this okay the load function will not appear similarly sales as well see here so let's assume hey sangmesh i want to load multiple sheets is it possible in power bi yes it is possible in power bi how we can do we can click on multiple sheets something like this something like this and then we can say load so now there won't be one sheet but there will be two sheets one will be called as order and one will be called as sales and sales will be having some random columns or some random rows called as high hello by something like that so let me show you okay it has something as column one okay and similarly you have this particular information which is going to be the excel files hope you are able to get it now what i can do is uh i can just go here i can just go here okay and see that i have loaded hi hello and here i am able to see i have also loaded all the data hope you are clear on this particular part sanjay any questions here any questions that's wonderful so now now let's go to the important part now we will try to download power bi for us okay so right now if you see uh if you how many i think there are couple of people who have power behind their desktop as well so if there is if they are able to see this particular thing there is something called as update available click here to download which basically mean there is a new version of power bi which is out in the market but you are using the older version of power pi okay i didn't intentionally uh upgrade my power bi the reason was the reason was um you know there are some of the things that need to be taught for you guys so i have not uploaded it okay so what i will do is we will learn how to install adding to that we will also try to understand how to upgrade if you have an older version of power bi how to upgrade that okay we will also learn that so now you might be scratching your head and saying oh my god how do i find that i have an older version of power which version of power bi i'm using you don't know to identify which version of power bi you are using you have to go to something called as files can you see here can you see here at your extreme right hand corner left hand corner files so in this files there is something called as about at the bottom can you see that about you can click on this about okay here you are able to see that i am using the apprehend version april 2022 okay and the version what i'm using is 2.104.7702.0 can you see that so this is the version i'm using and similarly this is my session id this is my user id okay so i can actually copy this and they can actually share this so for example this this can be really handy for people who are working in organization so people may call hey sir my power bi is having problem my power bi is having probably you don't know what is what is wrong with that then you can say hey share your details so if your manager is going to ask share your details this is a screenshot that you have to share or else you have to copy this information and share it to your manager so that he can talk to power bi uh team and they can they can fix your power via issue something like if you are actually having it okay so this is how you are going to see and can i get a confirmation which specific version you are using okay whether it is a approved version whether it is march version or which specific version you are using can you ping me on uh the chat can you ping me on the chat you can open your power bi you can open your power bi people who don't have power bi who don't have power bi on their system please go to power bi google and say power bi download oh why is this spelling download okay power bi download there is only one link for it okay that is https slash power bi dot microsoft dot com en iphone eu us downloads so this is the only link which is available you just need to click on this you just need to click on this okay and then and then there are various power bi downloads which are actually available you have power bi desktop you have power bi mobile apps you have power bi on-premises gateway you have on-premises gateway power bi report server you have on-premises power bi report builder as well so this this and this requires very premium license okay so but this is absolutely free you can just say download yes rajesh do you have any questions do you have any questions okay that's absolutely fine you can you can say downloads that there will be a play store that will open or else you can go for uh microsoft store extremely not extremely bad okay you you your microsoft store will actually open you can download from there or is you can click on advanced download option you can click on advanced download option and say download here okay so when you say download there are two prompts which are actually going to come up one is called as power bi desktop setup and second is called as power bi setup 64-bit and i know 90 of the people out in market are using 64 bits itself okay and click on 64-bit and say next okay that's it so there will be a thank you note okay and there will be a uh you know what i can say downloading that will actually happen here okay so meanwhile i i was saying repeat this steps please okay no worries uh rajesh can you help me with this specific step i will be able to help you out yeah you are mentioning this i'm audible yes it's your audio 100 yeah uh these steps so like how to download microsoft power bi please do repeat on this okay you want to sure sure okay meanwhile for a quicker response what i will do is i will paste this thing on the chat as well people who don't have power bi okay they can just click on this download link they can download meanwhile meanwhile what i'm actually saying is you have to go to power bi desktop please make sure this oh sorry power bi uh download on google okay and here there is a link that will start https okay power bi dot microsoft.com en us or downloads okay so the first link that you have to click so here you have various applications so you have power via desktop you have power bi mobiles on-premises gateway and all these things so out of which there are two options one is called as download option one is called as advanced option if you say download it will take you to power bi sorry microsoft store if you say advanced it will help you to get the exe file or else executive file i mean executable file okay so you are in my photo sorry to interrupt you in between but i don't think any of us would be allowed because of the id controls built in our systems so those are not allowing us to download any of this external software so we will call our ip guy do you have to speak to them so that's why probably everybody is facing this challenge we have to our only administrator will give us a right to download this kind of a software it is not a personal concept no actually after clicking on this link so automatically download will going you have to speak to your itt i'm not the right candidate okay so i'm just giving you a small idea here how to download it so um so this is it by the way i know many people are using power bi but no one had actually disclosed the version what they are using so the version what you are using is going to help me a lot to help you out a lot i mean help you out pinpoint with specific issues that because there are two types of you know uh panels that are going to be available one is this specific panel and second panel is i will show you just in a minute um options it is okay that's absolutely fine preview features video features um visual tooltip okay that's absolutely fine a new new format a new format let me okay say okay yes i will say okay i will close this power bi i will say don't save okay so this is this is the first panel that i showed you second panel of power bi will actually look something like this so there are two versions of our older version panel and second one new panel so the one what i was actually showing you was the latest panel so people who have power bi for a very long time that is something like six months seven months back or something like that they tend to have these type of issue so the the look and feel okay may look something like this so to resize it previously i went to something called as canvas but here i have to go to something called as page size page size previously i went for something called as canvas okay now i'm going to for page size here i'm doing the okay see here height okay i see 1500 width 1200 so the look and feel of the dashboard previously it was on top previously it was on top now it is at the bottom so these type of visual changes are actually available so people who are beginners they can find really uh you know good difficulty because these panels can be confusing that's the reason i'm requesting every single person who is having power bi please help me out with the version so that i can actually guide you better so how do you find the latest version you click on files you will say about okay and there will be a pop-up that will appear and you just need to copy this specific thing okay like this and you just go to chat and paste that particular thing out in the out on the chat people who have power bi on this system they can do that people who don't have power bi no worries okay your id team will actually help you to get power beyond to your system just now i call my it guy he's just taking the laptop is fine but not right now a free license is absolutely fine as of now okay we can upgrade after something like four sessions okay i will help you on that so right now free license is absolutely fine so if you want i can also help your id guy it's not a big headache okay to get power be a license you have to go to app store power bi something like this apps dot power bi something like this okay and uh after that um there is something called admin control panel there you have to okay let me say this one oh my god it is going to ask me authentication i don't have my mobile right now so there is an option admin controller and we can actually create users and all these things okay you can we can get in touch after the session okay okay no more issues okay so that is it and uh and what i was actually saying is um here i have downloaded my setup file so what i have to do for example if i want to upgrade so because if you see here okay i have an option called update available so i can click on this uh this particular link there will be a new pop-up that will appear okay so which will say what is the appeal updates which are actually available okay so on april 14th there was another update okay can you see so what are the different types of updates which actually happened in that this thing so uh in m query there was something called as dynamic parameter which was being involved okay in data connectivity there are three different data connectivities that are being involved in power bi services okay there is something called as goals updates which have been provided in mobile applications these are the two different uh changes which have been made in visualization there is new visualization called as app source drill down series pro for zoom zoom zoom chats are also proven provided and nova uh you know power power gain chart are also being provided here okay so these are the these are the updates that are actually available you can click on this this particular information power bi desktop okay you can just click on this there will be there will be it will take to this particular place you can say uh download it will take it will do the same process what you have done okay it will do the same process okay just give me a minute okay you you can just say okay something like this you can say download okay the same option you how you will install the power bi okay so i have the file here so that's the reason i'm just leaving this particular part so here you will be able to see all the just you know where it went okay just give me a minute so if you click on this you will be able to see what are the updates which actually happened so this update happened on 14th of april okay if you go a little bit down okay if you go little bit down they have well documentation what are the changes they have made okay so this is param parameter just in a minute gantt chart and all these things okay that's wonderful so if you go little bit up okay there are also some timelines in may 2022 that is this particular month what are the updates that are available in april 2022 what are the different updates which are actually available and in march what are the different updates which are actually available all these are well documented you can click on for example if i want to see march one what are the different changes which actually happened in march i can click on march 2022 here i'm able to see all the all the changes which actually happened in march can you see that can you see that so these are the these are the changes which actually happened in that particular month hope you are clear on that particular part so now to install power bi okay or to update power bi on my system what i have to just do is i just need to click on this okay i just need to click on this so as soon as i click on this there will be a prompt that will come oh i i need to close this power extremely sorry before installing this i need to close my power bi or is the power bi won't get installed properly okay okay just give me a minute i'll say don't save so then there will be a pop-up that will appear and now the pop-up appears okay yes so you see here the desktop had actually opened that's the reason there was an error so i can say retry i will say next i will say yes okay the same regular process i'm actually following even to update my power bi so there is no uh security patch which will be available the the process is same okay you have to download power bi desktop and then you have to install it so that is how you are going to update the version okay so now it will take a bit of time to um basically scan what are the which specific information whatever to the specific version i have and all these things so now it has started preparing to install now it has started checking all the files there will be there will be a pop-up something like this okay okay computing the space requirement now it will check whether i have whether my system is having the right space or not so here um the ram is required more than 8 gb and adding to that the system need to be over uh seven uh windows seven and adding to that it also require your system to be uh having good amount of space which basically means you at least need to have something like 20 gb of space on your feel free space on your system to work better on power pla even though if you have at least 1gb space left out in your system it will work smooth i mean the installation process will be smooth but the operation with power bi can be quite difficult things so that's the reason have an ample amount of space in your desktop so now it has us you know assist what are the requirements that i need to execute on this particular system so then i have to say just next i have to say accept next i have to say next that's it that's it so now what it will do is it will try to first assess what are the files which are actually available in my it will install the new uh files patches and it will remove the previous patches okay see here validating installation i have my power play in my system i'm reinstalling my power psc here i'm reinstalling my power bi okay so now there is a uh this thing so here i have my update so see here the setups file okay our service cannot be updated while the system running if you close the okay okay i will say okay so rajesh is not on youtube yes rajesh how can i help you do you have any question rajesh rajesh okay now everything has been done i have to say finish that's it okay i will be able to use the system but it is always recommended as soon as you install your system i mean uh install power bi on your system try to restart your system once okay as soon as you install your power bi there are some um what i can say uh files which need to get executed so for that a regular restart is actually required so that's the reason now i can go to power bi and i can actually install that power bi but now uh what i'm actually interested is i want to show you what are the various licenses which are actually available with power bi okay so i hope everyone are clear on how to install power bi on the system okay if you are not clear this recording will be provided to you okay if you want to refer it later you can also do that okay meanwhile if you have any other questions related to this you can actually ask me any questions any questions guys any questions any questions ashwini sanjay rahul amit thank you very much okay so now what i'm going to do is i will show you what are the various different licenses which are actually available tomorrow if your manager is going to come to you and he is going to say hey what type of license you want you will be in such a situation now that okay just okay so you will be in such a situation that you will be able to recommend them hey uh i want up or be a pro uh because it involves so and so activities something like that or is you can say hey uh power bi okay we are trying to install with the help of our itt thank you sanjay thanks for informing me if your team is facing any kind of issue installing i'm there to help you out okay so meanwhile uh i know you can be attentive here okay so there are majorly two types of license okay one is called as approved license one is called as a premium license hope you are able to get it so in pro license in pro license you will be able to shell out something like ten dollars nearly ten dollars okay in premium license you will be able to shell out something like twenty dollars okay and someone had actually asked me sangamesh if i'm going to have free power bi license will i be able to access power bi dashboard on my mobile so that answer is actually hidden in here okay so if you see if you see power bi mobile access that is only available with pro version and premium version and along with that there is also something called as premium per capacity so we will be understanding this premium per capacity which is very very expensive so it is something like uh 4995 if you just convert this it will be something like three lakh fifty to three lakh uh four lakh rupees okay per month okay usd oh okay it will be something like three lakh three like eighty one thousand something like that okay so uh this is this is a very quite expensive uh license but they have some of the advantages which these two license do not have and for small organization power bi pro and power bi premium will actually help them a lot okay so what i was actually saying is uh when you actually speak about power bi mobile access okay you at least need power pro at least need powerbear pro that is the first requirement for power pl okay and this cost ten dollars this cost twenty dollars and this cost something like um you know three lakh eighty thousand ninety thousand uh rupees per month all of them are for per month hope you are able to get it adding to that adding to that okay so if you are if you are thinking that i want to publish the dashboard like i want to build the dashboard i want to publish it and next part of the dashboard will be built by my friend who is working in the organization like you have two employees employee number one will do deeper data preparation and employee number two will do data visualization stuff if you have if your organization is planning these kind of activities then at least a power bi pro or a power bi premium is required if you don't have that you are not able to collaborate collaborate with each other hope you are able to get it along with that i have showed you something called a spagnated report like power bi uh premium will actually have something less stagnated that to have pagnetted report you at least need premium licenses and along with uh you know pagnated report you also need report server as well to connect the data to a power bi premium and you know get powerbear reports so this is this is also one of the requirement okay if you are actually planning for power bi uh magneto reports okay uh needed reports so have you seen uh any uh annual report i will report like you know you will get those uh reliance annual report tcs annual report right it will be in printed format there will be having some table some red something written out there something like that okay you can actually put insert some tables like this okay some tables like this some visuals can also be put here and some logos and some writing like this which can actually incorporate get incorporated so something like this something like this or is okay this is like this so these are packaging reports and this require a different uh this thing what i can say set up okay to run these on these things okay hope you are able to get it understood means apart from this data calculation and data presentation we can add these logos in all some different tables we can also put on top of that right reports only reports in only reports this can be done okay there is a huge difference between reports and dashboard that i will be teaching in our next sessions okay but this is used for reports only reports okay not for dashboards okay so according to you uh submission i'm just asking you according to you which license will have to go initially like instead of free license we'll have to go for first one second one go for the trial version it is the most safest thing okay okay and if you go for premium license you will get most of the features and it is really good okay because if you go for premium license you will be having uh row level securities as well your organization can also apply level securities as well and along with that you can also have development production and testing environment that is the development pipeline can also be integrated into your system as well so these are some of the um you know options that you are having there is also something called as diamond icon workspace which are which is actually called in layman language even you will get the diamond icon premium capacity workspace as well if you're using why i'm asking you because see currently we are having 11 participants here so we'll have to give a requirement over right guy also for future like which version will have to go whether for pro versus for premium so that's why i just i just want to check with you sir if you actually choose premium license you we will be able to cover all the chapters which are going to be taught in this particular in this particular session sir okay so if we are going to go for pro license what will actually happen is there is there is something called as development pipeline and there is also something called as rdl level security for those two topics you badly need power premium license you cannot do it on power bi pro license hope you are able to get it okay okay i'm going to be right transparent here okay so okay any other questions guys okay no right okay that's wonderful so what i was actually saying is what i was actually saying is okay so what is meant by the stagnated reports and uh you know how these are going to be used and along with that there is also something called as consume content without a per user license which basically means so this is something called as per user license can you see that even this is also per user license if you go on top if you go on top this is also per user license which basically means for your organization okay for your organization if um let's assume your organization tried to hire something like 20 power bi developers 24 billion developers all those 20 power bi developers will be paid ten dollars or twenty dollars to have power bi pro or power bi premium license hope you are able to get it and and when you go for this per capacity when you go for this per capacity you are going to have no licenses for example if you are working in an organization that power bi license will be given as a complimentary thing for you and you can use it you can you can do various things okay so here for this particular license you don't have that particular thing and along with that here sharing and collaborating can be really tedious i mean not tedious exactly um very secured i can say okay um because they also have incorporate something called by biok um keys as well and all these things so um so all these things are actually having certain advantage and disadvantage as well and adding to that on-premises reporting with power bi report server is possible only with this particular thing okay if you are actually having premium per capacity only in that case you will be able to use a dedicated report server dedicated report server for uh your services and all these things for a premium license you need to get another report server and then from another report server you have to plug in uh to power bi and you can do all these activities but majorly what i have seen is uh very few organization have used pagnated reports most of the you organization tend to use reports normal reports uh or else they tend to use dashboards or printer so these are the most popular options which are actually available so i don't recommend to get a dedicated report server because dedicated report servers are very very expensive as well okay because you need to have an ssis you need to have a sses then you need to have a ssrs so all these three things are actually involved so uh i recommend for initial uh setup and all these things um powerbi what the things what we are covering in this particular topic this is self-sufficient this is sufficient for doing all these things but this is something what i want to inform you so that if you have plans future to get a dedicated report server uh if you have if you want to have a standalone ssis ssrs and sses so in that case these are something which can actually help you okay hope you are clear on this particular part hope you are clear on this particular part okay yes what is this ssis sscsrs server dedicated report server so there is something called ssis ssis means this is that this is a part of msbi okay so this handle your etl process like extract transform load all these three stages okay so one point in time okay all the organization tend to use this ssis so my sequel they have a different terminology but microsoft has a different terminology so they have something called as msbi msbi so this msbi contains all these things what is what i was actually saying microsoft business intelligence this microsoft business intelligence contain ssis ssrs and ss okay so what is meant by ssis ssis is a part wherein you are going to do that etl activities okay in ssas you are going to analyze so you are going to create those cubes cube structures in the database you are going to store all your information in the cubes that is called as sscs ssrs is a reporting server okay so where you can run analytical servers okay and produce create reports in analytical servers so this is this is all the parts of msbi so if you speak about msbi use for okay let me see msbi ssis ssrs and and ss sses sorry okay so if you say so this contains all these things ssas ssrs and ssas so msbi these are the parts of mspi hope you are able to let it so these these are useful for those organization who have a really large amount of data who have difficulty uh you know um retrieving the data whenever they want hope i answered your question yeah okay and how about the capacity of the data storage sorry sir if we create such type of server how much is the capacity uh like ms sql stores 10 gb free space for database uh that actually depends on the license but being very frank with you organizations have been storing this information for a very this thing so i have seen people storing 100 gb people storing 150 gb 1tb this is the amount of size that i have actually seen they have also uh cloud storages as well ss i know sql server management studio is available on server as well even in cloud also you can develop and deploy all these um ssis models as well you can you can create some scheduled triggers wherein the data will be fetched from a specific folder or a specific area and they can update the data and on all those things so all these process of store procedure schema okay like all these things will be involved in that particular ssis okay so i don't want to discuss because this is not our scope of this tutorial we are speaking on power pi so i just give you a small idea what is meant by ssis ssrs and is these these msbi stuff okay okay so uh so adding to that adding to that uh there are certain things that also need to be understood okay so first of the thing first of the most important thing is something called as model limit so let me open one of my old power bi dashboard which i have created okay so let me see i have i have a couple of power bi desktop i have something called as ryan's project okay so i can just click on this okay i can say properties oh sorry properties okay i can say properties here i have opened my properties okay which is saying 6 mb can you see that it is saying 6 mb which basically mean that the model size of this particular dashboard is 6 mb so if you are using a power bi a power bi the model size will be something like 1 gb 1gb is the maximum amount of power bi file that you can actually incorporate in your organization for for pro license okay similarly you can actually have 300 gb if you are using premium license you can also use something like 400 gb if you are using uh premium licenses for per capacity license so this is also some of the information so this is model size is all about the file size of the uh you know model okay the the file of the power pi what you are actually having but being very frank with you being very frank with you if the model size of the power bi is going to reach nearly something like 600 or 800 900 mb megabytes okay you will get performance issues that we have seen so for that i have never seen organizations who fine tune a lot i have seen people if this is having problem then we will jump to power we have preview i think someone is not only extremely sorry to say please kindly look on you i think rajesh rajesh please go on mute that will be taken care of okay i have unmuted okay so so that is that is something what i want to inform you okay so adding to that when you actually upgrade the plan you will also have capacity in in uh what i can say power bi premium you also have something called as uh data flow okay when you actually incorporate the data flow we will be also understanding data flow in within something like five or ten minutes so even that in data flow you have an opportunity to reduce the model size and put the load less on the power bi so even those types of options are actually available in power bi okay so this is this is the main difference about model size and adding to that there is also something called as very very important thing that is called as refresh rate which basically mean how many times i can refresh the data in a day okay so if i am going to use um pre you know what i can say pro license i can refresh eight times in a day i can refresh the data eight times in one day okay if i'm going to use premium license i will be able to refresh that data every every two hours which which basically means every uh you know two hours i will be able to refresh if i am going to make it as total in one day there will be 48 refresh but if i am going to see this particular license for every two hours oh extremely sorry i am extremely sorry put it in a wrong way okay if you are going to use power bi pro license you will be able to refresh the data two hours once okay for the entire day if you are going for premium license if you are going for premium license for every 30 minutes there will be one refresh which basically means 24 divided by sorry 48 divided by 24 so which is just going to be 30 minutes and similarly the same thing okay for every two hours you will be having this uh this thing 24 divided by eight you will be getting that particular two hours okay so this is how which is actually available and adding to that okay you have something called as uh power via premium as well which is also having 48 refresh okay here normally people tend to ask only 48 refresh but every 30 minutes one times it will refresh oh my god don't you feel that this is wrong then power bi is useless people tend to literally say me these kind of things so people also have requested things like hey let's let's assume i'm going to plug in stock market data ohlc data that ohlc data will come from stock market api and i want to visualize it in power is either is that possible people have actually asked me these questions so whenever people actually ask these questions i say yes it is possible in power bi but you need a different setup called as push push and streaming data is tr va and minus streaming data question trimming data services in power bi okay so if you have these kind of things okay like real real-time streaming capability okay that is possible in power way but it is quite expensive thing uh for a normal small organizations so it is computationally expensive very expensive its not expensive it's very expensive okay so most of the organization even though it is a really big organization don't don't tend to go or for individuals it is it is a dream dream come true to use these kind of things and power breast apis uh can be used here to you know do all these activities okay so there is something like pubnub there is something like pubnub okay there is uh something called as uh where is this custom streaming data that i just told you streaming data and last but not the least [Music] this is popping up so there are actually three types of options streaming data oh my god it is not available it's not showing there is also something called as push data push services okay using this push data also you will be able to see i am not able to i need to read the document in a very detailed aspect there are there are three one is pop now one is called as push and second is called streaming data so these three options you have but computationally a little bit expensive only um companies who are having dedicated servers okay who can manage these things dedicated abs who can actually manage this can actually do these kind of things okay i'm just giving you a small idea here and uh for model preparation and all okay for model preparation and all you can see here you can connect you know data for more over 100 uh you know information and along with that you can create uh visualization as per you you can do embedding api embedding you can you can get the api put it into power bi or get power bi api to publish or show it to someone else you can do that ai based visualizations there are certain ai based visualizations like there are certain options where you can actually ask a question to power pi you can actually ask question to power be like what is my sales last month or last year the power bi will provide you the specific information saying that okay this is the visualization in that the last month sales was so and so something like that so if you want to ask them hey what is the relationship between um my sales and profit so it will provide you a relevant visualization which will say sales and profit so even though let's assume uh profit and revenue these two are completely different so uh revenue is also called as operational revenue something like that so instead of using revenue if you have used operational revenue you can also create those things okay in such a way that it will provide you uh this thing so now all this natural language processing and all these capabilities are actually available in power bi so these are some of the nitty gritty stuff which are actually available with power bi not only uh question and answers there is also something called as key influencer charts uh there is uh uh there is uh something called as uh this thing what i can say um influence of visualization so there are a couple of ai based visualizations so which use um you know artificial intelligence to help up with the visualization and adding to that there are also something called advanced ai as well which basically means you can do text mining you can do image processing you can do automate machine learning algorithms but it is not available with power bi pro license it is only available with power bi premium lessons per capacity or uh you know uh full whole whole capacity okay and xml connectivity so this is normally used by advanced developers like me okay you know this is used for understanding the connectivity understanding or altering the connectivity managing the uh version control for all these things we use xmla endpoint so connectivity so people who are well-versed with sql servers and all these things they will be able to identify what is meant by xml endpoint okay and one of the most important one of the most revolutionary part of power bi is this particular thing this is called as data flows and this is only available with power bi pro sorry power power be a premium per capacity and whole capacity so what it do is let's assume sir let's assume you have a huge data let's assume you have something like trend 10 trillion rows of data and you want to get it um you know you want to build a power bi dashboard or something like that to get all those 110 trillion tb or mb data you know into power bi okay it can be possible only using data flows if you are going to get it into your system okay so let's assume your system is something like uh tb and you are getting 90 you know 90 gb i'm sorry 900 gb of data into your system your system will get lots of problem computationally it is very expensive for your system inside your system it can take your system may hang it can you your system may get corrupted or there might be various issues that you might be facing so to handle all these things power bi has something called as powerful data flow which basically means you can get basically prepare the data in cloud environment like if you want to clean one specific row or a column you can clean that particular data in cloud okay and from there you can get that data into a sample data no it will it won't take the entire 900 gb data it will take a sample data into your power bi you can do the visualization and after doing the visualization you can again publish that file to power bi you know what against the server and there the actual visualization will come okay the entire visualization something like this so this is called as power bi data flows which can be used for big data hope you're clear on this particular part guys hope you're clear on this particular part this is very very uh important for people who are using larger amount of data like you can do direct query so we will be explaining what is meant by directory linked computer entity enhanced computer engines and all these things in our further sessions not right now okay and data security and encryption beautiful okay what it basically means power bi has shared environment when you are using per capacity which basically means for example my organization okay is out in karnataka and your organization might be maharashtra okay so what will actually happen is my data and your data will be stored in one single drive itself but it will be encrypted in such a way that none of my data will be shared to you and none of your data will be shared to me even there is a bug or any such this thing okay so this is the data security and privacy that power bi is actually incorporating hope you are clear on this particular part okay and uh there are also something like matrix creation um you know metric creation uh composition publishing and all these things so this is all about regular tasks that you are going to do we if you are not able to understand this we will be applying all these things on our in our regular class as well and uh this is something and along with that i was speaking about application life cycle management so the development pipeline i was speaking about something called as production environment testing environment uh development environment all this life cycle management can be only available with power bi premium not with power bi pro so that's the reason if you are getting power be a premium license all these options can also be understood and you will be having a better knowledge on the same okay so uh so it's all about the development like life cycle okay so for example if you are building your dashboard and if something goes wrong okay the end user will not get affected for example you are developing the dashboard and you have bring the dashboard and that bug will be transferred to testing environment where there will be proper testing which will actually happen and okay they will say okay this develop this dashboard is not good okay you have to change this bug or you have to rectify with this bug and there is that particular layer but if you are using a pro license what will actually happen is you develop and you test okay if there is if the testing is not proper or something like that okay or else if you are not even putting that particular layer you will directly publish that and the user who is actually using that particular dashboard will say oh my god there what is this what is this issue yesterday it showed something like 1 lakh ok now it is showing like 90 lakh so the sales need to increase but how come there is a fall or something like though these kind of logical issues can be available so for that particular reason power bi has these three environments one is called as development and neural network is called as testing environment that is called as production environment and they have also provided this capacity as well so that um you know sometimes if you if you have a larger data or something like that you can do that capacity management in these these these aspects as well so this is uh application lifecycle management how you build dashboard and develop dashboard and publish dashboard all these things and uh last but not the least this is again used for you know what i can say uh premium you know capacity people itself which basically means they have one advantage like let's assume the server is in ukraine and currently russia is bombing ukraine like here and there okay and your data will be safe okay so your data will be kept in japan and u.s okay in even in india okay in such a way that it will be encrypted and if there is a uh what i can say bombarding or if there is some mishap it is going to happen like earthquake or these kind of things okay your data will be safe here and there but uh if you are indian and uh if you are using microsoft service pro or premium the high probability is your data might be stored in bangalore or pune or the i i heard that there is one data center which is actually getting developed in the gurgaon sector in delhi i don't know whether they have done it or not but in pune and bangalore they have a dedicated centers data centers okay so your data will be stored any of these for example if taliban is going to bomb um a punish this thing data center then obviously all of your data will be jeopardized okay something like this so for this they have multi geo deployment and one of the major problem when you have a really big data is data center failures like okay when you are actually taking data from uh one system because of the internet issue or because of any other this thing the the data refresh may get failed or data uh data coiling may get failed okay there are there are multiple issues which actually happen when you have too much of load on the server okay so all these things will actually get managed when you are actually using uh capacity when if there is one failure then there is another another ready okay within something like 30 minutes everything will be rectified and you will be able to use so the chance of failure the microsoft actually claim it i don't know whether it is true or not they say that okay so within something like one tenth of so you know if if you are having ten issues one of one issue will be solved within so and so time okay so they have they they claim that uh within one tenth of uh the this thing what i can say um uh time you will actually face an issue with power bi uh you know data centers so they have these kind of promise i don't know whether they are true or not and adding to that uh they have something called as bi okay this is not with power b approved that would be a premium this is only available with capacity itself what they mean is they will give one key if you are going to insert that key then only your power bi will open and you will be able to use that power bi and auto scaling feature this is normally used for machine learning and all these things auto scalability and all add-ons availability so this is actually available with only uh capacity version okay not with everyone okay and the maximum storage is for 10 gb for pro 100 tv for this thing and 100 db for capacity so this is this is a small description about the various licenses which are actually involved in power ti okay hope you are clear on this particular part if you have any questions or concerns feel free to ask me on any licensing part or something like that if you you can ask ask in this session or else if you want you can ask actually ask in our next session as well hope you are clear on this particular part any questions we are trying to install with the help of our itt okay how many of you have installed power bi on your system say yes on the chat how many of you have installed power bi on your system no questions rather is having no questions uh vijay has a power bi on the system uh vijay can you confirm the version can you confirm the version and uh people uh i just also want to inform you that uh this is uh i don't don't have okay um this is again for people who are using power bi every single month a power bi will be coming up with one or the other updates and you have to install it okay if you don't install it there might be some issue with the data refresh or it might be some issue with the visuals itself okay and data refresh can be laggy as well one zero four huh april right okay that is absolutely fine the good good vijay thank you very much okay don't have so i assume that uh your your team is going to help you on power bi uh this thing what i can say license okay installation um if you are having any questions or concern you can get in touch with uh 360 digit they will be able to help you to connect me and we will be able to help you to get the licensing part and all these things any questions you can you can come to our help okay we are there to help you okay so any questions guys any questions so things can be moderate i mean if you want to be um you know dynamic or something like that i can go dynamic if you want hey some measure quite fast we can we can slow down or something like that even that can be also possible everything can be possible as per your custom ability okay i'm just going to inform you beautiful rathordy is also having wonderful so if you are using april 2022 that's wonderful okay uh so i think it got released in the month of uh april 28th or 14th okay either of these two dates okay that's wonderful guys okay it was a nice session if you have any questions or concern feel free to ask me right now if you don't have any questions okay you can get in touch with me tomorrow if you have any questions before we start ahead our discussion we will have one q a session which will be open wherein you can ask any questions related to our previous topics or something like that we are there to address that okay all good we can work on this free uh version right yes yes you're absolutely right and after that we'll have to go for maybe pro or premium right i will give you two session prior itself before two session prior itself i will inform you that we need to get uh license then what type of licensing you want you want to go for a trial version individual or if you want you know what i can say um if you want to go ahead with something else okay even that can be also possible like organizational license even that could be possible as well i'm there to help you out no actually what happened you know this this free version is also the validity of only one month so our classes will be an income this free version is for one month only valid for one month oh is it so can you share your screen sir i'm just saying no it is going on fine uh downloading is going on okay okay as for my knowledge free version is completely free and i have been using since a couple of years i can say okay so i started using power bi since 2019 18 19. since then i am able to use it without any hassle i don't know why you are facing that particular issue i do not have a complete knowledge about that yeah i was thought actually about that the validity for one month okay okay so i'm using for a very long time if you have such issues feel free to get in touch with me i'm there to help you out in that case okay okay that's wonderful okay guys it's 7 15 we took something like 15 minutes extra uh i have a small question here um do you want something like five minutes break or ten minutes a break in between or you want it to be in an entire stretch it's completely up to you if you want a break in between we can take a break uh between something like 3 30 around for something like 5 10 minutes 15 minutes as per your availability [Music] or 10 minutes we can do that okay so for every one yes sure ten minutes okay so you can decide it you can decide it we will catch up tomorrow okay and um 3 30 will be that time when i will provide you a break okay if you want it for five minutes if you want it for 10 minutes even if you want it for 15 minutes we can decide at that point for that point in time okay okay guys it was really a nice session with you um i i expect the team to be really interactive because see power bi as i've told you there is only right click left click double click that's it but as a beginner most of the power bi developers get confused what to do how to do so for that particular thing i request to be really interactive we will do okay i will do it i will give you some time so that you can do it on your system okay so this is how we have our learning process this is how we learn power bi so that's the reason interactivity is very much important okay thanks for your wonderful introduction looking for session tomorrow okay thank you nathan thank you for your comment i'll be waiting for you thank you very much vijay okay thank you everyone okay have a nice day bye thank you