{"id":8071,"date":"2014-06-24T10:00:48","date_gmt":"2014-06-24T15:00:48","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/blog\/?p=8071"},"modified":"2023-03-13T15:27:11","modified_gmt":"2023-03-13T20:27:11","slug":"7-ways-to-build-reports-that-your-executives-hate","status":"publish","type":"post","link":"https:\/\/www.mrc-productivity.com\/blog\/2014\/06\/7-ways-to-build-reports-that-your-executives-hate\/","title":{"rendered":"7 ways to build reports that your executives hate"},"content":{"rendered":"

\"Education\"Summary: As business data explodes at a surprising pace, many companies still struggle with reporting. They create reports that confuse or overwhelm their executives–hampering their ability to make decisions. What do your executives think about their reports? Do you make any of these reporting mistakes? <\/em><\/span>
\n<\/a>
\nHere\u2019s a surprising fact: Did you know that the volume of business data worldwide doubles every 1.2 years<\/span><\/a>? Think about that. In a little over a year, your business will have twice as much data as it does now.<\/p>\n

The big question<\/strong>: What is your company doing with that data? When used properly, this data can give you a massive competitive advantage over your competition. Businesses who quickly turn their data into meaningful management information will make faster, more informed decisions than those who don\u2019t.<\/p>\n

The problem<\/strong>: Most businesses still don\u2019t know what to do with this data. Creating reports over their data requires days or even weeks. The reports they do create are confusing or overwhelming–offering no real insight. Not only does this frustrate executives, it hampers their ability to make fast, informed business decisions.<\/p>\n

Today, let\u2019s explore a few ways to improve your reporting–by focusing on reasons an executive might dislike a report or find it frustrating. Your reports will most likely frustrate your company\u2019s executives, if you…<\/p>\n

1. Give them what they ask for (not what they need)<\/h3>\n

Henry Ford famously said, \u201cIf I had asked people what they wanted, they would have said \u2018faster horses.\u2019\u201d Does that mean you shouldn\u2019t ask your users what they want in their reports? No–though many people misinterpret this quote in that way. It means you must get beyond what they\u2019re asking for, and truly understand what they need. This goes beyond a simple criteria list. This requires a deep understanding of their goals.<\/p>\n

\u201cTo ensure that your report is hated, give the executives exactly what they ask for, instead of what they need,\u201d says Steven Lowe, Founder\/CEO at Innovator, LLC<\/span>. \u201cEnd-users tend to ask for things that are familiar, so they’ll ask for a report just like another report that they already hate, but with different data. And of course, then they’ll hate the new report, too. Surprise!<\/p>\n

Instead, work with the executives to determine what decisions the report is intended to support. Try to make the critical information obvious at a glance or a quick skim – highlight the truly relevant portions, and separate out the details in different sections or drill-downs (if interactive).<\/p>\n

Understanding how the information is to be used is critical to creating a useful report.\u201d<\/p><\/blockquote>\n

2. Show them all of the details<\/h3>\n
\n
\"photo
photo credit: PublicDomainPictures<\/a> via pixabay<\/a> cc<\/a><\/figcaption><\/figure>\n

\u201cAs someone who was thrust into providing reports for directors and managers one day to the C-Suite almost overnight, I learned through a baptism of fire how to turn a CxO\u2019s grin into a grimace,\u201d says Rob Patey, Director of Marketing at WorkZone<\/span><\/a>. \u201cWhen dealing with the C-Suite it\u2019s important to remember their chief concern \u2013 performance. Not performance of individual project steps or other in the weeds metrics, but true performance driving bottom line growth.\u201d<\/span><\/p><\/blockquote>\n

The true challenge of creating reports: presenting an overwhelming amount of data in an easily digestible form. Too many people make the mistake of cramming all of the data into a report, and assuming that\u2019s a good thing. As Patey explains below, executives don\u2019t care about every bit of data. They care about the data that drives action.<\/p>\n

\u201cFor years I needed to examine each subtle nuance of every campaign in the grand marketing mix: clicks, opens, engagement of each step through the funnel,\u201d he says. \u201cThis insight was essential to ensure the following campaign repeated successes and avoided pitfalls. When I first showed this report inside the ivory tower, it was met with utter silence. I had thought for a second I misunderstood the very definition of the word \u201creport.\u201d After my performance to a slew of stone walls, one executive kindly stated, \u201cyou need to go back to the drawing board and show us exactly how this grew our customer base and revenue without all the steps to get there. We simply don\u2019t have time to sift through all of this to get the fast answers we need.\u201d It was an appreciated lesson that has served me well ever since.\u201d<\/p><\/blockquote>\n

3. Offer no context<\/h3>\n

Taking the previous point one step further–displaying too little data creates problems as well. Most notably, reports or dashboards with too little data lack context. For instance, suppose you view a report that indicates customer support requests have plummeted. That\u2019s great news, right? It is…until you add the context that you\u2019re losing record amounts of customers to the competition. As you see, data without context can be very misleading, and result in misinformed decisions.<\/p>\n

\u201cData reporting dashboards should be designed to incorporate business nuances, not just report on data-driven facts,\u201d says Gina Miller, VP, Director of Customer Experience and Demand Management at CBD Marketing<\/span><\/a>. \u201cA downward trending line on a chart is not actionable. Similarly an upward trending line on one chart could indicate a positive business result, say for the sales of a new flavor version of a product. But if you overlay other flavor versions of that product and year-over-year comp store sales data, you might see that the new product is only cannibalizing your other products, not driving real growth. It’s the context that counts, not the data. Charts cannot explain the whys, and the whys are the reason the executives exist – to correct the course of business.\u201d<\/p><\/blockquote>\n

4. Make it available in just one format<\/h3>\n

Another common reporting mistake: creating a report that looks great on a computer screen, but not on paper. Many executives prefer to print their reports, but without a well-formatted print version, the report will be nearly unreadable.<\/p>\n

\u201cMany top-skilled analysts, IT specialists and project managers are unable to get their point across (or proper credit for their work) when their one page year-long data report prints out on 16 partially inked up pages,\u201d says Amethyst Polk, Senior Associate (Development) at the American Red Cross<\/span><\/a>. \u201c1 minute of manipulating data in \u201cPrint Preview\u201d can help save several dollars in ink toner and paper, labor hours in print services, and stress in that last 5 minute hustle before an annual meeting.\u201d<\/p><\/blockquote>\n

\"How
How well do your reports work on mobile devices?<\/figcaption><\/figure>\n

Going one step further, modern web-based reports must be available across all devices. After all, you don\u2019t know how an executive will access your report. Maybe they\u2019ll view it on a PC. Maybe they\u2019ll view it on a tablet. Maybe they\u2019ll view it on a smartphone. Modern web applications (including reports) must adapt to any device.<\/span><\/p>\n

5. Use text bullets to explain complex ideas<\/h3>\n

A picture is worth a thousand words–and that\u2019s especially true with reports. Many make the mistake of using too much text in their reports, rather than a single chart or image which would have easily conveyed the message.<\/p>\n

\u201cI’ve had meetings where we spend 20 minutes trying to explain new marketing ideas that could have been explained in less than 5 minutes with a screenshot or diagram (instead of a text bullet in a Word document),\u201d says Neena de Leon, Marketing Lead for Anywhere Pad<\/span><\/a>. \u201cNeedless to say, executives dislike spending more time than necessary.\u201d<\/p><\/blockquote>\n

6. Give them old data<\/h3>\n

\u201cExecutives and end-users quickly become frustrated trying to work with data that is not real time,\u201d says Kreg Decker, President and CEO of One Vision Solutions<\/span><\/a>. \u201cIt is like driving a car with a gas gauge that shows them how much gas they had last week. Executives can’t make effective decisions when looking at financial or project performance metrics as they stood days (or sometimes weeks) ago.\u201d<\/p><\/blockquote>\n

Of course, if you\u2019re creating monthly, quarterly, or yearly reports for review, this point doesn\u2019t apply. However, if you\u2019re creating web reports that your executives or users will access when needed, real-time data is essential. As the pace of business quickens, real-time data at your fingertips becomes more important than ever before.<\/p>\n

7. Give them static reports<\/h3>\n

In the past, many IT departments delivered unalterable, static reports to executives. If executives needed to see that data in a different way, filter or sort that data, or just drill down into more details, they made another request to the IT department. These days, static reports will frustrate your executives. Modern reports must allow for filtering, sorting, and drill-downs–letting your executives view the data from multiple angles without going back to the IT department for changes.<\/span><\/p>\n

\"An<\/a>
An example of a report with sorting\/filtering options.<\/figcaption><\/figure>\n

\u201cDependence on someone to create reports ensures a disconnect between when someone needs information and when it is available,\u201d says Decker. \u201cFor years, “ad-hoc” reporting was a part of most every company we worked with. With tools and reporting, self-service reporting frameworks can be built that allow the user to drill-down to the data they need without the need to halt their workflow and request another report. This streamlines the reporting process saving money and allowing for faster decision making.\u201d<\/p><\/blockquote>\n

So, what do you think? Is there anything you would add to this list? If so, please share your thoughts in the comments.<\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: As business data explodes at a surprising pace, many companies still struggle with reporting. They create reports that confuse or overwhelm their executives–hampering their ability to make decisions. What do your executives think about their reports? Do you make any of these reporting mistakes?<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","slim_seo":{"title":"7 ways to build reports that your executives hate - mrc's Cup of Joe Blog","description":"Summary: As business data explodes at a surprising pace, many companies still struggle with reporting. They create reports that confuse or overwhelm their execu"},"footnotes":""},"categories":[8],"tags":[23],"class_list":["post-8071","post","type-post","status-publish","format-standard","hentry","category-education","tag-web-reporting"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/8071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/comments?post=8071"}],"version-history":[{"count":7,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/8071\/revisions"}],"predecessor-version":[{"id":14642,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/8071\/revisions\/14642"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/media?parent=8071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/categories?post=8071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/tags?post=8071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}