If you’re new here, you may want to subscribe to my RSS feed. Thanks for visiting!In the following example we work through a real world example of a data visualization. We’ve chosen an example that involves Operations data – this is fairly non-domain specific so hopefully it can demonstrate some important points. The first, [...]

 
Following on from our previous blog post on a couple of the common cube performance issues we’ve seen this last month, I thought I’d mention some of the non-technical issues we see quite often. In one case, once we’d made a few teaks and sorted out the cube performance issues we had to ask - [...]

A quick blog post from the Services team here at XLCubed on some performance problems with SSAS that we’ve seen again recently. With the processing power and memory available it’s pretty easy to build a fast cube – both for query performance and processing time. It is also easy to be lax in cube design, ignore the [...]

Today, we released MicroCharts for Reporting Services 2005. You now can create sparkline enabled reports and dashboards with "more information per square inch" using Microsofts Standard Report Writer:

   Once you have installed MicroCharts for Reporting Services 2005, you have a set of MicroCharts controls available in your Toolbox.

[...]

As "An Excel User in a Cubed Kingdom" I’m starting my exploration of this new found land with a simple question: what is an OLAP cube? In plain English, please…
I like this simple, non-technical definition: a cube is a set of predefined answers. It’s up to you to select the right questions.
OK, let’s detail this.
Imagine [...]

I’ve been using Excel for my entire professional career, most of the time in large corporations where adding a piece of software to the standard IT structure would be some kind of heresy. When I have a business need that can be solve by an out-of-the-box Excel installation that’s the path I follow (I’m also [...]

I attended beginning this week the Microsoft BI Conference in Seattle where Microsoft presented an interesting new product that might change the way you build your Excel dashboards in the future: "Gemini", an End-User Business Intelligence plug in for Excel.
End-User Business Intelligence has been around for quite a while with some of the most prominent [...]