Home   Schulung > EDV > Backoffice > SQL Server

The course focuses on the creation of OLAP cubes and OLAP processing in SQL server, for the purpose of complex analyses which are not stressing production database servers. Delegates will learn how they can dynamically create complex analytical and business reports with an immediate response, regardless of the amount of data (such as obtaining complex reports from terabytes of data within a single second), how to use it for tuning server performance, and how to use the newly obtained information for the company management to make better decisions. They will also learn how to use data mining and artificial intelligence to discover new, valuable information from existing corporate data about customers, their behaviour, and relationships and dependencies within the company that will be highly appreciated by the business and management users. Upon successful completion of this course, students will be able to: - Describe the advantages of multi-dimensional processing of data - Create and use OLAP cubes - Configure cube dimensions and their hierarchies - Implement proper aggregates for the data - Use basic MDX querying to cubes - Use advanced features like KPIs, custom calculations or translations - Configure and administer OLAP cubes - Extract knowledge from tons of data using data mining - Describe and use different data mining algorithms to get insight into data

Microsoft SQL Server 2008/R2 Analysis Services

Ziel
The course focuses on the creation of OLAP cubes and OLAP processing in SQL server, for the purpose of complex analyses which are not stressing production database servers. Delegates will learn how they can dynamically create complex analytical and business reports with an immediate response, regardless of the amount of data (such as obtaining complex reports from terabytes of data within a single second), how to use it for tuning server performance, and how to use the newly obtained information for the company management to make better decisions. They will also learn how to use data mining and artificial intelligence to discover new, valuable information from existing corporate data about customers, their behaviour, and relationships and dependencies within the company that will be highly appreciated by the business and management users. Upon successful completion of this course, students will be able to: - Describe the advantages of multi-dimensional processing of data- Create and use OLAP cubes- Configure cube dimensions and their hierarchies- Implement proper aggregates for the data- Use basic MDX querying to cubes- Use advanced features like KPIs, custom calculations or translations- Configure and administer OLAP cubes- Extract knowledge from tons of data using data mining- Describe and use different data mining algorithms to get insight into data
Schulungsinhalte


· Introduction to SQL Server 2008/R2 Analysis Services
Advantages and disadvantages of OLTP vs. OLAP data processing .Architecture of Analysis Services . Installation of Analysis Services

· Creating Analytical Solutions in Analysis Services
Preparing data for analysis . Creating an Analysis Services project . Creating data sources and views . Creating OLAP cubes

· Working with Dimensions
Creating and Configuring dimensions . Attributes of dimensions and hierarchical attributes . Sorting, organizing, grouping and filtering attributes .Hiding attributes, changing displaying of attributes to the users

· Working with Summaries and Measures
Working with the measures . Additive and semi-additive measures . Organizing measures

· Querying the OLAP Cubes
Fundamentals of MDX language . Adding custom calculations into cubes

· Another Features of OLAP Cubes
Key performance indicators - KPI . Actions . Perspectives . Translations and language versions of OLAP cubes . Partitioning OLAP cubes and scaling-out performance .

· Putting OLAP Cubes Into Production
Deployment into production (both directly and indirectly) . Security and other Analysis Services databases settings . Working with OLAP cubes directly in Excel . Integration with Reporting Services

· Administering OLAP Cubes
OLAP processing modes – ROLAP, HOLAP and MOLAP . Logging, monitoring and optimization of OLAP cubes and queries . Backup and restore of Analysis Services databases

· Data Mining in SQL Server
Overview and benefits of data mining in SQL Server 2008/R2 . Supported data processing algorithms in data mining and their suitability for use on specific types of problems in practice . Principles of operation of neural networks . Creating data mining models . Validation of the accuracy and relevance of models . Forecasting using models and the DMX language . Examples of mining knowledge from data - prediction of trends,identification of customer behaviour, classification of customers, identification of most profitable product sets .
Zielgruppe
This course is intended for all who want to get the most out of their production data using analytical processing with the leading business intelligence tools for analysing data that SQL Server 2008/R2 offers.
Voraussetzungen
Basic overview of relational databases, optionally overview of management and decision making processes, and artificial intelligence.
Ausschließlich als Inhouse-Schulung
Dieses Seminar bieten wir ausschließlich als Inhouse-Seminar in Ihren Räumlichkeiten oder bei uns in Münster an.
Seminardaten
Schulung-Nrsqlanals
Dauer2 Tage
Inhouse-Schulung
Dieses Seminar bieten wir Ihnen als Inhouse-Seminar oder -coaching vor Ort in Ihren Räumlichkeiten an.

Rufen Sie uns bitte an:

+4925198 110 99 0
QRCode zu dieser Schulung

Aktuelle Termine
Mo, 12.09.2016 - Fr, 16.09.2016, Münster
Garantierte DurchführungWebentwicklung mit HTML, CSS, JavaScript, jQuery und PHP
Mo, 07.11.2016 - Fr, 11.11.2016, Münster
Webentwicklung mit HTML, CSS, JavaScript, jQuery und PHP
Garantierte Durchführung Garantierte Durchführung!