Cogito Analytics Monthly

Make the switch to the new CustomEpicCubes | The Analytics Catalog Is Now Your Reporting Headquarters |Document Search reports

Get More From Cogito

February 9, 2023

Breaking News

Make the switch to the new CustomEpicCubes now

Please switch to the new CustomEpicCube as soon as possible. The current database, “EpicCubes,” only refreshes on Sundays. The new database, “CustomEpicCubes,” refreshes on Sundays and on the first of every month for Month-End close.


To switch to the new database, please follow the instructions in the Establishing New Cubes Connections Document.


If you have a Pivot table that was connected to the EpicCubes database and you need to change the database connection to CustomEpicCubes, please follow the steps below. These steps will need to be done for each PivotTable in your Excel workbook.


  1. Ensure you have selected a cell on your existing Pivot table
  2. Navigate to the Data tab
  3. Select Properties 
  4. Click on the Definition Tab 
  5. Type Custom in front of EpicCubes in the connection name as well as the connection String
  6. Click OK.


Please follow the instructions for establishing a new CustomEpicCubes Pivot Table in the How to Establish a new CustomEpicCubes Pivot Table document.

The Analytics Catalog Is Now Your Reporting Headquarters

The Library will no longer be available when we transition to Hyperdrive. The Analytics Catalog will be your one-stop shop for reporting content, including reports, dashboards, and SlicerDicer sessions. While the My Reports activity will remain available for you to click on, you will be rerouted to the Analytics Catalog.


Visit The Analytics Catalog--Your One-Stop Shop for Reporting to learn more.

Document Search reports


Documents that appear on a patient’s document list can now be queried with the Patient Document Search reporting workbench template.

Users can create a report on documents such as scanned consents or signed notices by simply searching for this template in My Reports, clicking on New report and specifying the desired document types within the report criteria.


After running the report, the results will consist of a listing of the documents along with supporting data such as when received, when signed, which department the document was scanned in, and more.  

Breaking news you may have missed

  • SlicerDicer on real time data
  • SlicerDicer we Learning videos
  • Epic Update affecting ability to print reports
  • The Training Team is going to XGM 2023
  • Epic's Cogito R&D team selects the Cogito Analytics team for its annual Immersion Program
Tell me more

What is the Cogito Analytics team up to this month?

The Cogito Analytics team is constantly working to improve data analytics--from adding to Epic's Cogito suite of tools to involvement in Epic upgrades. Below is a snapshot of what we are doing to help you get more from Cogito.


  • Analytics Catalog Optimization
  • In-Basket SlicerDicer data model
  • Epic Hyperdrive Migration Nova Project
  • No-Show Predictive Model Project
  • PB Transaction SlicerDicer Customization
  • UT MH Census Charges

Cogito Tool Spotlight: SlicerDicer Usage Survey

SlicerDicer is used to create analysis and sources various data models such as Patients, Visits, and Transactions.


Our aim is help users like you become more familiar with using SlicerDicer. Please answer a short, three-question survey so we can help make SlicerDicer your go-to for reporting analysis.

SlicerDicer Usage Survey

Cogito Business Analyst Corner

Meet the Training, Reporting & Analytics Team: Lori Koepsel

By Hannah Tarver


The Cogito Analytics team is comprised of analysts, developers, database admins, and trainers to meet the analytics and reporting needs of UTHealth. This month we are highlighting Lori Koepsel, a bright and experienced leader who has served UTHealth for almost six years.



Can you share a brief background on your education and when you started here at UTHealth?

 

I have a Master’s degree in Health Informatics from the University of Missouri – Columbia, a Bachelor’s Degree in Business Administration with an emphasis in MIS from Montclair State University (NJ), and an Applied Associate’s Degree in Medical Laboratory Technology from Del Mar College in Corpus Christi, TX. I started working at UT Health as a Senior Project Manager in March of 2017.

 

 

What is your favorite part of your role as EPIC Business Intelligence Technical Support Manager?

 

My favorite part of my role is actually two-fold. I enjoy being able to share my knowledge and experience with others so that they can broaden their skill sets, setting them up for advancement and personal growth. The other favorite part is that I have the opportunity to learn something new every day.

 

 

What work-related accomplishment are you really proud of? 

 

A big work accomplishment that I am really proud of is the recent deployment of the automated reporting to the Prescription Drug Monitoring Program for the HCPC Pharmacy Department. This accomplishment allows Pharmacists to focus on patient care, created a solution using Epic data where the functionality isn’t natively available in Epic, and broadened my skill set.

 

 

Are you currently bingeing any shows on Netflix?

 

I’m actually bingeing on Hulu right now. I didn’t start off watching the Good Doctor and after several mentions by my Mom I decided to give it a try. I was bingeing on The Crown on Netflix, but the change in actors/actresses in Season 3 really turned me off of it. The sad thing is that my primary binge-watching occurs on the weekend. Too much to do on a weeknight to be able to sit down and enjoy tv.

 

What is one of your biggest pet peeves?

 

One of my biggest pet peeves is when people adopt a pet, but later abandon that pet because it becomes too much work. This pet peeve is probably tied with people who don’t spay or neuter their pets.

 

If you could snap your fingers and become an expert in anything, what would it be?

 

I don’t think I would like to be an expert at anything. That would leave one less learning pathway available.



Hannah Tarver joined the Cogito Analytics team as a Solutions Training Analyst in May 2022 and recently accepted an offer as an EHR Application Specialist I (Cogito Business Analyst). Her focus is on the Epic BI Administration area of the team.

RESOURCES

Knowledge is power and with the right tools, you can hone your skills in Radar Dashboard, Reporting Workbench, SlicerDicer, and Cubes. There are several tools available to you to gain the knowledge you need. Select a link below to learn more.


Cogito Data Requests & New Incidents

Do you have a data request need or an Epic related issue that is broken and needs to be fixed? The way you create a request matters.


Read more


Tiered Security Structure

Reporting security is determined by the user’s role. The more analytics intensive a role, the more security access is given.


Read more


Analytics Innovation Network & Hub


The Analytics Innovation Network & Hub is a pathway for analysts seeking a more analytics intensive role as a Cogito Report Builder or Cogito Business Intelligence Developer.


Read more


weLearning

Epic's library of e-Learning modules offers the most current information, instruction, and navigating modules.


Read more


Reporting Content Guides

Visit the Reporting Content Guide page on the Healthcare IT Analytics website to look at videos related to any application and relevant reporting content guides.


Read more


Charge Capture

Do you need information regarding charge capture? You can search for training documents related to Charge Capture such as documentation related to adding multiple CPT Modifiers to inpatient charges, hospital billing charge entry, and more. You can also search for training related to Haiku/Cantu and Care4.


Read more


Data Handbook

The Data Handbook is a repository for information related to accessing and reporting on data stored in Epic. If you don't find what you need in either the Analytics Catalog or Library, explore options in the Data Handbook.


Read more

Visit the Healthcare IT Analytics website
Is the content of this email relevant to you?
Yes
No

Office of the CMIO - Healthcare IT Analytics


Please direct correspondence regarding this newsletter or analytics to the Healthcare IT Analytics team.

For questions: Epic.Analytics@uth.tmc.edu

For help: https://go.uth.edu/epicticket or UTHealth IT Support Center: 713-486-4848

For general inquiries:

Miguel Rodriguez, MBA, PMP

Director, Healthcare IT Analytics

Office of the CMIO - Healthcare IT Analytics

6410 Fannin Street| Suite LL130 | Houston, Texas 77030 

713-486-8725