Two of the most fundamental and ongoing questions in BI are 1) “What data and logic do we need in the data model?” and 2)
Category: Excel
Investment Returns Standardized
The prices of individual investment securities can vary widely and thus a common reporting practice is to standardize or index these values to a baseline
A Look Ahead to MSBI in 2018
MSBI 2018 Feature List This post identifies 11 MSBI features and enhancements that could be delivered later this year. Similar to the Power BI Feature Report,
Dynamic Dates via DAX
Dynamic DAX Date Queries The following zip file contains two DAX queries that dynamically calculate 23 date dimension values. Both queries produce the same result set but
SSAS Tabular 2016 Metadata Reporting
The following Excel workbook available for download contains 10 report pages to describe primary components of SSAS Tabular 2016 databases at the 1200 compatibility level: SSAS Tabular 2016
Top 10 MSBI Enhancements for 2017
A Quick Look Back at 2016: Banner Year for MSBI 2016 was a great year for the MS data platform – for customers, partners, and
Insight Quest 