What specialty had the least duration of waittimes? Note that you may need to edit your dashboard view to extend the number of decimal places on the appropriate field to find the lowest value for this measure.

Exercises

  1. What specialty had the least duration of waittimes? Note that you may need to edit your
    dashboard view to extend the number of decimal places on the appropriate field to find the lowest
    value for this measure.
  2. What was the average wait time for Pain Management patients in December of 2008- 2009?
  3. What is the average wait time for plastic surgery patient’s ages 19 -30?
  4. What was the average wait time for day case admission in October of 2009 –2010
  5. How many oral surgery patients were white during September 2009- 2010?
  6. What was the average length of stay for a patient in neurology, both elective and nonelective in August 2009 – 2010?
  7. What was the average length of stay for patients in the 81 to 95 age group in August
    2008 – 2009?
  8. What specialty has an average length of stay of 10.22 days?
  9. For age group 0 – 12, what is the average length ofstay?
  10. How many spells did emergency pediatrics have from 2007 – 2010?

DAT 530 Hospital Activity Guidelines and Rubric
Overview: There are a variety of tools available today for creating data visualizations. Choosing the right tool is a crucial step in designing relevant visualizations
that help tell the story that the data holds for the audience. In this course, students are exposed to several tools. In this assignment, students will use one of
these tools—QlikView—and complete exercises to become more familiar with the tool’s capabilities.
Prompt: Develop the dashboard for the Hospital Activity by following a step-by-step guide.

  1. Follow the instructions in Module One to set up QlikView.
  2. Access the Qlik tutorial using your web browser: Build Your First QlikView. If you need an orientation to the program, review the other tutorials on the
    page.
  3. Open the Dashboard Guide—Hospital Activity document (in the Assignment Guidelines and Rubrics folder).
  4. Follow each step listed on pages 3–13.
  5. Save your completed QlikView Dashboard project for further reference.
  6. Review the Exercise questions 1–10 on page 16 of the Dashboard Guide—Hospital Activity document. Answer all of the questions as part of your analysis
    of the results.
  7. Write a 1- to 2-page report on your opinion of the QlikView tool. The answers in your report should communicate your analysis of tool assessment to
    your manager. The report should include the following sections and corresponding criteria:
    o Data Visualization Tool Usage
     This should include your opinion of ease of use, intuitiveness, and general thoughts for how it could be used in the organization.
    Additionally include a comparison of QlikView and Google Public Data, which you used in Module One, in terms of ease of use, flexibility,
    and the strengths and weaknesses of each visualization tool.
    o Exercise Results
     Answer the exercise questions 1–10 on page 14 of the Dashboard Guide—Hospital Activity document.
     Using the experience gained and specific results produced from the Hospital Dashboard you created, briefly explain how the resulting
    data can be used by different users for information. Include screenshots of the dashboard results to support your position.
    Rubric
    Guidelines for Submission: In Microsoft Word, submit your written report for both of the critical elements: Data Visualization Tool Usage and Exercise
    Results.
    Critical Elements Exemplary (100%) Proficient (90%) Needs Improvement (70%) Not Evident (0%) Value
    Data Visualization
    Tool Usage
    Meets “Proficient” criteria, and
    the technical assessment
    includes additional discussion
    and comparatives to a third
    visualization tool
    Demonstrates knowledge of
    QlikView and provides a
    technical assessment of
    QlikView including a
    comparative Google Public Data
    tool write-up
    The technical assessment of
    QlikView and comparative
    Google Public Data tool writeup did not fully demonstrate
    knowledge of the tools
    Submission was not posted or
    did not contain the technical
    assessment
    50
    Exercise Results Meets “Proficient” criteria, and
    answers to all 10 questions are
    correct
    The submission includes
    thoughtful and supported
    opinions of QlikView dashboard
    analysis with supporting
    screenshots and answers to the
    10 questions
    The QlikView analysis was
    included but does not express
    results usage effectively, or the
    questions are answered, but
    the majority of answers are
    incorrect
    Submission does not include
    answers to the questions or the
    QlikView analysis
    50
    Total 100%
Uncategorized
All Rights Reserved, Essaysland.com
Disclaimer: