Data structures and relationships

Data Warehouse for Health Care Organization

Submitted by bentownsend on
This article is about the creation and maintenance of a data warehouse for a healthcare organization. The process includes surveying the different departments for data inventory and reporting needs, integrating data from different sources, transforming data, building a master people index, integrating external APIs to enhance data, and performing analytics and building dashboards to explore the data. Additionally, the article covers the technologies and tools used such as Microsoft SQL Server, Python, Power BI and the APIs such as Twilio's Phone number validation and formatting API, and Geocodio. It also discusses data governance, security, and access control measures that were implemented to ensure the data is accurate, reliable, and secure. The article concludes with a discussion about future plans to explore the use of advanced analytics tools and techniques to perform analysis more effectively.