Tecflix

Modelling Data Purchase the entire course

21 December 2018 · · 303 views

Power BI Course

Modelling Data

So far we have seen how the Query Editor can be used to generate tables of data - after this point, these tables are loaded into the Power BI data model, the internal database that stores all imported data in Power BI, and into a dataset. A dataset consists of tables of data linked together by relationships, so that all of the tables can be queried as a whole. Relationships link a column on one table to a column on another table, similar to how you can join two tables together in SQL. There are a number of rules that have to be followed when creating relationships, for example that you cannot use composite keys and that on one side of the relationship you need a column that does not contain any duplicate values. Relationship filter direction controls how data in the tables on either side of the relationship is filtered when it is used in reports.

One commonly-asked question about the Power BI data model is how much data you can import into it. In fact this question is very difficult to answer: it depends on how well your data is compressed when it is loaded into Power BI, and this in turn can depend on a number of factors including how many distinct values there are in each column of each table. It is possible to reduce the amount of memory used by the data model, and therefore increase the amount of data you can import, by remodelling your data.

Once you have loaded your data into the data model, there are many properties you can set that govern how the data model behaves when you build reports. You can, for instance, control how the data in a column is formatted when it is used in a report and also how it gets sorted. Hierarchies can be used to help your users drill down through the data, you can create custom groups of values, hide columns, setting data categories, controlling how data is summarized by default and how the Q&A feature can identify columns and tables.

Log in or purchase access to play the video.

  • Power BI New Features and Course Updates 1-min Free—Watch Now

  • What is Power BI? 59-min Watch with Free Subscription

  • Licensing 8-min

  • Connecting to Data Sources 42-min

  • Connecting to Data Sources (2018 Updates) 23-min

  • Data Import Concepts 55-min

  • Transforming Data with the Query Editor 1-hour 20-min

  • Transforming Data with the Query Editor (2018 Updates) 13-min

  • Advanced Data Loading 49-min

  • Modelling Data 1-hour 10-min

  • Modelling Data (2018 Updates) 14-min

  • DAX and the Data Model 31-min

  • DAX and the Data Model (2018 Updates) 10-min

  • Power BI Desktop vs Excel 37-min

  • Cloud and Desktop Power BI Dashboards and Reports 45-min

  • Power BI Reports (2018 Updates) 40-min

  • Building Reports in Excel 32-min

  • Sharing, Distribution, and Security 42-min

  • Data Refresh 8-min Free—Watch Now

  • Administration and Auditing 11-min Watch with Free Subscription

  • Azure Analysis Services 1-hour 3-min

  • Power BI Premium and Power BI Embedded 36-min Watch with Free Subscription

Purchase a Full Access Subscription

 
Individual Subscription

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
 
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo