Power BI Challenge 1 - Wrap Up!

Hi All,

WOW! What a start to the challenge. Some seriously awesome work by everyone. Its been fascinating to see all the entries and the similarities between them yet how distinctive they are to each of the developers. So, I just want to say a big thank you to all those who participated.

Taking the time out to focus on your development in the current climate is difficult so appreciate the time that people are putting into this.

The aim is for us all to hone and improve our Power BI skills. There were some great shares around tips from the community and it would be good to keep this going. The challenges are open to all while there will be submission deadlines you can work at your own pace and submit at any time so don’t be shy, join in.

It was really hard to select a winner this week there was things in every report I liked, from standout colour schemes awesome use of visualisations, great calculations and even some awesome readable titles and field names!

The winner this week was @Walter a great effort that combined style and substance. Please get in touch to receive a complimentary membership that you can give to any one and we will hopefully be working to get your work shared across our social media channels giving you great exposure as a developer.

There were some highly commended efforts from @BrianJ , @michaelsampsonidis and @Greg_Philps


But seriously well done to all a great effort.

Feedback

This Challenge was all about creating a summary report, a task that for many BI developers will always find its way across the desk every so often.

Overall the quality of submissions was super high, and you all did an amazing job at extrapolating what was required from a very vague brief.

The brief was left vague as its not uncommon in industry to receive such an ask and as the developer its your job to extrapolate.

It was great to see this coming through in the development through measures and visualisations.

When creating summary reports it’s so important that you are actually summarising data.

It was great to see the use of top and bottom across several the attributes. This is something that management like to be able to get instantly. ‘I should be able to see my “X” worst performing stores/products’ is a common ask. (Loved the report with the button to switch between top and bottom).

The use of segmentation is another great way of summarising and presenting data kudos to those who implemented this.

The use of a consistent and professional colour schemes was great to see. (The orange and grey monochrome were very nice)

I think with all the visualisations available sometimes we overlook basics like tables and its important to remember that sometimes that’s all that is required. It’s all about understanding who your audience is. If they like data in a table, give it to them in a table!

So just want to say a massive well done to everyone who took part in the challenge and producing a management worthy dashboard.

Here are couple points for your reference whenever you are summarising data.

Understanding the brief and your audience

One of the hardest things in delivering any technical solutions be it software, reporting or analytics is making sure that you truly understand what it is that your customer is asking of you.

In BI this can be a particularly difficult as different places have their own ways of working and processes for raising requests.

Regardless of where you are and how the request is raised there are some general principles you should try to incorporate into your thinking to aid your development.

Who is the report for? Are they data literate? These are key questions that the developer needs to be aware of. The answers to such questions will start to help build a picture around the type of request you have received.

Their position and seniority within an organisation is normally a good indicator as to how to shape the outcome. For example in many companies the higher the position the greater the responsibility and generally less time they have available.

Where is it being used? This is key as it will help understand where your requestee will be using the data and how this will shape your development for example is it to be used internally or Is it something that will be published externally.

What are they looking to achieve by using your product? An important question that will help you focus in on the mindset of your customer.

How often are they going to use it? Daily, hourly, weekly a one-off request.

You as the developer need to put yourself into the customers shoes and understand what the ask is.

Look and understand the data.

Before diving headfirst into development it’s good to just take a little bit of time to evaluate what you have been presented. Sometimes actually getting the data from source can also be part of the task however we will leave that discussion for another day.

The first point of call in any development should be for you to understand what is the data available.

A quick eyeball of your data source Excel, txt, SQL or any other data source to understand the granularity and data available.

Questions to be thinking about while looking at the data.

What is the structure of my data? 1 flat table, multiple tables.

What level of detail am I being provided? is there a single or multiple line being added for each transaction/event?

What are the dates available? Single or multiple date columns

What type of date entries are being provided? Month name ‘June’ or ‘12/06/2020’

Look for any numerical columns? Understand what it is that your going to be measuring and what’s available in this scenario we had ‘unit price’ and ‘unit cost’

What other attributes do I have available? Product, Sales Channel.

This doesn’t need to be an arduous or extensive task it’s just a great way for you to get your head in the game and high level start thinking about how you are going to approach the task at hand and what is required of you from a data preparation point of view. Is it going to require extensive modelling or is it already modelled? What attributes and values are available to you?

Getting stuck in.

Its time to start developing!

Can’t emphasise enough the importance of implementing the 4-step process and what we at Enterprise DNA consider to be the 4 pillars of any Power BI solution.

  1. Loading and transforming data
  2. Data modelling
  3. DAX calculations
  4. Report and visualizations

Reviewing your solution

Once you have completed your development, I always like to take a moment and just reflect on the brief and act as the user would with the report to ensure that all aspects of the brief have been covered. This can sometimes prove difficult as through development you can often get tunnel vision so always step away for a little while before reviewing.

Ok that’s enough from me.

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

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

Haroon

12 Likes

Congrats @Walter
:+1:
.

@haroonali1000 maybe you can add screenshots of the winners report in your summary OR elements from other reports that you wanted to emphasize - thanks!

1 Like

Thanks @Melissa great shout.

1 Like

Congrats @Walter!! Fantastic report with much to draw from.

Thanks for the Challenge EDNA, it was fun and a great way to learn!

1 Like

Thanks for the recap and Congratulations @Walter !

This was a great challenge and look forward to the next one.

1 Like

@sam.mckay, @haroonali1000 and @EnterpriseDNA,

First off, thanks to Sam, Haroon and the rest of the Enterprise DNA Team for running a fantastic contest, and congratulations to @Walter for coming out on top in the field of very strong entries across the board. Given that the challenge thread is already the third most popular post of all time on the forum shows you’re clearly onto something here.

As I was reviewing all the entries, looking for tips, tricks, interesting visual presentations, great color themes, etc. I could use in my future reports, I had an idea for how to leverage the results of this and future contests into a unified design resource. Would it be possible to include the screenshots from each contest submission in the eDNA Report Design Inspiration Gallery and make each pic a clickable link to the published file?

Having all the current and future submissions in one place, where they could be easily browsed and explored would be incredibly valuable IMO.

Thanks for considering.

  • Brian
6 Likes

@BrianJ,

Couple of possible issues with the clickable link to the published file:

  1. What is someone deletes the published link
  2. Not everyone was able to publish the web link.

Might be a bit better if there was somewhere where we could access all the PBIX files. That way if someone wants to see how someone did something, they would have direct access. At the least, have a snapshot of the report available in the https://info.enterprisedna.co/report-design-inspiration/

Thanks
Jarrett

5 Likes

@ojones,

“Might better a bit better if there was somewhere where we could access all the PBIX files. That way if someone wants to see how someone did something, they would have direct access.”

Agreed. That’s definitely an improvement on my initial suggestion.

Thanks.

  • Brian

Great idea on sharing content. Not sure if it’s possible to have a Power BI Workspace dedicated for these challenges or if that’s even feasible but thought I would comment about it.

I’m not able to publish a report to web because of the restriction I have in my Power BI workspace so I can’t share the links to my reports only the PBIX file. It’s a policy that would have be changed by the workspace admin. I’m probably not the only one with that issue so just thought I would mention it.

Thanks Sam and EDNA team for these challenges! They are a great way to practice an improve.

Thanks,
Mike

2 Likes

Hi All,

Really appreciate the feedback and some great stuff for us to take away and think about.

Will keep you all posted.

See you on the next challenge.

Thanks,
Haroon

2 Likes

Congrats @Walter and thanks eDNA for the challenge😃

Daniel

1 Like

congrats @Walter and thanks to Enterprise DNA team.

I also agree that if we can upload pbix files would be easy and better option. Looking forward for next challenge.

Also, do we get feedback for each of the report submitted?

Well done Walter.

Awesome work everyone.

The challenge initiative has been a great one. I’m excited about where this can go…

Sam

1 Like

Super ideas Brian. We will do this. We also will be looking to place some of the entries over time on our Showcase page.

Sam

2 Likes

Yes the publish to web will be an issue, so we won’t do this directly.

For the top showcases, if approved we plan to use these within our showcases and then we will then make the pbix files accessible to all members.

We are also looking at creating a new section in our knowledge base which will keep track of each challenge and maintain all details of challenges going forward.

We will work on this over the coming days.

Thanks
Sam

7 Likes

Great @sam.mckay, it will be a good initiative

Great work you did there @Walter

Great work @Walter, keep it up!

It seems as if I see different numbers for some of the common measures, like sales by location and such. Do others see the same thing?

Would it be possible to post the “correct” numbers so that I can figure out if, and how, I missed the mark on some of the measures?

Since I am very much still learning, I suspect there may be flaws in my Dax or logic somewhere and I’d like to work through any errors I made.

Thanks,
Jamie

Great idea @BrianJ