Tools and Applications for Data Manipulation and Analysis

Programming for Business Solutions

Ariel Sepúlveda

Pronto Analytics, Inc.
www.prontoanalytics.com

Abstract

Although spreadsheets may keep a huge percentage of electronic data, the most widely accepted way of storing data is using relational databases. In any case, most professionals prefer to view data in two dimensions. Nesting or grouping data is very useful for analysis but not necessarily as useful or attractive for displaying or showcasing results. In conclusion, depending on the objective analysts need to master both ways of working with data: two dimensional for viewing and nested for manipulation and analysis.  

This presentation is about tools for both purposes. I will present a set of data manipulation and processing functions designed to simplify analysis of data read from databases, spreadsheets or any other format allowed in Mathematica. Additionally, I will highlight how these utilities have been used for creating several high-tech software applications for different kinds of customers. Software applications include paperless printing using image processing, automated graphical reports generation, and resource capacity planning among other.