Power BI Training by scieneers

Microsoft Power BI has risen to become the market leader in business intelligence software over the last few years, and not without good reason. Once started as a Powerpivot in Excel, the range of functions has been steadily expanded to the Power BI Premium Edition, which also leaves little to be desired in terms of Corporate BI. Microsoft wants to democratize access to data for all user groups and make Power BI a PowerPoint for data.

We want to help our customers fully realize the potential of their enterprise data with Power BI! View a sample how this could look like here.

Hands-on experience

Practical experience from projects flows into the design and instruction of the training.

No prior knowledge required

Gradation according to different skill levels picks up everyone optimally.

Targeted learning

Modular structure to expand knowledge in a targeted manner.

Fast and flexible

Flexibility in appointments and well-tuned length of units

Practice-oriented

Hands-on exercises help with the active transfer of knowledge.

Certified Solution Partner expertise

We are Microsoft Data and AI Solution and Power BI Solution Partners and also have the Advanced Specialization Analytics on Microsoft Azure. Therefore we have exclusive access to contacts, resources and go-to-market programs at Microsoft.

Certified experts

Our Microsoft certified trainers have been working for years with Power BI in the project business on a daily basis.

Your data problem?

Is also solved! We support you beyond a training course.

Your trainers

Milo Sikora

BI Consultant

Microsoft Certified Power BI Data Analyst Associate and Azure Enterprise Data Analyst Associate as well as Microsoft Certified Trainer (MCT). Milo’s main technologies in project business are Power BI and the Azure Data Platform.

Melanie Massmann

BI Consultant

Microsoft Certified Data Analyst Associate for Power BI. Mel’s main technologies in project business are Power BI and the Azure Data Platform.

Sascha Götz

Senior Data Engineer

13+ years professional experience in Power BI, SQL Server BI and Azure Data Services. Microsoft Certified Trainer (MCT) und Microsoft Certified Data Analyst Associate for Power BI and Microsoft Certified Systems Expert (MCSE) for SQL Server BI.

discover offerings

Our Power BI training offerings for you

Basic Training Power BI

The basic training is offered in 4 modules. These build on each other and can be spread over different days. A module lasts approx. 2 hours and contains exercises that the participants can perform themselves. Participants who finish all 4 modules will receive a personalized certificate.

Get in touch

Data access and preparation

Loading data from Excel and CSV into Power BI
Transforming the data – preparing the data to be able to use it for reports
Prepare tables in Power Query (M) and load them into the model

Data modeling and analysis

Data modeling in Power BI – linking tables together
Create different types of charts (Power BI Visuals): filter, bar chart, line chart, map, etc.
Data analysis – tagging and cross-filtering
Creating groups and hierarchies in dimensions
Creating key figures with DAX (Basic)

Data Visualization

Create templates for uniform formatting to develop Power BI reports faster
Adjust color palette centrally to corporate design
Build reports and design options (navigation, filters, interaction)
Power BI @Mobile App – adapt existing report for mobile app
Using custom visuals

Collaboration on PowerBI.com

Manage workspaces and access, publishing reports
Create and share dashboards
Collaboration and distribution in Power BI
Power Bi App Creation
Access via Mobile App

Advanced Training Power BI

The advanced Power BI training is also modular. One module takes about 2 hours. Since the individual modules do not build on each other in terms of content, you can combine them freely and tailor the training exactly to your needs. In this way, your know-how is expanded in a targeted manner!

Get in touch

Power BI Dataflows

Differences between Dataflows and Power Query in PBI Desktop
Transformation of data in the cloud with Power Query (M)

Power BI Administration & Gateway

Differences between Power BI versions
Licensing
Administration & Settings Power BI Service
Workspaces & Permissions
Setting up gateways to access local source systems from the cloud

Advanced Data Modeling and Data Shaping

Live Connect, Import, Direct Query – what is the ideal way to access which data?
Column-oriented in-memory database, data compression – how does it work under the hood and how can you optimize the performance of your own model?
BI data modeling in comparison according to Star, Snowflake, Galaxy schemas in the context of Power BI.
Hands-on modeling examples in Power BI

Data Analytics Expressions – DAX

Row and filter context
Scalar and table functions
Differences between calculated columns and measures
Use of parameters
Calculate function
Iterator functions: countx,sumx, etc.
Calculated tables with DAX
Time Intelligence functions

Application Lifecycle Management for Power BI

Code Versioning
Structured deployment of artifacts
DevOps Tooling basics

Data Science & AI in Power BI

Extensions with Python and R like special plots with many pixels
Integrated usage of AI services like text analysis and vision (premium features)

Power BI Embedded / Premium

Use of Power BI content in your own portal
Integration with Office 365
Power BI deployment pipelines
Authentication (token generation) independent of Azure AD

Bring your own data

Feel free to bring your own data sources/models! We are happy to help you with individual questions in your context, such as the connection of complex rest APIs.

Get in touch

Data Consulting

Appointments on short notice
We charge for consulting on an hourly basis

Submit non-binding request

Conditions

For the foreseeable future, only online training is possible.

Power BI Basic: All-inclusive price for online training consisting of the 4 basic modules with up to 8 participants of your company: 1.500 Euro

Power BI Advanced: All-inclusive price per module (2h) with up to 8 participants of your company: 500 Euro

Power BI Consulting: We are happy to offer them individually based on hourly rates

Working environment: Setup and usage fee for work environment via remote desktop per installation: 100 Euro

Prerequisites

One laptop per participant with Power BI Desktop installed would be optimal.

If this is not possible, we will also be happy to provide a dial-in option via Remote Desktop with installed setup after prior consultation. Access is then via Remote Desktop. There is a small setup fee.

Training can be held in German or English language. All documents are in English.

Power BI Training by scieneers

8 good reasons for choosing the Power BI-Training by scieneers

Hands-on experience

No prior knowledge required

Targeted learning

Fast and flexible

Practice-oriented

Certified Solution Partner expertise

Certified experts

Your data problem?

Your trainers

Milo Sikora

Melanie Massmann

Sascha Götz

Our Power BI training offerings for you

Basic Training Power BI

Data access and preparation

Data modeling and analysis

Data Visualization

Collaboration on PowerBI.com

Advanced Training Power BI

Power BI Dataflows

Power BI Administration & Gateway

Advanced Data Modeling and Data Shaping

Data Analytics Expressions – DAX

Application Lifecycle Management for Power BI

Data Science & AI in Power BI

Power BI Embedded / Premium

Bring your own data

Data Consulting

Submit non-binding request