Business Analytics Commons^™

Investment Decision Making, Muhammad Yaseen, Di Wu

Open Educational Resources

A newly established commercial bank, founded in 2021, has accumulated excess capital reserves. The bank is evaluating long-term investment options to deploy this capital in a way that balances growth and risk. The investment committee is considering two primary strategies: investing in a diversified technology-focused ETF, QQQ, or investing directly in selected individual technology stocks.

The bank's senior management wants capital growth, but it also needs to manage risk exposure. A bank cannot treat an investment decision only as a search for the highest return. It must also consider volatility, concentration risk, liquidity, downside periods, and whether the strategy fits …

German Energy Crisis, Liomar Jimenez, Malachy Mclaughlin, Muhdee Nawab, Mouhamed Sarr, Di Wu

Open Educational Resources

For most of the twentieth century, nuclear energy was the quiet backbone of Germany's electricity system. At its peak in 1997, nuclear power supplied over 31 percent of all electricity generated in the country. It was a reliable, low-cost source that kept German industries competitive across Europe. The country's industrial base, including automakers, chemical producers, and heavy manufacturers, depended on affordable, stable power. Nuclear delivered exactly that.

The political climate changed in the late 1990s. After years of advocacy based on concerns about nuclear waste and reactor safety, the Green Party joined the Social Democrats to form the Red-Green Coalition …

Credit Card Analysis, Di Wu

Open Educational Resources

A credit card business unit at a bank is facing a retention problem. More customers are leaving the bank's credit card services, and the retention manager wants to identify which customers are most likely to churn so the bank can intervene before the account is lost.

The bank has customer demographic, relationship, and transaction data for more than 10,000 credit card customers. The data includes age, gender, education, income category, card category, months on book, customer inactivity, contact frequency, credit limit, revolving balance, transaction amount, transaction count, and whether the customer attrited.

You are a business analyst on the bank's …

Smartphone Usage, Charles Howard, Josiah Nkele, Berner Hernandez, Di Wu

Open Educational Resources

A major smartphone company is studying how smartphone usage affects users' stress, productivity, and sleep habits. As part of the product development team, you have been assigned to analyze user behavior data to help create digital wellness features that improve the overall user experience.

The company has collected behavior data from over 50,000 users to better understand how smartphone habits may influence focus, stress, and performance. By exploring this data, the team hopes to discover patterns that can guide healthier digital usage and create a better balance between daily life and technology use.

Senior product managers are considering several possible …

Airbnb Studies, Fatoumata Diabate, Maria Estevez, Jaliah Fabre, Di Wu

Open Educational Resources

In the high-stakes world of short-term rentals, Homeland Sellers serves as an advisory firm for property buyers navigating the global Airbnb market. Historically, investors in the sector have often been led by intuition and gut feeling. That is a dangerous strategy in an increasingly regulated environment. To protect capital, Homeland Sellers is transitioning to a more rigorous, data-driven investment model.

Aspiring hosts face a minefield of financial and legal hurdles. Ignoring local HOA restrictions, fluctuating property tax structures, or strict licensing requirements can create serious risk for net operating income. Beyond regulatory compliance, investors must also account for guest appeal …

Staffing Decisions At Gabriana Cup, Ana Jimenez, Edith Oblitas, Gabriela Pena Guzman, Adriana Valdivia, Di Wu

Open Educational Resources

Labor costs are one of the largest operational costs in the service industry. Overstaffing increases expenses unnecessarily, and understaffing reduces service quality and customer satisfaction. You are a business operations analyst working for Gabriana Cup, a local coffee shop. The owner has observed that certain hours appear significantly busier than others, creating operational pressure during peak times. The owner would like to reduce unnecessary labor costs and optimize Gabriana Cup's staffing practices.

Staffing schedules are currently based on assumptions rather than historical sales patterns, costing the coffee shop owner through wasted inventory, overstaffing, understaffing, and unnecessary labor costs. The coffee …

Netflix Content Strategy, Di Wu

Open Educational Resources

Netflix operates in a highly competitive streaming market where content strategy directly affects subscriber acquisition, retention, brand positioning, and international growth. A streaming platform cannot simply add more titles indefinitely. Content licensing, production budgets, regional demand, maturity ratings, and genre balance all shape which titles should be prioritized.

You are a content strategy analyst on Netflix's global catalog planning team. Senior management is preparing the next annual content review and wants a data-supported recommendation about how the catalog should be positioned. The team is especially interested in whether Netflix should continue emphasizing movies, expand TV shows more aggressively, prioritize specific …

Bba405-Management Decision Making Syllabus, Di Wu

Open Educational Resources

Syllabus for BBA405 Management Decision Making course.

Smartphone And Sleep, Jesenia Ortiz, Melanie Bonilla, Eduard Reyes, Jose Rivera

Open Educational Resources

The case study and Decision: You are a data analyst advising a university-affiliated research and wellness initiative that is evaluating whether late-night smartphone use should be formally discouraged as part of student wellness guidance. Over the past academic year, administrators have raised concerns about declining sleep quality among students and its potential impact on academic performance, health, and decision-making. While smartphones are an essential tool for communication and learning, their use immediately before bedtime has emerged as a possible contributor to sleep disruption. The initiative must decide whether the available evidence is strong enough to justify recommending that students limit …

When The World Hits Play, Eileen Mazariegos, Danjela Halilaj, Yosmairy Guzman, Freddy Cruz Osorno

Open Educational Resources

The case study and Decision: In 2025, Lehman College administrators face a critical decision: how can music be strategically used to improve student engagement, emotional well-being, and campus connection? The decision must be made now, as rising academic stress, digital isolation, and declining campus interaction are affecting student experience. Leadership must determine whether to invest in a data-driven, campus-focused music platform or continue relying on generalized commercial streaming experiences that do not reflect student needs. The outcome of this decision will shape how students connect emotionally, socially, and academically on campus.

Nyc Fire Causes, Alex Rodriguez, Anyely Rojas Romero, Brianna Itwaru, Shahreen Sneha

Open Educational Resources

The case study and Decision: You are a team of newly hired Data analysts who have been chosen to conduct a case study for the Department of New York City. There is an interest in discovering what exactly is causing fires in New York City. Also, how can we prevent them?

Treasury Bills, Di Wu

Open Educational Resources

The Scenario and The Decision: You are a Data Analyst at a mid-sized investment advisory firm that manages portfolios for both individual and corporate clients. Recently, a significant portion of the client base has expressed interest in shifting capital toward U.S. Treasury bills (T-bills) as a low-risk investment strategy. However, the firm faces a dilemma: while T-bills are considered "safe," their prices and yields fluctuate based on economic conditions and investor demand, making market entry timing critical. The firm has formally requested that you provide a comprehensive analysis to guide their future investment decisions.

Zero Textbook Cost Syllabus For Bus 9430 (Business Analytics Projects Management), David Messineo

Open Educational Resources

This course delves deep into the pivotal roles, multifaceted opportunities, and inherent challenges faced by organizations aiming to harness business analytics as a competitive edge.

• Business Analytics Frameworks: We'll tap into various frameworks such as Lean, Six Sigma, Benchmarking, Kaizen, Value Chain, Balanced Scorecard, and Strategy Maps. While prior knowledge of these is not mandatory, a little research will prove invaluable when tackling class assignments.

• Project Lifecycle Management: The course draws upon CRISP-DM, Design Thinking, Story-Telling, Systems Thinking, TQM, and Agile/Kanban Methods to instill and enhance a culture of data-driven, evidence-based decision-making in an enterprise.

Prior exposure to these methodologies …

Zero Textbook Cost Syllabus For Cis 3920 (Intro To Data Mining), Lawrence Cohen

Open Educational Resources

To successfully compete in today’s global business environment an organization must constantly monitor, recognize, and understand every aspect and every issue of its operations, its industry, and the overall business environment. This course focuses on data mining and understanding the steps of a data mining project from both a business and technical perspective.

Students will actively participate in this course through class discussions, project preparation and presentation, and hands-on labs. We cover both supervised and unsupervised data mining techniques for tasks like targeted mailing campaigns, customer segmentation, customer churn, fraud-detection, and market basket analysis.

In this course, I encourage students …

Zero Textbook Cost Syllabus For Mkt 3600 (Marketing Information For Decision Making), Kapil Bawa

Open Educational Resources

Have you ever wondered how marketers get information about markets, determine what consumers want and decide how to position products? Or how pollsters, scientists and researchers can manipulate the design of a survey or a research study to get the findings that they want? Or why some polls seem to be “stacked” to show overwhelming support or opposition to a particular issue?

This course reveals those techniques and tactics, and helps you learn how to critically evaluate the quality of the information you are exposed to on a daily basis. It provides an introduction to marketing research methods, marketing analytics …

Zero Textbook Cost Syllabus For Cis/Sta 3920 (Data Mining For Business Analyitics), Vinayak Javaly

Open Educational Resources

Data Mining is the process by which useful information is extracted from large amounts of data. This course is designed to provide students with the necessary tools and techniques to perform data mining and business analytics. This course is intended as an introductory module targeted at individuals who plan to work with data (modeling, data management) as well as towards those who will work with data scientists. While the course will primarily focus on modeling and evaluation, it will also include data preparation and examination. Modeling techniques covered include decision trees, clustering, and other methods. Emphasis will be placed on …

How To Create A Pivot Table And A Histogram, Harini Mittal

Open Educational Resources

This file gives instructions on how to create a pivot chart and histogram using excel sheet. The instructions have been adapted from the following textbook, but supplemented with screen shots for better understanding.

Anderson, Sweeney, Williams, Camm, Cochran, Fry and Ohlmann. Essentials of Statistics for Business & Economics, 9th Edition

How To Construct A Pie Chart, Harini Mittal

Open Educational Resources

This file provides step-by-step instructions on constructing a pie-chart using excel.

How To Construct A Bar Chart, Harini Mittal

Open Educational Resources

This file gives step-by-step instructions to construct a bar chart in excel.

How To Construct A Frequency Distribution For Non-Numeric Data, Harini Mittal

Open Educational Resources

This is a step-by-step instruction file with screenshots to help anyone construct a frequency distribution table with non-numeric data.

Eco 230 / Mgt 230 Introduction To Economic And Managerial Statistics, George Vachadze

Open Educational Resources

No abstract provided.

The Law Of Black Mirror - Syllabus, Yafit Lev-Aretz, Nizan Packin

Open Educational Resources

Using episodes from the show Black Mirror as a study tool - a show that features tales that explore techno-paranoia - the course analyzes legal and policy considerations of futuristic or hypothetical case studies. The case studies tap into the collective unease about the modern world and bring up a variety of fascinating key philosophical, legal, and economic-based questions.

Tech Policy And Legal Theory Syllabus, Yafit Lev-Aretz, Nizan Packin

Open Educational Resources

Technology has changed dramatically over the last couple of decades. Currently, virtually all business industries are powered by large quantities of data. The potential as well as actual uses of business data, which oftentimes includes personal user data, raise complex issues of informed consent and data protection. This course will explore many of these complex issues, with the goal of guiding students into thinking about tech policy from a broad ethical perspective as well as preparing students to responsibly conduct themselves in different areas and industries in a world growingly dominated by technology.

Sample Syllabus For Teaching Online Database Modeling And Management, Joshua Moritz

Open Educational Resources

Students learn the basics of database modeling and managements as well as the analytical techniques and tools used to assess, enhance, and profit from customer-relationship management. The course reviews database technology, organization and planning including technology needs and outsourcing considerations; sampling techniques such as nth selects and frozen files; creating powerful predictor variables such as univariate and cross tabulations, ratios, time series variables, and other measures. The course also covers predicting customer actions by using multiple linear regression and correlation to model response, payment, attrition, churn, and other factors that assist in segmentation. Students also learn how to combine prospect …

Business Economics: Data For Decision Making, Brian Barnier, Kevin Foster

Open Educational Resources

Syllabus for a course in data analytics for business economics, focusing on use of source data sets to answer the "why?" questions hidden in aggregate averages used in theory and "headline" news releases. Zero cost course using data available widely on the web. Optional texts are trade books available widely in libraries or used copies at low cost.

Zero Textbook Cost Syllabus For Cis 3367 (Spreadsheet Applications In Business), Soniya Dsouza

Open Educational Resources

The primary focus of this course is to learn how to construct and use powerful spreadsheets for effective managerial decision-making. This course is mostly project- oriented with a dual focus on spreadsheet engineering and quantitative modeling of financial applications. Students will learn to develop powerful spreadsheet models and perform data analysis using Pivot Tables, VLookUp, Data Validation techniques and Sub Total functions. Students will also learn how to enhance spreadsheets by creating dashboards on financial data. The Visual Basic (macro) concepts will also be introduced to students. With the knowledge and hands-on experience of these concepts, students will be prepared …