Business Intelligence Commons^™

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 …

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 …

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 …

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 …

Bba405-Management Decision Making Syllabus, Di Wu

Open Educational Resources

Syllabus for BBA405 Management Decision Making course.