8 Report Types for Better Information Delivery

An important distinction to keep in mind while designing and building your management operating system is the classification of information and reports in the Gather process.

Classifying helps you assign the right process, tools, data, and resources to information, reports, and the Gather process. Without an overt classification, you can end up delivering information inefficiently, or worse, incorrectly.

Here are some common classifications:

  • Financial. Usually relates to items found on the Profit and Loss statement, balance sheet, or cash flow. Content can be at a detailed or summary level.

    Enterprise Performance Management, A Management Operating System, EPM, Ron Dimon

    A Management Operating System

  • Operational. Usually contains information about volumes, units, headcount, inventory levels, and so on. Can also be at a detailed or summary level.
  • Executive. Typically cross-functional information at a summary level.
  • Sustainability. Information relating to environmental, health and safety, and community and social issues.
  • Management or Internal. Includes flash reports. Typically contains information managers need to make business decisions before being transformed for external consumption.
  • Statutory or External. Information that has been transformed according to GAAP or other regulatory standards.
  • Canned. Standard reports that are used over and over again.
  • Ad Hoc. Usually one-time information that’s situational and does not need to be retrieved later— although if found useful across different audiences and at different times can quickly find its way into a canned report.

You can learn more about EPM and how it can help your organization build a common business process to execute its strategy in my book Enterprise Performance Management Done Right: An Operating System for Your Organization (Wiley CIO)

8 Ingredients to Turn Data into Useful Information

9-3-2014 blog image

Data Consumption Is Undergoing a Major Shift

The most common process in the management cycle is Gather. Organizations spend an incredible amount of time gathering data and trying to turn it into meaningful reports, dashboards, scorecards, and spreadsheets. In other words, turning numbers into knowledge.

The purpose of all this activity is to find out where you are performing well and where you need to make some changes. However, with the plethora of data we’re getting, and with the speed at which change happens and transactions occur, it’s getting harder to find out exactly where you stand. How, when, where, and why we consume data is undergoing a major shift.

To turn raw data into useful information that you interact with, you need at least the following ingredients:

  • A purpose or business question to answer (e.g., “What are our sales by region?” or “Who are our top customers?”)
  • A point of view for the consumer of the information (board, corporate, strategic business unit, line of business, division, team, territory, external)
  • Built-in relationships— hierarchies, dimensions including time periods, apples-to-apples like currency translations, and context— year-to-date, actual vs. plan, etc.
  • The right level of detail (according to business questions and consumer)
  • The right metrics— whether it’s a financial account like revenue, or an operational driver like headcount or a key performance indicator (KPI) or a ratio like productivity, it has to fit the business question
  • Timelines— the information has to be delivered be delivered and consumed in time to do something about it
  • Some comparative information— a variance to the plan or to a prior period or a benchmark
  • The right way to deliver the information to the consumer (the right tool and platform)

You can learn more about EPM and how it can help your organization build a common business process to execute its strategy in my book Enterprise Performance Management Done Right: An Operating System for Your Organization (Wiley CIO)

A Management Operating System

I would like to introduce a framework for thinking about Enterprise Performance Management and Business Intelligence. The genesis of this framework came from my days working at Hyperion Solutions (later acquired by Oracle Corp.). It’s been called a management “operating system” for your company because, like the operating system of your computer, it helps govern input and output and manage what applications (or decisions) are being run and helps make the most effective use of resources (memory, disk space, CPU cycles). You can start anywhere on this closed-loop process to tell the management operating system story, and today I’ll share Gather – the most common part of the cycle, with you.

Enterprise Performance Management, A Management Operating System, EPM, Ron Dimon

A Management Operating System

Gather – While you are busy running your business (Execution, which means service customers, making products, selling in markets), you are generating lots of data. You gather that data and transform it into useful information (according to its context) and deliver it to the right people (according to impact and areas of responsibility).

This is the place where managers consume reports about the results of the business. It’s where they answer the question “where are we, right now?” Depending on your industry and your business, there are generally two kinds of reports: mostly financial and mostly operational. The trend has been to combine financial and operational information on one report, which is a good idea since the two are interrelated: financial investments help drive operational results, and effective operations help contribute to financial performance.

Reports are delivered in a variety of formats with a variety of tools and can be categorized as:

  • Canned (static) reports
  • Ad hoc or interactive reports
  • Dashboards and scorecards
  • Spreadsheets

Reports give their readers a snapshot of what results have been produced to date to help them gauge how close to their goals and targets they are.

You can learn more about EPM and how it can help your organization build a common business process to execute its strategy in my book Enterprise Performance Management Done Right: An Operating System for Your Organization (Wiley CIO)

Oracle OpenWorld Radio Interview: EPM Done Right

Here’s an interview about my book by the Oracle Application Users Group, OAUG from Oracle OpenWorld 2013.  Hosted by Lee Kantor and  Stone Payton of BusinessRadioX:

Click here to listen.

This was a lot of fun to do and we hit on the business value of EPM and some hot topics like Data Relationship Management and Governance, how to get started in EPM, and how to ‘bring it all together.’  As we discuss, EPM is not just for CFO and CIO anymore, this interview appeals to any business manager and leader who is responsible for helping execute on company strategic objectives.

OAUG Interview

SG&A Performance Management

Selling, General & Administrative (SG&A) expense is top of mind for many organizations right now.

Simple SG&A Value Map example

Simple SG&A Value Map example

Everyone in the enterprise has an impact on SG&A expenses.  From your salary, to the office supplies you use, to the travel you take on behalf of the company.  It’s everyone’s job to help maintain and control these expenses.

SG&A spend should be optimized at the “right” level to help deliver on the promises of the organization.  If they are at too low a level, sales revenue will suffer.  At too high a level, Read more of this post

Data Consumption is undergoing a major shift

A good decision is based on knowledge and not on numbers.
—PLATO

As EPM practitioners, our job is to help deliver better insights to the business, and the starting place is delivering useful information: on time, at the right level of detail, to the people who can use it to make a decision that helps improve short and long-term results.

With the plethora of data we’re getting, and with the speed at which change happens and transactions occur, it’s getting harder to find out exactly where you stand. How, when, where, and why we consume data is undergoing a major shift: Read more of this post