{"id":2267,"date":"2014-04-12T18:42:29","date_gmt":"2014-04-12T13:12:29","guid":{"rendered":"http:\/\/ucanalytics.com\/blogs\/?p=2267"},"modified":"2016-10-13T16:04:50","modified_gmt":"2016-10-13T10:34:50","slug":"essential-tips-create-winning-reports-dashboards","status":"publish","type":"post","link":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/","title":{"rendered":"7 Tips to Create Winning Reports and Dashboards"},"content":{"rendered":"
\n

Killer Dashboards<\/span><\/h2>\n
\"Frazzled<\/a>

Frazzled Audience – by Roopam<\/p><\/div>\n

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.<\/p>\n

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.<\/p>\n

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

    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.<\/p>\n

    \"The<\/a>

    The Mahatma – by Roopam<\/p><\/div>\n

    The Mahatma<\/span><\/h2>\n

    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 \u2013 Doordarshan \u2013 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\u2019s calm voice recites the following – The greatness of this man was his simplicity. Let\u2019s try and discover the Gandhi in ourselves.<\/i><\/b> 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.<\/p>\n

    1)\u00a0 It\u2019s the Question, Stupid!<\/strong><\/span><\/h2>\n

    “[It’s] the economy, stupid” was the slogan Bill Clinton effectively used in the US presidential election in 1992 against\u00a0George 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”.<\/p>\n

    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.<\/p>\n

    2)\u00a0 Know Your Frazzled Audience<\/strong><\/span><\/h2>\n

    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.<\/p>\n

    3)\u00a0 Learn to Disagree if Required
    \n<\/strong><\/span><\/h2>\n

    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.<\/p>\n

    4)\u00a0 Tell a Good Story<\/strong><\/span><\/h2>\n

    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.<\/p>\n

    5)\u00a0 Edit, Edit, & Edit More <\/strong><\/span><\/h2>\n

    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\u00a0succinct trailer. This is your last chance to remove those unwanted characters (figures and tables).\u00a0 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.<\/p>\n

    \"Source:<\/a>

    Source: www.etsy.com<\/p><\/div>\n

    6)\u00a0 Aesthetics Minimalism<\/strong><\/span><\/h2>\n

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

    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.<\/p>\n

    7)\u00a0 Actionable Insights – Predictive Analytics in Action!
    \n<\/span><\/h2>\n

    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.\u00a0 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.<\/i><\/p>\n

    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:<\/p>\n

      \n
    1. Is the pain felt by the patient unstable angina?* (Answer: Yes \/ N0)<\/i><\/li>\n
    2. Is there fluid in the patient\u2019s lungs? (Answer: Yes \/ N0)<\/i><\/li>\n
    3. Is the patient\u2019s systolic blood pressure below 100? (Answer: Yes \/ N0)<\/i><\/li>\n<\/ol>\n

      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.<\/p>\n

      * This case was published in Malcolm Gladwell’s best-selling book ‘Blink’ and the factors are directly taken from the book.<\/span><\/p>\n

      Sign-off Note<\/span><\/h4>\n

      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.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Killer Dashboards 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<\/p>\n

      Read More…<\/a><\/p>\n","protected":false},"author":1,"featured_media":2268,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[62,78],"tags":[7,24,6,10],"jetpack_publicize_connections":[],"yoast_head":"\nSeven Tips to create winning Reports and Dashboards - YOU CANalytics<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Seven Tips to create winning Reports and Dashboards - YOU CANalytics\" \/>\n<meta property=\"og:description\" content=\"Killer Dashboards 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 ofRead More...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/\" \/>\n<meta property=\"og:site_name\" content=\"YOU CANalytics |\" \/>\n<meta property=\"article:author\" content=\"roopam\" \/>\n<meta property=\"article:published_time\" content=\"2014-04-12T13:12:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-10-13T10:34:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/04\/photo4.jpg?fit=615%2C1024&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"615\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Roopam Upadhyay\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#organization\",\"name\":\"YOU CANalytics\",\"url\":\"https:\/\/ucanalytics.com\/blogs\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120\",\"contentUrl\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120\",\"width\":607,\"height\":120,\"caption\":\"YOU CANalytics\"},\"image\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#website\",\"url\":\"https:\/\/ucanalytics.com\/blogs\/\",\"name\":\"YOU CANalytics |\",\"description\":\"Explore the Power of Data Science\",\"publisher\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ucanalytics.com\/blogs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/04\/photo4.jpg?fit=615%2C1024&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/04\/photo4.jpg?fit=615%2C1024&ssl=1\",\"width\":615,\"height\":1024},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#webpage\",\"url\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/\",\"name\":\"Seven Tips to create winning Reports and Dashboards - YOU CANalytics\",\"isPartOf\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#primaryimage\"},\"datePublished\":\"2014-04-12T13:12:29+00:00\",\"dateModified\":\"2016-10-13T10:34:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ucanalytics.com\/blogs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7 Tips to Create Winning Reports and Dashboards\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#webpage\"},\"author\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6\"},\"headline\":\"7 Tips to Create Winning Reports and Dashboards\",\"datePublished\":\"2014-04-12T13:12:29+00:00\",\"dateModified\":\"2016-10-13T10:34:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#webpage\"},\"wordCount\":1476,\"commentCount\":14,\"publisher\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#organization\"},\"image\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/04\/photo4.jpg?fit=615%2C1024&ssl=1\",\"keywords\":[\"Business Analytics\",\"Data Visualization\",\"Predictive Analytics\",\"Roopam Upadhyay\"],\"articleSection\":[\"Analytics Tips and Tricks\",\"Data Science Career\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6\",\"name\":\"Roopam Upadhyay\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g\",\"caption\":\"Roopam Upadhyay\"},\"description\":\"This blog contains my personal views and thoughts on predictive Analytics and big data. - Roopam Upadhyay\",\"sameAs\":[\"roopam\"],\"url\":\"https:\/\/ucanalytics.com\/blogs\/author\/roopam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Seven Tips to create winning Reports and Dashboards - YOU CANalytics","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/","og_locale":"en_US","og_type":"article","og_title":"Seven Tips to create winning Reports and Dashboards - YOU CANalytics","og_description":"Killer Dashboards 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 ofRead More...","og_url":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/","og_site_name":"YOU CANalytics |","article_author":"roopam","article_published_time":"2014-04-12T13:12:29+00:00","article_modified_time":"2016-10-13T10:34:50+00:00","og_image":[{"width":615,"height":1024,"url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/04\/photo4.jpg?fit=615%2C1024&ssl=1","type":"image\/jpeg"}],"twitter_misc":{"Written by":"Roopam Upadhyay","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/ucanalytics.com\/blogs\/#organization","name":"YOU CANalytics","url":"https:\/\/ucanalytics.com\/blogs\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/ucanalytics.com\/blogs\/#logo","inLanguage":"en-US","url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120","contentUrl":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120","width":607,"height":120,"caption":"YOU CANalytics"},"image":{"@id":"https:\/\/ucanalytics.com\/blogs\/#logo"}},{"@type":"WebSite","@id":"https:\/\/ucanalytics.com\/blogs\/#website","url":"https:\/\/ucanalytics.com\/blogs\/","name":"YOU CANalytics |","description":"Explore the Power of Data Science","publisher":{"@id":"https:\/\/ucanalytics.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ucanalytics.com\/blogs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#primaryimage","inLanguage":"en-US","url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/04\/photo4.jpg?fit=615%2C1024&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/04\/photo4.jpg?fit=615%2C1024&ssl=1","width":615,"height":1024},{"@type":"WebPage","@id":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#webpage","url":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/","name":"Seven Tips to create winning Reports and Dashboards - YOU CANalytics","isPartOf":{"@id":"https:\/\/ucanalytics.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#primaryimage"},"datePublished":"2014-04-12T13:12:29+00:00","dateModified":"2016-10-13T10:34:50+00:00","breadcrumb":{"@id":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ucanalytics.com\/blogs\/"},{"@type":"ListItem","position":2,"name":"7 Tips to Create Winning Reports and Dashboards"}]},{"@type":"Article","@id":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#article","isPartOf":{"@id":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#webpage"},"author":{"@id":"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6"},"headline":"7 Tips to Create Winning Reports and Dashboards","datePublished":"2014-04-12T13:12:29+00:00","dateModified":"2016-10-13T10:34:50+00:00","mainEntityOfPage":{"@id":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#webpage"},"wordCount":1476,"commentCount":14,"publisher":{"@id":"https:\/\/ucanalytics.com\/blogs\/#organization"},"image":{"@id":"https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/04\/photo4.jpg?fit=615%2C1024&ssl=1","keywords":["Business Analytics","Data Visualization","Predictive Analytics","Roopam Upadhyay"],"articleSection":["Analytics Tips and Tricks","Data Science Career"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ucanalytics.com\/blogs\/essential-tips-create-winning-reports-dashboards\/#respond"]}]},{"@type":"Person","@id":"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6","name":"Roopam Upadhyay","image":{"@type":"ImageObject","@id":"https:\/\/ucanalytics.com\/blogs\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g","caption":"Roopam Upadhyay"},"description":"This blog contains my personal views and thoughts on predictive Analytics and big data. - Roopam Upadhyay","sameAs":["roopam"],"url":"https:\/\/ucanalytics.com\/blogs\/author\/roopam\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/04\/photo4.jpg?fit=615%2C1024&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3L0jT-Az","jetpack-related-posts":[{"id":55,"url":"https:\/\/ucanalytics.com\/blogs\/credit-scorecards-advanced-analytics-part-4\/","url_meta":{"origin":2267,"position":0},"title":"Credit Scorecards – Advanced Analytics (part 4 of 7)","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Modeling in Advanced Analytics The room, full of Analysts, erupts with a loud round of laughter when a young business analyst narrates to us an incident from his recent trip back home. A distant aunt inquired about his new profession. His response \u2013 I am into modeling. She got all\u2026","rel":"","context":"In "Credit Risk Analytics Series"","block_context":{"text":"Credit Risk Analytics Series","link":"https:\/\/ucanalytics.com\/blogs\/category\/risk-analytics\/credit-risk-analytics-series\/"},"img":{"alt_text":"4. Scorecard Simple","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/4.-Scorecard-Simple1.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/4.-Scorecard-Simple1.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/4.-Scorecard-Simple1.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/4.-Scorecard-Simple1.jpg?resize=700%2C400 2x"},"classes":[]},{"id":2783,"url":"https:\/\/ucanalytics.com\/blogs\/in-conversation-with-eric-siegel-author-predictive-analytics\/","url_meta":{"origin":2267,"position":1},"title":"In Conversation with Eric Siegel: Author ‘Predictive Analytics’","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"In Conversation with.. Today we are starting a new series on YOU CANalytics called 'in conversation with'. In this series we will talk to the leaders and experts of predictive analytics and big data to gain deeper insight into the field. Dr. Eric Siegel Our first guest for the series\u2026","rel":"","context":"In "Events & Interviews"","block_context":{"text":"Events & Interviews","link":"https:\/\/ucanalytics.com\/blogs\/category\/events-and-interviews\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/12\/Slide15.jpg?fit=290%2C210&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2912,"url":"https:\/\/ucanalytics.com\/blogs\/excel-use-secondary-axis-to-create-two-y-axes-data-visualization-banking-case-lab\/","url_meta":{"origin":2267,"position":2},"title":"Data Visualization – Banking Case Lab : Microsoft Excel – use Secondary Axis to Create Two Y Axes","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Analytics Lab Malcolm Gladwell in his book 'Outliers' says that it takes approximately 10,000 hours of training or practice for anybody to master a subject. There is nothing in the world that could beat hands-on practice for learning. Keeping this in mind let me start a new series on YOU\u2026","rel":"","context":"In "Analytics Labs"","block_context":{"text":"Analytics Labs","link":"https:\/\/ucanalytics.com\/blogs\/category\/analytics-labs\/"},"img":{"alt_text":"Presentation1","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/Presentation1.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/Presentation1.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/Presentation1.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/05\/Presentation1.jpg?resize=700%2C400 2x"},"classes":[]},{"id":1912,"url":"https:\/\/ucanalytics.com\/blogs\/data-visualiztion-pie-chart-or-bar-chart\/","url_meta":{"origin":2267,"position":3},"title":"Data Visualiztion – Pie Chart or Bar Chart?","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"The topic we are going to discuss today will fit into visual analytics and data visualization - 101. Though on the surface this is really simple, over the years I have seen many young and sometimes seasoned analysts make this mistake. Hence I feel it is apt for us to\u2026","rel":"","context":"In "Analytics Tips and Tricks"","block_context":{"text":"Analytics Tips and Tricks","link":"https:\/\/ucanalytics.com\/blogs\/category\/analytics-tips\/"},"img":{"alt_text":"Pie Chart","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2014\/03\/Pie-Chart-1.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":6013,"url":"https:\/\/ucanalytics.com\/blogs\/data-analytics-challenge-solve-the-case-of-shady-gambler\/","url_meta":{"origin":2267,"position":4},"title":"Data Analytics Challenge 1(Clue # 1) : Solve the Case of a Shady Gambler","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Data! data! data!\" he cried impatiently. \"I can't make bricks without clay. - Sherlock Holmes In this article, we are starting a new series on YOU CANalytics that can't proceed without your\u00a0participation to solve the data analytics mysteries. In the beginning of each article of this series, you will get\u2026","rel":"","context":"In "Analytics Challenge"","block_context":{"text":"Analytics Challenge","link":"https:\/\/ucanalytics.com\/blogs\/category\/analytics-challenge\/"},"img":{"alt_text":"Mystery Challenge plot","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/09\/Mystery-Challenge-plot.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/09\/Mystery-Challenge-plot.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/09\/Mystery-Challenge-plot.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/09\/Mystery-Challenge-plot.jpg?resize=700%2C400 2x"},"classes":[]},{"id":281,"url":"https:\/\/ucanalytics.com\/blogs\/credit-scorecards-predictive-analytics-part-7\/","url_meta":{"origin":2267,"position":5},"title":"Credit Scorecards – Business Integration of Predictive Analytics (part 7 of 7)","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Columbus - A lesson in Leadership Christopher Columbus \u2013 I have adored this man for various reasons at various stages of my life. At seven, I adored him because his mistakes were applauded and became part of history \u2013 Columbus mistook Native Americans for Indians because he thought he had\u2026","rel":"","context":"In "Credit Risk Analytics Series"","block_context":{"text":"Credit Risk Analytics Series","link":"https:\/\/ucanalytics.com\/blogs\/category\/risk-analytics\/credit-risk-analytics-series\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/7-Leader-225x300.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/posts\/2267"}],"collection":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/comments?post=2267"}],"version-history":[{"count":0,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/posts\/2267\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/media\/2268"}],"wp:attachment":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/media?parent=2267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/categories?post=2267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/tags?post=2267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}