Intro to Business Analytics

In this first module you will get an introduction to the world of business analytics and modeling as well as getting a flavor for how this class will work. MIS 4460/5460 uses spreadsheets as the primary technical vehicle for learning about business analytics.

Intro and Objectives

After this module you will:

  • understand how this class works,
  • have had a preview of some of the types of things you'll learn and the activities you'll do in this course,
  • be ready to learn all kinds of cool business analytics things.

I created this course back in 2000 and have been teaching it every year since then. I used to teach BA in a computer lab and run it as a "modeling studio". We would do many hands-on exercises in class, I'll do mini-lectures and/or technique demonstrations and we had plenty of open work time in the lab. Since 2020, I have taught this course fully online. I try to make it as similar as possible to the lab based course.

I have broken up the course into a set of modules. In this first module you will get an introduction to the topic of business analytics, learn all about the logistics of how the course will work and get a chance to jump in and do some hands-on activities that will give you a flavor for the course.

Warning

During the first module of the class, we will do several challenging hands-on activities. They are meant to serve as a PREVIEW of some things we'll be learning about in the class as well as to set the tone for the course. I certainly do NOT expect that you already know the stuff in these challenges. So, do not panic if much (or even all) of the material is new to you. We'll be learning about all of this and much, much more over the course of the semester.

Readings

Business Analytics (BA) - Chapter 1: Introduction to Data Analysis and Decision Making

Downloads And other resources

download_intro.zip

Modules will usually contain a link to a zip file containing all of the files we might use during the module. Download the zip file to your computer (or storage device). Go to where you downloaded it and extract it using either Windows Explorer or a utility such as 7-zip (free). With a utility like 7-zip, it's easiest if you just do a right click on the zip file and select the Extract to here... option. It will unzip the file into a folder with the same name - in this case, download_intro.

Warning

In general, do NOT open files while they are still inside the zip file. This almost always leads to bizarre problems, especially since we use all kinds of add-ins, VBA, etc.

What happened to the old Text Import Wizard in Excel 2016?

The classic Text Import Wizard was replaced in XL2016 with the new "Get and Transform" tools. These provide powerful import and data transformation tools. Power Query is integrated as well which allows import from multiple data sources. These tools are pretty easy to use once you explore them a bit. If you want access to the classic Text Import Wizard, you can do that through File | Options | Data and then enable the legacy wizard(s). This applies to the old Web Query tool as well.

Screencasts and other activities

Okay, let's go. Start by watching the following video. I'll be using the intro slides (slides_intro.html) (also available in html from the Downloads folder) to structure my introduction to this class and I suggest you have them open while watching the video.

As you are watching the videos in this module, there will be times that you will be pointed towards additional videos for hands-on excercises using Excel. The Excel files needed for these exercises are in the Downloads folder. The work you do based on these "Exercise Vids" is NOT graded and you will NOT submit any files. These are the kinds of activities that we'd normally do in class together in the computer lab.

Time for the first hands-on challenge!

Data Analysis Challenge

Now let's get the big picture on analytics.

I already covered a bunch of things related to course logistics and the course websites in the Course Welcome video, in the Week 1 Welcome video and in the Announcements. Make sure you read through the syllabus - especially take a look at the grading section and the info on late days.

Now it's time for a little modeling challenge. After opening the SchedulingDSS.xlsm file, make sure you allow the macros to run. Usually you'll get a little yellow warning just below the ribbon and a button labeled "Enable content" (or similar) that you can click to allow the macros to run.

Let's get a bit of an historical perspective on the field of business analytics.

And for our last challenge, let's look at a simple simulation model of a project management problem.

Explore some of the links in the slides and in the Explore section below.

Explore (OPTIONAL)

This section will typically have links related to the topic, ... or not. Have fun exploring and learning more.

Web scraping Yahoo Finance

This is why the Yahoo Finance automated web query for historical stock price data will no longer work). Time for a new solution. Sounds like a good project.

Also, reading the comments below the blog post gives some good examples of how NOT to ask questions in technical forums. There are some good ones as well. See if you can spot the differences.

The Financial Hacker website wrote a goodbye message to this service.