REGISTER   |   LOGIN   |   HELP
Home  |  Blogs  |  Message Boards  |  Webinars  |  Resources |  By Channel
Pierre DeBois

Clean Data Made Easy With Free Tools

View Comments: Newest First | Oldest First | Threaded View
Page 1 / 3   >   >>
Pierre DeBois
User Rank
Blogger
Re: Master source
Pierre DeBois   2/7/2012 6:40:04 AM
NO RATINGS
Hi Daniel,

Exactly right  - Refine is a desktop solution viewed through a broswer, so given Google's past with its products, usage can seem like its online (The user downloads the program).  Data Wrangler is online, provided vis Stanford U.

I am seeing other products that operate with a private cloud aspect - it will be interesting to see how this niche develops.  It reminds me of BMW and how it has tried to cover a number of niches within their product lines.  We seem to be in the era of addressing a niche, with inspiration on and offline. :-)

Pierre DeBois
User Rank
Blogger
Re: Master source
Pierre DeBois   2/7/2012 6:34:40 AM
NO RATINGS
Shawn,

You're right. Tools like Data Wrangler and Google Refine can empower.  These tools are essentially adhoc in purpose, so there's an implication within organizations to communicate with care, ensuring that information discoverded from their usage is shared.

Daniel
User Rank
Data Doctor
Re: Master source
Daniel   2/1/2012 12:18:39 AM
NO RATINGS
1 saves
Pierre, you mean in user computer. Sorry, I thought it's just like other Google cloud based online products (Doc's, health etc).

Shawn Hessinger
User Rank
Blogger
Re: Master source
Shawn Hessinger   1/31/2012 9:34:20 PM
NO RATINGS
Hi Pierre,

These tools definitely sound interesting. I know some get antsy about BI-as-a-service being readily available, but I've always believed that more information empowers. It sounds like these technologies are just the thing to place more BI power in the hands of all employees for the benefit of an entire organization.  

Pierre DeBois
User Rank
Blogger
Re: Master source
Pierre DeBois   1/31/2012 8:46:47 PM
NO RATINGS
Hi Daniel,

The files created can be exported, so the table created can be ported.  For Google Refine, the application resides on the computer, even though you are using a browser for the interface, so there is not portability for the application.

BethSchultz
User Rank
Blogger
Re: different tools
BethSchultz   1/30/2012 10:49:07 AM
NO RATINGS
I would have to agree, Maryam. That's one of the worries I have when we start talking about easy accessibly of BI-as-a-service offerings.

BethSchultz
User Rank
Blogger
Re: Master source
BethSchultz   1/30/2012 10:46:20 AM
NO RATINGS
Joe, when you suggest there be "one final arbiter 'handling' the data in a uniform way" are you thinking along the lines of creating a master file/single source of truth, as I talk about in this recent blog about master data management? Or did you have something less formalized in mind for this level of data/tool/user?

kicheko
User Rank
Blogger
Re: Master source
kicheko   1/30/2012 5:24:30 AM
NO RATINGS
One article points out that upto 80 percent of data analysis efforts are spent on cleaning the data. In light of this he proposes data marketplaces as a means of obtaining common data. Something i agree with as a way of reducing data cleaning effort as a whole and leaving it for some firms to specialize.

However when push comes to shove and you really must collect the data yourself from raw source, such tools as google refine come in handy. The positive thing is that the learning curve for Google tools is not too steep, enabling even companies with a limited budget for analytics experts to handle a good chunk of their analytics by themselves

Daniel
User Rank
Data Doctor
Re: Master source
Daniel   1/30/2012 5:23:11 AM
NO RATINGS
1 saves
Pierre, I would like to know, whether such open source tools are portable, I mean import and export to different environments and analytical tools.

tinym
User Rank
Data Doctor
Thanks
tinym   1/29/2012 11:51:12 PM
NO RATINGS
Thanks for posting this Pierre. I didn't know there were free tools available that were also easy to use.

Page 1 / 3   >   >>
More Blogs from Pierre DeBois
Is there a movement towards consolidation among analytic vendors, or is this a time of second-coming growth of analytics?
Training citizens in an intelligence study pits human intuition against statistic models, and the results demonstrate the collective value of an analytical environment.
With enhanced campaigns, digital marketers can get more granular in how they analyze search strategy success.
The need to optimize page loads, especially on mobile devices, is spurring the use of open-source scalable databases.
Platform vendor Bottlenose offers a slick tool for marketers and other social media listeners.
Digital Audio
Latest Archived Broadcast
If anybody knows how to finesse predictive insight out of data, it's this A2 Radio guest, John Elder, founder and president of Elder Research. Tune in Wednesday, Oct. 15, at 3:00 p.m. ET.
October 30th 2pm EDT Thursday
Quick Poll
Readerboards
Have a question or topic but don't want to write a blog? Post it on our readerboards and get feedback from the community!
MORE READERBOARDS
AllAnalytics on Twitter
AllAnalytics Twitter Feed
AllAnalytics House Ad
Upcoming Events
for the Business and IT Communities
Executive forums with additional hands-on learning opportunities offered around the world
Each ideal for practitioners, Business leaders & senior executives
Visual Dashboards for Self-Service BI
TDWI Webinar with analyst, Cindi Howson
2014 VA Interactive Roadshow -- Boston
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
Nov. 4, 2014
Boston, Massachusetts
Data Exploration & Visualization
Get hands-on training that focuses on the critical steps in the process of analyzing data: accessing and extracting data, cleaning and preparing data, exploring and visualizing data. This INFORMS course will use several of the most popular software tools intensively, and provide an overview of the range of software options.
Nov. 7-8, 2014
San Francisco, CA
Foundations of Modern Predictive Analytics
In this INFORMS course, learn about modern predictive analytics, the science of discovering and exploiting complex data relationships. This course will give participants hands-on practice in handling real data types, real business problems and practical methods for delivering business-useful results.
Nov. 7-8, 2014
San Francisco, CA
2014 VA Interactive Roadshow -- Atlanta
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
Dec. 11, 2014
Atlanta, Georgia
AllAnalytics Video Blogs
Canada Post on Data Delivery
James Smith, lead of enterprise data governance for ...

02:53

2 comments
Big Data Checks In
Roger Ares, vice president of analytics at Hyatt ...

03:45

5 comments
Good Data, Smarter Travel
iJET International's Rich Murnane, Director of ...

2:50

4 comments
Healthcare Data Needs a ...
Tackling healthcare data management challenges ...

2:39

0 comments
In the Talent Sweet Spot
Gen Y shapes the new analytics workforce.

3:25

0 comments
A2 on the Road
What we found at last month's SAS Global Forum 2014.

2:28

0 comments
T-Mobile Hears Data's Call
Internal customer data provides an analytics ...

2:50

0 comments
A Is for Analytics in Academia
Professors and students agree that access to ...

4:11

0 comments
Advocating for Analytics ...
Analytics and business experts explore what it ...

5:51

0 comments
Analytic Myths: True or False?
Analytics experts give us their perspective on four ...

4:29

0 comments
We'll Be Your Eyes & Ears
We'll be on the scene at SAS Global Forum events in ...

2:15

0 comments
7 Tips for Deploying ...
We chat with Analise Polsky, a data visualization ...

33:15

0 comments
Top Big Data Platforms
All Analytics editors Beth Schultz and Michael ...

31:53

3 comments
Attention on Retail Shoppers
The retail store of the future will track customers ...

02:14

16 comments
Demand-Driven Forecasting
Charles Chase, chief industry consultant for the ...

02:22

1 comment
Live Video
On-demand Video with Chat
As retailers evolve toward an omnichannel environment, much of their success will depend on how effectively they use big-data and analytics.
AllAnalytics Videos
Intro to Visual Analytics
Find a way to visualize your data and watch it come ...

1:58

0 comments
Visual Analytics, Instant ...
Analytics results delivered in visual form are ...

2:06

5 comments
Big Data, Fast Infrastructure
Big data calls for a high-performance analytics ...

3:35

6 comments
Red Hot Analytics
Jayson Tipp, Redbox VP of Analytics and CRM, ...

3:51

7 comments
Hotelier Checks Out Analytics
InterContinental Hotels Group has woven analytics ...

06:55

11 comments
Like Us on Facebook
Point/CounterpointBlog
LEADERS FROM THE BUSINESS AND IT COMMUNITIES DUEL OVER CRITICAL TECHNOLOGY ISSUES

The Current Discussion

Visual Analytics: Who Carries the Onus?
The Issue: Data visualization is an up-and-coming technology for businesses that want to deliver analytical results in a visual way, enabling analysts the ability to spot patterns more easily and business users to absorb the insight at a glance and better understand what questions to ask of the data. But does it make more sense to train everybody to handle the visualization mandate or bring on visualization expertise? Our experts are divided on the question.
The Speakers: Hyoun Park, Principal Analyst, Nucleus Research; Jonathan Schwabish, US Economist & Data Visualizer
MORE POINT/COUNTERPOINT BLOGS
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS


Beth Schultz
Canada Post on Data Delivery

5|12|14   |   02:53   |   (2) comments


James Smith, lead of enterprise data governance for the Canadian postal service, explains how and why the organization has embraced an enterprise data governance program.
Michael Steinhart
Big Data Checks In

4|30|14   |   03:45   |   (5) comments


The hospitality industry gathers massive amounts of customer data, and mining that data effectively can yield tremendous results in terms of improved CRM, better-targeted marketing spend, and more efficient back-end processes. Roger Ares, vice president of analytics at Hyatt Corp., discusses the ways he and his staff use big data.
Beth Schultz
Good Data, Smarter Travel

4|24|14   |   2:50   |   (4) comments


Charged with keeping track of travel assets, including employees, iJET International relies on data management best-practices and advanced analytics to keep its clients in the know on current and potential world events affecting travel, Rich Murnane, Director of Enterprise Data Operations & Data Architect, told All Analytics in an interview from the 2014 SAS Global Forum Executive Conference.
Beth Schultz
Healthcare Data Needs a Booster

4|23|14   |   2:39   |   (0) comments


W. Ed Hammond, Director of the Duke Center for Health Informatics, spoke from the recent 2014 SAS Global Forum Executive Conference about the data management challenges involved in healthcare today.
Beth Schultz
In the Talent Sweet Spot

4|23|14   |   3:25   |   (0) comments


Jason Dorsey, chief strategy officer for the Center for Generational Kinetics and keynote speaker at last month's SAS Global Forum 2014, describes how Gen Y professionals are enhancing the makeup of multigenerational analytics organizations.
Beth Schultz
A2 on the Road

4|22|14   |   2:28   |   (0) comments


From analytics talent development to the power of visual analytics, All Analytics found a variety of common themes circulating throughout the exhibition floor and session discussions at the 2014 SAS Global Forum and SAS Global Forum Executive Conference events held last month in Washington, DC.
Beth Schultz
T-Mobile Hears Data's Call

4|22|14   |   2:50   |   (0) comments


Talking with All Analytics live from the 2014 SAS Global Forum Executive Conference, Eric Helmer, senior manager of campaign design and execution for T-Mobile, discussed the importance of customer data -- starting internally -- in devising the mobile operator's marketing plans.
Beth Schultz
A Is for Analytics in Academia

4|21|14   |   4:11   |   (0) comments


Interviewed live at SAS Global Forum 2014, professors and students agree that access to enterprise analytics software in academic programs better prepares graduates for their careers.
Beth Schultz
Advocating for Analytics Culture

4|21|14   |   5:51   |   (0) comments


Speaking at the recent SAS Global Forum Executive Conference, analytics executives, business experts, and SAS insiders explore what it means to build an analytics culture.
Beth Schultz
Analytic Myths: True or False?

4|21|14   |   4:29   |   (0) comments


At the recent 2014 SAS Global Forum Executive Conference, five analytics experts give us their perspective on whether four common myths about IT and analytics are true or false.
Beth Schultz
We'll Be Your Eyes & Ears

3|20|14   |   2:15   |   (0) comments


We'll be on the scene at SAS Global Forum events in Washington, D.C., March 23 to March 25, glad to share what we learn with our community members.
Beth Schultz
7 Tips for Deploying Visualization

3|7|14   |   33:15   |   (0) comments


We chat with Analise Polsky, a data visualization thought leader on the SAS Best Practices team, about what you need to know before you deploy data visualization.
Michael Steinhart
Choosing a Big-Data Analytics Platform

2|19|14   |   31:53   |   (3) comments


The big-data analytics market can be a confusing place. Among the vendors vying for your dollars are traditional database management providers, Hadoop startup services, and IT giants. In this video, All Analytics editors Beth Schultz and Michael Steinhart sit down in a Google+ Hangout on Air with Doug Henschen, executive editor of InformationWeek. Henschen discusses use cases for big-data analytics, purchase considerations, and his recent roundup of the top 16 big-data analytics platforms.

Related posts:

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Michael Steinhart
Keeping a Close Eye on Shoppers

2|13|14   |   02:14   |   (16) comments


At the National Retail Federation BIG Show last month, All Analytics executive editor Michael Steinhart noted a host of solutions for tracking and analyzing customer activity in retail stores. From Bluetooth beacons to RFID tags to NFC connections to video analytics, retailers must find the right combination of tools to help optimize the shopper experience, streamline operations, and boost revenues.

Related posts:

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Michael Steinhart
Real-Time Demand Drives Forecasting

2|11|14   |   02:22   |   (1) comment


The days when historical shipment trends and gut feelings were enough to forecast retail demand accurately are long over. SAS chief industry consultant Charles Chase outlines the benefits of pulling real-time sales information from point-of-sale and product scanner systems, then flowing that data into dynamic forecasting tools from SAS.

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Videos
Intro to Visual Analytics

6|5|13   |   1:58   |   (0) comments


With today's advanced visual analytics tools, you can stream data into memory for real-time processing, provide users the ability to explore and manipulate the data, and bring your data to life for the business.
Videos
Visual Analytics, Instant Insight

5|16|13   |   2:06   |   (5) comments


Dynamic data visualizations let analysts and business users interact with the data, changing variables or drilling down into data points, and see results in a flash. Advance your use of data visualization with tools that support features like auto-charting, explanatory pop-ups, and mobile sharing.
Videos
Big Data, Fast Infrastructure

2|14|12   |   3:35   |   (6) comments


No doubt your enterprise is amassing loads of data for fact-based decision-making. Hand in hand with all that data comes big computational requirements. Can traditional IT infrastructure handle the increasing number and complexity of your analytical work? Probably not, which is why you need a backend rethink. Big data calls for a high-performance analytics infrastructure, as Fern Halper, a partner at the IT consulting and research firm, Hurwitz & Associates, discusses here.
Videos
Red Hot Analytics

1|10|12   |   3:51   |   (7) comments


Redbox's bright-red DVD kiosks are all but ubiquitous these days, located in more than 28,000 spots across the country. Jayson Tipp, Redbox VP of Analytics and CRM, provides an insider's look at how the company has accomplished its phenomenal nine-year growth.
Videos
Hotelier Checks In With Analytics

12|14|11   |   06:55   |   (11) comments


InterContinental Hotels Group (IHG), a seven-brand global hotelier, has woven analytics into the fabric of its operations. David Schmitt, director of performance strategy and planning, shares IHG's analytics story and his lessons learned.