Most Active Speaker

Just Blindbæk

Just Blindbæk

Microsoft BI consultant, trainer, speaker and MVP

Århus, Denmark

Independent BI consultant with extensive experience in all phases of BI development on Microsoft SQL Server, Azure and Power BI. Founder and coordinator of Microsoft Business Intelligence Professionals Denmark (MsBIP.dk) and Power BI UG Denmark (PowerBI.dk). Is a Microsoft Certified Trainer at Orange Man.

Awards

Area of Expertise

  • Information & Communications Technology

Topics

  • Business Intelligence
  • Power BI
  • Microsoft Data Platform
  • Microsoft Azure
  • data engineering
  • analytics engineering

KPI management reporting across multiple datasets in Power BI

You have probably been in the situation, where you have different data topics split out on multiple datasets? One for Sales, one for Finance etc. And now you need to create reporting across? But how?

There are a few ways that you can accomplish this. One is to use Power BI dashboards, which have some limitations. Another is to explore the new scorecard functionality with Power BI metrics. Or you can create a new dataset on top of the others - either using composite models or import mode.

Let's take a tour of all the different solutions and see what they have to offer. You will learn a lot, and be able to choose the best one for your needs.

Next Step Power BI Tabular model development

Today most people use Power BI Desktop to develop datasets. While Power BI Desktop is a great tool for the citizen developer it also has limitations. If you want to take your development skills to the next level, you should consider using Tabular Editor (free or paid version) to develop your data models.

Tabular Editor is a tool for developing tabular data models (Power BI or Analysis Services). It allows the developer to be more productive by separating the model metadata and the actual data. This allows for scripting, multiselect editing and best practice analyzing. Since you are only working with metadata it allows for easier integration with source control and DevOps.

This training day will help you transition from Power BI Desktop to Tabular Editor. You will be much more productive and will (optionally) be able to integrate data model development into DevOps processes. We will start by developing a simple data model and gradually introduce advanced data modelling techniques in Tabular Editor.

In this training the following topics will be covered:
• Benefits of Tabular Editor
• Role playing dimensions
• Multiple fact tables at different granularity
• Many-to-many relationships
• Perspectives and partitions
• Best practice analyzer
• Advanced scripting
• VertiPaq storage engine
• Deployment and DevOps
• Object level security
• Calculation Groups

At the end of this training day the attendee will come away with the following knowledge:
• Why use Tabular Editor
• How to use Tabular Editor to develop tabular models
• How to further the quality of tabular models

Architectural blueprints for the Modern Data Warehouse

This session will walk you through five different ways to set up an affordable Azure based Data Warehouse solution. Covering pros and cons with each of the architectures.

Classic solutions with source system in the one end and the reporting in the other end. But what do we put in the middle? What are the available services to extract, transform and load our data? And how about orchestration and monitoring?

Does it matter if we choose schema on read or schema on write? What are the drawbacks and benefits?

Special focus on reusing the competencies we have already acquired from making the same solutions on SQL Server.

Reporting on the Reporting Services Database

Complete the loop and create reports on top of the Reporting Services database so you can answer questions like: Who is using the reports and who is not? Any reports not being used? What are the top 20 list of slowest reports? Who received the Data-Driven Subscription? What are the dependencies between data sources, data sets and reports? What is the specific query in a dataset or report? When was the report deployed and by who? Who has access to the reports and by which permissions?

The session will walk-through the creation and all the attendees will get all the reports from the demonstrations.

Paginated Reports in Power BI

Paginated Reports have moved in with Power BI in the cloud - get ready to the big wedding! Analytical interactive reports are now side-by-side with the good old pixel perfect print friendly paginated reports.

Join this introduction session and learn all about the strengths and weaknesses of Paginated Reports and why you should pay attention and learn about this “new” type of report in the Power BI Service.

We will walk through the concepts behind and create a report from scratch all the way to publish. Also covering how you can test and use the feature - even without Premium. Finally you will get a glimpse into the future on what additional features we can expect to come - both in the near future and on the longer run.

The Hitchhiker's Guide to navigating Power BI

Are you also sometimes lost in space? What is up and what is down, when it comes to navigation in Power BI. How much is controlled and what can you adjust yourself?

This session will cover all the options we have to change and setup navigation on three different levels. (1) Inside Reports, (2) between Reports in an App and finally (3) the Power BI Web Portal to help users finding the Apps and Reports. You will be amazed how much actually can be done, to give your users a better experience.

We will cover topics like, Power BI Service navigation, Linking from an Intranet, Setting up Dashboards, The new App navigation, Drillthrough, Buttons, Bookmarks and much more.

XMLA endpoints, Power BI open-platform connectivity

Did you hear it? Power BI is merging with Azure Analysis Services! Microsoft is now opening up and giving us full access to the powerful Analysis Services engine in the Power BI service. This gives us semantic models that serve as the single source of truth for the whole enterprise. Manage the models (datasets) with the tools you know and love and give read access to a variety of Microsoft and third-party client tools.

This session will give you the complete overview, show you how to get started, great demoes of currently working client tools and introduction to what is coming next.

The traditional modern Data Warehouse

Big data, Databricks and now also Synapse Analytics. Microsoft really focuses on how to put together BI and DWH solutions that can handle huge volumes of data. But what about the "ordinary" solutions in the SME market? How do we put together a sensible and affordable Azure solution for them? Where we can reuse the competencies we have already built from making the same solutions on SQL Server.

This session will go through and show you how to setup a very simple ETL framework based on Data Factory, Data Lake, SQL DB and Power BI. All code will be made available for you to download and use!

Power BI: From Self-Service to Enterprise

Power BI started out as a set of Self-Service BI tools in Excel before the merging into Power BI Desktop a couple of years ago. At the same time Power BI has evolved into a grownup scalable Enterprise BI platform. But how do you master to grow a solution from self-service to something that is scalable, managed and governed? A solution that can be trusted and used in the whole enterprise! Basically promoting a quickly made proof-of-concept project - but without redoing the whole thing.

In this demo heavy session we will take a look at the different steps you have to master, so you can make a successful ownership transfer of the different component in your Power BI solution. It be the data mashup, data modelling, report creation and report distribution. We will start with one Power BI Desktop file containing it all and end with a solution that is split up in Dataflows, Tabular model, Reports and Apps. Using the fact that Power BI eventually came out of a set of different tools and technologies. We will end up looking at different ways to certify and brand the datasets, reports and apps. So your users can distingues what is still self-service and what is enterprise.

Power BI Quiz

The Power BI Quiz show is your chance to prove and test your knowledge on Power BI and maybe win the grand prize! Or be the lucky winner of the raffle prize(s).

It’s fun and you may actually get some learning out of it 😁

SQLBits 2023 - Full day training sessions Upcoming

March 2023 Newport, United Kingdom

PASS Data Community Summit

Power BI: From Self-Service to Enterprise

November 2022 Seattle, Washington, United States

dataMinds Connect 2022

October 2022 Mechelen, Belgium

DataSaturday Croatia 2022

June 2022 Zagreb, Croatia

SQLDay 2022

May 2022 Wrocław, Poland

Power BI Gebruikersdag 2022

March 2022 Utrecht, Netherlands

SQLBits 2022

March 2022 London, United Kingdom

Power BI Fest

November 2021

dataMinds Connect 2021

October 2021 Mechelen, Belgium

Power BI Summit

April 2021

#DataWeekender #TheSQL

October 2020

SQLBits

Power BI: From Self-Service to Enterprise

September 2020

Sydney Power BI User Group

The Hitchhiker's Guide to navigating Power BI

September 2020

Power BI Gebruikersdag

The Hitchhiker’s Guide to navigating Power BI

September 2020

SQLSaturday 917

Enterprise and Self-service in Power BI - better together

January 2020 Vienna, Austria

SQLSaturday 910

Customer story: End-to-end Microsoft BI solution in Azure

December 2019 Ljubljana, Slovenia

Power Platform World Tour Brussels

Paginated Reports in Power BI

December 2019 Brussels, Belgium

dataMinds Connect 2019

October 2019 Mechelen, Belgium

Data Saturday Holland

October 2019 Utrecht, Netherlands

Power Platform World Tour Copenhagen

Paginated Reports in Power BI

September 2019 Copenhagen, Denmark

Power BI Balooza

Enterprise and Self-service in Power BI - better together

June 2019 Atlanta, Georgia, United States

Data in Devon 2019

April 2019 Exeter, United Kingdom

Power Platform Summit Europe

Enterprise and Self-service in Power BI - Better Together

March 2019 Amsterdam, Netherlands

SQLSaturday #816 Iceland

Deploying Power BI in the Enterprise

March 2019 Reykjavík, Iceland

SQLSaturday #765 Denmark

End-to-end Business Intelligence solution in Azure

October 2018 Copenhagen, Denmark

Power BI World Tour Copenhagen

Power BI Embedded

September 2018 Copenhagen, Denmark

Intelligent Cloud Conference 2018

May 2018 Copenhagen, Denmark

Just Blindbæk

Microsoft BI consultant, trainer, speaker and MVP

Århus, Denmark