Hi All – Just a quick note that my session for SQL Saturday #575 in Providence, RI on 12/10/2016 has been accepted. A tentative schedule
Tag: Tabular
Tech Events Page Added
A Tech Events page has been added under the About tab that identifies the events (physical and virtual) I’ll be either attending or contributing to as a speaker/presenter.
A New Project: Frontline Analytics
Last week I loaded up a U-Haul trailer and moved back to my home north of Boston to start my own data and analytics consulting
Role-Based Default Filter Context for Power BI
Update (9/26/2017): An improved approach to dynamic (user role based) default filter context for Power BI is detailed in Chapter 8 of the Microsoft Power
SSAS Tabular 2016: Direct Query vs. In-Memory
Hi, With the release of SSAS 2016 last month I’ve been thinking about the enhanced Tabular Direct Query mode and the trade-offs with In-Memory mode (default).
DAX Variables Design Considerations
Summary DAX variables can be used to optimize performance of queries against SSAS Tabular, Power BI Desktop, and Power Pivot for Excel models by re-using a DAX expression multiple times