• No results found

Use Excel to analyze Twitter data

N/A
N/A
Protected

Academic year: 2021

Share "Use Excel to analyze Twitter data"

Copied!
5
0
0

Loading.... (view fulltext now)

Full text

(1)

Use Excel to analyze Twitter data

Use Excel to analyze Twitter data

Use Excel to analyze Twitter data

Use Excel to analyze Twitter data

Blog Post Date: May 27th, 2013

Category: Technology made easy, Social Media Author: Ulrika Hedlund

Source: http://www.businessproductivity.com/use-excel-to-analyze-twitter-data

Would you like to know who is the most active tweeter in your field? Wouldn’t it be great if you knew what your competitor is doing on Twitter to attract customers? Do you wish you could see where in the world people are tweeting about your products? Well, you can! Using a free add-in for Microsoft Excel called “Analytics for Twitter” you can use powerful

analytical tools within Excel 2013 (or Excel 2010) to get new insights into Twitter data.

Introducing “

Introducing “

Introducing “

Introducing “Analytics for Twitter

Analytics for Twitter

Analytics for Twitter””””

Analytics for Twitter

The Analytics for Twitter application is the result of a joint initiative between Microsoft and ISV Gold Business Intelligence partner Extended Results. The application was first introduced in 2011 for Excel 2010 and in March 2013 an updated version for Excel 2013 was announced. The analytical tools called PowerPivot and Power View that provide the rich visual

analytics that are used in the Analytics for Twitter application are included in Excel 2013 out of the box (in the Microsoft Office 2013 Professional Plus version), for Excel 2010 you can download them free of charge.

How to get started

How to get started

How to get started

How to get started

The first thing you need to do is download and install the Analytics for Twitter application. The application is free of charge and there is an Excel 2010 version and an Excel 2013

version. When you’ve installed the application and open up Excel you will see a new tab in

(2)

You need to make sure that the “Analytics for Twitter” add-in is enabled in Excel, as well as the “Power View” add-in and the “Microsoft Office PowerPivot for Excel” add-in. You can find these settings by going to File ->Options ->Add-ins.

Before you can start with your analysis you need to link the application to your Twitter account and authorize it with a PIN code.

(3)

Start your analysis

Start your analysis

Start your analysis

Start your analysis

When you have installed the application and authorized your account you can get started with your analysis. In the “Analytics for Twitter” Tab click “New Query”. A search box will open up where you can enter up to 5 search terms separated by a comma. You can search for hashtags (#), mentions ( @) or just free text. Since I’ve recently launched a number of courses on Udemy, I wanted to do a search to see who is tweeting about Udemy, if tweets are spread all over the world, and how other instructors are marketing their courses on Udemy.

Understanding the search results

Understanding the search results

Understanding the search results

Understanding the search results

Once the query is finished and you’ve refreshed the data the spreadsheet will update and show rich visual graphs of your selected search terms. There are 7 different sheets in the spreadsheet showing different perspectives of the data.

Summary

Summary

Summary

Summary – here you will get a summary of number of tweets per day, frequency of tweets

by time of day, and top tweeters.

(4)

Here I can see that during May 19th and May 26th there are 5179 tweets containing “Udemy”

(as a hashtag, mention or written in free text). The most active tweeter is “GreatDealEver” and the most frequent hashtags in these tweets are (other than udemy) are iphone, ios, ipad and programming.

People

People

People

People – in the People sheet you will see who the key tweeters are for your search terms

including mentions and retweets.

Tweet Map

Tweet Map

Tweet Map

Tweet Map – here you will see a geographic map of where the tweeters are located and a

distribution of when they tweeted.

In the Tweet Map I can see that most of the tweets containing “Udemy” are coming from Canada followed by the USA, a very small portion of the tweets are coming from Asia.

Mentions

Mentions

Mentions

Mentions – here you will see the most talked about tweeters for your search terms.

Tweeter Profile

Tweeter Profile

Tweeter Profile

Tweeter Profile – here you will see details about tweeters, such as profile pictures, number

of followers/friends and the most talked about tweeters for your search terms.

(5)

Here I can learn more about people who are tweeting about Udemy. I can see their tweets, how many followers they have and their popular hashtags.

Details

Details

Details

Details – here you can see each individual tweet and filter on key items.

Tone

Tone

Tone

Tone – in the final sheet you can see if the tweets are negative or positive. There is a “Tone

Dictionary” where you can change the weighting of different words such as “amazing” or

“horrible”.

A fantastic tool for marketers

A fantastic tool for marketers

A fantastic tool for marketers

A fantastic tool for marketers

The “Analytics for Twitter” is a fantastic tool that provides a lot of valuable insights. The tool is easy to use and the report is elegantly and professionally designed. Analytics for Twitter makes full use of the rich visualization capabilities offered by Power View such as the Bing maps and dashboard views. The only downside to the tool is that the time interval is limited to 8 days, other than that I can warmly recommend it. Good luck with your Twitter

References

Related documents

Technology Technology Version Microsoft Excel Excel 2007 Excel 2010 (.xlsx) (*) Excel 2013 (.xlsx) Flat Files. Comma Separated Values (CSV)

Tableau is the sponsor of this paper) makes applications for fast analytics and visualization that connect to existing Excel spreadsheets, data warehouses and other data

[r]

When he hung up, Peter said that Mark sounded like the archetypal American.. I asked him what

Make sure you are on the first worksheet titled Tables Charts Graphs.xlsx Then, click on a cell within the table to identify the data collection. Click on the Insert Tab and click

templates, microsoft excel 2010 chart templates, excel spreadsheet for sharing expenses, excel spreadsheet for tracking employee time off, microsoft excel 2010 calendar template

You can open and edit an Excel 2007 file in an earlier version of Excel by downloading the Microsoft Office Compatibility Pack for 2007 from the Microsoft

In the Create PivotTable dialog box, under Choose the data that you want to analyze section, do the following:.  Select Use an external data source