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
As we can learn from automakers like Ford, effective study of customer needs and activity generate data that can create a renaissance within any company.
As more content providers discover the programming value of YouTube, YouTube Analytics becomes more valuable. Retailers should not overlook the engagement value of the viewing platform.
Mobile is already here, but companies must align mobile capability with customer analytics to create customer experiences that enhance sales.
Trends in customer experience have been long time coming, but IoT perspectives will unleash advanced strategies that can lead to better operations.
Real time data has its purposes but think before you react and change your strategy based on real time snippets.
Radio Show
A2 Conversations
UPCOMING
James M. Connolly
See How Data is Revolutionizing Healthcare


2/25/2016   REGISTER   0
ARCHIVE
James M. Connolly
The Analytics Job and Salary Outlook for 2016


1/28/2016  LISTEN   16
ARCHIVE
James M. Connolly
See How Analytics Drive Change in the Retail World


1/7/2016  LISTEN   103
ARCHIVE
James M. Connolly
All Analytics Conversations: Forecasts for Analytics in 2016


12/18/2015  LISTEN   3
ARCHIVE
James M. Connolly
Don't Make This Mistake With Big Data


12/11/2015  LISTEN   4
ARCHIVE
James M. Connolly
Understand the Difference Between Data Science and Analytics


11/23/2015  LISTEN   30
ARCHIVE
James M. Connolly
Shape the Next Generation of Data Scientists


10/20/2015  LISTEN   69
ARCHIVE
James M. Connolly
Analytics Best Practices: Plan for the Human Factor


10/14/2015  LISTEN   117
ARCHIVE
James M. Connolly
See How Your Analytics Initiative Measures Up


9/24/2015  LISTEN   50
ARCHIVE
James M. Connolly
Use Mobile Analytics to See the Big Picture


9/1/2015  LISTEN   83
ARCHIVE
James M. Connolly
Hire and Manage a Great Analytics Team


9/1/2015  LISTEN   152
Information Resources
Quick Poll
Quick Poll
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS