Power BI Full Course 2026 [FREE] | Power BI Tutorial For Beginners | Power BI Training | Simplilearn

Every time a company tracks sales, studies customer behavior, monitors revenue, checks regional performance or makes a business decision using dashboards, data visualization is working behind the scenes. And one of the most popular tools used to turn raw data into clear interactive insights is PowerBI. Welcome to this PowerBI full course by simply. So in this course we will start from the basics and understand what PowerBI really is, why it is used in business intelligence and how it helps convert raw data into meaningful reports and dashboards. We'll also be looking at PowerBI desktop, PowerBI service and how Microsoft fabric fit into the overall PowerBI ecosystem. Then we'll be exploring PowerBI desktop interface. Understand important areas like report view, table view, model view, data pane, visualization pane, and filter pane. This will help you get comfortable with the workspace before building report. After that, we will learn how to load data into PowerBI from sources like Excel files, folders, and other data sets. Now, once the data is loaded, we will move into Power Query Editor where you will understand how to clean and transform data by removing unwanted rows and columns, changing data types, handling missing values, removing duplicates, splitting, repeat, splitting columns, grouping data, and prepare the data set for analysis. Next we will focus on data transformation concepts like wide format, long format, pivoting, unpivoting and data granularity. Now these concepts are important because clean and properly structured data makes reporting easier and more accurate. Then we move into report creation and data visualization where you will learn how to create different visuals such as bar charts, column charts, pie charts, funnel charts, lineups, cards, and combo charts. We'll also explore formatting options like titles, colors, labels, borders, background, and visual styling to make reports clean and professional. After that, we will be understanding slicers, filters where you will learn how slicers help users interact with reports and how visual level, page level, report level filters help developers control what data appears in a report. We'll also be covering important Power Query operations like append and merge. You will understand how to combine multiple files, connect tables using common columns, and work with joins to bring data together from different sources. We'll move into data modeling where you'll be learning how to create relationships between tables, understand primary and common columns, work with cross filter direction, and see how relationships affect reports. We also introduce DAX, which stands for data analysis expressions. You will learn how to create calculated columns and measures, use functions like sum, count, average, calculate if, and nested if, and understand when to use power query calculations, and when to use stats. Next, we'll be exploring advanced report features like bookmarks, buttons, page navigation, image based navigation, drill through hierarchies, groups, and interactive multi-page reports. You will get introduced to AI visuals like the decomposation tree or deeper analysis. Finally, we'll look at publishing reports to PowerBI service, sharing reports, refreshing data, managing access and understanding role security so that different users can see the right data based on their role. And by the end of this course, you will understand how to load data, clean it model, build interactive dashboards, write DAX calculations, publish report, and use PowerBI to turn raw data into business insights. So let's get started with this PowerBI full course and learn how data can be transformed into powerful visual stories. Also just a quick information if you are interested in boosting your career in business analysis do not forget to check out our AI powered business analyst course. Now this course is perfect for professionals who are looking to enhance their skills with the latest tools like PowerBI Excel SQL all while gaining hands-on experience with real world projects. You will learn how to leverage generative AI for smarter faster decision-m. Now our program is IIBAok V3 aligned and it will help you prepare for certifications like CBA and CCBA. You'll be engaging with 10 plus industry projects, 40 plus practical activities and benefit from live online sessions led by experts. Plus with Sinclair's job assist you will get the support you need to land in next big role. So what are you waiting for? Hurry up and enroll now. The course link is mentioned below. Before we begin, here's a quick beginner friendly quiz question for you. Which PowerBI feature is mainly used to clean, transform and prepare data before creating reports? PowerBI service, Power Query Editor, report view or bookmarks? Let me know your answers in the comment section below. Okay. So, in this course, we are going to discuss about your PowerBI desktop application. Okay. So today we are if you have not uh installed the PowerBI desktop so we are going to install it. So the PL300 exam if anyone uh because it's a mixed cohort right some of you might be appearing for the PL 300 some you some of you might be just join the course for learning about the PowerBI okay so let me just discuss about the PL300 PL300 is basically a Microsoft certifi certified course for your data analyst okay which is valid for one year so that course comprises of two things okay it will comprise of two things your PowerBI desktop application desktop application and we will be also because all the analysis we are going to work on the desktop okay we are going to install in our system it's an offline application it's an offline application so we have to install it in our system okay after that once we have done the analysis and all those things we are going to publish it to share it with our peers okay for publishing it we need another application The cloud version of PowerBI that is your Microsoft fabric. Microsoft fabric which was earlier known as PowerBI service. Okay, which was earlier known as your PowerBI service but nowadays it is known as Microsoft fabric. Okay. Now coming to the course materials. What we are going to learn by the end of this course. You are going to learn okay you are going to learn about the PowerBI desktop application here. Okay. What are the things we can do the analysis using the PowerBI desktop. You are first going to learn about how can we connect to multiple different sources. So in PowerBI we can connect to 150 plus data sources. Whether it's you can get the data from an Excel file, you can read the data from an SQL server, you can read the data from any website. So you will be able to connect it to the data and you will be able to work on it. You will be able to work on it in the PowerBI desktop. Okay. Once you have gathered the data right once you have connected to the different data sources the data in real world what will happen is that there will be lots of issues with that there will be missing values there will be duplicate values right formatting issues will be there okay for those datas you have to first clean the data and then you have to go for so here you can see model and transform Right? Model and transform. Model means if I in simple words I will be discussing all these things in detail. I'm just introducing you to the course right now. Modeling means see we can connect to multiple different sources. So suppose one data you are getting from a PDF file. Another data you are getting from a excel file. Okay. Now there you have to connect it. You have to connect it to use the data. So that connection you can think of it as the model as the model and then you can go for cleaning the data that term is known as your transform. Okay. So we are going to learn how can we connect the multiple data coming from the different sources and we are also going to clean the data so that we can do the analysis. Okay. Then we are also going to create some calculated columns. Okay. In the middle of the anal uh analysis we realize that we would require some calculated columns. Calculated fields are required. Okay. So we have already an existing data is there. Data set is present with us. But the thing is that we would be requiring the help of multiple maybe we have to create ex extra fields so that we can do the analysis better. So we are going to go for creating data. So here in this course we are going to learn about that as well. Okay. Then of course we are going to learn about creating the reports and creating the dashboards using and publish in the PowerBI service. So as I mentioned it is no longer known as your service. It is known as your Microsoft fabric. Okay. Microsoft fabric. Please at any point of time if you are not able to understand anything please let me know in the chat. Okay. So these are the things that will be covered in this course. Okay. Let me go into the detail right now. Okay. So what are the prerequisites for the course? So you might be aware that PowerBI is nothing but your extension or I can and I I can say advanced Excel. Okay. So it is the pre- requirement that you should be aware of your pivot tables and pivot charts of your Excel. Okay. What happens is that because PowerBI works on the same concept that is it summarizes the data. It summarizes the data like pivot charts and pivot table summarization right. Similarly in PowerBI also the charts you create right it gives you the summarized output. Okay. So that is why they have asked you that it is a pure requirement that you are aware of the working of the pivot tables and pivot charts. Now let me go to the other part. Okay you can see the course outline what we are going to learn. So as you are aware so this is a six day session okay in this six days what we are going to cover we are going to learn about what is PowerBI okay so this PowerBI consist of two words power and BI so we are going to look into that we are also going to look into the terminologies and the interface of PowerBI so which we are going to do today itself okay we are going to in if you haven't installed the PowerBI desktop we are going to look into the installation and then we are going to getting introduced We will be uh introduced to the uh interface. We will learn how can we connect to the data sources. We will also learn about the data modeling. Right? In the upcoming classes, we are also going to learn about the data modeling. Now again I repeat what does the word data modeling mean? Datas are coming from multiple different sources or you can think there are more than one table. there are more than one table. Okay. Suppose if you are aware with the SQL or not doesn't matter. Okay. So if you are aware suppose we have the customer here and we have your um orders here. Okay. This is a customer table and where we have details about suppose customer ID, customer name. Okay. Then the customer age maybe city he lives in country. Okay. Similarly the orders have the order ID then they have the customer ID. Okay. So basically it's just a reference to the customers table only. Then the products ordered then the amount they have paid. Now if I want if the customer wants to fetch the information if we if they're not the customer if we want to fetch the information okay retrieve all the customers who have ordered something retrieve all the customer details who have ordered something in that case I have to connect to this table I have to connect to this table because without connecting I'm getting only the customer details but I don't know whether the that particular particular customer has ordered anything or not. This is known as your modeling. So we have to connect the data. We have to build a relationship. So that is your modeling. Okay. As I mentioned once we go there, once we learn about it, we are going to look into that. Uh customer ID would be a point of reference. Exactly. There should be a common column. If we want to connect two tables together, there should be a common column. Without common column, you will not be able to do it. So next we have to once we have gone for data modeling we can go for profiling the data. Profiling means nothing but analysis. You can do do the analysis. Okay. And once you are doing the analysis you will go for visualizing as well. You can go for visualization in terms of some charts or tables. Right? And while doing the analysis and while visualizing the things you realize that I would require some the help of some extra uh columns so you are going uh you are going to create the calculated columns as well. So what does what what does the calculated column means? Okay for example think about it we already had we already have the height column and the weight column. Okay. And suppose we want to do the analysis. What I want to do? I want to create an extra column BMI column. Okay. I want to create a BMI column. So don't you think that is the uh calculated column we are going to create by the height and the weight. So this is how the DAX is. So that what is what is here I'm mentioning. So while analysis you realize while visualizing the data you realize that okay I have to go for the uh DAX I need the help of another column. So you can go for the DAX. DAX is nothing but your as you have the in Excel right you for creating using the formulas you are creating the columns. Similarly DAX stands for your data analysis expression. Okay DAX stands for your expression. It is nothing but it is going for creating calculated columns using some formulas. You are applying some formulas and you are going to create the columns. Okay. After that in this course we are also going to learn about the optimization. So to be honest using PowerBI you can go for creating lots of visuals. Okay. Lots of re v visuals you can there are lots of visuals are available and those are all interactive that means if you make change in any chart it will be reflected in the other chart as well. Okay, in that case what happens is that once you publish it, once you have done the analysis on your personal system and you want to share it with your peers because why are we creating the reports, right? Why are we creating the reports? To share it with our peers, to share it with our managers. Yes, we call PowerBI functions as the DAX. Once you have created the charts, what happens is that when people are learning PowerBI, they go for applying lots of charts. Okay, that's totally okay. But once we go for in our organization, we work on a day-to-day basis, right? We have to make sure that once we share the peers or we are doing any refresh, right? It is happening uh it is more efficient. It does not take long time to refresh. It does not take long time to refresh. So, we should make sure it is only depicting the required information, not the unnecessary information which is not required. Okay? So we are going to use only those charts which are depicting the information. It is just able to represent the information what is required but it is not heavy. Okay. So we are going to learn about we are going to make the report efficient. Okay. Efficient. So that is coming under the optimization. So we are going to look into that as well. Yes. Once shared the changes uh changes made would reflect on the created report. share dashboard as well. Okay. So, PowerBI is known for your interactivity and analytics. So, you are obviously going to look into that. Okay. And also publishing into the PowerBI service. So, as I mentioned once you have created done the analysis, created the reports, you are going to publish it. You are going to publish it in Microsoft Fabric. So, we are going to do that as well. In the last session, we are going to create okay, we are going to create the dashboards. Now if you are familiar with the other BI tool maybe your uh Tableau okay in Tableau the reports and dashboards refers to the same thing right okay symbol we create one chart in a single page but this is not the case with the PowerBI it looks like same it looks like your PowerBI reports look uh PowerBI reports looks like a T tableau dashboard that means in a single page we have multiple charts in a single page page we have multiple charts. So that is why it is known as a report. Okay. So and PowerBI report we create in PowerBI desktop and PowerBI dash uh and the dashboards we create in your service. We cannot create a dashboard in your PowerBI desktop. Once we publish it, we go for creating the dashboard. Okay. After that we are also going to look into some advanced analytics. So we'll go for some bookmarks. Okay. Then how can we use the hyperlink in the image? Everything will be shown to you. And how do we manage the data sets in your service? Okay. So this is the course outline. Okay. On the sixth day we will have a project as well. So there are two projects in this course and to get the certification from simply learn you have to complete any one of the project. So we are going to discuss the project on the very last class. Okay. Not today. Any confusion till here? So this is the course objective. So it is business intelligence. Absolutely correct. if you heard the if you have uh already given me the full form of it, can you tell me my next question is what is business intelligence? What do you understand by business intelligence? A simple word or definition will do. What do you understand by that? Anything that comes to your mind. Exactly. Okay. Great. Rashma. So taking decisions from data. Publish the report based on the needs of the business. Analysis business data set to analyzing business data set to make informed decisions. Great. Benjam Benjamin. The Nasha have mentioned something. Give me a moment. Okay. interpreting a data set into a most useful way. Okay. Shanker, analyzing the data and presenting in a visual format. Okay. And Francis analyze the data. Okay. Now all of you have given correct. Okay. But the correct answer would be datadriven decision. Business intelligence means datadriven decision. Okay. A decision which is backed by the data. a decision that is backed by the data. Okay. Now what do I mean by that? Let's go for a simple example. Okay. Suppose I am about so we do this datadriven decisions every day. Let me take an example. Okay. Let us do an activity. I'm going to purchase a phone. Right? So I I have decided I need to purchase a phone. And for that the first and foremost things I will set up my requirements right. I will set up my requirements. Okay. So what are the requirements? What are the requirements might be that I need a good camera. Okay. The picture should come out good. I need a good camera. Or maybe I may also be interested in the RAM. Right. What else? What else for the mobile phone? What what have to go for? Maybe the Yes. Memory storage. We'll go for the memory as well. Yeah. Durability. Brand as well. That's correct. Processor. Processor. Lots of thing we are going to look into that. Okay. So brand as well correct now when we go for purchasing a mobile phone or a laptop right what we have to do okay what we we do as a normal human being okay we also do it we are also backed by data so please check it out here in real world if we want to go for purchasing we first set the requirements after that please check it out we have to we go for maybe I'm going for a diagram here. Okay. We go for different websites. We go for different websites. Suppose okay we go for different websites and check the reviews right and check the reviews in different online websites. How how is the product we are going for that also we take into we also go for YouTube reviews do you agree we go for the videos okay whether any reviews are available for the phone or not okay we'll go for YouTube videos to check if there is any feedbacks any reviews about the um you know phone after that you also take into consideration give me a moment You also take into consider consideration the previous phone experience. Previous phone experience. Okay, I'm writing in short. You also may be taking into consideration the opinions of your fam friends and families. So we go we are now just trying to get the reviews we are trying to get the reviews from this part. So these are the different data sources. Okay. So these are all what what are we trying to do? What we are trying to do we are going for gathering the data. Do you agree? Data gathering or data collection. Now once I have got this data, I have collected this data from different data sources. I'm going to combine the data. I am going to combine the data. Right? So as I have got from different data sources, I'm going to combine all this data together. data combined and then I'll go for cleaning the data I'll go for cleaning the data right because all the information they have given we have taken the reviews from the video you YouTube videos we have taken the reviews from Amazon users we have t we have taken into experience the opinions of our friends and families so we are going to combine all this data and then we are going to clean the data whichever based upon the requirements we have we are going to clean those information and once we clean the information we are going to store the data somewhere that is our brain if I go for this we are going to once we have got the all the information right we have gathered it we have combined it and cleaned it we are going to store it. So in this case uh our brain do you agree? Do you agree? Are you getting the things? Okay. Now once you have collected all the data just give me a moment. I'll just insert the shape here. Okay. I'm adding this. After this what we are going to do once we have the storage now we are going to do the analysis now we are going to do the analysis what analysis okay we are going to check okay the after gathering all the information after removing all the needs we are going to check whether it is going to fit our budget or not if I buy this mobile phone okay I suggested whether it is going to fit my budget how much uh years of will it work that is the durability ility. Okay. And uh all this analysis once you do once you all the analysis you do you are going to finally take the decision. You are going to finally take the decision. Okay. Just give me a moment. So from your storage you on the on your brain only you are doing the analysis and finally you are coming up to coming to a decision here coming to a decision. Now this your data the phone you are going to purchase the decision you have taken right is basically backed by your data it's basically backed by your data. Same thing is done in case of your uh business as well. Same case is done in case of your business as well. Okay. So please check here one thing if I go for it in this case if you think in terms of your PowerBI or the BI tools right just I'm going to reduce the size a little bit so that we can accommodate it okay here you can think that the data we are talking about maybe some files okay Excel files or CSV files okay it's coming from the Excel files or CSV files now in In this case, if I talk about the YouTube videos, you can just simply think of it. The data is coming from maybe some SQL server from some SQL server database. Let me just make it more smaller. Okay, it is coming from some SQL server. Now the previous phone experience, let me take into consideration some web APIs, web applications. You are getting it from some web applications. Just give me a moment. Okay, web applications. And this one families and friends, you can think of it from another data source. You can think of it from another data source that is uh your AWS because datas are nowadays stored in the cloud right AWS, Azure or maybe your you know one drive. So all these things are what different data collection methods are there. Now you are going to collect that you are going to combine that collected combined and you are going to okay let me not go for this one here. I'll take it from here. Just give me a moment. So, we are going to go for this part. Data collection, uh, data cleaning and data storage, right? Data storage. Okay. This entire part is known as your ETL. This entire part This box you can see right this portion known as ETL. So ETL this is where your data engineers work. This is the area where your data engineers work. Right? Now if I talk about we as analyst where do we work? We as analyst where do we work? We are going to work on this area. That is we are going to connect to the data storage. We are going to connect to the data storage and then we are going to analyze it. Analyze it in the forms of some charts or tables. We are going to analyze it in the forms of some charts and tables. So we are doing the analysis here. Okay. Now over here just This is the area just this is the portion this is the portion where your where your business analyst will work. That is once you the data analyst has generated some insights from the data. The data analyst has generated some insights from the data. The business analyst what he will do? He will come up with some solution. He will come up with some solution. What is wrong and what can be improved? He will come get some suggestions here. He will come up with maybe three four suggestions. Now ultimately the decisions will be taken by the leadership team. So the decisions will be taken by the leadership team. That means your directors okay directors CEOs etc. The executive peoples are going to take the decisions okay out of the suggestions uh given by the business analyst okay which suggestions to follow okay and the same process will repeat again the same process will repeat again okay so what happens is that if I talk about both the data analyst if I talk about your business analyst I talk about your data engineer right let me write here this is where the ETL process. Right? Here the data engineers will be working. Data engineers, right? Data engineers. And here we are this uh business data analyst will be working on that is your storage and the analysis. Data analyst all of them are working on the past data. If I talk about the business analyst, data analyst and your uh you know data engineers are going to work on the past data. Okay. Suppose when they are going to work on the past data. Suppose if I talk about the company wants to know the company wants to improve the business sales for this year. The company wants to improve the sales for this year. So for improving the sales for the current year they have to check out. Okay. they have to analyze what went wrong in the previous year. Okay, what went wrong for the for the previous uh for the previous years. So they are going to analyze the previous data and then they are coming up with the decision that what went wrong. Okay. And what can be improved. Okay. So this data analyst team like we as a data analyst we are going to analyze the data and generate some insights from it. And the business analyst what they are going to do based upon the analysis done by the data analyst they are coming up they will be showing some giving some suggestions what can be improved. Okay. And then the decisions will be depending upon the leadership team. So we are working on the past data. We are working on the past data what has happened. Right? So that is what it is known as your descriptive analytics. making sense. Are you able to understand a little bit? Check it out if you have any confusion. Pace is okay. Are you able to understand till this example? Because this is how your business what business intelligence means refers to datadriven decisions. Okay. Now no one asked me that question. Okay. So here I have discussed about your data engineers, data analyst, business analyst. But where does B uh data scientist work? Where does data scientist work? Okay. So the data scientist So the data scientist they work on a different route. They don't work with the past data. Okay. So please check here. The data scientist will take a different route from the storage. They are going to apply in the storage. Okay. They are going to apply some MLDDL models. They are going to apply some machine learning models or you can go for statistical models also and they are doing they are trying to predict the future. Okay, they are trying to predict the future. So they are going to apply the MLTL models. So this is the portion where your data scientists work. What is descriptive analytics? Descriptive analytics means working on the past data. What has happened? If you want to improve the business, okay? If you want to improve the business of the current year, you have to first understand what has happened in the previous years, right? You are going to study like what has happened in the previous year. like okay what went wrong in the previous year. So you are going to do the analysis of the past data. You are going to collect all suppose the past five years data and you are going to do the analysis. So that is known as descriptive analytics what has happened in the past because if you realize that what went wrong in the past then only you will be able to correct the current years as well. Are you getting it now Francis? Descriptive analytics to clarify working on the past data means descriptive analysis. Yes, because we want to descriptive analytics means to understand. So why are we going to the theory? Okay, I do understand you might have think like she will be going for hands-on but the thing is that before we go for the you know hands-on it is important for us to understand few concepts so that is why I'm just taking it the theory a bit don't worry we'll do the hands-on as well okay now please check it out here as I mentioned what is business intelligence You can see here make intelligent business decisions. How? By the driven by the data, right? Driven by the data. So what is business intelligence? Capability to make intelligent business decisions, right? It makes information discovery simple. Okay, simple. And also helps you in the analysis of the data. Right? Whatever I have explained right now. Now this one enables you to send the right information to the right people. This one basically it's talking about the security. Okay, it is talking about the security. That's what happens when we talk about this BI tools or like uh the PowerBI as well. If we want to like we can apply security to the reports as well. So that even if we create one report, even if we create one report and there where there are multiple charts, not everyone in the organization are able to view the all the details on only which is meant for you. We will be able to look into that part. So that is means sending the right information to the right people. So we can we are also going to discuss this in detail in the upcoming sessions and provides data insights to everyone. Okay, from any type, size and source of data. Okay, so this is your business intelligence. Now let's go for So you can see here PowerBI is a selfservice self-service cloud-based BI tool. Now I told you for PowerBI we have different applications. We have the desktop application PowerBI desktop application for doing the analysis. All the analysis creation of the visuals you are going to do in the PowerBI desktop also once you are done with it you are going to publish it it on its own cloud. So that is why give me a moment service. So this is known as your Microsoft fabric. Let me write it out. Microsoft fabric for publishing the report for publishing the report. So that is why it is known as a since it has its own cloud right so it is known as a self-service cloud-based BI tool also it is user simple and userfriendly. So we are going to get introduced to the interface today and you will be noticing I'm sure that most of us have used the up Microsoft office right and PowerBI is a Microsoft product so the interface is quite familiar and everything there is basically uh instead of drag and drop I would say expand and collapse okay it's pretty much user friendly and it produces highly interactive and beautiful graphs so lots of graphs are there we can go for creating it. We are going we are going to explore that as Okay. Why PowerBI? So we have other tools in the market as well. But why do we go for PowerBI? So if you talk about the competitors in the market, we have Tableau. We have the QIC. Okay. But PowerBI. So as I mentioned it is the easiest one. Okay. You can obviously perform. So in the thing is that the PowerBI comes with power query editor. Okay. Power query editor which is used for which is used for which is used for cleaning the data. So if you wish to go for pre-processing right you can go for the uh power query editor. You can go for also combining the data in the power query editor and also so the way it supports natural language uh natural query language. Now the thing is that we are communicating in English right? Similarly we can direct we don't have to write complex queries in PowerBI it's it is much similar to your English language. Okay. Uh and also you can see it allows you to fetch data from 60 different data sources. Now it is no more 60. It is 150 plus data sources. Okay. You name it and you are you will be able to connect to that data source. You can also connect to the live data. So any live data from the website you will be able to connect to and you will be able to do the analysis. Okay. And since it is a Microsoft product updates are happening quite frequently. So the I think the PowerBI right launch is uh new the PowerBI has been upgraded today itself on 14 to 2026. Okay. And it offers a very simple learning curve. So I don't know that if anyone of you are from the Tableau background you might feel that PowerBI is super easy okay compared to Tableau as well and you know the PowerBI desktop is absolutely free PowerBI desktop is absolutely free and you can connect to 150 plus data sources okay and you don't have to pay anything but if you are familiar with the other tool like your Tableau in that what happens if you're working with the Tableau public. So you only are able for using the free version, you will be only able to connect to three data sources. But that's that's not the case with your PowerBI. Now let's talk about the architecture. Okay. Now these are the products offerings of your PowerBI desktop. Okay, sorry PowerBI. So you have the PowerBI desktop. So I'm just repeatedly mentioning starting the class that PowerBI desktop is basically used for doing the analysis. It's absolutely free. So we are going to download it or install it today. Okay. Now I think Manisha you asked me considered sorry you asked me the question regarding the mobile application. The thing is that okay what happens uh in PowerBI mobile once we are going to once we have created the analysis right once we have done the analysis and we have published it in the Microsoft fabric. Okay. If my managers or my my supervisors or my peers want to check the report, they are just going to check the report what is happening in the business. Okay, they don't have to get the app. They don't have to install anything. They can also get the mobile application and they can check the reports. They can open the uh mobile app and they will be able to get it the reports that you have created or shared in the mobile in their mobile app. So that is your mobile service. And the last one, we have others products as well, but here the last one we have your PowerBI embedded. Here we have PowerBI embedded. Now at the as the name suggest right embedded means integrated. So what is happening here? What is happening here? Okay, most of the organization they have their own cloud. They have their own organization website. Okay, they have their own cloud cloud. So they don't want to go for publishing it in the PowerBI service. Now let me tell you PowerBI service is not free. They have to pay some amount. So instead of doing that they are going to publish it on their own website. Instead of publishing the reports into the uh you know PowerBI Microsoft fabric they are going to publish it in their own cloud. Okay. So that is they have for that they have to purchase the embedded PowerBI embedded they will be getting all the interactivity flexibility like the their own like the Microsoft fabric only but they are able to do it in their own organization that is PowerBI embedded. So PowerBI embedded is also not free. You pay as you go. How much you require for that only you are paying it. It it follows a pay as you go model. No no this is not restricted to management or authority. See whenever we go for publishing anything okay we are going for publishing anything. So we have the security there. Okay. If we have the security there because we we are not allowed to share it in public. We are not allowed to share it in public. We have to share the email ids. Okay. Then only they will be getting it. Okay. to it's like it's not only the management or the authority whoever have it whoever in the organization means you are sharing it for them you can go for this Microsoft uh sorry PowerBI mobile service now any confusion in this part in the embedded or yes if they don't want to go for the Microsoft fabric they will be going for the embedded if they have their own cloud Okay, if they have their own cloud depends upon the organization totally fabric is not free. Nothing is public. Okay, nothing is public. You have to make it public. So that also PowerBI gives you a warning that you whether you want to make it public, you have to create an account. Fabric is not free. You have to create an account then only you will be able to publish. For desktop it is free. Okay. Microsoft fabric is basically your cloud service of your PowerBI. Okay. Microsoft fabric is its own cloud of PowerBI which we are going to work on it on the last day. Okay. It's a its own is a cloud version cloud version of PowerBI where you are going to publish the reports but in the embedded okay if the embedded version if the organization if the organization okay does not want to publish in the Microsoft fabric they have their own organization account okay cloud okay own organization cloud out they are going to use the embedded. Now check they have mentioned that this is the PowerBI desktop architecture but this is a PowerBI architecture. Okay, not only the desktop architecture, it is the PowerBI architecture. So please check here. I'm cancelling this part. Okay, this is a PowerBI architecture. So what is happening? Okay, our desktop systems, right, the PowerBI desktops are able to connect to multiple different data sources, right? Salesforce, SQL, Oracle, hundreds of different data sources they are able to connect. Okay, they are also able to connect to the data stored in the PowerBI service. Okay, once they have done, okay, we are going to once uh once we have connected to the different data sources, we can also go for let me use a different arrow here so that it becomes clear. So we are going to just work on this. Okay, we are going to work on this suppose here we are connect to we are we will be able to connect to multiple different data sources and then we are going to publish it in the service right and once we have published it people will be able to access the reports we have shared in the service through their mobile phones or through their desktop okay through their desktop now the thing is that what happens is that in our case the organization's data since we are working in the PowerBI desktop. Okay. The organ once we have published it. Suppose any file is there in the local system. Any file you are working on the Excel file. The Excel file was present in your desktop. The Excel file was present in your desktop and you have published it. Once you have done the analysis, you have published it. But after few days, you realize that new data got uh added to the Excel file. you have added new data to the Excel file. Okay, in that case in that case what happens is that the only way you can go for the manual way of doing that you you don't you have to refresh the data in the PowerBI desktop so that it is reflecting the new data in the analysis and then you are going to publish it uh publish the report in the uh service again. Okay. Or if you wish to automate it, if you wish to automate it in the sense that if the file is present in your desktop, okay, and new data gets added, it should automatically reflect in the service as well. It should automatically reflect in the service as well. For that you need this gateway. You need this gateway. Okay, using the gateway what will the service will do? They will be securely connected. So you are basically it's a gateway in the sense you can think it of a door. It's a door securely from the service it will service it will be connecting to the data stored in your system where wherever the data is present that excel file is present in your folder it will be connecting to that folder and then it will be refreshing the powerbi service it will be automatic if new data gets added to the excel file right or the CSV file any offline file the changes will be reflected in the service as automatically with the help of gateway with the help of gateway. So every time your report right is showing the latest details not the PowerBI desktop I mean your uh your desktop machines or all your your laptops some drive local D drive okay in your D drive. Now the gateway what it will do is that using the gateway suppose at some point of time suppose your whichever the data whichever the excel file you were using for analyzing the you have analyzed and you have created a report and you have already published it. Okay. After some days you have added new data to that same file. Right? Same file. Okay. You have added new data. Now what will this gate will do? Right? Whenever there is a updation in the data in the local file present in your local drive right it will with the help of the connect with the help of the gateway it will connect to your desktop machine's drive and then it will be automatically updating it. So what the gateway will do gateway will provide a secure path to connect to only they will give you the access to connect to only that particular file and just refresh it. Okay, it will not allow you to uh give the access to all the files present in your desktop or present in your laptop only to that particular file which is present in particular drive. You are have to you have to set the gateway for that. Are you getting my point? Now it will securely connect to that particular file present in your local D drive only to that file and when there is a like new data added there it will be refreshed. So automatically it will be reflect in the service as well. So you don't have there is no manual intervention. Yesuling the foruling automatic refresh we need gateway. Yes, then it will not work. What if the file is moved to a different location within the then it will not work. Okay, because we have given to the permission to work on that f file only. We have to set up the refreshes. Yes, of course. If you change the location of the file, then it will not be able to refresh it. Okay? We will not go for much anything. So we are going to go for the install and there we are going to unh understood the desktop components. How many now let me ask you how many of you have already let it be Manisha we are going to discuss that in the last session as well. So I'm going to do that. Okay let's work on the hands-on part. Okay, those who don't have it, please. So, those who don't have it, please go click on this website and go for downloading it. Go for downloading it. Let me check the responses given by you. Okay, so you have shared your responses right in the feedback. So I can see that 15 of you have responded and out of which I can see like uh 73.3% right I can see 11 people have no experience now I can see more people but at that time I believe 11 people said that they have no experience with the PowerBI and most of you are the beginners right and let me check for the IT background or some primary goal of accuring this getting certified Okay. Yes, we'll go for the hands on. Okay. So, my pace will be slow. So, at any point of time that you feel that I'm going fast, let me know in the chat. Okay. So, those who don't have it, I would request you all do one thing. Please go to this link and go for downloading it. Just download it. And by that time I would request everyone since we have looked into the file as well. Okay. But I also want you people to get to know each other. So can you please introduce yourself in the chat uh and also mention the years of experience you have and whether uh you have any knowledge in PowerBI or not because I can see more people have joined the uh class after that feedback session. Yes, I would request everyone let it get downloaded and by that time I would want you to introduce yourselves especially those who have it can go for that introduction. Hi Ankit. Finance 13 years new to PBI. Okay. Shida 24 years. Great. Experience at BA. Okay. Great. Akash Kumar. Okay. Uh hi Anand head an IT larger farmer. Great. 23 experience years. Okay. It you are aware of it. Okay. Hello Deepa. I have around uh 13 years of IT experience and no experience in PowerBI. Okay. Then Akash has mentioned fresher. Okay. Shri Vidya. So have worked on SSRS and have been end user of PowerBI but never worked on creating one. Okay. Hi Ryan. 10 years of experience in knowledge management, digital content management. I have minimal experience with using PowerBI for purely data analysis but not hands-on with creating dashboards, reports. Okay. Then we have Princes project management 10 years no experience in PowerBI. Okay. Jakumar. Uh hi J. So working in shipping operation 15 years experience and PowerBI experience. Okay great. So Steve 19 years of experience in operation currently managing a team of 65 including a BA team. Great. Intermediate experience of PowerBI. Okay. Then let's go for Hi Magna. Four years of experience in IT and consulting but new to PowerBI. Okay. Okay. Uh Gaza Bandana. So, hi, I have 2.6 years of experience as data analyst and I've enrolled the session to learn advanced PowerBI. I currently switched my organization. Okay. Hi Asha. 13 years of experience in finance, no experience in PowerBI. I have uh BI. Okay. I have used only smart view SAP sack. Okay. Great. 15 years experience in enterprise application. No experience in PowerBI. Okay. Alone. Okay. Hi Samson. Okay. 15 years experience. But not PowerBI. Okay. Okay. 5 years 10 months experience project and client. Okay. PowerBI. No, not yet. Okay. Okay. 12 years experience in finance. Basic understanding of PowerBI but never worked on it. Okay. Dri. Okay. Hi everyone. 14 years experience with project management, delivery, governance and operation. Manisha. So I have I worked with the diplomatic mission as a case analyst. Now I'm required to work on PowerBI. management. So with about 12 years of experience in finance, accounting and business management, self-learn PowerBI. Great sometime back. I need little more insight. Okay, great. Okay, thank you everyone. So I think I think with that you are also able to know your batch even. Okay, so Asha, are you able to install it right now? So you have to just click on this and installation is truly simple. Once you go for this, you will be uh getting it in your uh no downloads and you have to just click click click and next. And one more thing, the PowerBI is a Microsoft product, right? It's specially designed only for your uh Windows system. If you are using Mac, then you have to go for virtual machine. There you have to install the Windows and then go for the Now, please check here when you first time open the interface, right? So you are get you will be getting some uh PowerBI starting starting videos as well. Okay. But once you cross that you will be getting the same interface as me. So you can see multiple different data sources here. But we are not going to import the data from here. Okay. We are not going to uh import the data from here. Rather you have to just for now click on blank report. You have to click on blank report. This is the interface you are getting where there are five views. For me it is five views. I have uh installed quite a few times like quite a few months ago. So check tell me are you also getting the five views here? Okay. So this is your PowerBI desktop. This is your PowerBI desktop interface. Okay. Now please check here initially initially okay till last year okay till last year January I believe we have only this three views okay we had only these three views okay and if there were a common interview questions also what are the views in your PowerBI so these are the three views we were have we were having okay so one is your report view the first one is known known as the report view. Report view. Then you have the table view. We are just getting introduced to it. Then this was the model view. Okay. Then last year, early last year, we got introduced to this DAX query view DAX query view and probably in the month of July last year we got this TMDL view as well. So TMDL view it stands for the full form is tabular model definition language. Okay. Table model definition language. This is the TMDL view. Okay. Let me just cross that here. Give me a moment. Let me write it here again. Tabular model Okay. But for your PL300 exam, right? For your PL300 exam, you will be getting these two views will not be there. You will be getting questions from this view also only. You will be getting questions from these three views only. That is the report view, table view and the model view. Okay. You can also notice so this is about the views. Okay. This is about the views. I will be also showing you how the views look. The current view you are getting right. The current view you are getting. So here you are having this white where you go for creating your visualization. This view is known as the report view. The current view we are currently in is known as your report view where we go for creating the report. Where we go for creating the report right on your right hand side you will be able to see the pes here. Three pes will be there. One is your data pan. One is your data pan collapse that you have the visualization pan you have the filter pen as well. So as I mentioned PowerBI is more or less like a expand and collapse. So you will be able to collapse it. Are you all having these three pens filter visualization and data? Kindly confirm in the new version as well. Do you have these three pens? Now please check how can we load the data. Okay. How can we load the data? So I'm sharing the data set. If someone has not downloaded it, I'm sharing the data set here as well. Just give me a moment. If you have not downloaded the data set, I'm sharing in the chat box. Okay. You can download it from the chat box as Yeah, you can download it. So to get to load the data, right? To get the data to load the data you have to load it from here. You have to load it from here. You can check it out here. Get data. First download it. First download it. See we are there are very less people in the batch today. Okay. So feel free to ask. Okay. If you have any confusion, please write write it down in the chat immediately. I can take that up. Shall we proceed? See, since I have shared an Excel file, you can directly do from the Excel workbook even. But I want to show you the different sources. We are getting introduced to the interface, right? So, I want you to click on this get data. Okay? Once you click the on the get data, you will be able to notice the just you will be able to notice the common data sources. You will be able to get the common data sources. Right? So what I want you people to do instead of selecting it from here just go for more option. we will be able to see the different options present in your PowerBI that we can connect to the different data sources that in present in PowerBI that we can connect to. So please click on So here once you click on more right once you click on more you will be able to see what are the different data sources that you can connect to you can connect to excel workbook text CSV file XML files JSON files folders P PDF files work files SharePoint folder so all the different sources you will be able to connect to check it So there are more than 150 plus data sources. There are more than 150 plus data sources that you can connect to. Okay. Now the all thing we have to do right now because ours is a simple Excel file, right? Ours is a simple Excel file. We are going to connect to this Excel workbook. We are going to connect to this Excel workbook. Please click on Select the Excel workbook and go for connect. Go for connect. Then you have to browse to the file. browse to the data uh set. Okay. Where it is present. So for me it is this one. You will be getting the navigator pen. Please let me know once you reach till this point you are getting the navigator window. All right. Now check if you you are getting there in the workbook, right? I have three files are there. Three sheets are there. One of the sheet is orders, other is people and returns. If I check this box, you will be able to get the preview of this data. You will be able to see the preview of the data on your right. See, this is the preview of the data. Right now the thing is you can also go for people table. This is your people table and this is your return table. Okay. I for now I don't want to load all the data. Okay. I don't want to load all the data. What I'm going to do I'm going to just uncheck the people and the return and I'm going to load only the orders table. Okay. Also notice one thing here you have three option. One is your load, other one is your transform data, another one is your cancel. Cancel will just cancel the loading process. Cancel will just lo cancel the loading process. So we don't want that. We want to load the data. Okay. Now we are going to we are not going to transform the data because if I go for the transform data right now, what happens? it will be taking me to the Power Query editor instead of PowerBI. Okay, but I want to scale to the like I want to work with the PowerBI right now and then I will be showing you how to work with the Power Query editor. Okay, so I would request everyone to click on the load. So if you click on the load, it will take you to your PowerBI. If you click on the load, it will take you to the PowerBI. Please click on the load please. Only the orders data. Okay. Only the orders data. What you need to do Francis? What did I do? I have to go to this get data option. Right. Go to this get data. Then you have you can directly go from here as well. Excel workbook. Okay. Then go for sample supertore. Click on open. You will be getting the navigator. You will be getting the navigator clear. Then you have to choose the orders data. Then you have to choose the orders data and click on load. Since I have already loaded, I will be going for cancelling it. I'm getting the tables but I'm not getting the fields. Where are the fields? For getting the fields you have to expand that you can see an expand option right just give me a moment here you are getting the expand option so please click on the expand once you click on the expand you are getting the field in the arranged in ascending order you are getting the fields not in the exact order how it is present in the table But it is present in ascending order. So you have the category CTC first alphabet C is coming then D is coming O P and so on. So in the data pan datas are uh coming in the in sorted in ascending order. The fields are uh depicted in sorted in ascending order. Then how do I see the actual uh you know sequence of the fields? How do I get the actual sequence? Okay. Now the thing is that before we go for any visualization any analysis we have to make sure that our data is cleaned. Right? Our data is cleaned. For that we have to use the for pre-processing part right for pre-processing the data prep-processing is not done in your PowerBI uh report view or the in the PowerBI interface we for that we have to go to the power query editor okay how do I go to the power query editor see at that time we have loaded the data right we can from here as well from the desktop also we can Go to the power query editor. You are having the option for transform tab. You are having the option for transform tab here. Okay. So click on the transform tab and there you have the first option as the transform data. Here you have the first option as the transform data. So click on this. So this is the interface for your power query editor. If you have worked with Excel, right, normal Excel in Excel also we have the power query editor. It is the same interface we have for here as The Power Query editor comes free with your PowerBI and Microsoft Excel. Are you all in the park ready editor? Okay. Now the first and foremost thing what I'm going to check. Okay. What I'm going to check what is the total number of rows. Okay. what is the total number of rows? So what I'm going to do for that again in the power query editor also there you have the transform tab. In the power query editor you have the transform tab. Click on this transform tab. Okay, there just give me a moment. You will be getting the option for count rows. rows. Please click on that and let me know what is the total number of rows and columns. Sorry. Or what is the total number of rows columns? Yes, exactly. Okay. Now see I'm clicking on this total number of count I'm getting the count. So sorry I will not be able to increase the size of the power query editor. So this is the default size. Okay. But the thing is the total number of rows in this data set is 9,994. But the thing is how do I get my data back? My data is gone and I don't have an undo option. Do I have an undo option? You can see the table I had right it has been transformed to a number right now. So once you do any step here right in power query editor we don't have the option to undo for that you have in the applied steps here you will be getting the applied step you have to cancel the step from here then only you will be getting it back. You have to cancel the step from here. Apply steps. Okay. There is no option of undo. There is no option of undo in your power query editor. So for that you have to go for cancelling the steps. Once you click on that you can see you are getting your table back. Yes. Now let's check first. Can you show that again? Okay. So suppose if you apply any step. Okay. First I'm applying the step of counting the rows. Let me go for counting the rows. Once I go for counting the rows, check my uh this one marker. Okay. You can see the in the applied steps. So you can see the counted rows right. So just go for cancelelling it. You will be getting your tables back now. Clear. No cancelling. Samir, it's not cancelling for you. Can you give me a screenshot? Yes, if you close the account, it will get back. See what did I do? I go to this count rows right here. I have to click on this cancel. I have to click on this cancel and then it will be gone. Shall I proceed? Now, please check here. Okay. Now, please check here. You can notice we have to first understand the type of data present in your or data type present in your power query editor. Okay. So if you check here, if you check here 1 2 3, if you check on the ordered ID, you have ABC. You have ABC. Similarly, you can see a calendar like icon. These are nothing but the type of data. Now what are the type of data are there? Okay, if you wish to check it out, you have to click on suppose this 1 2 3. You have to click on this 1 2 3 and you will be able to see what are the data type here. So the first and foremost thing when we go for data cleaning the first and foremost thing when we go for data cleaning we have to check whether the rows are or the columns are marked correctly or not whether the data types of the columns are correct or not. Okay. So if you check here and PowerBI is an intelligent tool. PowerBI is an intelligent tool. It is able to uh it is able to detect the data type on its own. Okay, most depending upon the values you have right it is able to detect the data type on its own. We don't have to worry on that. Okay, but still if it is not able to do that you are going to do it ourself. Okay, for example. Okay, let's go to the scroll scroll scroll and go to the suppose your uh this one sales column. Go to the scroll and go to the sales column please. Are you all able to get the sales column? Okay. Now check here. What does this 1.2 mean? Okay, it refers to decimal number. It refers to decimal number. 1.2 refers to decimal number. Okay, but there is another decimal here. Fixed decimal number. What is the difference between the two? Okay, please check here for the sales column. For the sales column, we have after the decimal point for the first case 261.96. But somewhere you are also having 907.152 right somewhere it is after decimal point we have two digits somewhere after decimal point we have three digits and somewhere it is one one digit okay so it is not uniform so if you go for fixed decimal number instead of decimal number go for fixed decimal number and we'll go for replace the current You will notice that everywhere after the decimal point the digits are fixed to two digits. It is no now more uniform agree this is your fixed decimal digit. Okay. Now similarly let's take for the other columns also. Okay, this is quantity 1 2 3. It is correct. It is whole number. Okay, let's go for the discount. Uh discount is also done correctly only. Okay, what about the profit? Again same thing. Again same thing somewhere it is four digit somewhere three digit somewhere again uh two digit. Okay. So for profit as well I'm going to make it as fixed decimal number. Okay, for profit as well we are going to make it as fixed decimal number we have to go for writing an M query here. Okay, if we want to go for uh Samsung, are you not able to get it? Give me a moment Steve. I will answer your question. Don't worry. Check it out Samsung are you not getting this option? Not able to see the option fixed decimal number. Okay. If you click on this, what is the second option you have? What is the second option you have? Is it remove? We have to do the same for discount. Discount is not required because one digit is only there. Let me take up one of your screen. Okay, let me I think it has been changed then. It has been modified then. Can you please share your screen? Anyone of you? Let me check it out. Might be it has updated right today itself. Let's go for that. Can anyone please share your screen? Okay, Samsung is sharing. Let me check it out. Can you go to that power query editor? Give me a moment. Not here. Not here. Go for 1.2. Go for 1.2. Where the before? Yes. Click on this. Wait. Yeah, you have the fixed decimal. Second option. Second option. Yes. Click on this. Yes. Click current. Replace current. Yeah, you're getting it. Should I unmute you? Yeah, you can unmute yourself. Are you getting now? Yeah. Any confusion? Uh no, not fine. Yeah. Shida, quickly share your screen. It is there. Fixed decimal is there. Please share your screen. Okay. Guys, please clearly have shared. No, no, no. This is not the right place to click, right? You have clicked on the wrong region. Please click on 1.2 where the 1.2 is appearing. Yes. See? Okay. No, no, no. Not, not the correct one, not the column again. Please uncheck it. Okay. Go to the unselect the column. Please uncheck the column. Select some 120 suppose quantity. Yes. Okay. Go for selecting only one two. One, two is there, right? One, two. Yes. No, no, no, no, no, no, no, no, no, no, no. Do not select the entire column. Just click on 1.2 again. Uncheck. Unselect it. No, your selection is only incorrect. Your selection is incorrect. Okay, I'll show you again. Just give me a moment. Let me unshare your screen. Okay everyone please check here how to select it. Okay, let me show you here this one right only this option you are going to select only this option okay keep your cursor and just not right click just left click simple left click simple left click if I go for right click I will be getting this I'm going for left click I'm going for simple click no left click also only click if I Go for right click. I will be getting this. Just click on this guy. Got it. Don't go for right clicking it. Did you get it? And similarly shidya both of you please kindly confirm in the chat. Okay see whatever we are doing here guys I'm waiting for your confirmation okay just go for clicking this part don't don't go for right click okay whatever the things are we are doing here whatever the changes we are doing here I am just doing with a simple click right but in the back end you will be able to see that codes are generated for you. The codes are generated for you. Right? Codes are generated for you. Suppose if I wish to go for right click, sorry, not right click. Give me a moment. I'm going for suppose fixed decimal number and I want to add a new step. Okay, a step has been added here. Okay, a step has been added here. Okay. Now I'm also going for right now fixml. So this is changed to step. So you can see here whatever I'm doing I'm just clicking it. I'm clicking and doing it. But in the back end your codes are generated. You can see on the top it's highlighted. So that language you know power query editor it's written in mquery language that is known as your mquery we can just go for click click click click click but in the back end codes are generated it is similar to macros in your excel like we go for clicking right but in the uh excel right what happens the VBA codes are generated for you VBA codes are generated similarly in power query editor the mquery language is working. So here in the back end even though we go for click click click click click here we are getting the codes. So you will be able to see the codes using this advanced editor option as well. If you click on the advanced editor you will be able to see the codes. See what are the codes that has been generated. What are the codes that has been generated so far? What did I do? I went for change data type see integer order date order id all those things then transform change type sales type number right similarly this these are all the steps in the back ends these are all the step in the back end getting it this is your mquery language Question, if the data is transformed in PowerBI, will it change the original data source? Very good question. Okay, so the thing is that if I do any changes in the Power Query editor, nothing will happen to your original data source. Why? Because PowerBI always works on the copy of the data, not on the actual data. PowerBI works on the copy of the data not on the actual data. Clear? But if any changes you are going to do in the original data file okay and uh okay if you're doing any changes in the original data file and then suppose if you're working on the power query editor if you refresh it that changes will be reflected here but any changes you do in the power query editor will not be reflected in the original data source. Yes, you can modify if you are aware of the MQuery language, you can modify this language. Sorry, you can modify the code as well, right? And people does that like we have the visual basic developer. We have the mquery developer also who goes to modify this language. We don't require it because we are going to learn it from the analyst point of view. If we don't know how will you work on it, right? You have to learn. So this MQuery is a separate course in itself. Mquuy is a separate course in itself, Okay. Shall we proceed then? We are just as an analyst we are going to use it maybe how to create a column and all those things very less mquery. All right. Now please check it out. not formulas used in Excel. You can say it as the visual basic the coding language VBA coding is similar to Excel. MQuery is not similar to the formulas. Okay? Please don't think in that way. It is similar to the VBA codes. Whatever click click you do, it gets transformed into the code. It's not the formulas. Formulas we apply it. Okay. Now simple things few simple things here please check it out here you are able to notice column profiling based on so top uh thousand rows are you able to view column profiling on top thousand rows yes formulas in Excel equal Dex. Okay. Now the thing is that if you go to the view tab, if you go to this view tab, right? If you go to this view tab, you will be a you have to go to the view tab. In the view tab, in the view tab you have suppose the column quality column distribution. Let's go for the column distribution. Check this box please. Check the box please. Column distribution. column distribution. So column distribution you are getting on the thousand rows only. Column distribution you are getting on the top 1,000 rows only. Okay. You are not getting on the 9,994. Okay. Out of that column profile you are getting that out of that thousand rows you have here in this case for row ID all are unique. But in case of order ID four 479 are distinct and 226 are unique value. But we know that this analysis is wrong because incorrect in the sense we have 9,994 data. But it is showing me only top 1,000. So what you can do here please everyone notice here focus right now click on the column profiling and go for profile column profiling based on entire data set column profiling based on entire data set. Choose the second option then you will be getting the correct one. Got it? Column profiling on entire data set. Entire data set. Are you able to get it? No. Where is the column profiling? Check my arrows. Please check the arrows. Column profiling based on entire data set I'm having right now. You have thousand data. Column profile. Check the check on my screen. Focus on my screen please. Column profiling based on top thousand rows. So I'm going to change it to column profiling based on the entire data set. See check the difference this one and profiling means you are doing the analysis. Profiling means you are doing the analysis. Initially the analysis was done only on the top thousand rows. That was incorrect. Right? That was incorrect here. That's why we went for instead of doing the analysis on the top thousand rows, I want to do it on the entire data set. I want to do it on the entire data set. How this helps? How this helps? So, please check out here in this data set. Okay, let me go to the let me go to the uh column. Maybe let's go for the column city. Okay, you can see the city column here. So out of the city column, you can check here there are 9,994 uh rows are there. Right? Out of that 531 are distinct. 70 cities are unique. Now what is the difference between the unique and the distinct? What is the difference between the Can anyone tell me? I did click on the column distribution, right? I did click on the column distribution under the view tab. So that's how I got it from the view tab. Unix is the same city. Distincts are of different cities. No. Yes. Unique cannot be replicated. Okay. Now let me give you a small example here. What is the difference here? Okay. Suppose I have some values. Okay. Suppose I have some values. Okay. Now if I ask you how many distinct values are there? How many distinct values are there? One suppose this is 12 13 12 13 14 15 four right. Four distinct values. How many unique How many unique values are there that are not repeated? We have only two that is your 13 and 14. Understood. Difference between distinct and unique. Now let's go for the column profile as well. Please go for the column profile. Check this box please. If you click on the column profile, if you click on the column profile, you will be able to understand here. See there is only one unique value here. There is only one in the cities. There is only one unique value and all the cities are repeated. Okay? So that is why you are getting 49 distinct and only one unique right only one unique. Let me go for the ship mode as well. So in the ship mode we have four modes four distinct values. second class uh standard class then we have I think uh same day and the first day first class right but there is no distinct sorry unique value there is no unique value the chart will be only visible to you if you go for the column profile and column distribution not about the type shida. Okay. So it is the column profile of the column distribution. If you are not getting it might be the case that your data is messed up. Try to reload the data again. Reload the data again. So now everyone please check here. I'll come back to this. No worries. I'm going to the home tab in the Power Query editor. Okay. In the Power Query editor also I have the option for getting the data. Okay. That was whatever the get data portion was there, right? That was a part of your power query editor only. So if I click on this, see I have the Excel workbook. So I can also get the data from here. So let's go from here. Just get the data. Sample supertore. Open it. So this time I will be getting the people and the returns because I already have it. Okay. So I will be trying to I I this time I don't have the option for transform because already I'm in the power query editor right already I am in the power query editor so I don't have the option for transform I directly have okay so once I go for okay this data will be loaded here this data will be loaded Yeah. Please everyone load the people and the returns table as well. Yes, everyone. Have you loaded it people and the returns table as well? Kindly confirm me. Okay, only one response. What about others? Okay, now check here. If you go to the people's table, right? If you go to the people's table, you are getting in the column, column one and column two. But if you check the first row value, first row value, you have a regional manager here and you have the region here and then you have the names looks like the names of the person and it's talking about the regions right in that case what we can do this row right I can make it as header I can make it as column name can I do so because it feels like this is not able able to PowerBI is not able to identify the row name column names properly. Okay. So we have to allow we have to make it work right now. How do I so this is the column name. How do I do that? Please go to the home tab. Go to the home tab. There you have the option for this. Use first row as header. This one. Click on the drop-down. There you have the first option as use first row as headers. Please click on that. Okay. Samsung, where are you lost? Where are you right now? Are you able to access the Did you get the table people and the returns? Are you able to get the table? Kindly confirm me. People and the returns table. Do you have it? Okay. Now go to the people's table. Go to the people's table. That means click on this people's table. You will be getting the people table here. Right. Now what you need to do, you have to go to the home tab. Home tab. There you have the option for use first row as headers. Focus on my screen. Please click on this. Click on this. Click on the home tab. You will be here. You have the people and the returns table here. Right? You have the people and the returns table here. I believe. Okay, those who have it, those who have it, please go for right click. Sorry, not right click. Just click on the drop-down and go for use first row as headers. Automatically, you will check that your regional manager and region is coming as the headers. Similarly do it for the returns as well. Let me help out Samsung. Samsung please share your screen please. Samsung, please share your screen quickly. Okay, give me a moment. You have only the you are still in the table view. You are not in the power query editor. Go for the transform tab. Okay, here is the power. Okay, you have not loaded the data only. Just go for the home tab. Just go to the home tab. Yes. Click here. Click on the new source. Click on the new source. Yes. Go to the Excel workbook. First option. Please wait. Please wait. Okay. Just go for the people table and returns table. Click on people. Click on returns. Returns as well. Click on okay. Click on okay. Please wait. Now go to your parkquery editor please. Yes. Go to the people's table. Okay. You are having you are in the Okay. Go to the people's table. Okay. Now you have the first row as header right towards your right. Top top right. Please check towards your top right. Again more top more right. More right. More right. No. No. More right. Yes. Use first to headers. More right. More right. After group by. Okay. Next. Next. Yes. Use first to headers. Click on this. Yes. Yes. Use first headers. Click on Okay. Similarly do it for the returns as well. Similarly do it for the returns table as well. Everyone have you done it for the returns? Have you done it for the returns as well? Same thing. Click on the returns table. Just give me a moment. Here you have use first row as headers. Click on this. Done. See we are getting it. Everyone done till here? Okay. Now the next thing few simple things we are going to go for. Okay. If you wish to remove any column which you don't require. If you wish to go for any column that you don't require, you have to go for remove columns. Okay. Distinct values again. Okay. Give me a moment. Simple example if I take here simple example of distinct if I take here. Okay. If I take multiple values 22 23 in this case I have taken an example. So the distinct values are basically how many unique values not unique the distinct values are there. Okay, which has not uh even though it is repeated twice, right? How many values are there? So, I'll go for I have 22 distinct values. Distinct values. 22 23 24 56 45 and 89. Right? That means how many values? Six values are distinct here. Six values are distinct here. 16. six distinct values which has not been which are basically used right but in this case if I go for the unique here okay unique here unique means which value has not been repeated twice right in this case it will be five in this case it will be five because 22 is appearing twice here apart from 22 all are coming once only so those are five five unique values clear 89. Yeah, you understood I believe. Yes, only 22 will not appear here. Other than that all numbers will appear. So that is a unique. That value is not repeated. That value is not repeated. So if I go for the unique, we have 23, we have 24, we have 56, we have 45, and we have 89. These are the unique. Okay. Now, please check here. I'm going back to the orders table again. I'm going to the orders table again. There I'm going for let's take uh split column. Okay, let me go for first split column here. This one. Do you get it? Split column. Are you able to see the split column? Okay. So there we have the order ID. We have the order ID. Okay. So please check it out. I'll tell you one thing. those who are appearing for the PL300 right so park query editor is a very important topic okay so data cleaning is a very important topic so please learn each and every option clearly so you can go for the split…

Transcript truncated. Watch the full video for the complete content.