Info
The workshop aims to provide participants with a deeper understanding of business analytics and the practical challenges faced by business users when working with data. Through hands-on examples with Microsoft Power Pivot and Power BI and interactive discussions, attendees will gain valuable insights into building effective self-service BI solutions and communicating data-driven results clearly and professionally. As places are limited, registration is required.
Self-Service Business Intelligence Workshop feat. Power BI
One-Day Agenda (09:00–15:30)
Prof. Dr. Peter Lehmann & Friends
08:30 - 09:00 | Registration & Welcome Coffee
09:00 – 09:15 | Workshop Introduction
Peter Lehmann
- Overview Introduction and objectives
- Participant expectations
- The Self-Service Business Intelligence (SSBI) process at a glance
09:15 – 10:00 | Self-Service BI Architecture
Peter Lehmann / N.N.
- The end-to-end data flows
- For me? For my team? For my business unit? For the global information factory?
- Collaboration between business and IT
- Building sustainable reporting solutions
10:00 - 10:45 | Data Preparation – Creating High-Quality Data
n.n.
- Power Query best practices
- Data cleansing and transformation
- Combining and reshaping data
- Common challenges and optimization tips, do and don's
10:45 – 11:00 | Coffee Break
11:00 – 12:00 | Data Modeling – Building Efficient Models
Peter Lehmann
- Star schema fundamentals
- Relationships and filter context
- Using AI Agents for Modelling: MCP Server, Ontologies, CoPilot
- Best practices for scalable semantic models
12:00 – 13:00 | Lunch Break
13:00 – 14:00 | Data Visualization – Turning Data into Insights
N.N. / Information Design
- Selecting the right visuals
- Dashboard design principles
- International Business Communication Standards
- Interactive features such as slicers, drill-through, and tooltips
14:00 - 14:15 | Coffee Break
14:15 – 14:45 | Information Sharing - Delivering End User
N.N. / Data Communication
- Integrate Report into Dashboards
- Integrate Reports into Web Apps
- Integrate Reports into MS Excel and PowerPoint
14:45 – 15:30 | Microsoft Fabric
N.N.
- Why Microsoft Fabric?
- What is Microsoft Fabric?
- End-To-End-Analytics with Fabric
- Adoption, Use Cases & Future
