skip to Main Content

Thank you Banner

I wanted to share my experience more as a thank you than as a technique to share.

About a year ago, I moved into a new role in health care as a clinical performance analyst.  My previous experience easily qualified me as an Excel Pro, and I relied heavily on pivot tables, but I was not yet familiar with Power Pivot.  Within the past year, it has transformed the ease and quality of my work and given me a whole new level of appreciation for Excel (I already thought Excel was one of the best things in life!).  Furthermore, my team members have started using Data Models and learning about DAX formulas because they have seen the possibilities.

I am so grateful for Rob’s books and the articles on powerpivotpro.com.  They make learning fun and easy and are such a wonderful resource.  I have learned that if I want to do something in Excel, I just have to search long enough to find the blog post that will help me do it.  I have not yet encountered something I have wanted to do that Excel cannot accommodate in some way.

The interesting thing for me has been seeing how effective Power Pivot is for clinical data.  Most of the examples I have read deal with financial/business scenarios.  With clinical data, the logic is more about filtering tables effectively in order to capture specific inclusions and exclusions for numerators/denominators.  Since many performance rates are calculated differently (e.g. per 1000 patient days vs. per 10,000 patient days), cube formulas have been invaluable in dashboards to allow seamless presentation of metrics that have different data sources and different calculation methods.  I can even capture a user’s slicer selection and incorporate that in the cube formulas to switch between viewing hospital overall rates vs. a specific department’s rate.

In short, Power Pivot has brought new flexibility and depth to clinical reporting in my position.  Thank you for sharing your tools and techniques!

With gratitude,

Hanna Vessey

Microsoft’s platform is the world’s most fluid & powerful data toolset.  Get the most out of it.

No one knows the Power BI ecosystem better than the folks who started the whole thing – us.

Let us guide your organization through the change required to become a data-oriented culture while squeezing every last drop* of value out of your Microsoft platform investment.

* – we reserve the right to substitute Olympic-sized swimming pools of value in place of “drops” at our discretion.

Hanna Vessey

Hanna began her Power Pivot odyssey while working as Clinical Performance Analyst for Foundation Health Partners in Fairbanks, Alaska. She quickly saw the potential for clinical data and has been building data models ever since. Recently, she moved to a role in the Education Department and has just finished her first series of introductory courses on Power Pivot. When not writing formulas, Hanna is either reading or on the many trails in Fairbanks running or walking her dog.

This Post Has 9 Comments
  1. Hanna, I couldn’t agree with you more. The generosity of this team to helping me move forward with DAX has been over the top. And the efforts by Tom Allen who answers 95% of the forum questions is just amazing. Thank you guys…

  2. Riding Hanna’s wave…Thank you P3! Rob, David, and other contributors… You have helped turn us from Excel Jockeys into BI Monsters. DAX, Data Modeling in PowerPivot, Power Update and Thin Reports have (in a short amount of time) helped us to help our business. Trends, insight, counts & amounts are being shared globally through dashboards and reports with our engineers and business managers. Thank you for sharing your knowledge, and providing so many resources and examples.

  3. Hey wow – a second post on the PPP site in the same month by someone from Fairbanks, Alaska. What were the odds?

  4. Great testimonial Hanna! I’m beginning to apply DAX formulas in some of my healthcare analysis so if you’re ever up for sharing some of your work, I’d love to see it!

    1. @Scott: Thanks! The hard part with working with healthcare data is sharing… or rather, difficulty in sharing. I’m always up for discussing techniques, but most of what I work with involves PHI/otherwise sensitive material. I’m sure you will find DAX invaluable as you start using it more and more! 🙂

  5. Having been analyzing healthcare data for years, I can definitely attest to a massive underutiliztion of Power BI and its family in medical informatics departments on both the payer and provider ends…. virtually everywhere.

Leave a Comment or Question