We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

Blog: Wayne Eckerson Subscribe to this blog's RSS feed!

Wayne Eckerson

Welcome to Wayne's World, my blog that illuminates the latest thinking about how to deliver insights from business data and celebrates out-of-the-box thinkers and doers in the business intelligence (BI), performance management and data warehousing (DW) fields. Tune in here if you want to keep abreast of the latest trends, techniques, and technologies in this dynamic industry.

About the author >

Wayne has been a thought leader in the business intelligence field since the early 1990s. He has conducted numerous research studies and is a noted speaker, blogger, and consultant. He is the author of two widely read books: Performance Dashboards: Measuring, Monitoring, and Managing Your Business (2005, 2010) and The Secrets of Analytical Leaders: Insights from Information Insiders (2012).

Wayne is founder and principal consultant at Eckerson Group,a research and consulting company focused on business intelligence, analytics and big data.

October 2014 Archives

Informatica Targets Business Analysts With New Data Preparation Tool

In the good old days of data warehousing, the information technology (IT) department was king and business analysts were... well... locked out.

If business analysts needed more or different data than was in the data warehouse, a data mart, or a report, they had to beg and plead IT to create a data set for them. Often, they had to wait days, weeks, or months for a data dump, and in the meantime they scrambled to find crumbs of relevant data and piece it together using Microsoft Excel or Access. Not surprisingly, research shows that business analysts spend at least a third of their working hours finding, cleaning, merging, and aggregating data--a huge time and cost sink that most organizations don't recognize.

Power shift. Today, the balance of power has shifted from the IT department to business units and their analysts, who are more inclined to spend money on data and analytics. Subsequently, vendors have rushed to build and sell self-service tools to business analysts so they can more quickly and easily access, manipulate, analyze, and visualize data without IT's help or intervention.

Given the opportunity, startups are swarming the space, offering innovative self-service tools for every step in the analytic workflow. But established vendors are not far behind. They are jumping in to protect their flank and bring a modicum of governance to self-service tooling so that business analysts don't proliferate analytical silos that undermine data consistency that is near and dear to the IT department.

Empowerment with Governance

One such established vendor is Informatica, which recently shipped Springbok, a new Web-based, self-service data preparation or "data wrangling" tool for business analysts. Informatica has grown to a billion dollar software firm by selling data integration platforms and tools to the IT department. But recognizing the growing power of business users, Informatica now offers a self-service data integration tool that not only makes it easy for analysts to access, profile, clean, combine, aggregate, and share data, but provides a bridge between business analysts and the IT department, which can monitor data usage patterns and bake those data flows into Informatica's ETL tool PowerCenter, which would create data structures that give business analysts an even shorter path to the data they need.

More than some other data wrangling tools, Springbok makes it easy for analysts to connect to data sources and upload data. From there, the tool uses built-in intelligence to automatically profile the data and make suggestions for how to parse, combine, and aggregate the data, among other things, taking a lot of the guesswork and tedium out of preparing data for analysis.

Governance opportunities. Springbok tracks in sequential order every operation that an analyst applies to a data set and displays it in a dialogue box called a "recipe sheet". This makes it easy for the analyst retrace his steps with the click of a mouse and share his process with colleagues or the IT department. The IT department can use the analyst's data preparation logic to prototype PowerCenter programs, further accelerating the time to market for new data sets.

Creating a technical bridge between analysts and IT is a huge differentiator for Informatica in a marketplace that is teaming with data wrangling upstarts.

Pricing. Informatica offers a freemium version of Springbok that provides 20GB of storage and 15,000-row limit per month of imported data. For $25 a month, users get 40GB of storage and 100,000 rows per month, while the Professional edition supports 50GB of storage and 10 million rows and costs $60 per month.

For more information and try Springbok for free, click here.

Posted October 26, 2014 8:35 AM
Permalink | No Comments |

Buying business intelligence (BI) from Microsoft is a little like buying your child a mail-order bike for Christmas. When you open the box late Christmas eve, you see umpteen parts, nuts, bolts and various accessories that you quickly realize will take all night to assemble, if you are lucky.

Although Microsoft offers some very good BI capabilities, they are built into a number of different products (Excel, SQL Server, Sharepoint, etc.) and do not come as an integrated bundle. First, you need to purchase the right versions of each Microsoft product and then assign several developers to wire the BI capabilities of the products together to ensure a seamless user experience. So, although Microsoft doesn't charge for BI, it takes a lot of time and money to get a Microsoft BI implementation up and running, especially in an enterprise environment.

Fortunately, there is a BI product that takes the pain out of installing and using BI capabilities for Microsoft customers. Called BI Office Suite, the product from Pyramid Analytics provides a tightly integrated BI environment that supports reporting, dashboarding, analysis, visualization, and data mining. Using LDAP-based security and role-based permissioning, the product can be tailored to both casual and power users so companies only needs to purchase a single tool to meet everyone's reporting and analytical needs.

This is sweet news to many Microsoft customers, who comprise the vast majority of Pyramid Analytic's 450+ customers. And one notable customer is Microsoft, who purchased a division site license and recently appointed Pyramid as Managed Partner for a number of industry verticals (health, finance, federal). BI Office Suite strengthens the overall Microsoft BI stack especially in competitive situations with Tableau, Qlik, Cognos and other established BI vendors.

Built on the Microsoft stack with SQL Server Analysis Services as its core engine, BI Office Suite has branched beyond the Microsoft platform this year and now imports data into an in-memory cache from a host of databases and applications, from local files to relational and NoSQL databases, and applications, such as Salesforce.com. The product was built from the ground-up as a Web product, so there is no desktop software to install or maintain. The company recently introduced an HTML5 interface (replacing Silverlight) and a variety of hybrid mobile apps so that it runs on any device with automatic screen resizing.

Other key differentiators include a modular and scalable architecture with load balancing with both scale up and scale out functionality on clustered computers. It also offers server-based data modeling and manipulation (i.e. data wrangling), which means the models analysts build can be easily shared, reused and monitored. Finally, the product embeds the open source R language to support data mining operations under the covers.

For more information, see www.pyramidanalytics.com

Posted October 1, 2014 4:53 PM
Permalink | No Comments |