BUA 345
  • This website provides semester-long access to BUA 345 lecture slides, notes, and R code files, regardless of access to Blackboard.
  • Syllabus and Course Links
  • Lecture Material
  • Homework Assignments
  • Practice Questions
  • Installing R and RStudio
  • Interesting Data
Professor Pooler - Office: WSOM Room 518
  • In-Person Hours: Tue. Thu. 5:00 PM - 5:45 PM
  • Zoom Hours: Mon. Wed. 4:30 PM - 5:30 PM - Zoom Hrs. Link
  • Also available by appointment on Zoom or in-person
Spring 2025 Syllabus
  • NOTE: The order of the material varies slightly between semesters so the subjects covered in the syllabus may be updated as the semester progresses. I will always let you know if there are substantial changes.
Spring 2025 Absence Explanation Form
  • It is not possible to effectively keep track of absence excuses or PointSolutions technical issues through email.

  • If you are absent or have a temporary technical issue with Point Solutions, use this Google form to explain.

Spring 2025 BUA 345 Blackboard Site
  • Engagement Questions, Assignments, and Tests will be submitted on Blackboard.
Software Links
  • Point Solutions - Required by Lecture 3. Register from BUA 345 Blackboard site so that registration is linked to this course.

  • Posit Cloud - Cloud access to R and RStudio

  • R
  • RStudio
Software Training
  • LinkedIn Learning - Free for Syracuse University Students, Staff, and Faculty

    • R for Data Science: Analysis and Visualization - This training is optional and provides a good introduction to R and RStudion whch are used in this course.

    • Python Essential Training - Python is not used in this course but it is helpful for Analytics and Data Science.


  • DataCamp - An excellent (but not free) online learning center for many software packages. Costs can be subsidized (see below).

  • Whitman WIRE Initiative - The WIRE initiative will subsidize costs of online software training the results in certification.

    • Contact their office to arrange a meeting and develop a plan.
Instructions for Downloading and Saving Excel Files:
  1. Create a BUA 345 folder on your laptop’s Desktop.

    • NOTE: If you are on a campus computer, when you login, the desktop is connected to your ‘Syracuse University OneDrive’ and can be opened on SU computer when you login with your NetID and Password.
  2. Click link below to open file, then click File > Download > Microsoft Excel (.xlsx)

  3. Move file from Downloads to your Desktop BUA 345 folder.

PointSolutions Session ID: bua345s25
Excel Skills and Simple Linear Regression (SLR) Review
  • MAS 261
    • Helpful Lectures from Fall 2024
      • Lecture 17 - Language of Hypothesis Testing/One Sample t-tests
      • Lecture 20 - Introduction to Correlation and Covariance
      • Lecture 24 - Introduction to Simple Linear Regression
      • Lecture 25 - Simple Linear Regression Continued
      • Lecture 27 - Multiple Linear Regression
      • Lecture 28 - Introduction to Linear Transformations

  • Lecture 28 - Course Wrap Up and Some Review

    • Video Recording
      • Lecture 28 - 2025-04-24 - 3:30 PM
        • Only one recording is posted because the audio recording of the 2:00 PM lecture was unsuccessful.
    • Slides
    • Notes
    • PDF
    • Lecture 28 Excel File - Titanic Data
    • Respond here if you are interested in either of the possible Zoom Review Q&A Sessions before the final exam(s).

  • Lecture 27 - Stock Dashboard

    There is a very short in-class exercise on Blackboard associated with this in-class activity. This will count for today’s class particpation. No Blackboard submissions for this exercise will be accepted after midnight on Wednesday, 4/23.

    • Video Recordings
      • Lecture 27 - 2025-04-22 - 2:00 PM
      • Lecture 27 - 2025-04-22 - 3:30 PM
    • Example Dashboard
      • View in full-screen mode.
    • Stock Dashboard Instructions
    • Stock Dashboard R Project on Posit Cloud
    • Course Evaluations Link
      • We will set aside 5 minutes of class time for students to complete evaluations for all of their courses.

  • Lecture 26 - Forecasting - Part 2

    • Video Recordings
      • Lecture 26 - 2025-04-17 - 2:00 PM
      • Lecture 26 - 2025-04-17 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Forecasting Lectures and HW 10 - R Student Project
      • This R project includes .qmd files for Lecture 25, 26, and HW 10.
      • Updated on 4/15/2025. Delete project from 4/14.

  • Lecture 25 - Introduction to Forecasting

    • Video Recordings
      • Lecture 25 - 2025-04-15 - 2:00 PM
      • Lecture 25 - 2025-04-15 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Forecasting Lectures and HW 10 - R Student Project
      • This R project includes .qmd files for Lecture 25, 26, and HW 10.
      • Updated on 4/15/2025. Delete project from 4/14.

  • Lecture 24 - Linear and Integer Programming

    • Video Recordings
      • Lecture 24 - 2025-04-10 - 2:00 PM
      • Lecture 24 - 2025-04-10 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Lecture 24 Excel File
      • Lecture 24 - Excel Worksheets - Linear and Integer Programming.xlsx
      • Lecture 24 - Excel Worksheet - Cookie Question with updated Supply and Demand.xlsx

  • Lecture 23 - Introduction to Unconstrained Optimization

    • Video Recordings
      • Lecture 23 - 2025-04-08 - 2:00 PM
      • Lecture 23 - 2025-04-08 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Lecture 23 Excel File
      • Lecture 23 - Excel Worksheets - Unconstrained Optimization using Excel Solver.xlsx
      • Lecture 22 - Three Data Sets and Plots (with some solutions).xlsx

  • Lecture 22 - Introduction to Non-Linear Models

    • Video Recordings
      • Lecture 22 - 2025-04-03 - 2:00 PM
      • Lecture 22 - 2025-04-03 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • OPTIONAL R Project with Functions for Non-linear Models
    • OPTIONAL R Project HTML File
    • Lecture 22 Excel Files
      • Lecture 22 - Three Data Sets and Plots (without trendlines).xlsx
      • Lecture 22 - Three Data Sets and Plots (with some solutions).xlsx

  • Lecture 19 - Review for Quiz 2

    • Video Recordings
      • Lecture 19 - 2025-03-25 - 2:00 PM
      • Lecture 19 - 2025-03-25 - 3:30 PM
        • Note: 3:30 PM Lecture reording skips from Slide 1 to Slide 4 due to a recording issue.
    • Slides
    • Notes
    • PDF
    • Aggregated R Projects
      • Lectures 7-18
      • HW 4.2 - HW 7
      • Practice Questions for Quizzes 1 and 2
    • Lecture 19 Excel Worksheet
      • Titanic_Betas and Model Worksheet_w_Quiz_Format.xlsx

  • Lecture 18 - Logistic Regression

    • Video Recordings
      • Lecture 18 - 2025-03-20 - 2:00 PM
      • Lecture 18 - 2025-03-20 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Lecture 18 - R Student Lecture Project
    • Lecture 18 Excel Worksheets
      • Titanic_Betas and Model Worksheet.xlsx
      • Late_Payment_Betas Model Worksheet.xlsx

  • Lecture 17 - More about Model Selection

    • Video Recordings
      • Lecture 17 - 2025-03-18 - 2:00 PM
      • Lecture 17 - 2025-03-18 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • There is no R project for Lecture 17 but we may refer to the R project from Lectures 15 and 16 that is saved in your Posit Cloud Workspace.

  • Lecture 16 - Introduction to Model Selection Continued

    • Video Recordings
      • Lecture 16 - 2025-03-06 - 2:00 PM
      • Lecture 16 - 2025-03-06 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Open R Project for Lectures 15-16 that you already saved in your Posit Cloud Workspace.
    • Animal_Worksheets.xlsx

  • Lecture 15 - Introduction to Model Selection

    • Video Recordings
      • Lecture 15 - 2025-03-04 - 2:00 PM
      • Lecture 15 - 2025-03-04 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Lectures 15-16 - R Student Lecture Project

  • Lecture 14 - Categorical Regression - Interaction Model

    • Video Recordings
      • Lecture 14 - 2025-02-27 - 2:00 PM
      • Lecture 14 - 2025-02-27 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Lectures 13-14 - R Student Lecture Project
      • The data for Lecture 14 was added on Thursday, 2/27.

  • Lecture 13 - Categorical Regression - Parallel Lines Model

    • Video Recordings
      • Lecture 13 - 2025-02-25 - 2:00 PM
      • Lecture 13 - 2025-02-25 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Lectures 13-14 - R Student Lecture Project

  • Lecture 11 Review for Quiz 1 using Practice Questions / Intro to HW 5

    • Video Recordings
      • Lecture 11 - 2025-02-18 - 2:00 PM
      • Lecture 11 - 2025-02-18 - 3:30 PM

  • Lecture 10 - Multiple Linear Regression Models in R

    • Video Recordings
      • Lecture 10 - 2025-02-13 - 2:00 PM
      • Lecture 10 - 2025-02-13 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Open R Project for Lectures 9-10 that you already saved in your Posit Cloud Workspace.

  • Lecture 9 - More about Linear Regression Models in R

    • Video Recordings
      • Lecture 9 - 2025-02-11 - 2:00 PM
      • Lecture 9 - 2025-02-11 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Lectures 9-10 - R Student Lecture Project

  • Lecture 8 - Introduction to Regression Modeling in R

    • Video Recordings
      • Lecture 8 - 2025-02-06 - 2:00 PM
      • Lecture 8 - 2025-02-06 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Open R Project for Lectures 7-8 that you already saved in your Posit Cloud Workspace.

  • Lecture 7 - Introduction to R/Rstudio in Posit Cloud and Review of Correlation

    • Video Recordings
      • Lecture 7 - 2025-02-04 - 2:00 PM
      • Lecture 7 - 2025-02-04 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Lectures 7-8 - R Student Lecture Project
    • Excel Files - Download to a BUA 345 folder on your desktop:

      • Lecture 7 Review Question Data.xlsx

  • Lecture 6 - Data Queries

    • Video Recordings
      • Lecture 6 - 2025-01-30 - 2:00 PM
      • Lecture 6 - 2025-01-30 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Excel Files - Download to a BUA 345 folder on your desktop:

      • Lecture 6 Excel Worksheets.xlsx

  • Lecture 5 - Descriptive Analytics with Pivot Tables Cont’d

    • Video Recordings
      • Lecture 5 - 2025-01-28 - 2:00 PM
      • Lecture 5 - 2025-01-28 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Excel Files - Download to a BUA 345 folder on your desktop:

      • Lecture 5 Review Question Data.xlsx
      • Lecture 5 Excel Worksheets.xlsx

  • Lecture 4 - Descriptive Analytics with Pivot Tables

    • Video Recordings
      • Lecture 4 - 2025-01-23 - 2:00 PM
      • Lecture 4 - 2025-01-23 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Excel Files - Download to a BUA 345 folder on your desktop:

      • Lecture 4 Review Question Data.xlsx
      • Lecture 4 Excel Worksheets.xlsx
    • Posit Cloud Demo - Titanic Data - Click links

      • HTML file
      • R Project
        • Free Posit Cloud Account Required

  • Lecture 3 - Data Preparation and Conditional Formatting

    • Video Recordings
      • Lecture 3 - 2025-01-21 - 2:00 PM
      • Lecture 3 - 2025-01-21 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Excel Files - Download to a BUA 345 folder on your desktop:

      • Lecture 3 Review Question Data.xlsx
      • Lecture 3 Excel Worksheets.xlsx

  • Lecture 2 - Data Preparation in Excel

    • Video Recordings
      • Lecture 2 - 2025-01-16 - 2:00 PM
      • Lecture 2 - 2025-01-16 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Excel Files - Download to a BUA 345 folder on your desktop:

      • Lecture 2 Review Question Data.xlsx
      • Lecture 2 Excel Worksheets.xlsx

  • Lecture 1 - Welcome and Introduction to Business Analytics

    • Video Recordings
      • Lecture 1 - 2025-01-14 - 2:00 PM
      • Lecture 1 - 2025-01-14 - 3:30 PM
    • Slides
    • Notes
    • PDF
    • Excel Files - Download to a BUA 345 folder on your desktop:

      • Big_Mac_Index.xlsx

Simple Linear Regression (SLR) and Multiple Linear Regression (MLR)
Introduction to Non-linear Models and Optimization
Introduction to Forecasting and Creating Dashboards
  • Demo Videos will be posted to assist you.
HW 10 Demo Video Playlist
HW 9 Demo Video Playlist
HW 8
  • HW 8 - Part 1 - Demo Video Playlist
  • HW 8 - Part 2 - Demo Video Playlist

HW 7
  • R project on Posit Cloud
  • Demo Video Playlist

HW 6
  • R project on Posit Cloud
  • Demo Video Playlist

HW 5
  • R project on Posit Cloud
  • Demo Video Playlist

HW 4 - Part 2
  • R project on Posit Cloud
  • Demo Video Playlist

HW 4 - Part 1 - Demo Video Playlist
HW 3 - Demo Video Playlist
HW 2 - Demo Video Playlist
Additional Practice Questions
  • Demo videos

Quiz 2 Practice Questions
  • R project on Posit Cloud
  • Demo videos

Quiz 1 Practice Questions
  • R project on Posit Cloud
  • Demo videos
    • Unfortunately, when I recorded these videos, I was still very hoarse. I appreciate your patience while I recover.
Notes
  • Students in BUA 345 are NOT required to install R and RStudio on their laptop but they are encouraged to.

  • R and RStudio are two separate software components. Download and install R and then download and install RStudio.

  • When updating your version of R or RStudio, uninstall the previous version first.

Downloading and Installing R
  • R can be downloaded from the Comprehensive R Archive Network

  • Video Demo for downloading and installing R on a Windows OS
  • Mac installation is similar.

  • If you do not need to uninstall an out-of-date version of R, skip to 0:53.

  • The current version of R is 4.4.3.


Downloading and Installing RStudio
  • RStudio can be downloaded from Posit, the parent company of RStudio.

  • Video Demo for downloading and installing RStudio on a Windows OS
  • Mac installation is similar.

  • If you do not need to uninstall an out-of-date version of RStudio, skip to 0:56.

  • The version shown in the video is from August of 2024 and is out-of-date.

  • The current version of RStudio is 2024.12.1.563.

NOTES:
  • Many data sources provide data in a downloadable format such as Excel (.xlsx) or .csv. I recommend saving data as CSV UTF-8 files with a .csv postscript.

  • The list below is in alphabetical order and is not an exhaustive list.

  • Some data sources do not provide data in a downloadable format so the data values have to be scraped from the website.

Billboard
  • Scraping required
BEA - Bureau of Economic Analysis
BLS- Bureau of Labor Statistics
Box Office Mojo
  • Scraping required but it’s straightforward.
Competence Centre on Composite Indicators and Scoreboards
  • Great source for unusual datas
Data World
  • An ecclectic library of data that can be searched by topic of interest
Department of Energy - Prices & Trends
Eurostat
  • A wide variety of data about Europe can be accessed at this site.

  • Aanalogous to US.Gov for the United States.

Federal Reserve Data
Kaggle
  • An ecclectic library of data that can be searched by topic of interest
  • Kaggle also holds competitions where data scientists can win money and build a reputation
Our World in Data
  • Good source for geographic and demographic data
Sports Reference
  • Scraping required
  • Wide range of sports data
Statista
  • Syracuse University Libraries provides paid membership access
  • Use link above and then sign in with SU NetID and Password
  • Excellent resource for public and private sector data
U.S. Energy Information Administration
  • Excellent information on electricity usage by location or region.
Data.Gov - Data and Statistics about the U.S.
  • Includes MANY topics including BLS, DOE, and EIA above
Yahoo Finance
  • Stock data can be directly imported into R as an xts dataset