How to "Visualize" Reports to Better Understand, Predict and Manage (Full 12 month license)

How to transform every day business data trapped in columns and rows into simple to grasp, visual operational reports in real time, an effective tool for seeing what matters for the overall management of the business. This version is under a three month license, allowing enough time to take the course and apply it. For a more affordable version with a three month license, see the course How to "Visualize" Reports to Better Understand, Predict and Manage (3 month license). 

If spreadsheets are used in your work, this course will change the way you look at them.

Working hard IN a business, there is precious little time to work ON it, to make things better. When time is found, trying to see what matters in columns and rows packed with too much data but too little meaning is a waste of precious resources!

In this coures you will learn to transform data from existing reports in a few minutes with a flick of a pen or a mouse, to know with precision what you need to do, and not do. 

The course includes:

  • Why are the Profit and Loss (P&L) and the Balance Sheet done the way they are
  • In depth look at the problems of these reports as tools for operating a business
  • A review of The Flaw of Averages
  • A review of The Foibles of Percentages
  • And an in depth review of the Dangers in Limited Comparisons
  • Why there is a need for Operational as opposed to Financial reports, though they may use the same data.
  • How to create these visonary reports to help visualize and understand instantly, in the flow of time what has happened
  • And is mostly likely to happen next.
  • Many examples
  • Lots of working together, in “real-time,” like Khan Academy
  • Independent exercises and study to help achieve mastery.
  • AND MORE

Based on a proven system with more than 80 years of successful application in a wide variety of businesses, packed with examples from sports, healthcare, retail, manufacturing and more, and step by step hands on practice, guided by an experienced and patient teacher.

You will need a pencil, an eraser, some graph paper preferably, a straight edge, a calculator, a computer and spreadsheet software would be nice, but most of all, your uncomputer… your mind. 

Entertaining but enlightening video, plus pdf’s for study, supplementary materials, and an hour or two of independent practice to move you from first exposure to mastering the art of making useful operational reports and how to apply them for breakthrough, almost magical results.

The Free Course, Income Statement Secrets, is a precursor to and required for taking this course.

Keywords: Accounting, finance, startup, entrepreneurial, how to keep the books, how to profit loss, problem solving, how to analyze data, sole proprietor, business, Excel, financial, starting a business, business analysis, small business business intelligence, Management, How to "Visualize" Reports to Better Understand, Predict and Manage (Full 12 month license)

How to "Visualize" Reports to Better Understand, Predict and Manage (Full 12 month license)

Introduction
Introduction
Introductory Review
Introductory Review
Cookin' the Books?
Cookin' the Books?

An Introduction to me, what you will need to do to maximize your investment in this course, and what you can expect from me.

Review of Income Statement Secrets Revealed
Review of Income Statement Secrets Revealed

A review of the free course, precursor to this course on the basics of turning Income Statements and other reports created to count, into easy to understand, actionable tools in real time to help produce and sell the things counted more effectively. Includes a review of the most important financial statements as governed by the GAAP, and covers some of the most troubling mistakes that are made in interpreting the report.

Review Single Datapoints and Limited Comparisons
Review Single Datapoints and Limited Comparisons

Why limited comparisons and single datapoints muddle understanding, with lots of examples.

Hurt'n to Learn
Hurt'n to Learn
Pele vs. Messi in Football, the one played with the foot!
Pele vs. Messi in Football, the one played with the foot!

Parlaying the baseball presentation in the precursor course, Income Statement Secrets, you will join me as I dig into the controversy over who was the best goal scorer in their first 8 years in football, what in the US is called Soccer. Both Pelé and Messi are monster players, and what will be learned goes so much deeper than just who is number 1, showing just how much context and understanding can be revealed in a visual representation of data.

How Our Humanity Trips Us Up
How Our Humanity Trips Us Up

What science explains about how we are not that logical after all, and why we so easily find connections in data that may not be there in the real world, and other suprising truths. Human beings like a sure thing, Nature likes complexity;we humans want a single answer that works, Nature provides webs of influence. The workfloor is where Human Nature and Nature meet, where we try and forge our ideas, opinons and theories where the rubber meets the road. To help you manage better, this module introduces a learning opportunity at the cutting edge of cognitive science, in preparation for the next module on an essential Natural Law, that controls the results of everything we do, goes against our intuition and our desires, and undermines our best efforts to reach our objectives and goals.

Nature varies
Nature varies

All work is done in processes, and involves material things. (even electricy is material). The behavior of processes is limited by natural law, which conflicts with human nature, and our aims. The little known but essential law of nature they didn't teach you in school is variation. It profoundly effects everything we do and makes our best efforts at making and achieving objectives difficult. Knowing it can provide a competitive advantage; mastering it lead to almost magical success. "For those who enter the same stream, ever different waters flow."

Signals and Noise
Signals and Noise
Shewhart's Rules for Presenting Data Visually
Shewhart's Rules for Presenting Data Visually

A short sweet to the point pdf presenting Dr. Shewharts rules for the visual presentation of data. Great stuff, really useful. Too many Data presentations fall in love with what the technology can do, and confuse the heck out of anyone trying to understand the meaning in the data.

Real Life Examples
Real Life Examples

From a doctor's office, a deli, a hospital, a hotel and more... even how to use to greatly enhance the use of a treatment of a girl with allergies. Nothing speaks more than real examples from people just like you!

Changing Glasses
Changing Glasses

A short but sweet call to action.

Finding the Meaning In 30 minutes or Less with Pencil and Paper
Finding the Meaning In 30 minutes or Less with Pencil and Paper

"All you need is 30 minutes and a pencil and paper to get what you need from the data..." W.E. Deming

We begin DOING, using the UNcomputer...

Learn by Copying Along, an Old But Effective Method
Learn by Copying Along, an Old But Effective Method

In the olde apprenticeships, you learned by standing side by side and working with a journeyman to learn. Repetition and the chance to observe, helped the learning sink in deeper. The Khan Academy created something simiar with their way of teaching, mimic'd in this module. It is one thing to know something theoretically, another entirely to take it in, digest and master it. The more powerful the tool the more damage you can do with it if you used it half well, or poorly. Better to not use it at all, at least then you have a 50/50 chance of making a good outcome. Here you have a chance to work along side me, as it were, step by step, copying what I do. it may save you from going off the deep end one day!

Working with Excel
Working with Excel
More Practice with Excel
More Practice with Excel
By Hand vs. Computer Smack Down
By Hand vs. Computer Smack Down

An Uncomputer vs Computer smack down!

Which is faster, which goes deeper, which do you prefer?

Turning Your Eyes to The Road in Front of You
Turning Your Eyes to The Road in Front of You

Management is Prediction. Without a theory you learn nothing, and the best you can do is 50/50, right today, wrong tomorrow: but armed with an understanding of the process behavior, once you get it running smoothly, you can reliably predict and thereby make the best possbile managment decisions.

More Excel-ent Examples
More Excel-ent Examples
Working in iWork Numbers
Working in iWork Numbers
Thermometer Allegory
Thermometer Allegory

What makes a household thermometer useful is it tells you if you have temperature and need to call the doctor, or not. It is a very simple tool, hardly precise, but good enough to do the job and save you a lot of money in Doctor's bills, or save your life if you really are sick. It can't tell you what you have, for that you go to the doctor and he probes deeper to find the root cause and treat it. In work, the Process Behavior Chart is a similar tool.

Exercizes
Exercizes
More Exercizes
More Exercizes
Even More Exercizes...
Even More Exercizes...
Seasonal and Other Effects
Seasonal and Other Effects

A look at more advanced work using a simple, affordable program from the Deming Collaboration Website, allowing you to look at seasonal and other effects without having to create a new chart every time. A great tool for understanding businesses like retail, agriculture, or any other business that has seasonal or periodic changes.

Setting Up an Effective Operational Report
Setting Up an Effective Operational Report

What a true Operational Report Looks like:

Creating the charts needed for a more or less universal report that measures how well your whole business is running, and lets you get a clear picture, in real time, of the health of your business operationally, and how well you are managing your TRUE costs, the overall costs of the system.

Setting Up an Effective Operational Report Two
Setting Up an Effective Operational Report Two

Taking the charts and formatting them into the complete report.

Understanding in an INSTANT!
Understanding in an INSTANT!

The application of the report created in the last two modules, to create instant, relevant, effective understanding in a way you could never dream of doing when seeing only in two dimensions as in the common financial reports.

A Project...
A Project...

What to do with your newly found time from your newly acquired knowledge: build a better system... in this case an ordering system as an example.

Connectedness
Connectedness

The importance of how things inter-relate.

Further Reading
Further Reading
Congrats!
Congrats!

An inspirational slap on the back... just for you...

Attachments:

Rubric or Cheatsheet on Formula for Calculating the Limits   (440 KB)
A cheatsheet, rubric or memory aid so you can calculate the limits of predictability on the charts.... hey, even Einstein was quoted as saying, "I never try to remember what I can write down."
Formula or Recipe for Describing Process Behavior   (160 KB)
Recipes may be for beginners, but boy do they help, and even the experts consult them. Use this until you don't need to anymore to describe a process behavior...
How the charts separate the signals from the noise   ()
From the most authoritative voice on process control and the application of statistics to everyday business problems, this article explains how and why the charts work, in case you are curious.
How to "Visualize" Reports to Better Understand, Predict and Manage (Full 12 month license)

Buy This Course

Price :

$24.00 ( Per License )

Visited: 2263 Times

Difficulty: Normal

# Licenses Discounted Price
1 $24.00
10 $22.00
51 $21.00
101 $20.00
501 $19.00
1001 $18.00
5001 $17.00

Resold modules appear on your website. You earn syndication share from each purchase. Contact Coggno to learn more on how to embed your own Portable Webshop in your website.

Syndication FAQs