This course focuses on spreadsheet modeling to support decision making by organizations in service industries, such as healthcare, banking, distribution, and education. Students develop critical thinking and problem solving skills to address real-world problems. The spreadsheet modeling capability acquired is highly practical for managers and administrators. Course topics cover display charts, data exploration. decision-making logic, reference functions, financial impact of loans and investments, project management, what-if analysis, goal seek. visual basic programming, and other advanced tools.
This course discusses the process of business analytics by developing a business intelligence solution, including problem definition, data preparation, descriptive and predictive analyses, evaluation of results, implementation and deployment. Data-oriented methods using spreadsheet and structured query language (SQL) are emphasized for business transaction capturing, data aggregation and online analytic processing (OLAP). Students will employ a variety of software tools in the development of a data warehouse, including ETL (extraction, transformation and loading) and visual data representations (e.g., data cubes).
Novel problems require innovative solutions - this course introduces students to the power and flexibility of programming and scripting languages such as R and Python, applied to problems in business analytics. Students will learn how to acquire and deploy software packages relevant to their problem, then use them together with tools such as SQL to collect and prepare data, customized analyses according to specific needs, and create outputs which effectively communicate the results.
This course introduces students to the concept of social media analytics and techniques used to analyze social media data such as texts, networks, and actions. Students will learn how to extract data from popular social media platforms and analyze such data using software tools such as R to identify trends, sentiment, opinion leaders and communities.
This course introduces students to data visualization and dashboarding. Students will learn best practices in data visualization, data retrieval using structured query language (SQL), polish analytical skills, and learn how to design dashboards to support managerial decisions. Students will have the opportunity to gain hands-on experience in data retrieval and visualization. Students will use Tableau as their main tool for data visualization and dashboarding but will develop transferable skills which can apply to most common software packages in the field.
This course provides students with knowledge and skills in the various decision analytical techniques for managerial decision making including big data analytics. A number of well-defined data mining techniques such as classification, estimation, prediction, affinity grouping and clustering, and data visualization will be covered. The Cross Industry Standard Process for Data Mining (CRISP-DM) will also be discussed. The data mining techniques will be applied to diverse business applications including: target marketing, credit risk management, credit scoring, fraud detection, medical informatics, telecommunications and web analytics.
This course introduces students to the management and coordination of enterprise data resources to improve enterprise-wide decision-making. Students will learn how to identify key performance indicators from enterprise data, how to differentiate enterprise analytics from other forms of analytics, how to determine what proprietary data will provide analytical advantage to maximize the impact on the enterprise, recent technologies for analytics and best practices from recent cases. Students will engage in an iterative process of exploring data from multiple functional areas within an organization to derive actionable insights as well as communicate findings to help enterprises improve the quality of their decisions.
This course provides students with comprehensive understanding of problems and solutions related to information security and information assurance in organizational contexts. Students learn how to conduct quantitative and qualitative security risk assessment analyses related to site safety and security, hardware and software reliability and risks, and network reliability and security. Students will carry out data collection and analytics methodologies which address expected failures, incidence and severity of attacks, accidents and acts of nature, and their impacts on operations and budgets.
An introduction to statistical methodology to include probability concepts, inference techniques, analysis of variance, regression analysis, chi square and other non-parametric analyses. This course focuses on the use of the computer in performing statistical analysis.
*Students without statistics background will be advised to take QUMT 6303 as an elective course
This course introduces students to modern machine-learning methods that can be applied to build predictive models & discover patterns in data for better-informed business decision-making. Students will learn implementation of the machine learning techniques in R programming language for understanding complex datasets. This course will enable students to approach business problems by identifying opportunities to derive business value from data-driven business intelligence. Prerequisites: QUMT 6303 or QUMT 3341 or equivalent.
This course introduces the principles and techniques of prescriptive analytics. These provide business entities and policy makers with rational tools for evaluating performance, making decisions, designing strategies, and managing risk. Students will learn how to use analytical models to evaluate uncertainty that is prevalent in many business decisions. Since Business problems often have alternative solutions, students will learn how to use analytical models to assess various business solutions and identify the best course of action. This course involves a hands-on learning experience with spreadsheet modeling and other analytical packages. The emphasis is on how to employ these analytical methods to facilitate managerial decision making in diverse industries and functional areas.
