Instructor: Jing Gong, Section 002/004

Software/Tool Instructions

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!

Setting up MySQL Workbench Before Week 4

We’ll be using MySQL Workbench to create and execute SQL queries (to interact with databases). That will start around February 6, 2018.

(1) If you’re using your own computer (Windows or Mac), you’ll need to install the software;

If you’re using a lab computer which already has MySQL Workbench installed, you’ll still need to configure a connection to access databases with your username and password.

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.

(3) Whether you use a lab computer or your own computer, you’ll also need a MySQL username and password. I’ve assigned one to each of you, which you’ll find in the Under Grades in Canvas.

  • To find it, in Canvas, click Grades, then click “MySQL Account
  • You will find the MySQL username and password are added as comments to “MySQL Account.”
  • The first value that starts with “m” is the username, and the second value is the password.

Using ERDPlus to Creat Entity Relationship Diagrams (ERD)

Starting from Thursday, January 18, we will learn how to create Entity Relationship diagrams (ERDs) to model databases.

To create ERDs, we will use ERDPlus, a free tool that is quite easy to use.

Specifically, we will use the standalone version of ERDPlus (https://erdplus.com/#/standalone), which allows us to create an ERD within a browser.

This is a short YouTube tutorial on the site that shows you how to create a diagram, and export the diagram as an image which can be placed into a Word document. Please watch this video on your own before Tuesday, January 23.