Why Modern BI is Failing

Jeff Carr
Jeff Carr CEO & Co-Founder
Legacy BI tools were not built to handle modern NoSQL data models like JSON or XML. Change starts with real innovation, not tweaking the status quo.

Why Modern BI Is Failing

Almost daily I hear from companies asking how we can help them connect their relational BI tool (Tableau, PowerBI, ect.) to their NoSQL database including MongoDB, Couchbase, Marklogic and others. It’s understandable, these tools have been around a long time, and many people are comfortable using them. The problem is these tools were not built to handle modern NoSQL data models like JSON or XML, and have extremely poor support for them. Nevertheless, people are determined to make them work. The results in most cases are poor, and ultimately they look for other ways to solve the problem after spending valuable time and money trying to force the square peg in the round hole.

Sreeni Iyer, SalmData's new SVP of Engineering, speaking at the 2015 IPS conference in Montreal.
An entire industry has thrived in the last decade based on the simple idea that all data should fit the existing tools, regardless of where it started..

If You Have A Hammer, Everything Looks Like A Nail

The relational data model was first defined in the early 1970’s and it’s been the dominant model for database and analytics for 40+ years. In recent years new more complex data models have taken hold to support modern applications including IoT, Social media and SaaS. Developers have openly embraced this change since it made their job easier and more efficient. However when analytics on these modern applications comes up the immediate response is make ALL the data relational, regardless of how it is now. Its as if we have decided there can only be one data model for analytics for the rest of eternity.

Request A Demo

No ETL. No Mapping. No Stale Extracts.

First, you should ask yourself, why am I using a NoSQL DB in the first place? For many the answer is schema flexibility, or the ability to not need to have to design a completely fixed schema upfront. It makes development of the application much easier and more agile. If you value this feature for building your app, you should value it for analytics also. Unfortunately the absolute requirement of ALL traditional BI tools is a fixed schema.  From this point forward most of your analytics effort will not be actual analytics at all, but trying to make the flexible schema JSON data fit into a fixed schema model so your tool can understand it. If you don’t need the flexible schema in the data then use a relational DB like Postgres or MySQL, your legacy BI tool will work fine. Otherwise you need to seriously rethink your analytics approach.

Conventional thinking is just “make” the data fit the tool.

How Did We Get Here?

For many non-developers they really don’t fully understand the implications of modern NoSQL datastores. If you’re a business analyst, or marketing person, that did not have a hand in picking the datastore why would you? Most people confronted with the need to gain insights into data will simply default to a tool they know. I recently was trying to explain to an analyst why traditional BI tools were not a great fit for NoSQL, his response was “I’m comfortable with Tableau”. This is the crux of the problem. Modern DB’s have exploded over the last 10 years, they are popping up everywhere, and gaining insights from data models like JSON require tools not built solely for relational data models. Since existing BI were never designed for non-relational data, the focus has been changing the data to fit the tools, instead of just building better tools designed for JSON and other non-relational data.

Need evidence? The number one indicator someone will find a solution like SlamData is have they already failed trying to use an existing BI tool. We have seen companies spend weeks or even months trying to get a “bigger” hammer for that square peg, ultimately only to surrender and realize that powerful analytics on NoSQL data is a very different beast, not just a few degrees from what they already know.


Now Available: the Definitive Guide To JOINs On MongoDB

Lots of business come to us looking for help with doing BI on MongoDB. Specifically, many people want to just do what they’ve always done: query data with SQL. Here's the definitive guide!

Webinar Replay: Plug-And-Play Analytics for Your SaaS App Built On MongoDB

Check out the replay of this webinar to learn how US Mobile uses SlamData to deliver interactive reporting across its business.

The Five Money-Saving Tricks MongoDB Doesn’t Want You To Know

If you listen to your friendly MongoDB sales rep, it's easy to think they are a one-stop shop for all things MongoDB.

Solving the problem of modern data analytics is as much an exercise in human nature as it is a technical problem. Users learn to like a particular analytics tool and become determined to use them on every possible data problem regardless of the probability it will work.

Don’t Fix Your Data, Fix Your BI Tool

An entire industry has thrived in the last decade based on the simple idea that all data should fit the existing tools, regardless of where it started. A large percentage of “Data prep” is really just making non-relational data like JSON fit into tables so traditional BI tools can work. Sure a small percentage is related to data cleaning, or combining disparate data sources, but majority is not. Studies have shown that 80% of “Data science” is really just data prep, of which most is organizing data to a fixed schema of perfectly flat homogenous tables. This is what your BI tool expects, regardless of the original form of the data. Conventional thinking is just “make” the data fit the tool. Unfortunately this approach creates a number of issues including not just the effort needed to change the data, but the fact that by changing it you actually loose data fidelity. You are “dumbing” down the data.
The correct approach is building better BI tools that actually take full advantage of complex data models like JSON as they were designed. Easy to say, hard to do.

I get asked all the time why nobody else has tried this approach? Simple, it’s really hard to build this kind of solution, which means in most cases it’s just easier to make users change the data.

News, Analysis and Blogs

Now Available: SlamData 5.0

The latest release of SlamData delivers unprecedented analytics for NoSQL data sources like MongoDB as well as for projects and solutions that deal with disparate, complex data. Tame your data now! SlamData is a single analytics solution for all of your data. 

read more

What Our Customers Are Saying


We use SlamData to build custom reports and have found the tool is exceptionally easy to use and very powerful. We recently needed to engage the support team and we were very pleased with the turn-around time and the quality of support that we received.

Troy Thompson
Director of Software Engineering
Intermap Technologies, Inc.


When our company migrated from SQL database to MongoDB, all our query tools became obsolete. SlamData saved the day! I was able to easily write SQL2 queries. Plus the sharing, charting, and interactive reports were a game changer.

Michael Melmed
VP, Ops and Strategy
US Mobile


Slamdata helped shine the light on how our new product was being used. The support staff was awesome and we saved engineering cycles in building all the analytics in-house. I am using it to change the mindset in the teams and shift the focus from product launches to product landings

Engineering Lead
Cisco Systems


The Characteristics of NoSQL Analytics Systems

  • The Nature of NoSQL Data
    • APIs
    • NoSQL Databases
    • Big Data
    • A Generic Data Model for NoSQL
  • Approaches to NoSQL Analytics
    • Coding & ETL
    • Hadoop
    • Real-Time Analytics
    • Relational Model Virtualization
    • First-Class NoSQL Analytics
  • Characteristics of NoSQL Analytics Systems
    • Generic Data Model
    • Isomorphic Data Model
    • Multi-Dimensionality
    • Unified Schema/Data
    • Post-Relational
    • Polymorphic Queries
    • Dynamic Type Discovery & Conversion
    • Structural Patterns

Send Us A Message

Get In Touch

(720) 588-9810


1215 Spruce Street, Suite 200 Boulder, CO 80302

Connect With Us

© 2017 SlamData, Inc.