Archive for category Presentation
Two excellent posts about *just* data versus actual analysis
Posted by Mike S in Business Intelligence, Presentation, Reporting on August 9th, 2010
I’ve had these bookmarked for a while and periodically revisit them. They are worth checking out.
Juice Analytics: Filling the gap between reporting and Reporting
Avinash Kaushik: Consultants, Analysts: Present Impactful Analysis, Insightful Reports
From GraphJam.com: Things I Want to Do in New Jersey
Posted by Mike S in Presentation on November 8th, 2009
Might I add “Visit the Axis Group headquarters“? Just kidding, New Jersey people. It was good seeing you last week.
Very amusing (though occasionally vulgar) site.
Typography for Lawyers (and pretty much everyone else)
Posted by Mike S in Presentation on September 20th, 2009
Typography for Lawyers is a website created by Matthew Butterick, a Harvard graduate and lawyer with a background in graphic design and typography. (To his credit, his law firm does have a pretty beautiful website.) He dedicates some of his free time to Typography for Lawyers to help those in the legal profession make better typographic decisions.
I can’t think of many industries that do not rely heavily on text, including technical fields, which has been discussed here before. To be clear, typography goes beyond font choice, including size, alignment, case, and anything that contributes to the appearance of text. In Business Intelligence and Data Warehousing, it can take the form of written communication, reports, application design - even your comic sans email signature.
A few basic takeaways from Mr. Butterick’s site:
- Typography matters because presentation matters. Design choices affect how your message is conveyed and how easily it is understood, just as your tone of voice and body language do in conversation.
- One space - not two - between sentences. (Evidently, I’ve been doing this incorrectly for a long time.)
- Many things are best used sparingly - bold, italics, all caps, exclamation points.
- Monospace fonts, e.g. Courier, are difficult to read and waste space. They are only necessary for typewriters to work correctly, which likely has little to do with your work.
- The most commonly used fonts on our computers are designed to render well on your monitor, not in print.
There is plenty more detail on the site itself, if the subject interests you. There is likely a void at your company yet to be filled by a typography guru.
For another reading on the topic, see Tufte’s paper, PowerPoint Does Rocket Science.

This typography just screams “Financial Analysis”. (SAP.com)
Design consistency
Posted by Mike S in Presentation, Reporting, Visualization on May 24th, 2009
Welcome back, as I continue my slow, alphabetical wade through Universal Principles of Design.
According to the principle of consistency, systems are more usable and learnable when similar parts are expressed in similar ways. Consistency enables people to efficiently transfer knowledge to new contexts, learn new things quickly, and focus attention on the relevant aspects of a task. (page 46)
That’s right: creating report templates is not just busywork, because inconsistency is actually distracting and counterproductive. When you see a new report, you shouldn’t have to search for the run date, and when you flip the pages of a dashboard or analytical interface, you shouldn’t need to regain your bearings and relearn the layout. Consistency allows end users to jump right into consuming the data, and this principle applies equally to the likes of reports, dashboards, analytical applications, and even slide decks and your company’s web site.
So pick an approach, given your audience and medium, and stick to it.
- Replicate your layout on all pages of a report or application, with components aligned and intuitively arranged. Selectors (dropdown boxes, radio buttons) for the same dimensions should be in the same place, the data date should be in the same corner, etc.
By the way, here’s a QlikView enhancement idea to make layout consistency a natural part of building applications: create an option on the Layout tab of an object’s properties that allows you to choose from a series of checkboxes on which sheets an object should appear, rather than just copying it once per tab. I imagine it would even save 1) memory, because there would be fewer overall components and 2) calc time, because it wouldn’t need to update copies of those components on new tabs when you open them.
- Have not just consistency of colors, but consistency of meaning of colors. For instance, darker colors might indicate recency or the degree to which a data point is an outlier.

That, of course, precludes you from making psychedelic bar charts, where every slice is arbitrarily assigned a color for the sake of variety. (This example commits more offenses than just that.)

Junk Charts
- Pick a standard font, colors and sizes. Choose based on readability and the ability to create some emphasize using contrast. For instance, everything data-related might be black, while everything else, like help text or metadata, might be a lighter color.
- For charts, pick a standard alignment for titles and a standard place to display the units and granularity. Making a habit of this improves not only consistency, but provides end users with the context necessary for understanding the data correctly.
- Apply a standard alignment for tabular data, e.g. left-justified text and right-justified numbers with the same number of decimal places, to facilitate visual comparison.


- Sort orders should be consistent, particularly if several charts or tables are using the same dimensions.
- Each page should have the same footprint. In a dashboard, the components on all tabs should fit into a space with the same dimensions, e.g. 1024×768, and reports shouldn’t have objects running off of the page.
Some of those sound like common sense, but it’s shocking how often they are violated. Once you have finished your thoughtful planning and are happy with your work, document your choices as the standards upon which future work will be based.
Enhancing live performance with PowerPoint
Posted by Mike S in Presentation, Visualization on February 24th, 2009
Critique of Your PowerPoint Presentation Titled “Sales Forecast, Third Quarter”
Posted by Mike S in Presentation on February 11th, 2009
…Your ransom-note-like use of multiple fonts and sizes on each slide led us, the viewers, to identify not with the content but with the feeling of being trapped and held hostage, our freedom being contingent on our ability to appear to understand your many indecipherable charts and graphs. With this quick nod to Stockholm syndrome, we began to feel for you as our captor and, eventually, as our fellow prisoner.
Another highlight was your complete rejection of Tuftean convention through the use of colors without meaning, location without purpose, and position without movement. How daring it was to represent the quarterly shortfalls in revenue with the color purple—the color associated not only with kings but also with the skin of slaves, an obvious yet powerful homage to Alice Walker’s seminal novel. By rejecting the fixed ironic conventions of green and black (colors of mold, death, and despair) for profits and red (blood and lust) for losses, you transcended the common criticism that capitalism is animalistic and decadent. The postmodern color scheme instead offered a fascinating contradiction, one that simultaneously said, “I am master of my destiny,” and “I am trapped by the projections required as a condition of my employment, and am but a slave to outcomes that are way beyond my control,” and “Feel free to have more cinnamon buns, for I seem to have ordered too many.” Your despair, transparent as it was, brilliantly led us to share your pain, as the mumbled delivery forced us to lean forward and listen with extra focus, sharpening the impact of your dismal forecast for your sector and, by extension, our lives.
An excerpt from McSweeney’s, a sometimes satirical literary journal I follow. One of the most amusing things about this essay, to me, is that the author’s use of the adjective “Tuftean”, indicating that he either knows something about data visualization or did good research, uncovering the godfather of modern data visualization.




