Jonathan Steiman
  • Blog
  • Resources
  • Photos
  • My Dad's Photos
  • About Me
  • Contact

Google Chrome Commercial Comes to Life: Creating An Account For Your Kids

10/31/2011

0 Comments

 
Remember this Google commercial?
Well, it is a brilliant idea that I saw put into action.  My friend and co-worker just had a baby girl. About three weeks after the birth, he created a Google account for her. Here is an email I sent her.
Picture
0 Comments

Google Tables: A Great Tool with the Potential to be Transformative

10/21/2011

3 Comments

 
Google, rather quietly, released a new Doc product called Fusion Tables. Tables is a database tool, which means that Google is now matched one-for-one with the Microsoft Office Suite. Like all Doc products, Tables is intuitive, collaborative and integrated with the web, especially location-based data. Tables is not nearly as robust as Access. But most people don't need that much power, which is why Tables is a great tool for anyone with the slightest data analysis needs.

Tables is also focused on being a data repository. In other words, if you have a dataset that you want to share with the world, simply make it "public" on Tables. And vice versa; if you need a dataset, peruse the public tables located here.  Right now there are about 100 sets, including Goals at the 2010 World Cup, Coffee Production, and Homicides in Colombia. 

Testing Tables: Uploading and Analyzing One Data Set
The best feature of Tables is the ability to overlay information onto a map. To familiarize myself with this functionality, I needed a rich data set that was not too cumbersome. The Bureau of Labor and Statistics is a natural, so my first test is an analysis of firm size and employment by each state.

First, I had to create the table. This could not be any easier. To create a new table you are given three options: From this computer (i.e. an Excel or Access file), From a Google Spreadsheet, or Empty Table. Since I downloaded the Excel dataset from the BLS, I chose the first option: From this computer. The next step is to confirm that the columns are correctly formatted. Amazingly, Google correctly recognized every column. For example, the first column was State, which I thought would have been tagged as text but was correctly recognized as location.

The next step is attributing the data. This is key for sharing tables with the public. If you plan on publishing the table, proper attribution is vital, or else it is of little value to the research community.

With the file uploaded and the data attributed, it was time for fun: analysis. My first stop was the Intensity Map, which is located in the Visualize drop-down. At first, the data was skewed because it included employment by firm size for all fifty states as well as the United States as a whole. Also, the data was noisy because it included every firm size, ie 0-4 employees, 5-9 employees, etc. Therefore, I needed filters, which were extremely easy to add; simply click the "options" link.  Here is a screen shot of the Intensity map showing the number of companies with over 500 employees. 

Merging Two Tables: Good, as long as you do not need a calculation
I ran into my first problem / bug while merging two tables together and then performing a calculation. Basically, I wanted to understand the data on a per capita basis, so I created a second table with state-by-state population going back to 2004. (I made it public here).  Merging the two tables was simple. In the original table, I simply clicked on “Merge” and was presented a two question “wizard.” The first question was “which columns do you want to match.” This is equivalent to dragging the cursor between two tables in Access. In this instance, I chose to link STATE data together, so that I would see employment by state along with population. The second question is a no-brainer: which table do you want merged.

Next, I wanted calculate the Enterprises per Capita by dividing the population by the number of firms. So I went to Edit, Add Formula and wrote in my command. It didn’t work. For some reason, I could not get a merged table to perform a calculation. My work-a-round was exporting the newly merged table to Google Docs Spreadsheet, and then importing it back in as one table. When I did this, I was able to perform the calculation. This is not an acceptable solution because the table is no longer dynamic. If anyone out there knows what I’m doing wrong, please shoot me a note or write a comment below.

Conclusion: A Key Tool for Any Analyst
Aside from my inability to calculate, Google Tables is a great resource. My intensity map of firm size is just the tip of the iceberg. Check out these amazing examples. 

Lastly, Tables has the potential be transformative. Humans advance on data. Right now, there is a vast expanse of data, but it is silo'd across many systems and written in different formats. A central, crowd-sourced repository of data will improve the quality of analysis, all while reducing the time wasted finding, verifying and cleansing.
3 Comments
    Picture
    JONATHAN STEIMAN
    Follow @jonsteiman
    I'm the Founder and CEO of Peak Support. This blog is my take on early-stage companies and innovation. Every so often, there may be a post about culture, networking, family -- you name it. After all, what is a blog if it isn't a tad bit unstructured.

    Enter your email address:

    Delivered by FeedBurner

    Archives

    December 2016
    August 2016
    December 2015
    August 2015
    May 2015
    September 2014
    July 2014
    April 2014
    March 2014
    December 2013
    August 2013
    June 2013
    May 2013
    April 2013
    March 2013
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    December 2011
    November 2011
    October 2011
    September 2011
    August 2011
    July 2011
    June 2011
    May 2011
    April 2011
    March 2011
    February 2011

    Categories

    All
    2011
    Accredited Investors
    Airbnb
    App
    Apple
    Bankrupt
    Bankruptcy
    Benjamin Graham
    Best New Business Blog
    Beta
    Blog
    Bob Dylan
    Capital Asset Pricing Model
    Capital Requirements
    Capm
    Coaching
    Codecademy
    Codelesson
    Competitive Strategy
    Continuous Improvement
    Convertible Preferred
    Creative Destruction
    Crowd Sourcing
    Crowd-sourcing
    Customer Insights
    Database
    Data Repository
    Dcf
    Debt
    Design
    Development
    Discounted Cash Flow
    Disruptive Technology
    Ed Tech
    Education
    Education Technology
    Elizabeth Warren
    Entrepreneur
    Entrepreneurship
    Ephemeral Era
    Equity
    Facebook
    Facebook Marketing
    Facebook Mobile Advertising
    Finance
    Finance-ability
    Fortunate
    Function
    Functionality
    Fusion Tables
    Google
    Google Chrome
    Google Docs
    Google Fusion Tables
    Google Spreadsheet
    Google Table
    Hiking
    Innovation
    Instagram
    Institutions
    Intensity Map
    Internet Access
    Internet Platforms
    John Rawls
    Joseph Schumpeter
    Leadership
    Location
    Location-based Data
    Management
    Marketing
    Mba
    Microsoft
    Microsoft Access
    Mobile
    Model
    Nda
    Networking
    Novartis
    Operations
    Participating Preferred
    Pay-off Diagram
    Performance
    Personal Improvement
    Peter Drucker
    Polaroid
    Portfolio Management
    Postagram
    Private Equity
    Product Development
    Risk Free Rate
    Risk Management
    Scale
    Schedule
    Sec Regulations
    Sincerely
    Social Media
    Standards
    Start Up
    Start-up
    Steve Blank
    Table
    Talkto
    Taxation
    Ted Fortsmann
    Treehouse
    Twitter
    User Interface
    Valuation
    Value Chain
    Venture Capital
    Venture Finance
    Warren Buffett
    Water Safety
    Web 3.0
    Working Capital
    Y Combinator

  • Blog
  • Resources
  • Photos
  • My Dad's Photos
  • About Me
  • Contact