Posted on

Data Visualization

 

SCENARIO

An operation director receives the sales volume data for 25 products on 6 markets for the past quarter, on a spreadsheet. She needs to report these business performances to upper management in a meeting, in 5 minutes.  She wants to report with visualized data, rather than with the plain numbers in the spreadsheet.

 

SOLUTION

Use a WorkWaltz custom automation tool to create a PowerPoint or Keynote presentation that contains bar charts for all 25 products in the six markets, in about 15 seconds.

Posted on

Data Summary

 

SCENARIO

The owner of a new wine store has an Excel spreadsheet that lists the wine origin, varietal, and sales volume of each transaction of the store in its first month in business. There are total of 9 origins, 9 varietals, and 200+ transactions. He wants to know the sales volume of each of the 81 combinations of the origins and the varietals, as well as the total volumes for each origin and each varietal. He figures that it’s too complicated for him or any of his employees to do the job manually using the available Excel features.

 

SOLUTION

Use a WorkWaltz custom automation tool to generate the pivot table for the exact data summaries he wants, in 50 seconds.

Posted on

Data Analysis

 

SCENARIO

A marketing director at a mobile business startup has a user data spreadsheet. There are a total of 10,000+ records in it, and one column of it holds the users’ country information. She wants to know what countries these users represent, what the top 5 countries are among them, the percentages of each of the top 5, and the percentage of the top 5 together among all represented countries.

 

SOLUTION

Use a WorkWaltz custom automation tool to process the spreadsheet and generate a pivot table in less than a minute. The pivot table will list all represented countries and the user count, percentage, and rank for each country. The table will be sorted by rank and will also provide the combined percentage of the top 5 countries.