Power BI Training
Training course for Microsoft Power BI, the suite for business analytics tools providing cloud-based analysis of business data.
At a glance
General information
2 half days remote or 1 day inhouse practical training (‘Basic’ module – pleases email to inquire about the ‘Advanced’ and ‘Coaching’ modules, see below)
Target group
Business Analysts, Business Users with a data affinity, Business Intelligence Developers
Application examples
Cloud-based analysis of business data by business analysts, specialist users with data affinity, and business intelligence developers.
Description
The Training sessions are usually held in German. Please contact us if you are interested in Training sessions in English.
Using Power BI, you can analyze, evaluate and visualize business data in real time and by using the self-service method. This allows business users to easily obtain knowledge from their data and make informed decisions.
We have developed a Training course that can be tailored to meet the exact demands of participants due to its modular structure:
- ‘Basics’ module (1 day)
- ‘Advanced’ module (1 day)
- ‘Coaching’ module (n days)
The above date relates to the ‘Basics’ module (1 day). If you are interested in the ‘Advanced’ or ‘Coaching’ modules, please contact us directly by emailing pbi-trainings@inovex.de. Thank you!
Agenda
‘Basics Training’ module [1 day]
Theory:
- Business Intelligence Basics and the evolution of Power BI
- Overview of Power BI services – Power BI Desktop, Service, Report Server, Power BI Embedded
- Interaction with other Microsoft data platform services
- Introduction into data modelling – what are relations, keys, normalization and why are these important for us?
Hands-on:
- Provisioning of sample data
- Data import – Flat File connection
- Data transformation – data cleansing, calculated columns, relations
- Data visualization – diagrams, filters, buttons
- Publication – Power BI Service, Power BI Report Server
Also available to book:
‘Advanced & Bring your own data’ module [1 day]
Theory:
- Advantages and disadvantages of various modelling methods
- Examples of data models from practice
- Acquaintance with DAX language
- Row-level security
- Creating your own tables with inquiries
- Inserting your own calculations
- Creating code definitions
- Using existing time intelligence in Power BI
- Creating temporary tables
- Making calculations more dynamic
- Data gateways
- Power BI Embedded
- Performance optimizations
- Power BI storytelling
- Scaling Power BI with analysis services tabular models
Hands-on:
- Hands-on connection with your company’s data sources
- Data modelling, transformation and visualization of your data
- Practical exercises using DAX language
- Instructions and tips on designing reports
- Integration into your ecosystem
A single day course will not always contain the entire scope of topics. Instead, the individual Training sessions will provide information on focal points that have been decided with the participants at the start of the day.
Also available to book:
‘Coaching’ module [contingent n day]
Individual consultation and coaching on Power BI
Example topics:
- Connection of complex data sources
- Doctor’s Inn: Surgery for employees of your company to ask their own questions about Power BI
- Creation of an authorization concept
- Creation of corporate design guidelines & templates
- Migration to the analysis services tabular model
- And much more, by arrangement
Typical questions we answer:
- How can I connect, import and transform data from different sources?
- How do I effectively define business rules and KPIs?
- Which powerful visualisation tools are covered in the training and how are they applied?
- How do I create engaging reports with Power BI?
- How do I share dashboards with my team and business partners and publish reports on the web?
- How do I create a meaningful data model and what considerations are important?
- How do I get a successful start using DAX (Data Analysis Expressions) for data analysis?
- signed certificate of participation
- experienced trainers
- small training groups
Trainers
Our trainers are field-tested experts in their areas of expertise. Through their work in projects, they expand their knowledge day by day and pass on this know-how in their trainings - application-oriented and practice-oriented.
Clemens Janoudi
Michael Riedmüller
Adam Ratka
Patrick Singer Ramos
Why inovex Academy?
Our offerThe inovex Academy has set itself the task of passing on knowledge about methods and technologies that we already use successfully in our projects.
Exchange experiences
In our open training courses, we attach great importance to the exchange of experience among like-minded people. Learn from and with other experts.
Curated content
All training content is carefully selected to achieve the best possible learning effect and to convey as much content as possible.
Individual Assistance
Our trainers come from a practical background and have already tested and successfully applied many of the contents taught in their daily work.
Customized flight altitude
Our training courses start where many standard courses end. Thanks to their interactive structure, we dynamically adapt the level to the participants' expert knowledge and are happy to delve deeply into complex issues.
Upcoming trainings
09:00–13:00 (Karlsruhe)
09:00–13:00 (Karlsruhe)
09:00–13:00 (Karlsruhe)
09:00–13:00 (Karlsruhe)
09:00–17:00 (Karlsruhe)
09:00–13:00 (Karlsruhe)
09:00–13:00 (Karlsruhe)
Frequently Asked Questions
Will I receive a certification as a result of the training?
On what basis was the training content designed?
How can I prepare for the training?
When does the training start?
Do I get an invitation? When do I get it?
Supplementary information
Collin Rogowski
Head of inovex Academy