Caricamento...
MOC10778

Implementing Data Models and Reports with Microsoft SQL Server 2012

Prezzo

€ 1,600.00
(Iva esclusa)

Scheda tecnica

Scarica

Giorni

4.5 gg

La Business intelligence (BI) sta diventando sempre più importante per le aziende di diverse dimensioni e tipologie per il vantaggio competitivo che può contribuire a fornire.

Le funzionalità combinate di Microsoft SQL Server 2012 e Microsoft SharePoint 2010 rendono più semplice che mai per le imprese sviluppare una soluzione di BI che soddisfi le loro esigenze specifiche, riduca i costi totali (TCO), e permetta di raggiungere le soluzioni in un tempo più veloce.

Questo corso di 5gg insegna agli studenti come potenziare il proprio lavoro attraverso strumenti di analisi e reporting.

Il corso serve per la preparazione dell'esame 70-466.


OBIETTIVI

Al termine del corso gli allievi saranno ina grado di:

  • Descrivere i componenti, l'architettura e la natura di una soluzione di BI.
  • Creazione di report con Reporting Services.
  • Creare elementi del report riutilizzabili che semplificano reporting self-service.
  • Gestire una infrastruttura di reporting.
  • Creare un database multidimensionale con Analysis Services.
  • Implementare le dimensioni di un cubo.
  • Mettere in atto misure e gruppi di misure in un cubo.
  • Utilizzare la sintassi MDX.
  • Personalizzare un cubo.
  • Implementare un modello di dati tabulari in PowerPivot.
  • Usare DAX per interrogare un modello tabellare.
  • Implementare un database tabulare.
  • Utilizzare View Potenza per creare visualizzazioni interattive di dati.
  • Utilizzare data mining per l'analisi predittiva.
IT Professionals
Almeno 2 anni di esperienza di lavoro con database relazionali, compreso:
  • Progettazione di un normalized database
  • Creazione di tabelle e relazioni
  • Esecuzione di query con Transact-SQL

Conoscenza base del data warehouse schema topology (incluso star and snowflake schemas)

Consapevolezza delle priorità aziendali come fatturato, redditività e contabilità finanziaria

Module 1: Introduction to Business Intelligence and Data Modeling
This module provides an introduction to Business (BI) Intelligence. It describes common BI scenarios, current trends in BI, and the typical roles that are involved in creating a BI solution. It also introduces the Microsoft BI platform and describes the roles Microsoft SQL Server 2012 and Microsoft SharePoint 2010 play in Microsoft BI solutions. 
Module 2: Implementing Reports with SQL Server Reporting Services
This module discusses the tools and techniques a professional business intelligence developer can use to create and publish reports with SQL Server Reporting Services. 
Module 3: Supporting Self Service Reporting
This module describes Microsoft SQL Server Reporting Services features that you can use to enable self-service reporting. 
Module 4: Managing Report Execution and Delivery
This module describes how to apply security settings and configure reports for delivery.
Module 5: Creating Multidimensional Databases
The fundamental purpose of using SQL Server Analysis Services online analytical processing (OLAP) solutions is to build cubes that you can use to perform complex queries and return the results in a reasonable time. This module provides an introduction to multidimensional databases and introduces the core components of an OLAP cube.
Module 6: Working with Dimensions
In SQL Server Analysis Services, dimensions are a fundamental component of cubes. This module provides an insight into the creation and configuration of dimensions and dimension hierarchies. 
Module 7: Working with Measures and Measure Groups
A measure represents a column that contains quantifiable data, usually numeric, that you can aggregate. This module describes measures and measure groups. The module also explains how you can use measures to define fact tables and associate dimensions. 
Module 8: Introduction to MDX
Multidimensional Expressions (MDX) is the query language that you use to work with and retrieve multidimensional data in SQL Server Analysis Services. This module describes the fundamentals of MDX. It also explains how to build calculations, such as calculated members and named sets. 
Module 9: Customizing Cube Functionality
In this module, you will learn how to customize cube functionality by using several technologies available to you in SQL Server Analysis Services. These technology customizations include: Key Performance Indicators, Actions, Perspectives, and Translations.
Module 10: Implementing a Tabular Data Model with Microsoft PowerPivot
This module introduces tabular data models, explains how to install and use the PowerPivot for Excel add-in, and describes how to share a workbook to PowerPivot Gallery.
Module 11: Introduction to DAX
This module covers the fundamentals of the DAX language. It also explains how you can use DAX to create calculated columns and measures, and how you can use these in your tabular data models.
Module 12: Implementing an Analysis Services Tabular Data Model
With SQL Server 2012, you can install Analysis Services in Tabular mode and create tabular data models that information workers can access by using tools such as Excel and Power View. This module describes Analysis Services tabular data models and explains how to develop a tabular data model by using the SQL Server Data Tools.
Module 13: Creating Data Visualizations with Power View
SQL Server 2012 introduces Power View, a SharePoint-based data exploration tool that provides a way for information workers to interactively create data visualizations that help them to better understand the data that they are working with. This module introduces Power View and describes how you can use it to create a range of different types of reports quickly and easily.
Module 14: Performing Predictive Analysis with Data Mining
SQL Server Analysis Services includes data mining tools that you can use to identify patterns in your data, helping you to determine why particular things happen and to predict what will happen in the future. This module introduces data mining, describes how to create a data mining solution, how to validate data mining models, how to use the Data Mining Add-ins for Excel, and how to incorporate data mining results into Reporting Services reports.


Sede Data P