Štěpán Rešl
Data Platform MVP | Managing partner & Lead technical consultant at DataBrothers
Prague, Czechia
Actions
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).
Badges
Area of Expertise
Topics
Orchestration best practices in Microsoft Fabric
Join me for a session on mastering orchestration within Microsoft Fabric. Discover best practices for scheduling and managing your data workflows. We will be talking about native schedulers for items like semantic models, dataflows, notebooks, etc, and why using only these can bring you into specific issues that can be handled more elegantly and efficiently. Explore how to effectively schedule components with multiple dependencies like pipelines and notebooks while addressing common challenges such as dependency control and parametrization. Learn why pipelines are great for managing complex workflows, offering superior control over dependencies and execution. Finally, dive into the power of Directed Acyclic Graphs (DAGs) in tools like Apache Airflow and see how they excel at orchestrating notebooks and why this is a crucial part of orchestration in the Microsoft Fabric ecosystem. Whether you’re building pipelines and notebooks or preparing complex reporting solutions with dependencies between semantic models or between Fabric items, this session will equip you with actionable strategies to achieve efficient and scalable orchestration in Microsoft Fabric.
Fabric vs. Sharepoint - Extract your data as they should be
Although Sharepoint is not a database, many companies use it that way. It doesn't matter if we are talking about "files" or "lists." It is still a carrier of data we may need for further insight.
Today, we have three main ways to get this data into the Fabric environment. But which of them is optimal? Can I do the same in all three? Will we get all the data in the proper form? These and other questions are precisely the ones we will be interested in during this session.
So, what options do we have? Pipelines, Dataflows, and Notebooks. The last-mentioned variant can be exciting because, at that moment, you are not limited and can do anything with the obtained data.
Ready? Here we go!
Dataverse in connection with Power BI and Microsoft Fabric
Unlock the full potential of your data with this deep dive into the integration of Dataverse, Power BI, and Microsoft Fabric. This session will introduce OneLake for Power Platform developers and demonstrate how Power BI leverages its capabilities for enhanced analytics. Learn how to seamlessly link Dataverse data to Microsoft Fabric, enrich it for greater insights, and integrate Fabric data back into Dataverse as Virtual Tables for your next Power App or Power Automate. We’ll also explore advanced techniques for writing data from Power BI semantic models to Dataverse using SemPy and REST API by executing DAX queries and pushing. Whether you’re a developer or data professional, this session will equip you with practical strategies to create connected, optimized, and actionable data workflows that can help you reuse data you already have.
Bring your data to the age of better visualization! Its age of SVG in Power BI
Although Power BI offers several native visuals, their capabilities are usually very limited. For this reason, many users are running away from native visuals to custom visuals. On the other hand, these may be prohibited entirely in many companies or limited to only certified ones.
Let's take advantage of it together to make your own SVG charts and bring them to life using native visuals. A life that will show your data in precisely the form you see fit! The form will convey what is needed. The way you have everything under your control!
As part of this training, we will produce different types of SVG together and then dynamically generate them using the DAX language so that we can use the data from the datasets to the fullest. In addition to classic sparklines, we will also focus on creating full-fledged KPI cards and entire visuals.
Personal Workspaces in times of Fabric
Personal workspaces are spaces for content that every user has, but many companies don't like them because they are afraid. After all, they seem to be a black box for data. Let me help you not to be afraid of them anymore because they are no black box. They can be audited, controlled, encrypted, and much more. You need to know how and what you need to be able to do it.
Lessons learnt from PySpark Notebooks and extracting APIs
Notebooks inside Fabric are a high-speed solution for data transformation, and APIs are a great data source and are provided by many systems. So, it is great to have the ability to download and shape their data by PySpark for other Fabric purposes.
In this session, I will show my lessons learnt from Notebooks and API extractions. A session is aimed even for beginners who have never worked with APIs or Notebooks. I will show what libraries are required and how to create a User Define Function that can be very handy for more complex transformations.
Level-Up your Power Query game with Custom Functions
Functions are one of the fundamental building blocks of Power Query. In addition to the native ones, we can create our own so that we don't have to write everything repeatedly. Custom functions can be one of your best friends for making your work easier in Power Query. But you need to be able to create them and set the input parameters, including whether they are mandatory or optional.
But once we create the function, it doesn't end there! To pass the function to someone or not forget what it does, it is good to know how to add documentation metadata that will be displayed in the preview of the function and used for quick understanding.
Start building custom functions and advance your Power Query capabilities.
Data-driven alerts in Power BI
Data inside datasets are great for populating the content of Power BI Reports. But how to bring this content closer to the users in the environment where they work every day? This is already an exciting task where the Power BI REST API can significantly help us. Of course, before talking about it, we must know all the options by which Power BI communicates with us, so we know which one we can reach for when. When none of them are enough, the aforementioned API comes into play.
Using Power Automate or Logic Apps, PowerShell, or any other means, we can query our data and work with it further. At that point, DAX becomes our primary language that looks for answers. But together, we will show how to get these answers to people right up to their chat in MS Teams using Power Automate.
SQLBits 2025 - General Sessions Sessionize Event Upcoming
Power BI & Fabric Summit 2025 Sessionize Event
dataMinds Connect 2024 Sessionize Event
Data Platform Next Step 2024 Sessionize Event
Data Saturday Croatia 2024 Sessionize Event
SQLDay 2024 Sessionize Event
Viz.fo 2024-05-03 Sessionize Event
Macaw Learning Days
Power BI & Fabric Summit 2024 Sessionize Event
Fabric February 2024 Sessionize Event
DATA BASH '23 Sessionize Event
Data Moshpit 2023 Sessionize Event
Power BI User Group Denmark #2023 User group Sessionize Event
CZ/SK Power Platform User Group Meetup User group Sessionize Event
Data Saturday Croatia 2023 Sessionize Event
Data Saturday Stockholm 2023 Sessionize Event
Power BI Summit 2023 Sessionize Event
Power BI Next Step 2022 Sessionize Event
#DataWeekender CU5 Sessionize Event
Power BI Summit 2022 Sessionize Event
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.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top