Zum Hauptinhalt springen

Data exports for analytics

Img

In the Data Export section of a Nooxl App you find extracts of your applications data, meant for analysis purposes. The data is provided as excel files containing all the data on the different sheets, which can for example be used to create a simple data model in pivot to do data analytics.

Of course the data can also be analyzed in any other tool which can import data from excel.

Download data exports

Depending on your App there maybe multiple data exports available to you. You can download a data export as an excel file, by clicking on the Img button.

Img

Exploring the content of data exports

You can take a peek into the data extract by clicking on the Img button to open the exports details. Inside

you find a list of all dimensions11  and fact tables12 ! which contain the actual data, called grains13.

  1. https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/ dimensions-for-context/
  2. https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/facts- for-measurement/
  3. https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/grain/

Img