IBM Watson Analytics preps the data so you don't have to

The new IBM Watson Analytics promises to remove many of the headaches around data cleansing and analysis

Given a set of data, with descriptive column headers, IBM Watson Analytics can generate a set of visualizations showing possible trends of interest
Given a set of data, with descriptive column headers, IBM Watson Analytics can generate a set of visualizations showing possible trends of interest

With the newest commercial service to spring from its highly publicised Watson cognitive computing initiative, IBM is attempting to streamline the process of analysing data so business managers can pull insights from data sets without the help of IT experts.

"Often what business users do is rely on a data scientist or business analysts to help them, which can be too slow, or those people may not be available. So they make a decision without any analysis," said Eric Sall, IBM vice president of marketing for business analytics.

The new service, IBM Watson Analytics, launched as an invitational beta trial, can walk the user through data analysis by way of a series of interactive steps. In an event in New York Tuesday, the company demonstrated how the service would work.

The service can upload data, cleanse it, understand the user's requirements through an interactive natural language query session and then produce a range of analysis and accompanying visualisations that may be of interest.

"It's the full range of analytical capabilities integrated together in one user experience," Sall said in an interview before the launch event.

The service is powered by a set of different IBM analysis technologies, such as Cognos and SPSS, and adds some machine learning capabilities from the Watson project.

In a series of presentations, IBM showed how Watson Analytics could be used. None of the demonstrations were live; the audience was shown screen shots taken before the presentation. But they offered a glimpse of how the technology, which IBM is still refining, would work.

As a first step, the user uploads a Comma Separated Values (CSV) or Excel Binary File Format (XLS) flat file to the service. A CSV file can easily be extracted from a spreadsheet or a database table. The data values are separated by commas and each column of data has a name, usually given to it by the administrator who created the table or spreadsheet.

Watson first analyses the file to estimate the quality of the data. A data set may have missing values, or be too small to draw meaningful conclusions from. Certain columns may not have any statistical interest -- they all may have the same value for instance. Watson offers an overall score of the cleanliness of the data, as well as how much potentially interesting analysis could be derived from the set.

The service will then examine the data set for any interesting correlations that may be occurring, and look for more obscure second-order effects that someone looking at a spreadsheet may miss.

In effect, Watson Analytics runs through the data and prepares visualisations for all the possible relations among the data elements, emphasising those that might be of most interest to the user. The user can then click on the charts of interest, and Watson makes notes of what its users are looking for.

It offers both basic analysis and predictive analysis, where it can make guesses at future behavior based on metrics of past behavior.

This is not to say the Watson does all the work of analysing the data. Helping Watson understand the data requires that all the column rows be descriptively named. The set-up process also requires domain experts to identify those columns that they are most interested in learning more about, to prevent Watson from endlessly churning up relations of little interest.

During a customer panel at the event, a number of data scientists and business intelligence system managers expressed optimism for the new offering.

Justin Croft, manager for brand platforms and analytics for U.S. wireless communication provider C Spire, noted that this service could be immediately useful to the company's sales and marketing staff, who could use it to ferret out reasons why there may be a spike or dip in sales volumes. Typically, the staff may have "far more questions than there is time to track down the answers," he said.

Though IBM is marketing the service directly to end users, it can also be embedded in other enterprise software. SugarCRM, electronics distributor AVNET, and Truven Health Care analytics have all shown an interested in folding Watson capabilities into their own offerings

IBM itself is folding Watson Analytics into another, as-of-yet unnamed cloud service for its Smarter Workforce portfolio that it plans to launch later this month for human resource (HR) departments. Among the features offered by this service is a Watson Analytics powered service allowing HR professionals to ask questions about information typically captured by HR offices.

A demo showed how someone, for instance, could look for drivers of attrition -- why employees are leaving a company.

A company may keep a spreadsheet of workers employed in 2014 and what departments they belong to, along with a column indicating whether or not each employee is still with the company. Other columns may capture additional factors such as the geographic location of the employees, number of hours each employee worked and so on.

Watson will automatically create a chart of the number of people who have left per department, such as sales or testing, as well as charts that show the number departed employees by other factors as well, such as all the departures in each geographic region.

Watson Analytics also has a learning component that will able to build an ontology, or thesaurus, based on user input. If users enter the phrase "employees who quit or were fired" and then click on the data sets built around the attrition column, the service will come to equate the term "attrition" with the terms "quit" and "fired," and will offer the attrition information more readily in future searches with the words "quit" or "fired."

In the hypothetical example IBM provided, the data showed that one department, testing, had a higher turnover of employees, proportionally, than any other department. While this information could be fairly easily garnered from the spreadsheet itself, Watson Analytics was also able to call up information on how many overtime hours that each employee in testing worked, a correlation not so readily observable by a visual scan of the spreadsheet.

In this example, testing employees clocked far more overtime hours than the average for the company, and the heavy workload could be seen a prime culprit for the departures.

Watson Analytics is the latest move in IBM's US$1 billion initiative to commercialise Watson technologies.

IBM Research developed Watson to compete with human contestants on the "Jeopardy" game show in 2011, using natural language processing and analytics, as well as many sources of structured and unstructured data, to formulate responses to the show's questions.

In the years since, the company has been working to commercialise the Watson technology by identifying industries that could benefit from this form of cognitive computing, such as health care, law enforcement and finance.

IBM expects that Watson Analytics will go live by the end of November. Then, the service can be used at no cost, for up to a certain number of data sources (the exact number IBM has still to determine). IBM will charge for using the service with additional data sources.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.
Show Comments

Latest Videos

More Videos

More Brand Posts

What are Chris Riddell's qualifications to talk about technology? What are the awards that Chris Riddell has won? I cannot seem to find ...

Tareq

Digital disruption isn’t disruption anymore: Why it’s time to refocus your business

Read more

Enterprisetalk

Mark

CMO's top 10 martech stories for the week - 9 June

Read more

Great e-commerce article!

Vadim Frost

CMO’s State of CX Leadership 2022 report finds the CX striving to align to business outcomes

Read more

Are you searching something related to Lottery and Lottery App then Agnito Technologies can be a help for you Agnito comes out as a true ...

jackson13

The Lottery Office CEO details journey into next-gen cross-channel campaign orchestration

Read more

Thorough testing and quality assurance are required for a bug-free Lottery Platform. I'm looking forward to dependability.

Ella Hall

The Lottery Office CEO details journey into next-gen cross-channel campaign orchestration

Read more

Blog Posts

Marketing prowess versus the enigma of the metaverse

Flash back to the classic film, Willy Wonka and the Chocolate Factory. Television-obsessed Mike insists on becoming the first person to be ‘sent by Wonkavision’, dematerialising on one end, pixel by pixel, and materialising in another space. His cinematic dreams are realised thanks to rash decisions as he is shrunken down to fit the digital universe, followed by a trip to the taffy puller to return to normal size.

Liz Miller

VP, Constellation Research

Why Excellent Leadership Begins with Vertical Growth

Why is it there is no shortage of leadership development materials, yet outstanding leadership is so rare? Despite having access to so many leadership principles, tools, systems and processes, why is it so hard to develop and improve as a leader?

Michael Bunting

Author, leadership expert

More than money talks in sports sponsorship

As a nation united by sport, brands are beginning to learn money alone won’t talk without aligned values and action. If recent events with major leagues and their players have shown us anything, it’s the next generation of athletes are standing by what they believe in – and they won’t let their values be superseded by money.

Simone Waugh

Managing Director, Publicis Queensland

Sign in