Microservices Expo Authors: Elizabeth White, Carmen Gonzalez, Pat Romanski, Liz McMillan, Derek Weeks

Related Topics: Agile Computing, Java IoT, Industrial IoT, Microservices Expo, Microsoft Cloud

Agile Computing: Article

Understanding Business Intelligence and Your Bottom Line

How much BI is just right for your business?

The term "Business Intelligence" and its acronym "BI" are so pervasive in today's data-intensive lexicon that it's a challenge to know just what to make of it. If you add in all the new trendy terminology such as business process management (BPM), data mining, data warehousing, business process automation, decision support systems, query and reporting systems, enterprise performance management, executive information systems (EIS), business activity monitoring (BAM), modeling and visualization, and so forth, your head can start spinning.

Here is a workable definition of BI that was provided in a Technology Evaluation report from a January 10, 2005, Technology Evaluation Centers article by Mukhles Zaman entitled, "Business Intelligence: Its Ins and Outs":

"BI is neither a product nor a system. It is an umbrella term that combines architectures, applications, and databases. It enables the real-time, interactive access, analysis, and manipulation of information, which provides the business community with easy access to business data. BI analyzes historical data - the data businesses generate through transactions or by other kinds of business activities - and helps businesses by analyzing the past and present business situations and performances. By giving this valuable insight, BI helps decision-makers make more informed decisions and supplies end-users with critical business information on their customers or partners, including information on behaviors and trends."

To put it in simpler terms, BI makes the right information available in the right format to the right person at the right time. Given that virtually all small and midsized businesses (SMBs) crave better information, the kind of information typically provided by a BI tool, the real question is how much of this technology constitutes a good investment of time and energy? Most of the industrial-strength, BI-related tools cater more to the larger enterprises whose business structures are highly complex and whose budgets can accommodate the lofty implementation expenditures. While many of these vendors would like you to think that their pricey, high-end solutions are absolutely necessary for the SMB sector as well, our research indicates otherwise.

Based on the size of your company and budgetary constraints, your goal is to determine what BI tools you really need to drill down and extract the key performance data that will make your company more efficient and profitable.

To start, we recommend that you leverage your existing technology and find cost-effective, easy-to-use BI solutions that integrate with your Microsoft Office Suite. That should be quite sufficient to get you the intelligence you need to significantly boost your bottom line. The real question is how much of BI technology constitutes a good investment of time and energy?

Cutting Through BI Mythology and Hype
To distill the BI discussion to its simplest terms, what businesses need most is the ability to find and extract key information that identifies their strengths and weaknesses and helps them make better decisions. They also want this information to be presented in a timely fashion and in a way that business people can understand.

Given this modest objective, SMB companies must filter through the hype emanating from many BI application vendors who claim that they should invest in higher-priced, industrial-strength BI solutions to achieve their goals. Below, we will attempt to dispel some of these myths and offer some guidance on how to make the right purchasing and implementation decisions for your business.

Myth #1: You really need a "cube-based" OLAP BI solution
Many vendors want you to believe that in order to make the best possible business decisions;

Sure, this makes sense if you are a Fortune 1000 company with numerous divisions and databases and highly complex reporting requirements. Oh, and you've got mega-bucks to spend on trying out different BI solutions that will take a long time to implement and much more time to learn and use. We know that a cube-based OLAP tool does enable end-users to slice and dice their data, perform multi-dimensional analysis, present information in graphs and charts, and more. However, there is a high cost associated with maintaining these cube-based systems. For example, every time a new dimension is added to a multi-dimensional analysis, one has to make changes to all cubes that would use that dimension. Of course, one needs access to very high level programming skills to do that, not to mention the budget to support this approach.

On the other side of the equation are reporting tools such as Crystal Reports, FRx, and F9, which fall into the category of transaction system reporting. If you want to know your current inventory levels or the balance of a receivable account or even a comparison of these indicators over a specific period, these tools are fine. But if you're looking for actionable intelligence that will add considerable value to the decision-making process, you need more than simple reporting tools.

The best approach to BI for SMB companies lies somewhere between these two approaches. The optimal position is one of information balance, existing between formal cube-based systems and simple report writers. The right tool must be able to deliver multi-dimensional analysis, graphing, charting, and more, for a fraction of the cost of an expensive OLAP solution. Moreover, the tool should be modifiable by a user without requiring extensive programming skills.

Make no mistake - having access to an analytics tool can be a very powerful component of your BI plan. Analytics enable end-users to transform data into information, and then get that information into the right hands and in the correct format to facilitate timely decision-making. This can help companies increase customer satisfaction, decrease costs, and increase revenues. However, there is a misconception that SMB companies must invest a small fortune in industrial-strength analytics. In reality, these companies are more interested in the macro view of their business (which BI can deliver), rather than getting so close to the actual transactions that you lose the departmental or company-wide perspective (needed for smarter decision making).

For these companies, it's usually quite sufficient to perform data analysis covering predetermined periods of time - say, months, quarters, or years. Typically, you are examining trends or comparisons of results between periods, meaning that you really don't need to pay for overly expensive applications that deliver high-powered analytics. We contend that the level of investment required for an expensive analytics solution is more the province of the larger company than the SMB market.

Myth #2: You need to toss out all your spreadsheets
With all the high-priced applications now available in the fragmented BI marketplace, it's easy to see why many vendors would scoff at the idea that your basic Microsoft Office Suite is quite adequate as a key component of your BI solution. They don't want you to know that the most widely used BI tool today is an Excel spreadsheet. Almost everyone in the corporate world is familiar with Excel, its minimal learning curve, and the fact that the application leverages a company's existing software solutions. Excel is often used to track expenses, create budgets and forecasts, and create reports from that data. Plus, Excel tools offer many useful features such as graphing, charting, and pivoting, which assist decision-making.

Since many of today's more affordable BI solutions integrate seamlessly with Excel, there is absolutely no reason to abandon this trusty tool that you have relied on for so long. As long as you can access the right data that can help you measure your company's operational performance, the spreadsheet is still the way to go. Of course, if you are accessing data from disparate databases whose information is out of sync, then it won't matter what BI solution you use; you're not going to get accurate results.

Myth #3: You really need to invest in a BI solution to achieve airtight compliance with Sarbanes-Oxley
The Public Company Accounting Reform and Investor Protection Act of 2002 (also known as the Sarbanes-Oxley Act of 2002) was passed by U.S. lawmakers to reinforce honest and transparent corporate practices in the wake of various public accounting scandals and corporate failures. As with any far-reaching legislation of this magnitude, there is plenty of hype that has emerged in connection with this law. Let's clear up the picture as it relates to BI software and compliance with Sarbanes-Oxley.

For starters, here are two facts to consider: 1) The Act applies only to U.S. public companies and, 2) There is no software application certification provided under the Act. This means that you can't achieve compliance with this Act by simply buying some BI tool. If you are concerned with Sarbanes-Oxley compliance or want to tighten your internal controls as a result of renewed focus on this area, there are software tools that you can utilize in concert with proper management of your internal processes, for reporting, auditing, and disclosure. In general, well thought-out applications can help you in your compliance efforts by making information more accessible and more transparent, and by highlighting anomalies.

A combination of accounting and BI-related reporting tools can serve as a vital part of your overall internal control compliance strategy. As you determine how to respond to the new challenges imposed by Sarbanes-Oxley, there is little doubt that much of your attention will be focused on managing, protecting, and reporting on the data that at some point passed through your accounting system.

One BI tool that can serve this process admirably is an "Alerts" solution that integrates with your accounting system. Using alerts and special triggers, your organization can automatically generate e-mails, launch reports, or generate system warnings without the need for human intervention.

While no software application alone will make you compliant, the right mix of accounting and BI applications can work in conjunction with your internal policies, compliance programs, and other technology investments to increase the transparency of financial events, ensure distribution of critical information in a timely manner, and provide the peace of mind you need on matters of security and access.

Guidelines for a High-Performance, Low-Cost BI Solution
Let's take a closer look at what really matters to small and midsized businesses as far as investing in a BI solution. We contend that most SMB companies need little more than their MS Office Suite and a mix of affordable, easy-to-use BI tools. These tools can help you drill down to the key performance indicators which identify your strengths and weaknesses in operational performance, marketing, and sales-the key components to optimizing efficiency and profitability.

Equally important, the BI tools you implement must be easy to use and learn and must be able to present data in a way that everyone can understand. If you have access to BI tools that can convert all of your key performance data into easy-to-understand terms that management can fully grasp, you have a tremendous opportunity to boost bottom-line performance and overall profitability.

Conversely, if your proposed BI solution is hard to grasp, it likely won't contribute much to your objective of locating and analyzing key, actionable data that can help your business run smarter. Whatever solution you choose, make sure that all of you can figure out how to get the most out of it without needing a PhD. This cannot be overemphasized!

Key Components of a Cost-Effective BI Solution
As you contemplate a cost-effective BI solution for your company, you should make sure that the integrated software delivers most, if not all, of the functions listed below at a price point that fits your company's budget:

Alerts: Alerts provide crucial monitoring, proactive notification, and automation capabilities that help your company adapt to changing conditions and avoid alarming scenarios pertaining to payables, receivables, budgets, sales, and inventory. With alerts functionality in place, you can pre-set a wide variety of benchmarks in all of these areas and protect yourself from missing key time- or date sensitive events or failing to respond to deviations from acceptable levels.

Inquiry: Having an easy-to-use inquiry tool enables you to drill down into a specific area and quickly extract data that is essential to your business. For example, if you need to examine sales trends by region over the last 12 months, identify the top 5 customers for the quarter, or locate the top 10 bestselling items for the last month, this type of BI tool will serve you well.

Multi-dimensional analysis tool: SMB companies want the ability to bring in data from multiple locations and still be able to see a unified macro view of the entire enterprise. Analysis software should help you achieve this goal - providing a quick snapshot of your business and enabling you to drill down into sales and purchasing trends, as well as perform budget analysis. Some of these solutions offer Dashboards - The term "dashboard" has become omnipresent in the ever expanding BI lexicon. An effective dashboard is a graphical snapshot of your business's health that is easy to understand. Some common categories of data (often from Excel) feeding the dashboard are revenues by period, product sales by category, actual vs. budgeted financial indicators, and expenses by category, just to name a few. The good news is that you can take full advantage of affordable BI solutions that offer this type of functionality.

If your proposed BI solution is hard to grasp, it likely won't contribute much to your objective of locating and analyzing key, actionable data that can help your business run smarter

Quick KPIs: Whether analyzing business performance vs. another company or between divisions within your company, quick access to key performance indicators enables you to see how your business is measuring up at any moment in time. This type of solution should possess the capability to compare financial models and actual performance vs. budget and forecast numbers for different time periods. In addition, it should enable you to quickly establish benchmarking of results vs. competitors over varying time periods. Finally, you should be able to export any KPI report or model to Microsoft Excel or Word.

Graphical presentations of data: Viewing data in graphical format makes the process of analyzing performance much quicker and easier. Make sure that your BI solution incorporates customizable graphical views of your data in grid, pivot table, and interactive chart formats. This should be a standard feature, not an accessory.

Flexible reporting capabilities: The ability to create and generate reports (including exception reports) that accurately reflect your company's key performance data is crucial as is the ability to customize these reports and display them graphically, if needed. In addition, you should be able to export these reports to an Excel worksheet or include Excel spreadsheet data in these reports.

Remote access: Most decision-makers conduct a significant portion of their business while out of the office. So, it is essential that they have remote access to a wide range of their company's vital business data any time they want via the Internet. Make sure your BI solution enables you to access your KPI's such as sales, product and customer analyses, income and balance sheets, and inventory reports whenever you are out of the office.

Report automation: In order to stay ahead of the competition, most SMB companies can't afford to sit back and wait for their IT or accounting departments to provide the information they need to make informed decisions. They must be proactive in automating their entire reporting process - from creation to generation to distribution of reports across the entire enterprise. Armed with streamlined, high volume reporting, these companies are equipped to respond to ever-changing market conditions and make the best possible decisions that impact the health of their business.

More Stories By Jean Huy

Jean Huy is a senior director of product marketing for Sage North America. In his duties, Huy leads marketing strategy and go-to-market activities related to the launch and growth of Sage business solutions in the Mid-Market, including ERP and CRM products, cloud services and complementary solutions in the Sage portfolio or ecosystem.

Prior to his current position, Huy served as director of product marketing for Sage North America where he led market analysis, product strategy, product requirements and positioning of the Sage ERP X3 software product in North America as member of the global product committee. Additionally, Huy managed the launch and go-to-market activities of Sage ERP X3 in the North American market while developing innovative marketing programs and sales tools to support double digit revenue growth. Huy earned an MBA in marketing communications from the Reims Management School in Reims, France.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.

@MicroservicesExpo Stories
DevOps is being widely accepted (if not fully adopted) as essential in enterprise IT. But as Enterprise DevOps gains maturity, expands scope, and increases velocity, the need for data-driven decisions across teams becomes more acute. DevOps teams in any modern business must wrangle the ‘digital exhaust’ from the delivery toolchain, "pervasive" and "cognitive" computing, APIs and services, mobile devices and applications, the Internet of Things, and now even blockchain. In this power panel at @...
The best way to leverage your Cloud Expo presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering Cloud Expo and @ThingsExpo will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at Cloud Expo. Product announcements during our show provide your company with the most reach through our targeted audiences.
@DevOpsSummit has been named the ‘Top DevOps Influencer' by iTrend. iTrend processes millions of conversations, tweets, interactions, news articles, press releases, blog posts - and extract meaning form them and analyzes mobile and desktop software platforms used to communicate, various metadata (such as geo location), and automation tools. In overall placement, @DevOpsSummit ranked as the number one ‘DevOps Influencer' followed by @CloudExpo at third, and @MicroservicesE at 24th.
As software becomes more and more complex, we, as software developers, have been splitting up our code into smaller and smaller components. This is also true for the environment in which we run our code: going from bare metal, to VMs to the modern-day Cloud Native world of containers, schedulers and microservices. While we have figured out how to run containerized applications in the cloud using schedulers, we've yet to come up with a good solution to bridge the gap between getting your conta...
Without lifecycle traceability and visibility across the tool chain, stakeholders from Planning-to-Ops have limited insight and answers to who, what, when, why and how across the DevOps lifecycle. This impacts the ability to deliver high quality software at the needed velocity to drive positive business outcomes. In his session at @DevOpsSummit 19th Cloud Expo, Eric Robertson, General Manager at CollabNet, will show how customers are able to achieve a level of transparency that enables everyon...
DevOps theory promotes a culture of continuous improvement built on collaboration, empowerment, systems thinking, and feedback loops. But how do you collaborate effectively across the traditional silos? How can you make decisions without system-wide visibility? How can you see the whole system when it is spread across teams and locations? How do you close feedback loops across teams and activities delivering complex multi-tier, cloud, container, serverless, and/or API-based services?
Today every business relies on software to drive the innovation necessary for a competitive edge in the Application Economy. This is why collaboration between development and operations, or DevOps, has become IT’s number one priority. Whether you are in Dev or Ops, understanding how to implement a DevOps strategy can deliver faster development cycles, improved software quality, reduced deployment times and overall better experiences for your customers.
So you think you are a DevOps warrior, huh? Put your money (not really, it’s free) where your metrics are and prove it by taking The Ultimate DevOps Geek Quiz Challenge, sponsored by DevOps Summit. Battle through the set of tough questions created by industry thought leaders to earn your bragging rights and win some cool prizes.
SYS-CON Events announced today that Super Micro Computer, Inc., a global leader in Embedded and IoT solutions, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 7-9, 2017, at the Javits Center in New York City, NY. Supermicro (NASDAQ: SMCI), the leading innovator in high-performance, high-efficiency server technology, is a premier provider of advanced server Building Block Solutions® for Data Center, Cloud Computing, Enterprise IT, Hadoop/Big Data, HPC and ...
Without lifecycle traceability and visibility across the tool chain, stakeholders from Planning-to-Ops have limited insight and answers to who, what, when, why and how across the DevOps lifecycle. This impacts the ability to deliver high quality software at the needed velocity to drive positive business outcomes. In his general session at @DevOpsSummit at 19th Cloud Expo, Eric Robertson, General Manager at CollabNet, will discuss how customers are able to achieve a level of transparency that e...
“Being able to take needless work out of the system is more important than being able to put more work into the system.” This is one of my favorite quotes from Gene Kim’s book, The Phoenix Project, and it plays directly into why we're announcing the DevOps Express initiative today. Tracing the Steps. For years now, I have witnessed needless work being performed across the DevOps industry. No, not within our clients DevOps and continuous delivery practices. I have seen it in the buyer’s journe...
SYS-CON Events announced today that LeaseWeb USA, a cloud Infrastructure-as-a-Service (IaaS) provider, will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. LeaseWeb is one of the world's largest hosting brands. The company helps customers define, develop and deploy IT infrastructure tailored to their exact business needs, by combining various kinds cloud solutions.
In many organizations governance is still practiced by phase or stage gate peer review, and Agile projects are forced to accommodate, which leads to WaterScrumFall or worse. But governance criteria and policies are often very weak anyway, out of date or non-existent. Consequently governance is frequently a matter of opinion and experience, highly dependent upon the experience of individual reviewers. As we all know, a basic principle of Agile methods is delegation of responsibility, and ideally ...
A completely new computing platform is on the horizon. They’re called Microservers by some, ARM Servers by others, and sometimes even ARM-based Servers. No matter what you call them, Microservers will have a huge impact on the data center and on server computing in general. Although few people are familiar with Microservers today, their impact will be felt very soon. This is a new category of computing platform that is available today and is predicted to have triple-digit growth rates for some ...
SYS-CON Events announced today that SoftNet Solutions will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. SoftNet Solutions specializes in Enterprise Solutions for Hadoop and Big Data. It offers customers the most open, robust, and value-conscious portfolio of solutions, services, and tools for the shortest route to success with Big Data. The unique differentiator is the ability to architect and ...
SYS-CON Events announced today that Enzu will exhibit at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Enzu’s mission is to be the leading provider of enterprise cloud solutions worldwide. Enzu enables online businesses to use its IT infrastructure to their competitive advantage. By offering a suite of proven hosting and management services, Enzu wants companies to focus on the core of their online busine...
Enterprise IT has been in the era of Hybrid Cloud for some time now. But it seems most conversations about Hybrid are focused on integrating AWS, Microsoft Azure, or Google ECM into existing on-premises systems. Where is all the Private Cloud? What do technology providers need to do to make their offerings more compelling? How should enterprise IT executives and buyers define their focus, needs, and roadmap, and communicate that clearly to the providers?
Analysis of 25,000 applications reveals 6.8% of packages/components used included known defects. Organizations standardizing on components between 2 - 3 years of age can decrease defect rates substantially. Open source and third-party packages/components live at the heart of high velocity software development organizations. Today, an average of 106 packages/components comprise 80 - 90% of a modern application, yet few organizations have visibility into what components are used where.
SYS-CON Events announced today that Sheng Liang to Keynote at SYS-CON's 19th Cloud Expo, which will take place on November 1-3, 2016 at the Santa Clara Convention Center in Santa Clara, California.
If you are within a stones throw of the DevOps marketplace you have undoubtably noticed the growing trend in Microservices. Whether you have been staying up to date with the latest articles and blogs or you just read the definition for the first time, these 5 Microservices Resources You Need In Your Life will guide you through the ins and outs of Microservices in today’s world.