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, Fabric 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

Workspace management in Fabric

Fabric is a fully fleshed analytical solution, that can quickly become swamped if you don't setup some guidelines around how you create and use workspaces.

With all the new types of ressources you can create in Fabric it's increasingly important to organize the content in the best possible way. Not only for overview, but also to handle the permissions.

This session will cover the best practices to better govern the workspaces in your tenant. Both targeting enterprise and self-service use.

You will get a practical check list for different use cases, so you can get started right or get some help cleaning up.

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 😁

dataMinds Connect 2023 Upcoming

October 2023 Mechelen, Belgium

Data Saturday Denmark - 2023

March 2023 Kongens Lyngby, Denmark

Just Blindbæk

Microsoft BI consultant, trainer, speaker and MVP

Århus, Denmark

Just Blindbæk

Links

Awards

Area of Expertise

Topics

dataMinds Connect 2023 Upcoming

Data Saturday Denmark - 2023

Just Blindbæk

Links