think-cell chart case study
This is the shortened online version of a case study conducted with one of our major customers.
Consulting firms spend a large share of their resources on client communication. Most leading consulting firms employ specialists to translate their consultants' findings and recommendations into convincing client deliverables. These specialists have gained years of experience and developed a best practice building upon the industry standard Microsoft PowerPoint.
Still, our own personal experience in a consulting firm and anecdotal evidence from other consultants and graphics experts indicated a large potential for improving slide creation efficiency.
Starting from these indications, we spent half a year conducting interviews and observing work flows to thoroughly understand the problem. We then used test scenarios to quantify our qualitative impression. We focused heavily on software efficiency. We cooperated with a top-tier strategy consulting firm, and they allowed us to publish this data anonymously.
Identification of improvement potentials
The exhibit to the right shows the distribution of time that graphics experts spend working at the site of one of our customers. 11 percent of their time is dedicated to slide-specific drawings. Another 26 percent is spent on typing text on the slide. Both fractions offer only limited potential for improvement. Typing speed is limited by the keyboard skills of the user, while creating drawings is difficult to standardize using intelligent software.
22 percent is spent on the production of business charts from numerical data. By far the largest fraction of time is spent on arranging text, drawings and charts to create the final slide layout (41 percent). Both chart and layout times exclude typing text. Including text-typing time, 30 percent of the work time is spent on charts and 59 percent on non-numerical standard slide components, not including drawings.
Both chart production and slide layout production have a high potential for improvement, since charts and slide layouts are usually standardized within a company and bound by common design rules, which can be formalized into a computer program.
In the rest of this study, we focused on the impact of using think-cell chart, which was designed to exploit the described efficiency gain potential in chart production. As a first step, we took a closer look at the types of charts used by consulting firms.
The exhibit below shows that only a few chart types account for a large fraction of all used charts in the cooperating consulting firm. We compared this result with results obtained from other consulting firms and found it to hold true everywhere, with the dominating chart types varying slightly across different firms.
To quantify the impact of new software on the creation and alteration of charts, we selected a set of 48 typical charts out of a portfolio of archived slides. The exhibit to the right illustrates that the mixture of chart types in the test set resembles the mixture obtained by analyzing a much larger slide set. Our cooperation partner counted the number of different chart types in a set of 1000 slides picked randomly from its portfolio. 468 of these slides had a chart.
We created two scenarios from the test set. The first scenario simulated the typical creation process: A chart is sketched by a consultant, faxed to the graphics expert and turned into PowerPoint. In our test, a highly experienced graphics expert from our cooperation partner turned the sketches into PowerPoint slides.
He was allowed to use the firm's regular set of templates for typical chart types and quantities (4-column, 5-column, ...) and also the macros already in use (for legends, units of measurement, etc.). We took the time required to create the charts.
For the second scenario we printed the slides created in the first scenario, annotated them with typical changes a consultant would make, and handed them back to the graphics expert. We again took the time to incorporate the changes into the slides.
The same two scenarios were used to evaluate the efficiency of think-cell chart.
The main finding is illustrated by the exhibit below. It shows the cumulative time required for creating and changing the charts specified by our test set. In the case of our cooperation partner, alteration accounts for approximately 60 percent of chart production time. Hence, we scaled the time for chart alteration by two. This resembles the common assumption that one creation cycle leads to at least two cycles of alteration.
The total time required to finish the test set using PowerPoint together with templates and macros was over ten hours. The total time needed to finish the test set using PowerPoint with think-cell chart was approximately three hours. This implies an overall speed-up factor of 3.2.
The exhibit below breaks this result down to the four chart types that were included in our test. All chart types benefit quite evenly from using think-cell chart, especially in the alteration scenario.