Power BI Desktop Introduction - A Complete Beginners Guide | Alan Murray | Skillshare

Power BI Desktop Introduction - A Complete Beginners Guide

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
5 Lessons (1h 31m) View My Notes
    • 1. Power BI Desktop Introduction #1 What is Power BI Desktop

    • 2. Power BI 2 Import and Transform Data

    • 3. Power bi 3 model

    • 4. Power bi 4 dax

    • 5. Power bi 5 visuals


About This Class

This class is an introduction to Power BI Desktop. This class is a complete beginners guide to the software.

It starts by explaining what Power BI Desktop is and why you would use it. We then show how to install the software and the different options available.

We then create a Power BI report following the entire process. We get the data from different external sources, clean and shape the data, model it and then create DAX formulas and visualizations.

This class is a great intro to the software and shows everything you need to get started.

Download the exact files used in the lessons and follow along.


1. Power BI Desktop Introduction #1 What is Power BI Desktop : Hello and welcome to this video tutorial by computer guard guard dot com. And in this video and the next few videos in this Siri's, we are going to look at an introduction to Power bi I desktop. So this video is what is power bi desktop. So it is aimed at those of you who may be new to the tall Or maybe you're not familiar with it yet and you're hearing the words for the first time. So we're going to see what is it? How do I get it? And more importantly, over to come in videos? How do I use it? So first of all, what is power bi I Well, it is a complete B i ittle, which allows anyone to easily create powerful and interactive reports, with the emphasis being on that presentation of the data. The visualizations you get with power bi desktop really are another level. It does include the power query that you might be familiar with from excel to import data from multiple sources and be able to to transform and cleaning up ready for analysis. It also has the data model would become relate different tables you don't need to use that in orderto use power bi desktop. But a great strength is getting data for many sources huge data sets and to build a model it, you can then create those visualizations from it on. These visualizations are very interactive. So if you're using charts on matrixes slices and then be able to to click on or interact with one visual and see how it filters and transforms had a data is presented in other visualizations on that report, it comes in three versions. The Free the Pro and the premium. So, yes, it is free power bi desktop you can download for free on. I'll be showing you how to do that shortly on. Then you can use that to follow along with this series of videos. I will also provide a link in the description of this video to First of all, download and Access Power Bi desktop, but also to download the files that I'll be using in this Siri's so you really can follow along. How does power bi desktop defer to excel? Well, the good news is that it does include power query on a data model, and you may be familiar with those talks from Excel. And if you're familiar with those tools Power query, pal, pivot and Internal Model, then they are almost identical in Power Bi desktop, so you can just transition your existing skills across. However, Power Bi Desktop does contain mawr, Dax formulas and faster calculations than what you can get with Excel and Power pivot. It also has mawr. Visualizations on those visualizations are gloriously interactive, as I've mentioned already. That is one of the great strips, and you'll see that in one of the coming videos, How will be able to interact and also choose how we interact with those visuals and how they affect other visuals, which we have on our dashboard or our report. What can you expect? Well, I've got a project that we're going to walk through here to create two different dashboards on the reports on the files, which will be able to access from a link in the description. Off this video work on the idea that we work for some kind of subscription based company you can imagine with where and Netflix or YouTube or someone it works on a subscription model. So we've got data of all the subscribers that have joined within a year on whether there knew whether their return in whether they're free, where the premium am I going to work on this to correct some dashboards and analyze that data? So this video at the moment is all about what Power bi desktop is on. I'm going to show you how to get to it soon and have a little glimpse of it. But then we'll look important data from different sources, and we look at transforming and load in that into the model within. Look at building up her model, creating relationships between our existing tables and then look at creating a date table so that we can do some time intelligence work. We need to look at writing Dax formulas. This is where really steps up. Another level to create. Some measures on these measures will be used in our visualisations later on, which leads us onto that, creating two dashboards in our report, looking at how these visualizations could be created, formatted on an interactive and finally publishing that report, how can we share our power? Bi? I reports. So how do you get power bi desktop on this site at this u R L which I will have a link in the description of this video to you can get access to power Bi desktop. You see, there's a button right here to start for free, and you couldn't download it and start using it. Now if I click on the progress in Link a top. I spoke about how there was a pro on a premium version as well, and here they are. This is showing it in U. S. Dollars. So at $10 a month, you get the pro version Onda key difference with the pro version at the time of doing this video is the collaboration on the way you can share your dashboards with the premium version. You can see the cost on that cost is because it is on site. It is on premises computing and storage and the way that you can share your dashboards the other way off. Getting access to power bi desktop will be through the Windows store. So when the machine I'm using at the moment, I can just click on my start button and access the marks of store through here. You may access it a different way on your device. If you can use this white on a concert for the app. So I have this search in my top right corner on this window, and I could just search for power bi I And here we go. If I give it a click here. Here it is. I have a button for me to launch you on the right hand side because I already have it. But few that button will say download or something similar to get access to. It tells me how this product is already installed for me, but here it is. Information about power bi desktop. And as I scroll down, you have a fantastic little description to it here, some of which I've been talking about already in this video. Bacon Ciel their benefits off using this power bi desktop mentioned by them here. We've mentions off that on premises report that we just spoke about You get a premium version, you won't get up the free version. Once studies downloaded, we can start to look at how it works. So when you open power bi I desktop for the first time, you will get this welcome screen. And he considered the bottom. There is a tick to show this screen that start up and you can stop that. But if start screen will give you access to getting data from sources term to use one of your previous reports. There's also really useful links here to find out further information both about how to use power bi desktop, but also to see what might be new and get some assistance with using it. This product is updated on a monthly basis, and if you download it through the marks off store, it will be automatically updated each month for you. And he could find out what is happening fruity. Start up screaming through that link. If I close down this start screen for the moment, this is your typical start to power bi desktop. And the first thing I want to do is save this report, and I can do that in the usual way file save as. And I'm just going to save this to my documents folder. I'm happy with this. Now look at the bottom here. Savers type power bi I file adopt P b I X extension said power bi reports have a P B. I X extension. Now I'm going to give it a name. Let me call it that. Subscribers, let me call it. And you subscribers report. I'm just going to save that into my documents folder. And there it is, that saved. And you can see with this PB I desktop that we have the ribbon at the top. So no different, really to excel. You know, some of the buttons may be different, but just like good Old Excel, we have some different views on the left hand side. The report view we have the date of you on. We have the model view. There were some people called it diagram view. So at the moment on the report view, this is where we will see our stunning visuals and are dashboards. Nothing to see at the moment. At the bottom, you'll see I have one page just like you get sheets and excel on. The plan is to create two pages for a report. If I click on the date of you, there's nothing to see here because there's no data added. I never click a model view. There's nothing really to see here yet. Apartment little description there. So put back on the far right hand side. We have the area where we will be creating visualisations. So that's a fantastic choice of different visuals and hover over. They tell me what they are underneath, that we have these different areas where we can drop information from our tables just like you do with pivot tables. So any skills you've got there you can utilize here very user friendly. We also have these two buttons at the top filled and format and will be seen these in the video we do on our visualisations about how we can both create them, but it makes some formatting changes to them. So this is a quick little introduction to what the screen looks like will be seen it in a greater detail will begin their hands dirty over the coming videos. So I look forward to seeing you in the next one where we begin to import data transforming it and getting itself ready for our reports. 2. Power BI 2 Import and Transform Data: Hello and welcome to this video tutorial from computer guard guard dot com. And in this video, we're going to look at how to import and transform data in power bi I desktop. So we are working on a subscription model business, and we need to get data from different sources. We're going to get it from three different sources into a model for further analysis and reporting. And you can see from my home tab here that we have this get data button on. This is where you would typically begin to go and grab that external data. And for this first example, I'm going to get some data from a folder. Now I do not see folder as an option at the moment are sitting really good options, but not the one I want. So I will click on MAWR on this will open a complete set of options. Wow, look at all of these options. Lots of different sources for data. Fantastic. Now the one I want was actually near the top. It's the 5th 1 down, fold up and I will click on Connect after selecting it, and it's going to prompt me for where is this folder that you speak off. Let's clicking the browse button and go in. Tell it where it is. Well, it is in my desk Documents area, Westmont Doctrines area This PC documents. And if you're coming to here, where are we? Subscribers folder on in here. I have a number subscribers folder on that contains to see SV files, which I want to use now if you have downloaded the fire was to follow along. They are available in a link in the description off this video. If you don't already have them, you will need to go to the area where you have done load them to where you have saved them for me. They're here. If I click OK in goes the path and I will click OK again to connect to that location. And here we are. We have to see SV files and some information about them at the bottom. We have a few buttons to combine them. Loadem cancel or the one I want and always encourage people to go far edit so that we can get a look at a data stocks perform further transformations if needed. Always a good habit to press edit, and we'll be doing that with a without imports. Here are the two files again now shown in the Power Query Editor First thing you normally do in here is changed the name of the query in the right hand side. It company has the name off subscribers and I'm quite happy with that. So I'm going to leave that all I want to do is expand these two files said that the to see SV files will be stacked into one big table so that I can use that as my fact table. When we start creating reports where we have this content filled, there's a couple of double down arrows as a hover over its hell's me. That's to combine files button. I'm going to combine both these files. What this state is really good far is we can start using these filters on the headers. So there are other files in here I could feel to the CIS fee, falls out or could feel to buy some kind of date information, anything so that you get the ones you want for this folder because you might know one. All of them. I do. So I'm going to hit my combined fire was button. Here it goes, evaluating the Queary. That's just give it a moment, and we get an insight into those files. Don't they look fabulous? We have a date and Time column here already. This is the date column. We have the type of product. If it was a free, a premium subscription, a country code and how many years? And it's two different files. Here we have a new file for new subscribers on a renewal file for renewing subscribers. This is the new one. So no years the renewal will have. How many years have being with us? How many times have they keeps coming back and coming back? I'm going to check the box to skip Fault of errors at the bottom on this can be useful, especially if there is a potential that other users could be interacting with these files. Because if one of these files, new or re Newell's dot CS V, is open at this given point, that would interfere with Halley's data refreshes but kick okay, that's going to start stacking these or pending them into one at Monster List, and it creates these queries on the right hand side and also these custom functions and tables on a rightly consider a Siris of applied steps here, where it started to feel tone, invoking that custom function and eventually ended out of a change type step. Which, for any of you, her familiar of power query with familiar, very familiar with that step. Now what I'm going to do here is do a few simple transformations, really, just to get this up and working, the first thing I'd like to do is with this first column called Name on Gone to Remove this blot CSP part. I know one. It's there. That's the name of the file, but really Arkan uses column for the type off subscription. Was it every Newell or was it a new one? So I'm going to slip that column where it's already selected for me and on the home tab we have a replace values bottom, just like you find in replacing Excel. The value to find for me is dot C S V destroyed Akin, See, SV on. I'm going to replace it with nothing. Click OK, It ruthlessly takes out orthodoxy. SV's on. That's good. Now I can just see, with their new or freedom in on that step is added to the right hand side. I'm now going to double click on the column header so I can rename that something appropriate, like type that be a really creative and useful head up. Now the next step is with this date column. It seems to be recognized as date and time. You always want to check the data type of thes columns, so I've got text ago. Another to text. I've got a numeric one at any state one. Now I want to make that a date column, and there we go. We now have this information stored as dates only. I don't want any of that time information with it, and I think that's it. Just a few simple transformations. We have what we want in the top left corner as a close and apply button. For those of you who have used power Query, you may be used to seeing that button saying clothes and load, and you get different options about where you can load it to normally, such as a pivot table or data model or the table in worksheet. Here. It's quite simply close and apply, and that's a scant To close it and apply. Order those steps into the model so it doesn't actually load it to a worksheet in a way to exhale can. It's gonna load it straight into that model in the background, and he could see that's doing it here we have with just shy of one million Rose in that fact table where data table with just just loaded. Okay, that's in we can't really see at the moment because we're in this report view. But if I was to go over to the date of you and well, here it is his will a data and look at the bottom 942,000 and 79 Rose. Wow, Just shy off one million rows of data. A huge data set. It could be a lot bigger than this as well. But you see how power bi ire, You know, it took a few seconds to load into the model, but nothing crazy where his data that size you can't work with that in an excel worksheet. You could use power pivot in the model available of in there. It's not like excel can't do it, but Power Bi desktop was built for this big data. Powerful calculations. Fantastic visuals. Okay, let's go and get on next. Source of data. Get data. This one's coming from Excel. Gotta have some data in Excel with you documents. Foldout subscribers folder. There it is. It's called packages. Open up this Excel file on. We will get a preview. Here it is now. There are two things in this preview. The 1st 1 is the table. If a click on it, the table, it's only a tiny table. Hope you didn't expect much. There we have the package premium or free. So what type of subscription package, if they ordered freeze off. The free premium comes at a price 23 95 in the year, this year's worth of fictional data. We also have this other one down below on. Hey, it's exactly the same. So the 1st 1 is the table. This data is former. It's a table on the worksheet. The second is the name of the worksheet. That's the tab. The worksheet tab. Now I'm going to take the table. I've got it in the table, but that's why it's appearing twice. Load or edit. Always a good habit to go into edit first rather than just load in its straight in, although in this scenario I don't think there's anything to do, so we probably could have loaded it straight in. You can see the name of the query on the right hand side called D product. You see a lot of people putting letters D or F in front of their table or query names, said a day's dimension. It's a dimension table called product. I haven't bothered putting an F in front of my subscribers queer from before, which you see a lot people do. But it's a fact table, whereas others like myself here fact table. Just get a name dimension Tables get a D so we know they're dimension tables of was known as look up tables. This all looks fantastic, so I'm going to click close and apply, and that will get loaded into the model teeny, teeny, tiny look up table and let's go get more data. This time it's coming from a text file text slash CS V. There it is. It's jumped to the same location, school countries. The information about the country's the different regions, which we have managed to entice subscribers from. Here's a preview when Lodin for text file See what a previews are slightly different in their appearance, asking me what the deal emitter is. Year is detected. It's a tab we considers an issue here. The column header To have noticed that because this preview that's great. Let's definitely click on edit because we need to fix that. There is something to do here, although it's not much. Here's the data loaded on the right hand side. We can give our Queria name. Let me put a letter D in front off the names. It's a dimension table. And then let's go for a button to use first row as headers, which is on the home tab and that will load that first road into the header area, an issue that we identified at the preview step. And then we can close and apply this into a model so we have a lot three tables loaded on. We can see them on the right hand side in this field area, de countries deep run up and the fact table subscribers, and he can see underneath how it identifies. We have a date field and also a numeric field identified from that sick. My that kind of some icon, little bit misleading, just means it's numeric expecting you to use it in measures we can collapse out that we need those old expanded not that is doing any home. And if we now were to come over and look at things like report view, it still doesn't really look any different apart when you have the fields area on the right hand side. Here, too, I don't we have diagram view on. We can see the three tables loaded in here also. Now maybe. Let's look at my date of you again. We've loaded these free tables in with performs from transformations, making sure dates of former credits dates, making sure we cleaned up. Bring those headers into the top row, the robbers headers. But I've just noticed that in The Subscribers Fact Table, the first column could type renewals and new wonderful. But maybe I would prefer if they were in proper case. It's got a lower case R for in Newell's lower case in for New, You could actually scroll for order. Stay two separate away. Whoa! So you're squatting for hundreds of thousands and here's the new ones. All in lower case, too. Maybe I don't like that. Let's go back to the home tab. Edit queries that will bring you back to the power query editor on It's actually taken me to subscribers, but I could select the correct query from the left hand side. Here we have the type columns selected transform tab format button capitalized each word. Now that's what I wanted. This step is added to the right, and I can go back to our home and a close and apply and ALS these. Let's call it one million Rose. That's a little short from that. Will be reloaded into the model and accept pump for it right now and they're in. See, we have it. We have a free tables, data imported. In the next video, we're going to be looking actually building a pair model relating those tables. We need to also look at how to create a date table. So get their first glimpse. Awesome Dax formulas in power bi desktop 3. Power bi 3 model: Hello and welcome to this video tutorial from computer ghar ghar dot com and number three in the Siris on a Power bi I desktop introduction. And in this video, we are going to look at how to build our data model and also had to create a simple date table. So on screen, I have power bi desktop open, and on the right hand side, you can see the three tables that have been loaded into our model. So far. I'm company on the date of you, and you can see the deep product table, which is not too much to look at on the left. If I click on what is called the model view, we can see the three tables laid out as a kind of relationship view or a diagram view. Whatever words you may know this kind of you as now that's going to drag subscribers into the middle here because that's our fact table and opposition, my two dimension tables by the side of it just to the right hand side here, and we need to create relationships between our tables now to begin with with the dimension table for countries they are connected by the country code. Every time we get a subscriber, that table contains the code of the country they're from. And then we have this look up table, which shows the name of the country related to that coat. Now, if we click and drag from the country code from Dimension Table to the Table, thought subscribers, it will automatically detect and create that relationship a one to many relationship because we could potentially, and we'll hopefully have many subscribers from each country. We then have a similar situation with the product table. I want to click and drag the column, known as package to the subscriber's table when a related field is known as products there . I know that because of my understanding of the data, but I'm sure you could have guessed it wouldn't be price that's not unique. Or in this example, Ash. It is but in the package that is out free or our premium. So that's going to drive across and pick that up. So we have our relationships created now. One thing we are missing, we are missing a look up table for a date. If we want to work in some kind of time intelligence on do some analytics. That way, we need a date table so we can figure out how many subscribers per month for harmony in certain weeks or certain days of the week. We need this information. We have a date filled in subscribers table. But if we use that date field in our visualisations, then that's going to create date tables as we go, and that's going to clog up her model. So if we click on the modeling tab at the top, let me switch to Date of you first on, then looked at the modeling tab. That's haps. Could be contextual and change across the views. We have a new table button. No, we're going to create a new table, which is known as your date table, sometimes referred to as a calendar table. The kicker New table. We have to give our table of name, so I'm going to call it D date Damage tape of date A equals. Now, when we're typing in this formula bar at the top, things can get a little bit small and sometimes difficult to see, and in this video, or try and zoom into the easier to view for yourself, but another lovely technique you may wish to do on your own personal version of power. Bi desktop there that you're using is the whole down the control key on the mouse and scroll with your mouse will control and scrolled in the mouse hole where she zoom in or out of that formula bar, making the text bigger and easier to see So I can scroll way in a scroll way out to get something useful, and I'm going to leave it at that size there. But a family can zoom in and will be clearer when you look your brackets and your commerce like what is going on next, it can get quite small, especially working on a small screen. Now I'm going to use a Dax function called Calendar here, which has on type in tells me this could return a table off the column of all the dates between a start dating end date on. What we need is a date table that has got every single date for every single year from our subscribers fact table. We need this for a time. Intelligence analytics toe work correctly. Now we're not going to get too intense with this stuff over the Syriza's video going to keep things quite simple because this is an introduction to this and some of you watching this. You know, it's aimed at those who are beginners, but we do need to get a table of all those results now, in this example, the data were using. We only have one year. I think that year is 2018 but I'm just trying to remember what year I date a fictional data's from, but it is only one years worth of data, so we need every single date from the year off. I believe it's 2018. You see how it prompts me for a start date in an in date? So what a start. They need the first of January 2018. Thean date the 31st off December 2018. But I want this to be able to work. We're going to use the idea that wanted to be a tow work if I try and do the same thing next year, or if I try and load in dates from the year after. So for the start date, I'm going to begin with a function called date and then I'm going to put in my open bracket . So it promised me for the year, month and day. And I guess I could touch 2018 comma, one comma, one for the start date, first of January 2018. But instead, I'm going to use the year function right now to bring out the year from the date or half. So this could also apply, you know, for the following year, in the following year, etcetera. But open bracket it promised me for that information on, I will refer to the and started not a D dates table. That's the one amusing order subscribers table. That's where the dates are. Open square bracket. Now, you may be noting hither as on type in. I'm not gonna new lists come up. Typically, I would have seen my subscribers table Koppelman list, and that should have been a bit of an alert to me, Teoh some kind of issue that may be happening right now, But let me persevere because this is seen tactically, you know, kind of writing. Okay, here, not miss type subscribers and then going to refer to the date field, which is what it's called in that table Always expand the table on the right if I wasn't short Now, closing square bracket and a comma also are closing bracket before that for that year function. And then I have my comma on, Just like in Excel. You see how this list below walks me through the function so so useful. A loving, excel loving in power pivot. I love it in the power bi desktop. Any help with formulas is is always used for no matter what level you maybe it. The month is going to be one common. A month is going to be one. I'm going to closed bracket for the date function. Akama brings me out with this start day argument into the Ende arguments, and I'm just going to Korpi this date function of God and pasted over here and change it so that the month is 12 and the day is 31 30 1st of December Off that year is going to be the end close bracket on the end for the calendar function and pressing enter to run and I have an era I haven't alert in my fields list on the right. I always have an alert underneath, which can hardly miss on. Nothing happened, telling me that single value from the corn date from the table, subscribers can be determined and then advises me to use an aggregation function such as mean max council Some. Now you see people doing this a lot because quite often people are working with multiple years, were for data and then need to find the earliest in the latest dates within the data using . Now, I tried to be smart and thinking that I've only got one year, don't I? So nice and easy, but it doesn't work like that. I wanted to bring in some kind of aggregation function. So what I'm going to do is just before subscribers there, I'm going to put the men functioning one of the aggregations I can choose from. I could work of other men all Max, because I only have one year. But typically you had seen people use men here, so let's go for that for simplicity, you'll make more sense to people reading it on a close bracket on the in, so find the minimum. The earlier state then grabbed the year from the earlier state and the date function will use that over here will do the same thing. But using Max, I repeat, men would work equally well in my example. But normally you see a max function here. And to make things easier on the eye, it makes sense. If this is the latest state this go for Max, it just reads nicer. Make sure that closing bracket is there when a press enter way. We are working now. Now we have a list of every single date and year of 2018. Well, to say it more appropriately, or that it's the case now, every single date from a data set for every year in the data set. With that column selected, let me select it from the modeling tab. Buck. Now specify how I want it formatted some just going to slip dates. I'm not interested in doing any time stuff in this example. I'm then going to select what format I would like, and I just want a typical d d m m y y y Y format there. So I'm going to select that, and now we're going to create just a fume or columns for our data. So we have a new column button on the top. If I click on that button next up, what I would like is a month number, cities, columns bent, going to be called month number equals. And I'm just going to select the month function just like you get in, Excel and feed it The D Dates Table date column Now I'm in the D date table right now. Snap A. You seem a little bit weird to refer to the table when I'm actually in the table, but this is quite common. It is a typical ruler fund that when you're referring to a measure on, we'll talk about those in the next video. But when you're referring to a measure that you just want a name in a measure, you don't have to mention the table name. But you mentioned a field. You mention the name of the table and then the field. So, though are mentioned, I'm referring to the date column, literally next door to me. I'm still going to refer to the table that it's in so it's deduct date. You can double, click or tap that closing bracket. In the end, it's come jumped ahead of me there on a month. Numbers, Aaron. Okay, Next column. This one is going to be month name when it comes to report in are more likely going to show the name in a month since its April or November robin and four and 11. Although everybody understands what they are, it is just easier to show the name is what most people are gonna want to read. It has so the month name for this, we're going to use a Dax function called format. This is the equivalent of a function called text in Excel, which have produced videos for in the past. And you might be familiar with If you are the good news, it's the same. The value on checking is the D dates table, date filled, comma one about it. But how do you want it to look? Well, in these double quotes, I'm going to ask it to be in an M M M format show the month in a short hand text fall it four EMS would show the whole month name closed back in. Enter on. In they go. Now what we now need to do this is what we need to do is we need to tell with a month name column to be sorted by the month number column because if I use the month name column in my visuals, which are will be doing, it won't sort them accurately. It was sore a pool to start with because it would do in alphabetical order. Now, when you use this kind of stuff in Excel for use month names, I refer four meters offering pivot tables. XO understands it because there's the custom list, both for days of the week and awesome for month names. But here it does not know that. So I'm going to with the month name selected to sort by column and tell that column in to be sorted by month number. And then we're going for another column. New COLUMN This one is going to be for the week number. It's against a weak number. Equals there equals Emma Guns use a function called Week Day. Once again, it's the same is an excels and experience you have. It's beneficial. Here it returns. A number from 1 to 7 identifies a day the week. Now, if I want to perform some analytics to see which data week tend to get the most subscribers , which died a week, to get the least and what's the difference between them? If I want to know this stuff, I need this information in my date calendar date table. So week day it prompts me for the date discovered. DD dates. Here we go, and then a comma leads mints, returned type on and can resize that it's like a can, but one fruit Sunday or the second option is Monday's one fruit. Seven. It's Sunday, and that's what I'm going to have. Mondays one Sunday to seven. Let me do that. Closed bracket enter and now I have a weak number, which can be used. New COLUMN. I've got one more column here. This one is going to be the week number, Name just started, month arm or likely going to be happy reading it as a Wednesday or Saturday as opposed to number free or number six equals format. Open bracket Very similar to the month Name. Here. De dates Date column, a gain comma, same situation. I'm going to go for the free days here. Just I could deal with the month close bracket. Enter now. That's useful for our reporting And then once again, I'm going to offer a week number. Name to be sorted. Bye week number. Don't be confused by the alphabetical listing. Use the week number is the way that you order that. Okay, these are only the columns that I want now, typically in a date table, you may see people crying columns for the day number and for the year number for quarter's fiscal quarters. Weak numbers of the year. It all depends what people are planning on using it for. Here. This is all I want, keeping it simple. But you get a logic incorrect. Many columns you want here one of the finger will need to do is Mark. This is a date table. This will stop power bi desktop, creating these invisible date tables every time a user date field in the visual. There's a button on the modeling tab to the right for it markers date table. It will prompt me. What column to use. And it's date. Yeah, I want to use. So I'm going to choose dates here. That's two column from the date table. The first column. I click. OK, that is confirmed. And if we switch back to our model view. There's a new table with their columns that's drag into a position and drag between dates to date or day to subscribers is up another one to many relationship. We could have multiple subscribers on any given day from the date table, so and model is set up ready to go. Next optional thing we could do before this video ends is you could choose to hide certain fields from the report for you. So, for example, with the month number on the week number fields, which we used to set up the sort in for month name, week name. If we don't need those, I could right mouse click on the field and hired in report view right click Hide Important you. You could do this for anything that you deem necessary in any off the tables. If you get any key fields that you don't want to show any measures that you don't wanna show on, we'll talk about measures In the next video. He could even slept a bunch of time using a shift key. For now, though, hide in those two fields. I don't need them in the report view, so please don't clatter it with them when they're not necessary for switch to report view right now and look to my right in the D dates table. Those two fields are not showing. Only the free that I asked for are shown in the next video. We're going to start getting a little bit mawr involved with Dax. We did some debt cap tax calculations here, but we need to start adding and counting the average in and started getting some aggregations going ready for our visuals. 4. Power bi 4 dax: Hello and welcome to this video tutorial from computer guard guard dot com. And this is video number four in a Siris on an introduction to Power bi I desktop. And in this video we are going to be writing some Dax formulas to create some measures. Now there are certain questions that we want to know from our data here. We're going to solve those by writing some dax and then in the following video, we're going to stop creating visuals on their dashboards, ready to publish some of the questions we would like to know. Firstly, how many subscribers did we get this calendar year? We then want to know how many of those subscribers subscribed to the free membership that we offer and how many of them took up that premium subscription that we offer. We then want to know the total revenue. So there is a charge for that premium subscription, and that is coming from our D product dimension table. And we want to total that I want to know the total revenue and then would like to know the percentage off the subscriptions that were premium out of that total. What percentage were premium So they are our five questions to solve with some Dax formulas right now on. Well, then, look at how we can use and reuse those both in other measures, but also in our visualisations. Now, the first thing I want to do I mean, my date of you at the moment is click on the subscribers table on the right hand side so that that is the active table and then to the modeling tab above. I can click on new measure and that will open my formula barter like my first measure, and he can see how it begins to appear within the subscribers table. Now, this 1st 1 is the number off subscribers that we got. So I need to toughen name for my measure and old quarter total subscribers a course. So when you write a formula in excel, when you begin with the equal sign, we're kind of beginning with it here. Now, name of the measure equals to kick start the the calculation aspect of it now going to use a Dax function called count rows. Remember from a previous video that when we are writing in this formula bar, we can hold down the control key and scroll with our mouse will to increase the font size and zoom in on this formula bar area. A really handy little short cup count. Rose is what I want. I'm going to double click on that function, and you see, it prompts me for a table. This will just simply count how many rows or in a table. And it works for me, are wants, know how many subscribers. So I'm just going to count the rows in the subscribers table and we double click on that Close off my bracket, Empress, enter and the measure is created on the right hand side in my subscribers table. First measure is done. Now, if I wanted to test quickly, If that measure appears to be working, there were a few different ways of doing net. But a nice quick way would be to switch to my report you and just drag that measure onto the page, and it will quickly create a visual. It may not be what you Ponton may not necessarily be what you're after, ultimately as a visual, but sometimes this can give you you know, that the idea is whoever it seems to be working or not. See, it's just shy of one million. Never hover over 94 to 079 94 to 079 I'm going to delete that visual and go back to my date of you. Look it out of the bottom 94 to 079 So that 1st 1 we've got an absolute confirmation. That is how many there are next up. I want to know how many free subscribers so make sure my subscribers table is active. New measure, this one total free equals and I'm going to use Count Rose again. Tap keys are narrow down. This time, though, I'm looking for a subset off that data set. So not looking at how many in total I'm looking how many were free. So I'm going to bring in the future function. This will allow me to provide a boolean expression and filter into a subset of that data money looking at a specific range from there so the table will be subscribers comma. The filter expression is going to be if subscribers and I am testing the product field is equal to free inside double quotes, closed bracket filter function close bracket for the count rows function. Press enter, and we have ourselves another Dax expression. What I will now do is a quick selection off that, and I'm going to take a copy of my control, See keep would choke up. And then, with my subscribers table selected new measure, I'm going to just place that in with my control v shortcut. And I'll just change free to premium Onda free to premium over here so that we can get a total for the premium memberships. So when we are creating our visuals on were put to them into our column chart sorelle matrixes, and then we'll be able to add slices and a lot of you watching this video, even if you might be new or kind of beginner to power. Bi, I you may well be quite familiar with pivot tables on with the use of slices, and obviously we can provide filters through things up slices and through, you know, the axes of a chart on that provides that filtering aspect, and I can still do that to the result of this measure. I'm just kinda hard code in a filter into it. This will only be premium, and then you could filter it any other way you want through. Other filtering tools are available in power beyond so there's free of our questions done free of the measures Ordinance subscribers Table Way of the subscribers Table Selected New measure. Next up. Total revenue, some guns, according total revenue. A quos. Now I'm going to reuse my measures here. So is a default role when you're referring to a field in a table like AWAS. In the previous measures, I referenced the name of the table subscribers and in the field within IT products. Right now, when you're referring to a measure, you only reference its name. So even on a measure exists within the subscribers table, I don't mention the subscribers table. This makes it easy for people when they're looking at Dax to know if it's a reference to a measure or a field of in a table. So I want to know if I want to know total revenue. What it is is the number of premium members multiplied by the price that we sold at now. The price is inside the deep product table, and the number of premium subscribers with just calculated that we just created a measure that does that selects refer to it. Total premium. There's the measure. Double click and notes. A measure has square brackets around it, just like the field of a table does. Which is why I emphasize when courage, the use of putting a table name before filled. Not with a measure. So people looking at this no no table name must be a measure. After that, multiply the asterisk, and I want to refer to the D product table. Open square bracket price. Now, at this point, as I'm typing, it should start ringing alarm bells because I'm typing on. I'm not getting any list helping me select a field from D Product on. It was doing that in the previous measures, but it's not doing it now. Let me carry on price close square bracket and I press enter and I'm getting an error. A single value from the column. Price in the table. Deep corrupt. So we did understand my syntax there that I was referring to a field in the table, but it tells me it cannot be determined shouldn't have been a surprise because off the lack of assistance always getting asked me to provide an aggregation function. Now, inside the D product table, there is only one. Price is just one rogue. River Price is not like we've got loads of subscribers that we're doing a fact table, they said. I mention table. So you know, I could use the Mac's function or some this. A few different functions are confused, really. But if I go back to my total revenue measure, you can see on the right hand side here the warning sign indicating that it's not happy. Let me click on it, come back into my formula, and I'm going to throw the some aggregation function just before it. Some open bracket. Look how it's quite happy with the list coming up now. Closed bracket the other side press enter. Now it's working. Total revenue. The measure is done. One more measure to go. How many off the subscribers as a percentage were premium. Make sure to subscribers tables selected new measure. Last measure here. Percentage premium equals now to know the percent is at a premium. We want to divide the number of premium subscribers by the total subscribers that will give us that percentage So if I do total premium divided by total subscribers using the measures that have created just referencing them and press enter that gives me that result. I can check this out by going to my report view and Dragon Percentage premium onto a page, and you can see I get nope, went for one in a decimal. There's a percentage at the top, so that quick little column chart shows me that that sounds about right, nor point for one if you had an idea of your data, so that is working fine in this example. But for gun back to my measure here, What I would like to mention is a really useful Dax function called Divide because alone quite happy divide in here. And it's working as you might you know, from using Excel that you can throw up, give slash zero errors and he can get issues When you're doing things like divisions Now index, there is a divide function on this, as they called it is the safe divide as the ability to hand order divide by zero scenario. So unlike Excel, where we may throw in if error functions or something to try and avoid those potential issues of blank sales and zero sales. So in divide function, I haven't put my bracket in. There goes the numerator is total premium measure. Comma. The denominator is the total subscribers measure. Come on, the alternate result out instead of an a right if they're zero. I was just going to type a zero in is not happening in this scenario, but that's that's my alternate response. Close bracket and enter, and there is no real difference here for went batch report and drag that in. I've got another note point for one, but that is a useful alternative. If you're doing a measure like that, issues that divide decks function, something that don't get in excel. It's really nice tohave, so we have five measures set up. You can see them in their table with a little calculator icon next to them, indicating to people that their measures we are going to be using knows to create some beautiful interactive visuals in the next video said, Stay tuned. Check that out, and this will be the culmination off this power bi desktop. Siri's 5. Power bi 5 visuals: Hello and welcome to this video tutorial from computer ghar ghar dot com. On this is the final video off our Power bi I desktop introduction. Siri's where we will look at creating two simple dashboards and looking at some of the more useful visualizations that you offer on their interactivity and and finally, how we can share that finished report. So we have the measures from the previous video five measures, and we've also got four tables that are all related. Here is our model view as a quick reminder off that on Let's switch over to a report of you to start creating our reports. Now, at the bottom of the screen, you can see we have one page a moment. This is our first dashboard and what I would like to start with awesome cards along the top . Now there are a couple of key ways that we can create our visuals. You can have a click on a visual for the visual ization list and then start to build up in a way that you would build a pivot table. Or you can simply drag a measure or label straight onto the report area until a page and a visualization is created, which you can then edit. So that's kind of ever look at both. I want total revenue to begin with and then to click and drag total revenue the measure from the field list and dump it roughly where want this visualization to be on my page immediately. Visualizations created Show me the millions that were brought in in revenue in this calendar year. If that is not the visualization that I wanted with its still selected. If it wasn't, I could go and select it in the visualizations area. I will choose the one that I want and I want a card. As our hover over the visualizations. They will tell me what they are so that I can to quite small. If you can't tell, they will tell you and there is the card. There's some fantastic visualizations here. We're not going to get a chance to look at. All of these were just gonna look at I think about six or seven. And there's also the idea that you can create custom visuals and download custom visuals. So is one of the biggest areas off power bi I. It's probably his greatest strength verses. Power. Pivot on, you know. Have you been working? Excel? There we go. Card Done. Just little over nine million total revenue. Let me resize this card on. Then when your editing visualizations with its selected over here in the visualizations pane, I'm currently in this section of field section Organ start toe change What is displayed of in this card? If I click on the next one along this kind of paint roller icon, this is how we form that our visuals. And this will get a bit more exciting when we start. Welcome of charts. And the visuals are stronger because it is quite a lot of options, even with just this basic kind of text card. Now, I would like to put a board around it. The border is company set off, but quit. Their little icon turns it on every click away so you can see that lovely border. Okay, next up, let me do the same technique. Next up, though I want percentage premium measure, drag percentage premium. Drop it onto the page, change it to a card government, my border on format section, border on and no resize it and look at this Wow as we re size. And look at these lions coming up to help us resize, actually, boom, That the same size. Very similar to what you get. So the the alignment is what I meant to say. There very similar to how some of you may be used to envisage a or in power point. So I really Yeah, great. Simple way of a line in these. Okay, I've got one more. Such no point. For one, there is a percentage that show me as a decimal illness. Not really too keen on that. So what I might do is if I come over and click on my percentage premium measure and it shows me the measure again, back at the top so I could edit it. And I'm going to change the format to this percentage. Former. Okay. And then I'm going to take out the decimals or fingers, remove my decimal places on. That's what we want as a percentage. So you can still go back and edit your measures even once the visuals on there is not the end. You haven't got to go back, delete the measure created again. You can simply go back in Eddie over the calculation or the former off that calculation. No problem. So we've got that one. Next up. Total subscribers. Now, whenever you bring a visualization in, it's a good idea. Toe klik somewhere on the white space. Because if you've still got a visualization selected and I went to click on something like a custard bar chart, it changes my visual to that chart on. Now Go and switch it back to a card. Maybe so. If you kick in a white space first, then you can go and insert your visual. Now Robert and Dragon. This time I'm going to click on card. It dumps that visual on the page, I contend. Drag it into the space. So one do my alignment and whatever else you may want to do to it. And then I condemn side what it's going to do, and this is going to be total subscribers. Aiken tick the box or drag that into the area. There's not so much here of cards will be more with charts Underground Taylor box because of that, and it's seen so just like pivot tables where we can take a drag. But most people drag former area border on. So I've got three cards along the top giving me some coming key metrics. Kind of KB eyes or targets, if you will. Summary detail. So I've got a total revenue percentage off total subscribers that premium and and also the total subscribers. We could argue that it may make more sense if I move these around. Actually, how many subscribers in how money off those were? Premium seems like a more logical orderto to think so. David, let's stop bringing in some charts now on a simple column charge. Going to click somewhere in my white space. Click on the Clustered column chart, just like you guys may have used in Excel before. We can do some resize in, but Mom make a bit more sense. Mints. We got some data on that on his column chart to show side by side how Maney free subscribers Hamli Premium subscriber. It's so I could go and take the the measures over on the right hand side across a drag them in. Let me take finish one total free Total premium knows what to do. Dumps him into this value area because their measures resize thistle little bits, maybe, and then we can start making some edits. So nice simple column chart here that Mia lining up coming over to the format section and in we go. And I don't want this title at the top telling me over these at a total free total premium . I kind of know that. So over here, while I'm not going far, where is the title? There it is. Title off is gone. I think I'm gonna get rid of my axes as well discovered that y axes done on that. That's bringing some data label with its turner on a girl was expand these sections to make further edits to those labels. No color. The units are displayed the size stuff that you guys might be familiar with to some extent through for use of charts in excel or other products and offering hoco happy. But does he have a board around it? No, it doesn't. I'm happy. I'm actually one more former I could do here is I could come back to former and look at the data colors. You know, you're not happy with that default style here. I could come in and say, Look what I want now driver, this kind of bluish color and the other one to be like this kind of bluish color could start making my own decisions. Right COLUMN chart in Let's have one more visual on this first page, and I'm going to go for a map. We have some country data. I want the visuals. So I'm going to the white space to the map icon. Click the map, drag it into position that say, I want this about here. I could make it bigger. That'll be lovely and I will bring in what we want. Look at the amount of fields now. Now it's getting a bit more intense in a good way. So country field just expanded district country into location. That probably seemed a little bit obvious. Or let me see this map, this information. But then we're going to need something to chart. I want total subscribers total subscribers into size. Drop it in there. This will hopefully map this real soon, okay? And it doesn't seem to be working, so let's have a little explore. I've got my map in. I've got this size and they're the country. Let's go back to our model view And there is that relationship between the countries and subscribe. It's so why doesn't it work now if we double click on the line? Oh, look at that. As our hover over a country code to die tights, they don't understand each other. The relationship is broken. Then we double click. This will give us a chance to edit that. And look at this. That shouldn't be date. That should be country code for Click on that, The codes or the match. Oh, Nell, Click OK, and come back to my report view. There was a mistake in the model. Let me get this company and I'm going to delete that visual on again to reinsert it country into location subscribers into size. And hopefully this will work a lot better. And here we have it. Our Mac. Sorry, the first finger might want to do is get rid of this header again. So with that map visualization selected over to the format area, turn off the title and it may be all resize this map a bit more to get some more space from it. Have got these bubbles representing the size so you can see a country in Europe there and also in the U. S. A. Are quite large square. Largest bubble over there as well. If a wish Akan zoom in on this map and scroll around the map and we can see it's Germany. That's one of the largest bubble going. See that the French and U. K. And Australia bit larger weaken drag around as the U. S. There's Canada and also zoom back out to see his match was little ism mapas. We need to let me re size that's tryingto cough their age anymore. Hey, big guy. Oops. Give me to drink that instructed by his age here we got Okay, So what else can we do with this? Well, in the format section, if you wish to weaken, start editing the size of the bubbles. Now, groups have a little bit cool up here. Bring that back to one. I could change the color off those if you're not happy with that default color Eric. Options for heat map. Lots of stuff to play around with putting a border around it. Never switch back to the fields area. Something else wanted to demonstrate. Here was this tour tips section and we could do this with with other visualizations to. But using this is my example. I want to expand the subscribers table on. I'm going to drag total free, total premium and also total revenue into tor tips. So as our hover over the bubbles, this little taught it will pop up and tell me what country that is. Hamli subscribers because that was already in the size filled. But then also the stuff the information I just dragged in their total free total premium total revenue. I can do that for anything of our hovered over the USA. There's the revenue in the free and premium that Harvard down here into South Africa or went into the jumble of Europe and hope that one's Denmark. Yet that's a total free. Put such a premium, and we can get our information that way. Want to see something else really cool? Let's click one like Australia. Whoa, look at the interaction as soon as I click Australia. The three cards at the top. So 52,000 subscribers revenue just over 500 k And look at the visual on the left. Changes well for click inside Europe here who is that that's Bulgaria and look at the visual change 1 to 7 K 13,000 subscribers to click on the U. S. And look at how it interacts with everything around it, absolutely bringing a little drop on the percent supreme. There's been 41% for all of them apart from this one. That was Sweden there, and we can actually change how that interacts as well. So this is the interaction that I was talking about on with the visualizations selected. If I come to the formats, tap on the visual tours with this Eddie Interactions button and if I turn it on so a bit like the bold button and exhale weaken total arms huguely off as a talking on local order visualizations that would have these little icons at the top of them. Looking at this column chart one. There is an option for none, so I don't want any interactivity with it. There's option forever. The interactivity is a highlight, which is what it's doing at the moment. It is highlighting that amount on the column, which is very, very small or the option for a filter. Now I'm gonna click on filter instead So now when I going click on Canada, it's the death highlighting it theaters. So if the changes to the cards above But now I can see the difference in free in a premium . And if I come to click over here, then we've got it for this country and click over here. And I've got it for this country that are filtering that column so we can choose if and how the interactivity is happen between each one. So that is really, really cool. So a little bit on our map here, what have do encourage you guys? You know, there's links to the files that I'm using in the description of this video. If you haven't already grabbed that data or grab some other dates you have, we can get online and just play around with this stuff. This is how we're gonna learn the volume of visualizations and the options available with them that we have now. I've got one dashboard at the moment, one page letter double click on that page tab so I can rename it just like we do sheets and excel on. I'm going to call overview and then click the plus sign for a new page or dashboard double click on that and I'm going to call it time. Andi. Um, I think it's that kind of product breakdown products break down. So not the greatest names. It's just what came into my head and we're gonna look at some of the visualizations on here . I'll click in the white space is a good habit. I don't want to bring in a line graph line. Sharks this. Bring this in. Haven't looked at this kind of stuff yet. Now, this is going to be over time. Here. Some fields for axes, legend values and talk tips again, like a demonstrated with the map. Visual. Now, in two d date. I haven't done anything with dates. Really? At the moment month Name this we created with some data analysis expressions with some Dax formulas. Let me drag that into the axes so we'll get the mumps up names along the axes. Remember how we sought to do in the right order and that as well. Now I want something to plot in the values I'm going to plot Total free and total premium. Here we go months along the bottom, like a normal line graph legend up there and we've got a plot and look at how can hover over and get these tour tips as well. So that is a nice visual. Let's look at what else we can do. Click in the white space. Come off that visual. Let's bring in a pie chart. I'm gonna pie chart yet. Maybe we want to use this to show the contribution off the how many of these subscribers are new and how many of them are returning their renewals? So that is the type, I think so. I'm going to drag type into the legend area and we need something in values. Toast of total subscribers. Here we go. So the total subscribers that now broken down by the type which is new and renewals got their title The top, Remember, you can turn off these titles. I don't want to dedicate too much time to this, but I'm gonna pop back to that lion graph and get rid of that title. Look at all the volume of options, but I want to dedicate too much time. This is where you can kind of play around with this. More interested in seeing what visuals we've got and some of the more important settings at formatting. We could be here forever, but we've got these labels and there the lines to them and all stuff you may be quite familiar with. Now, let's imagine I was looking at a pie chart for or actually, doughnut would be better. Remember, we can click on the visual click a different one, and it was just change. What visuals using. And now I've got a doughnut instead as ah, hover over different parts, I get the information that is 59.87% said it's called it 60% and 564,000 renewals for under 78,000 mules at 40% for those that I could bring over information into the talk tips area. Now I'm going to resize that a little bit and use some space here for something else we haven't spoken about yet, Which is a matrix. They're quite popular. That's hover over of visuals and get some help. There it is, straight away. It's similar looking icons nearby. It click on the Matrix, drag it where I want that strike. It here used to love the ways of rape of a lineman to help me right now for this one, I'm going to bring in the country's on countries in the rose area a Z species just like pivots papers. This really is just like a pivot table. This matrix Andi, I've got that in there. I need something in the columns area what I want In columns area. I want the product in their strict product into columns, Frame premium. And then I need something to plot total subscribers into values. Maybe God and I can resize is a bit more if I want to try and fit few more countries in, but there's a lot to go. So we've got the country's got a free and premium breakdown and just like we saw in the previous dashboard The overview one. I can interact if I click on Brazil. Whoa, look at that interactivity. That lying graph adapted, and so did the doughnut off. Still got the edit interactions button switched on at the top so I could come in here and say, Look, don't do the highlight. Do a filter. And now when I click on Canada, it field is instead France. It filters Ireland. It filters never hover over conceded values just shy of 8000 for Ireland, 60% of them Austria got 16,000 at 60%. That is some good percentages, and I can click elsewhere in this. They're gonna be careful not to quickly headers That would really to the country's. But I which could be useful haven't. But if I click elsewhere outside of those that remove that interaction that I've got so we can decide what it's interaction we can choose which visuals are affected by the interaction on this air matrix A bit like a pivot table. I was just another visual that wanted to demonstrate now for my final ones something that you guys may will be familiar with for excel, for clicking My white space is a slicer and this is your icon. I can introduce a slicer And I could bring one of these in right now to show what I wanted to show. I wish I put in there that the slicer I could use week name, week number, name Let me take that. This is something that we created without addax formulas in the deed a table And if I tick Saturday. Everything reacts. So this is what's been going on. On Saturdays, I break down. All of the countries have any free premium totals overall. Gotta totals down here for Saturday's taken Sunday, a little bit more on a Sunday choosed I on the line. Goff is changing to a riffing, interacting with their slice out with each other. Incorrect as many slices as you want. I could bring in another one for free and premium or whatever of the data we have to hand just like we can va pivot tables. So let's imagine that this is our finished dashboard are finished. Report to dashboards. One report we want to look at now sharing this well, First of all, it's a good idea to save what we've done so I can click my save button. Now. One way we can share it is just to share this stop P B I X file. So I've got this file just like having excel fire or a word document. And you can just share this with anybody else who has power bi desktop and remember, it's free. So is there really a reason for them not to? In they can view and interact with your reports. That's one way just the usual way. If you don't mind me calling it that I could also come up to the fire or tab on. I have an option to exporters. Pdf. So if I click on this is going to do what it says it's going to do is going to export as a PdF. Let's let that generate that and we're gonna get a nice PdF it. So obviously, the bad news with Pdf says that there's no interactivity, which is a big thing, but we do get a kind of snapshot, if you will, of that point in time. And as the A. PdF is viewable by pretty much anyone on any device no special software needed or you expect them to have the need is pretty much a standard thing. It's not a small team to share by some kind of messaging or or email services. Well, that's another option, and then the other one is toe Publish it to power Bi. I don't come so we can do it for you to file menu but is also a publish button waiting for us on the home tab. There's also by the way, some nice themes didn't mention themes could switch this to a nice twilight fame and Robert a new messing around the format and the colors yourself as quite nice. Little bit of a fan of 12. Any white at publish button. Clear Call Nats. You want to save changes for sure. Don't lose that theme Doi on, but it's published to a destination. I have a workspaces. Publish it to that workspace published, published publish Did you know? Let's get this going on success. I could open it directly through this link, or you can just go to your browser. Want on log in tow or the app on your phone log into it. Have you wish? I'll use my account. Give a click. It will be embarrassing on no, it become. It's logging into my account here and here it is, and it will be fully interactive so I can interact with my slices. I can access the other page at the bottom for the overview page, and I have published it too. Power bi dot com where I can log into this from anywhere, including my smart phone and my tablet using the power bi app, which you can also get from the marks of store to view your reports and to act system. That was where and you see the options along the top to edit on also to re fresh as well. So if people are editing, the queer is in the background when I can change the visuals and it's gonna be refreshed. So we're spoke in a previous video, the 1st 1 that there are different versions off Power Bi desktop. There is a pro and also premium version which do offer extras in a way that you can collaborate with other users of in your business and share reports. This is just looking at it in the free version. Anybody can get this and do this right now with the data that I'm providing, what other data that you have and you can learn the same set of skills. We can still share this report as demonstrated and free different ways Here. There's also an option to embed it to a Web page as well, but you can get more for the extra paid services. So hope you found this series useful as an introduction Toe power bi desktop, please go out there, play around with it. Let me know what you think of it in the comments section, and please check out some of our other videos on a YouTube channel and come see us a computer goggle dot com.