Business Analytics with Excel (I) Get Equipped! · A Multimedia Course on Data Analysis

Watch video Introduction at: goo.gl/2R31ND

About the Author

Z. Justin Ren is an Associate Professor of Business Administration in the Operations and Technology Management Department, Dean’s Research Fellow, and Senior Fellow of Health Policy Institute at Boston University School of Management. He was also a Visiting Scholar and Research Affiliate at Massachusetts Institute of Technology (MIT) Sloan School of Management from 2009-2013.

For almost ten years, Professor Ren has been teaching analytics courses which focuses on tools and frameworks that help managers gain market intelligence and make strategic decisions. He also teaches in executive education in financial risk management. He is a certified teacher by the Harvard Business School Case Method Discussion Leadership Program.

Professor Ren has consulted for Fortune 500 companies as well as start-ups. His work has been mentioned in Sloan Management Review, China Daily, and the World Financial Review. He has given lectures and presentations around the world at institutions such as Harvard Business School, MIT, Duke, Dartmouth, Georgetown, Emory, INSTEAD (France), Hong Kong University of Science and Technology, Peking University (China), and Tsinghua University (China).

Professor Ren has received several recognitions, including the INFORMS George B. Dantzig Dissertation Award, INFORMS Junior Faculty Paper Competition Award, and the Production and Operations Management Society (POMS) Wickham Skinner Early-Career Research Accomplishments Award.

Professor Ren received his M.S. in Operations Research and Ph.D. in Operations and Information Management from The Wharton School at the University of Pennsylvania.

Description to the Multimedia Series

This multimedia series is not about learning all the powerful functionalities of Excel. It will not make you a guru on Excel. In fact, it covers a rather small subsets of functions existing in Excel.

Rather, this book aims to help you become a better decision maker. A better manager or executive. A better homemaker or entrepreneur. A better thinker.

This introductory series on business analytics is designed for readers who are interested in building analytics skills and applying them into business situations such as:

-How to model demand for a new drug?

-How to predict stock prices? Price stock options?

-How to evaluate risk and uncertainty?

-How to detect sex discrimination from compensation data?

-Does it pay to invest long-term?

It will help you build a set of essential analytics skills such as:

-Finding information efficiently;

-Using commonly used math, statistical, and financial functions;

-Building a correct and clear model to analyze a problem;

-Scenario analysis to make decision under uncertainty;

-Summarizing information (e.g., with pivot tables);

-Finding patterns among data;

-Simulation and analyzing risks;

-Optimization for better decision making.

Some key feature of this multimedia series:

1. Each key lesson is accompanied by a how-to video

2. Templates and answers for each example are downloadable

3. Hyperlinks are provided throughout for quick referencing and feedback

4. Built for both Mac and PC

5. FREE lifetime updates of new videos, templates and modules.

The whole series has seven modules, each in e-book format:

1: Basic Skills

2. Model Building

3. Power Analytics with Data Tables and Pivot Tables

4. Visualizing data

5.