A free video tutorial from Parker Stevens
4.4 instructor rating • 1 course • 31,132 students
Learn more from the full courseLearn Power BI Fast
Build a professional Power BI report in less than 2 hours. Learn data visualization basics and advanced techniques.
01:53:42 of on-demand video • Updated February 2020
- Build a Power BI report from scratch
- Create calculated columns and measures to create a more robust data model
- Use advanced DAX in order to perform complex calculations
- Style the report to make it beautiful and fun to use
- Push the report to Power BI Service and configure automatic data refreshes
- Download and install Power BI Desktop and SQL Server 2017
English [Auto] All right so now we have three tables nor related to each other. So that's really good. Let's go ahead and create some visualizations. First thing that I want to do is I want to bring in a bar chart barters are really good at getting quick information down on the paper. So when you create this visualization it comes up with a list of fields that you can add data to in order to show different things with your data. So go ahead and go to them customer and it has a field that is number of children at home. Gragg then the access. And for the different divisions of children at home I want to go to fact internet sales and take the total sales amount. Put that in a value and there's your first visualisations make it bigger. This is really interesting. We can see that people who have zero kids at home spend a lot more money than people with five kids at home. And there's really not much difference between 1 3 5 To be honest. Let's take a look at how we got here real quick. We put number of children home on the axis so these are the values supplying the x axis and values kind as the a word for the y axis here to make this visual a little bit more informative. Let's go and add something else let's add maybe Jinder to the legend this will now show the division between female and mid in their spending habits. So already in what seems like three clicks we have a pretty informative graph that we can draw some insights on that we can see that you know people with you know less kids may buy more maybe it's cause them or May has spent on a not. It's almost even as far as the division between men and women sales go. So that's a BART Herald's clinical line chart. Make sure to click off the graph. If you were to click on the graph and you click on a line chart it would change the chart type. So it's going leave it as a bar graph click off and click click and line chart. It's like there's a little bit bigger three here. What we want to use Let's go let's make this do sales over time. So in order for that we're going to need sales out there that are in there when the values the values well and for date. Let's go ahead and put a date by default. The dates are always going to show us higher keys. And what I mean by that is right now it's showing your then if you drill down into it show by quarter by month into my day in order to drill down you can click pretty much any of these three buttons this button right here will turn on. Drill down and turn it on means now double clicking will drill into what I'm looking at to go in. I'm on 2013 to stay a point and we drill into it and that shows the 2013 data. That's what hierarchy's do it enables you to see different levels of your data. You can drill down on all of the different categories. So now we'll see all the data from those 12 to 2014. But the next level drilling down further will take us to the month and drilling down further it will take us to the day higher. These are cool but they're very situational. I prefer to right click and click on order date. This is how you use the date data instead of the higher he by itself and dates can show in two different ways. If you go to x axis it defaults to continuous. That shows all of your data all on one graph. It'll fit it to the size of the window no matter what. If you change this to categorical that will show you a more detailed view of your dates with a scrollbar to show you everything. It's a little bit harder to see trends this way so I'm going to leave it as continuous. And before I get 4 I'm done with that. I want to go to the factoring and sales table and change the order date to a format that I would I would much much prefer. So let's just do a date format. Let's get it this way here let's now go back to our visualization and let's going to continue to work just to see if that categorial see that change with there. Yes and it looks a lot better. But all of that continuous. And that's a line for her to recall we can at the same level of detail it did for the bar chart. Let's go ahead and throw in marital status or let's throw in gender to keep it keep it the same. So now we can kind of see a difference although you can't really draw much insight from that. So now is really cool cool part of the outcomes and so part as all about filtering things and visualizing data in a really cool way. So you can click on almost anything these graphs. So our legend up here is totally interactive. I want to see the men cook on the M and it highlights the man in this graph and highlights the men in this graph. Or you can see a females show you the female on the other half. Let's look at people who only have zero kids and are female. You click on that or you can control click and select the rest of the people and basically everything that you're clicking on is a filter. And if you ever need to get rid of filters there's usually a race button on slicers. OK. So let's show you another kind of chart that's commonly used which is a pie chart. And use this at some point your life both when you done at chart because they're different and cool but they're out there. Let's look at people's occupations which will throw in the legend. By order by sales I'm out again. So now it's kind of a theme. So if you make it bigger we can see that professionals make up most of sales whereas followed by skilled manual and clerical showing you again how filtering works clicking on females over here now shows you a smaller portion of that and males make up the what about the other half. I don't turd's are a very interesting way to be able to visualize percentages. Let's finish up this lesson with a really cool visual. It's a map. We have a couple here. This is my favorite map using SIM city state postal code. Pretty much anything that can define a location you're able to show them map is really cool. I'm going to going going to go ahead and show States through that and the location pane you know come up with this little map right here and it shows the states that have data in them a lot North America gets mirror up and some in Australia. I am going to for this particular visual you can shade the colors of the states based on an amount. So again since everything is about sales here I mean put in sales amount for the courts that. Kind of hard to see but you can see that different states have different colorings. One more thing I'm going to do so that this map will always show up on on the United States. I am going to put in a custom filter here. So in the filter's pain this is where you can add different filters to your visualizations or your page or the report as a whole and be able to show the data just the way you want it. I'm going to come to in geography country region I'm going to throw this at the bottom of the filters. And now we can select which which countries show and first to select all. So we can but I just want to show the US so that zooms in only in the U.S. because that's what I'm filtering on through the Google maps are an awesome way to be able to visualize data and how spatial trends. So those are some basic visualizations. We'll talk more about others in a little bit. Does want to get your feet wet with some of the most common.