====== 1.3 Use Case: Self-Service BI ======

Business departments analyze data independently.

===== Initial Situation =====

  * Every analysis requires IT support
  * Weeks of waiting for evaluations
  * Frustration in business departments

===== Solution with Data Gateway =====

  * OData access for Excel and Power BI
  * Prepared views for complex queries
  * Permissions at database level

===== Example =====

Controlling analyzes cost development:

  - Excel -> Data -> OData Feed
  - Select view "vw_CostAnalysis"
  - Create Pivot Table
  - Refresh monthly

===== Result =====

  * Immediate data access
  * IT relieved
  * Higher data quality through direct access