Cubes vs. Cubeless Significance
New Technology Demanded – New Technology Delivered:
Pinpoint – No Cubes = No Limits…
Emerge from the BI-cubed dark side to discover real-time,
limitless data and analytic power.
Other BI systems use cubes, in-memory, data-marts or meta-layers to aggregate data; a process which limits data available and then additionally limits access to the limited data. To make matters worse, many times this data building process is done with little to no input from the customers’ subject matter experts to determine which data to leave out/aggregate. In a rushed environment, based on that day’s needs, someone other than a well-chosen client committee determines what information executives will need to make future strategic decisions for years to come. A simplified example might be that total revenue by department is added as a data element. Later an executive wants to know what portion of new revenue was from new patients who also presented with another related diagnosis but were not hospitalized at that time. That data was not included in the data cubes to answer the question, so the executive has a choice; do without the answer or go ask and wait for IT to build additional cubes that contain this data (which is the same process required every time for every new data element). Heaven help the executive that receives the new data and to qualify the new data, wants to know something else that is not in an existing cube.
Before Pinpoint, if an analyst did not know what data was/was not in the cubes/data mart, etc. or in which cube/data-mart, etc., he could easily produce a report which led him to make a decision based on less than complete information. Executives using these BI systems, who almost never know this cube detail, have unknowingly made countless strategic decisions based on less than complete information. Additionally, these inherent problems extend well past implementation, where customers’ IT departments must invest, and BI vendor consultants will charge, significant time in continuously updating these cubes/data-marts, etc. In many cases BI customers choose, or are forced by financial conditions, to slowly let these limited data containers become less and less valuable by not updating/adding to them. This is frustratingly noticed by end-users who quickly discount the data and reduce/stop querying the system; resulting in very expensive shelfware. For this reason, those who have purchased BI systems strongly convey to others “you cannot base a BI purchase decision on the purchase cost alone, you must include the total on-going costs, which can be 3-4 times the purchase cost”.
It’s no wonder most BI companies have been sued by their customers. Newer BI companies, trying to capitalize on this low BI customer satisfaction are touting a customer/user-focus, however if they use a cube/data-mart, etc., they are only adding to the industry’s problem and to the weariness of potential BI customers. Pinpoint solves the limiting data and limiting access issues while eliminating the need for on-going IT and consultant involvement. With Pinpoint the subscription price on a SaaS model is the total cost. On a perpetual license option the only other charge is annual maintenance (lower than industry).
Once we solved the “data limiting” problems we were then able to harness numerous new, advanced technologies, which allowed us to eliminate the “data access” problems. Included in Pinpoint are new “data access” technologies such as Ad-hoc Multi-tier Querying and Continuous Cell Drilling, enabling analysts and executives alike to now ask very detailed, multiple “streaming” questions within one query, as well as continue to drill-down within one report/geo-map until all relevant data is delivered. Current BI systems typically limit the detail/number of questions in a user query. An example of a Pinpoint Ad-hoc Multi-tier Querying:
- Which departments see at least 10% of the male patients with age less than 30 that come from our top 50 zip codes and perform procedures which have less than 5% denial rate from insurance companies which pay on average in less than 20 days?
Current BI systems typically also limit drill-downs to two drill downs; however the drill down and what you get/don’t get is entirely predicated on what was set up in the cube/data-mart you are drilling down in. Again, knowledge an end-user typically never knows. With Pinpoint you need only make successive mouse clicks within the same report. An example of a Pinpoint Continuous Cell Drilling:
- Of those patients with heart surgery, select by type of heart surgery, select by facility, by a surgeon, by patients with complications, by male patients over 75, to then drill down to discover the date of surgery, complications, date of last follow-up, results of last follow-up, days hospitalized, prescriptions, outstanding A/R by patient/insurer, A/R age, reason?
Resolving these data limiting/access problems significantly increases decision-making frequency, confidence, credibility, reliability, accuracy and timeliness. It also allows analysts/executives/end-users to achieve new, valuable organizational, fiscal and strategic agility levels. And by significantly reducing set-up, implementation and on-going support costs, the customer realizes a significant reduction in the time to achieve a significantly higher ROI.
“Based on our committee’s thorough review of six leading Business Intelligence offerings, we found Pinpoint was not only without equal in non-technical ease of use, providing ad-hoc queried information and drilldowns in seconds vs. hours; but also clearly distinguished itself with quick customization capabilities of dashboards and reports.”
– Jeffery Jacobs, Decision Support Manager Erie County Medical Center