Define quick measures Hello and welcome to level eight, the final level of this part one, which is all about visualizations. Now, in this level, what we’re going to do is look at all the other things that we need for the DA Dash 100 exam that don’t quite fit into the rest of the course easily, or some of the topics may be quite difficult, or some of the features actually knew and have been introduced into power bi. After this course was first created, and with Microsoft introducing…

Sort and Filter Now it’s possible that you don’t have the data in the order that you want. Especially if you’re going to reduce rows by removing the top few rows of the bottom few rows. So maybe you didn’t want the very first ones where the foul name starts with the very start of the alphabet 000102. Or maybe you wanted this columnist number, a column to be sorted in the other order, descending order. And then you can remove the rows that you don’t want. Well, you can…

Welcome to Part 2: Get and Transform Data Hello and welcome to part two of this course. And in this part we’ll be looking at the Getandtransform section of Power Bi, which uses the M language. So you can see that most of what we’ll be doing is in sections one to three. So we’ll be getting data from different data sources. So really from now, all we’ve done so far is used Excel, and we’ll be continuing to use a lot of Excel simply because I know that’s what…

Merge Queries and Expand Table In this video we’re going to have a look at merge queries, the first of the combine. And what I’m going to do is I’m going to get rid of almost everything that we did in the last few sections. Just have it so that we have our raw data. So these are our filenames, this is the path which contains the album. Now you can categorize these albums. This one for instance is a sampler. It’s got music from all over the place. Further…

Practice Activity 11 – The Solution So how did you get on with this practice activity? It’s a simple practice activity, but we are going to go deeper into unriveting in the next video. So it’s important that we’ve got this basic one done. So let’s have a look at our data source. And we’ll be looking at the Pivot HPI regions, so not regions two or admin ends with the regions. Now there are two blank lines at the top which computer ignores. And then we have got a…

Transform – Table and Any Column In this section we’re going to have a look at the transform menu and specifically tables, any column, text column and number column. There will be some revision in this, partly because there’s revision in here already. A lot of this is in the home menu that we had a look at in the previous few videos. So I’m just going to load just for this video, the CD DS and just have a look around at the start of the transform. Now you…

Transform/Add Column – Number Column – Statistics and Standard In this video we’re going to have a look at the transform or add column number functions. And there aren’t too many surprises here. So first of all we have statistics. So some main max medium average standard deviation count values and count distinct values. So what that will do is transform what you’ve got into just that. So here we have the sum of the average price. Now, the formulas that they use is not that surprising, it’s list sum…

Transform/Add Column – Text – Format Activity that we just did. I created this year analysis and it’s looking okay, fairly good. It gives me information. It gives me, for instance, that east of England and southwest keep changing places. But the thing that it doesn’t quite do, if you have a look at the months is have the months in order january, February, May, April, March, June, July. It’s got May, March in the wrong order order. In fact it’s the right order. It just depends on what you…

Transform/Add Column – Time In this video we’re going to have a look at the time functions that we have got. So we’re going to create again a new query, starting from a blank query. And we’re going to have a list of dates. But instead of using dates or times, I’m going to use date times, which combines dates and times. So instead of starting with a date, I’m going to start with a date time. So the difference between hash or pound date and date time is that…

Creating a list of dates Hello. In this section we’re going to have a look at dates and times. And we’re going to start by getting data, but not from our friend at the Power Bi data spreadsheet. Instead, we’re going to start with a blank query. So there’s some interesting things we can do with a blank query. Now, I’m just making sure the windows just a bit larger than normal, so that when we get to date, time, duration, it looks like that. So a blank query, absolutely…