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

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 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