Business Intelligence Design and Process

Course Description:

This course focuses on the development process and design concepts of BI system. It discusses the principles of BI requirement analysis. The course provides the design concepts of data preparation and integration, data warehouse, OLAP, data analytic and visualization. Additionally, data analytics using data mining is explored. The course illustrates how to apply BI framework. Practices with BI software and group learning will be performed throughout this course.

Duration :

5 Days (9:00 - 16:00)

Fee :

12,900 Baht exclude VAT (10,900 Baht exclude VAT with your own computer)
(Fee includes Course Material + Coffee Break and Lunch)

Instructor :

Mr. Chinnavit Chalidabhongse (See Profile >> Here )
IT consultant
Adjunct faculty at Mahidol University International College and Dhurakijpundit University
Technical lead and consulting experience in global software companies in USA

Training Schedule:

24-28 February 2014
15-16, 21-23 May 14
21-22, 27-29 Aug 14
10-12, 17-18 Nov 14

Training Venue:

The Connecion (Near MRT Ladprao Exit 4) >> See Map

Who Should Attend:

-Manager
-Business/data analyst
-IT lead/architect
-IT developer
-IT administrator

Prerequisite:

-

Benefits :

-Understand BI requirement analysis process
-Learn data warehouse design
-Learn ETL process design
-Learn OLAP design
-Explore data visualization styles and techniques
-Understand how to apply data mining for business analytics
-Review BI development technology and trends

Course Outline:

Day 1
o BI Development process
o Requirement analysis
o Data warehouse dimensional design
o Dimensions and measures
o Slowly changing dimensions
o Enterprise data warehouse
o Master data management

Day 2
o Data integration process
o Working with ETL
o Data flow and control flow
o Checkpoint, logging, error handling

Day 3
o OLAP structure and design
o Populating OLAP
o Hierarchical dimension
o Calculated measure, MDX
o KPI, scorecard measure
o Pivoting with OLAP

Day 4
o Data exploration, analytics and visualization
o Ad-hoc analysis
o In-memory analytics
o Data visualization design and selection criteria

Day 5
o Business applications with data mining
o Data mining process and methodology
o Principles and applications of various data mining methods for data analytics and knowledge discovery
o Technology and trends

Online Registration >>

HERE

Payment Condition :

Payment may be paid in full or 50% deposit at least 7 days prior to the start of the course. The payment could be paid by the following methods

1. Account transfer to "IMC Institute" Saving account no. 616-2-07327-1 , Kasikorn Bank, Sathorn Square Branch.

or

2. Cheque should be made payable to "IMC Institute"

Notes:

In case you choose to pay 50% deposit, we would request the remaining 50% to be paid at the registration desk before the beginning of the course.

Contact Person :

For more information, contact our course coordinator on:

Ms.Kwanhathai Thavornpong
Mobile: 087-593-7974, 088-192-7975
Tel: 02-610-3687
E-mail: kwanhathai@imcinstitute.com