Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.
basis, objectives and application of data warehouse, data warehouse server types
base building ETL processes in SSIS
basic design data cubes in an Analysis Services: measure group measure
dimensions, hierarchies, attributes,
development of the project data cubes: measures calculated, partitions, perspectives, translations, actions, KPIs,
Build and deploy, processing a partition
the base XML / A: Partitioning, processes and overall Incremental, delete partitions, processes of aggregation,
base MDX language
The course is intended for IT specialist that works with the distributed processing of large data sets across clusters of computers.
Data Mining and Business Intelligence
Area of application
Basics of data exploration
What does Big data stand for?
Big data and Data mining
What is Hadoop
Architecture and configuration of Hadoop Distributed File System
MapReduce and Hadoop
Administration and configuration of Hadoop On Demand
Weekend Business Intelligence courses, Evening Business Intelligence training, Business Intelligence boot camp, Business Intelligence instructor-led
, Business Intelligence on-site,Weekend Business Intelligence training, Evening Business Intelligence courses, Business Intelligence training courses, Business Intelligence private courses, Business Intelligence trainer , Business Intelligence coaching, Business Intelligence classes, Business Intelligence one on one training