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

A Simple Introduction to Cisco CML2

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

Creating Dynamic DNS in Network Environments

0 641 1

This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader teaches how to create Dynamic DNS zones in Network Environments. Video Transcription: Now that we’ve installed DNS, we’ve created our DNS zones, the next step is now, how do we produce those … Continue reading Creating Dynamic DNS in Network Environments

Cable Testers and How to Use them in Network Environments

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

Write a Comment

Share your thoughts...

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