Text MiningSupplemental Resources on Class

Website

Concept Map

Text Mining

Big Data

Implementation

Relative Cell

References

Design: Accurac

y

Import

Search, Left, Right, Mid, Len, &

Data Mining

Objectives

▪Define Big Data, Text Mining and Data Mining

▪Demonstrate Excel features that support text mining.

Facebook Users

▪1.28 billion users worldwide

▪802 million users login daily (up 21%)

▪67% of Internet users are on FB

▪50% of 18-24 year olds login when they wake up

▪45-54 year old age group has grown 46%

Facebook Content

▪4.5 billion likes daily (up 67%)

▪30 million photos uploaded daily

▪1 in 5 page views in US

▪36% users post brand-related content on their walls

King of Social Media

▪FB accounts for 66% of social media sharing on iPhones

▪Users with income over $75,000Facebook 73%Twitter 17%Pinterest 13%

Facebook & e-commerce

▪10 million registered small businesses

▪Drives 26% of referral traffic to e-commerce sites

▪20% of shoppers prefer buying thru FB vs. e-commerce website

▪58% of businesses see a drop in marketing costs when moving to FB

▪Data sets too large to process with traditional database technology

https://www.ted.com/talks/ kenneth_cukier_big_data_is_ better_data

Big Data

Data Mining Tools

▪software that searches through data

▪uses complex statistical calculations

▪outputs▪ Trends▪ Patterns▪ Correlations▪ Exceptions

Nestle

▪Nestle processes Social Media

http://uk.reuters.com/article/video/idUKBRE89P07Q20121026?videoId=238680321

Import

▪Access data not formatted as an Excel document

▪File type = txt or csv

Import – Step 1▪ File, Open, File type = All files

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

Import – Step 2

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

Import – Step 3

▪Save As File type = Excel Worksheet

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

Text Mining

▪Search

▪Parse

▪Concatenate

▪SEARCH

▪LEFT, MID, RIGHT, LEN

▪&

SEARCH Function

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

LEFT Function

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

LEN or Length Function

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

RIGHT Function

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

MID Function

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

Concatenate

▪& is the concatenate symbol

▪Quotes are required around constant strings of text

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

Relative Cell Addressing

▪Relative is the default

▪When you copy a relative cell reference the reference will change depending on the direction and magnitude of the copy.

Copy Formula with Relative Cell Addresses

Paste Special - Values

http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

MAC: Edit Menu, Paste Special