Our team works with the business intelligence and IT team at a large hospital helping them prepare data coming from multiple source data systems, Raiser's Edge, creating data architecture and schema for the data warehouse for business intelligence usage purpose. The data was transformed using SSIS and Microsoft SQL studios and these large transactions databases were translated into presentation and summary tables. That information is then used to put into the PowerBI cloud service. Our team had a data science, a data architecture, and a project manager working directly with their head of it and the chief data officer. We also were audited by one of the big four companies.