Analysis Services

Several large systems integration consulting firm leaders in my network have confirmed a resurgence in demand for OLAP and related dimensional modeling skills. Dimensional modeling design patterns are still being …
Read More

If you have done everything possible to tune your Analysis Services OLAP cube and it still is not delivering fast enough queries, you might want to evaluate an acceleration utility …
Read More

After a few years of silence, wondering if cloud first meant cloud only, SQL Server BI on-premises customers finally got a peek at the investments being made in SQL Server 2016. …
Read More

Happy Holidays! I wasn’t kidding when I shared to keep posted for more updates last week. Although the Public Preview of Power BI was intended to be quietly and humbly …
Read More

I have teamed up with Packt Publishing to organize a Giveaway of the awesome Expert Cube Development with SSAS Multidimensional Models book written by the SSAS super-gurus: Chris Webb, Alberto …
Read More

I have been meaning to share this tip for a long time and stumbled upon it again backing up files to my off-site server this past week.  A while ago …
Read More

I found a “golden nugget” for using Analysis Services Cubes (SSAS) with Tableau.  There is a Knowledgebase article on the topic that is a little dated BUT the attached workbook …
Read More

A common advanced analytic requirement is “what if” scenario modeling. How can we enable our analysts to alter certain parameters  within known contraints to test potential impact?  Well, let me …
Read More