Stringfestanalytics.com

Course Preview: Excel for Healthcare Professionals

WEBI'm happy to share my tentative curriculum for a new course on Excel for healthcare professionals.The motivation to blog about Excel was for analysts in general but more …

Actived: 1 days ago

URL: https://stringfestanalytics.com/excelforhealthcare/

Microsoft Excel for Healthcare Professionals

WEBHighlights of this course: Addresses solutions in Excel for real-life problems of working with healthcare data. Over two hours of video training — download them, yours to keep …

Category: Course Go Health

Learning path: Fundamentals of data visualization in Excel

WEBVisualizations in Excel are called “charts,” whereas most places elsewhere they’d be “plots.”. I’ll use the terms interchangeably; e.g. a “scatter plot” and “scatter chart” are the …

Category: Health Go Health

Excel for Healthcare Preview: What is a Dashboard, Anyway

WEBThank you for signing up. I look forward to becoming savvier about data with you.

Category: Health Go Health

Healthcare Analyst: The Wrangling Fox

WEBSomething I haven't written much about -- and that I'm asked about often -- is my work as an analyst at a public health system in Ohio. I plan to write on it more, so if you've got …

Category: Health Go Health

If the Patient is CEO, Then What’s the Analyst

WEBI recently finished Robin Farmanfarmaian's The Patient as CEO: How Technology Empowers the Healthcare Consumer. Robin describes a wonderful new world of …

Category: Health Go Health

Practice t-tests with these free online datasets

WEBThe t-test rite of passage I like to use the independent sample t-test to introduce learners to inferential statistics. This test is used to compare whether the average value of one …

Category: Health Go Health

Big Data at the Hospital

WEBThis Wall Street Journal story caught my attention because it is capturing many of the trends in my industry. The growth of data, cost control, and population health are all …

Category: Health Go Health

Developing an analytics community of practice: A discussion with

WEBA recent survey by analytics consultancy New Vantage Partners found that only 24.4% of executives claimed their firm possesses a data culture. What can organizations do to …

Category: Health Go Health

Expensive Health Care: Is it Really the Transaction Costs

WEBThis recent Fiscal Times article got me thinking about how to apply the lessons of e-commerce to health care. The article stated at first that individual patient habits were to …

Category: Health Go Health

Python in Excel: How to run a Monte Carlo simulation

WEBMonte Carlo simulations leverage probability and randomness to simulate processes multiple times, exploring a wide range of possible outcomes. This approach can …

Category: Health Go Health

How to get a count of distinct items in Excel

WEBIn the past, getting a count of distinct items in Excel using formulas only was quite cumbersome. With the help of dynamic arrays, we can get it done quickly. Let's look at …

Category: Health Go Health

Free learning guide: Excel for nurses, half-day workshop

WEBMy focus for this learning guide is nurses who are overwhelmed with the dirty data that is thrown at them of all kinds: operational, clinical and financial. It is my hope that with this …

Category: Health Go Health

Yes, really: My 2020 year in review

WEBWay back in the fall of 2019, I had scheduled out all of my 2020 blog posts and decided my last post should be a recap of the year. But what more can be said about 2020?

Category: Health Go Health

accountable care organization

WEBThis recent Fiscal Times article got me thinking about how to apply the lessons of e-commerce to health care. The article stated at first that individual patient habits were to …

Category: Health Go Health

How to load data into Copilot for Excel

WEBFinding Copilot. Copilot is located at the far right of the Home tab of the ribbon, next to Analyze Data: The “Analyze Data” feature in Excel, a precursor to Copilot, encompasses …

Category: Health Go Health