SQL Server 2016 ile OLAP Modelleme ve Raporlama (SSAS, SSRS) Eğitimi

Module 1: Introduction to Business Intelligence and Data Modeling

Elements of an Enterprise BI Solution
The Microsoft Enterprise BI Platform
Planning an Enterprise BI Project

Module 2: Creating Multidimensional Databases

Introduction to Multidimensional Analysis
Creating Data Sources and Data Source Views
Creating a Cube
Overview of Cube Security

Module 3: Working with Cubes and Dimensions

Configuring Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Hierarchies

Module 4: Working with Measures and Measure Groups

Working with Measures
Working with Measure Groups

Module 5: Introduction to MDX

MDX Fundamentals
Adding Calculations to a Cube
Using MDX to Query a Cube

Module 6: Enhancing a Cube

Working with Key Performance Indicators
Working with Actions
Working with Perspectives
Working with Translations

Module 7: Implementing an Analysis Services Tabular Data Model

Introduction to Analysis Services Tabular Data Models
Creating a Tabular Data Model
Using an Analysis Services Tabular Data Model in the Enterprise

Module 8: Introduction to DAX

DAX Fundamentals
Enhancing a Tabular Data Model with DAX

Module 9: Implementing Reports with SQL Server Reporting Services

Introduction to Reporting Services
Creating a Report with Report Designer
Grouping and Aggregating Data in a Report
Publishing and Viewing a Report

Module 10: Enhancing Reports with SQL Server Reporting Services

Showing Data Graphically
Filtering Reports by Using Parameters

Module 11: Managing Report Execution and Delivery

Managing Report Security
Managing Report Execution
Subscriptions and Data Alerts
Troubleshooting Reporting Services

Module 12: SQL Server Database Certification Path

Introduction to SQL Server Database Certification
Choosing the Right SQL Server Database Certification Path
Preparing for SQL Server Certification Exams
Sample Tips,Questions and Answers from Certification Exams

KAYIT OL

Detaylar

Tarih:

Gün:

Saat:

Süre: 24 Saat

Fiyat: 2500 TL

Eğitmen:

BİLGİLENDİRME

Eğitim fiyatlarına KDV dahil değildir.

Eğitimler en az 6 kişi ile açılır. Yeterli katılımcı sayısına ulaşılamayan durumlarda eğitim bir defaya mahsus ertelenir.

Kurumsal kapalı grup eğitim teklifleriniz için bizimle iletişime geçebilirsiniz.

EĞİTİM DOKÜMANI

EĞİTİMİN AMACI

Bu eğitim içerisinde,SQL Server 2016 Analysis Services üzerinde çok boyutlu küplerin oluşturulması,Çok boyutlu küplerin MDX dili ile sorgulanması,Tabular Model ile proje oluşturulması,Tabular Model sorgulama dili DAX ile SQL Server 2014 Reporting Services ile raporlar oluşturulması konuları yer almaktadır.