Data Science

Data Science: An Introduction, Science & Data Science, Introduction to Data, Identifying Sources of Data

Recordings:

• Lecture 1.1: Introduction 
• Lecture 1.2: Science & Data Science 
• Lecture 2.1: A Brief Introduction to Data
• Lecture 2.2:  Identifying Sources of Data

Readings:

• Three Science Words We Should Stop Using (Allain) 
• I’m Beating the NSA to the Punch by Spying on Myself (Stein) 
• What the NSA Wants to Know About Your Phone Calls (Di Justo) 
• The Ashley Madison Hack is Only the Beginning (Aguilar)
• What The Fox Knows (Silver) 
• Open Data (Wikipedia)
• In Search of America’s Best Burrito (Silver)

In Class Activities:

• In-Class Exercise 1.1 – Data is Everywhere.docx
• In-Class Exercise 1.2 – Hypotheses.docx
• In Class Exercise 2.1 – Data Dictionary.docx
• In-Class Exercise 2.1 – 2015 Car Fuel Econ Start.xlsx

Decks:

• 1.1. Introduction.pptx
• 1.2. Science and Data Science.pptx
• 2.1. A Brief Introduction to Data.pptx
• 2.2. Identifying Sources of Data.pptx

May 19

Learning to (Mis)Trust Data, Viewing Data, Introduction to Tableau

Recordings:

• Lecture 3.1:  Learning to (Mis)Trust Data (Links to an external site.)
• Lecture 4.1 Viewing Data
• Eli Pariser Ted Talk: http://www.ted.com/talks/eli_pariser_beware_online_filter_bubbles

Readings:

• Bubble Trouble: Is Web Personalization Turning Us into Solipsistic Twits? (Weisberg) (Links to an external site.)
• The Hidden Biases in Big Data (Crawford) (Links to an external site.)
• In Data We Trust (Hayes) (Links to an external site.)
• Chapter II.2: Good Graphics? Handbook of Data Visualization (Unwin) – Temple Library (Search for “Handbook of Data Visualization” using Summon. Find the 2008 edition in the search results.)
• Stephen Few on Data Visualization: 8 Core Principles (Hoven) (Links to an external site.)
• Watch out, Terrorists: Big Data is on the Case (Acohido)

In Class Activities:

• In-Class Exercise 2.2 – Sources of Data.docx
• In-Class Exercise 3.1 – Trusting Data
• In-Class Exercise 4.1 – Finding Good and Bad Visualizations.docx
• In-Class Exercise 4.2 – FoodAtlas.xlsx
• In-Class Exercise 4.2 – Getting Familiar with Tableau.docx

Decks

• 3.1 Learning to (Mis)Trust Data.pptx
• 4.1 Viewing Data.pptx

Discussion Board Post #2 (due by 5/25 @11:59 PM)

Quiz #1 submitted through Canvas by 3:59PM on May 19

Communicating with Data, Storytelling with Infographics

Recordings:

Unit 5.1: Communicating Using Data

Unit 5.2: Storytelling With Infographics

Readings:

• Telling a Story with Data (Davenport) (Links to an external site.)
• Visualizing a Day in the Life of a New York City Cab (Matlin) (Links to an external site.)
• Chapter 1: The Science of Infographics. Cool Infographics (Krum) – Temple Library (Search for “Cool Infographics” using Summon.)
• Chapter 6: Designing Infographics. Cool Infographics (Krum) – Temple Library (Search for “Cool Infographics” using Summon.)

In Class Activities:

In-Class Exercise 5.1 – studentloans2013

In-Class Exercise 5.1 – Telling a Story Through Visualization

Decks:

5.1 Communicating Using Data

5.2 Storytelling with Infographics

Discussion Board Post #3 (due by 6/1 @11:59 PM)

Quiz #2 submitted through Canvas by 3:59PM on May 26

Assignment #1 Analyze a Data Set Using Tableau, submitted to Canvas by 5/29 at 11:59 PM.  

Dirty Data, Data Cleansing, Choosing Relevant Data and Evaluating Key Performance Indicators

Readings:

• Data’s Credibility Problem (Redman) – Temple Library  (Search for “Data’s Credibility Problem” using Summon.)
• Damn Excel! How the ‘Most Important Software Application of All Time’ is Ruining the World (Gandel) (Links to an external site.)
• Stupid Data Corruption Tricks (Taber) (Links to an external site.)
• Top Ten Ways to Clean Your Data (Microsoft) (Links to an external site.)
• Performance Indicator (Wikipedia) (Links to an external site.)
• The Tyranny of Success: Nonprofits and Metrics (Schambra) (Links to an external site.)
• Wearable Tech is Plugging Into Health Insurance (Olson) (Links to an external site.)
• Tracking Health One Step  at a Time (Bialik)

Watch:

• Lecture 7.1: Dirty Data
• Lecture 7.2: Data Cleansing
• Lecture 8.1: Choosing Relevant Data
• Lecture 8.2: Evaluating KPIs

Decks:

• 7.1 Dirty Data.pptx 
• 7.2 Data Cleansing.pptx
• 8.1. Choosing Relevant Data.pptx
• 8.2. Evaluating KPIs.pptx

In Class Activities:

• In-Class Exercise 7.1 – How Data Gets Dirty .docx
• In-Class Exercise 7.1 COMBINED DOCS – How Data Gets Dirty.pdf
• In-Class Exercise 7.2 – Finding Bad Data in Excel.docx
• In-Class Exercise 7.2 – Vandelay Orders by Zipcode.xlsx
• In-Class Exercise 8.1 – Identifying Key Performance Indicators.docx
• In-Class Exercise 8.2 – Visualizing KPIs062016.docx
• In-Class Exercise 8.2 – OnTime Airline Stats [Jan 2014].xlsx

Discussion Board Post #4 (due by 6/8 @11:59 PM)

Quiz #3 submitted through Canvas by 3:59PM on June 2

Connecting Diverse Data, Creating Interactive Dashboards, Storing & Retrieving Data, Using Tableau to Aggregate Data

Readings:

• How Data Integration Works (Strickland) (Links to an external site.)
• The GOP Arms Itself for the Next “War” in the Analytics Arms Race (Gallagher) (Links to an external site.)
• Best Practices for Designing Views and Dashboards (Tableau) (Links to an external site.)
• The One Skill You Really Need for Data Analysis (Farmer) (Links to an external site.)
• Knowing Just Enough about Relational Databases (Rosenblum and Dorsey) (Links to an external site.)
• How To Explain Hadoop to Non-Geeks (Bertolucci) (Links to an external site.)
• How to Structure Source Data for Excel Pivot Tables & Unpivot (Acampora)

Watch:

9.1 Connecting Diverse Data

9.2: Creating Interactive Dashboards

11.1: Storing & Retrieving Data

Decks:

9.1. Connecting Diverse Data.pptx

9.2. Creating Interactive Dashboards.pptx

11.1. Storing and Retrieving Data.pptx

In Class Activities:

In-Class Exercise 9.1 – Connecting Diverse Data.docx  

In-Class Exercise 9.1 – 2012 Presidential Election Results by District.xlsx

In-Class Exercise 9.1 – Portrait 113th Congress.xlsx

In-Class Exercise 9.2 – Creating Interactive Dashboards.docx

In-Class Exercise 9.2 – Pew Story Data (Jan – May 2012).xlsx

In-Class Exercise 11.1 – Creating a Database.docx

In-Class Exercise 11.2 – Working with ‘Pivot Tables’ in Tableau.docx

In-Class Exercise 11.2 – NCAA 2013-2014 Player Stats.xlsx

Discussion Board Post #5 (due by 6/15 @11:59 PM)

Quiz # 4 submitted through Canvas by 3:59PM on June 9

Assignment #2 Cleaning a Dataset, submitted to Canvas by 6/12 at 11:59 PM. 

Beyond Numbers, Twitter Sentiment Analysis, Predictive Analytics

• Unstructured Data in a Big Data Environment (Hurwitz et al.) (Links to an external site.)
• Techniques and Applications for Sentiment Analysis (Feldman) – Temple Library  (Search for “Techniques and Applications for Sentiment Analysis” using Summon.)
• Don’t Worry, Facebook Still Has No Clue How You Feel (Wohlsen) (Links to an external site.)
• What Analytics Can Teach Us About the Beautiful Game (Paine) (Links to an external site.)
• Big Data Analytics: Descriptive vs. Predictive vs. Prescriptive (Bertolucci) (Links to an external site.)
• They’re Watching You at Work (Peck) (Links to an external site.)

 Complete: Weekly Quiz 5 

 Watch:

Lecture 12.1: Beyond Numbers (Links to an external site.)

Lecture 13.1: Predictive Analytics (Links to an external site.)

Lecture 13.2: More Predictive Analytics (Links to an external site.)

What is the difference between structured and unstructured data? (Links to an external site.)

 (Links to an external site.)Imagine Predictive Analytics Putting a Crystal Ball in Your Hand (Links to an external site.)(TED)

More on Market Basket Analysis Using Tableau (Links to an external site.)

Market Basket Analysis – AdBadger (Links to an external site.)

Decks:

12.1 Beyond Numbers.pptx

13.1 Predicting the Future.pptx

13.2 More on Predictive Analytics.pptx

In Class Activities:

In-Class Exercise 12.1 – Manually Determining the Sentiment of Text Data.docx

In-Class Exercise 12.2 – Sentiment Analysis Using Excel.docx

In Class Exercise 12.2 Twitter Sentiment Analysis Data .xlsx

In-Class Exercise 12.2 – Sentiment Analysis Tools.xlsm

In Class Exercise 12.2 Recorded Walkthrough (Links to an external site.)

In-Class Exercise 13.2 – Simple Predictive Analytics.docx

In-Class Exercise 13.2 – VandelayOrdersAll.xlsx

Discussion Board Post #6 (due by 6/20 @11:59 PM)

Quiz #5 submitted through Canvas by 3:59PM on June 16

Assignment 3 – Original Data Analysis Due 6/22 @ 11:59PM