institutional data users group - it communities · bureau of oral and health delivery systems ......

INSTITUTIONAL DATA USERS GROUP

April MeetingApril 13th 2016

Institutional Data Users Group

IDUG AgendaInstitutional Data Users Group

Facilities Management Data OverviewAlex Junk, Senior Systems Administrator

College of Public Health, Iowa Health Fact BookJacob Oleson, Associate Professor,

College of Public Health

Facilities Management Data Overview


Facilities Management Data Overview

Steve Sawyer – Associate Director, Information TechnologyAlex Junk – Senior Systems Administrator


Facilities Management Systems

Systems:1. AiM – Facilities and maintenance work order system2. Build UI – Capital projects application3. SIMS – Space Inventory Management System4. PI – Utilities data collection5. GIS – Exterior and Interior Mapping6. BAS – Building Automation Systems7. Several websites and applications

a. Build UI contractor applicationb. Intranet and Internet sitesc. Overtime equalizationd. Monthly and Bi-Weekly payrolle. Campus Master Planf. Many smaller applications


Facilities Management System Inputs / Outputs

Inputs

DWPROD AiM and BUI (HR, Vendor, and PO data)Aerial Surveys ArcGISUtility Meter Data PIBuilding Info and Floor Plans SIMS

Outputs

AiM and BUI GL DWPROD - Monthly Project and Work Order billing dataAiM, Build UI, SIMS, Utility Billing FMDM (via SSIS)FMDM FM SSAS Tabular CubesGIS Data UI Business Office BOR, ITS (Enterprise Infrastructure, Web Services)SIMS UI Buisness Office BOR, MAUI, UIHC, every college


Facilities Management BI Objectives

- BI solutions to replace currently manual monthly reports- BI solutions to enable new reporting from our CMMS- Excel pivot tables for Power Users (Accountants)- Rollout of DataZen (SQL Server 2016 Mobile Reports) to

enhance information accessibility- Predictive Analysis

- Budget analysis- Space usage and planning- Energy usage

- Utility billing automation


Facilities Management BI contacts

Team & Contact Information

- Steve Sawyer – [email protected] Associate Director, IT

- Alex Junk – [email protected] Senior Systems Administrator

mailto:[email protected]


CPH Iowa Health Fact BookInstitutional Data Users Group

College of Public Health, Iowa Health Fact Book

Jacob OlesonAssociate Professor, Director, Center for Public

Health Statistics

CPH Iowa Health Fact Book

OVERVIEW What is the Iowa Health Fact Book? History Data Collection Compiling the Data Presentation of Data


WHAT IS THE IOWA HEALTH FACT BOOK? To provide public health and health care providers,

planners and policy makers with data for assessment of health and decisions for the future

To provide current population-based data To provide data at the county level and over time We do not seek to provide any analyses, discussion,

or conclusions regarding the data



HISTORY 1997 First Fact Book produced as a collaborative effort

between the University of Iowa and Iowa Department of Public Health. New books released in the summer of odd years

1999 College of Public Health and Center for Public Health Statistics

2001 CD version created 2015 State Health Profile of Iowa 2015/2016 Launch of New Website



Sample page from 2013Iowa Health Fact Book:Lung Cancer Incidence



Sample page from2015 State HealthProfile:Lung Cancer

Incidence



CHAPTERS Demographics Social Determinants of Health Health Behaviors Prenatal and Infant Health Infectious Diseases Cancer Incidence and Mortality Injury Mortality Youth Injury Mortality Other Mortality Health Care Providers Health Care Facilities Environmental Health Indicators



DATA SOURCES United States Census Bureau

American Community Survey (csv) Small Area Income and Poverty Estimates (csv)

Surveillance, Epidemiology, and End Results (SEER) Program United States Department of Labor, Bureau of Labor Statistics Agency for Healthcare Research and Quality (web) United States Department of Health and Human Services

(web) United States Department of Agriculture, Economic Research

Service (web)



DATA SOURCES (continued) Centers for Disease Control and Prevention

National Center for Health Statistics (csv) United States Department of Health and Human Services National Center for HIV, STD, and TB Prevention (web) Behavioral Risk Factor Surveillance System (txt) CDC WONDER Online Database (web)



DATA SOURCES (continued) Iowa Department of Public Health

Public Health Web Tracking Portal (txt) Bureau of Planning Services (csv) Bureau of Substance Abuse (csv) Bureau of Health Statistics (csv) Bureau of HIV, STD, and Hepatitis (csv) Bureau of Emergency and Trauma Services (pdf) Bureau of Environmental and Health Services (csv)



DATA SOURCES (continued) Iowa Department of Public Health

Bureau of Genetics and Infant Screening (csv) Center for Acute Disease Epidemiology Bureau of Substance Abuse (csv) Iowa Youth Survey (txt) Bureau of Oral and Health Delivery Systems Women, Infants, & Children Nutrition Program (csv)



DATA SOURCES (continued) Iowa Department of Inspections and Appeals (txt) Iowa Department of Education (txt) Iowa Department of Health Services (csv) Iowa Consortium for Substance Abuse Research and

Evaluation (txt) University of Iowa College of Medicine

Office of Statewide Clinical Education Programs (pdf) University of Iowa College of Public Health

State Health Registry of Iowa (csv) Injury Prevention Research Center (csv) Iowa Registry for Congenital and Inherited Disorders (txt)



COMPILING THE DATA SAS

Compute totals, ranks, crude rates, and age-adjusted rates

R produce graphics

Python read numbers sent in PDF documents

SQL Database


Old Website Entire book as a PDF Each chapter as a separate PDF CD only contains PDFs

New Website iowahealthfactbook.org County page and Aspect page Ability to subset quickly Downloadable and Printable Available on a tablet and smartphone

http://www.public-health.uiowa.edu/factbook/


Find the following: Number of heart attacks in Johnson County compared

to Scott County and Washington County Show overall population change over the past decade,

and find biggest increases and biggest decreases How does Dallas County rank for every cancer

recorded in the Iowa Health Fact Book? How do the four congressional districts compare for

deaths due to fire arms?



Participants in the Iowa Health Fact Book Development Project

College of Public Health- Jacob Oleson, Associate Professor, Biostatistics (Content Expert)- Patrick Riepe, App. Developer (Website Development)- Jacob Clark, Grad. Research Assistant (Data Collecting)

ITS Enterprise Services Application Development- Steve Bowers, Sr. App. Developer (General Project Lead)- Steve Tomblin, Sr. App. Developer (Application, UX Lead)- Cale Bierman, Application Programmer/Analyst (Application, UX)- Ted Fitzgerald, Application Developer (Data Conversions Lead)- Anitha Prudhvi, Application Developer (Data Conversions)



Background: ITS Enterprise Services Application Development

- Within ITS, but not the group that developed MAUI (that’s AIS)- A “catch-all” development group of around 20 developers• Receives projects from all over campus• Projects aimed at research, instruction, administrative too• As a catch-all group, we use a wider variety of tools

Applications: Java, .Net., PHP subgroupsDatabases: MS SQL Server, MySQL, FileMaker, MS AccessRich Apps: Angular, Digital Media, Animations, Educ. GamesIntegration, Reporting: SSIS, SSRS

• Projects are generally “cost-recovery” (i.e., we charge)


Informatics Show Case

BI@UIApril 18, 2016 9am-12pmUCC 2520D Seminar Room

ITS Business Intelligence Shared Service CenterBrenda Ulin, ITS-Administrative Information SystemsDawn Moore, ITS-Administrative Information Systems9-10

Campus Data PortalEd Hill, ITS Administrative Information Systems10-11

UI Predictive Modeling Data for Freshman Student RecruitmentMichael Hovland, Director of Enrollment Management Data AnalyticsGrant Brown, Asst Professor, Biostatistics, College of Public HealthKnute Carter, Assoc Research Scientist, Center for Public Health Statistics, College of Public Health11-12

Wednesday, May 11th 2016UCC2520-D8:30 – 10:00

For IDUG Executive Committee and Session Feedback or Ideas

[email protected] IDUG Peer to Peer Discussion, Collaboration and Sharing

[email protected] Website

http://itcommunities.uiowa.edu/content/institutional-data-users-groupFollow us on Twitter @UIowaIDUG

IDUG Next Session




http://itcommunities.uiowa.edu/content/institutional-data-users-group

institutional data users group - it communities · bureau of oral and health delivery systems ......

Documents