Financial Technology

The Four Generations of Analytics Tools

As the science of analytics advances, new tools are being developed to allow analysts greater abilities to access data and unearth information. The “state of the art” continues to be a moving target, and analytics tools continue to advance as the skills of the analysts increase. The more recent tools require a broader skillset that incorporates both “domain” knowledge about the subject area and technical knowledge of how to use the tools.

A Structured Approach to Spreadsheet Review

Spreadsheets have become universal in the financial world, yet their flexibility also allows for significant potential for error. This white paper presents several techniques for identifying and correcting spreadsheet errors.

Analyzing Bundled Payment Data with PowerPivot

Attendees at this year’s Phila HFMA Decision Support and Financial Technology seminar heard several sessions describe the new PowerPivot add-in for Microsoft Excel.  Presenters described its ability to handle large million-row data sets with extremely fast response times.  But  how big can the datasets be, and how fast is the response time? 

Use RSS to Keep Up to Date

How many websites do you visit each day to keep abreast of the developments in healthcare, finance and technology?  Do you visit each website individually?  If so, you know how time-consuming that process is.   Fortunately there’s a better way, using Really Simple Syndication or RSS.

Exploring New Data Sets - the Stephen Few Approach

Those of us who regularly prepare tables and graphs are well aware of the writings of Stephen Few, who wrote such notable references as Show Me the Numbers  and Information Dashboard Design.  Now Few has prepared a useful guide to using visualizations for data exploration – the process of understan

Maintaining Financial Technology Skills

How to prepare for your next employer while your current employer is using outdated technology
Several years ago I worked on projects for four different clients that involved evaluating a change in the payment methodology of a major payer.  This change had a major impact on revenue, and required analysis of historical data to estimate its effects.

Why Analysts Can't ONLY use Excel 2010

In a previous posting, we extolled the virtues of Excel 2010 for healthcare data analysts.  Excel 2010 offers significant advantages over previous versions of Excel, as that article describes. 

Why Analysts Should Use Excel 2010

I can hear the cries now.  "But we just had to learn Excel 2007 a few years ago.  Why do we have to learn something new now?"  Because it's worth it, so simmer down and take a serious look.

How Will "Cloud" Databases Help Healthcare Providers?

Internet-based databases offer significant computing capabilities to organizations without creating the need for a complex data infrastructure.

MIT Sloan Management Review discusses "How the Analytics Gap Decides Who Wins"

It's not the data that's the problem.  It's the people.  So says a fascinating article in the winter 2011 issue of “MIT Sloan Management Review” (  This extensive article written by several IBM researchers explores how organizations are utilizing analytics to differentiate themselves from their competitors and to become top performers in their industries.  The article profiles results of a massive survey of more than 3000 business executives in mu

"Population Health" provides guidance for ACOs and others taking health risk

"Population Health -Creating a Culture of Wellness"  (  is a new book that provides a comprehensive overview of the issues involved in understanding and managing the health of large groups of people.  Coauthored by David Nash, Dean of Thomas Jefferson University's School of Population Health, the book is separated into section

Your Industrial-Strength Database - And It's Free!

Let's suppose you've been tasked with a project that requires dealing with a significant amount of data.  Perhaps you're analyzing changes in the demographics of patients using hospital services over the last three years, analyzing the results of your cost accounting system, or investigating various characteristics of bad debt claims.  All of these would require working with large volumes of data that would tax the abilities of most spreadsheets.  In your heart you know that you need a true database system to handle this data, but know that there is no way th

Syndicate content