Beskrivning

In the modern BI world, data preparation is considered the most difficult, expensive, and time-consuming task, estimated by experts as taking 60%-80% of the time and cost of a typical analytics project. Some of the challenges in those projects include fragmented and incomplete data, complex system integration, business data without any structural consistency, and of course, a high skillset barrier. Specialized expertise, typically reserved for data warehousing professionals, is often required.

Such advanced skills are rare and expensive. To answer many of these challenges, Power BI serves analysts today with industry leading data preparation capabilities using Power Query in Power BI Desktop.

Now, With Power BI dataflows, Microsoft brings these self-service data preparation capabilities into the Power BI online service. A very good reason for involving dataflows is when the organization lacks a Datawarehouse.

The use cases of dataflows include:

• Creating transformation logic that can be shared and reused for Power BI datasets and reports.
• Establishing a single source of truth by forcing analysts to connect to dataflows themselves, instead of connecting to the underlying systems.
• Limiting access to an underlying data source for only a few select people, while letting analysts build on top of the dataflows.

Audience

This course is intended for data analysts who want to improve their data preparation skills.

The training provides individuals and teams with significant advanced skills manage their data preparation and distribution pipelines.

Prerequisites

As it’s an advanced course, attendees should have a good understanding of Power BI and want to master its core functionality.

Topics

All you want to know about dataflows will be covered in this 1 day workshop

Kursen levereras i samarbete med

Kontakta oss om denna kurs