Monthly Archives: April 2015
Day 36 – Predictive Analytics – class slides
Reading Assignment for Day 36 (Apr 13)
Big Data Knows When You’re Going to Quit Your Job Before You Do – Bloomberg (http://www.bloomberg.com/news/2014-12-29/big-data-knows-when-you-re-going-to-quit-your-job-before-you-do.html)
Day 34 – Beyond Numbers – class videos
Google Flu Trends Overview – Google.org (https://www.youtube.com/watch?v=6111nS66Dpk)
How Good Is Facebook’s Facial Recognition – BuzzFeed (https://www.youtube.com/watch?v=l4Rn38_vrLQ)
Sentiment Analysis – LiveHelpNow (https://www.youtube.com/watch?v=N5mE-LzIKCI)
In-Class Exercise on Fri, Apr 10 – Sentiment Analysis Using Excel
Online discussion questions – Day 34 (Apr 8) – Beyond Numbers
- Any examples of sarcastic tweets or reviews for a company that is not straightforward to interpret as positive or negative?
- Any other examples of analysis of unstructured data?
- Any data source for sentiment analyses other than Twitter or Yelp?
Day 34 – Beyond Numbers – class slides
In-Class Exercise on Wed, Apr 8 – Sentiment of Text Data
In-Class Exercise on Mon, Apr 6 – solution
Reading Assignment for Day 34 (Apr 8)
Unstructured Data in Big Data – For Dummies (http://www.dummies.com/how-to/content/unstructured-data-in-a-big-data-environment.html)
Online discussion questions – Day 32 (Apr 3) – Designing Data
In the example below, there are four entities (Personnel, Member, Facility, Equipment). What are the attributes and the relationships? What are the relationship types?
Foothills Athletics is an athletic facility offering services in the greater Highlands Ranch, Colorado, area. All property owners living in Highlands Ranch are members of the Recreation Function of the Highlands Ranch Community Association (HRCA). Foothills Athletics consists of a recreation facility where residents have the opportunity to participate in athletic activities, enroll their children in day camp or preschool, or participate in an HRCA program.
- Personnel: Foothills Athletics has a number of employees, primarily fitness course instructors and administrative personnel (e.g., billing clerks, equipment managers, etc.). Records are kept on each employee, past and present, detailing employee name, address, phone number, date of hire, position, and status as either a current or former employee. Employees are assigned a unique four-digit Employee ID number when they are hired.
- Members: When joining the Foothills Athletic center, individuals are assigned a unique four-digit Member ID number. This information along with their name, address, phone number, gender, birth date, and date of membership are recorded. At the time of enrollment, each member decides on one of three available membership types along with a fixed membership fee: Platinum ($400), Gold ($300), and Silver ($200). This is a one-time fee that establishes a lifetime membership.
- Facilities and Equipment: Foothills Athletics has a variety of facilities and equipment choices. Each facility has a unique room number and a size limitation associated with it. Some of the rooms contain pieces of exercise equipment; all have a serial number (provided by its manufacturer) that is used for inventory purposes. In addition, for each piece of equipment, purchase date and the date of its last maintenance are recorded. Each piece of equipment belongs to a specific equipment type, such as stair master machine, and is assigned a unique three-digit identification number. The description, the manufacturer’s model number, and the recommended maintenance interval for that model of equipment are also kept on file. Each equipment type is associated with a single manufacturer that is referenced by a unique two-digit manufacturer ID number. Additional information maintained on each manufacturer is the company name, address, and phone number.