Chris Olsen

Healthcare Data Analyst | Process Improvement Specialist | Cat Collector

Skilled in: Excel, Tableau, SQL, VBA, Power Query, Power Automate, Data Manipulation, Data Analysis, Problem Solving, Cat Herding, Not Knowing The Lyrics To My Favorite Songs

• Projects

This dashboard monitors hospital nurse attrition rates by age range, job role, department, and shift type.
-This provides insights into employee groups most at risk of leaving, offering opportunities for early intervention, reducing attrition, increasing employee satisfaction, and improving patient care quality.

This is an old version of the tool. The newest version had slightly more functionality, was more user-friendly, and more visually appealing. I could only keep the older version, however.
I built this tool to streamline our SOP for price changes. Our suppliers would give us the SKU #s and the new prices. This tool:
-Looks up all of the relevant information and calculates % increases (following different rules for some buyers).
-Calculates what the new retail price should be if we kept the same margin (then rounds up to the nearest cent ending in 9).
-Highlights SKUs whose price has increased above a certain % threshold, and gives other warnings if certain conditions are met.
-Transforms this info to fit the template supplied by the Pricing team and saves it to a file, following a naming convention.
-Creates an Outlook email addressed to the correct people, with the correct file attached.
The buyers said they'd "needed this for 15 years."
Tools used: Excel, VBA, Outlook, Power Query.

-Transformed flu shot data in SQL - Used CTEs, Joins.
-Developed to track the number and percentage of flu shots given to hospital patients, flu shot percentages by age group, and by county.
-This helps officials identify target areas for increased efforts, ultimately improving public health outcomes.

This dashboard compares company overall revenue and costs, as well as by region and product type. The chart on the right also has the profit margin % for that month.

This is a fully dynamic seasonal hunting/fishing calendar I made for our team. Specify the seasons, species, start/end dates, date intervals, colors, as well as labels and it will create it for you. I used VBA in Excel for this. Part of this could be done just with dynamic array formulas and conditional formatting, but VBA added so much more flexibility and customization.