Many undergraduates take at least one business analytics course at the 200 course level. A book that I and other professors at our business school have selected to teach business statistics is by Albright and Winston
Business Analytics: Data Analytics and Decision Making (Amazon link)
This book provides three essential ingredients to a successful course:
- Covering core concepts like descriptive statistics and optimization
- Providing relevant examples in a business context (e.g. how much inventory should a retail store order)
- Showing step-by-step instructions for how to do applications in a specific software which in this case is Excel
Microsoft Excel is essential for business school graduates (arguably all college graduates). No one is born knowing how to select cells or enter formulas. The book does not assume anything, so the professor does not have to require supplementary material on how to use Excel. There are lots of exercise and examples that teach proficiency in the tool while demonstrating the concepts. Analytics courses should be hands-on.
Sometimes statistics courses do not feel like they allow for critical thinking or discussions. There is only one correct formula for an average, and it is merely and exactly what the formula determines it to be. Therefore, an interesting addition to a technical class is the book by Muller
The Tyranny of Metrics (Amazon link)
Muller spends most of the book pointing out cases where measuring results backfired. He is not so much against “analytics” as he is skeptical of pay-for-performance management schemes. Many of these schemes were sold to the public as incredible technocratic improvements, such as No Child Left Behind. I do not always agree with Muller, but he gives students something to debate. Note that only select chapters should be assigned so that it does not take up too much time from the other course material.
“…Microsoft Excel is essential for business school graduates..” — yes