Speaker

Erik Svensen

Erik Svensen

Power BI MVP

Copenhagen, Denmark

Microsoft Data Platform MVP, ex-Leader of Power BI Usergroup Denmark - Huge Power BI fan and :-)

Area of Expertise

  • Consumer Goods & Services

Topics

  • power bi
  • Powerapps
  • Power Platform
  • Microsoft Power platform
  • Power Apps
  • Power Query

1 slide - 5 Power Queries challenges

This session will be packed with real worlds Power Query challenges I have had to solve during the last few years of wrestling with the M language and strange challenges.

I will take you through 5 different challenges where we will dig into the advanced editor and some of the less used functions in the M language.

We will look at parameters, functions, conditional steps and other tips and tricks that might also help you some day.

My goal will be to inspire you to dare to drill deeper into M/Power Query and know more about M's awesome possibilities

Power BI Paginated Reports - How to and why should I care

Power BI Report Builder is the tool to build paginated reports in Power BI and even though its a Power BI Premium feature - it could be a handy tool in your BI toolset that you should know about.

I will demo how you can build reports based on a Power BI dataset and how to parameterize the report.

I will also show how you can use paginated reports without having a Power BI premium capacity by using Power BI Embedded SKU's to create datadriven subscriptions.

Introduction to Power BI developers to develop Power Apps

As a Power BI Developer you are used to work with Power Query, data modelling, DAX and visuals.

In this session I will guide you into the world of Power Apps, and how you can use the skills of knowing about tables and records translate into building Power Apps.

We will look at the different objects/elements and controls in Power Apps and build an App that can update,add and/or edit data.

The session will give you a kickstart to also be able to master the development of Power Apps.

Power BI and Web API's - not so low code ?

In this session I will demo how you can get data from web api's and how you can ensure that your model can be refreshed in the service.

We will by using real life examples walk through how to connect to different web api's and how different API's have different authentication methods that you will have to understand and master.

We will look at how you can parameterize your queries and only get the data for a specific period or other ways of specifying parameters that the API supports.

In the session you will also learn how to do a POST request to an API.

And YES we will spend a lot of the time in the Power Query Advanced editor.

After the session you should have a good start so that you can connect to the API's that are relevant for you.

Don't trust the Power Query Editor

The Power Query editor is a really great editor when transforming and importing data into your Power BI Model.
But it sometimes doesn't do exactly as we want. If you want to fully control what is happening in Power Query you must be aware of some of these pitfalls and begin to master the M language.
In my session I will illustrate some of these possible problems and how to handle them. This will require knowledge about parameters, the advanced editor and the core elements in the Power Query language - but don't be scared it's actually quite simple and will hopefully improve your queries speed and flexibility in the future.

How can I integrate Open data into my Power BI model

A lot of public data is available for free via Open data portals. In this session I will show how you can access these data directly from Power BI and create a model that combines your sales data with for example the population count in the municipality for the location. We will look at how you create the DAX measures to create this

Tips and tricks for testing/validating/debugging your M & M's

In this session I will give you my tips and tricks to secure an easier way to debug, test and validate your queries in your datamodel. I will show how you can use parameters, lists and more to control how your queries dynamic and bulletproof when murphy's law kicks in.
OBS - The use of the user interface query editor will be limited so we will spend a lot of time in the advanced editor.

Power Query, Don't be afraid of the avanced editor

There is no reason to be afraid of the advanced editor in Power Query - you can do a lot more in here than the user interface exposes. This session will guide you through different examples of hidden functions and variables you can use in your data extraction and transformations using Power Query, and you will learn how to make your queries dynamic and flexible, and even include error handling, if something you didn't expect to happen actually does. You will leave the session with a good understanding of how powerful the language of Power Query actually is and how you can use it in your tool belt. The learnings can be used both in Power BI Desktop and Excel.

Capture Your Store Visit with PowerApps and analyze the effect in powerbi

n this session I will show you how we built a PowerApp where the store reps can document their store visits. In order to reduce the time to capture the information - we used the location awareness to find the store, the camera to capture images and the barcode scanner to identify the products. The data is then saved in Azure Blob Storage and Azure SQL database ready for reporting and analysis in Power BI - and add a reminder to follow up on the visit using a flow.

The session will show you how you can benefit from using PowerApps to optimize the data collection and quality at the same time.

10 things you absolutely need to know about PowerQuery

PowerQuery is a very efficient tool to extract and transform data and is now spreading to other products in the PowerPlatform stack and even Azure Datafactory. It’s very easy to select the transformations via the interface but you can end up with a lot transformation steps that might have a negative effect on the performance and how errorproof your queries are.

In this session I will talk about 10 different things you must know about PowerQuery in order to ensure performance, reliability and ease of maintenance – and this knowledge can be used in all the places you use PowerQuery.

PowerBI and PowerApps - update your budget from PowerBI and see the effect immediately

in the session I will demonstrate how you can use PowerApps within your PowerBI report and update your budget and see the effect instantly in your report. See how you build a datamodel using a combination of imported mode and direct query and use PowerApps within your report to update the budget and and the same time see the updated figures in your report right away.

Data Community Austria Day 2024 Sessionize Event

January 2024 Vienna, Austria

Erik Svensen

Power BI MVP

Copenhagen, Denmark