Erik Svensen
Former Power BI MVP
Copenhagen, Denmark
Actions
I spend my days convincing data to behave — coaxing semantic models and Direct Lake datasets into doing what they're told, which, as any Power BI person will confirm, is not a given.
Simple is the whole point, for me. My real love is visualization: turning a pile of numbers into something a human can actually look at and understand, without needing a decoder ring. I'm a firm believer that if a DAX measure needs a flowchart to explain itself, something has gone wrong — give me a clean, simple formula and a good chart over a clever one-liner any day. I live somewhere in the Microsoft Fabric ecosystem — OneLake, Azure Databricks, and the Rayfin CLI/SDK are basically my neighbours at this point — and I'm usually the one in the room who can explain why your report is slow and fix it before the coffee gets cold, usually by making it simpler.
I started out as a certified accountant, a career that was going perfectly respectably until I fell in love with Excel a little too hard and followed that passion straight into IT. I've never looked back, and honestly, neither has my old calculator.
When I'm not wrangling semantic models, I'm probably turning someone's spreadsheet into a chart they didn't know they needed — the simpler, the better.
Links
Area of Expertise
Topics
Taking your visual further with Visual Calculations
DAX is simple but not easy - but Visual Calculations is both simple and easy, and can help your visualizations in Power BI if you know about how they work and when you should use them and when not to use them.
In this session I will take you through the basics and then quickly move on to the more advanced functions that will enable you to understand how the functions EXPAND, COLLAPSE, RANK, INDEX and more can be used to make your DAX at the visual level simpler.
The visual calculations can also be used in conditional formatting to make your visuals dynamic and perhaps limit the need for visual specific measures in your datamodel.
We will do this through all lot of demos that should inspire you to use them in your own reports.
Datamodelling made easy (easier) with TMDL
Does your company restrict you from buying or installing Tabular editor 2 or 3 and/or do you wish it was easier to create, copy or multi delete measures, tables and calculation groups ? - then the new Tabular Model Definition Language (TMDL) is definitely something you should get familiarized with as soon as possible. It will for sure make your data modelling faster and easier.
In this session I will give you an introduction to how you get started with TMDL, what is needed and how you can utilize it to make faster data modelling.
It will be done via demos and walkthroughs plus tips and tricks to use TMDL for source control of your datamodels as well.
Make the core visuals look like a custom visual
In this session I will show you via creative use of the core visuals in Power BI can create visuals that makes your reports really stand out.
We will look at trips and tricks to
- highlight periods with shading areas
- creative use of error bars to show variations compared to previous period or year
- custom data labels to highlight specific datapoints
- creative use of dynamic formatting to control visibility or emphasize datapoints
After the session you should have learned some tips that will make your reports really stand out.
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.
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.
Data Community Austria Day 2024 Sessionize Event
Erik Svensen
Former Power BI MVP
Copenhagen, Denmark
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