Designing Reports with Custom MDX Queries – part 3
Start at part 1 …continued from part 2: Handling Parameters When an MDX query is created using the graphic query…
Category: SQL Syndication
Gartner BI Magic Quadrant 2011
It’s often true that “a picture is worth a thousand words” but sometimes a picture can be such an effectively…
Designing Reports with Custom MDX Queries – part 1
This article is the first in a three-part series On the Microsoft Developer Network (MSDN) forum for Reporting Services and…
Take-aways from the 2011 Microsoft MVP Summit
Every year, Microsoft brings a couple thousand specialists from every corner of the globe together for a few days to…
Can I Add Controls to a Reporting Services Report?
I see this question on the forums all the time and thought it was worth a repost here. Just this…
StreamInsight: A new way to think about analyzing data
Last night’s Oregon SQL user group meeting was very enlightening. Mark Simms from the SQL Server Customer Advisory Team (SQLCAT)…
Why Do All Funnel Charts Look The Same?
Something recently occurred to me. I’ve been researching chart and dashboard design standards for an article I’m working on, and…
Rich Embedded Text Formatting in Reports
I’ve recently come to realize what a truly remarkable feature it is to be able to format report text using…
Building Reports and Analytics on Dynamics CRM – Lessons (Being) Learned
In concept, designing reports is such a simple thing… you connect to a data source, write a SQL query, optimize…
Preventing Subscriptions from Blocking Interactive Report Executions
A consulting client recently asked how they could resolve a capacity-planning issue on their production report server. They manage a…
Dashboard and KPI Design–the Definitive Industry Standard
First of all, the title is intended to be a little tongue-in-cheek – just a little bit. I’ll explain. Last…
Cloudy Days Ahead
Microsoft is investing heavily in cloud computing with several online services available under the Azure Platform. SQL Azure The SQL…
Self-service Reporting in SQL Server “Denali”
Project Crescent is a fully-interactive, browser-based data visualization surfaced using Silverlight interactive and animated controls. It’s Reporting Services, only sexier. …
Testing for NULLS in a Dataset Filter
Some seemingly simple filtering logic can be more difficult to achieve when using a dataset filter rather than the WHERE…
Project Phoenix: a Chance to Support the Community and Build a Career
Do you know someone with an IT background who could use a break, is passionate about technology and wants to…