Data Warehouse or Business Intelligence BI Solution – or Both?

Home > Blogs > SQL Server > Data Warehouse or Business Intelligence BI Solution – or Both?

Data Warehouse or Business Intelligence BI Solution – or Both?

Like This Blog 0 Don Jones
Added by June 24, 2013

I’ve recently been working with a number of small- and medium-sized businesses that are preparing to jump aboard the decision support bandwagon. Several of them have been asking me questions that reveal the enormous amount of confusion in the decision support industry, such as, “do we need a data warehouse, or should we buy a business intelligence solution?” That’s a question best answered by clearly defining some of the key terms that the industry throws around.

Business Intelligence, or BI, is another name for decision support. In essence, BI refers to the business-level practice of gathering information in such a way that management and decision-makers within the organization can quickly get the answers to key business questions. In other words, BI is a generic name for an entire set of functionality as well as the supporting technologies.

A data warehouse is one possible component of a BI system. The idea is that most companies store data in many different places: Customer databases, order databases, shipping databases, and more. These systems can be slow to query individually, and answering key business questions may require data from several sources to be combined in unique ways. A data warehouse basically copies all of that data into one place, making it easier and faster to query and combine that data.

In-memory analytics achieves more or less the same thing as a data warehouse, but it doesn’t require as much advanced planned. Whereas the design of a data warehouse requires you to think in advance about how you want to combine data, in-memory analytics can retrieve and combine data on the fly. As the name suggests, these analytics take place in the memory of a server, meaning the server typically needs relatively massive amounts of memory and processing power. The idea of data warehouses were created before this amount of memory and processing power were readily available.

A BI solution is a software package that implements a data warehouse, in-memory analytics, or both, along with a front-end system that allows users to interact with the system. That front-end usually incorporates dashboards, reports, scorecards, and other end-user elements.

You’re never going to have just a data warehouse, although you may well have a BI solution that only utilizes a data warehouse. These days, it’s more likely that you’ll have a BI solution that leverages both a data warehouse and in-memory analytics, since the two technologies are complementary. The data warehouse can make it easy to quickly get standardized answers to predictable questions, while in-memory analytics serves as kind of an “ad-hoc backup,” providing answers to questions that couldn’t be foreseen when the data warehouse was constructed. An in-memory analytics system can also draw data from the data warehouse, as well as other sources.

The real moral here is to not focus at all on the underlying technologies. If you’re considering a BI solution, look at its business-level features first, and don’t worry so much about how the solution delivers those features. Whether it uses a data warehouse, in-memory analytics, or pure magic under the hood, so long as it’s able to provide the capabilities your business needs, that’s all you should care about.

Don Jones
PowerShell and SQL Instructor – Interface Technical Training
Phoenix, AZ

Videos You May Like

A Simple Introduction to Cisco CML2

0 3859 0

Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2

Cable Testers and How to Use them in Network Environments

0 713 1

This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments

Government Edition – Encrypting a USB Flash Drive in Windows 10

0 272 2

In this video, Security Instructor Mike Danseglio demonstrates how to use BitLocker in Window 10 to secure files on a USB Flash drive that adhere to stricter data protection requirements as found inside Government entities. BitLocker 2-day instructor-led training is now available at Interface: BITLOCK: Planning and Deploying BitLocker Drive Encryption Training Video Transcription: Hi. … Continue reading Government Edition – Encrypting a USB Flash Drive in Windows 10

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.