Best Practices for Report Design & DAX in Power BI (with Gustaw Dudek)

Published 2022-11-04
Microsoft Power BI tool consistently provides new features and capabilities to transform the raw data into meaningful insights. Effective UI/UX solutions can be driven by various different functionalities such as, but not limited to: built-in visual-related formatting options (including conditional formatting). In particular contexts, those options can be enhanced ever further by incorporating strategic DAX techniques. By using a combination of the following approaches, including design practices and DAX solutions, it is possible to create reports and dashboards that tell compelling stories from our data in a highly interactive way!

This presentation will demonstrate several practical design & DAX techniques that helps increase report transparency and user experience through the application of certain functionalities, interactions and formatting options.

GUEST BIO πŸ‘€
Gustaw Dudek works as the Head of Business Intelligence at the Polish Company (Enterium). He has multiple years of experience in the field of data analytics and business intelligence. In addition he's one of the resident Enterprise DNA Experts, having created multiple showcase reports for various EDNA contests. Despite of designing most of showcase reports in dark-mode, Gustaw is a huge advocate of IBCS chart standards and really enjoys exploring both the art and science of report design.

RELATED CONTENT πŸ”—
LinkedIn -- www.linkedin.com/in/gustaw-dudek
NovyPro Portfolio -- www.novypro.com/profile_projects/gustaw-dudek

LET'S CONNECT! πŸ§‘πŸ½β€πŸ€β€πŸ§‘πŸ½ 🌟
-- twitter.com/HavensBI
-- www.linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting

CHECK OUT OUR MERCH STORE πŸ‘•
-- havens-consulting.creator-spr...

HAVENS CONSULTING PAGES πŸ“„
Home Page -- www.havensconsulting.net/
Blog -- www.havensconsulting.net/blog-and-media
Blog Files -- www.havensconsulting.net/blog-files
Files & Templates -- www.havensconsulting.net/files-and-templates
Consulting Services -- www.havensconsulting.net/consulting-services
Online Course -- www.havensconsulting.net/online-courses
Contact & Support -- www.havensconsulting.net/contact-and-support

EMAIL US AT πŸ“§
[email protected]

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #visualbi #dax #charts #modeling #bestpractices

All Comments (13)
  • Reid - per your question about the Chi Square visual on page 2 of the eDNA Challenge report, that was created with the ggstatsplot package within R. Gustaw is correct that in the version we submitted, that was exported from R as a .png and then pulled into PBI as a static image. However, that was done simply because R visuals do not show up in Publish to Web. However, in the non-PTW version of this report, that visual is generated as a Power BI R visual dynamically upon refresh.
  • @logiman
    I love his report designs. These give me some solid ideas for my projects. This about 20 levels ahead of me. Wow!
  • @jadwiga8759
    Amazing video!! Got a list of techniques that I need to apply in my reports
  • Thank you so much for a fantastic presentation. I learned a lot πŸ’―
  • Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered '. I got this error while loading data, what can I do?
  • too bad field parameters are not available in reports with live connections :-(