MSBA Technology Setup Guide

PostgreSQL

In the Business Analytics Foundations concentration, you’ll use PostgreSQL to create, query, and manage databases. 

Installing PostgreSQL is easier to install with Docker. To install PostgreSQL using Docker, follow the steps below:

docker pull postgres

  • To run the postgres container, copy, paste, and run the following command in your terminal:

docker run --name postgres -p 5432:5432 --restart always -e     POSTGRES_PASSWORD=111 -d postgres 

Note: The command above is passing "111" as the PostgreSQL password and launches the database server on your machine. You can choose your password—make sure to remember it!

If you do not want to use Docker, you can directly install PostgreSQL on your computer without Docker by following these instructions. The instructions will also help you set up a server and create a database. 

PGAdmin

After installation of PostgreSQL, you’ll need a GUI (graphic user interface) to interact with the database server installed on your machine. Install PGAdmin locally on your machine by downloading the pgAdmin4(v6.19) installer Mac or Windows. Then, launch the installer and complete the installation.

Tableau

In the Business Intelligence course (part of the Communicating with Data concentration), you’ll use Tableau to build data visualizations. 

Download and install Tableau Desktop. You should be able to use the default 14-day trial to complete the required tasks. However, if you would like to extend your access, fill out this form to request a free one-year student license. It'll take several days to process, and you should expect an email from Tableau requesting enrollment verification, which Quantic Student Affairs is ready to provide for you.

Python Development Tools

In the Analytics Methods and Frameworks concentration, you’ll use the Python coding language to do analysis on real datasets. You’ll need the Python development tools and programming environment to practice. There are many ways to do so. We recommend the following:

Google Colab

Python Refreshers

If you don’t know Python or would like to refresh yourself on the basics, prepare for the program by completing this Python Refresher Exercise developed by our faculty. When you’ve completed it, review the solution.

If you are new to Python programming, we also strongly recommend you take Google Crash Course on Python early on during the course of your study. 

We’ve also made Quantic’s Python courses optionally available to you if you want a deep dive! To view them, search “Python” in the Courses tab of the Quantic app.

Anaconda Distribution

At the completion of Communicating with Data and before starting Analytics Methods and Frameworks, to simplify package management and deployment, you may like to use Anaconda, a distribution of the Python and R programming languages for scientific computing, which includes data-science packages suitable for Windows, Linux, and macOS. 

Install and configure the Anaconda distribution provided here. 

R Programming Environment

In the Analytics Methods and Frameworks concentration, you’ll learn how to use R to do statistical computing, data mining, and data visualization.

You’ll need to install the R Programming Environment, including the following two tools:

  • R: Download R from the official R website.
  • R-Studio: R-Studio is an IDE (integrated development environment) for R. To set up the open source, free version of R-Studio, follow the instructions at the RStudio downloads page.

Generative AI

We encourage you to use generative AI tools as a study companion to help you build a solid data science foundation, with the freedom to select any such tools you prefer. For an optimal experience, we recommend considering a subscription to ChatGPT Plus, which you can sign up for at chat.openai.com.

Still need help? Contact Us Contact Us