Lecture #2 In Class Assignment OLAP 24

.docx

School

Chamberlain University College of Nursing *

*We aren’t endorsed by this school

Course

242

Subject

Business

Date

Jun 13, 2024

Type

docx

Pages

1

Uploaded by DeaconGoosePerson571

CNHP 4450 In Class Assignment – Lecture #2: OLAP The assignment demonstrates the use of Online Analytic Processing (OLAP) or “Cube” Methodology to access data from the data warehouse. You will locate https://dph.georgia.gov/about-dph/health-data-and-statistics to answer the questions below. Using the Georgia OASIS OLAP reporting tool answer the following questions. Navigate the various category and choose “Get Data” to reset your data. 1. What is the leading cause of Age-Adjusted Death from 2018-2022 __Heart and Vascular disease _____________ 2. For Baldwin County, what is the highest cause of Death for African Americans? __________Hypertention__________________________________________________ 3. For Fulton County, where does Homicide Rank in terms of Deaths? _14 th __________ 4. How many ER visits did Cobb County have in 2022? ______182,867___________________________________________________________] 5. What is the ER visit rate for Cobb County? _______913,758__________________________________________ 6. What do you think is the difference between the counts and the rates? Counts refer to the total number of occurrences, while rates are standardized per population size to allow for comparisons across different population sizes _______________________________________________________________________ 7. Use the map feature to see if Fulton County has one of the highest ER rates in GA. ____ No Fulton county has a low ER rate in GA____________________________________ 8. For Alzheimer’s and Dementia Related Disease what is the death rate for Blacks? __ 55.2___________________________________________________________ 9. For Alzheimer’s and Dementia Related Disease what is the death rate for Whites? _____ 126.0___________________________________________ 10. Gather one additional piece of information of interest to you from this data. __ Infant Mortality Rate interested me, This can provide insights into health disparities and the effectiveness of public healthinterventions._____________________________________________________________ _ __________________________________________________________
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help