Intro to Business Analytics course

Welcome to my Business Analytics (BA) class. In this first module you will get an introduction to the world of business analytics and modeling as well getting a flavor for how this class will work. MIS 4460/5460 uses spreadsheets as the primary technical vehicle for learning about business analytics. I also teach an advanced business analytics course called Practical Computing for Data Analytics in which we use R, Python, and Linux.

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. Usually, I teach BA in a computer lab and run it as a “modeling studio”. We 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. For a few years, I have also offered it both partially and fully online.

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 how the Moodle site is structured 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

Downloads_Module01_Kickoff.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 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.

Since you’ll be doing some text importing in one of the activities below, I put together a quick screencast to demo the new wizard.

Screencasts and other activities

Okay, let’s go. Start by watching the following video. I’ll be using the PPT slides from the Downloads file to structure my introduction to this class and I suggest you download them and have them open while watching the video as many of the slides have hyperlinks to web sites we’ll be exploring.

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 file. 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!

Now let’s get the big picture on analytics and this class.

I already covered a bunch of things related to course logistics and the course websites in the Course Welcome video and in the Week 1 Welcome video. I’m NOT going to repeat these things here. There are just a few more course and syllabus details I want to mention now. Note that the video below is from Fall 2023 but the content has not changed.

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.

Let’s finish this session with a high level look at the role of analytics today and both educational and professional opportunities in this field. Check out the rest of the slides in this presentation and explore some of the links. They will provide a glimpse into where analytics is used today and how it is being taught today.

Explore (Optional)

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

Check out my collection of links about the field of business analytics. This is from the Resource Center section of this courseweb.

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.