Morning Tells the Truth

April 10th, 2012
Comments Off

The end of the day has a way of convincing you what you’ve done is good. The next morning has a way of telling the you truth.

And that’s fine. Design is a process of experimentation and elimination. You should be excited to have your mind changed and throw things away.

This isn’t news, of course. “Sleep on it” has been great advice since forever. But it’s been a good reminder that the next morning isn’t just a block on the calendar, it’s a great design tool in itself. Use it to your advantage.

From Signal v Noise


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 job_name, schedule_name, d.path, c.description, c.laststatus, c.lastruntime
FROM msdb..sysjobs a
JOIN reportserver..reportschedule b ON 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

Inaugural Scheduled for 2/1/2009

January 25th, 2009
Comments Off

The inaugural post is scheduled to go live on 2/1/2009. Please stay tuned or subscribe to the All Others Bring Data feed.