As a follow-up to my work with the Time Series algorithm, I’ve been playing with the SSAS clustering algorithm over several cups of Bald Guy coffee. One will generally use the clustering algorithm to segment “things” (customers into “customer clusters”, for example) based on similarities between attributes that describe the “things” ...
In 2010, the install point of PerformancePoint Dashboard Designer isn’t overly discoverable, but Microsoft has done a good job documenting how to get the thing loaded. Most of the time, our instructions tell you to go to a BI Center site, and install it from there. You can also install it ...
Over the holidays, I decided to experiment with some business intelligence technology that I normally don’t have the opportunity work with – QlikTech’s QlikView. In a nutshell, I took Microsoft’s Contoso Retail sample DW, brought portions of it into QlikView, and created several dashboards. Might as well blog about the experience, ...
Yesterday, a machine which had been happily creating PowerPivot snapshots for me stopped doing so. If I had taken the time to search on keywords like “PowerPivot”, “snapshot”, and “IE9”, I would have landed on Gavin’s blog and saved myself some time, but whatever…it was a good learning experience. When the ...
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 my OWN data inside that thing, however”. So ...
(This refers to MOSS 2010 and PPS V2) Today I needed to make an internal PPS demo available via the internet, so some alternate access mapping within SharePoint was in order. I added an AAM entry for my default web site, essentially converting http://foo into http://demoname.domain.com inside MOSS. When I fired up the dashboard via http://demoname.domain.com, my analytical grids/charts, scorecards and filters worked correctly. However, the PPS reports which are [ Read More ]
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
It’s official! The Silverlight Pivot control is now available to the general public. Download now! http://www.silverlight.net/learn/pivotviewer/
Proof positive you need to keep writing code or your skills atrophy. This morning I needed to write some simple code to render an SSRS report as an image using the SSRS Web Services…. In VS, I added a Service Reference to ReportExecution2005.asm
Today I installed the BI Indexing Connector for the first time (neat stuff!) and pretty quickly saw a change in the way the PowerPivot gallery renders Reporting Services reports. When installing the backend component of the connector, you are inst
You heard it here first! (?) The next major release of the All-up Virtual Machine for Business Intelligence will be made available to Microsoft Partners in the near future (No, no word on whether the general public will be able to get their ha
Noticed that Gartner’s MQ for Business Intelligence is now out there for 2010: http://www.gartner.com/technology/media-products/reprints/microsoft/vol10/article7/article7.html Compared to 2009, it appears that Microsoft (yay!), Oracle,
There are reports that the SSAS archive out on http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=868662dc-187a-4a85-b611-b7df7dc909fc is corrupt….”damaged, truncated, or has been changed”, to exact 
To open it, simpl
For those of you who attended SQL PASS or other recent Microsoft-related technical conferences, you may have seen our new BI “Contoso” demo. Well, the data that powers it has now been made available for download. You’ll find both an OLTP DW and an OL
Over on the Forrester Blog, Boris Evelson has written an interesting post about the real cost of creating a single BI report in the enterprise. He estimates a price tag of between $1,840 and $20K per report after one factors in expenditures on softwa
