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.

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 |

Leave a comment

    
Search this blog
Categories ›
Archives ›
Recent Entries ›