Healthcare Analytics: Strategy, Architecture, and Implementation


What the client wanted:

Our client was experiencing tremendous business growth. Sales were booming and there was an increased need for fast access to current and accurate information. Our client realized their demands for information could not be supported by the existing reporting approach.  They wanted to invest in a sound data warehouse strategy, development process, and analytical tools that would provide the executive leaders with quick access to well organized summary and detail information.



What SD3 did:

Our objectives were to review the client’s data and reporting implementation and recommend a new enterprise data warehouse (EDW) strategy, development process, architecture, tools, and organization. SD3 would then go forward to build and deploy into production a completely new EDW platform.


We met with business leaders to identify and prioritize a set of information areas that were most important and organized them into a list of strategic roadmap initiatives. Then we gathered anddocumented requirements and established an Agile data warehouse development methodology using Jiraas an Agile project management tool. SD3 designed a multi-tiered data warehouse architecture utilizing data vault and dimensional modeling techniques. We recommended and licensed ERwin as a metadata repository tool and designed datamodels for all of the database layers in the architecture.


SD3 designed and developed all of the logic to extract information from source systems and load into the data vault and dimensional data mart databases. Cognos reports and Tableau queries were developed and made available for direct user access.


The outcome:

Our client feels that their new enterprise data warehouse is a huge success. It provides them with self-service access to information that they never had before. Now they have the capability to perform advanced mathematical modeling including business forecasting and risk analysis. Having access to the summary and detail data is helping the management team drive operational process improvements. Thenew Agile development methodology is being used on the list of strategic roadmap initiatives and the business community is seeing measurable progress as they continue to gain access to more information areas across the organization.


Tools: Data Warehouse Strategy, Data Vault Architecture, Dimensional Modeling, ERwin, MS SSIS, MS SQL Server, Team Foundation Server, Cognos

  • Quick access to accurate information
  • Reduced costs for information access
  • Increase customer satisfaction
  • Cost savings from improved process efficiencies
  • Revenue growth by targeting cross-selling and up-selling opportunities

<< Back

Contact Us

Case Studies

Customized Mobile Application Development

img3_small Bringing together multiple relevant software platforms, SD3 created an app that streamlines workflow assessment in real-time. Team members in the field can communicate smoothly with home office, each one in sync with work orders, updates and more. Read More...

HipaaCat & My Doctor Note Android and iOS Apps

case_studies_img3 A hospital system that relies on communication of critical and highly private patient information needed a safe way to do so electronically. The forward-thinkers at SD3 developed an app enabling chiefs, residents and nurses to securely send and receive images and/or messages. This required creation of a custom camera application to keep images off the “camera roll” for security and yet still gave full control of image details. Read More...

Data Warehouse Telecommunications

img10_small When the regional arm of a large cellular provided needed a massive tech fix, SD3 provided the solution, in the form of a system to monitor performance of cellular towers to troubleshoot every factor imaginable. This data retrieval and storage system not only earned a Corporate Award for Excellence, but ended up being implemented nationwide. Read More...

Website Development Marketing

img13_small SD3 built a customized marketing site that leveraged the client’s need for a heavy web presence. The environmental services company came away with a site that not only pumped the brand, but enabled the company to access regulatory adherence documentation, product lines, customer education and other critical information. Read More...

Healthcare Network Security

img14_small Multiple Network Security and HIPAA Compliance A healthcare company needed to insure that its computers, databases and networks were safe from ... Read More...