1.3 Use Case: Self-Service BI

Business departments analyze data independently.

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

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

Controlling analyzes cost development:

1. Excel → Data → OData Feed
2. Select view „vw_CostAnalysis“
3. Create Pivot Table
4. Refresh monthly

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