All Analytics Academy
The Internet of Things Joins the Enterprise

Jun 9 - Jun 23
Join 5 interactive classes & chat with peers
 
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   >   >>
Information Resources
More Blogs from Pierre DeBois
Some organizations are making early progress in capturing information in the Dark Social world of apps.
Vetting referral traffic is becoming essential to ensure accuracy and, in some instances, security.
Mobile moves to the forefront in analytics and Google's search algorithm plans, and that means you have to think about how your website's architecture serving the needs of the mobile world. Take a peek at what Google plans for April.
Data scientists are discovering R programming as an augment in data visualization and analysis.
Analytics solutions are making cohort analysis easier to implement, and customers easier to discover.
Radio Show
Radio Shows
UPCOMING
James M. Connolly
Finding Answers Through Prescriptive Analytics


7/21/2015   REGISTER   0
UPCOMING
James M. Connolly
Health Analytics: Find Data Beyond the Hospital Doors


7/28/2015   REGISTER   0
ARCHIVE
James M. Connolly
Visualization: How to Bring Data to Life


6/22/2015  LISTEN   55
ARCHIVE
James M. Connolly
Learn Why Analytics Are at Home in the Cloud


6/15/2015  LISTEN   26
ARCHIVE
James M. Connolly
Analytics: Your Defense Against Cyber Threats


5/27/2015  LISTEN   60
ARCHIVE
James M. Connolly
Big Data & Big Pharma: How Analytics Might Save Your Life


5/19/2015  LISTEN   37
ARCHIVE
James M. Connolly
Live Interviews From SAS Global Forum


4/28/2015  LISTEN   11
ARCHIVE
James M. Connolly
How to Hire Great Analytics Talent


4/23/2015  LISTEN   51
ARCHIVE
James M. Connolly
Sports Analytics Mean Fun and Business


3/24/2015  LISTEN   3
ARCHIVE
James M. Connolly
Secure Your Big Data in the Cloud


2/26/2015  LISTEN   114
ARCHIVE
James M. Connolly
Make It Big As a Data Scientist in 2015


2/11/2015  LISTEN   106
ARCHIVE
James M. Connolly
Big Data, Decisions & the Simulated Experience


2/3/2015  LISTEN   87
Information Resources
Quick Poll
Quick Poll
Infographic
Infographic
It Pays to Keep Insurance Fraud in Check
While 97% of insurers say that insurance fraud has increased or remained the same in the past two years, most of those companies report benefits from anti-fraud technology in limiting the impact of fraud, including higher quality referrals, the ability to uncover organized fraud, and improve efficiency for investigators.
Follow us on Twitter
Follow us on Twitter
Like us on Facebook
Like us on Facebook
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS