Builds 23 "Health & Substance Abuse Report Analysis"

ChallengeTeam · October 21, 2022, 9:35am

Hi everyone, this is an entry submitted by Kiruba Selvi via email.

Here’s how Kiruba selvi described it:
"I’m happy to submit my Enterprise DNA Challenge report. Very interesting dataset. I hope you like my report!“

You can view the full report here
Kiruba selvi

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 10:43am

Hi everyone, this is an entry submitted by Usman Ghulam Nabi via email.

Here’s how Usman Ghulam Nabi described it:
" I have accepted Enterprise DNA Challenge 23 " Health-Substance Abuse Data Analysis. This is my first submission to the Enterprise DNA challenge. The data set was small but unique and full of insights. I personally tried to present it in a bit different style than my other reports/dashboards.“

You can view the full report here
Usman Ghulam Nabii

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 10:49am

Hi everyone, this is an entry submitted by Bhanu Gautam via email.

Here’s how Bhanu Gautam described it:
I have accepted Enterprise DNA Challenge 23 " Health-Substance Abuse Data Analysis. This is my first submission to the Enterprise DNA challenge. The data set was small but unique and full of insights. I personally tried to present it in a bit different style than my other reports/dashboards.“

You can view the full report here
Bhanu Gautam

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 10:57am

Hi everyone, this is an entry submitted by Chawki Hazam via email.

Here’s how Chawki Hazam described it:
" Je vous prie de bien vouloir trouver en attachement ma modeste. Participation à la 23e édition relative au Challenge de l’Entreprise

DNA . Merci @Federico Pastor pour cette opportunité. “

You can view the full report here
Chawki Hazam

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 10:59am

Hi everyone, this is an entry submitted by Kim Cook via email.

Here’s how Kim Cook described it:
"Please find my entry for the EDNA Challenge 23. I love the dataset. I hope you like my report.“

You can view the full report here
Kim Cook

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 11:04am

Hi everyone, this is an entry submitted by Daniel Bonilla via email.

Here’s how Daniel Bonilla described it:
"Please find my entry for the EDNA Challenge 23. I love the dataset. I hope you like my report.“

You can view the full report here
Daniel Bonilla

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 11:11am

Hi everyone, this is an entry submitted by Blessing Ibrahim via email.

Here’s how Blessing Ibrahim described it:
"Please find my entry for the EDNA Challenge 23. This is firs time entering an EDNA challenge. I love the dataset. I hope you like my report.“

You can view the full report here
Blessing Ibrahim

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 11:13am

Hi everyone, this is an entry submitted by Sana Khatoon via email.

Here’s how Sana Khatoon described it:
"Please find my entry for the EDNA Challenge 23. This is firs time entering an EDNA challenge. I love the dataset. I hope you like my report.“

You can view the full report here
Sana Khatoon

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 11:17am

Hi everyone, this is an entry submitted by Kyei Baffour via email.

Here’s how Kyei Baffour described it:
"Please find my entry for the EDNA Challenge 23. This is firs time entering an EDNA challenge. I love the dataset. I hope you like my report.“

You can view the full report here
Kyei Baffour

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 11:21am

Hi everyone, this is an entry submitted by Farah Abdou via email.

Here’s how Farah Abdou described it:
"Please find my entry for the EDNA Challenge 23. This is firs time entering an EDNA challenge. I love the dataset. I hope you like my report.“

You can view the full report here
Farah Abdou

Please feel free to give your feedback on his report

ChallengeTeam · October 22, 2022, 11:26am

Hi everyone, this is an entry submitted by Tatsiana Starastesenkavia email.

Here’s how Tatsiana Starastesenka described it:
"Which hospitalization program is better comparing the difference of Daily Living Test2 and Test1 between Intervention and Usual Care programs. As a result, we see strong improvements in patients at Intervention program. At the same time, the results of Test2 by Usual Care are remained practically unchanged.“

You can view the full report here
Tatsiana Starastesenka

Please feel free to give your feedback on his report

Yted · October 24, 2022, 2:26am

Hi fellow Power BI Enthusiasts

I thought it was about time that I started putting forward submissions into these fantastic challenges, so please find my first entry.

Report Url: EDNA Challenge 23 - Health Substance Abuse Report

eDNA_23

ChallengeTeam · October 24, 2022, 6:40am

Hi everyone, this is an entry submitted by Vineeta Khati via email.

Here’s how Vineeta Khati described it:

Here is my submission to EDNA Health - substance abuse data analysis challenge. The data includes around 500 patients participating in mental health program. Two kind of programs one is Usual care program and Intervention program. I have tried to analyse the data according to the requirements given in the challenge

You can view the full report here
Vineeta Khati

Please feel free to give your feedback on his report

ChallengeTeam · October 24, 2022, 6:43am

Hi everyone, this is an entry submitted by Juan- Pierre Louw via email.

Here’s how Juan- Pierre Louw described it:

Here is my submission to EDNA Health - substance abuse data analysis challenge. Dynamite comes in small packages- and this is true for this very small dataset, and on such an important topic which is more prevalent these days. I tried to stick to the basics with no “fancy analysis”, just the key detail with some recommendations

You can view the full report here
Juan- Pierre Louw

Please feel free to give your feedback on his report

ChallengeTeam · October 24, 2022, 6:46am

Hi everyone, this is an entry submitted by David Okenwa via email.

Here’s how David Okenwa described it:

" Attached is my submission to the Enterprise DNA challenge 23 on Substance Abuse and Mental Health. Thank you for the wonderful dataset and brief .“

You can view the full report here
David Okenwa

Please feel free to give your feedback on his report

ChallengeTeam · October 24, 2022, 6:48am

Hi everyone, this is an entry submitted by Karol Jachyra via email.

Here’s how Karol Jachyra described it:

"Attached is my submission to the Enterprise DNA challenge 23 on Substance Abuse and Mental Health. Thank you for the wonderful dataset and brief . I hope you like it.“

You can view the full report here
Karol Jachyra

Please feel free to give your feedback on his report

ChallengeTeam · October 24, 2022, 6:50am

Hi everyone, this is an entry submitted by Timoumi Rafouf via email.

Here’s how Timoumi Rafouf described it:

"This is my primary trial reporting dealing with the challenge of data visualization about substance abuse analysis.

Looking further for all additional advice to improve and generate better results and contributions. I hope you like it.“

You can view the full report here
Timoumi Rafouf

Please feel free to give your feedback on his report

ChallengeTeam · October 24, 2022, 6:52am

Hi everyone, this is an entry submitted by Nandhu Krishnan via email.

Here’s how Nandhu Krishnan described it:

"This is my entry for challenge 23 about data visualization and substance abuse analysis. Looking further for all additional advice to improve and generate better results and contributions. I hope you like it.“

You can view the full report here
Nandhu Krishnan

Please feel free to give your feedback on his report

abbi · October 25, 2022, 7:59am

mspanic · October 25, 2022, 5:10pm

Hi everyone,

Following the brief – I focus on 2 main part:

different hospitalization programs comparison
primary mental health diagnosis analysis

For program comparison I put a KPI list as vertical table:

KPI list in the middle
Separate Columns for each program

Try to keep it clear and simple as possible. Also for #Psyhiatric Admission I use

I add additional row to separate KPI list from Top Dimensions

On the top I put summary for each program.

I put also dynamic summary DLA commentary measure for each program - Depends of what is pick (additional tables can be use as filters + additional IsBlank is added to not display if There is no %Patients):

DLA Commentary = 
VAR DLAIm =[% DLA Improvements]

RETURN 
IF( ISBLANK(DIVIDE([# Patients], CALCULATE([# Patients], ALL('Substance Abuse Programme'[Program])),0)),
"",
IF(DLAIm <=0, 
"No Daily Living Activities Score (DLA) Improvement.", 
" Daily Living Activities Score (DLA) improvement by " &FORMAT (DLAIm,"0.0 %")))

Instead something like this:

Finally I decide to put Tooltips (to keep clean and simple style).

Since demand is 1 page report different analysis around primary mental health diagnosis analysis, I used matrix :

primary mental health diagnosis as column
slided by field parameters (with different dimension options) as rows - could pick one or more
and number of patients as values (heat map style with conditional formatting – dark color = less patients)

All visuals are Native Power BI +I used PowerPoint for background (and info page)

Add also Info page with short description

Hope you like it.