Upcoming event
Past Event
22
Feb 2024

The Power in BI - Building Better Reports with Better (Best) Practices

Linkedin Live
|
4:00 pm
-
5:00 pm
This webinar will be focused on how best practices can not only significantly reduce refresh and visual response times, but shave hours or even days off of your development and ongoing maintenance efforts. Register now.

The Event

Linkedin Live

With the continued refinement of the point-and-click UI interface, alongside the emergence of AI-based tools, it’s never been easier for the citizen developer to quickly visualise an organisation’s data. 

However, this ease of use often overlooks central questions related to optimization and modelling:

  • Can we be certain of the quality of the data?
  • How will we refresh and maintain the source data?
  • How will a refresh impact the source system?
  • Is the data model designed to ensure the best performance?
  • Are our measures built to be both performant and easily maintained?
  • Is this really the best user experience?
  • Do we need to start from scratch for each new report request?

In this webinar hosted by our resident expert in all things Power BI, Tim Volz, we’ll explore answers to all of the above questions - and more. Focusing on how best practices can not only significantly reduce refresh and visual response times, but shave hours or even days off of your development and ongoing maintenance efforts.

𝗗𝗮𝘁𝗲: 22nd February 2024

𝗧𝗶𝗺𝗲: 11:00 PM EST / 4:00 PM GMT

𝗗𝘂𝗿𝗮𝘁𝗶𝗼𝗻: 1h

This webinar is perfect for technology enthusiasts, business leaders, and anyone simply curious about Power BI and its capabilities to improve organisational efficiency.

Register now!

Topics Covered

Getting the most from Power Query to ensure the best foundation possible for your reports

Building the most performant data relationships possible

Understanding DAX: when to use it and how to optimise it

Expanding the interactivity and visual information for end users in your reports

Maximise semantic model reusability and collaboration

Event Agenda

16:00
 - 
16:15

Getting the Most from Power Query

  • To transform or not to transform…there is no question
  • How to identify and mitigate data quality issues
  • It’s a date! Creating a calendar table
  • Save time with parameters and functions
  • M code – a quick peek under the hood
  • Order matters – arranging transformation steps
Tim Volz
Business Intelligence Analyst
,
The Virtual Forge
16:15
 - 
16:20

Optimizing Data Relationships

  •  Merge vs relationships
  • Why the star schema is best
  • Understanding cardinality and cross filter direction
  • Dimension and fact tables – the ideal relationship
Tim Volz
Business Intelligence Analyst
,
The Virtual Forge
16:20
 - 
16:35

Demystifying DAX Development

  • The basics of DAX syntax
  • Measures vs calculated columns
  • Explicit vs Implicit measures
  • Fundamental functions
  • CALCULATE and filter functions – perfect together
  • Activate the inactive with USERELATIONSHIP
  • Time intelligence
Tim Volz
Business Intelligence Analyst
,
The Virtual Forge
16:35
 - 
16:50

Enhancing Visual Engagement

  • Conditional formatting” bringing the outliers to light
  • Using “What if?” parameters to answer the “what if?” questions
  • Customize labels with dynamic formatting
  • Field parameters and measure swapping
  • Bookmarks will take you where you want to go
  • Controlling layer order and other visual formatting tricks
Tim Volz
Business Intelligence Analyst
,
The Virtual Forge
16:50
 - 
16:55

Collaboration and Reusability Beyond the Report Canvas

  • The advantages and disadvantages of connecting to a published dataset
  • Maximizing the reusability of table transformations with dataflows
  • PBIDS files – the key to collaborative development
Tim Volz
Business Intelligence Analyst
,
The Virtual Forge
A The Virtual Forge Divider

Event Speakers

Tim Volz

Business Intelligence Analyst
,
The Virtual Forge

Over the past ten years, Tim has worked on nearly every aspect of the project lifecycle, from initial contact through ongoing operational support. He’s worked in Customer Service, Project Management, and Account Management, finally settling in to a data-centric role focused on analytics and integrations. Given his background in philosophy and logic, Tim’s passion for the role should come as no surprise. When Tim’s not planning data integration strategies, designing dashboard prototypes, or troubleshooting stored procedures, he can be found running the roads of his adopted hometown, Doylestown, PA, preparing for the next distance race on the agenda.

VF Microphone Image

Register for the event

Spaces are limited so please do reserve your place as soon as possible.
Please fill out this field.
Please fill out this field.
Please fill out this field.
Please fill out this field.
The Power in BI - Building Better Reports with Better (Best) Practices
Send Message

Thank you.

We've received your message and we'll get back to you as soon as possible.
Sorry, something went wrong while sending the form.
Please try again.