Speaker

Robert Hawker

Robert Hawker

Owner - Meloro Limited

Reading, United Kingdom

Actions

Robert Hawker has worked in Data and Analytics within household name end user organisations since 2007. Rob has worked in a range of industries in both hands on and leadership roles, covering areas such as master data management, data quality, metadata management and more recently data visualisation.

After learning Power BI in 2019, Rob changed his focus from data leadership roles to hands on Power BI work, culminating in starting consulting in 2023. Rob is working with a public sector organisation, as well as training end users in preparation for PL-300 certification. Rob published a book called "Practical Data Quality" in September 2023.

Area of Expertise

  • Information & Communications Technology

Topics

  • power bi
  • power bi service
  • power bi desktop
  • Power BI Dataflows
  • Power BI Governance
  • power bi premium
  • power bi training

Fabric Capacity Management

Organisations using Power BI / Fabric Capacities must carefully monitor and manage usage of these capacities.

When capacities are not managed properly, performance can be reduced, and ultimately, users will receive error messages stating that limits have been reached until the "overuse" has been repaid.

As Power BI capacities become Fabric capacities, managing this properly needs even greater focus.

This session will outline:
- The importance of managing Fabric capacities and what can go wrong
- Using the Fabric Capacity Metrics App
- Best practices on setting notifications for capacities
- Different throttling scenarios, and the action you might take in each scenario (for example, identifying a page of a report which might be problematic and hiding it until it can be improved, or temporarily re-allocating cores from one capacity to another if the organisation has >1)
- Guidance on using Autoscale
- A real life example of a capacity migration used to re-balance content across two capacities
- What Fabric developers should be thinking about when using capacities - to safeguard performance and cost for everyone else.

Delivering high quality Power BI content

Note: This session would fit into the "Power BI Report Delivery Learning Journey" element of SQLBits.

Power BI drives key decisions in organisations. Those decisions are only as reliable as the content that they are based on.

This session is about how to ensure that the most critical Power BI content is completely robust, but without compromising speed of delivery.

Far too often, Power BI content is built under huge time pressure and significant issues which affect performance, accuracy of the data and usability are missed. Reports rely on other content such as Dataflows, Datasets and work done further upstream (and now also in Fabric workloads!). Conversely, sometimes organisations put so many governance steps in place that the pace of delivery is too slow (driving content developers crazy in the process!!)

This session is aimed at members of Power BI centres of excellence who are tasked with governing how Power BI operates in their organisation. It is also aimed at content developers, who can take ideas from the presentation to drive up quality on their own work.

Audience members attending this session should understand the basics of Power BI, including awareness of the various types of content and capabilities available (Datasets, Reports, Workspaces, Deployment Pipelines).

The audience will learn:
- How to identify which content needs which level of governance, applying only the most stringent checks to the most critical content.
- The appropriate checks to put in place as the content goes from development, to a test phase and finally goes live.
- How to appropriately design the various checks such as developer peer review, risk assessment for testing and so on.
- How to communicate with end users about the level of rigour which has been applied to the development of content.

The audience will receive detailed guidance documents and templates following the session which they can adapt to their own organisation.

Robert Hawker

Owner - Meloro Limited

Reading, United Kingdom

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