{"id":7738,"date":"2018-11-21T23:34:55","date_gmt":"2018-11-21T23:34:55","guid":{"rendered":"http:\/\/orionhealth.weareiceberg.co\/?p=685"},"modified":"2024-06-11T01:51:18","modified_gmt":"2024-06-11T01:51:18","slug":"easy-data-access-for-reporting-and-analytics","status":"publish","type":"post","link":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/","title":{"rendered":"Easy data access for reporting and analytics"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Wouldn\u2019t it be great to extend your health organisation&#8217;s integration engine with\u00a0<a href=\"https:\/\/orionhealth.com\/blog\/extend-your-integration-engine-with-secure-cloud-storage\/\">Amazon Web Services (AWS) secure cloud storage<\/a>, and not have to worry about how you would get access to the data in it?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Message integration &#8211; such as HL7 messages &#8211; has been and continues to be a bedrock for healthcare data integration, but modern healthcare organisations increasingly require data to be stored and combined for a large range of use cases, for example:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2022&nbsp;<strong>Research and Data Science<\/strong>&nbsp;&#8211; data exploration, dataset extraction, machine learning<br>\u2022&nbsp;<strong>Analytics<\/strong>&nbsp;&#8211; measures, cohort identification, operational metrics<br>\u2022&nbsp;<strong>Reporting<\/strong>&nbsp;&#8211; operational reporting<br>\u2022&nbsp;<strong>Monitoring<\/strong>&nbsp;&#8211; quality, concept drift, usage, real-time dashboards<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Software vendors often insist you use their proprietary interfaces to access information in your own platform. We don\u2019t believe that is a good idea; we believe in being as open as possible by using industry standard protocols and APIs in\u00a0Amadeus CORE. The most obvious demonstration of this is the ANSI SQL interface we provide.<br><br>The ANSI SQL interface enables you to use an industry standard query language, one you and your team already know, to build reports, perform analytics using 3rd party tools or feed your training pipelines for machine learning tasks. There is support for tools such as Tableau, Microsoft Excel, Jupyter Notebooks, Microsoft Power BI and other industry tools.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Our ANSI SQL capability is backed by the state-of-the-art big data processing technologies, so you know it is up to the task no matter the \u2018V\u2019, i.e. Volume, Variety or Velocity of your data environment.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Leveraging and building data-driven capabilities is often centralised in &#8220;Data Teams&#8221; that specialise in all things data, but innovation can come from anywhere; Amadeus CORE can empower users from different parts of the organisation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Amadeus CORE gives you an ANSI SQL option to power your analytics, machine learning and BI reporting to your data. Now that you know, you can implement a scalable, secure and open system for your next data platform, what impossible data problem will you like to cross of that too hard list?<\/p>\n\n\n\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/orionhealth.com\/contact\/\">Contact us<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Wouldn\u2019t it be great to extend your health organisation&#8217;s integration engine with\u00a0Amazon Web Services (AWS) secure cloud storage, and not have to worry about how you would get access to the data in it? Message integration &#8211; such as HL7 messages &#8211; has been and continues to be a bedrock for healthcare data integration, but [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":15617,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[1],"tags":[],"region":[23],"class_list":["post-7738","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","region-global"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Easy data access for reporting and analytics - Orion Health<\/title>\n<meta name=\"description\" content=\"Learn how Amadeus CORE gives you an ANSI SQL option to power your analytics, machine learning and BI reporting to your data in this blog post.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Easy data access for reporting and analytics - Orion Health\" \/>\n<meta property=\"og:description\" content=\"Learn how Amadeus CORE gives you an ANSI SQL option to power your analytics, machine learning and BI reporting to your data in this blog post.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"Orion Health\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/orionhealth\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-21T23:34:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-11T01:51:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/orionhealth.com\/wp-content\/uploads\/Easy-data-access-for-reporting-and-analytics-min.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1180\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"MarkOps\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@OrionHealth\" \/>\n<meta name=\"twitter:site\" content=\"@OrionHealth\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"MarkOps\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/\"},\"author\":{\"name\":\"MarkOps\",\"@id\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/#\\\/schema\\\/person\\\/689ebe5a4696ea74129b3d0ec636d756\"},\"headline\":\"Easy data access for reporting and analytics\",\"datePublished\":\"2018-11-21T23:34:55+00:00\",\"dateModified\":\"2024-06-11T01:51:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/\"},\"wordCount\":360,\"publisher\":{\"@id\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/orionhealth.com\\\/wp-content\\\/uploads\\\/Easy-data-access-for-reporting-and-analytics-min.jpg\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"global\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/\",\"url\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/\",\"name\":\"Easy data access for reporting and analytics - Orion Health\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/orionhealth.com\\\/wp-content\\\/uploads\\\/Easy-data-access-for-reporting-and-analytics-min.jpg\",\"datePublished\":\"2018-11-21T23:34:55+00:00\",\"dateModified\":\"2024-06-11T01:51:18+00:00\",\"description\":\"Learn how Amadeus CORE gives you an ANSI SQL option to power your analytics, machine learning and BI reporting to your data in this blog post.\",\"inLanguage\":\"global\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"global\",\"@id\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/blog\\\/easy-data-access-for-reporting-and-analytics\\\/#primaryimage\",\"url\":\"https:\\\/\\\/orionhealth.com\\\/wp-content\\\/uploads\\\/Easy-data-access-for-reporting-and-analytics-min.jpg\",\"contentUrl\":\"https:\\\/\\\/orionhealth.com\\\/wp-content\\\/uploads\\\/Easy-data-access-for-reporting-and-analytics-min.jpg\",\"width\":1180,\"height\":720},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/#website\",\"url\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/\",\"name\":\"Orion Health\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"global\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/#organization\",\"name\":\"Orion Health\",\"url\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"global\",\"@id\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/orionhealth.com\\\/wp-content\\\/uploads\\\/Orion-Health-Logo.png\",\"contentUrl\":\"https:\\\/\\\/orionhealth.com\\\/wp-content\\\/uploads\\\/Orion-Health-Logo.png\",\"width\":260,\"height\":96,\"caption\":\"Orion Health\"},\"image\":{\"@id\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/orionhealth\\\/\",\"https:\\\/\\\/x.com\\\/OrionHealth\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/orion-health\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/orionhealth.com\\\/uk\\\/#\\\/schema\\\/person\\\/689ebe5a4696ea74129b3d0ec636d756\",\"name\":\"MarkOps\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"global\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"caption\":\"MarkOps\"},\"url\":\"https:\\\/\\\/orionhealth.com\\\/global\\\/author\\\/markops\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Easy data access for reporting and analytics - Orion Health","description":"Learn how Amadeus CORE gives you an ANSI SQL option to power your analytics, machine learning and BI reporting to your data in this blog post.","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:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/","og_locale":"en_US","og_type":"article","og_title":"Easy data access for reporting and analytics - Orion Health","og_description":"Learn how Amadeus CORE gives you an ANSI SQL option to power your analytics, machine learning and BI reporting to your data in this blog post.","og_url":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/","og_site_name":"Orion Health","article_publisher":"https:\/\/www.facebook.com\/orionhealth\/","article_published_time":"2018-11-21T23:34:55+00:00","article_modified_time":"2024-06-11T01:51:18+00:00","og_image":[{"width":1180,"height":720,"url":"https:\/\/orionhealth.com\/wp-content\/uploads\/Easy-data-access-for-reporting-and-analytics-min.jpg","type":"image\/jpeg"}],"author":"MarkOps","twitter_card":"summary_large_image","twitter_creator":"@OrionHealth","twitter_site":"@OrionHealth","twitter_misc":{"Written by":"MarkOps","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/#article","isPartOf":{"@id":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/"},"author":{"name":"MarkOps","@id":"https:\/\/orionhealth.com\/uk\/#\/schema\/person\/689ebe5a4696ea74129b3d0ec636d756"},"headline":"Easy data access for reporting and analytics","datePublished":"2018-11-21T23:34:55+00:00","dateModified":"2024-06-11T01:51:18+00:00","mainEntityOfPage":{"@id":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/"},"wordCount":360,"publisher":{"@id":"https:\/\/orionhealth.com\/uk\/#organization"},"image":{"@id":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/orionhealth.com\/wp-content\/uploads\/Easy-data-access-for-reporting-and-analytics-min.jpg","articleSection":["Blog"],"inLanguage":"global"},{"@type":"WebPage","@id":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/","url":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/","name":"Easy data access for reporting and analytics - Orion Health","isPartOf":{"@id":"https:\/\/orionhealth.com\/uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/#primaryimage"},"image":{"@id":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/orionhealth.com\/wp-content\/uploads\/Easy-data-access-for-reporting-and-analytics-min.jpg","datePublished":"2018-11-21T23:34:55+00:00","dateModified":"2024-06-11T01:51:18+00:00","description":"Learn how Amadeus CORE gives you an ANSI SQL option to power your analytics, machine learning and BI reporting to your data in this blog post.","inLanguage":"global","potentialAction":[{"@type":"ReadAction","target":["https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"global","@id":"https:\/\/orionhealth.com\/global\/blog\/easy-data-access-for-reporting-and-analytics\/#primaryimage","url":"https:\/\/orionhealth.com\/wp-content\/uploads\/Easy-data-access-for-reporting-and-analytics-min.jpg","contentUrl":"https:\/\/orionhealth.com\/wp-content\/uploads\/Easy-data-access-for-reporting-and-analytics-min.jpg","width":1180,"height":720},{"@type":"WebSite","@id":"https:\/\/orionhealth.com\/uk\/#website","url":"https:\/\/orionhealth.com\/uk\/","name":"Orion Health","description":"","publisher":{"@id":"https:\/\/orionhealth.com\/uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/orionhealth.com\/uk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"global"},{"@type":"Organization","@id":"https:\/\/orionhealth.com\/uk\/#organization","name":"Orion Health","url":"https:\/\/orionhealth.com\/uk\/","logo":{"@type":"ImageObject","inLanguage":"global","@id":"https:\/\/orionhealth.com\/uk\/#\/schema\/logo\/image\/","url":"https:\/\/orionhealth.com\/wp-content\/uploads\/Orion-Health-Logo.png","contentUrl":"https:\/\/orionhealth.com\/wp-content\/uploads\/Orion-Health-Logo.png","width":260,"height":96,"caption":"Orion Health"},"image":{"@id":"https:\/\/orionhealth.com\/uk\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/orionhealth\/","https:\/\/x.com\/OrionHealth","https:\/\/www.linkedin.com\/company\/orion-health"]},{"@type":"Person","@id":"https:\/\/orionhealth.com\/uk\/#\/schema\/person\/689ebe5a4696ea74129b3d0ec636d756","name":"MarkOps","image":{"@type":"ImageObject","inLanguage":"global","@id":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"MarkOps"},"url":"https:\/\/orionhealth.com\/global\/author\/markops\/"}]}},"_links":{"self":[{"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/posts\/7738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/comments?post=7738"}],"version-history":[{"count":0,"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/posts\/7738\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/media\/15617"}],"wp:attachment":[{"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/media?parent=7738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/categories?post=7738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/tags?post=7738"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/orionhealth.com\/global\/wp-json\/wp\/v2\/region?post=7738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}