PerformancePoint Blog

A Blog about PerformancePoint and Microsoft BI technologies. Your host is Russell Christopher

Archive for the ‘SQL Analysis Services’ Category

Visualizing Microsoft Market Basket Analysis with Tableau

Posted by Russell on February - 24 - 2011
5-Recommednations.gif

In this post we explore different ways you can use Tableau to explore the output of the Microsoft Association Rules algorithm.

The Microsoft Clustering Algorithm, Tableau, and More Cowbell

Posted by Russell on February - 13 - 2011
Created with GIMP

Using Tableau to visualize the output of the Microsoft Clustering algorithm…More cowbell.

Blog Pic

I’m constantly amazed that such a small portion of people who own SQL Server are using the fantastic data mining capabilities they have access to. One thing that has occurred to me as a potential bump in the road towards wider adoption is visualization. Can Tableau help here?

Whoops!

What does “Persisted file cannot be found” mean when you’re executing a DMX query? I didn’t know and couldn’t find anything on the internets.

Creating a data-bound, drillable heat map with Silverlight

Posted by Russell on November - 24 - 2010
HeatMap

There are four big reasons I will always love ProClarity: It writes MDX for me The Decomposition tree The Heat/Performance map It writes MDX for me Since SharePoint/PerformancePoint 2010 now includes a decomp tree, I generally donâ

Silverlight Bubble Slider

I love PowerPivot. And I really, really love the visualization in the management dashboard that allows one to see which reports are active across time. I’ve thought to myself many a time, “Self, I sure like that visualization. I wish I could show

The PivotViewer

While watching the keynote from the recent BI Conference, I saw a demo of the Pivotviewer Extensions for Reporting Services. This is an interesting tool that will help automate creating Pivot collections. Unfortunately, even as an Microsoft FTE I can

PowerPivot, DAX and Semi-additive measures

Posted by Russell on January - 21 - 2010

Over the week-end I was doing some analysis on SQL Server disk usage, and wanted to be able to display current disk usage by database. Up to this point, I’d mainly been doing a SUM over  my measures. Well, that would make no sense in this scenario -

If you’ve played with PowerPivot at all, it’s pretty obvious how flexible the tool is in terms of creating data models. After you initially create a model, you may want to spend some additional time with it to make sure users can easily leverage what

I had a bear of a time getting SQL Server 2008 R2 November CTP’s Integrated PowerPivot feature installed.  It looks like several other people in the Twitter/Blogosphere are running into the same issue, but for potentially different reasons. For m

  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Russell's About.Me Profile