1.1 Use Case: Reporting

Live reports from enterprise data.

Initial Situation

  • Reports based on outdated exports
  • Manual data preparation in Excel
  • Long wait times for IT reports

Solution with Data Gateway

  • Excel/Power BI connects directly to data source
  • Automatic refresh
  • Business departments create their own reports

Example

Sales manager creates revenue report:

  1. Open Power BI
  2. OData connection to Gateway
  3. Join tables Orders and Customers
  4. Dashboard with revenue by region

Result

  • Daily current figures
  • No IT request needed
  • Create report once, use daily
Zuletzt geändert: on 2026/01/29 at 11:28 PM