logo
  • Home
  • Blog-Navigation
  • Art
  • About
  • Contact

7 Tips to Create Winning Reports and Dashboards

· Roopam Upadhyay 14 Comments

Killer Dashboards

Frazzled Audeience - by Roopam

Frazzled Audience – by Roopam

Some time ago I came across an Excel based dashboard with around 45 tabs, and every tab had around 10 charts/ graphs /tables. That is roughly 450 figures and tables. I could only sympathize with the end audience of that dashboard. Unfortunately, almost every organization is deluged with meaningless reports and dashboards of this kind. I immediately knew I had to write this article on YOU CANalytics to save the end users from the torture these reports can cause. Luckily nobody is reading these reports and for a good reason.

The problem is not with the Excel-based dashboards but the clouded thinking on the part of the designers and analysts. Trust me no fancy software (Tableau, Business Objects or QlikView) can rectify the problem with a muddled brain. Hence let me suggest a few strategies for creating winning reports and dashboards. The strategies have been framed as titles.

  1. It’s the Question, Stupid!
  2. Know Your Frazzled Audience
  3. Learn to Disagree if Required
  4. Tell a Good Story
  5. Edit, Edit, & Edit More
  6. Aesthetic Minimalism
  7. Actionable Insights – Predictive Analytics in Action!

Before I tell you more about the above strategies, let me share with you a piece of memory from my childhood that will serve us well in this journey.

The Mahatma - by Roopam

The Mahatma – by Roopam

The Mahatma

Let us go some 25 years back in time when India was not bombarded 24/7 with more than 500 channels on television. Then it was just one channel – Doordarshan – with less than 8 hours of broadcasting time in a day. Television was a lot calmer then. Doordarshan used to have a short clip about Mahatma Gandhi as filler. The clip was not more than a couple of minutes long with brush strokes leaving a white canvas with the doodle similar to the one shown adjacent. In the background, a man’s calm voice recites the following – The greatness of this man was his simplicity. Let’s try and discover the Gandhi in ourselves. That is when I learned that one could depict the Mahatma with just a couple of brush strokes. I believe we need to discover simplicity within us and around to create relevant and winning dashboards. The following are my 7 tips for the same.

1)  It’s the Question, Stupid!

“[It’s] the economy, stupid” was the slogan Bill Clinton effectively used in the US presidential election in 1992 against George H. W. Bush (Dubya Bush’s father). Bush’s campaign was focusing on the Iraq war and Saddam while Clinton hit the bull’s eye by focusing on the right issue and won the election by a huge margin. I will modify the phrase a bit for creating winning reports by focusing on the single most important factor – “it’s the question, stupid”.

For me, charts, graphs, analysis or even data come much later. I think the foremost thing of importance is the question these tools are trying to answer. Every dashboard, report, presentation, analysis or model has a business question which it tries to answer. I would recommend that you write down the question(s) in plain English before starting with analysis without assuming that everybody knows the question(s). After that, everything is just an attempt to answer the question using the best possible medium / tools.

2)  Know Your Frazzled Audience

Okay if you don’t know them already let me introduce the end user of your dashboard, analysis or presentation to you. They are overloaded with information and a plethora of pending issues. To make things worse they are perpetually distracted with the emails on their smartphones. They are looking for simplicity but find it difficult to think straight within the chaos. Your analysis, report or dashboard could bring some simplicity in their work life, but they will find it difficult to see it at first. This will make your job really tough. But you cannot afford to get flustered by the surrounding, otherwise, you will just add to yet another useless analysis or dashboard.

3)  Learn to Disagree if Required

Now that you know your end audience better, you will also appreciate that they may at times ask questions that reflect their confusion during the analysis phase. This is when you need to guide them, question their thought process and if you disagree, say no to their muddled ideas. Be polite but firm while doing so.

4)  Tell a Good Story

We all love stories. Presentations, reports, and dashboards are just visual stories. The opening chapter of this story is, of course, the question(s). Once the questions are framed clearly, a good practice is to think of answering the questions like a story. The graphs, tables, and charts are different characters in this story and they will help in moving the story forward. A story is nothing but a logical progression of thought. For instance, a guest-appearance by Jabba-the-Hutt in a Shakespearean tragedy is unacceptable, similarly, an unwanted chart or graph is enough to confuse your audience and make them disengaged. Use your characters wisely and arrange them in the logical order of the story.

5)  Edit, Edit, & Edit More

The great movies cannot be made without great editing. You need to be completely dispassionate and ruthless while editing your reports and dashboards. Remember your audience is not looking for 3+ hours long ‘Schindler’s List’ movie but a succinct trailer. This is your last chance to remove those unwanted characters (figures and tables).  The hardest part is when you have to cut the role of your favorite actor – the analysis you have spent several sleepless nights working on but it does not fit well with your story. Keep your scissors sharp as you will need them.

Source: www.etsy.com

Source: www.etsy.com

6)  Aesthetics Minimalism

Mark Twain, one of the greatest writers once said: If you want me to give you a two-hour presentation, I am ready today.  If you want only a five-minute speech, it will take me two weeks to prepare. The idea captures the gist of one of the essential principles of designing dashboards and reports – less is often more!

I am a huge fan of Japanese minimalist art and design. The primary philosophy of minimalism is to say more with fewer elements – like the depiction of Mahatma Gandhi displayed above or the adjacent picture. Similarly, I believe for dashboards the graphics and charts should be simple and to the point. Simplicity goes a long way when it comes to designing dashboard. Though trust me, this is a really difficult and effort-intensive path.

7)  Actionable Insights – Predictive Analytics in Action!

The following is a case from the Emergency Room (ER) of Cook County Hospital in Chicago from the mid-1990s. Being a public hospital they serve poor people without health insurance.  The ER gets a quarter million emergency patients per year – this ensures a perpetual chaos-like situation for the doctors and medical staff to handle. The excessive inpatient rate also guarantees a consistent shortage in a number of hospital beds. A patient walking in with chest pain could be a case of impending heart attack or (not so dangerous) indigestion. This first case needs serious medical attention and the second a bit of reassurance and a bus ticket back home. The problem statement for the doctors and medical staff at Cook County hospital was simple: To distinguish severe cases vs. harmless cases fast and upfront to save as many lives as possible with the constraint of limited resources.

They were not looking for a fancy dashboard or sleek reports but a simple rule to help them make this decision fast. A competent bunch of statisticians (physicists actually) helped the hospital solve this problem. A predictive model suggested answering the following 3 ‘urgent risk factors’ along with the ECG report:

  1. Is the pain felt by the patient unstable angina?* (Answer: Yes / N0)
  2. Is there fluid in the patient’s lungs? (Answer: Yes / N0)
  3. Is the patient’s systolic blood pressure below 100? (Answer: Yes / N0)

What transpires was a simple decision tree that anyone could use to direct the patient to the appropriate treatment. Insights that facilitate action or actionable insight is exactly what the decision makers are looking for. Any dashboard, report or analysis that delivers this will never go unnoticed and is a winner.

* This case was published in Malcolm Gladwell’s best-selling book ‘Blink’ and the factors are directly taken from the book.

Sign-off Note

I have done my bit by sharing the tips I feel will make people take dashboards more seriously. I believe, business metrics and KPIs for your dashboard are going to pop out naturally once you follow the above steps. Let me know if you have some suggestions for the above list, post your comments right below this.

  • Share
  • Twitter
  • Facebook
  • Email
  • LinkedIn

Related

Posted in Analytics Tips and Tricks, Data Science Career | Tags: Business Analytics, Data Visualization, Predictive Analytics, Roopam Upadhyay |
« Population Stability Index (PSI) – Banking Case (Part 6)
Learn R : 12 Free Books and Online Resources »

14 thoughts on “7 Tips to Create Winning Reports and Dashboards”

  1. Luiz Oliveira says:
    April 12, 2014 at 8:11 pm

    Great tips, man! Congrats! Thank you very much.

    Reply
  2. Venuka says:
    April 14, 2014 at 11:48 am

    Thank you so much for giving us wonderful tips …..

    Reply
  3. Partha says:
    April 14, 2014 at 11:46 pm

    !

    Reply
  4. manoj says:
    April 21, 2014 at 1:02 pm

    simple

    Reply
  5. Yadaiah Koppoal says:
    April 22, 2014 at 3:49 pm

    Good information simple and short

    Reply
  6. Sergio says:
    April 26, 2014 at 10:34 am

    Excellent story, excellent article, excellent tips… and Excel. Thanks Roopam

    Reply
  7. Tarek says:
    May 13, 2014 at 11:36 am

    Thanks for the great tips; simplicity is the way to follow and the question is the base to start the analysis!

    Reply
  8. Daniel says:
    May 20, 2014 at 9:37 pm

    Roopam, I have spent a considerable number of hours on your blog now and want to thank you for your work. You share great tips and tricks, your blog posts are easy to read, and no matter where I click, I am learning something new. Thank you!

    Reply
    • Roopam Upadhyay says:
      May 25, 2014 at 9:55 am

      Thank you Daniel for the kind words! I am really happy that you are enjoying my blog and finding the posts helpful.

      Reply
  9. Eliud says:
    October 17, 2014 at 10:51 pm

    Thank you so much Roopam. As a growing analyst, this is one of my favourite learning opportunities. It’s just too addictive!

    Reply
    • Roopam Upadhyay says:
      October 19, 2014 at 12:10 am

      Thanks Eliud, am glad that you are finding my blog posts useful. All the best, and keep learning!

      Reply
  10. steve john says:
    January 25, 2019 at 11:34 am

    Thanks for sharing the wonderful blog. your blog is really good. your blog posts are easy to read and understand.

    Reply
  11. MIchal clarkh says:
    January 25, 2019 at 11:36 am

    Thanks for sharing the wonderful blog. your blog is really good and impressing me an peoples. your blog post are easy to read and understand.

    Reply
  12. Saurabh Kansal says:
    January 20, 2020 at 3:27 pm

    Thanks Roopam, It was a wonderful blog.

    Reply

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to Blog

Provide your email address to receive notifications of new posts

Must Read

Career in Data Science - Interview Preparation - Best Practices

Free Books - Machine Learning - Data Science - Artificial Intelligence

Case-Studies

- Marketing Campaign Management - Revenue Estimation & Optimization

Customer Segmentation - Cluster Analysis - Segment wise Business Strategy

- Risk Management - Credit Scorecards

- Sales Forecasting - Time Series Models

Credit

I must thank my wife, Swati Patankar, for being the editor of this blog.

Pages

  • Blog-Navigation
  • Art
  • About
  • Contact
© Roopam Upadhyay
  • Blog-Navigation
  • Art
  • About
  • Contact
 

Loading Comments...