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
Chicago’s push for improving civic services through data is leading to IoT innovations, a robust developer community, and an intriguing new seminar demonstrating best practices for analytics practitioners and tech managers
A few years ago we discussed Twitter’s influence on elections and voter sentiment. Now we examine how Twitter’s social influence has changed and impacted analytics as a result.
Amazon’s emphasis on the Internet of Things in its strategic moves demonstrates how web analytics is no longer just about the web.
The rising interest in autonomous vehicles and development environments that support such vehicles highlight new opportunities for analytics.
The increasing demand for understanding customer preferences in advanced analytics means managers have become more report savvy and less stuck on vanity metrics.
Information Resources
Radio Show
A2 Conversations
UPCOMING
AllAnalytics
A Look at Tomorrow's Data Scientist


8/9/2016   REGISTER   0
ARCHIVE
James M. Connolly
Analytics and the Making of a President


7/21/2016  LISTEN   76
ARCHIVE
James M. Connolly
Analytics: Where We've Been, Where We're Going


7/12/2016  LISTEN   48
ARCHIVE
James M. Connolly
How Predictive Analytics Can Take Your Company to the Next Level


6/28/2016  LISTEN   22
ARCHIVE
James M. Connolly
How Analytics Can Transform State Government


5/17/2016  LISTEN   51
ARCHIVE
James M. Connolly
Save Labor Costs With Predictive Analytics


5/10/2016  LISTEN   53
ARCHIVE
James M. Connolly
What the IoT Means to You and Your Insurer


5/6/2016  LISTEN   75
ARCHIVE
James M. Connolly
When It's Time for a Robot's Job Review


4/27/2016  LISTEN   21
ARCHIVE
James M. Connolly
How Advanced Analytics Serve Healthcare


4/12/2016  LISTEN   88
ARCHIVE
James M. Connolly
Life in a World of Big Data, Autonomous Cars and IoT


3/17/2016  LISTEN   34
ARCHIVE
James M. Connolly
Sports Analytics: Driving the Business Forward


3/10/2016  LISTEN   73
Quick Poll
Quick Poll
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS