Analyst Training: Two Parentheses-The Math of Simple Analysis

Most analysis in healthcare doesn’t need more than two parentheses or what you learned in fourth grade. But sometimes our great data and brilliant models are dismissed simply because we forgot our order of operations (PEMDAS) or percentage calculations. A spreadsheet does simple math but doesn’t know math.

This Excelinar is a refresher on the simple math of analysis so you don’t get embarrassed when you’re trying to show your cool report but your customer raises their hand and says “I think you have the math wrong.”

 

Link to presentation worksheet: Equation Excelinar Two Parenthesis Math Worksheet


Meet the Presenter:

Rick Carter has over 35 years of experience in an analyst and consultant role. Rick helps physicians and healthcare executives improve their operational and financial performance. He has authored many industry articles, but is best known for creating the core methodology behind Equation’s data and analytically driven consulting model.

Analyst Training: Extreme Logic-How To Use Data That Doesn’t Exist

As analysts, we all face the obstacle of missing or incomplete quantitative data. As a result, we find ourselves left with the decision of how to effectively analyze data when we don’t have the benefit of complete data from which to work.

In this webinar session, we address how to effectively tackle missing data in the analysis process. We take you through the analytic processes we undertook for one of our clients as we assessed their physician compensation model.

Analyst Training: Report Writing – Don’t Let Your Words Ruin Your Numbers

Writing an effective report that highlights your data insights can be tricky. Even for a seasoned writer, figuring out how to translate data relationships and patterns from numbers to plain English can be a daunting task.

In this session, Rick Carter will teach the key aspects of writing a useful, focused, and impactful report that will propel your organization to action.

Click here to download the webinar: Webinar: Report Writing

Click here to download Rick’s worksheet: Worksheet-Excelinar Words to Support Numbers


About the Presenter

Rick Carter has over 35 years of experience in an analyst and consultant role. Rick helps physicians and healthcare executives improve their operational and financial performance. He has authored many industry articles, but is best known for creating the core methodology behind Equation’s data and analytically driven consulting model.

Analyst Training: Spreadsheet Errors That Kill Your Reputation & How To Avoid Them

Healthcare Analysts translate big and complicated numbers into plain English every day. The crux of an analyst’s job is to take that data and use it to help health systems make better business decisions. Executive managers make system-wide business decisions off of analyst’s work every day — no big deal, right?

Painting the business picture through analysis is a process. In that process there are a myriad of mistakes that can be made. These mistakes can hurt an analyst’s credibility. In this webinar, Rick Carter illustrates the most common spreadsheet errors and how to avoid them in his signature live Excel format.

 

 

To download worksheet used in the webinar, click here: Worksheet-Spreadsheet Errors


Presenter:  Rick Carter, Equation Principal

Analyst Training: The Greatest Skill of an Analyst, How to Tell a Story in Numbers

We all know that data is powerful. But did you know when data is used to tell a story, it becomes unforgettable?

Telling a story in numbers seasons the data so it resonates with the audience on both an intellectual and emotional level. Data stories allow the audience to have a greater sense and understanding of the context of the numbers.

In this webinar, Rick Carter will explain and illustrate how to make your numbers tell a story.

To download the spreadsheet that Rick used please click here: Telling Stories with Numbers

Equation uses a custom Excel add-on that changes ‘Number to dollar’ and ‘Number to comma’. Contact ehaynie@equationhealth.com if you are interested in the add-on.


Rick Carter has over 35 years of experience in an analyst and consultant role. Rick helps physicians and healthcare executives improve their operational and financial performance. He has authored many industry articles, but is best known for creating the core methodology behind Equation’s data and analytically driven consulting model.

Analyst Training: Building Powerful Data Models

In this session, Rick Carter demonstrates how data models can move you to more effective communication with your organization’s stakeholders.

Participants will gain a practical understanding of data modeling terminology, concepts, and techniques as well as how best to apply this new knowledge to their own data projects.

Excel Spreadsheet Link: Equation Health Excelinar on Basic Modeling (spreadsheet)

Equation uses a custom Excel add-on that changes ‘Number to dollar’ and ‘Number to comma’. Contact ehaynie@equationhealth.com if you are interested in the add-on.

Analyst Training: Putting Lipstick on Your Analytics

Do you want your audience to take notice of your data analysis? Are you looking for ways to make your analysis stand out? Do you want to increase your audience’s understanding and recollection of your quantitative analysis?

Believe it or not, the way in which you present your data has a direct correlation on how receptive your audience is to your analysis. The visual representation of data has the power to make your quantitative analysis shine by making it easily digestible and significantly more memorable.

In this session, Rick Carter shares ways to dress up your analytics in order to attain the spotlight your analysis deserves.

Equation uses a custom Excel add-on that changes ‘Number to dollar’ and ‘Number to comma’. Contact ehaynie@equationhealth.com if you are interested in the add-on.


Rick Carter has over 35 years of experience in an analyst and consultant role. Rick helps physicians and healthcare executives improve their operational and financial performance. He has authored many industry articles, but is best known for creating the core methodology behind Equation’s data and analytically driven consulting model.

Analyst Training: Making Sense of Benchmarks

Healthcare organizations look to physician practice benchmarks for assurance and course corrections. However, benchmarks don’t always add up, aren’t consistent, and often just don’t make sense at all.

Rick Carter, creator of a leading data-driven consulting model used by Equation analysts and presented to clients nationwide, provides instruction on how to make sense of benchmarks. This webinar differs from typical webinars in that Rick keeps you thoroughly engaged throughout this unique, live Excel spreadsheet modeling format.


To download the workbook used in the Excelinar*: Equation Excelinar Benchmarking Workbook

Equation uses a custom Excel add-on that changes ‘Number to dollar’ and ‘Number to comma’. Contact ehaynie@equationhealth.com if you are interested in the add-on.