Gartner predicts that by 2017, more than 30 per cent of enterprise access to broadly based big data will be via intermediary data broker services. Many of these proprietary databases come with their own visualization tool. But what if you want to put some of this data into the context of your business? How can you do analyses that incorporate both purchased data and data from your financial and operational systems?
Combining Big Data with Your Company Data
BIO Business Intelligence is a complete business intelligence solution, which means that it includes a full-featured data warehouse. BIO has out of the box connectors for ERPs like Microsoft Dynamics GP and many of our clients use BIO to consolidate multiple ERP databases and other on-premises data like CRM and operational databases. While BIO is not a big data solution, per se, it is built on SQL Server and Analysis Services (SSAS), so it won’t hiccup if you add a bunch of representative data from your purchased database to the BIO data warehouse, making it possible to include purchased data to find trends, correlations, and dependencies in the consolidated data. Looking at your data together gives you a 360-degree view of your company that will enhance your understanding of your business, your customers, your markets, your partners, and your competitors and allow you to make data-backed decisions.
The data analysts in your company (whether or not that is their title) are able to use BIO’s sophisticated visualization front-end for data discovery, which can range from an unstructured “walk-about” in the data to a very structured process to uncover the information buried in the data. Data discovery, or finding “the story” hidden in your data, requires interactive, self-service access with the ability to easily manipulate the data—drill down, aggregate, and mask the data, look at alternate roll-ups, create new visualizations—so you can exploit your data resources. BIO lets you drag and drop to change columns or rows, change selection criteria, and re-order data at the speed of thought. Change from reports to graphs in just one click. Dashboards and report tabs are context sensitive so when you change the data in one panel of the dashboard or one open report, all of the rest change as well, making it easy to get different views of data across different aspects of your business.
Share Big Data Discoveries
BIO also lets you collaborate with others as you analyze and experience those eureka moments. You can create reports and views and save them for other users and attach notes. As others use the interactive reports, they will be populated with the most current data (unless other parameters are used). This makes it easy to share results and work together toward a common goal. And users do not need to have IT training or a heavy mathematics background to use BIO—it is designed so that even the most “non-technical” user can get up to speed in hours or even minutes.
But what if all of your analysts are thoroughly familiar with some other viewer and don’t want to learn the BIO front-end? Not a problem. Although BIO comes with an advanced front-end visualization tool, it can be replaced with just about any other tool, even Excel. And BIO does not make you pay for connections to tools you already have.
Take a look and see how representative big data can be consolidated with your company data with BIO Business Intelligence. Join BIO for a free business intelligence webinar. And please contact me at 203.705.4648 or by email at firstname.lastname@example.org if you have any questions about BIO or business intelligence in general.
Read the Gartner article.
By Sandi Richards Forman of BIO Analytics, Corp., Microsoft Dynamics Business Intelligence (BI) Solution Provider