After rolling out an excellent Hotel Revenue Management challenge, we are announcing Challenge 23.
“Health – Substance Abuse Data Analysis”
About the dataset
One Excel Workbook – Substance Abuse
PBI file – Data model provided.
Data Dictionary included in the Excel Workbook
Brief in PDF format
Our project start date is 26/09/2022 and your final reports must be submitted by the 26/10/2022.
Report Developer Role:
It is your job as an analyst to prepare an analysis report about the Substance Abuse dataset. The following questions must be addressed in your report.
Compare different hospitalization programs. What conclusion(s) can you draw from it?
What are key drivers of different types of primary mental health diagnosis?
Demographic analysis about different types of primary mental health diagnosis?
What other analysis would you like to have?
What other recommendations would you like to make?
Special Client Requirements:
- Client believes that a 1 one page, maximum 2 pages will suffice for this report.
- Client do not want an Intro Page but suggests instead vertical/horizontal navigation bars or pop-up menu.
- Not scrollable or fancy shape reports, report must fit well within a page. Preferred size 16:9.
Reports is limited to 2 pages, no other restrictions, or techniques. Feel free to use all the techniques at your disposal – tooltips, drill throughs, page navigations, etc.
That is all for the brief!
Submission of entries
To be considered within the competition, entries are due no later than 11:59pm GMT on 26th October 2022.
Join our challenge group at
How to submit:
Email the completed PBIX file to
Take an image of your report and post it to the Enterprise Challenges Group
Take the image plus URL and post them on LinkedIn tagging Enterprise DNA to say, “I accepted the Enterprise DNA challenge.”
#EDNADataChallenges & #EDNAHealthSubstanceAbuse
We always encourage all participants to do a brief description of how they approach the project, share their experience of participating in the challenge on the forum/social media.
If you need any help with publishing, please reach out to one of the team managers for assistance (post in the forum/LinkedIn group) or email to email@example.com
Dataset 1 - contains a Power BI file fully modelled and ready for action.
Dataset 2 - contains an Excel workbook and Enterprise DNA Calendar Table.