Welcome!

Microservices Expo Authors: Elizabeth White, Dalibor Siroky, Pat Romanski, Liz McMillan, Stackify Blog

Related Topics: Microservices Expo, @CloudExpo

Microservices Expo: Blog Feed Post

Avoid These Pitfalls When Choosing a Business Intelligence Solution

Business intelligence software and services have gone mainstream

Business intelligence software and services have gone mainstream. In the past, only large enterprises typically invested in BI solutions. These days, however, more and more small and medium-sized businesses are actively looking for ways to tap into their information and use it to increase revenues, reduce expenses and realize competitive advantage.

Even though the concept of business intelligence has been around for over 20 years, a substantial percentage of BI implementations are still considered failures. Given the large number of vendors selling BI products and solutions, one would think that at least one of them would be able to get it right. Why are successful BI solutions so elusive?



The answer lies in how success is measured. The only way to establish the success of a BI project is to determine the return on investment (ROI) realized by the company as a result of deploying the system. The problem is that BI deployments usually require very large up-front investments in software, hardware, analyst services and developer time. After the system goes live, there are also high ongoing costs of customization and maintenance. By the time the company realizes whether or not the effort is actually improving its business metrics (months or years later), so much time and money has been spent that discovering a positive ROI is difficult. A key factor in achieving positive ROI is fast, hands-on business user success – when they are able to actually use and benefit from the software within a short period of time.

The best way to avoid this common trap – and to make sure that you quickly and indisputably demonstrate the value of the business intelligence solution you choose – is to select an option with very low up-front costs and fast implementation times.

- Don't Pay ANYTHING before your Users are Actually Using the Solution on Real Data!

This piece of advice may sound unrealistic – until you become familiar with BI solutions based on modern technology. With traditional BI solutions, which use software based on older technologies, it is inevitable that you will have commit substantial time and money to your BI project long before your users ever get their hands on it. This is a risky, outdated approach and one best avoided.

The value of a BI system can only be known once the business users are actually using it to answer important questions and solve real-life business problems. In almost all cases, this requires a process of revisions and improvements during which users want to incrementally change how the system works based on how they are using it. If they cannot quickly add new questions and analytic processes to the software, it may prove only marginally valuable. At worst, they simply won’t use it and the entire investment will be for naught.

Unfortunately, most BI vendors require the customer to invest in serious hardware and data integration/preparation work before the end users even get to play with the data and attempt to adapt it to their own business processes. In typical systems, most changes will require modifications to the back-end data structures and/or report definitions – adding customization costs, taking time and frustrating your users.

The goal has to be to get your users gaining real-world benefits from a BI solution with minimal up-front investments of time and money. Using today's BI technologies, you can deliver an initial working solution using the standard PC hardware you already have, with no more than a day or two of data preparation (sometimes much less). A standard desktop PC with 12GB of RAM can handle huge amounts of data (even 500 million rows) with reasonable response times. That should be enough to get started. Get a more powerful server machine only once you understand exactly what your users will be doing. (Maybe you won't need one at all.) For your users, there are several user-friendly, drag-and-drop reporting/analytic tools. This should get them started quite nicely, and most of those have free trial versions!

- Beware of Data Warehouses and OLAP Cubes

A data warehouse is a centralized repository of data, usually organized in specific ways designed to make it efficient for an OLAP cube, which in turn speeds up query response times to previously-defined queries. If this sounds too technical, that’s because it IS too technical. And like anything very technical, it requires technical people and several weeks or months of work to set up. Thereafter, maintenance and improvements are also time-consuming, constrained and expensive.

Modern BI technologies (e.g., column-based storage and in-memory query processing) do not require a data warehouse/OLAP architecture in order to provide excellent query response times, simply by better utilizing hardware resources. Going down the OLAP path, especially before the system has gone live, is a sure way of punching a big hole in your IT department's budget long before you even know if the system is worth anything to the actual business users it is intended to serve! Data warehouse and OLAP implementations are complex, risky, time-consuming affairs and difficult to maintain. These days, there are better alternatives! Try them first. The implementation time is significantly shorter and easier, so your up-front investment will be much smaller.


- Consider the Scalability of the BI Solution you Choose

Successful BI systems almost always face three ongoing pressures for expansion: (1) the quantity of data with which they must function is ever-growing, (2) the demands from users for new and ever-more-complex queries/reports/analytics keep coming and (3) growing numbers of users in the organization will want access to the system.

These demands often prove extremely challenging to those who maintain a BI system. Scalability issues are usually addressed by either throwing more hardware at the problem or making architectural changes to the system. Both approaches result in system down-time, IT management overhead and significant expense. OLAP cube-based solutions are particularly vulnerable to scalability challenges.

When you are evaluating BI solutions, consider at what rate you expect your data to grow, how user demands might tax the system down the road and how many users might potentially need access to the system in the future. Ask BI vendors what kind of hardware would be required to handle your future expected demands and what limitations the system might introduce. For example, you will never want to be forced, for reasons of system architecture limitations, to divide your data into separate silos or to significantly limit the amount of historical data available. These are both common vendor-suggested approaches which introduce extensive data management headaches and business-level reporting constraints. If you are going to compromise on this, you better know you're not doing it because the solution is using out-dated technology.

Consider carefully the costs and limitations you may face down the line. You don't want to invest in a BI solution with a foreseeable expiration date.

- Outsourcing vs. In-house BI

If your business does not have people with the in-house skills and knowledge required to implement a BI solution, outsourcing is clearly the way to go. Even in this case, it is important to be very involved every step of the way, making sure that any choices made by your consultants are in line with your own strategic and tactical priorities. The downside of using outside people to implement and maintain your BI system is that your access to the system is very limited. When you need new reports, for example, your requests may get delayed because your service provider is simply too busy doing other things.

It is always a good idea for an organization to manage its own BI, whenever possible. Since BI is a core strategic asset and source of competitive advantage, updates and improvements to a BI system need to be flexible and swift. With traditional BI solutions, your lack of in-house expertise may entirely obviate this option. However, BI technologies have evolved tremendously over the past few years, and you might be surprised at how the expertise you do have is more than enough to deploy and maintain a powerful BI solution. In most cases, a sophisticated business user with solid Excel skills will be able to integrate large amounts of data from multiple sources and create the interactive dashboards and reports your business needs with no need for consultants or IT professionals.

- Think Twice before you Run your Data in the Cloud

Despite the hype, cloud infrastructure is expensive. For light processing of modest quantities of data, it's great. However, BI solutions are resource-intensive computing applications, requiring extensive amounts of memory and CPU horsepower. Using a cloud-based BI solution operationally will siphon off a lot of your budget to your cloud provider or force you to significantly limit the amount of data available for business reporting.

If you have compelling reasons to run your BI in the cloud, it is very important that you choose a BI solution with cloud-friendly technology. Look for a system optimized for efficient use of hardware resources under cloud conditions, e.g., to utilize more hard disk space (cheaper) and less RAM and CPU (expensive). Otherwise, you will be limiting yourself to small data sets or expending huge budgets. Either way, that may be fine in the short-term, but down the road you might not be so happy with your BI choices.

Read the original blog entry...

More Stories By Elad Israeli

Elad Israeli is co-founder of business intelligence software company, SiSense. SiSense has developed Prism, a next-generation business intelligence platform based on its own, unique ElastiCube BI technology. Elad is responsible for driving the vision and strategy of SiSense’s unique BI products. Before co-founding SiSense, Elad served as a Product Manager at global IT services firm Ness Technologies (NASDAQ: NSTC). Previously, Elad was a Product Manager at Anysoft and, before that, he co-founded and led technology development at BiSense, a BI technology company.

@MicroservicesExpo Stories
As DevOps methodologies expand their reach across the enterprise, organizations face the daunting challenge of adapting related cloud strategies to ensure optimal alignment, from managing complexity to ensuring proper governance. How can culture, automation, legacy apps and even budget be reexamined to enable this ongoing shift within the modern software factory? In her Day 2 Keynote at @DevOpsSummit at 21st Cloud Expo, Aruna Ravichandran, VP, DevOps Solutions Marketing, CA Technologies, was jo...
The nature of test environments is inherently temporary—you set up an environment, run through an automated test suite, and then tear down the environment. If you can reduce the cycle time for this process down to hours or minutes, then you may be able to cut your test environment budgets considerably. The impact of cloud adoption on test environments is a valuable advancement in both cost savings and agility. The on-demand model takes advantage of public cloud APIs requiring only payment for t...
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know that not all workloads are suitable for cloud. You know that you want the kind of ease of use and scalability that you get with public cloud, but your applications are architected in a way that makes the public cloud a non-starter. You’re looking at private cloud solutions based on hyperconverged infrastructure, but you’re concerned with the limits inherent in those technologies.
Is advanced scheduling in Kubernetes achievable?Yes, however, how do you properly accommodate every real-life scenario that a Kubernetes user might encounter? How do you leverage advanced scheduling techniques to shape and describe each scenario in easy-to-use rules and configurations? In his session at @DevOpsSummit at 21st Cloud Expo, Oleg Chunikhin, CTO at Kublr, answered these questions and demonstrated techniques for implementing advanced scheduling. For example, using spot instances and co...
It has never been a better time to be a developer! Thanks to cloud computing, deploying our applications is much easier than it used to be. How we deploy our apps continues to evolve thanks to cloud hosting, Platform-as-a-Service (PaaS), and now Function-as-a-Service. FaaS is the concept of serverless computing via serverless architectures. Software developers can leverage this to deploy an individual "function", action, or piece of business logic. They are expected to start within milliseconds...
The cloud era has reached the stage where it is no longer a question of whether a company should migrate, but when. Enterprises have embraced the outsourcing of where their various applications are stored and who manages them, saving significant investment along the way. Plus, the cloud has become a defining competitive edge. Companies that fail to successfully adapt risk failure. The media, of course, continues to extol the virtues of the cloud, including how easy it is to get there. Migrating...
For DevOps teams, the concepts behind service-oriented architecture (SOA) are nothing new. A style of software design initially made popular in the 1990s, SOA was an alternative to a monolithic application; essentially a collection of coarse-grained components that communicated with each other. Communication would involve either simple data passing or two or more services coordinating some activity. SOA served as a valid approach to solving many architectural problems faced by businesses, as app...
Some journey to cloud on a mission, others, a deadline. Change management is useful when migrating to public, private or hybrid cloud environments in either case. For most, stakeholder engagement peaks during the planning and post migration phases of a project. Legacy engagements are fairly direct: projects follow a linear progression of activities (the “waterfall” approach) – change managers and application coders work from the same functional and technical requirements. Enablement and develo...
Gone are the days when application development was the daunting task of the highly skilled developers backed with strong IT skills, low code application development has democratized app development and empowered a new generation of citizen developers. There was a time when app development was in the domain of people with complex coding and technical skills. We called these people by various names like programmers, coders, techies, and they usually worked in a world oblivious of the everyday pri...
While some developers care passionately about how data centers and clouds are architected, for most, it is only the end result that matters. To the majority of companies, technology exists to solve a business problem, and only delivers value when it is solving that problem. 2017 brings the mainstream adoption of containers for production workloads. In his session at 21st Cloud Expo, Ben McCormack, VP of Operations at Evernote, discussed how data centers of the future will be managed, how the p...
From manual human effort the world is slowly paving its way to a new space where most process are getting replaced with tools and systems to improve efficiency and bring down operational costs. Automation is the next big thing and low code platforms are fueling it in a significant way. The Automation era is here. We are in the fast pace of replacing manual human efforts with machines and processes. In the world of Information Technology too, we are linking disparate systems, softwares and tool...
DevOps is good for organizations. According to the soon to be released State of DevOps Report high-performing IT organizations are 2X more likely to exceed profitability, market share, and productivity goals. But how do they do it? How do they use DevOps to drive value and differentiate their companies? We recently sat down with Nicole Forsgren, CEO and Chief Scientist at DORA (DevOps Research and Assessment) and lead investigator for the State of DevOps Report, to discuss the role of measure...
DevOps is under attack because developers don’t want to mess with infrastructure. They will happily own their code into production, but want to use platforms instead of raw automation. That’s changing the landscape that we understand as DevOps with both architecture concepts (CloudNative) and process redefinition (SRE). Rob Hirschfeld’s recent work in Kubernetes operations has led to the conclusion that containers and related platforms have changed the way we should be thinking about DevOps and...
"As we've gone out into the public cloud we've seen that over time we may have lost a few things - we've lost control, we've given up cost to a certain extent, and then security, flexibility," explained Steve Conner, VP of Sales at Cloudistics,in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
These days, APIs have become an integral part of the digital transformation journey for all enterprises. Every digital innovation story is connected to APIs . But have you ever pondered over to know what are the source of these APIs? Let me explain - APIs sources can be varied, internal or external, solving different purposes, but mostly categorized into the following two categories. Data lakes is a term used to represent disconnected but relevant data that are used by various business units wit...
With continuous delivery (CD) almost always in the spotlight, continuous integration (CI) is often left out in the cold. Indeed, it's been in use for so long and so widely, we often take the model for granted. So what is CI and how can you make the most of it? This blog is intended to answer those questions. Before we step into examining CI, we need to look back. Software developers often work in small teams and modularity, and need to integrate their changes with the rest of the project code b...
"I focus on what we are calling CAST Highlight, which is our SaaS application portfolio analysis tool. It is an extremely lightweight tool that can integrate with pretty much any build process right now," explained Andrew Siegmund, Application Migration Specialist for CAST, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
"Cloud4U builds software services that help people build DevOps platforms for cloud-based software and using our platform people can draw a picture of the system, network, software," explained Kihyeon Kim, CEO and Head of R&D at Cloud4U, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Kubernetes is an open source system for automating deployment, scaling, and management of containerized applications. Kubernetes was originally built by Google, leveraging years of experience with managing container workloads, and is now a Cloud Native Compute Foundation (CNCF) project. Kubernetes has been widely adopted by the community, supported on all major public and private cloud providers, and is gaining rapid adoption in enterprises. However, Kubernetes may seem intimidating and complex ...
DevOps is often described as a combination of technology and culture. Without both, DevOps isn't complete. However, applying the culture to outdated technology is a recipe for disaster; as response times grow and connections between teams are delayed by technology, the culture will die. A Nutanix Enterprise Cloud has many benefits that provide the needed base for a true DevOps paradigm. In their Day 3 Keynote at 20th Cloud Expo, Chris Brown, a Solutions Marketing Manager at Nutanix, and Mark Lav...