Instructor: Jing Gong, Section 002/004

Jing Gong

Jing Gong joins the Fox School on a tenure-track appointment from Carnegie Mellon University, where she studied for a PhD in Information Systems and Management. She is interested in using empirical models to analyze firm and consumer behavior in online markets, with primary focuses in electronic commerce, digital marketing, two-sided online markets, online labor markets, and business analytics. Her research uses interdisciplinary approaches such as econometrics, Bayesian statistics, economic structural modeling, field experiment, and text analytics. Jing’s work has appeared in several major conferences and workshops including International Conference on Information Systems (ICIS), Workshop on Information Systems Economics (WISE), Conference on Information Systems and Technology (CIST), Marketing Science Conference, and China Summer Workshop on Information Management (CSWIM). She was the 2014 recipient of the Best Student Paper Award at the Conference of Information Systems and Technology and the 2014 Best Paper Award runner-up, at the China Summer Workshop on Information Management. Jing holds a Bachelor's Degree in Information Management and Information Systems from Tsinghua University in Beijing, China.

Agenda for Week 9 (Week of 3/9)

Welcome back!

Below is the agenda for Week 9.

Class Schedule:

  • Tuesday — Principles of Data Visualization
  • Thursday — ICA #6.1 Principles of Data Visualization; Introduction to Advanced Analytics and R (****Please install R and RStudio following the set up guide here: Setting up R and RStudio)

Assignment:

  • Assignment #4 (ETL in Excel)  – due on Tuesday, 3/13 before class.
  • Assignment #5 (Pivot Tables in Excel)  – due on Tuesday, 3/20 before class.

Other (for future weeks):

  • Exam 2 — we will have Exam 2 on 3/27 (Tuesday); there will be an in-class review session on 3/22 (Thursday)
    • Aaron will hold a review session on SQL advanced queries. Time and place TBA.
    • Nathan will hold office hour for Exam 2. Time and place TBA.

 

Setting up R and RStudio

Source: Listen Data (https://www.listendata.com/2016/12/companies-using-r.html)

R is a widely-used, open source statistical analysis platform. RStudio is an integrated development environment for R – that means it makes using R easier!

  • You should install both software packages – R and RStudio! Don’t just install R or your life will be difficult! 

We’ll be using this software to do some advanced analytics in the second half of the semester! You can get a full copy of the software – PC or Mac – for free!

First, download and install R:

  • Download the installation package for R.
    • Choose the link for your operating system (Windows or MacOS).
      • If you have Windows, choose the “base” installation file.
      • If you have a Mac, you’ll have to choose the one that corresponds to your version of MacOS.
    • Download the latest version (Currently the latest version is the latest version is R 3.4.3. But if there is a newer version, simply download the latest version.)
    • Install the software, accepting the default options.

Now, download and install RStudio: (You need to have R installed first!)

  • Download the appropriate installer from the RStudio website.
    • We will use the RStudio Desktop (Open Source License) version, which is free.
    • Scroll down to the bottom of the page, and choose the link for your operating system (Windows or MacOS).
    • Download the latest version (Currently the latest version is RStudio 1.1.442. But if there is a newer version, simply download the latest version.)
    • Install the software, accepting the default options.

After both are installed, you’re always going to run RStudio, which will use R behind the scenes to give you a pleasing analytics experience!

Agenda for Week 7 (Week of 2/26)

Dear all,

Below is the agenda for Week 7 (Yes! We are almost halfway through).

Office Hour:

  • Aaron will hold office hour on Monday (2/26) at 1:00-2:00 pm (in Speakman 201F).

Class Schedule:

  • Tuesday — Dimensional Data Modeling
  • Thursday — ICA #5: Pivot Tables in Excel

Assignment:

  • Assignment #3 (SQL In) – due on Tuesday, 2/27 before class.
  • Assignment #4 (ETL in Excel)  – due on Tuesday, 3/13 before class (to be announced soon).

Agenda for Week 6 (Week of 2/19)

Dear all,

Below is the agenda for Week 6.

Class Schedule:

  • Tuesday — Exam 1
  • Thursday — Extract, Transform, Load (ETL); ICA #4: Excel Basics

Assignment:

  • Assignment #3 (SQL In) – I will announce this assignment soon, which will be due on Tuesday, 2/27 before class.

Exam 1 Study Guide

Here is the Exam 1 Study Guide.

Here is the SQL Quick Reference 1 (a summary of all the queries we learned in Module 2 – SQL 1: Getting Information Out of a Database).

  • Note that advanced queries ( joins and subselect statements) will not be covered in Exam 1; instead, these advanced queries will be covered in Exam 2.

Remember, the exam is on Tuesday, 2/20/2017 during class time. There will be an in-class review session on Thursday, 2/15/2017.

Schedule changes for the following weeks (Assignment 2 deadline extended to Thursday 2/15 before class)

As you might have heard, the campus will be closed and classes will be canceled this Thursday (2/8). We will still have Exam 1 on Tuesday 2/20, but the rest of the class schedules will be adjusted accordingly.

Class Schedule:

  • Thursday, 2/8: Class canceled
    Tuesday, 2/13: Lecture – SQL 2 (Putting Data into the Database); ICA 3 – SQL In (using MySQL Workbench)
    Thursday, 2/15: ICA 3 – SQL In (using MySQL Workbench) continued; Review for Exam 1
    Tuesday, 2/20: Exam 1 (****** No Change ******)
    Thursday, 2/22: Lecture – Extract, Transform, Load (ETL)

Assignment:

  • Assignment #2 (SQL Out) – The deadline is extended to Thursday 2/15 before class.

ITA Office Hour (no change):

  • Nathan Pham: Friday (2/9), 1:00 – 2:00 pm, in Alter 240D (Breakout room).
    Aaron Cheng: Monday (2/12), 1:00 – 2:00 pm, in Speakman 201F.

Let me know if you have questions regarding the schedule changes.

Best,
Jing

Companies Using MySQL

You might be interested to know how popular MySQL is in the real world. What companies are running MySQL? Well, the list is quite long (see a complete list of companies using MySQL here), but here are some examples.

  • E-Commerce: Amazon, Airbnb, Alibaba, Booking.com, craigslist, ebay, Google, Groupon, Uber, Yahoo
  • Telecom: Alcatel-Lucent, AT&T Wireless, Comcast, Verizon Wireless
  • Technology: Apple, Cisco, Dell, Hewlett-Packard, Intel, NEC, Symantec, Xerox
  • Web/Social: Facebook, LinkedIn, Twitter, Pinterest, Quora, Wikipedia, Yelp
  • Media/Entertainment: NBCUniversal, New York Times, Youtube
  • Retail: Sears, Walmart, Spirit, Macy’s West
  • Travel/Airlines: Continental Airlines, Virgin America, KAYAK, Orbitz

Agenda for Week 4 (Week of 2/5)

Dear all,

Below is the agenda for Week 4.

Class Schedule:

Assignment:

  • Bonus Assignment (Database Schema) – due on Tuesday, 2/6 before class
  • Assignment #2 (SQL Out) – I will announce this assignment soon, which will be due on Tuesday, 2/13 before class.

ITA Office Hour:

  • Nathan Pham: Friday (2/9), 1:00 – 2:00 pm, in Alter 240D (Breakout room).
  • Aaron Cheng: Monday (2/12), 1:00 – 2:00 pm, in Speakman 201F (Breakout room).

And a MySQL joke, just for fun:

Source: http://database.ca/databasehumorhumourjokes.aspx

Best,
Jing