This page contains categorised lists of the posts I’ve made so far and hopefully I’ll be diligent in keeping it up to date!
BI Theory
- BI Theory #1: An introduction to the changing world of self-service BI
- BI Theory #2: The Microsoft Self-Service BI Toolset
- BI Theory #3: PQFL (“M”) vs DAX
- BI Theory #4: Where to get Power Query and Power Pivot
- BI Theory #5: What are databases?
- BI Theory #6: OLAP (Analytical) Databases
- BI Theory #7: Multidimensional vs Tabular
- The increasing security requirements of a growing data model
Analysis Services
- Why Azure Analysis Services is a great value proposition
- How to automate (Azure) Analysis Services processing from a remote PC
- Workarounds for Analysis Services database admins without server admin access