While recently attending a meeting, I heard the CEO make the following statement:
“Is it too much to ask, … seriously here; to create a system where data is not only painstakingly entered in by competent staff, but then to use that same system to do normal analytical reporting? … I mean why we do need one system to put the data into, and then another system that does the reporting?”
This CEO is not the only person expressing concerns. A recent search on the internet for: “the future of business intelligence”, returned millions of results from developers, data architects, data modelers, business intelligence consultants and various organizations expressing similar concerns.
Every day business owners around the world try to find a way to compete in today’s market place. Millions upon millions of dollars each year are invested into innovative new ways to analyze the data businesses capture and process. This process of analyzing business data is commonly referred to as Business Intelligence.
Typically when a business decides to change out its ERP or CRM system, at a minimum it involves:
- Selecting and purchasing the necessary software / hardware.
- Setting up the hardware and software.
- Importing the historical data from the legacy system.
- Testing and then making necessary changes.
- Training users on how to use the new system.
When one considers the expense and time involved, its simply overwhelming! This of course has nothing to do with the second system that will be purchased later to provide the analytical reporting.
The truth is, none of this is necessary. The Spider Schema is a data modeling technique that allows vendors who create ERP, and CRM systems to model data so that it provides robust Transactional (OLTP), Analytical (OLAP), and Big Data support in a single data model!
The Spider Schema is the future of Business Intelligence or Analytical Reporting because it provides full support for OLAP, OLTP, and Big Data.
The Spider Schema has been used for over 8 years in various industries and is proven to be a solid, data reducing, accurate, time saving, and robust way of modeling data.
When ERP and CRM system vendors realize the potential of the Spider Schema it will replace existing OLTP data models. Then a single system can process the daily business needs while also providing full analytical reporting.
The question is: why invest time and money in a CRM or ERP system that needs another system to do the analytical reporting? Why not build a custom ERP solution based off of the Spider Schema data model, and get the best of OLTP, OLAP, and Big Data in a single solution?