Speaker

Ben Watt

Ben Watt

Managing Director of Datalineo

Dublin, Ireland

Ben is Managing Director of Datalineo and is a Microsoft Data Platform MVP, specialising in Power BI.

Awards

  • Most Active Speaker 2022

Area of Expertise

  • Information & Communications Technology

Topics

  • Power BI
  • Power Automate
  • Data Warehousing

Power BI report designs and features that drive positive Customer feedback

This session contains real-world feedback from the field showing what Power BI solution features and report design drive the most positive feedback from Customers.

Beware, you will see a number of features that Business Intelligence professionals regard as hype, non-standard and worse-practice. Through my years of consulting I have come to regard these features as much higher value than we may originally consider.

It's not all controversial stuff, you'll see visual design and navigation techniques that add a user experience boost and directly impact your Users' sentiment.

After this session you should have a new outlook on how to gift wrap your Power BI solution in a way that delivers not only the intended business insights, but a polished user experience and improved user adoption.

Power BI Deployment, Workspaces, Apps - getting it right

In this session we will cover the right way to organise you Power BI objects when you publish to the service and share with your users.

We will cover:
Workspaces - with guidance on where you should organise your reports, datasets, dataflows and more.
Apps - when you publish a Workspace as an App, we'll cover navigation and the new App Audiences.
Deployment Pipelines - where you can have dev/test/prod environments.
Security - we'll cover a rigourous approach leveraging Azure Active Directory

The end result is solid deployment, user experience and security models across your Power BI estate.

Power BI dataflows: building your own refresh orchestration

In this session we look at how to build your own process to orchestrate Power BI dataflow refreshes, allowing for dependencies to be maintained.

Using the built-in scheduler for each individual dataflow you are limited to time-of-day refreshes, meaning downstream refreshes are often left to hope-for-the-best timing conditions. We have solved that and all the necessary code is shared with you.

We leverage the Power BI REST APIs, where the workloads are triggered by Python (or your favourite language) in Azure Functions. Finally our processes are managed via configurable Power Automate flows.

Evolving your Power BI Architecture using Dataflows and Shared Datasets

In this session we will look how the release of dataflows and shared datasets has changed the way we design our Power BI solutions. Starting with a single Power BI file, containing the queries, data model and reports, we will look at the features allowing you to decouple these components to move your solution into a more enterprise architecture.

We will walk through a solution and watch it grow into a mature architecture, and you’ll see demos of dataflows, shared datasets and data visualisations sourced from your datasets in the cloud. We’ll talk through the benefits and some pitfalls, all with the goal of getting you ready to grow your Power BI estate straight away!

Power Automate your way to Cognitive Services and Power BI

This session is suited to those new or getting started with Power Automate. We will walk though a Power Automate driven solution to capture images from an email inbox, apply multiple Cognitive Services algorithms and analyse the output in a Power BI report.

We will walk through a Flow, covering Loops, Conditions, Variables, 3rd Party actions, API calls & more.

With the data captured by the Flow, we'll do some analysis in Power BI

Automate your Power BI data validation

In this session we look at one way to implement automated testing of your Power BI dataset's data quality back to source.

In a meta-data driven solution you'll see how to leverage multiple technologies like Python, Azure Function Apps, SQL Database and of course Power BI to create a test history dashboard.

With this process in place, you will feel much more comfortable that development across your Power BI data model or dataflows don't create unexpected differences, with validation done across all dimensions.

This session is demo heavy, uses the AdventureWorks database and all of the code is shared so you'll be able to pick it up, try it out & adapt to your own solutions.

Ben Watt

Managing Director of Datalineo

Dublin, Ireland

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