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 2014
21-22, 27-29 August 2014
10-12, 17-18 November 2014
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
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
- Account transfer to "IMC Institute" Saving account no. 616-2-07327-1 , Kasikorn Bank, Sathorn Square Branch.
or
- 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 / Ms.Mailada Moungmaitong
Mobile: 087-593-7974, 088-192-7975 , 090-992-9916
Tel: 02-610-3687
E-mail: kwanhathai@imcinstitute.com / mailada@imcinstitute.com /
contact@imcinstitute.com
