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
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:

18-20, 26-27 November 2015
18-19, 24-26 February 2016
18-19, 25-27 May 2016
17-19, 25-26 August 2016
16-18, 24-25 November 2016

Training Venue: Skulthai Surawong Tower 8th (Near MRT Sam Yan Door 1)


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

Event Contact