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

Agile Methodology in Project Management

0 184 0

In this video, you will gain an understanding of Agile and Scrum Master Certification terminologies and concepts to help you make better decisions in your Project Management capabilities. Whether you’re a developer looking to obtain an Agile or Scrum Master Certification, or you’re a Project Manager/Product Owner who is attempting to get your product or … Continue reading Agile Methodology in Project Management

Creating Users and Managing Passwords in Microsoft Office 365

0 786 4

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.   For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365    

Using Navigation Controls in a Collaboration Site in SharePoint

0 360 1

In this SharePoint training video, I want to talk about the Navigation Controls in SharePoint. They tend to fall into two kind of different categories; one with the navigation controls in a typical Collaboration Site such as a Team Site or a Project Site. These are Sites that are based on the Team Site Template … Continue reading Using Navigation Controls in a Collaboration Site in SharePoint

Write a Comment

Share your thoughts...

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