Hans Peter Pfister
Senior Consultant Business Intelligence, IT-Logix
Bern, Switzerland
Actions
Hans Peter Pfister is a certified expert for controlling and accounting as well as MCSA BI Reporting with over 25 years of experience in data modeling and data analysis.
More than 20 years ago he developed his first own reporting and analysis application.
Today he runs his own company, Power BI Coach. Prior to that, he worked for over 25 years as CFO and Head of BI & Analytics in various industries.
He is an experienced trainer and consultant for Power BI, SQL, MS Access, Excel, VBA, Power Query and Power Pivot.
Since the introduction of the first components of Power BI, this tool has grabbed him and never let go. Especially the possibilities of Power Query and DAX fascinate him the most.
In addition to his professional activities, he is also a LinkedIn trainer, Power BI speaker and co-leader of the Power BI User Group Switzerland.
He runs the Power BI Blog http://www.powerbi-pro.com.
Links
Area of Expertise
Topics
CALCULATE – the swiss army knife in DAXende
DAX is a very powerful tool in Power BI, Excel and SSAS. In order to be able to use the tool to its full extent, however, an understanding of the context types is important.
In this session you will also learn how you can have more influence on the calculations with Calculate.
After the session you will be able to master most of the challenges in DAX.
Session level: 300
Power Query Deep Dive - Introduction to Mende
The user interface in Power Query allows the user to easily perform many import and transformation steps.
These Power Query functions can be further extended using the underlying "M" language. The session will provide an introduction to "M" and the attendees may use the power of “M” in Power BI Desktop, SSAS and Excel Power as well as in the Power BI Dataflows.
After the session you will be able, to enriche your Power Query solutions with your own “M”-Code.
Session level: 300
How to unify your data with Power BI Dataflowsende
You have created several Power BI Desktop files that use the same data sources?
The solution is to use the queries in the Power BI Dataflows. These serve as data sources for the corresponding reports.
In this session you will learn how to use your Power Query knowledge in Power BI Dataflow and how to use the data in Power BI Reports.
Session Level: 200
Create a Development & Production Environment for Power BIende
Division of labor is becoming increasingly important for the development of Power BI reports. This requires the presence of an appropriate environment. The reuse of datasets can be used to separate the development of data models and reports.
To do this, separate environments must be created in Power BI Service to enable proper Application Lifecycle Management.
This involves separating the development, testing, and production environments.
In this presentation, you will learn how to build different environments and how to develop data models and reports separately.
Build your HR Report with Power BI in 60 minutesende
In this end-to-end session you will learn how to create an HR report in 60 minutes in Power BI.
Get data from multiple sources and transform it using Power Query.
Create relationships between data tables.
All necessary calculations are created with DAX Measures.
Visualize the data in an interactive report.
After this session you will know everything you need to create your own HR report in Power BI.
Power Saturday 2019Sessionize Event
Hans Peter Pfister
Senior Consultant Business Intelligence, IT-Logix
Bern, Switzerland
Links
Actions
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