With examples of real problems and (attempted) solutions, this presentation will examine dimensional modeling techniques which simplify and speed up measure evaluation. A fast-paced look at some common and uncommon reporting scenarios, including: - All manner of date calculations and comparisons - Slowly changing dimensions - Events in progress - Conditional evaluation of measures
By the end of this talk, you should have a stronger understanding of the right questions to ask that will make your BI solution simpler for end users and more performant at run-time.
An experienced technical leader and curious problem solver, I have experience across the Microsoft data platform, with expertise in SQL, Analysis Services, Power BI, DAX, and M.
