ThinkTWENTY20

  • HOME
  • ERIC'S BLOG
  • FORUM
      • Hey! What's New?
  • ABOUT US
  • CONTACT US
  • REGISTER
      • ThoughtLeader Gateway

Time for Financial Professionals to Get Graphical

on 30 January 2020

In the Fall 2019 issue of ThinkTWENTY20, I wrote about assurance issues related to digital media – moving beyond numbers and words in reporting and audit workpaper/audit evidence issues related to images and video.

 Financial professionals often leverage charts and graphs and other visualizations as ways to present results, to help highlights trends and relations between data points. Visuals can provide “the big picture” rather than being in the weeds. So using graphics and visualizations for telling a story, or marketing, or getting and keeping people together through steps, facilitating understanding and using additional senses to help in remembering information is common.

But I want to talk about graphical tools for information gathering rather than telling, for managing and analyzing, jumpstarting thinking, and helping with beginning to end processes.

My introduction to “graphics” in the audit function was the green plastic IBM process flowcharting template. It was provided to me at my initial Arthur Andersen audit training at the St. Charles campus on the Fox River. (I guess the facility is now known as the “Q”.) This was before the IBM PCs and flowchart software.

As I noted on my LinkedIn, using the PC for modelling and simulation is how I first became aware of my passion for the PC many years back. It was the earliest days of the PC and Lotus 1-2-3 (yes, that long ago), and I was asked to use this new tool to help develop a model for a local dairy being acquired by a larger organization. I was asked to simulate delivery routes to help in projecting revenues for the merged organization. I was the “human” simulator, as optimization was not built in; counter-intuitively, I was able to prove that fewer routes turned into more income, getting a substantially bigger offer for the seller. The hours on that project flew by, and I knew I wanted more. But graphics were not yet a big part of that story. And graphics were not yet an input to the process, rather than the output.

Enter a spreadsheet called Javelin. Javelin did turn things upside down. It had unusual features for financial modeling. One was about creating (or rather being able to update) the numbers from the charts, rather than the charts from the numbers. You create a bar chart. You decide one of the bars should be longer or shorter. You click, drag to size, and the underlying numbers update to match. Microsoft added this functionality to Excel, moved it to an ad-on for Excel 2007, and I’m not sure what the current status is.

I hope, over the next few blog entries, to speak about gaining control and getting graphical. I’m catching up on the status of some old friends that brought the green template into the personal computer age – flow charting and process charting tools, which seem to have lost some ground as Microsoft built capabilities into Office products. I want to talk about Mind Mapping, Topic Maps/Knowledge Graphs, and other planning, brain storming, simulation and analytical tools.

And we’ll discuss different ways of getting started (e.g., text, tables, outlines or templates/digital stencil, drag and drop, connections (or both)), and how to leverage information once entered.

Your constructive thoughts to guide the dialogue warmly welcomed.

Leave a comment

    Comments

    • No comments found
    Powered by Komento
    Forum Recent Posts
    Top Technology Trends for 2023
    Tuesday, 10 January 2023

    It’s the time of year when predictions are being made for the top technology trends for the new year – 2023. We have assembled a number of them for this article.

    They show considerable diversity, in part because of the differing perspectives of the organizations making the predictions. However, there is also some unanimity. Some ideas stand out.

    Passage of the Financial Data Transparency Act
    Friday, 30 December 2022

    In December 2022, a watershed moment took place for regulatory filings and, indeed, financial reporting when the US Senate passed the Financial Data Transparency Act (FDTA).

    The act was passed by the House of Representatives in November 2021. It calls for the eight major US financial regulatory agencies to adopt and apply data standards which render their data fully machine-readable and searchable – meaning, as a practical matter, to adopt XBRL. This act will result in enhanced transparency, comparability, and usability of the data collected by the regulators.

    ThinkTWENTY20 © 2023. Privacy Policy
    Login

    username / password