Top 5 Selection Criteria for Packaged BI Systems

Home > Blogs > SQL Server > Top 5 Selection Criteria for Packaged BI Systems

Top 5 Selection Criteria for Packaged BI Systems

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

Small- to Medium-Sized Businesses (SMBs) enjoy a growing marketplace for packaged, SMB-focused business intelligence (BI) solutions. From all-in-one solutions that you host on your own server to Software as a Service (SaaS) cloud-based solutions that you just sign up for, the options grow every day. The lessons that huge enterprises have learned from BI over the past decade are paying dividends for SMBs, as vendors leverage those lessons to create smaller, less-expensive, and easier-to-deploy BI solutions.


However, the advantage that giant enterprises have is that they’re building their BI solutions from scratch. They don’t need to worry about comparing features and vendors, because they’re paying to develop the whole darn thing (they do have to be smart shoppers for components like a database engine, but in terms of top-level features they’re in complete control). When an SMB goes shopping for a BI solution, being a smart comparison shopper is mandatory. With that in mind, here are the five key things you’ll need to pay attention to:

  • Vendor Experience. When looking at a BI solution, see how experienced the vendor is with BI in general. A vendor that’s already making a living custom-building BI solutions for huge companies is going to have the experience necessary to create SMB-focused solutions. A vendor that’s never done BI before should be asked to demonstrate their bona fides.
  • Performance. Look for a vendor that’s willing to recommend any hardware that you’ll need to host their solution, so that you’re running on a “supported” platform and can go to the vendor for help if your BI system doesn’t deliver the performance you need. Otherwise, you’ll wind up with the hardware vendor and BI vendor pointing fingers at each other. Also, ask the BI vendor to show you some existing production systems that are sized about the same as your proposed system, and show you how that system performs. Make them prove that they can handle your data.
  • Output. The whole point of a BI system is output: Dashboards, scorecards, reports, and so on. Make sure you’ve got a robust built-in set of output mechanisms. It’s great when vendors offer “custom reporting,” but you should be able to start using a system effectively without having to immediately build a bunch of custom reports.
  • Connectivity. A BI system has to pull business data from your existing systems, so make sure you know what systems that entails, and that a proposed BI solution can connect to them all. If the BI system can’t get to your data, then it’s useless.
  • Mechanism. There are two primary ways of turning your business data into business intelligence: A disk-based data warehouse, which operates on less-than-real-time data, and in-memory analytics, which relies more on up-to-the-minute data. Both have value and a place in your business, and ideal BI solutions incorporate both. Make sure you know what you’re buying, and ask the vendor to explain how they turn data into facts.

With the right conversation between you and a BI vendor, you’ll definitely find the right one for your business.

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

Videos You May Like

Cable Testers and How to Use them in Network Environments

0 668 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

Configuring Windows Mobility Center and How to Turn it On and Off

1 1413 1

Video transcription Steve Fullmer: In our Windows training courses, we often share information about the Windows 8.1 Mobility Center. Mobility Center was introduced for mobile and laptop devices in Windows 7. It’s present and somewhat enhanced in Windows 8. Since we don’t have mobile devices in our classrooms, I decided to take a little bit … Continue reading Configuring Windows Mobility Center and How to Turn it On and Off

How to create a Cisco IOS Banner – Login and MOTD Message of the Day

0 4246 4

In this video, Cisco CCNA instructor Mark Jacob shows how to create a Login and Message of the Day (MOTD) banners in Cisco IOS. The Banner is an interesting feature of the Cisco IOS. You could probably get by without it, but in a commercial environment you want to have it.

Write a Comment

Share your thoughts...

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