Implementing Data Models and Reports with Microsoft SQL Server (MS 20466)

IL CENTRO PRESENTA IL PROGRAMMA PENSATO PER MIGLIORARE LE TUE COMPETENZE E PERMETTERTI DI REALIZZARE GLI OBIETTIVI STABILITI. NEL CORSO DELLA FORMAZIONE SI ALTERNERANNO DIFFERENTI MODULI CHE TI PERMETTERANNO DI ACQUISIRE LE CONOSCENZE SULLE DIFFERENTI TEMATICHE PROPOSTE.

descrivere componenti e architettura di una soluzione di Business Intelligence;

creare report con i Reporting Services;

gestire l'esecuzione e la distribuzione dei report;

creare database multidimensionali con Analysis Services;

implementare le dimensioni in un cubo;

implementare le misure in un cubo;

utilizzare la sintassi MDX;

customizzare un cubo;

utilizzare DAX per interrogare un tabular model;

implementare un tabular database;

implementare PowerView per creare visualizzazioni interattive;

utilizzare Data Mining per analisi di tipo predittivo.

Introduction to Business Intelligence and Data Modeling

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

Creating Multidimensional Databases

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

Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Hierarchies

Working with Measures and Measure Groups

• Working with Measures
• Working with Measure Groups

Introduction to MDX

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

Enhancing a Cube

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

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

Introduction to DAX

• DAX Fundamentals
• Enhancing a Tabular Data Model with DAX

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

Enhancing Reports with SQL Server Reporting Services

• Showing Data Graphically
• Filtering Reports by Using Parameters

Managing Report Execution and Delivery

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

Delivering BI with SharePoint PerformancePoint Services

• Introduction to SharePoint Server as a BI Platform
• Introduction to PerformancePoint Services
• PerformancePoint Data Sources and Time Intelligence
• Reports, Scorecards, and Dashboards

Performing Predictive Analysis with Data Mining

• Overview of Data Mining
• Creating a Data Mining Solution
• Validating a Data Mining Model
• Consuming Data Mining Data