Speaker

Štěpán Rešl

Štěpán Rešl

Power BI MVP | Managing partner & Lead technical consultant

Prague, Czechia

I am a data lover, especially in the ecosystem of Microsoft tools. I primarily focus on Power BI, Azure Synapse, and Azure SQL. In general, I follow a very simple motto.

"Don´t say it cannot be done, or someone who doesn´t know it will come and do it."

I am a co-founder and a Lead Technical Consultant at DataBrothers. We are Power BI experts and consultants with a focus on data analysis, reporting, and training in Power BI. We work with our clients across the globe on developing custom solutions and training their users on all levels (from business to development).

Awards

Area of Expertise

  • Information & Communications Technology
  • Business & Management
  • Media & Information

Topics

  • Microsoft Power BI
  • Power Platform
  • Power Query
  • M language
  • DAX
  • Analytics and Big Data
  • Azure Data Lake
  • Data Modeling
  • Microsoft Power Automate
  • Azure Data Factory
  • Azure SQL Database
  • Azure Synapse
  • Azure Synapse Analytics
  • Azure SQL Synapse
  • Azure Synapse Analytics (formerly Azure SQL DW)
  • #PowerPlatform
  • Microsoft Power platform
  • Azure Logic Apps
  • Microsoft Logic Apps
  • Technological Innovation
  • Vizualization
  • Data Storytelling
  • Azure Data Platform

Open indexed windows full of new options for visuals

New features mean new possibilities! This is doubly true for the DAX language! Because almost everything that can be written using it can be transformed into a visual and thus support our story, which we are trying to tell with data. Specifically, the INDEX, WINDOW, and OFFSET functions are those that can not only support the clarity of reports but also make them faster! At the same time, in combination with Calculation Groups, it can create incredibly dynamic synergies. So let's look at them together.

Extracting data from Power BI datasets

Today we use Power BI daily. We prepare reports, dashboards, consume applications and scorecards.

We can go much further thanks to specific options, such as Power BI. REST API. What if we didn't have to go to Power BI for data, but what if we came directly to the chat in MS Teams? It wouldn't be great to wake up in the morning with the summary answers you need waiting for you in one place. Or what If we would be able to generate invoices, issues, KPIs and more based directly on data from our Power BI models?

How to do it? Come and find out! ExecuteQueries endpoint is waiting just for you!

Bring data in Power BI directly to users in MS Teams

Today we use Power BI daily. We prepare reports, dashboards, consume applications and scorecards.

We can go much further thanks to specific options, such as Power BI. REST API. What if we didn't have to go to Power BI for data, but what if we came directly to the chat in MS Teams? It wouldn't be great to wake up in the morning with the summary answers you need waiting for you in one place.

In the same way, Power BI can serve as a component that collects data, calculates the results of internal competition, and informs all participants about it.

How to do it? Come and find out!

Manipulation with hierarchies in Power BI

Power BI can work with different hierarchies. But what options do we have to deal with them? There are quite a few scenarios. A typical scenario is the Parent-Child hierarchy, which is familiar in almost every organization within a role hierarchy. Sometimes, however, it is not so simple, and M:N hierarchies also need to be addressed. This does not have to exist only within roles and, for example, the substitutability of roles, but also on the business scene. Or you can have a merchant who manages a customer and should be able to see all trades made with the customer and, on the other hand, should be able to see only his sales for all customers. In scenarios like this, things get interesting! So let's not make two datasets unnecessarily, if possible otherwise, and unlock the potential of hierarchies to the maximum. Let's use them within visuals, RLS, calculations, and relationships.

Win the API battle with Power Query

The M language is a competent language. So how do you use it to tame an API and start getting data from it? In this session, we will focus on the constructs necessary for this data mining, best practices that will help you optimize these queries, and how Authentication is handled.

Hack the Matrix (Power BI)

One of the basic visuals in Power BI. Anyone working with Power BI for a while has come into contact with it. But how does it work, and how can we use it to get the most out of it? Both in terms of graphics and content.

As part of this session, of course, we cannot do without DAX studio, which will help us to reveal and hack the matrix down to the last foundation.

Data-driven alerts in Power BI

Do you have data in Power BI that is updated regularly? So why not use this data to make instant decisions or to know what's going on right away? Together, we'll look at how to prepare automated flows that will be able to act on your data!

This session requires knowledge of DAX Queries, REST API, or even Power Automate.

Power BI REST API with Power Query optics

Valuable pieces of information are hidden inside Power BI REST API (not just Admin one), such as when the data set was updated. Who has access to it, or what settings the data set has? But how do we get them to work with them in Power Query? What do we need to set up and create within Azure?

DAX tweaks for graphical diversification of the report

Nobody likes confusing and illegible reports. How can DAX help us make reports more dynamic and graphically eloquent? We will focus on this in this lecture. In addition to the elements found in Power BI, we will also look at the superstructure in the Tabular Editor or the solution using Calculation Groups.

Topics:
- The dynamic ratio of TOPN products sold to all others for individual sellers
- Showing Data Labels by set parameter
- First & Last Values of Line Chart
- Active category label next to the end of a line in Line Chart
- Highest & Lowest value in the Column Chart

Building custom Power Query functions

Power Query has a very great language M, thanks to which the data can be perfectly transformed. But how to proceed when standard functions are not enough for us, and we would need some more complex ones?

Topics:
- Basic concepts in M languages
- Custom Functions constructions
- Metadata Documentation of Functions

Data Saturday Croatia 2023 Upcoming

June 2023 Zagreb, Croatia

Data Saturday Stockholm 2023 Upcoming

May 2023 Stockholm, Sweden

Power BI Next Step 2022

September 2022 Billund, Denmark

SQL Server Bootcamp 2021

No more boring Power BI reports

Nobody likes to read boring reports. So why not make them more exciting and lively? How can DAX help us make reports more dynamic and graphically eloquent? Sometimes it is necessary to look at it from a different perspective and, for example, use the Tabular Editor to push it to places where it will not look in the power you have modified in Power BI itself. The lecture will analyze and demonstrate several examples of how DAX in conjunction with Calculation Groups, but even without them, can cheat classic reports.

November 2021 Prague, Czechia

Power Break

Nobody likes confusing and illegible reports. How can DAX help us make reports more dynamic and graphically eloquent? We will focus on this in this lecture. In addition to the elements found in Power BI, we will also look at the superstructure in the Tabular Editor or the solution using Calculation Groups.

Topics:
– The dynamic ratio of TOPN products sold to all others for individual sellers
– Showing Data Labels by set parameter
– First & Last Values of Line Chart
– Active category label next to the end of a line in Line Chart
– Highest & Lowest value in the Column Chart

July 2021

Power BI Day CZ - DAX for better UX&UI of Reports

Power BI Day 2021 ONLINE is a Czech-Slovak conference where you can look forward to lectures by TOP Czech and Slovak experts on trendy Power BI topics. The conference will be appreciated not only by data analysts or financial managers, but all those who work with data and reports at a more advanced level need to be able to process, decipher and interpret them clearly.

April 2021 Prague, Czechia

Studuj.Digital - Power BI and Open data

February 2021 Prague, Czechia

How 2020 changed Power BI beyond recognition

In the lecture, you will learn about how the year 2020 completely changed Power BI, as we knew it. We will talk about Calculation Groups or DirectQuery for live data sources, we will show you how to use them and what has been added to graphic innovations such as point selection or Azure Map Visual.

February 2021 Prague, Czechia

SQL Server Bootcamp 2020 - Dataflow as a transformation treasure in Power BI Service

Dataflow is a tool that is very often dormant in companies, although it certainly does not have to be asleep and can help a lot with data preparation and report stability. During the lecture, the Dataflow will be rebuilt from the very beginning, including working with it. Since Dataflow works as a tool within the Power BI Service, the data storage will be introduced, where the processed data is stored and how it can be accessed. Dataflow is subject to certain restrictions that are good to consider.

August 2020 Prague, Czechia

SQL Server Bootcamp 2020 - Time Intelligence and its effects on the model in Power BI

Power BI has a two-pronged function called Time Intelligence. On the one hand, it can facilitate date calculations created using the DAX language, but on the other hand, it can cause an unexpected size of the .pbix file, due to spontaneously occurring date dimensions.

August 2020 Prague, Czechia

Czech SQL Pass - Dataflow as an entrance into world of CDM

Štěpán and I will go through Dataflow from the beginning. Including an explanation of where the data is stored and how it can be accessed. Let's talk about when it pays to use dataflow and what are their limitations, especially for PRO licenses. We will explain how Dataflow helps the whole concept of the Microsoft Power Platform and why it is the gateway to enter the world of CDM.

April 2020 Prague, Czechia

Data Festival

May 2019 Prague, Czechia

Štěpán Rešl

Power BI MVP | Managing partner & Lead technical consultant

Prague, Czechia