Why include analytics as part of the School of Information Technology curriculum?

Why include analytics as part

of the School of Information

Technology curriculum?

Lee Foon Yee, Senior Lecturer

Agenda

 Background Introduction

 Initiation of Diploma in Financial Informatics (DFI)

 Rational for Analytics in DFI curriculum

 How SAS BI & Business Analytics is used in DFI curriculum

Nanyang Polytechnic (NYP)

 A tertiary institution dedicated to meeting the manpower needs of Singapore since 1992

• Students seeking a quality polytechnic education

• Working professionals looking at upgrading opportunities

 It has seven schools offering a wide range of courses • School of Engineering

• School of Information Technology

• School of Design

• School of Interactive & Digital Media • School of Chemical & Life Sciences • School of Business Management • School of Health Sciences

School of Information Technology (SIT)

 Offer six IT diploma courses

• Diploma in Information Technology • Diploma in Business Informatics • Diploma in Engineering Informatics • Diploma in Business Enterprise IT • Diploma in Information Security

• Diploma in Financial Informatics

 Centre for IT Innovations (CITI)

• A platform for staff and students to develop innovative and effective IT software solutions and services for the industry • Our partners include IBM, Microsoft, SAP, Oracle, Cisco

Diploma in Financial

Informatics (DFI)

Learning Objective

To define business requirements in financial services and translate them into implementable IT

solutions.

Focus Areas

• Banking Solutions & Architecture • Consumer & Corporate Banking • Investment & Treasury

• Business Intelligence & Analytics

Course Structure

• Laws & Ethics of IT

• Database Systems

• IT in Governance

• Software Engineering

• InfoSecurity & Business Continuity • Enterprise Application Development • Accounting • Economics • Business Finance

• Capital Markets & Financial Instruments

• Risk Management

• Investment & Treasury

• Consumer Banking

• Corporate Banking & Trade Finance

• Personal Financial Planning & Insurance

• IT for Financial Services Industry

• Business Intelligence & Analytics

• Business Process Management

• CRM

• Mobile Applications & Services

• Enterprise Solutions

• E-Banking Technology

• Semester Projects

• Final Year Project

• Industrial Attachment Banking Technology &

Business Intelligence & Analytics is Gaining Importance!

Business Intelligence & Analytics

Curriculum Objectives (2010)

 Apply BI concepts to decision making

 Apply dimensional modelling techniques in the design of data warehouse, basing on business requirements

 Apply ETL (Extraction, Transformation and Load) concepts to load quality data into data warehouse

 Understand the difference levels of business analytics

 Use OLAP technologies and BI reporting tools

 Appreciate the use of data mining techniques like

Classification, Clustering and Association to discover patterns

Levels of Business Analytics

The Forrester Wave

Predictive Analytics And

Data Mining Solutions, Q1 ‘10

Why we chose SAS?

 Widely used by major Local and International Financial Institutions

 Functionality and Completeness

 Usability and Visualization

 Cost and Licensing Schemes

 Training Materials and Support

Final Decision on Platform & Tools for DFI

 SAS Educational Analytical Suite • SAS 9.2

• Enterprise Guide 4.2 (EG)

 SAS Enterprise BI Server • Web Report Studio

• Add-In for Microsoft Office (AMO)

 SAS OLAP Server

• OLAP Cube

 SAS Enterprise Miner 6.2

Curriculum Delivery

 Business Intelligence & Analytics Module • To learn the concepts and technologies

• Students learn through lectures, tutorials, practical lab sessions, sharing and talk sessions by industry speakers

 Business Intelligence & Analytics Project

• To apply the concepts and technologies learnt to a project scenario

• Students work in group of 4 to 5 students under a supervising lecturer

 The first polytechnic using SAS platform and tools to deliver Business Intelligence & Analytics curriculum

Sample Student Project Output

Producing a business report with charts and table with drill down features from SAS Enterprise Guide, view from Web Report Studio.

Sample Student Project Output

Analysing the spending patterns of credit card customers on the different retail stores using tile chart from SAS Enterprise Guide.

Sample Student Project Output

Analysing credit card customer distribution in Singapore using the Map Graph feature in SAS Enterprise Guide.

In a nutshell …

 It is important to incorporate Business Intelligence & Analytics skillsets in financial & IT curriculum to

prepare the workforce for the future.

 SAS BI platform and tools fulfilled our Business

Intelligence & Analytics curriculum requirements with completeness in functionality, ease-of-use and

visualization.

 SAS’s comprehensive training materials and support had enable the teaching staff to deliver the Business Intelligence & Analytics curriculum effectively within a demanding schedule.

Looking Forward …

 More challenges and growth in Business Intelligence & Analytics market …

• IDC Expects a 20.5% Growth for APEJ’s Business

Intelligence Software Market in 2010 with 3Ps - Predictability, Pervasiveness and Price as Key Drivers.

 Banking sector will remain the largest BI adopter with increase investment in advanced analytics …

• To enable better risk management, fraud management, support faster fact based decision-making for customer related issues.

Looking Forward …

 Government sector is increasingly using business analytics to guide decision-making, increase

efficiency, and promote accountability … • Promote a culture of fact-based decision-making

• Manage performance to achieve measurable objectives • Establish a framework for decision-making

• Align strategies across departments

Thank You

Lee Foon Yee, Senior Lecturer School of Information Technology Nanyang Polytechnic