Who can Build the Best Power BI Report in 30 minutes?

In the latest episode of "Dev Dash," hosted by Amelia Roberts, two expert trainers from Pragmatic Works, Jonathan and Greg, compete to build the best Power BI report in just 30 minutes. The twist? Their dataset revolves around coffee, and Greg introduces an additional challenge: incorporating buttons to enhance interactivity. This spirited competition showcases the participants' creativity, speed, and expertise in Power BI.

Setting the Stage

Amelia kicks off the challenge by introducing the trainers and their friendly rivalry. Greg, the younger trainer, claims Jonathan's "old-school" methods will slow him down, while Jonathan believes experience will give him the edge. The dataset is focused on coffee sales, and Greg adds the interactive element of buttons as the unique challenge for the reports.

Data Preparation

Both trainers dive into Power Query to clean and prepare their data. Jonathan emphasizes best practices, like renaming columns for clarity and creating a date table to enable time intelligence features. Greg opts for a faster DAX-based approach to creating his date table, trading some efficiency for speed. Both highlight the importance of data modeling, including setting up a star schema for optimal performance.

Designing the Reports

The contestants take different approaches to their visuals and functionality:

• Jonathan: Focuses on clarity and organization. He includes slicers for month, location, and product category, complemented by visuals like maps and matrix tables. Jonathan adds a "Clear All Filters" button and applies conditional formatting to highlight sales performance by product category.
• Greg: Prioritizes interactivity and compact design. He uses tree maps instead of pie charts for a cleaner layout and incorporates tooltips to save space while enhancing usability. Greg experiments with custom visuals, such as a play axis slicer, but faces challenges with its functionality during the presentation.

Judging the Results

Amelia evaluates the final reports based on style, functionality, and usability. Jonathan's report stands out for its organization and adherence to best practices, earning him the win. Greg’s report, despite innovative features like the play axis slicer and Q&A integration, suffers from technical issues that prevent its full functionality.

Key Takeaways

Both trainers share reflections on their strategies and performance:

• Jonathan highlights the importance of foundational best practices, such as clear naming conventions, robust data modeling, and effective use of visuals.
• Greg stresses the value of interactivity and compact design, while acknowledging the need to test custom visuals thoroughly before implementation.

Conclusion

The episode concludes with Jonathan claiming victory and the promise of more exciting challenges in future episodes of "Dev Dash." Both contestants demonstrate that even under time pressure, Power BI can be a powerful tool for creating informative and engaging reports.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power BI and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.