{"id":7412,"date":"2019-09-10T13:37:41","date_gmt":"2019-09-10T18:37:41","guid":{"rendered":"https:\/\/www.osfhealthcare.org\/blog\/?p=7412"},"modified":"2022-01-13T21:25:16","modified_gmt":"2022-01-14T03:25:16","slug":"full-financial-picture-helps-drive-mission","status":"publish","type":"post","link":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/","title":{"rendered":"Full financial picture helps drive Mission"},"content":{"rendered":"<p>Like every other business in the world, we have to know and understand the financial performance of all of our facilities within <a href=\"http:\/\/osfhealthcare.org\">OSF HealthCare<\/a>. That means having the ability to view, compare and contrast billing data at every level\u2014from in and outpatient hospital-based care down to the primary care services offered to our communities.<\/p>\n<p>Having this information allows leaders to determine where we need to grow, where we need to scale back and how to fix areas of concern \u2014 all with the goal of ensuring we can continue serving patients with the greatest care and love. As a former <a href=\"http:\/\/osfsaintfrancis.org\">OSF HealthCare Saint Francis Medical Center<\/a> CEO said before, we can\u2019t carry out our Mission without having the dollars to put back into the Ministry.<\/p>\n<p>In the past, analysts evaluated the overall business using hospital-only financial information. To get the full financial picture, our finance teams needed a way to easily view hospital and ambulatory data in one easy-to-access place. This led to the development of the Integrated Financials Model that allows for analyses across the continuum of care.<\/p>\n<h2>Building an Integrated Financials Model<\/h2>\n<p>OSF has carried out hospital cost accounting using various analytics tools for years. However, ambulatory cost accounting is a more recent development \u2014 and this financial information was still being presented in separate areas. In order to provide a more holistic view of market sustainability, analysts had to manually pull those numbers into a spreadsheet model with limited viewing capabilities.<\/p>\n<p>\u201cThe model took a long time to build and would often crash when sent to users,\u201d said Eliza Montgomery, finance senior analyst for Financial Planning and Analysis. \u201cBy the time we would prepare and send out the spreadsheet, the data would be stale.\u201d<\/p>\n<p>Working with Healthcare Analytics, the Integrated Financials Model was developed using a server-based tool that can handle hundreds of millions of rows and processes this type of data in a matter of seconds.<\/p>\n<p>\u201cAll of this data is housed within our home-grown Enterprise Data Warehouse,\u201d said Tim Umdenstock, a senior business intelligence analyst with Healthcare Analytics. \u201cThe model we\u2019ve built changes, normalizes and translates this information into an easy-to-use display.\u201d<\/p>\n<p>The Integrated Financials Model takes data from the hospital and ambulatory tab of a larger dashboard and merges it into a single view where end users can compare financial performance by region, service line, entity, department, physician and payor.<\/p>\n<h2>Improved efficiency of data collection<\/h2>\n<p>Updated daily, the Integrated Financials Model gives users the ability to manipulate data in any way they want, empowering them to understand the different segments of their business and make changes where needed.<\/p>\n<p>\u201cThis has not only freed up time for our team to work on other pressing projects, we\u2019ve been able to improve the integrity of the data and help users understand what the data means,\u201d said Montgomery. \u201cIt\u2019s changed my work from manually placing information in Excel to actually being able to do analysis.\u201d<\/p>\n<p>Having this data in one place gives OSF HealthCare the information it needs to sustain its <a href=\"https:\/\/www.osfhealthcare.org\/about\/mission\/\">Mission<\/a> and expand it to those who need it most.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Like every other business in the world, we have to know and understand the financial performance of all of our facilities within OSF HealthCare. That means having the ability to view, compare and contrast billing data at every level\u2014from in and outpatient hospital-based care down to the primary care services offered to our communities. Having [&hellip;]<\/p>\n","protected":false},"author":53,"featured_media":7416,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[355],"tags":[925,678,640],"coauthors":[684],"class_list":["post-7412","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-innovation","tag-billing-insurance","tag-data","tag-healthcare-analytics"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Full financial picture helps drive Mission<\/title>\n<meta name=\"description\" content=\"Healthcare Analytics, a part of OSF Innovation, developed an Integrated Financials Model to help financial analysts.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Full financial picture helps drive Mission\" \/>\n<meta property=\"og:description\" content=\"Healthcare Analytics, a part of OSF Innovation, developed an Integrated Financials Model to help financial analysts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/\" \/>\n<meta property=\"og:site_name\" content=\"OSF HealthCare Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/osfhealthcare\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-10T18:37:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-14T03:25:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bryan Kaiser\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Full financial picture helps drive Mission\" \/>\n<meta name=\"twitter:description\" content=\"Healthcare Analytics, a part of OSF Innovation, developed an Integrated Financials Model to help financial analysts.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@osfhealthcare\" \/>\n<meta name=\"twitter:site\" content=\"@osfhealthcare\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bryan Kaiser\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/\",\"url\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/\",\"name\":\"Full financial picture helps drive Mission\",\"isPartOf\":{\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg\",\"datePublished\":\"2019-09-10T18:37:41+00:00\",\"dateModified\":\"2022-01-14T03:25:16+00:00\",\"author\":{\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/#\/schema\/person\/4e118e81879cdb8435b55494c583c3e2\"},\"description\":\"Healthcare Analytics, a part of OSF Innovation, developed an Integrated Financials Model to help financial analysts.\",\"breadcrumb\":{\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#primaryimage\",\"url\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg\",\"contentUrl\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Full financial picture helps drive Mission\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/#website\",\"url\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/\",\"name\":\"OSF HealthCare Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/#\/schema\/person\/4e118e81879cdb8435b55494c583c3e2\",\"name\":\"Bryan Kaiser\",\"url\":\"https:\/\/osf-blog.live.imagescape.com\/blog\/author\/bkaiser\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Full financial picture helps drive Mission","description":"Healthcare Analytics, a part of OSF Innovation, developed an Integrated Financials Model to help financial analysts.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/","og_locale":"en_US","og_type":"article","og_title":"Full financial picture helps drive Mission","og_description":"Healthcare Analytics, a part of OSF Innovation, developed an Integrated Financials Model to help financial analysts.","og_url":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/","og_site_name":"OSF HealthCare Blog","article_publisher":"http:\/\/www.facebook.com\/osfhealthcare","article_published_time":"2019-09-10T18:37:41+00:00","article_modified_time":"2022-01-14T03:25:16+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg","type":"image\/jpeg"}],"author":"Bryan Kaiser","twitter_card":"summary_large_image","twitter_title":"Full financial picture helps drive Mission","twitter_description":"Healthcare Analytics, a part of OSF Innovation, developed an Integrated Financials Model to help financial analysts.","twitter_image":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg","twitter_creator":"@osfhealthcare","twitter_site":"@osfhealthcare","twitter_misc":{"Written by":"Bryan Kaiser","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/","url":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/","name":"Full financial picture helps drive Mission","isPartOf":{"@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#primaryimage"},"image":{"@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#primaryimage"},"thumbnailUrl":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg","datePublished":"2019-09-10T18:37:41+00:00","dateModified":"2022-01-14T03:25:16+00:00","author":{"@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/#\/schema\/person\/4e118e81879cdb8435b55494c583c3e2"},"description":"Healthcare Analytics, a part of OSF Innovation, developed an Integrated Financials Model to help financial analysts.","breadcrumb":{"@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#primaryimage","url":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg","contentUrl":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/full-financial-picture-helps-drive-mission\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/osf-blog.live.imagescape.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Full financial picture helps drive Mission"}]},{"@type":"WebSite","@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/#website","url":"https:\/\/osf-blog.live.imagescape.com\/blog\/","name":"OSF HealthCare Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/osf-blog.live.imagescape.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/osf-blog.live.imagescape.com\/blog\/#\/schema\/person\/4e118e81879cdb8435b55494c583c3e2","name":"Bryan Kaiser","url":"https:\/\/osf-blog.live.imagescape.com\/blog\/author\/bkaiser\/"}]}},"modified_by":"Michael Vujovich","featured_image_url":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-content\/uploads\/2019\/09\/shutterstock_367579028.jpg","_links":{"self":[{"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/posts\/7412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/comments?post=7412"}],"version-history":[{"count":3,"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/posts\/7412\/revisions"}],"predecessor-version":[{"id":7418,"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/posts\/7412\/revisions\/7418"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/media\/7416"}],"wp:attachment":[{"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/media?parent=7412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/categories?post=7412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/tags?post=7412"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/osf-blog.live.imagescape.com\/blog\/wp-json\/wp\/v2\/coauthors?post=7412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}