Challenge 2 - Customer Insight

So here it is all the 2nd installment of the EDNA challenge.

Remember its open to everyone so don’t be afraid to get stuck in.

To learn more about the challenge and how it works be sure to check out here!

If you’re not sure of anything just reach out to me.


Welcome to the EDNA Data Challenge.

An opportunity to enhance your Power BI development and learning curve.

Sharing, learning and growing!

Join us bi-weekly for a new scenario based on what you are likely to face in the real world. We take a data set and turn it into an actionable report providing information and insight. The Enterprise DNA community will then come together to review the project and would love for you to join us.

Remember: The weekly winner will receive a complimentary membership to the platform that they can share with anyone and the opportunity for your work to be showcased across our channels.


You are an analyst working closely with the customer team.

The customer engagement manager (Janet) has just returned from a meeting and has been given two data sets. One contains customer sales information and the other customer engagement information.

Janet is now looking for you to produce a report that looks at both data sets and gives us some insight into customer behaviour.

She is not sure if there is a correlation between sales and engagement but would like to know either way.

There is 1 years worth of data taken from both systems.

The ball is now in your court and you need to find a way presenting this data back to Janet and the team.

SUBMISSION DUE DATE – Sunday, 28th June 2020 (PST)

Please can you all submit your PBIX files to powerbichallenge@enterprisedna.co

Objective: Produce a report which summarizes both data sets.

The data set can be downloaded below both datasets are in the one Excel file.

Click here to download the data set.

Click here to see who won this challenge.

Join the Enterprise DNA Community here.