Pragmatic Works Nerd News

Power BI Data Challenge ๐Ÿ“Š Report From Start to Finish โฑ๏ธ

Written by Amelia Roberts | Sep 28, 2024

In this special edition of Dev Dash, hosted by Amelia Roberts on the Intergalactic Learn with the Nerds day, Power BI trainers Angelica and Allison go head-to-head in a fast-paced competition to create a Power BI report from scratch. Both contestants are tasked with building a Power BI report using a dataset of failed banks, transforming and modeling the data, and creating five visuals, including one custom visual.

 

Key Challenge Requirements

  • Bring in a live dataset and clean it up using Power Query.
  • Create a date table using DAX, build a hierarchy, and check the data model for relationships.
  • Build five visuals: four standard Power BI visuals and one custom visual.
  • Use the Q&A feature to create a map and design a custom tooltip that includes a map and a card visual.
  • Apply a custom space-themed design to the report.

Challenge Highlights

  • Angelica impressed the audience with her quick data modeling skills, effortlessly creating a date table using DAX and showcasing her mastery of Power BI features like custom tooltips.
  • Allison stood out with her attention to design, spending time perfecting the space-themed visuals and ensuring the report was both functional and visually cohesive.

The Final Reports

  • Both contestants successfully completed the challenge by cleaning the dataset, building out interactive reports, and applying custom visuals.
  • While Angelica demonstrated a strong technical approach, Allison's dedication to styling and theme won the judges' hearts, leading her to victory in this Power BI Dev Dash.

Conclusion

Congratulations to Allison for her well-deserved win! Her ability to combine speed with a polished, professional design gave her the edge in this Power BI Dev Dash. Don't forget to check out more Dev Dash challenges on the Pragmatic Works YouTube channel and see how these experts push the limits of Power BI development.

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.