Power BI Challenge 4 - Wrap Up!

Hello to all my fellow Power Bi enthusiasts.

Where does the time go? Another challenge completed!

I’m beginning to struggle for superlatives to describe the work being produced.

An amazing effort across the board by all those who have participated. We are going from strength to strength with the challenge and I for one can definitely say that every challenge has presented me with a couple of golden nuggets which I can take away and consider in my work going forward.

The number of you taking the time out to document your thought process is also growing and this is something we at Enterprise DNA encourage you to do. Recording your work, writing a post, even a voice recording seriously whatever suits you.

While the challenge is the same for all, our backgrounds and experience are not. Therefore in documenting your work we can understand the thought process behind the report and expand our analytical abilities and critical thinking.

So I encourage you going forward to get involved and share your thoughts and thinking when working on a challenge. Any questions or suggestions do not hesitate to shout!

I want to take this opportunity to thank Sam for participating in the challenges which given his diary is no easy task. Sam has been working hard not only to complete the challenge but all the while recording his development effort and then doing a write up! (The man never stops!)

I would highly recommend that you watch the video and have a read of his project update and hopefully this can inspire some of you to share your thoughts over the coming challenges.

The winner

I’m sure none of you envy me and the team having to pick a winner.

A massive well done to everyone who participated and the winner this week is…………






An awesome submission which covered all bases. There was some very robust analysis teamed with some very creative design aspects an excellent report all round.

The team will be in touch with regards to your free membership.

I know I normally select a few highly commended efforts but this challenge I want to commend all participants. There were some excellent reports in the mix from experienced campaigners and also some newbies in the mix.

Be sure to check out the original post to review the entries.

Challenge 4 Submissions

Great work everyone!


The scenario this week was a little different, and we introduced some elements that we haven’t considered before.

Many companies are aware that digitisation is key to the future of their business and as a result are spending enormous amounts of money on digitising their business using technology be it applications, robotic process automation, systems etc.

Companies implement a technology (in this instance the app) to help support or improve a process by either reducing cost, improving efficiency, user experience or even all of them combined.

In my experience many companies press ahead and implement technology however forget a critical step which is to monitor the technology and measure the impact it is having.

The smartest companies understand how data can help them achieve their goals and can help focus the attention to where it is required. These companies will look to a build a cycle of build, measure, learn and then repeat this until they are happy the technology is doing as required.

The scenario this week was based on the measure and learn aspects and as to how we can use the data to understand the next iteration of improvements required in order to make the digitisation successful.

The data set was simple, and the only real nuisance was the splitting of the time and date (make sure to check out Sam’s video and post). The data could then easily be loaded into a star schema (waterfall method) for analysis.

Several of you went the extra mile and considered some advanced logic around the locations of the store and warehouses kudos to you for implementing this logic.

The brief mentioned some key points that you needed to evaluate in the report, and I think all of you managed to create metrics with regards to these points.

The key metrics were:

The no of manual scans

The no of damaged labels

The time spent store

By creating these metrics and taking a deep dive into what was happening in the app it could be seen that there are several areas that require focus.

A suggested improvement could be to eradicate manual entry completely unless there is damage to the label.

This is just one example and many of your reports provided several factors that the app team and management need to consider which was not based on soft skills but is rather backed up by DATA.

Data is a powerful tool and when we start to use it to drive change in an organisation the results and speeds of delivery are significantly improved.

Seriously the standard of work was immense, and you all did an amazing job.

A quick share in case of any of you missed it!

While reviewing the submissions I came across a very interesting technique and one I’m sure many of us will at some point need to implement.

So just wanted to call it out as its something I’ve had clients ask me about previously.

Some clients like to use a particular icon or visual for their percentage rather than a standard gauge. @harsh.nathani used a bee but you could literally substitute this to any icon of your liking. The link to the blog he used is below.

@harsh.nathani maybe you could create us a summary on the enterprise DNA forum? :blush:


I hope this challenge has benefited you all in some way and appreciate the effort you are all putting into this.

So just want to take a moment and say thank you to all those who have participated.

The challenge is all about you and enhancing your capabilities. if you have any ideas, concerns, issues or anything else you want to discuss then don’t hesitate to get in touch.

If there is an idea or scenario that you would like to see posted then don’t hesitate to get in touch.

Feel free to email powerbichallenge@enterprisedna.co for any queries
or reach out to me personally on haroon.ali@enterprisedna.co

Ok that’s enough from me.

Keep your eyes peeled for challenge 5 which will be released soon.

Any questions, requests or queries do not hesitate to get in touch.


Enterprise DNA



Congratulations on a really well-deserved win. I really loved everything about your entry, from the understand/explore/take action structure, to the perfect balance of direct answers vs. interactivity, to the gorgeous, creative design (the B&W is really impactful), and even the intricate details like the filled star icons on the explore page.

Funny story - my wife (also an analyst/researcher, though not a PBI user…yet) has gotten really into following the challenges. This past Sunday, we had the following conversation:

Her: Do you think you’re going to win?
Me: No idea. There are a ton of great submissions this challenge.
Her: Let me see.
Her: Wow, these are really good.
Her: (Getting to your submission) - Wait, is this his entry or the app he used to analyze the data?
Me: That’s his actual submission.
Her: Yeah, you’re not going to win…

Amazing work, amidst a ton of fantastic entries.

  • Brian

Love it @BrianJ :slight_smile:

Congrats @alexbadiu

Excellent job :tada:


Congratulations @alexbadiu … a beautiful, uncluttered report that naturally draws your eyes to the insights. Food for thought … hmm, challenge #5?



Wow, thank you all! I never thought I could win! I just tried to do my best! There were many many great entries this week.
It really motivates me to continue do my best in the following challenges, test new things and continue learning. :slight_smile:


Well done @alexbadiu, the presentation was professional looking, and is going to appeal to both people who want a slick design, and those who want to see ‘just the facts’.

This is something that looks like a team worked on the design, not just a single person.


Congrats @alexbadiu! Creative report and great insights

1 Like

Congratulation @alexbadiu Job well done.

1 Like


Congrats, Alex! Well deserved and awesome job.

1 Like

Aweome writeup Haroon.

And well done Alex, superb submission to the challenge. Well deserved winner this time round.


1 Like


Congratulation for job well done

1 Like

@alexbadiu, job well done!

1 Like

This is beautiful

1 Like

This is very cool!

1 Like

@alexbadiu congrats. You authored an impressive report depicting a balance of context and insights all presented in great style.

1 Like

Congrats @alexbadiu. It looks wonderful.
Hi, @haroonali1000 not sure if i missed it. Can you please share the pbix file for the same?

1 Like

@haroonali1000 @sam.mckay

When is the dataset available for next challenge(5)? Usually it will be available the next day after the current challenge is closed. Any tentative timeline so that we can plan accordingly.

Thanks in Advance!

Are you able to share your PBIX file and also a video like Sam on how you break it all down. That will be really helpful. Thanks.