The course aims to teach students the process, models, and tools for data analysis and analytics in business, such as in finance, marketing, etc. The course will teach students the practical skills to employ software packages (such as spreadsheets and statistics software) and apply necessary extensions (such as with add-in tools, macros, scripts, queries, etc.) to analytical framework and tackle business data analysis problems for corporation manage and decision making. On completion of the course students should be able to
(a) understand the target and requirements of a selection of critical business data analysis problems;
(b) manage the statistical techniques/models for data analytics;
(c) implement the models into a software packages, such as spreadsheet, and adapt the models through add-ins and scripting/programming capabilities (such as using macro and VBA); and
(d) analyze and interpret the outputs of models to support decision making in finance, marketing, accounting, etc.