Tom Martens
Solution Architect @ Munich Re
Hamburg, Germany
Thomas "Tom" Martens has been awarded as an MSFT Data Platform MVP and works as Solution Architect at Munich Re (www.munichre.com). For 20+ years, Tom delivers Business Intelligence, Data Warehousing, and Analytics solutions. His current interest is in data visualization and applying analytical methods to small and large amounts of data, next to providing the Power BI Platform to users for tackling analytical challenges. Tom is a regular speaker at international conferences and user meetings. Tom is the co-author of the book "Pro DAX with Power BI."
Links
Area of Expertise
Topics
Power BI Universe - Mapping the hive ( EN )
In this session, an Azure-based solution will be created that maps your Power BI tenant. This solution, of course, also contains a Power BI report is part of this solution, which allows you to see the data sources that are fueling your datasets, how many workspaces exist, and a lot more.
This solution uses various Azure-based services, the Power BI Rest API, and of course Power BI Desktop for the visualization.
DAX - Musings about foundational concepts
Selected questions from the Power BI community (https://community.powerbi.com) will be discussed. All these questions are touching foundational concepts ranging from table iterator functions like SUMX, the scope of variables and of course the weird filter context. These questions provide some additional and unusual perspectives to some common and not so common problems.
Each question comes with its own slides documenting the underlying concepts and a separate PBIX file using additional explaining measures.
Composite Model - What works and what doesn't
Seit der Einführung von Composite Models im November 2018, war eins der am häufigsten nachgefragten Feature die Möglichkeit auch bestendende Analysis Services Tabular und Power BI Datenmodelle miteinander zu verbinden. Seit Dezember 2021 steht dieses Feature als Preview zur Verfügung und sorgt seit dem für viel Furore.
Diese Session gibt einen Einblick in dieses Feature, erläutert wichtige Begriffe und erklärt was bei der Implementierung berücksichtigt werden muss.
Data culture, data-enabled, data governance, data catalog, Power BI - how does this all relate
The quest for becoming a data-enabled organization that will thrive in a world where a data culture sets new standards and defines the new normal using a data catalog like Azure Pureview will become more important, not just to prevent losing focus.
This session provides meaning to some of the words used in the above sentence. It explains why mapping your data estate becomes vital in the overall theme of data governance and data strategy. A live demo demonstrates how Pureview will be setup to map a Power BI tenant and selected data sources. Next to some technical tips and tricks, some aspects on how to convince data owners to prepare "their" systems for being scanned.
DAX - Fundamental Musings
Musings about foundational concepts
Selected questions from the Power BI community (https://community.powerbi.com) will be discussed. All these questions are touching foundational concepts ranging from table iterator functions like SUMX, but also the scope of variables will be addressed. These questions provide some additional and unusual perspectives to some common and not so common problems.
Each question comes with its own Power BI Report Page(s) documenting the underlying concepts that will be available for download.
DAX - Time Series Analysis, Sequences, and some other fancy stuff
Here Time Series Analysis does not mean calculating the YTD value of a numeric value. This is about discovering the clients who have been buying 10 days in a row and how concepts of time series analysis can be used with DAX. These are the requirements to have fun attending this session: a basic understanding of the Filter Context is required, this article has to be read at least once https://mdxdax.blogspot.com/2011/03/logic-behind-magic-of-dax-cross-table.html, and it's also helpful to have a good understanding of extended tables.
Power BI - The Admin Portal
Very often the settings of the Admin portal are not touched, and left unchanged. But these settings have to be treated carefully and with respect as these settings are important for almost everything Data Governance.
This session explains the most important settings from the Admin portal of the Power BI service and explains why and how some selected settings should be configured to avoid unintentionally data loss or similar dreadful things.
Power BI - The Admin Portal (Deutsch)
Very often the settings of the Admin portal are not touched, and left unchanged. But these settings have to be treated carefully and with respect as these settings are important for almost everything Data Governance.
This session explains the most important settings from the Admin portal of the Power BI service and explains why and how some selected settings should be configured to avoid unintentionally data loss or similar dreadful things.
Use advanced Power BI techniques for text mining
In the age where we are overloaded with information it becomes essential to identify what to read first. For this reason a Power BI app helps to analyze all the emails using methods from text mining and text analysis. Using just the Power BI tool stack this solution makes email analysis versatile and easy to use.
This session provides a short introduction into text mining and text analysis and demonstrates how certain concepts can be utilized using Power BI. Throughout this session some advanced techniques from the whole Power BI stack are applied, ranging from Power Query, to data modeling topics, to advanced DAX usage, even Cognitive Services are incorporated in this analytical pipeline. Technics are used to filter out stop words from the email body and to create a whitelist to easily discover emails that contain content that is of special interest.
DataBlaster Community Conference (#DBCC2021)
Global Azure Lüdinghausen 2021
Tom Martens
Solution Architect @ Munich Re
Hamburg, Germany