Stream: implementers
Topic: How to do business intelligence using FHIR
Andy Sanchez (Mar 07 2019 at 16:48):
Hi. Someone could tell me what is the best way to do BI using FHIR. That is, in the case of having all the information on an FHIR server, what is recommended to build a data warehouse, including the dimensional modeling, from these data in FHIR structure. If you could give me some suggestions or point me in the rigth direction I’ll be grateful.
Andy Sanchez (Mar 07 2019 at 16:49):
(deleted)
Andy Sanchez (Mar 07 2019 at 16:54):
(deleted)
Lloyd McKenzie (Mar 07 2019 at 17:08):
There's no single solution or best approach. There are a wide variety of ways of organizing FHIR data for persistance and query and what is "best" will depend on your use-cases, what types of technologies you want to use, what your volume and performance needs are, etc. You might find some useful ideas - and get a sense of some of the options - reading through the #storage for FHIR stream.
Andy Sanchez (Mar 07 2019 at 20:31):
Thanks for the response Lloyd. In my case I am working on a project in which there are two SQL databases in Azure, one to concentrate data from several external systems with a bit of preprocessing and another that is dimensionally modeled to facilitate the analysis of the business, which It consumes the data directly from the first database. The entire ETL process is being carried out through Azure Data Factory. Finally, Power BI is used to create different reports according to the needs of the business having as source the second database.
The problem is that now the external systems that had their data in SQL relational databases are now migrating to FHIR servers, which means that the ETL process changes completely as does the structure of our databases. On the other hand, Power BI, which is the data analysis tool that we must use, does not yet have integration with FHIR. I would like to know under these conditions and taking into account that we consider the performance important, which are the edges that are currently being used in these cases. Maybe if you know some references that can help us would be great.
Lloyd McKenzie (Mar 07 2019 at 20:37):
I'd recommend raising this question on the #storage for FHIR stream. Hopefully someone there can provide some insights.
Andy Sanchez (Mar 07 2019 at 20:38):
Ok thanks :+1:
Jean-Christophe Cauvin (Mar 09 2019 at 08:25):
RonFHIR is a package for accessing a FHIR server. And R can be used in PowerBI (https://docs.microsoft.com/fr-fr/power-bi/desktop-r-in-query-editor). It can be a solution.
Last updated: Apr 12 2022 at 19:14 UTC
