Power BI Challenge 13 – Acing Your Documentation

by | Power BI

We’ve just finished a difficult yet fulfilling 12th round for the Power BI Challenge, which was based on a transport and shipping dataset. This was probably one of the most difficult challenges we’ve had to date, and we’re very impressed with the participants’ in-depth analysis on their entries. 

Challenge #13

Now that we’re moving onto the next round, we’ll focus on something that is often overlooked in the creation of a Power BI report – the documentation process.

More often than not, documentation is an afterthought rather than a task that needs to be done. However, documentation is important in order to make the report sustainable and maintainable not only for you, but for other users in the long run.

So how can we consistently provide great documentation without the need for loads of additional work? That’s easy — let’s get Power BI to do the work for us!

This week’s challenge is all about creating a report which documents another report. You’ll get to use and play around with an external tool called Document Model to make the task easier, but it won’t be a requirement for this challenge.

The Power BI Challenge

For this challenge, all of us will be using this simple financial report template to achieve consistency.

Remember that the key requirement for this challenge is to provide a report which effectively documents the above report so that anyone can view it and have a good understanding of what the report comprises without the need to go to the specific report.

Just like always, the entries will be judged based on the four pillars of a great Power BI report:

  • Data loading and transformation
  • Data modeling
  • DAX calculations
  • Reports and visualizations

The winning entry gets a cash prize, as well as complimentary membership to Enterprise DNA. The exceptional entries also get featured on Power BI Challenge Showcase, which allows members to practice their Power BI skillsets and get some hands-on experience using actual reports and dashboards from different industries.

Deadline for submission is on Sunday, 23rd May 2021 (PST).

How to Join 

The good news is that everyone can join the challenges – even if you’re a non-member.

First things first: check out the forum thread inside the Enterprise DNA Forum. Once you’ve completed the challenge, all you need to do is:

  1. Download the data set from the forum.
  2. Post your report on the thread.
  3. Submit your PBIX files to powerbichallenge@enterprisedna.co

When you submit your report, just use the subject line Power BI Challenge 13 – Name (Member). If you’re not a member yet, use the subject line Power BI Challenge 13 – Name (Non-member) instead.

Not yet an Enterprise DNA member? You can still join by going here:

  1. Submit your PBIX file, images of the report, link and description to powerbichallenge@enterprisedna.co
  2. Post this caption on your social media accounts along with the image below: I accepted Enterprise DNA’s Power BI Challenge
  3. Make sure to hyperlink this post
  4. Use these hashtags on your social media post – #EnterpriseDNA #EnterpriseDNAPowerBIChallenge #PowerBIChallenge #PowerBIChallengeAccepted

Join the challenge now and learn from leading Power BI experts, receive personalised feedback on your development, and get a chance for your entry to be featured across the entire Enterprise DNA network. Good luck!

Related Posts

Using the DISTINCT Function Effectively in DAX

DAX Table Functions Deep Dive

Explore an in-depth analysis of DAX table functions in Power BI, comparing SUMMARIZE and ADDCOLUMNS, and understanding INTERSECT and EXCEPT for enhanced data manipulation and analysis.