Following my previous blog post on how to add a new Dimension to a Data Sync task, this post looks at how to add a Fact and perform a lookup on dimensions while loading the target fact table in a data warehouse using Data Sync. To refer to the blog post on adding a Dimension […]
Posts Tagged ‘data warehouse’
Oracle BI Data Sync: How to Add a New Dimension
In this and the following post, I will cover the steps entailed in adding dimension and fact tasks in Oracle Data Sync. The latest releases of Data Sync included a few important features such as performing look-ups during an ETL job. So I intend to cover these best practices when adding new dimension and fact […]
Why CU Anschutz Medical Campus Migrated to Google Cloud
Our healthcare team has been working with the University of Colorado over the past couple of years to overcome critical data challenges in healthcare… and the results are exciting. In this blog post, I’ll share how the academic medical center was able to improve security, reduce maintenance, and increase efficiency in support of the university’s […]
5 Fun Facts about OHDSI’s Healthcare Data Quest
What comes to mind when you hear the word “Odyssey?” Did you picture a journey filled with international discovery? Did you associate images of a quest filled with notable experiences? Or, did you think of OHDSI (pronounced “Odyssey”), the “multi-stakeholder, interdisciplinary collaborative that is striving to bring out the value of observational health data through […]
Empower Business Users with Oracle Data Visualization [Webinar]
With Oracle Data Visualization Cloud Service, your business users can perform self-service analytics, spot patterns, trends, correlations, and construct visual data stories for greater insight into how your product, service, or organization is performing. In this webinar, you will learn how easily users can explore their data in new and different ways through stunning visualizations […]
5 Reasons to Consider Informatica Lifecycle Management (ILM)
I recently implemented an Informatica Lifecycle Management (ILM) project at a national auto financing company and I would like to share some details about what I learned about ILM and the benefits my client received. ILM is a mature and robust data archiving tool used by many organizations to manage and archive large sets of […]
How to Load Late Arriving Facts in HCPDM
What are Late Arriving Facts? In data warehouses, dimensions are processed first and the facts are loaded later, with the assumption that all required dimension data is already available in the system and a Parent fact is already available before a child fact. But, this scenario may not always be the case because the nature […]
Data Lakes vs Data Warehouses in Healthcare
In a recent post, Perficient’s Arvind Murali explained how the rise of Big Data and data lake technology is not an indication that traditional data warehousing is obsolete. There is a place for both solutions, since they address different challenges, and plenty of opportunities for integration as well. According to Gartner, there is a market […]
Is Data Warehousing Dead?
In my recent interactions with IT practitioners and leaders either on the software vendor side or on the business side, a common question keeps coming up. With the rise of Big Data, are data warehouse initiatives dead? My answer to them is a resounding NO. To clear this notion, let us discuss the commonalities which […]
SQL, NoSQL, and NewSQL
Traditional SQL databases and data warehouses have been around for decades and have been doing really well. However, Big Data NoSQL changed the game with big returns for big investments. Concepts like Edge Analytics have been game changers “uberizing” foundational changes in business models. I recently attended a conference hosted by Snowflake, a data warehouse […]
Northwestern Medicine Uses Epic to Deliver Value-Based Care
Recently, Kate Tuttle, my colleague and healthcare marketing guru, wrote a post over on Perficient’s Healthcare Industry Trends blog, describing the shift from a fee-for-service based model to a value-based care model and the subsequent need for a 360-degree patient view. Many healthcare organizations are facing challenges around transforming data into meaningful information – information […]
Pre-Packaged Analytics Applications Measure What Matters
My years of working with transactional systems helps me really appreciate the age old question of “how to get data out?” My curiosity about using data to gain actionable business insights started with the first computer program I ever developed. It was a natural progression of my problem-solving skills. I was involved with building transformational […]