
Š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).
Area of Expertise
Topics
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
Data Saturday Stockholm 2023 Upcoming
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.
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
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.
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.
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.
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.
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.