Archive

Archive for February, 2009

Choosing a Good Chart

February 9th, 2009
Comments Off

The first struggle in creating any visual report for BI is selecting the best type of graph. Each developer or analyst has their own bias, but as process-oriented people, we know a flowchart is invaluable in making this decision.

Andrew Abela put together this excellent summary flowchart based on Say It With Charts.

A great place to start when creating charts.

Data Visual

Restart a Scheduled Report in Reporting Services 2005

February 2nd, 2009
Comments Off
SQL Job Names Used by Reporting Services Subscriptions

SQL Job Names Used by Reporting Services Subscriptions

There are a number of scenarios where you might need to restart a scheduled report in reporting services 2005. Unfortunately, the SQL jobs that are created by reporting services do not carry intelligible names.

This code snippet will show which SQL jobs need to be run in order to restart a failed subscription.


SELECT a.name job_name, d.name schedule_name, d.path, c.description, c.laststatus, c.lastruntime
FROM msdb..sysjobs a
JOIN reportserver..reportschedule b ON a.name=cast(b.scheduleid as nvarchar(255))
JOIN reportserver..subscriptions c ON b.subscriptionid=c.subscriptionid
JOIN reportserver..catalog d ON c.report_oid=d.itemid
ORDER BY c.lastruntime desc

Reporting Services 2005

Inaugural Words from 1789 to the Present

February 1st, 2009
Comments Off

The New York Times featured a great interactive graphic on presidential inaugural speeches. The graphic uses larger fonts to show frequently-used words.

The interactive infographic also highlights the words that are used more often relative to other addresses. Links are included to the speeches so you can verify the math.

Not crazy about the font-sizing method, but it seems to work pretty well in this instance. I’m wondering if a stacked line chart with an optional filter would relative frequency better. Similar to that employed by the Baby Name Voyageur. Which method would you prefer?

Interactive Graphic