Business Intelligence Design and Process

Venue: QHouse Lumpini, Bangkok, Thailand

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:

18-20, 25-26 May 2015
19-21, 27-28 August 2015
18-20, 26-27 November 2015

Training Venue: Conference Center, 4th Floor,Q-House Lumpini, 1 South Sathorn Rd(near MRT Lumpini Station Exit 2) >> See Map

Who Should Attend:
Manager
Business/data analyst
IT lead/architect
IT developer
IT administrator

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