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

What if you could take raw business data, turn it into clear visual insights and help teams make smarter decisions? That is exactly what PowerBI help you do. Hey everyone, welcome to this Microsoft PowerBI certification training course by SimplyLearn. Today almost every organization relies on data to track performance, understand customer, monitor operations and plan for growth. But raw data on its own is not very useful unless you know how to organize it, analyze it and present it in a very meaningful way. And that is where PowerBI becomes such a valuable tool. PowerBI is one of the most popular business intelligence and data visualization platforms used by professionals across the industries. It will help you connect data from different sources, clean and transform it, build interactive dashboards, and generate reports that make decision making easier and more effective. So, this course is designed to help you learn PowerBI in a very practical, simple, and structured way. So, whether you are a beginner or someone looking to strengthen your reporting and analytics skills, this course will help you build confidence in working with data using PowerBI. So first we will begin with an introduction to PowerBI, its components, why it's vitally used for business reporting and analytics. Next we'll learn how to connect PowerBI to different data sources and understand how to import, manage and work with data efficiently. Then we'll explore Power Query where you will be learning how to clean, transform, prepare raw data before analysis. After that, we will move into data modeling where you will understand relationships, tables, and how to structure data for better reporting. We'll also cover DAXs or data analysis expressions to create calculated columns. And by the end of this course, you will have a strong understanding of PowerBI fundamentals and be able to build professional dashboards and reports with confidence. Also, 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 IIBAG V3 aligned and it will help you prepare for certifications like CBA and CCBA. You will be engaging with 10 plus industry projects, 40 plus practical activities and benefit from live online sessions led by experts. Plus with simply learns job assist you will get the support you need to land your next big role. So what are you waiting for? Hurry up and enroll now. The course link is mentioned below. So before we get started here's a quick quiz question for you. What is the main purpose of PowerBI? To design website to analyze data and create interactive dashboards to edit videos to write programming code. Let me know your answers in the comment section below. Here as I mentioned what is business intelligence? You can see here make intelligent business decisions. How? By the 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 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. You will be able to look into that part. So that is means sending the right information to the right people 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 self-service 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's it on its own cloud so that is why 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 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 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 is 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 well. 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 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 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 launched its uh new the PowerBI has been upgraded today itself. 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 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 working with the Tableau public. So you only are able from 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. 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. Okay. And the last one, we have others products as well, but here the last one we have here, here we have PowerBI embedded. Now, at the as the name suggests, 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 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. 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 for them you can go for this Microsoft uh sorry PowerBI mobile service. Now coming to the architecture. 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 or 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 the 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. Okay. If you are working with an offline file your file is stored suppose in your desktop 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 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 machines 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 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 drives. You are have to you have to set the gateway for that. 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 reflected in the service as well. So you don't have there is no manual intervention foruling automatic refresh we need gateway yes okay 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 import the data from here rather you have to just for now click on blank report. So this is the interface you get 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 as the report view. Report view. Then you have the table view. We are just getting introduced to it. Okay. 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. Tabular 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 definition language. 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 al 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 panes here. Three panes will be there. One is your data pan. One is your data pan. Collapse that you have the visualization pen. You have the filter pan 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. Now please check how can we load the data. Okay, 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. Okay. 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 that. 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 p P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P P PDF files, pocket files, SharePoint folder. So all the different sources you will be able to connect to. Check it out. 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. 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. Only the orders data. Okay, only the orders data. See once I click on load I'm clicking on load. Okay. Once you load right the orders data you will be able to see in your data pen. See this is your data pen. You will be able to see it here. 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 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? How the table is exactly storing here? Let me show you. For that you have to click on the table view. Please click on that. So if you go to the stable view, you will be able to see how it is exactly present in your original data set. How it is present in your original data set. Now let me go to the report view again. Okay, let me go to the report view again. So if I if to go to the report view, I will be going for this the first one. Clicking on the first one. This is your report view. Okay, I will be going to the first one. 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. Pre-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 well. The Power Query editor comes free with your PowerBI and Microsoft Excel. 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 you will be getting the option for count rows. You will be getting the option for count 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. 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 parkquery 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 applied steps okay there is no option of undo there is no option of undo in your 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. 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. Yes. 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 okay now check here what is this 1.2 mean okay it refers to decimal number it refers to decimal number 1.2 two 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 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 MQ query here. Okay. If we want to go for 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 right codes are generated for you. Suppose if I wish to go for right click sorry not right click 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 quotes 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 MQ language. Okay. Now, simple things, few simple things here. Please check it out. Here you are able to notice column profiling based on so top column profiling on top thousand rows. Okay. Now the thing is that if you go to the view tab if you go to this view tab right 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? 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? So, please check out here in this data set. Okay, let me go to the 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? Okay 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? 1 this is 12 13 14 15 four right four distinct values 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 okay 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 okay 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 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 to pbi is not able to identify the row name col column names properly. Okay. So we have to allow we have to make it work right now. How do I? So this 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. Now 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 the home tab. You will be here. You have the people and the returns table here. Right? I'm going to the orders table again. There I'm going for let's check 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 column. Click on this drop-down and you can see various options here. You can see various option here. Now how do I want to split? I want to split it by the delimiter. The first option the check the order ID column. Check the order ID column. I want to split it by delimiter. Please click on that. Once I click on the delimiter, you will be getting this window appear for you. This dialog box is appearing for you. It is giving you the option whether you want to go for and also it has identified the delimiter which is your hyphen which is your hyphen. Then they are asking you whether how do you want to split it only by the leftmost delimiter or by the rightmost or by each occurrence of the delimiter? Initially let me try out with the each occurrence of the delimiter here. Okay, let me go for the default one and let me go for okay. Okay. Right. If you click on okay, you will notice that the column order ID gets split into three columns. Get split into three columns. And not only that, not only that you can also change, you can also check that based upon the values, right? The data type has also been changed. Here you are having ABC. Here you are having 1 2 3. Here also you are having 1 2 3. Understood? Okay. Let me go for cancelelling that out. Please cancel the steps. cancel the steps again and let's go for splitting again and let's go by uh delimiter again. This time we'll go for the left leftmost delimiter. Okay, leftmost delimiter instead of the rightmost let's go for the leftmost delimiter and click on okay. What are you getting in this case? Only the other the rightmost is present but the left most has been removed. Clear? Okay. Now please check here if you are in the park query editor. If you are currently in the parkquery editor and if you wish to add if you wish to again add the new file. Okay get the new file just go to this new source option right go to this new source option click on the drop-down. Okay there you have the Excel workbook. Click on that browse to the location where your file is present. Okay. So click here the file and whichever file you require right whichever file you require you can just check that just give me a moment you will get the navigator pan. So you whatever whichever whichever data you need you go for that people and the returns and go for okay once you click that go for okay I'm not doing that because I already have it and if I I can do that see I'll get if I go for okay I will be again getting it twice okay so I'm going to delete it right now because I got it twice okay now since I have got it twice let me delete Okay, I don't need it. So, I'm going to delete it from the model. Just give me a moment. Delete. I'm also going to delete this one. Okay, now let's go back to the order data set. And we were working with the split column. Okay, we were working in the order ID. And here we have the split column here. So, click on this. Okay. So, let's go for the suppose by number of characters. I'm going for this right now. Okay. Number of characters if you wish to go for. So if you wish to go for only maybe three characters. Okay. You want to go for number of charact specify the number of characters and you wish to go for three characters. Click on okay. The quotation is not why I'm not showing you because we don't have the quotes here. So I'll take a data and then I have to show you. Okay. Let me do one thing. I'm taking an Excel file right now. I'm taking an Excel file and let me save some names here. Suppose here I'm saving strawberry. Then I'm using here maybe cherry. Here I'm using maybe kiwi within quotes. Okay. Then I'm going to save the file as a CSV file. Okay. Not an Excel file. I'm going to save it as CSV file. So not it's an you can see here the file I'm going to save here it is right now an Excel workbook right right now an Excel workbook I'm going to save it as a CSV file right now let me do that comma separated yeah I'm going to go for this comma delimited okay delimited form okay I'm going to just go for sample test okay sample test and I'm going to save it somewhere in my folder just give me a moment Okay, now I'm going to load this file. Let me show you here how it is. Now we are going to work with the CSV file right now. So let me load it again. I'll not go for the Excel workbook. It is my text CSV. Okay, so this is my sample test. So this is my file right now. Okay, this is my file right now. Okay, now I'm going to use the split column. Okay, I'm going to use the split column here. Okay, how do I do that? Okay, so here is the split comma. It's comma and we have the quotation here, right? Let's go for this. See what happens is that even though a comma is here, right? It is going to replace the quotation here. So that is the purpose of your quote. That is the purpose of your quotation right now. Okay, for the comma and then you have to again split it by the comma. Once you go for splitting it by the quotation, then you have to go for split it by comma. Okay. All right. Now please check here. Let's try out with the another one. Let's go for another one. Okay. Let's understand the split properly. Then only we will be going going to understand the extract as well. There is an extract option is also there. Okay. Let's go for split and let's go for number of characters. Okay, let's go for here number of characters. I'll go for three characters. After three characters, it should repeatedly split. Okay, let's check it out. What happens here? If I go for the number of characters, see it is first three characters 1 2 3 that is C A and hyphen. Then we have again 202 again three characters then zero under sorry hyphen and one three characters. So it is splitting every time it is splitting by three characters repeatedly. It is splitting by three characters repeatedly. Are you able to understand number of characters? So I'm again removing that. Okay I'm deleting that. Let me go for one more example from here. Suppose okay why I'm going for this library let me take the uh okay first name let me go for this one customer name okay we have the customer name where we have the space here where we have the space here right we can go for the delimiter to get the to extract the first name and the last name to extract the first name and the last name and save it in a separate column you can do that otherwise let me go for some other one suppose by upper case to lower case what will happen by upper case to lower case if I go for this uh for customer name your C will be in separate column your L will be in a separate column please check it out if I go for upper case to lower case C your C is in separate column and rest other is in all other column okay and again G you have it here and you go for this last name here this is for your upper case to lower case clear upper case to lower case. All right, let's go for the extract right now. Let's go for the extract right now. Okay, then let's understand what is how it is different from the extract. All right, now please check here how do we go for the extract and what's the difference between the extract. Okay, let's go for the transform tab. Let's go for the transform tab. Right now in the transform tab, you will be having the extract option. Now, similar to this, similar to the split column, I'm going for the extract option and the first option. Okay, I'm going for text before delimiter. I'm going for the text before delimiter. Okay, the fifth option. So, if I go for this, so what is the delimiter? You have to mention here. So, it is suppose space. Click on okay. space I have given. Okay. So what is the difference? You can check here of the customer column, customer name column. If I go for extract, what is the difference are you getting here from split? Check here. This is my customer column. Go to the extract. Go for the text before delimiter. Okay. Here it is not identifying the delimiter. We have to take that. Okay. So I'm giving here space. Just click space. Click on okay. What is happening here? Are is it are we getting two different columns here? No. Right. Only the text which before the del limited. Right. Delimiter I have given a space. Only the delimiter I have given a space. So I'm able to extract the first name here. Right? So that's what your difference between your extracted. Extract will just retrieve it. It is not going to split the column. Split is going to split the column right into different columns. But your extract is just going to retrieve the value, fetch the value. Okay, let's go for okay, I'm just u I have just cancelled the step. Okay, I have just canled the step. Now let's go for suppose if you wish to go for the by the length of the character. If you wish to go for length of the character, if you wish to go for extract, okay, uh give me a moment. See, you will be also if you just go for extract the length, right? I'm show you here. You will be able to get the length as well. You are getting the length. The first name was 11 characters. So, so you are getting it like this. Okay. Now, I will be going for group by. Let's go to the home tab again. Let's go to the home tab again. Here also we have it. We can do it from the from the transform tab or we can do it from the home tab. It's like Microsoft uh Excel only or word file only. So where we have multiple option repeated in the tabs. So here we are going to get the group by option. You will be able to get the group by option here. Okay. Now suppose this is giving me just normal data right it is just giving me the uh how the data looks like but if you wish to go for summarization just you want to get for maybe u city- wise total sales if you wish to go for checking the value what is the city wise total sales okay for that you can go for the group by option okay if you I I would not suggest to do it in the power query editor but if you Just want to go through it. Okay. Just want to check. Okay. How to apply the group by. So please check it out. How can we go for it? Okay. So everyone please focus here. This is your group by. So click on that. Once you get that you will be getting a dialog box appear for you for group by. Here you have the first option. So we will having we will be having the basic one also and the advanced one also. So using the basic one you will be able to group only using a single column. you will be able to group using only a single column. Okay. So check here if you have the basic one and I want to go for suppose city wise total sales. If I wish to go for city wise total sales so let's go for here. Okay check it out here I'll modify it to suppose city. Okay, city here and I have to go for providing the name of the column. You can give any name. Okay, so let me give here city wise total sales. Right here I will be changing the aggregation function. I will be changing the aggregation function. So to sum because I want the total, right? I'm going for sum here and in the column I'm going to choose the sales. Please modify the do the changes please see what is the city wise total sales for each city you will be able to get it here. Okay. But the thing is that see we are just doing the pre-processing. We are just doing the pre-processing here. If you do everything here right if you do everything here your entire table is lost. You're able entire order table is lost. You don't have any data. You can anyway able to get this data in your PowerBI as well. You will be anyway able to get this in your PowerBI as well. Okay? So you don't have to do it here because your data will be lost here. Your data will be lost. Right? So I would request not to do the group by here because same thing we will be able to do it using the visualization as well. Okay? So what you can do right now you can go for the cancel step. Yes for the uh for as an analyst you can for understanding the data you can go for it. Okay but do not save it. Do not save it because your data will be gone. So cancel the step please. We can directly apply in the visualization. We can directly get it in the visualization that city wise total sales right we will be able to get it. See power query editor is a different application in itself. It's used for pre-processing. So please check it out. If you wanted suppose statewise, citywise total sales and total profit or maybe. Okay, let's go for statewise and statewise, city wise total sales. Okay, let's go for doing that again. Go to the group by. Where is your group by? You are getting it here. Click on the group by right. Click on the advanced option. This time click on the advanced option this time. Okay. Now go for advanced option. Okay. Now let's go for state. Let's go for state. Select the state here. Right. Now please add one more column. Go for grouping. In the row ID, I will be selecting the city. Go for this one. Right? State and city. Now here I'm changing the name of the column state wise city wise here if you wish to go for suppose let me go for max okay instead of some total I'll go for maximum sales let's go for sales here I will be going for sales click on okay okay let me click Click on okay. See now this is my statewise city wise total sales sorry maximum sales. Got it? If you wish to go for maybe let me just cancel this. Okay let me cancel this. Go for what are the things you want? You want suppose uh let's go for state. You go for add grouping. You want city as well. Just go for this. Okay. And here you want maybe alpha one we will do state city count. Okay. Let's go for count rows only this time. And here. Yeah. Okay. It's better to do it in this way. Okay. sum here we are getting but we want to get the count okay count I will be showing you here if it is not working here right anyways because this is for just our understanding right I will be showing you in your powerbi how to do that okay so whatever you changes you do right I'm canceling it right now you have to go for this give me a moment you have this close and apply option here right under the home tab so since we don't have right whatever the changes you are What are the changes you are doing? First check your data sets that it is correct right now. Okay. Data type. Go to the close and apply. So you will be getting three option here. Close and apply. So what does this close and apply mean? It will save the changes. Whatever changes you have done, it will save the changes and close the Power Query editor and take you back to the PowerBI and take you back to the PowerBI. If you want to just go for apply, it will just save the changes, but you will still be in your Power Query editor. You will still be in your Power Query editor. But if you wish to go back to your PowerBI, you have to go for close and apply. If you just simply go for close, right, it will not save the changes. Am I clear? If you go for close and apply, it will save the changes and you will be closing the power query editor and you will be going back getting back to the PowerBI. Am I clear? Now check here one thing. Now I'm currently in the power uh PowerBI right now. Report view right in the data you can see these things. Discount you are getting a summation symbol. Postal code you are getting a summation symbol. Profit also summation symbol. Okay. So there are you can see different categories here. Okay. Wherever you have the numerical columns you are getting a summation symbol. You are able to get a summation symbol like this. A sigma symbol is there. Right? That means those are numerical columns. Those are numerical columns. Wherever you are not seeing any of these symbols those are so here these are known as measures. Okay. The numerical columns are known as measures. The numerical columns are known as measures. Wherever you are not seeing anything, okay, that is category, city, customer ID and all those things. Those are your categorical columns. Those are your categorical columns. And you are able to see this date as well. a calendar-l like icon when the order date and the ship date. So that is your date, that is your date. Check if you have any confusion here. Wherever you are not seeing anything, category, city, country, the region, customer ID, customer name, these are all categorical. Where wherever you are seeing the date icon, the calendar icon, that is your date. Okay. Now one more thing. Now Power Query, PowerBI is have one more feature here. Okay, that power query editor don't have that is we can go for uh categorizing the geographic locations as well. We can categorize the geographic locations as well. Okay, so we have a data type for that. So please check how can we do that? How can we do that? Geographical locations. So city is a geographical location, right? City then we have the state all those things. So please check here. Please check here. We are going to categorize the city. Please click on the city. Please. Click on the city. You will be able to notice that you are getting the column tools on top. Once you click on the city, right? Don't check the box. Don't check the box. Just click on the city. You will be getting the column tools. Are you able to get it? The column tools. Just click on the city. Do not check the box. This one. Are you able to get it? Okay. Now what we can do, you can see an option here. You can see an option here for the column tools. Since I have selected the city, right? You can see here city and it is of data type text. Also, you can see it as the data category as uncatategorized. Okay. What you can do? You can click on this drop-down in the data category and make it city. Choose city here. Choose city here. Please check what is the changes are you getting. Yes, exactly. So if you go for categorizing it immediately you will be noticing that you are getting that globe icon and this is really helpful when we go for the map visualization. It connects to the Google map. Similarly, can you do it for the country and the uh region and the state as well? Okay, let's go for creating our first chart. Okay, let's go for creating our first chart. Okay, so please check here. We are going to create a simple chart right now. Okay, let me not go for uh yeah, I'll go for this city wise total sales like we have done here like I done in the group buy, right? Without group by I'm going for this. Okay, so I'm going for a The first visualization I'm going for is this one. The first chart, the very first chart. Do you all have it? Do you all have it here? If you take your cursor, you will be able to see the name of the chart as a stacked bar chart. You will be able to see the name of the chart as a stacked bar chart. Please click on that. See, you are getting the chart. You are getting the chart. Isn't it? Now, you don't have to do anything. You don't have to do anything. I have to just put the columns. Okay. based upon the charts just give me a moment when I select this chart right I will be able to get this option as well over here are you all getting it x-axis y ais legend etc so it is talking about the horizontal axis vertical axis we don't have to think about anything here okay so here okay always for a chart we will require some numerical value and we will require some categorical value okay so I'm using. So I'll select here based upon the chart I'm going to tick this box city. Okay, I'm selecting this box city. Automatically it has appeared on my y-axis. But nothing is appearing for me. No chart because I have not given any measure. I have not given any measure. So that is why I'm not able to get it. Just the moment I click on sales, you will be able to get the chart. Please check it out. Are you getting a non just check this boxes you don't have to do anything just within a fraction of second you will be able to create the chart got it okay so I'll tell you one thing focus here x-axis I have selected sales but I got sum of sales that means what city- wise total sales city wise total sales so that's why I ask you not to go for the group by in your uh park query editor. Right? Okay. Now everyone, this is my chart. Okay. Where are you right now? Select the first visualization. Please select the first visualization and check the boxes. Check the boxes. Then city and your sales. That's it. You'll have to do nothing. Okay. Once you get this chart right, you can see this marks here. If I want to resize the chart, I have to drag I have to drag it. See I have to drag it. Then only you will be able to increase the size. Okay. Now you can see here the charts though it is visible but we are not able to see the labels like what is the sales done in each city. I understand that New York City has highest done the highest sales right from the chart but I'm not able to get it the total sales here. So what I'm going to do I'm trying to get the data labels. So please check here everyone. I'm just expanding my visualization pen. Okay. There to do the formatting. You have this option format your visual. Are you able to get that option format your visual? Click on that. There you have two option visuals and generals. There you have the option visuals and generals. Okay. Scroll down. You will be having the data labels. Scroll down. You will be getting this data labels. You have to on this toggle bar. Currently it is off. You have to on this. Check it out. After ribbon, you have the data labels. Just on that. The moment you do that, you will be able to get the data labels. But still it is too small. Now we are going to increase the size. Please expand it. Expand the data labels. Expand the data labels. Scroll down. Scroll down. In the data labels, once you expand, you have the values there. In the data labels, you have the values there. Please go for expanding it as well. The values you can increase the size from here. Check. I'm going to increase. So now for now we are getting in K that is in thousands. You can also change the labels as well. Let's see how can we do that. Scroll down. You have the display units. Scroll down. You have the display units. Are you getting it? Display units. It's auto. Make it none. You will be getting the exact value. Make it none and go for the decimal places. Instead of auto go for two decimal places okay in this case we will be getting after decimal only two or let me do one thing I don't want the decimal places only. Okay I'll making it zero no decimal numbers. Okay similarly so this is for the data labels. Now let us increase the size of this uh you know y-axis as well. I cannot see it properly. Okay. So go scroll up scroll up or you can change the color as well. You can check the color for the data labels as well. But now I'm not doing it. Let's go for increasing the size. So just scroll up scroll up scroll up. You have the x-axis. Sorry yaxis. Can you see the xax yaxis please? The first option. this one. Expand it. Expand it. Increase the size. See, I'm able to see it now. I'm changing the color as well. Black. So, this is our very first chart. This is our very first chart. If you wish to save this, how do you save it? Please check it out. You can just go to this file option. You can go to this file option. And there you have the save as. Click on save as and you have to search for a location where you want to save the file. So go for browse this device and save your file. It will be saved as PBX file. So let's do one thing. Let's quickly start and I would request you all to kindly load the sample super data. You are already aware of it. Please go for loading. Okay. Now since you are aware of this, right? You know it's a excel file. Okay. And we have looked into the data s get data purpose also get get data option also we can directly load from here as well right we can directly load from this is simple excel file we can go for loading the file from excel so I'll go for the sample supertore and I can load it directly okay click on the orders data I want only this and just go for loading the data just orders just orders okay those who are done I would request gest you all to just uh categorize the city, state, country and region or postal code as well. Categorizing the geographical location that please do it. It's always a good practice that you do the categorization. Okay, check the data type properly. So go for this. Here is your city column, right? Just click on this. You are getting the column tools categorize instead of uncatategorize right please categorize it to city categorize it to city okay similarly do it for the state and the postal code as well country and region done so now everyone please check here let me just decrease zoom out a little it. Okay. Now, please check here. You can see this dotted line portion, right? This dotted line portion. So, this area is known as your canvas. This area is known as your canvas. So, whatever reports, okay, charts and the uh charts and the all the visualization tables, whatever you are going to create, you are going to create inside this canvas. you are going to create inside this canvas. Okay. Now if you wish to color this canvas. Okay. So you can see no chart is selected right now. No chart is selected right now. What you can do? You can go to this visualization pan where you have this. Focus on my screen. Okay. I hope you have this option. Format format your visual or format your report page. Right now you are getting this is known as your report page right click on that please since we have not selected any chart since we have not se selected any chart no chart is present here it is a c canvas which is empty right that is why you are getting the option for format report page and here you have the different informations okay suppose now if I go for the if I want to apply some color on the background I want to apply some color on the background. Okay, let's go for this. Expand it. Expand the uh canvas background. Expand the canvas background. Okay. Now you have the color option as well. Please check it out. You have the color option as well. So for now the color is white. The color is white. If you wish you can change it to some other color. So let's go for I'm just removing this annotations. Okay, if I wish I can go for applying some color as well. So please check I'm applying the color but even if I okay let me apply some deep color. Okay, dark color I'm applying but even if I applying this color I'm not able to get this color here. I'm not able to see this color here. Okay, why? That's because of the transparency. It is entirely transparent, right? So, I'm not able to view the color. What I can do if I wish to get the color, I can reduce the transparency. Then I will be getting the color. Try it out. If you reduce it, you will be getting a deeper color. Okay. Now check. You can if you wish, if you wish, you can also add an image. If you don't want to go for background color right you can also go for image as well in the background right whatever you wish you can go for that I have an if you have an image in your system okay what you can do you can just click on this sign okay symbol and then you will be able to get an image and you will be able to apply it okay as a background as a background but for now what I'm going to do I'm going to apply the color only background color only instead of an image image. Okay, image we are going to work today because we are going to create a report. There I will be showing you how to insert an image. Okay. So let's go to the build visual again. Let's go to the build visual again. Okay. Now please kindly let me know are you able to view all these images? Are you able to get all the images that I have or you have something less? All the images especially this one 1 2 3 or something then only you will be understand okay all are there right if all are there not an issue because in the previous version they have removed it so that's why I asked you okay let's go forward then all right now we are going to create the charts okay or we are going to first create a chart we are going to do the formatting and then we are going to create a report Okay. So, let's start it. Okay. Now, let's go for the visuals. Okay. Build visual. So, I'm going for the visualization right now everyone. Okay. This is my build visual. Okay. This is the maximum background we have the default background you have. If you wish to go for changing the size, okay, if you want to go for a default size, right, you can go for canvas settings. And again, same thing. If you wish to go for setting, you can go for the canvas setting and you can select the sizes. So for us, it is 16 is to 9. Keep it that one. That is better one. Okay. But if you wish to still change it, you can go for custom. You can go for custom and you can make it custom. Okay. Size you can go for the height and the pixel. You can set it. But I would suggest go for the default one that is your 16 is to 9. There are different options as well. Right. 4 is to3 letter tool tip custom. So go for the 16 is to9 that is the most appropriate for creating the report. Okay. Now let's proceed. We are going to create a chart. Okay. Category wise total sales. We are going to create a sales dashboard today. Okay. Let's go for creating a sales dashboard. So I'm selecting the first chart. You're aware of this one right? Okay. So let's go for this. Okay. Now I'm clicking on this chart. Clicking on this chart. Then I'm selecting category. Just check that box category. Then I'm going to select the sales. I'm going to select the sales. So please check once I click here. Right? So this is my category on the y-axis. On x-axis I'm getting the sales. Now I can simply drag it to enlarge the image a little bit. Okay, it's simple. Here I'm removing the chart. Please click on the first chart. Okay, select the category. Check the box category. Check the box sales under the data pan. That's it. Okay. Now please check if you wish to enlarge the size. Okay, maximize the size. I can go I can just take my cursor here. You will be able to see the cursor has changed. Now you can able to drag it. So I'm dragging it little bit right now. Okay. Once I drag it, if I wish I can also just take move it to some other position. So what I'll do, I'll take it somewhere here. I'll take it down. Now let's go with the formatting. when you're going for the formatting right you have to make sure that your chart is selected how do I know my chart is selected you can see this gray lines you can get this gray lines over here so that means my chart is selected if my chart is selected then only I will be getting this option just give me a then only you will be able to get this option that format your visual okay check here format your visual if your chart is not selected you will be getting format your report page format your report page. So make sure that your chart is selected. So click inside the chart you will be getting this format your visual. Click on that. Okay. Now please check once you get this format your visual right. Once you get this format your visual you can see in the formatting part in the formatting part you can see two options. One is your general option, another is your visual options. Now what are the whatever the options are present under the visuals, right? Whatever the options are present under the visuals are specifically are specific to the chart you have selected, right? Are specific to the chart you have selected. Suppose the y-axis, x-axis, grid lines, so bars etc. these are specific. But coming to the suppose the background of the chart okay then the font of the title so that is related to the general portion. So that general will be common for all the charts. General will be common for all the charts but the visuals the visuals options will vary for different charts. Okay. So let's work on that and then you will understand it. Let's work on the visual. Okay. The first and foremost thing we are going to do working with the y-axis labels right now it is too small right small and it is not clearly visible to our eyes so what I'm going to do I'm going to expand the y label I'm going to expand the y label here there you can see font size is 9 you can change the data uh data font font as well. So you can make it time new times new roman if you it's not okay with you or you can just keep it same as well. So I'm going for times new roman here and size I'm increasing it to suppose 11. Okay. 11 color. You can go for color. So I'm applying some color. Maybe black. Now we are not going to switch the axis position. Okay. We are not going to switch the axis position. Why? Because check. This is how it looks. If I switch the axis position, not good, right? So I'm not going to use that. Now what about the width? If I increase the width, okay, less than 50. See this is the width width of the bars right? So we don't want that. We don't want that. So let's keep it around 20% or 25% only. Okay. My chart is unselected right now. Done with the y-axis. Okay. Now let's go for the x-axis also. But if you check the x-axis, right? Okay. You have the y-axis title. Y-axis title is a category. Okay, let's go for that. Let's expand the Y-axis again. Let's expand the Y-axis again. There you have the Y-axis title. These were the values, right? These were the values. You have the title as well. Let's do that. Give me a moment. Scroll. Scroll. Scroll. You have the titles. Scroll down. The let it be auto only. You can also change the title instead of category. You can give categories that is also okay. But let us keep it keep it same. That is category. Then let's scroll down. You can change if you wish. You can make it little bit bold. Okay. I have made it mole. That's it. Nothing else. Pawn size is 12. Let it be 12. Now let's go for the x-axis as well. Please go for the x-axis. Okay. Now in the x-axis please do not change the minimum and the maximum range. Please don't change this. Let it be auto otherwise you because the difference is not much. The difference is not much. We will not be able to understand. So you will be getting a straight bars only. Let it be. We are not setting that. Keep it same as automatic. Okay. After that go to the values. Go to the values. Make it black. In the display unit, you can make it none. Sorry. Yeah. Display unit, make it K in thousands, please. Display unit, make it thousands. Let me know if you're able to get it till this part. Okay. So, this PowerBI is a tool, right? You have to explore it to learn. Okay. Now let's scroll down to the data labels. We are going to add the labels because from here I'm not able to understand what is the value here. Right? Let's go to the data labels. Okay. And let's go for values. In the data labels, scroll down to the values and go for applying the color black here. Little bit increase the size. That's it. Okay. Now, let's change the color of the bars. Let's change the color of the bars. Okay. So you can go to the bars, please. You can check. You scroll up and go to the bars. Scroll up and go to the bars. Expand the bars. Here you can see apply setting to in the bars you are getting apply setting to categories as all. And that is why you are getting for each category right for all the categories you are getting the color is blue. But if you wish to get different colors for each category, what you can do, you can just select the category. Suppose I'm selecting the technology category right now and I'm going to modify it to some other color. Okay. Now, if I go for this any color of your choice, furniture, you can go for go for office supplies. See data labels you have the you have to scroll down to the data labels and on it. You have to scroll down to the data labels and on that after that expand the data labels. Once you expand the data labels scroll down go to the values. You have to make it the display unit as okay in the y-axis but you can still make it as thousands here. That's it. You can still make it thousand but anyways we are getting in thousands only because we have done it for the x-axis. Okay. So you can do it like this and what else? Okay bars. So please check after that. After you have this, just give me a moment. Scroll up. You have the bars. To change the color. To change the color, you have the bars. Expand it. You have the apply setting to categories. Right? For you, you it might be all. For you, it might be all and the color is blue. So, what you do? Select each category separately and change the color of it. Since change uh select each category separately. Suppose this office supply I have selected I have given yellow color. Similarly you can go for technology and give blue color. So whatever color you wish you go for that. Now please check here we have the grid lines here. You can see here. Okay I'll click on the focus mode. Okay please everyone check here. This is known as the focus mode. When a chart is selected right you are having this option right? You will be getting this focus. This is known as the focus mode. So if you take your cursor here, you will be able to see the name of it. It's a focus mode. So if you click on this right, the second part, you will be able to get the enlarged image. You will be able to get the enlarged image. Okay. So this is known as the focus mode. Now you can if you just click on when you check my diagram, right? If you check the start, you will be able to see small small grid lines. Are you able to see it? the grid lines. Now if I wish to just for the aesthetic purpose only if I wish to go for coloring it making it little bit deeper I can do that. How? So please check here. I have the grid lines here. Okay. I have the grid lines here. Please expand the grid lines. Expand the grid lines. You will be getting the color as gray right now. So I'll make it black. I'll make it black. Okay. So it becomes more visible right now. It is becoming visible right now. Also instead of the dotted line style, right? If you check here, instead of the dotted line style, I'm going to make it dashed. Two things, two changes only. On only the color and the line style. Understood? Okay. Now the thing is that we have applied we have done done the basic or the specific visualization. Right? Now the thing we are we are going to do we are going to apply the background color. We are going to make this title okay bold and make it a like you know in a proper structure in a proper format right so that it is able to segregate it from the chart. So for doing that for applying the background color or maybe some making the title proper we have which is common to all the charts okay we will be going for the general option we will be going for the general option not the visual okay make sure that your chart is selected and clicking on the general so see that's what I'm getting okay now the first and foremost thing I'm going to work with the titles. I'm going to work with this title. Okay, expand the title, please. Let me do one thing. Let me drag it a little bit and Okay, the title I will not be able to see it here. Just give me a moment. For now, I can expand the image so that you're able to view it. Okay. So, this is my title, sum of sales by category. Okay. Now I will be going for this one title. Expand the title. So instead of sum of sales by category, I'm going for changing the title to total sales by category or category wise total sales. Let's do it better. Category wise total sales. Okay, I've changed it. Now, you can also increase the size a bit of the title. Make it bold. You can totally use your own aesthetics. Okay, you can go for font, any font, color, whichever you wish, up to you. Okay, now I'm going to change the text color. I'm going to change the text color. Okay, so please check. I'm going to make it white. But if I make it white, I won't be able to get it. Right? So the background color I will make it black. Background color. This is of the for the title. This is for the title. I'm making it black. Where did I do it? Please check it out here. This is your text color. This is your background color. able to understand. Now I want to make it center. I don't want it in the like left aligned. Okay, I want in the center. So how do I do that? Just scroll. You will be getting the center aligned. Done. Done. Okay. Now comes your background. So this is your title. It's done. Now we want the background color. I hope everyone is done with the title. Let me go for the background then. Please everyone scroll down to the effects. Scroll down to the effects. You have the effects right? Please go here. Click there. Once you go to the effects, right? That is effects. Expand it. You will be getting the background. You can go for any background color of your choice. You can go for any background color of your choice. I'll make it little bit transparent so that it becomes lighter. Okay. It's too much. Okay, let me apply some. I have taken a deeper color only. So, let me go for taking a lighter color. Not looking good. So, I'll take some other color. Okay. I have to change the font color. Then I have to change the font color because it's not visible only. this I'll changing the font color now please check you have a visual border if you want a visual border to the chart right so you can just on that you can just on that you will be getting a visual border and apart from that if you expand it you can also get the border rounded because it is now sharp edges so I'll make it rounded I'll also increase the width what is happening in this case Please check it out. It becomes rounded. Right now, give me a moment. I'll just make it the lighter so that you are able to view it. See, are you able to see the rounded border here? Are you able to see the rounded border? Let me select it again and go to this visual. What did I do? You have this visual border, right? You have this visual border and…

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