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 ...
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 – I’d end up with a meaningless number just like I would if I took a SUM of an Inventory value. I found [ Read More ]
Looks like May! http://blogs.technet.com/dataplatforminsider/archive/2010/01/19/sql-server-2008-r2-gets-an-official-date.aspx
Yes, it is totally possible to publish a SSRS report into your PowerPivot Gallery – In fact, the gallery invites you to do so with the “New Report Builder Report” item in the PowerPivot gallery’s silverlight application. But as my buddy George O
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
File this under “duh”, but if your goal is to show PowerPivot charts to their best effect in the SharePoint PowerPivot Gallery, then…. Hide those chart data sheets, ladies! Simple, but makes a world of difference in terms of how cool your re
Want to play with PowerPivot (Project Gemini) without going through the hassle of installing Office, SharePoint, etc? Try the newly released virtual lab! https://cmg.vlabcenter.com/default.aspx?moduleid=ad3bd3e9-8d2b-498d-94fa-e41e1b09730d Upda
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
I was in an inflammatory mood at the beginning of the week and tweeted the following at #sqlpass: DBAs don’t like it, but Excel IS the database for many. This hasn’t and won’t change. Manage to this reality. The
Last week I was in a bit of a panic when Excel Services and SQL Reporting Services (MOSS Integrated) broke on nearly all of my “demo” Hyper-V images. I could publish to Excel Services, but attempting to render caused this exception to get
The title says it all! x86: http://www.microsoft.com/downloads/details.aspx?FamilyID=90c596a5-aca4-4ded-9072-facf834bc0c6&displaylang=en x64: http://www.microsoft.com/downloads/details.aspx?FamilyID=3ad75ae5-d2cd-4953-87cf-5f74d79804c6&di
