Natalie Denny | BI Analyst

As a Business Intelligence Analyst, I have developed analytical data solutions supporting hospital leaders and clinical managers using PowerBI, SAP Business Objects, T-SQL stored procedures, and Epic Cogito tools.

Certifications:

Microsoft Certified: Power BI Data Analyst Associate
Epic Cogito Tools
Epic Caboodle Data Model
Epic Clarity Data Model
Epic Clinical Data Model

The Domains/Subjects reported on include:

Specialty Medical Services

Inpatient Nursing

Surgical and Procedural

Care Management

Trauma Program

Hospital at Home

Transfer Center

Health Information Management

Health System-wide reporting

Chronic Ventilator Dashboard/Exploratory Tool: This dashboard was created for a Quality Improvement Project within the Pulmonary and Critical Care division. This tool allows them to explore a difficult patient population across many dimensions. Including a Drill Through to understand each patient's experience.
Technology Used: PowerBI, DAX, T-SQL, SSMS

Chronic Ventilator Patient Drill Through: In an effort to help the Quality Improvement team, they can drill through from a scatter plot to see details for a patient. The graph was created based on many different discretely recorded data points and allows the user to see them in a visual form that is not available in the Electronic Health Record application.
Technology Used: PowerBI, DAX, T-SQL, SSMS

Pulmonary Consult Service: The purpose of the Pulmonary Consult Service dashboard was to help this group of physicians understand the volume of work they are doing. This helped them in staffing and resource planning.
Technology Used: PowerBI, DAX, T-SQL, SSMS

Surgical Growth Dashboard: The Purpose of this dashboard is to monitor the surgical departments progress to budget targets, surgical cancelations, block utilization, and surgical referrals.
Technology Used: PowerBI, DAX, T-SQL, SSMS

Cancer Related Activities: The purpose of the Cancer Related Activity page is to track progress toward a growth target.
Technology Used: PowerBI, DAX, T-SQL, SSMS

Sample Budget Graph: This PowerBI graph is utilized by Perioperative leadership to track progress to budget.

Technology: PowerBI, DAX, T-SQL, SSMS

Inpatient Nursing: This Health System-wide report was built to monitor progress toward the adoption of a documentation workflow.

Technology: SAP Business Objects, T-SQL

Process Improvement Monitoring: Sample of part of a large system-wide report using statistics (mean absolute error and mean absolute percent error) to access effectiveness of a process improvement.

Technology: SAP Business Objects, T-SQL

SAP Business Objects - Transitional Care.jpg

Program Impacts: This report was developed to assess programs at General Hospital to connect patients with a variety of health and social programs. The data is used by the program to report to outside agencies as well as used to support grants.

Technology: SAP Business Objects, T-SQL

As a Business Intelligence Analyst, I have developed analytical data solutions supporting hospital leaders and clinical managers using PowerBI, SAP Business Objects, T-SQL stored procedures, and Epic Cogito tools. Certifications:

The Domains/Subjects reported on include:

As a Business Intelligence Analyst, I have developed analytical data solutions supporting hospital leaders and clinical managers using PowerBI, SAP Business Objects, T-SQL stored procedures, and Epic Cogito tools.

Certifications: