Inhaltsverzeichnis
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
Zuletzt geändert: on 2026/01/29 at 11:28 PM
