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.

3 Replies to “Data Analysis”

Leave a Reply

Your email address will not be published. Required fields are marked *