Dec 15, 2018
Converting from UTC to Local Timezone in Power BI and Azure Analysis Services
Converting from UTC to Local Timezone in Power BI and Azure Analysis Services is a common issue due to the servers using UTC time, this post explains how to work around this issue.
Dec 14, 2018
How to automate (Azure) Analysis Services processing from a remote PC
A local SQL Server agent is unable to easily execute process commands against a remote Azure Analysis Services instance. This post details how to overcome this difficulty while also not having server administration rights.
Dec 12, 2018
The increasing security requirements of a growing data model
This post details what options you have for adding security into your growing data model.
Dec 11, 2018
Why Azure Analysis Services is a great value proposition
Azure Analysis Services continues to provide excellent value for money while maintaining strong administration controls and source control capability.
Nov 26, 2017
BI Theory #7: Multidimensional vs Tabular
In this post, I’m going to do a quick comparison between multidimensional and tabular data models, and hopefully give you some intuition about why they have the features that they do.
Nov 26, 2017
BI Theory #6: Analytical Databases
In this post, I'll outline why you don't necessarily want to build your analysis on top of a transactional database, and instead why you'd be better off using (or building!) an analytical database.
