Posts tagged tables
Google Refine Gets Fusion Tables Import and More
Jul 18th
Google Refine, formally known as Freebase Gridworks, has been updated to version 2.1. Refine is an open source tool for cleaning up messy data sets before linking them into systems such as Freebase. The update includes new HTML parsing functions, the ability to import Google Fusion Tables and more.
Freebase Gridworks was one of the tools included in Google’s acquisition of Metaweb. We covered its last big update here.
Sponsor
New features include:
- HTML parsing functions (based on JSoup)
- Metaphone3 (American English) & Cologne Phonetic (German) coders & clustering
- Google Fusion Table import support
- Facet for exact duplicates
- Ability to star favorite expressions for reuse later
- Latest Apache POI library including a number of Excel bug fixes
As we’ve noted before, Google Refine can be used with other Google tools to create a fairly powerful stack for working with big data.
Refine competes with other data cleaning tool such as DataWrangler.
View full post on ReadWriteWeb
Google Docs Adds Support for Pivot Tables
May 17th
Today Google announced support for pivot tables to the Google Docs spreadsheet application. According to Wikipedia, pivot tables “can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a “pivot table”) showing the summarized data.” It’s a common approach to data visualization and business intelligence.
Unfortunately, pivot tables from Microsoft Excel can’t be imported into Google Docs yet.
Sponsor
This new functionality takes Google Docs one step closer to being useful for serious data analysis.
View full post on ReadWriteWeb
Zanran: New Search Engine That Unearths Data In Charts, Graphs & Tables
May 12th
A few days ago, I was looking for a very specific piece of data: the average age of professors in the US. I did a Google search for “average age of us professors” and, after the obligatory and unhelpful Wikipedia result at the top, found some data that was good enough further down the…
Please visit Search Engine Land for the full article.
View full post on Search Engine Land: News & Info About SEO, PPC, SEM, Search Engines & Search Marketing
Premiere Game Tables Sees Immediate SEO Boost with Treepodia Ecommerce Video … – Benzinga
Mar 7th
|
Premiere Game Tables Sees Immediate SEO Boost with Treepodia Ecommerce Video …
Benzinga Treepodia announced today that online retailer Premiere Game Tables has experienced significant SEO benefits by implementing its Dynamic Video Sitemap in conjunction with the Treepodia Ecommerce Video Platform. After turning to Treepodia to create … |
View full post on SEO – Google News
Turning The Tables On The Google Toolbar & Disclosure Claims
Feb 5th
Part of this week’s debate over whether Microsoft’s Bing search engine is learning from Google involves data that Bing gathers through Microsoft’s Internet Explorer. Google has suggested Microsoft isn’t giving fair disclosure. I disagree. To better illustrate, let’s…
Please visit Search Engine Land for the full article.
View full post on Search Engine Land: News About Search Engines & Search Marketing
Google Adds Spatial Queries to Fusion Tables
Nov 11th
Today on its Geo Developers Blog, Google announced support for spatial queries in Fusion Tables. Google announced last week that the Maps API is being deprecated and that Fusion Tables is the replacement. In that announcement, it was mentioned that spatial queries were added to Fusion Tables. It’s not clear whether there were new queries added today or if this announcement is meant to reiterate the transition to Fusion Tables. The documentation for spatial queries in Fusion Tables can be found here.
Sponsor
According to the announcement, spatial queries will enable developers to:
- Find all features that are located within (or overlap with) a given distance from a location
- Find all features that are located within (or overlap with) a given bounding box,
- Find a given number of features closest to a location.
In the example given, a developer could put a list of locations of a pizza chain in a table and then use a query to map all the locations within a given distance or within a specific area.
Fusion Tables is a cloud data management service. The idea is to help developers on opposite sides of a firewall collaborate on large datasets. “Fusion Tables is not a traditional database system focusing on complicated SQL queries and transaction processing,” the original announcement says. “Instead, the focus is on fusing data management and collaboration: merging multiple data sources, discussion of the data, querying, visualization, and Web publishing.”
View full post on ReadWriteWeb
How To Make Awesome Ranking Charts With Excel Pivot Tables
Jun 14th
Posted by richardbaxterseo
On the "So You Want to Test SEO?" panel at this year’s SMX Advanced Seattle, Branko Rihtman from SEO Scientist presented some spiffy looking ranking charts, measuring positioning by keyword, over time. A few people asked me how exactly you make a chart like that. Being something of an Excel fan, I was instantly inspired to share the approach with my fellow SEOmozzers. Here’s a step by step on how to create a rankings chart using Excel.
Collect the data
To be able to produce a chart like my example below, you’re going to need Microsoft Excel, and a rankings checker that will export ranking data, by search engine and by date. For now, I’m using Advanced Web Ranking, but there are lots of other ranking checkers you can use. Start by putting your data in an Excel table named "rankings" just like this:
Create a pivot chart
Pivot tables were designed for exactly this type of application, and making them is heaps of fun. Let’s start by selecting "Insert > PivotTable >PivotChart" in the options along the top of your Excel ribbon.
You should see a window appear. Make sure you’ve named the correct range (our table name: "rankings") and select "New Worksheet", followed by OK.
Drag and drop your legend, axis and value fields
The cool thing about making a pivot table is the drag and drop functionality when you’re creating the row labels and values for the table. Here’s a visual explanation of where to put your keyword, date and position data:
Next, you’ll need to filter for the keywords you’d like to create a chart for. It’s quite inpractical to create a chart with hundreds of keywords, but you can add a good number for comparision purposes. Head to the "Column labels" drop down and filter for the keywords you’d like to build the chart for:
Filter by search engine
If you’ve collected data on multiple search engines, you’ll need to add a filter. Drag the "Search Engine" field down into the "Report Filter" section, and select the search engine you’re interested in using the drop down at the top of your pivot table.
Format your chart nicely
If you’ve followed the instrutions so far, you’ll see a slightly noisy and weird looking bar chart, so next we’ll create a line chart to show the positional changes over time.
For pure charting awesomeness, a simple right mouse click on the chart, followed by "Change chart type > Line", will do the trick. Finally, you’ll need to reverse your Y axis, leaving position 1 at the top and your lower rankings at the bottom. Using your right mouse button, click on the axis and select "Format axis" – you should see a window like this:
The end result
After spending some time having fun with formatting, you can create really nice charts. Here’s mine:
Hope you find these tips useful, and if you’d like some more of this, please shout in the comments!
View full post on SEOmoz Daily SEO Blog
Are nested tables hinderance for search engine optimization?
Mar 9th
This is the question related to search engine optimization. Some web design companies do not use nested tables and only use CSS (cascading style sheets) for search engine optimization point of view. Can anyone tell that does nested table structure of the page creates problem in SEO
