Analytics and reporting

1Input

A sales spreadsheet with several tabs and a table export from Power BI.

2Process

1. reads the spreadsheet and computes the pivot table with code - the result is reproducible
2. draws the charts and runs them through the Obsigen Magnify visual check before they go into the presentation
3. assembles the presentation from the data: every chart cites its source
4. saves the analysis as a spreadsheet with formulas, not pasted values
5. the result in the app or - via Obsigen Runtime - in your folder

3Result

Editable presentation + spreadsheet with the analysis - in the app or on your computer (Obsigen Runtime).

4Where the data is

The spreadsheet is stored in your tenant or in your folder. The table is computed by code, not by the model - the numbers are reproducible.

where it runs spreadsheet and pivot table: tenant or your computer · model: provider in the EEA · presentation: tenant or your folder

Data, layer by layer →

5Company glossary

Terms from this process and how Obsigen remembers them - sample entries in the company glossary:

margin

contribution margin I after discounts - column margin_1

Q3

July–September; fiscal year = calendar year

board deck

8 slides, one chart per slide, source under each