Blog Topic Schedule The next three topics on the blog schedule (each Sunday) have been pushed back a week. ‘Power BI Desktop versus Excel 2016 Feature Compare’
Tag: Excel
‘Data Scientist’ Attacks Excel (2007)
Earlier today a self-described data scientist published the following on LinkedIn: Several comments were posted in response questioning the author’s dubious assertions and general lack of research. My comment
New Excel 2016 Charts; Ignite Sessions
Hi, In last week’s post I made available a sample Power Pivot data model for Excel and referenced two videos from the MS Data Insights Summit regarding Excel,
Sample Data Model Available for Download; MSBI Tools
Hi – The following Excel file contains a Power Pivot data model based on Microsoft’s latest sample data warehouse database (Wide World Importers) for SQL Server 2016:
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).