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
