Wolfgang Strasser

Information & Communications Technology

Power BI SQL Server SSIS SSAS SSRS Azure Data Platform Data Integration Azure Synapse Azure SQL Synapse Azure Synapse Analytics Power Platform Power Automate Microsoft Power BI

Hartkirchen, Upper Austria, Austria

Wolfgang Strasser

data juggler

Wolfgang Strasser creates solutions based on the Microsoft Data Platform tools in his day-to-day job as Business Intelligence consultant. Either using SQL Server Database Engine, SSIS, reporting with SSAS and SSRS, implementing Power BI solutions or cloud tools for data analysis - the data-tools-landscape is broadening every day! Based on his professional careers as a software developer he likes to work on structured development processes.
Wolfgang shares his knowledge with the community at many national and international events. For his community work, Wolfgang has been awarded with the Microsoft MVP Award for Data Platform in October 2015.

Wolfgang Strasser

data juggler

Wolfgang Strasser creates solutions based on the Microsoft Data Platform tools in his day-to-day job as Business Intelligence consultant. Either using SQL Server Database Engine, SSIS, reporting with SSAS and SSRS, implementing Power BI solutions or cloud tools for data analysis - the data-tools-landscape is broadening every day! Based on his professional careers as a software developer he likes to work on structured development processes.
Wolfgang shares his knowledge with the community at many national and international events. For his community work, Wolfgang has been awarded with the Microsoft MVP Award for Data Platform in October 2015.

Current sessions

My favorite 10 Azure Synapse Analytics features EN

Azure Synapse allows you to analyze data of different formats, volumes and sources under one umbrella - the Synapse workspace. You can decide if you want to use SQL, spark or Data Explorer analytic runtimes.
After a few years of customer projects using Synapse Analytics, I want to share my Top 10 features with you. See and feel Synapse in action and demos!
Btw: What is your favorite Synapse Analytics feature?


Connect your data artifacts with Azure Synapse Analytics EN

Everyone talks about distributed data and data islands. And yes, that's true - data is stored and produced almost everywhere - in the cloud on premises and even machines produces data in milliseconds speed. It is getting more and more harder to build an integrated, single system for your single point of truth.
In the past years, Microsoft positioned Azure Synapse Analytics as an ideal platform for the Modern Datawarehouse serving diverse needs.
In this day long workshop I would like to present you the Azure Synapse Analytics platform ranging from data ingestion with Azure Synapse Pipelines, Data Exploration using SQL Serverless Pools, Data Wrangling using integrated Spark Pools and Data Warehousing using Dedicated SQL Pools.
Without a deep integration to external, linked services, Azure Synapse would not be that successful. Therefore, the concept of Synapse Link (for Cosmos DB and Dataverse) will be presented.
Analytics without visualization is missing an important step - in the last part of the day, the integration of Power BI and Synapse will be presented.


Best friends? Let's talk about the Relationship of Power BI and Azure Synapse Analytics EN

Azure Synapse Analytics is the new star in the cloud data analytics field.
With the goal of combining enterprise data warehousing and Big Data analytics, this service provides an end-to-end solution for data analytics in the cloud.
In the past years, Power BI development was the rising star in the business intelligence field, and with Synapse Analytics a new chapter was added to the data story.
In this session, I would like to provide an overview of the Synapse architecture, the technologies that are similar to Power BI concepts, and how you - as a Power BI developer - can leverage Azure Synapse Analytics to bring your Power BI environment to a next level.


Ach, wo hab' ich nur meine Kundendaten wieder abgelegt...? EN DE

Daten, Daten, Daten... überall nur Daten..
Wo aber sind unsere Kundendaten abgespeichert?
Es sind oft die Kleinigkeiten welche uns das Datenleben erschweren - mit einem geeigneten Werkzeug - vielleicht einem Data Catalog !? - könnten wir uns hier das Leben erleichtern.
Mit Azure Purview schickt Microsoft ein Data Governance Werkzeug ins Rennen, welches wir in dieser Session beleuchten werden. Was kann es bereits? Was fehlt noch?
Und - ist es mir das überhaupt wert?


What's in the Azure Synapse cake for you as Power BI developer? EN

You are a Power BI developer and you feel familiar with most of the features in the Power BI universe? And now you think you are ready for the next step?
You heard about THE (new) analytics platform in the Azure cloud? Azure Synapse Analytics they call it.
Join this session if you want to know what is in the cake for you as Power BI developer and how the Azure Synapse platform can boost your data processing journey.


Data what? Why you should govern you data! EN

Collecting data is one part of the story. Know you data estate is another part. Let's see how Azure Purview can help you to manage and govern your data estate and bring it to another level.
No matter if the data resides in a database, SAP, Power BI or a datalake - Azure Purview can scan and help you classify your data estate.


Azure Synapse Analytics: (Not only) for the Power BI Developer EN

Azure Synapse Analytics is the new star in the cloud data analytics field.
With the goal of combining enterprise data warehousing and Big Data analytics, this service provides an end-to-end solution for data analytics in the cloud.
In the past years, Power BI development was the rising star in the business intelligence field, and with Synapse Analytics a new chapter was added to the data story.
In this session, I would like to provide an overview of the Synapse architecture, the technologies that are similar to Power BI concepts, and how you - as a Power BI developer - can leverage Azure Synapse Analytics to bring your Power BI environment to a next level.


Connect your data artifacts with Azure Synapse Analytics EN

In human brains, synapses are responsible to connect information pieces together. Over time, our knowledge increases when more and more synapses are connected together. Following that analogy, Azure Synapse Analytics wants to connect (all) information silos together and provide a single point of analytics.
Join this session, if you want to hear about the building blocks of Azure Synapse Analytics, how Data Engineers and Data Scientists and even BI developer can work together in a single service and see how easy it is to start with Synapse Analytics!


How to start with Azure Synapse Analytics - Power BI Developer Edition EN

In many cases, Power BI developers are often focused on the possibilities available in the Power BI universe. With Azure Synapse, a broader field for data transformation and integration is opened. What are new parts of the workspace that could be of interest and what are pieces you - as a Power BI developer - are already familiar with?
Join this session to get an introduction to Azure Synapse Analytics for the Power BI Developer!


Continuous Integration for the BI Developer EN

In many cases and BI projects, the manual process of development and especially deployment of artefacts led to sleepless nights, emergency hotfixes, grey hair and many hours of stress.
Especially in BI development, the usage of database projects, unit testing, version control, continuous integration and deployment is an underrepresented area.
Join me in this demo-heavy session where I will guide you through the not-so-frightful jungle of continuous integration using SQL Server database projects, SSIS, T-SQLt and Azure DevOps etc.
After this 60 minutes you'll have the guidelines and some ideas how easy it is to change your manual BI development and deployment into a powerful and automated no-brainer that - just works!


PowerPlatform Dataflows –PowerQuery (and more) in the Cloud EN DE

With PowerPlatform dataflows, users can bring PowerQuery functionality to a cloud-only life. Created in the cloud, processed in the cloud and storing results in the cloud, dataflows can be seen as cloud native part of the ETL within the PowerPlatform.
After their initial start in the Power BI universe, they now reached out into other parts of the PowerPlatform and be one of the future options of ETL pipelines to transfer data into data lakes.
In addition to data transformation, dataflows can be enriched with AI functionality to bring more ML power into your ETL processes.
Join this session if you want to learn more about the current feature set available and see what is new and possible with data preparation in the cloud with PowerPlatform dataflows.


Power Platform Dataflows - PowerQuery (und mehr) in der Cloud EN DE

Mit den PowerPlatform Dataflows können Benutzer PowerQuery Prozesse in eine cloud-only Architektur überführen. Mit der Erstellung, der Verarbeitung und auch der Speicherung der Ergebnisse in der Cloud können die Dataflows als der cloudbasierte ETL Teil der Power Platform gesehen werden.
Nach dem Start im Power BI Universum, finden sich nun Dataflows auch in anderen Bereichen der PowerPlatform. Ein wichtiger Schritt in Richtung ETL pipelines ist gemacht, aber wo stehen wir heute und vor allem: wo wird die Reise mit den Dataflows hin gehen?

Einige dieser Fragen werde ich in meiner Session behandeln und mich dem Thema Datenaufbereitung in der Cloud mit den Powerplatform Dataflows im Detail beschöftigen.


Let Me Automate You - Take Power BI To The Next Level EN

In the early days, Power BI was placed as a self-service BI tool but as the userbase and deployment sizes within organizations grew, the need for Power BI automation got more important.
Join this session to learn how common Power BI administration tasks can be automated using the CLI, PowerShell and C#, how Azure DevOps can work together with Power BI for continuous integration and in addition, learn how create Power BI artefacts in an automated way.

In the early days, Power BI was placed as a self-service BI tool but as the userbase and deployment sizes within organizations grew, the need for Power BI automation got more important.


The Microsoft Power Platform - What is it? EN DE

The term "Power Platform" was introduced by Satya Nadella and James Philips as the serving foundation for building powerful (cloud-baked) applications with PowerApps, Power BI and Microsoft Flow. Join me in this session to learn more about the super-powers of the Power Platform.


Let your data flow - Introducing Power BI dataflows EN DE

Power BI serves as a self-service BI platform with a strong focus on data preparation and interactive analysis. With the introduction of Power BI dataflows, self-service data preparation is brought to a new level using well-known and established technologies.


Hybrid Power BI - What is possible? What do you need? EN

Power BI as a cloud-based SaaS solution is not limited to cloud data sources. In many projects, hybrid architectures are the key to successful projects using already existing infrastructure.
Besides the on-premises data gateway, there are additional options how a hybrid approach can bring benefits and lead to better solutions.


A Year in the World of Power BI EN DE

A year does not seem long in the world of software products. But – Power BI is different!
In this session I would like to go on a journey through the last year of Power BI. What were the “main” features added to the Power BI universe!? What changed since last year?


The Current State of Microsoft Reporting EN

With the announcement of the Reporting Roadmap in 2015, Microsoft defined the fundamental concepts of their reporting future. The basic principles in this "reporting manifesto" are: harmonized report types (paginated, mobile, interactive and Excel reports); cloud and on-premises feature parity; SQL Server Reporting Services (SSRS) are the on-premises report distribution platform; and unified mobile experience. SQL Server/SSRS 2016 was the first step into the reporting future; the story continued with SSRS 2017 and with Power BI ReportServer (PBIRS). This session will look at the current state of implementation. What was planned, what is already available today, and what are the missing points so far?


Die Microsoft Power Plattform - Was ist das? EN DE

Die eigenständigen Technologien PowerApps, Power BI und Microsoft Flow sind erwachsen geworden und arbeiten als Power Plattform stärker denn je zusammen!
In dieser Session werden die einzelnen Teile der Plattform aber vor allem das Zusammenspiel in zahlreichen Demos vorgestellt.


Ein Jahr im Power BI Universum.. was hat sich getan, wohin geht die Reise? EN DE

Ein Jahr ist auf den ersten Blick nicht viel in der Welt der Software Produkte. Bei Power BI jedoch ist ein Jahr schon fast eine Ewigkeit. Mit permanenten Veröffentlichungen, fast wöchentlich neuen Features hat sich vieles getan in den letzten 52 Wochen.
Was waren die Highlights? Wohin geht die Reise mit Power BI in den nächsten Monaten ? ...All das sollte nach dieser Session klarer sein!


Die Power BI Dataflows - Datentransformation in der Cloud und im Data Lake EN DE

Power BI ist die Self-Service BI Plattform von Microsoft mit einem starken Fokus auf die Datenaufbereitung, -transformation und interaktive Datenanalyse. Mit den Power BI Dataflows wird die Self-Service Datenaufbereitung in die Cloud gehoben, die Wiederverwendung gestärkt und der persönliche Power BI Data Lake befüllt.
In dieser Session wird das Konzept der Power BI Dataflows vorgestellt, die Unterschiede zu Power Query in Power BI datasets herausgearbeitet und die Möglichkeiten und Konzepte vorgestellt.


Na, wie fühlen wir uns heute? Sessionbewertung automatisiert in 60 Minuten! DE

Gefällt es den Teilnehmern eigentlich auf der Konferenz? Schwankt die Stimmung vielleicht im Laufe des Tages? Das wollen wir herausfinden! Leider sind wir schlecht vorbereitet… Daher müssen wir uns eine Sentiment Analyse komplett von null aufbauen… Aber wir haben ja eine gute Stunde Zeit und der Microsoft Stack bietet uns mit den Cognitive Services, Azure SQL Database, Power Apps, Flow und Power BI ein paar Hilfsmittel.


Data Governance? Was ist das denn? Und brauch ich das? EN DE

Daten sammeln kann jeder. Aber einen Überblick über die eigene Datenlandschaft zu bekommen und zu erhalten ist eine spannende Aufgabe.
Betrachten wir gemeinsam Azure Purview und sehen uns die Möglichkeiten an, um unsere Daten zu verwalten, zu katalogisieren und besser kennenzulernen. Und es kommt nicht darauf an, wo und mit welchem System die Daten gespeichert und verarbeitet werden – Azure Purview hilft uns dabei Daten zu finden, zu katalogisieren und zu klassifizieren.


Past and future events

Power BI Next Step 2021

16 Sep 2021
Copenhagen, Capital Region, Denmark

Azure Summit

13 Sep - 23 Sep 2021

Data ANZ

25 Jun - 26 Jun 2021

DataMinutes #1

11 Jun 2021

A Taste of M365 Chicago!

4 Jun 2021

DataBlaster Community Conference (#DBCC2021)

19 May 2021

Virtual Symposium - SQL Server & Azure SQL

4 May - 6 May 2021

Power BI Summit

18 Apr - 23 Apr 2021

Global Azure Austria 2021

15 Apr 2021

Global Azure Lüdinghausen 2021

15 Apr 2021

Power Platform Virtual Conference

11 Mar - 12 Mar 2021

Virtual Scottish Summit 2021

22 Feb - 27 Feb 2021

Experts Live Austria 2021

7 Jan 2021
Linz, Upper Austria, Austria

CDS Saturday

23 Oct 2020

dataMinds Connect 2020 (Virtual Edition)

12 Oct 2020
Mechelen, Flanders, Belgium

Power Platform 24

1 Oct - 2 Oct 2020

Data Community Weekender Europe

1 May 2020

Global Azure Bootcamp Austria 2020

23 Apr 2020
Pasching, Upper Austria, Austria

DataGrillen 2019

19 Jun - 20 Jun 2019
Lingen, Lower Saxony, Germany

Global Azure Bootcamp Austria 2019

26 Apr 2019
Linz, Upper Austria, Austria

Intelligent Cloud Conference 2019

7 Apr - 9 Apr 2019
Copenhagen, Capital Region, Denmark

Power BI Days 2019-01

25 Jan - 26 Jan 2019
Mechelen, Flanders, Belgium