MIS2502: DATA ANALYTICS (Fall 2018)


Setting up R and RStudio

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.5.1. 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.456. 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!

Assignment #4: ETL/Pivot Table in Excel [Due Tuesday, 10/23/18 at 5:59 pm]

Here are the instructions: Assignment #4 – ETL/Pivot table

For ETL related questions (Part 1-4), you’ll need to complete the assignment using this excel file: ETL Workbook.xlsx. Please submit the final version of your “ETL Workbook.xlsx” worksheet to Canvas.

For Pivot table related questions (Part 5), complete and submit the assignment as a word or pdf file using Excel workbook: VandelaySales.xlsx

Due date: Tuesday, 10/23/2018, 5:59 pm.


Group Assignment: Temple Analytics Challenge! [Due Wednesday, 10/31/18 at 11:59 pm]

The group project is based on the Temple Analytics Challenge (http://ibit.temple.edu/analytics/), a University-wide data analysis and visualization competition.

Here is the instruction for the group project CLICKThe group project is due by October 31, 2018. 

  • You should work in teams of up to four members.
    • Each member of the team will receive the same grade. Team member can be anyone at Temple University.
  • For each group, please email me the names and TUIDs (i.e. tuz12345) of all group members by October 12 (Friday) before noon.
  • You will complete the two deliverables for the challenge (both clearly displaying the names of your team members):
    • The graphic (or series of graphics) as a PDF.
    • A brief summary of no more than one page explaining your graphic and why you think it is effective – also as a PDF.
  • Your deliverables should be submitted via Canvas. Each group will only need to submit once.


Exam #1 Study Guide: Data/Information/ERD/SQL [During class time on 10/2]

  • The exam is closed book, closed notes. The exam will be a combination of multiple-choices and short-answer questions.
  • You will NOT be able to use a computer during the exam.
  • Exam # 1 covers all the lectures up to “SQL 1: Getting Information Out of a Database – Basic”. We will have a review session on Thursday (Sep 27th).
  • There will be an additional office hour on Monday (Oct 1st) 2:30-3:30 p.m.
  • Study Guide for Exam #1 (word)
  • Study Guide for Exam #1 (ppt)

Practice questions. Here are some practice questions, in case you want more exercises. Solutions are provided.


Please register for the IT Career Fair by Sep 14th (MIS Major/Minor only)

The IT Career Fair (https://ibit.temple.edu/careerfair/) is coming up on September 17, 2018.

There will be over 30 leading companies, including NBCUniversal, Ernst & Young, QVC, Pfizer, AmerisourceBergen, Grant Thornton, GlaxoSmithKline, TD Bank, Subaru, and Vanguard attending.

I strongly recommend you attending this event, because it’s a unique opportunity to talk to companies specifically motivated to hire MIS students. You should attend even if you have a job or internship lined up. You can use this fair as an opportunity to build your professional network!

The deadline for registration is September 14, so please please follow the link to register: https://ibit.temple.edu/registration/

How to set up MySQL Workbench

We’ll be using MySQL Workbench to create and execute SQL queries starting next week.

1) If you’re using your own laptop (Windows or Mac), please install the software before Sep 11th. You can get instructions for how to do both of those things in this Quick Guide to MySQL Workbench. Use the guide to setup your software and connection. If you’re installing this software on your own computer, I suggest you do it this early!

2) You will need a MySQL username and password. I will assign one to each of you, which you’ll find on Canvas under Grades>MySQL ID/PW.

3) If you’re using a lab computer, you will only need to configure a connection with your MySQL username and password (I will show you how to do it in class).

Assignment #1: ER Modeling [Due Thursday, 9/13/18 at 5:59 pm]

Here is the assignment instructions.

Use ERDPlus to complete the assignment. It is pretty straightforward to use, but this handy video shows you how to create an ERD and export the diagram as a graphic. That graphic can then be inserted into a Microsoft Word document.

Remember, you must submit a single Microsoft Word document – if you send multiple graphic files, or multiple Word files, you will not get credit for the assignment.

The assignment is due by Sep 13th, 5:59 p.m.