sql square

Goals


- Describe the components, architecture and nature of a BI solution

- Create a multidimensional base with Analysis Services

- Implement the dimensions of a cube

- Implement the measures and groups of measures in a cube

- Use the MDX syntax

- Implement a model of tabular data in SQL Server Analysis Services

Program

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

Practical Workshops: Exploring a BI solution

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

Practical workshops: Creation of a multidimensional database

Configure dimensions
Define attribute hierarchies
Sort and group hierarchies

Practical Workshops: Working with Cubes and Dimensions

Working with Measures
Working with Measure Groups

Practical workshops: Configure measures and groups of measures

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

Practical Workshops: Using MDX

Work with performance indicators
Work with actions
Work with perspectives
Work with translations

Practical workshops: Customizing a cube

Introduction to Analysis Service Tabular Data Models
Create a Tabular Data
Model Use a Tabular Data Model in Business

Practical Workshops: Implementing a Tabular Data Services Analysis Model

Duration

5 days

Price

£ 2134

Audience

Database professionals who wish to become a developer to create analysis and reporting solutions with SQL Server

Prerequisites

Experience required in the use of relational databases

Reference

BAS1126-F

DAX Fundamentals
Improving a Tabular Data Model with DAX

Hands-on Workshops: Creating Columns and Calculated Measures Using DAX

Introduction to Reporting Services
Create a Report with Report Designer
Group and Aggregate Data in a Report
Publish and View a Report

Practical Workshops: Creating a Report with Report Designer

View graphical data
Filter reports using parameters

Practical workshops: Subscription implementation report

Manage report security
Manage report execution
Subscriptions and alerts
Troubleshoot Report Services

Introduction to using Sharepoint Server in a BI platform
Introduction to PerformancePoint Services
Data source PerformancePoint and Time intelligence
Reports, dashboards

Practical Workshops: Implementing PerformancePoint Services

Data Mining Overview
Create a Data Mining Solution
Validate a Data Mining Model
Use Data Mining Data

Practical Workshops: Using Data Mining to Support a Marketing Campaign

Sessions

Contact us for more informations about session date