Welcome!

Microservices Expo Authors: Aruna Ravichandran, Elizabeth White, Liz McMillan, Pat Romanski, Cameron Van Orman

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
Digital transformation leaders have poured tons of money and effort into coding in recent years. And with good reason. To succeed at digital, you must be able to write great code. You also have to build a strong Agile culture so your coding efforts tightly align with market signals and business outcomes. But if your investments in testing haven’t kept pace with your investments in coding, you’ll lose. But if your investments in testing haven’t kept pace with your investments in coding, you’ll...
In his session at 21st Cloud Expo, Michael Burley, a Senior Business Development Executive in IT Services at NetApp, will describe how NetApp designed a three-year program of work to migrate 25PB of a major telco's enterprise data to a new STaaS platform, and then secured a long-term contract to manage and operate the platform. This significant program blended the best of NetApp’s solutions and services capabilities to enable this telco’s successful adoption of private cloud storage and launchi...
DevOps at Cloud Expo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to w...
Enterprises are adopting Kubernetes to accelerate the development and the delivery of cloud-native applications. However, sharing a Kubernetes cluster between members of the same team can be challenging. And, sharing clusters across multiple teams is even harder. Kubernetes offers several constructs to help implement segmentation and isolation. However, these primitives can be complex to understand and apply. As a result, it’s becoming common for enterprises to end up with several clusters. Thi...
Containers are rapidly finding their way into enterprise data centers, but change is difficult. How do enterprises transform their architecture with technologies like containers without losing the reliable components of their current solutions? In his session at @DevOpsSummit at 21st Cloud Expo, Tony Campbell, Director, Educational Services at CoreOS, will explore the challenges organizations are facing today as they move to containers and go over how Kubernetes applications can deploy with lega...
Today most companies are adopting or evaluating container technology - Docker in particular - to speed up application deployment, drive down cost, ease management and make application delivery more flexible overall. As with most new architectures, this dream takes significant work to become a reality. Even when you do get your application componentized enough and packaged properly, there are still challenges for DevOps teams to making the shift to continuous delivery and achieving that reducti...
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, will answer these questions and demonstrate techniques for implementing advanced scheduling. For example, using spot instances ...
SYS-CON Events announced today that Cloud Academy has been named “Bronze Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place on Oct. 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Cloud Academy is the leading technology training platform for enterprise multi-cloud infrastructure. Cloud Academy is trusted by leading companies to deliver continuous learning solutions across Amazon Web Services, Microsoft Azure, Google Cloud Platform, and the most...
The last two years has seen discussions about cloud computing evolve from the public / private / hybrid split to the reality that most enterprises will be creating a complex, multi-cloud strategy. Companies are wary of committing all of their resources to a single cloud, and instead are choosing to spread the risk – and the benefits – of cloud computing across multiple providers and internal infrastructures, as they follow their business needs. Will this approach be successful? How large is the ...
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...
Many organizations adopt DevOps to reduce cycle times and deliver software faster; some take on DevOps to drive higher quality and better end-user experience; others look to DevOps for a clearer line-of-sight to customers to drive better business impacts. In truth, these three foundations go together. In this power panel at @DevOpsSummit 21st Cloud Expo, moderated by DevOps Conference Co-Chair Andi Mann, industry experts will discuss how leading organizations build application success from all...
DevSecOps – a trend around transformation in process, people and technology – is about breaking down silos and waste along the software development lifecycle and using agile methodologies, automation and insights to help get apps to market faster. This leads to higher quality apps, greater trust in organizations, less organizational friction, and ultimately a five-star customer experience. These apps are the new competitive currency in this digital economy and they’re powered by data. Without ...
With the modern notion of digital transformation, enterprises are chipping away at the fundamental organizational and operational structures that have been with us since the nineteenth century or earlier. One remarkable casualty: the business process. Business processes have become so ingrained in how we envision large organizations operating and the roles people play within them that relegating them to the scrap heap is almost unimaginable, and unquestionably transformative. In the Digital ...
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...
The nature of the technology business is forward-thinking. It focuses on the future and what’s coming next. Innovations and creativity in our world of software development strive to improve the status quo and increase customer satisfaction through speed and increased connectivity. Yet, while it's exciting to see enterprises embrace new ways of thinking and advance their processes with cutting edge technology, it rarely happens rapidly or even simultaneously across all industries.
With the rise of DevOps, containers are at the brink of becoming a pervasive technology in Enterprise IT to accelerate application delivery for the business. When it comes to adopting containers in the enterprise, security is the highest adoption barrier. Is your organization ready to address the security risks with containers for your DevOps environment? In his session at @DevOpsSummit at 21st Cloud Expo, Chris Van Tuin, Chief Technologist, NA West at Red Hat, will discuss: The top security r...
Most of the time there is a lot of work involved to move to the cloud, and most of that isn't really related to AWS or Azure or Google Cloud. Before we talk about public cloud vendors and DevOps tools, there are usually several technical and non-technical challenges that are connected to it and that every company needs to solve to move to the cloud. In his session at 21st Cloud Expo, Stefano Bellasio, CEO and founder of Cloud Academy Inc., will discuss what the tools, disciplines, and cultural...
Enterprises are moving to the cloud faster than most of us in security expected. CIOs are going from 0 to 100 in cloud adoption and leaving security teams in the dust. Once cloud is part of an enterprise stack, it’s unclear who has responsibility for the protection of applications, services, and data. When cloud breaches occur, whether active compromise or a publicly accessible database, the blame must fall on both service providers and users. In his session at 21st Cloud Expo, Ben Johnson, C...
21st International Cloud Expo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy. Me...
‘Trend’ is a pretty common business term, but its definition tends to vary by industry. In performance monitoring, trend, or trend shift, is a key metric that is used to indicate change. Change is inevitable. Today’s websites must frequently update and change to keep up with competition and attract new users, but such changes can have a negative impact on the user experience if not managed properly. The dynamic nature of the Internet makes it necessary to constantly monitor different metrics. O...