Category Archives: EDW

The Northwestern Medical Enterprise Data Warehouse (NMEDW) is a Northwestern University Clinical and Translational Sciences Institute (NUCATS) initiative funded jointly by the Northwestern University Feinberg School of Medicine (FSM), Northwestern Medical Faculty Foundation (NMFF), and Northwestern Memorial Hospital (NMH). Its mission is to create a single, comprehensive, and integrated repository of all medical data sources on the campus to facilitate operational, patient care, and research reporting. The EDW has been developed completely in-house, with no consulting fees.

TaskMaster

Posted on August 11, 2011 by Garima Sharma

TaskMaster is a work flow management application that provides a central source for tracking all work involving the EDW, including data requests, account requests and ETL development. It integrates with other EDW tools to provide a cohesive approach to the … Continue reading →

MyCohorts

Posted on August 11, 2011 by Garima Sharma

MyCohorts is a framework for tracking a group of patients over time. The cohort may be static (created from a list) or dynamic (created from a query) and refreshed at regular intervals. This framework provides for secure access, auditing and … Continue reading →

Metadata Browser

Posted on August 11, 2011 by Garima Sharma

The Metadata Browser is a group of tables and web application with custom functionality for managing changing schemas, tables and columns, bulk editing and searching. It allows the user to navigate through the data structure of the EDW and view … Continue reading →

Report Writer

Posted on August 11, 2011 by Garima Sharma

Report Writer is an application developed to kick-start the report creation process. It accepts SQL and generates an SSRS .rdl file or full .sln file that is built off an existing template that adheres to the practices and standards of … Continue reading →

Report Deployer

Posted on August 11, 2011 by Garima Sharma

Report Deployer provides a framework that allows a user to submit a report developed in SSIS for approval before it’s deployed in production. The Deployer checks that the report meets defined criteria, best practices and standards, and deploys the validated … Continue reading →

EDW Robot

Posted on August 11, 2011 by Garima Sharma

The EDW Robot is a real-time email parsing service. It uses regular expressions to route messages based on sender, subject and content. The Robot can interact with other EDW applications, such as TaskMaster, MyCohorts and the Metadata Browser. By allowing … Continue reading →

ETL Assistant

Posted on August 11, 2011 by Garima Sharma

The next generation of ETL Writer embeds all ETL logic into a single package and makes ETL jobs table driven. ETL Assistant is powered by CozyRoc’s custom component and effectively reduces the effort to add a table into the EDW … Continue reading →

ETL Writer

Posted on August 11, 2011 by Garima Sharma

The EDW team at Northwestern has automated the generation of SQL Server Integration Services (SSIS) packages through code. The application embeds EDW best practices and is very useful in minimizing package creation time.

Powerform Data Mart Generator

Posted on August 10, 2011 by Garima Sharma

Data Entry forms in Cerner are called PowerForms® and are widely used for recording clinical information. This data is stored in an Entity-Attribute-Value(EAV) format. At Northwestern, popular forms are pivoted into individual data marts. The EDW team has minimized the … Continue reading →

Aggregating Mulitple Rows of Text

Posted on August 10, 2011 by Garima Sharma

This component is used for aggregating mulitple rows of text columns inside an SSIS component. It allows you define keys, which act as a ‘Group By’ clause and concatenates rows in the data flow with identical keys. This SSIS component … Continue reading →