Power BI Query - Schulung in Berlin

Use Power Query in Power BI: From data cleansing to complex transformations to process automation.

Description

Use the full power of Power Query in Power BI: From data cleansing to complex transformations to process automation. In this practical training you will learn how to design ETL processes professionally and implement them efficiently. After the training, you will master the most important techniques to optimally prepare your data for analysis.

Target group

Power BI (specialist) users, business analysts

Duration

1 day

Content in detail

Introduction to Power BI

• Overview of the Power BI environment: Desktop, Service, Mobile
• The workflow in Power BI: Retrieve, transform, visualize data

Introduction to Power Query

• Get to know Power Query as an ETL tool
• Use the Power Query user interface effectively
• Professionally integrate various data sources
• Optimally import and transform Excel files
• Basic Perform and understand data transformations

Data cleansing with Power Query

• Efficiently cleanse unstructured data
• Strategies for dealing with duplicates and missing values
• Data types and their correct use
• Pivot and unpivot tables professionally

Advanced Transformations

• Create custom and conditional columns
• Apply complex functions for text, numbers and dates
• Group and aggregate data professionally
• Skillfully merge and append multiple queries
• Use the advanced editor for complex transformations

Optimization and performance

• Best practices for efficient Data models
• Improve loading times through optimization techniques
• Systematic troubleshooting and debugging

New: Book online training now

On the mutually agreed training day, your trainer will contact you and first mirror his screen onto your computer - and vice versa if necessary. Ideally, you should have a second PC or laptop ready for your own exercises. Then the training can begin.

With online training you save time and travel costs and can use the hours gained productively for your daily business.

For further information, call us.

Further information

For companies, this training can also be carried out as in-house training. Please contact Rebecca Schlesser about this - by email schlesser@atvisio.de or by phone 0631/4140140