Help with Data Modeling for dynamic hierarchical data

You have come to the right place. Every month Enterprise DNA runs a “Data Challenge” where you are given a sample dataset, and a short brief explaining the overall goal and the type of questions your report should answer. Participants post their reports along with a detailed writeup explaining how they created their report. In addition, Enterprise DNA founder and CEO Sam McKay provides a written evaluation with detailed constructive feedback for every single entry submitted. Entrants range from relatively new Power BI users to expert professional developers, and the community is incredibly supportive. I think almost every single person who participates regularly in the Challenges would tell you that it is the absolute best way to improve your Power BI skills quickly, and that it’s also a lot of fun. Data Challenge #12 should be kicking off this coming week, and you can find all the past Challenges, reports and PBIX files in the Data Challenge Showcase.

I would really encourage you to give it a try. In addition, we also offer some great prizes for the top submission each challenge by a first time entrant.

In addition to the Challenges, on the first and third Wednesday of each month we run “Problem of the Week”. These are intermediate level problems based on applied, practical problems that would be commonly seen in a business environment. The first problem each month is a DAX problem, while the second problem each month is focused on the use of Power Query. The problems are run by different members of our expert team, so you get exposed to a wide variety of techniques and problem-solving styles, both from the lead expert and from all the other entrants as well.

Past Problems of the Week, , along with submissions and expert solution videos can be found in forum Problem of the Week category:

https://forum.enterprisedna.co/c/problem-of-the-week/51

The DAX Problem of the Week for March kicks off this Wednesday.

So, lots of great structured practice opportunities to improve your Power BI skills. Hope to see you in one or both of these, and give a shout if you have any questions.

  • Brian