Image

Analysis Services

Solve Analysis Services Need for Speed
3 months 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

Microsoft Breathes Life back into SQL Server BI On-Prem
2 years ago

Microsoft Breathes Life back into SQL Server BI On-Prem

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

Unwrapping the Power BI vNext Public Preview
2 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

Free Expert Cube Development with SSAS Multidimensional Models
3 years ago

Free Expert Cube Development with SSAS Multidimensional Models

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

Tip! How To Display SSAS Member Properties in Tableau
4 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
4 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
5 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

Free BI Technical Training from Microsoft Product Teams
5 years ago

Free BI Technical Training from Microsoft Product Teams

http://www.microsoftvirtualacademy.com

WOW – how did I miss the memo?  I did not know this great technical resource even existed so thought I would share it here in case others are …
Read More

SSAS Tabular Model Security White Paper Released
5 years ago

SSAS Tabular Model Security White Paper Released

Continuing on with my FAQ theme, Dave Wickert just directed me to a recently released security white paper for SSAS Tabular Models written by Cathy Dumas that I could not …
Read More

FAQ: How to deploy SQL Server 2012 BI in a SharePoint 2010 farm
5 years ago

FAQ: How to deploy SQL Server 2012 BI in a SharePoint 2010 farm

UPDATE: August 2012 Power View Infrastructure Installation:  Step-by-Step and Scripts

General guidance for implementing SQL Server 2012 BI in a SharePoint 2010 farm (with one dedicated BI Server in the …
Read More

PowerPivot “How To” for Large Scale Projects
5 years ago

PowerPivot “How To” for Large Scale Projects

It seems many BI pros do not realize the wonderful large scale potential for PowerPivot projects using the easy SSAS upgrade path in SQL Server 2012. Most of the enterprise …
Read More

Top