1 / 25

W ebinar 1 Nursing Databases 101: From Inception to Analysis

Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series. W ebinar 1 Nursing Databases 101: From Inception to Analysis. Andrea Baumann RN, PhD Jaspreet Ahuja , MSc. Nursing Health Services Research Unit (NHSRU) McMaster University. Date: Thursday October 18, 2012

nina-york
Download Presentation

W ebinar 1 Nursing Databases 101: From Inception to Analysis

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Webinar 1Nursing Databases 101:From Inception to Analysis Andrea Baumann RN, PhD JaspreetAhuja, MSc. Nursing Health Services Research Unit (NHSRU) McMaster University Date: Thursday October 18, 2012 Time: Noon- 1:00PM (EST)

  2. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Introduction • Target audience • Overview of webinar series • Types of data • Discussion of a database • Example from the Pan American Health Organization

  3. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Types of Data Primary data - collected to answer a specific research question. Secondary data– collected by some other user. Administrative data –secondary data collected for non-research purposes but may used to answer specific research questions. Source:Wunsch, H., Harrison, D., Rowan, K. (2005). Health Services Research in critical care using administrative data. Journal of Critical Care, 20: 264-269.

  4. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Primary Databases • Result from individual research projects • Include many variables and/or themes • Can be standardized for use by other investigators to ask different questions

  5. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Secondary Databases • Housed at the provincial, national and international level • Include data from a variety of administrative databases • Agreement on general indicators

  6. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Indicators “…standardized measures by which to compare health status and health system performance and characteristics among different jurisdictions in Canada…through quality comparative information.” Source: Canadian Institute for Health Information (CIHI). (2012). Health Indicators Interactive Tool. Retrieved: http://www.cihi.ca/CIHI-ext-portal/internet/EN/SubTheme/health+system+performance/indicators/cihi010653

  7. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Health Administrative Databases • Housed in healthcare organizations • Include data such as human resources, finances, payroll, illness and long term disability • Stored in a “data warehouse” • Uploaded to the Ministry of Health and Long-Term Care as part of an accountability agreement (varies from province to province)

  8. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Challenges in Database Development • Standardizing data • Compatible versions of software • De-identifying personal information • Access and transferability Source: Data, Data Everywhere: Access and Accountability? (2011). ed. C. M. Flood. Montreal and Kingston: Queen’s Policy Study Series.

  9. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Provincial Databases • Institute for Clinical Evaluative Sciences (ICES)* • Health services data; Population and demographic data; Disease cohort/registry data; Care provider, facility, geography, coding and other data • Ministry of Health and Long-Term Care • Health Professions Database; Management Information Systems (MIS) • College of Nurses of Ontario • Provincial nursing regulatory database *Source: Institute for Clinical Evaluative Sciences (ICES). 2012. Retrieved from: http://www.ices.on.ca/webpage.cfm?site_id=1&org_id=26&morg_id=0&gsec_id=5314&item_id=5322

  10. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series National Databases • Canadian Institute for Health Information • Statistics Canada • Canadian Association of Schools of Nursing and Canadian Nurses Association

  11. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series International Databases • Organization for Economic Development and Development (OECD) • International Labour Organization (ILO) • World Health Organization (WHO) • Pan American Health Organization (PAHO)

  12. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series PAHO • What does PAHO have in HHR? • How do they develop databases ? • What does PAHO want to create ? Two examples: • An international database developed using national databases • The creation of a schools of nursing directory database Source: Pan American Health Organization/World Health Organization (2012). Retrieved from: http://new.paho.org/hq/index.php?option=com_content&view=article&id=91&Itemid=220&lang=en

  13. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series PAHO- Example 1 Migration of Nurses from Latin America and the Caribbean countries to Canada: - Nursing education acquired from source country - Focus on numbers of those practicing in Canada - Using existing data/literature

  14. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Using CIHI Database • CIHI Nursing Database • Data on 3 regulated nursing professions in Canada: • Registered Nurses (RNs) • Licensed Practical Nurses (LPNs) • Registered Psychiatric Nurses (RPNs) • What does this database contain? Source: Canadian Institute for Health Information (CIHI). (2012). Spending and Health Workforce. http://www.cihi.ca/CIHI-ext-portal/internet/EN/TabbedContent/spending+and+health+workforce/workforce/nurses/cihi010673

  15. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Data Methodology • How is this data collected? • Methodology • Primary or Secondary ? • Data Dictionary • Challenge: Details of data collected were not necessarily available in reports • “Canadian” vs ”Foreign” Source: Canadian Institute for Health Information (CIHI). (2012). Spending and Health Workforce. http://www.cihi.ca/CIHI-ext-portal/internet/EN/TabbedContent/spending+and+health+workforce/workforce/nurses/cihi010673

  16. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series What to do ? • Coping with challenges and making decisions • 2 options • Data Request from CIHI • Use available data till 2006 • Consider time vs. how recent is the data ?

  17. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series ILO Report: Canadian Context • ILO – International Labor Organization • Report on Mobility of Health Professionals • Compiles CIHI data to demonstrate trends and patterns in migration • Primary or Secondary data ? Source: Emmott, M., Pittman, M. (2012). Canada Mobility of Health Professionals. Public Health Institute.

  18. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series PAHO Example 2 2). Schools of Nursing Directory -primary data collection • Questionnaire • Identification • Contact Information • Undergraduate and/or Graduate Program • Scientific Journal • Research Groups

  19. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Challenges & Limitations • Accuracy • Up to date data • Dependent on time availability • Cost

  20. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Challenges & Limitations • Data indicators; no common agreement • Among provinces • Even bigger challenge when comparing project comparing countries • Terms: RPN’s, LPNs & RNs are not consistent • Need for a common nursing data dictionary ?

  21. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Main Messages • Different types of data • Development of provincial and national databases are on-going • Need for data is increasing • Many challenges including a common understanding

  22. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Questions?

  23. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Upcoming Webinar Sessions Webinar 2: How to Access and Use Secondary Databases (Nov 19, 2012) Webinar 3: Collecting and Storing Your Data (Dec 12, 2012) Webinar 4: Development of a New Graduate Nurse Employment Database (Jan 21, 2013) Webinar 5: Applications and Analysis of a Secondary Database (Feb 20, 2013) Webinar 6: Understanding How to Work with HOBIC (March 2013) Webinar 7: Development of a Longitudinal Qualitative Database (March 2013)

  24. Leveraging Data to Make Better Decisions - An Overview of Databases Webinar Series Contact Information Andrea Baumann, PhD Scientific Director Nursing Health Services Research Unit McMaster University Michael DeGroote Centre for Learning MDCL 3500 (905) 525-9140 ext. 22581 baumanna@mcmaster.ca

More Related