~/talk

Lessons learned from optimizing enterprise data models

on YouTube 51m
Talkat SQLBits 2023 · 2023-03-14..03-18· [data-visualization]

speaker

name:Nikola Ilic
links:none on file

resources

video:https://youtu.be/ul-DY4Jp3NE
slides:none on file

summary

Shows how to mimic hybrid tables on Pro by splitting a 200M-row fact into hot (import) and cold (DirectQuery) parts and using a DAX “tipping point” (filtered aggregations) to avoid DirectQuery; cuts a chats table from 667 MB to 214 MB by rounding to hour in SQL/Power Query instead of DAX; stresses enabling manage aggregations and setting precedence so Power BI maps queries to 2k-row vs 5M-row aggregates; flips AvailableInMDX off to drop a 121 MB hierarchy to 8 MB; warns that auto date/time can create ~3M hidden dates and 176 MB overhead.

AI-written summary · about

chapters (7)

  1. 0:00Introduction
  2. 1:21Data model optimization context
  3. 5:49Mimicking hybrid tables
  4. 18:20Reducing cardinality
  5. 27:06Implementing aggregations
  6. 36:34Hidden MDX properties
  7. 44:58Avoiding Auto Date/Time

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.