![power bi desktop tutorial power bi desktop tutorial](https://docs.microsoft.com/en-us/power-bi/fundamentals/media/desktop-getting-started/designer_gsg_startsplashscreen.png)
What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial).
Power bi desktop tutorial how to#
Power bi desktop tutorial zip#
Highlight Zip field and from the ribbon select Remove Duplicates to create a query of unique Zips
![power bi desktop tutorial power bi desktop tutorial](https://i.ytimg.com/vi/2_JqZ4IWTmY/maxresdefault.jpg)
Highlight query SalesData (2) and from the ribbon select Choose Columnsįrom choose columns dialogue, select Zip, City, State and Region columns This will create a unique list of Products Highlight ProductID fields and from the ribbon select Remove Duplicates. In the right panel, under Query Settings, rename the query to Product Select ProductID, Product, Category, Segment and Manufacturer. Highlight SalesData query and from the ribbon select Choose Columns Right click on SalesData Query in the left panel and duplicate it 3 times to create a total of 4 queries Now we are going to create 4 queries and prepare each of query to be a different dimension/lens. Make sure Date column is of Date data type Highlight Zip column and change data type to Text
![power bi desktop tutorial power bi desktop tutorial](https://www.tutorialspoint.com/power_bi/images/power_bi_desktop.jpg)
Query Editor window opens with SalesData Query selected in the right panel Navigator window opens, select SalesData and click Edit In this tutorial, we will learn how to massage the data using Power BI Desktop so that we can build a more user friendly model.īrowse to the location of the downloaded source file, select the file and click Open As we can see, we can analyze this data using three different lenses or dimensions: Very often our analysis starts with a flat data set that contains all of the pertinent columns in a single table that looks like the one above. This tutorial shows how to create a Star Schema using Power BI Desktop.ĭata for the tutorial can be obtained by downloading Excel file from here An updated version of this tutorial (including a video lecture) is available here: