From the course: Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Design efficient tables

Design efficient tables

From the course: Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press

Start my 1-month free trial Buy for my team

Design efficient tables

“

- We have seen that choosing the correct data types is important in your design of a semantic model. The next item to think about when designing is the tables you have. You want to design efficient tables. And in this lesson, we will investigate a few things that impact the efficiency of tables. Thinking back of what we have learned about how the engine works and how it deals with data types and coding values, there are a few choices that you can make in the design of your tables to help the engine to work efficiently. The first thing to think about is the size of your tables. You don't want to create enormous tables in your model because they take up a lot of space, and it'll make your model slow since it works in memory. But how can you make your table smaller? There are two ways in which you can split up your data tables, either by cutting back the number of columns or by cutting back the number of rows. Or even both, that…

Contents