“Health – Substance Abuse Data Analysis” is based on Health medical observation through 3 months about the patients enrolled into two different programs with various health diagnosis, ages, race ethnicities, substances etc. The report tells the story about:
- 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. Thus, the difference of Test2 and Test1 is higher for Intervention program than for Usual Care.
The same conclusion can be drawn if to compare the results considering different categories: Age, Chronic Medical Conditions, Psych. Admissions, Gender, Race and Substances. - What are key drivers of different types of primary mental health diagnosis?
Analytical users can compare total number of cases for various categories (Month, Chronic Medical Conditions, Psych. Admissions, Gender, Race and Substances) by mental diagnosis. The biggest number of the cases could be considered the key driver of the mental diagnosis the total mental health diagnosis. The summary results are shown on the report. - Demographic analysis about different types of primary mental health diagnosis. As we see from the report, the most critical years for substances abused are 47, 39, 51, 46, 56, 57 and 38. At 47 and 46, the most common diagnosis is Depression, at 39 – Psychosis, at 51 and 57 – Anxiety, at 56 and 38 – Trauma.
Key used highlights or features:
1. Bookmark navigation (Two groups and updating only selected visuals). It’s used for navigation between different visuals in the same group. It’s perfect for displaying more but saving space.
2.Text boxes with auto-generated text. I’ve used it for
- describing comparing improvement results of Intervention program with Usual Care. The generated values are based on calculation of means by categories and programs.
- describing summary over key drivers of different types of primary mental health diagnosis.
DAX measures:
There are about 30 measures. Mostly - for Text boxes with auto-generated text. More complex functions - CONCATENATEX, CALCULATETABLE, SUMMARIZE, MAXX, AVERAGEX.
eyJrIjoiMzk4ODM3NTQtN2ZlMS00ODhmLThiZGItMjZhNDY4YWMwY2IzIiwidCI6ImE1ZWVkMmJmLWQwYTMtNGQ5OS1iOGNhLTIzOWQ1MmI5NjQ4OCJ9
