TRANSFORM-it

Pre-build calculations, groupings, pivots and un-pivots for reporting

To get the best performance out of your reporting and visualization tools, you are going to need to pre-build some Datasets. Data Academy makes this really easy, by providing all the tools you need via one "point and click" interface, so you no longer find yourself picking through 300-line "SELECT" clauses.

Using un-pivot, you can re-normalize previously pivoted data while our pivot operator will automatically add columns when required to your output. A full range of incremental options are also supported to enhance run-time performance.