Efficient Data Modeling Using the Star Schema in Power BI and Excel
Create, optimize and use data models
4.6
Basics of data modeling
- Data modeling in OLTP databases such as relational SQL databases.
- Data modeling in OLAP databases such as Power BI.
The strengths and weaknesses of the flat table as a data model
The necessity of the star scheme
- Improved evaluation options.
- Simplified DAX commands.
- Storage space and performance.
Data import with the help of Power Query
- Creation of dimension and fact tables.
- Data cleansing and transformation such as UnPivot functionality.
- Differentiation between joins in Power Query and relationships in Power Pivot.
Basics of the star chart
- Basic relationship management in Power BI (1:1, 1:n, n:n).
- Active and inactive connections, e.g. for date tables.
- Multi-fact scheme for complex target/actual comparisons.
Best practices for data modeling
Practical exercises and case studies
- Development of own data models.
- Discussion and Q&A.
Once you've logged in, you'll find useful information, downloads, and additional services related to this Qualification Program 2 in your online learning environment.
- Learn the basics of data modeling with Power BI and Excel.
- Develop your own data models to make reports and dashboards more efficient.
- Understand the importance of relationships between tables and learn how to use them optimally.
- Gain new insights through practice-oriented case studies and exercises.
Presentation, practical examples and independent exercises on the PC, sample solutions, tips and tricks.
Due to the workshop character of the seminar, questions, tasks and own suggestions for solutions are very welcome, so that a high level of practical relevance is guaranteed.
To take part in the training , you will need your own laptop with Microsoft Excel installed (Office 365 is recommended) and Power BI integrated (the latest version is recommended).
controllers and users from other areas who want to integrate complex data structures into reports and dashboards.
Good basic knowledge of MS Excel and regular use of pivot tables are required. The training is not suitable for Excel newcomers .
Previous knowledge of Power Query is helpful, but not required.
41992
- Customized training courses
- Direct application in practice
- Efficient use of time and resources
Ratings and feedback from our participants
Start dates and details
Wednesday, 09.09.2026
09:00 am - 5:00 pm
Thursday, 10.09.2026
09:00 am - 5:00 pm
Monday, 30.11.2026
09:00 am - 5:00 pm
Tuesday, 01.12.2026
09:00 am - 5:00 pm
Monday, 01.02.2027
09:00 am - 5:00 pm
Tuesday, 02.02.2027
09:00 am - 5:00 pm
Monday, June 14, 2027
09:00 am - 5:00 pm
Tuesday, June 15, 2027
08:00 am - 4:00 pm
- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
Monday, September 20, 2027
09:00 am - 5:00 pm
Tuesday, September 21, 2027
09:00 am - 5:00 pm
The next booking ensures this course will take place- one joint lunch per full seminar day,
- Catering during breaks and
- extensive working documents.
About us - The Haufe Akademie
Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.
Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.
A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.
Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.
Do you have any questions?
We are there for you Monday to Friday 8:00 a.m. - 5:00 p.m.
Questions & Answers
In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.
Munzinger Str. 9
79111 Freiburg
- Planning security
- Free seminar places
- Quality standards
- Planning and locations
- Funding opportunities
- Training app
- Business Solutions
