Data visualization tool lets users flip for Hadoop

Let’s face it: Visualization is a numbers game. Every analytics software company has its own way of presenting the numbers.

Datameer Inc., which makes a suite that pulls, processes and visualizes data from Hadoop stores, has a new way of visualizing data in the middle of processing: In can be flipped from spreadsheet view to a graphic view at the push of a button.

By seeing certain data graphically problems can be spotted quickly before business analysts get what they think are polished numbers, said Karen Hsu, the company’s senior director of product marketing.

The capability is included in version 4.0 of Datameer, released this week.

After flipping a spreadsheet columns of numbers can appear graphically
After flipping a spreadsheet columns of numbers can appear graphically in Datameer 4.0

“What we’re trying to address in the 4.0  release is the challenge in workflow: People are spending up to 80 per cent of their time just doing data acquisition, management, data wrangling before they can visualize the data,” Hsu said in an interview.

“The challenge with the market today is there are multiple tools out there that address just a part of each workflow” — and most are designed for IT and not business analysts, and can’t visualize until that data processing has been done, which means she can’t see early that there might be dirty data.

For example, piles of customer data including name, address, age and sex looks innocuous. However, a small number of people might have filled out the column for “sex” wrong (or the machine reading software misread a form wrong.

Highlighting a column and pressing a Flip button makes the table flip as if it were showing the back of the page. But on the other side the number are in whatever graphic form the user wants — bar chart etc.

In that view it would be quickly obvious there are three bars for “sex,” so some data filtering has to be done before the final numbers are given to a business analyst to crunch.

If the data isn’t cleaned, the analyst may come to wrong conclusions.

Analysts can flip data after very integration, join and transformation. Other solutions only visualize data at the end of all transformations, Hsu said.

Through an optional Smart Analytics module for business analysts, users can also “flip” the spreadsheet to see an interactive visualization of the results from any advanced analytics, including decision trees, clustering, column dependencies and recommendations.

Datameer 4.0 will be available in Q2. It is sold in personal, workgroup and enterprise editions. It can be bought online or through Canadian partners including IBM and Dell.

Would you recommend this article?

Share

Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.


Jim Love, Chief Content Officer, IT World Canada

Featured Download

Howard Solomon
Howard Solomon
Currently a freelance writer, I'm the former editor of ITWorldCanada.com and Computing Canada. An IT journalist since 1997, I've written for several of ITWC's sister publications including ITBusiness.ca and Computer Dealer News. Before that I was a staff reporter at the Calgary Herald and the Brampton (Ont.) Daily Times. I can be reached at hsolomon [@] soloreporter.com

Featured Articles

Cybersecurity in 2024: Priorities and challenges for Canadian organizations 

By Derek Manky As predictions for 2024 point to the continued expansion...

Survey shows generative AI is a top priority for Canadian corporate leaders.

Leaders are devoting significant budget to generative AI for 2024 Canadian corporate...

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now