Get ready to open your mind to Business intelligence! "Applied Microsoft Business Intelligence" provides best practices on how to leverage Microsoft SQL Server and Microsoft Office for more opitimised BI.
Actionable Visualisation in Power BI with Julie Koesmarno on 27 Mar 2015 in Brisbane, QLD
Register now for Actionable Visualisation with Power BI Workshop in Brisbane on 27 March 2015
Power View with Dynamic KPI Treshold Defined Per Category and Per Year
Current Power Pivot / Tabular Model does not support dynamic threshold settings for KPI. However, some customisations on the data model can be applied to enable dynamic KPI threshold in Power View.
Implementing Tabular Data Models
Are you a database developer and wondering how to jump to the Analysis side of the world of data? Join my session with Patrick LeBlanc at the Implementing Tabular Models MVA session on Nov 11, 2014
Short Time format in Tabular is doing what the Medium Time format is supposed to do and vice versa!
Accessing Schedule Data Refresh
Schedule Data Refresh is a new feature in Power BI to allow users to refresh data sources in Power Pivot at a defined time or on demand.
GeoFlow for Excel 2013 - SQL Server Data Refresh 22M rows
How to connect GeoFlow to SQL Server database and Tabular Model for millions of rows. This article includes sample workbooks.
Upgrade PowerPivot to Excel 2013 Dialog Box
Upgrading Excel 2010 workbook with PowerPivot to Excel 2013. Sample workbook used is courtesy of Jason Thomas.
A review of DAX Studio, a simple, yet powerful Excel Add-In for PowerPivot and Tabular Model developer