Our Power BI Summer School 2019 program
Dynamic platforms with Collective analytics by Michiel Rozema & Henk Vlootman
Traditional, IT-driven BI projects struggle with business engagement and low adoption rates. Power BI promises to enable the business user to create her own reports and analyse data. But how to do this is a manageable way? How to ensure that results of end-user reports can be trusted?
The answer lies in a collective approach to analytics, in which not only business analysts are supported by data services from IT, but also the specific strengths of Power BI are leveraged to drive success of BI projects with deep involvement of business users. In this session you will learn specific methods to implement collective analytics.
DAX, Context, and Variables by Michiel Rozema
At the heart of any Power BI solution is the Power BI Data Model, enhanced with powerful calculations. DAX is the function language to define these calculations. It is amazing what can be done with DAX, but many get stuck as it’s easy to get lost in complexity.
In this session, I’ll introduce you to the single most fundamental and important concept for working with DAX: Context. Knowing how to deal with context and how to bend it to your will, enables you to create virtually any calculation you need. In the second part of the session, we’ll look at DAX table functions and their behavior, context-wise; and we’ll cover DAX Variables as a means to make complex DAX calculations easier to build and read.
Power BI LIVE by Gašper Kamenšek
This session is all about Live Data Streaming in Power BI. Streaming datasets as they are called are how the IoT world can communicate with Power BI in real time. We will go from the basics of creating the Streaming Dataset through testing different methods of streaming data and all the way to using a Server Room simulation to create a LIVE Power BI Dashboard.
– Creating a Streaming Dataset
– Using PowerShell to send data
– Using Excel to send data
– Using a WebService to stream data
– Creating a Power BI Dashboard based on Streaming Data
PowerApps and Flow by Prathy Kamasani
PowerApps: How to build Data-Driven Apps easily and quickly using familiar datasets like Excel and Sharepoint Lists how to build intelligence into your Apps.
• What is PowerApps?
• How to design and build an App: Using existing Templates, Using Blank Templates
• How to use controls and customising controls
• How to use functions to configure the App functionality
• How to share and manage Apps
Microsoft Flow: With no code approach, how to include automation directly into your Apps and Reports.
• What is Mircosoft Flow?
• How to create Flow from a template
• How to create a flow from scratch
• How to use expressions
• How to Manage Flows and Flow runs
Enriche your Power BI model with Artificial Intelligence by Markus Ehrenmueller
AI is everywhere – and now even included in Power BI. Sometimes AI might be very apparent when you enrich your data with predictions by explicitly calling an Azure Machine Learning web service in Power Query. Sometimes it might by hidden in a nice little context menu when Power BI is automagically explaining the reason of a difference or a change over time in your data to you.
No matter if you are a business user, analyst or data scientist – Power BI has AI capabilities tailored to you. In this session we will cover how you can integrate and leverage the use of language R, how to integrate an Azure Machine Learning Service when loading data, what kind of insights Power BI is capable of delivering automatically, how you can create a complex new column without typing a single formula/function, how you can explore your data by asking questions in plain English, … and more!
Sounds like a lot of content? I omitted most of the slides in favor to spend the time in live demos instead. Learn how you can enrich your very own Business Intelligence with Artificial Intelligence and make the step up from Power BI to Power Artificial Intelligence.
Using Power Query in Power BI & Dataflows by Henk Vlootman
The ETL tool in power BI is Power Query. Easy to use, but vulnerable for creating inefficient listings. We aim at getting the most out of Power Query.
Power Query uses the M-language. You could think M stands for Messy. Since Power Query is so easy to use, staying in control is difficult. In this session we dive deep in Power Query. We show the use of variables, how to write proper code and how your code can be “small and beautiful”. We also take a look at Dataflows, the corporate way of using Power Query.
Data never speaks for itself by Arend Oosterhoorn
Data never speaks for itself, it is always up to us to interpret the information in the data and tell that to our listeners. Data story telling is actually about three things. About data, which we can now display in the most beautiful and appealing way. And about the story with which we convey the eloquence of the data. A story is more than just a beautiful series of sheets in a PowerPoint presentation, a story has a structure. And then, of course, there is the narrator, the person who has to express all this and, through his presence, convey the message hidden in the data.
In this lecture I would like to share my insights about
– the data, the story in the data and the message that the data contains
– the story, the structure and the storylines
– what do stories with people
– the narrator, how can you develop as much presentation power as possible with your voice, your body and your movements?
Visualisations by Ida Bergum
Ida will give you some insights on how you can use design thinking methods for your Power BI initiatives or solutions. I will also go trough one of the templates I have built for innovation accounting used for multiple incubator teams at a global organization.