If you Don’t have a Data Warehouse you Lose!
If you don’t have a data warehouse that can be scaled, migrated and grown for the purpose of data mining than you lose in the new supply chain game of value analysis analytics.
What I’m talking about here is the need for you to employ a data warehouse to manage, analyze and control your supply chain business vs. just managing routine MMIS or ERP transactional data. It means going deeper and broader than ever before to extract meaningful actionable data to save money and improve your operations. Some of the benefits of a data warehouse are:
● Enables you to maintain your data history, even if your source transaction systems
(e.g. MMIS or ERP) do not.
● Integrates data from multiple source systems (A/P, financial and clinical files, etc.) so you can
have a view across your supply chain.
● Improves data, by providing consistent categorization and descriptions, flagging or even fixing
bad data.
● Presents your supply chain information consistently and reliably.
● Provides a single common data model for all data regardless of your data's source.
● Restructures the data so that it makes sense for your business use.
● Organizes your data so that it delivers excellent query performance, even for complex
analytic queries.
If you feel that these attributes of a data warehouse aren’t important to you, let me show you how you can use this technology to control your supply chain expenses when you have the right analytical software for data mining.
If you would integrate your purchase service expenses, by category, (telecommunications, travel, transcription services, etc.) with their relational operating metrics (patient days, meals serviced, clinic visits, etc.) you will than see what your cost per operating metric is for each category of purchase service. If you then benchmark these same categories of purchase services, I can assure you that you will discover 11% to 18% in savings in these same purchase services.
Get my point here! This same analytical exercise can’t be accomplished without a data warehouse. Your current MMIS or ERP systems won’t cut the mustard; it’s beyond their capability to do so. So, if you want to move to the next level of data performance don’t wait any longer to make, buy or subscribe to a provider of these services to up your game.
Filed Under: Best Practices • savingsblog
