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 : 15,900 Baht  exclude VAT (12,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:

• 17-19, 25-26 August 2016

• 16-18, 24-25 November 2016

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

oBI Development process

oRequirement analysis

oData warehouse dimensional design

oDimensions and measures

oSlowly changing dimensions

oEnterprise data warehouse

oMaster data management

• Day 2

oData integration process

oWorking with ETL

oData flow and control flow

oCheckpoint, logging, error handling

• Day 3

oOLAP structure and design

oPopulating OLAP

oHierarchical dimension

oCalculated measure, MDX

oKPI, scorecard measure

oPivoting with OLAP

• Day 4

oData exploration, analytics and visualization

oAd-hoc analysis

oIn-memory analytics

oData visualization design and selection criteria

• Day 5

oBusiness applications with data mining

oData mining process and methodology

oPrinciples and applications of various data mining methods for data analytics and knowledge discovery

oTechnology and trends

Online Registration >> HERE