Image

Analysis Services

Back to Dimensional Modeling Basics
1 year ago

Back to Dimensional Modeling Basics

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

Solve Analysis Services Need for Speed
2 years ago

Solve Analysis Services Need for Speed

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

Unwrapping the Power BI vNext Public Preview
4 years ago

Unwrapping the Power BI vNext Public Preview

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

Tip! How To Display SSAS Member Properties in Tableau
5 years ago

Tip! How To Display SSAS Member Properties in Tableau

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

Tip! Analysis Services Cubes with Tableau Design Patterns
6 years ago

Tip! Analysis Services Cubes with Tableau Design Patterns

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

What-If Analytic Scenario Simulation Options
6 years ago

What-If Analytic Scenario Simulation Options

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

Top