Digi Academy

Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

Introduction to SQL Server 2008 R2 SQL Server 2008 R2 and SharePoint 2010 SQL Server 2008 R2 data Warehousing After completing this module, students will be able to: Identify the key features and scenarios addressed by SQL Server 2008 R2.

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Cosa impari in questo corso?

Server
Microsoft SQL Server
Reporting
Management
SQL
e-Business

Programma

Describe the ways in which SQL Server 2008 R2 and SharePoint 2010 can be integrated to create a comprehensive self-service BI platform.


Identify the options available for data warehousing with SQL Server and describe the key features of SQL Server 2008 R2 Parallel Data Warehouse.


This module introduces PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010 and describe how they can be used to empower business users to create their own business analyses by using familiar tools.


Introduction to PowerPivot


Power Pivot for Excel 2010


Data Analysis Expressions (DAX)


Power Pivot for SharePoint 2010


Using PowerPivot for Excel 2010


Using PowerPivot for SharePoint


After completing this module, students will be able to:


Install and configure PowerPivot for Excel and PowerPivot for SharePoint.


Use PowerPivot for Excel to create a PowerPivot workbook.


Use Data Analysis Expressions to build formulas in PowerPivot.


Use PowerPivot for SharePoint to manage PowerPivot workbooks.


This module describes the enhancements to Reporting Services tools and APIs in SQL Server 2008 R2 (enhanced reporting functionality is covered in the next module; this module is specifically focused on changes to the management and development tools and APIs).


Deploying and Managing Reporting Services


Reporting Services Authoring Tool Enhancements


Enabling Self-Service BI Through Item Re-Use


Developing Custom Reporting Services Solutions


Viewing and Managing Reports


Using Report Builder 3.0


Working with Shared Datasets and Report Parts


After completing this module, students will be able to:


Use the enhanced Reporting Services management tools


Use the enhanced Reporting Services authoring tools


Collaborate with other report developers by using shared datasets and report parts


Use the enhanced Reporting Services development APIs


This module describes the enhancements to Reporting Services in SQL Server 2008 R2.


Overview of Report Authoring Enhancements


Visualizing Data


Visualizing Spatial Data with Maps


Using Lookups


Paginating Reports


Visualizing Data with Databars and Sparklines


Visualizing Data with Indicators


Visualizing Spatial Data


After completing this module, students will be able to:


Use new features to create reports that include rotated text boxes, linked data from multiple datasets, include rollup aggregations, and custom pagination behavior.


Create reports that include graphic visualizations of data with Sparklines, Data Bars, and Indicators.


Create reports that include visualizations of spatial data.



This module introduces StreamInsight with an emphasis on its use to enable analytical solutions for real-time streams of data.


Introduction to StreamInsight


StreamInsight Core Concepts


Developing a StreamInsight Solution


Creating a StreamInsight Application


Using Filters and Aggregates


Using the StreamInsight Debugger


After completing this module, students will be able to:


Describe scenarios where Complex Event Processing can be used effectively


Describe the core concepts related to Microsoft StreamInsight.


Create a basic StreamInsight application


This module introduces Master Data Services with an emphasis on its use to enable data consistency across the enterprise to help increase the accuracy of BI solutions.


Introduction to MDS


Key Concepts in Master Data Services


Importing and Browsing Data


Business Rules


Exporting Data to Subscribing Systems


Securing Master Data Services


Installing and Configuring Master Data Services


Creating Master Data Services Objects


Importing Data from a Source System


Creating a Business Rule


Exporting Data to a Subscribing System


After completing this module, students will be able to:


Describe the key scenarios and benefits of MDS


Describe core MDS concepts


Import data into MDS


Implement MDS Business Rules


Export MDS data


Secure MDS


This module introduces SQL Azure and cloud-based data solutions.


Overview of SQL Azure and Cloud Services


Using SQL Azure


Introduction to “Dallas”


After completing this module, students will be able to:


Identify suitable scenarios for cloud-based data solutions


Use SQL Azure for cloud-based data storage


Use the Dallas cloud-data service


This module introduces new and enhanced manageability features in SQL Server 2008 R2.


Database Server Provisioning by Using SQL Server SysPrep


Application Management by Using Data-Tier Applications


Managing Multiple Servers by Using Utility Control Points


Working with Data-Tier Applications


Managing Multiple Servers with a UCP


After completing this module, students will be able to:


Use SQL Server SysyPrep to provision database and reporting servers


Use data-tier applications to manage BI databases


Use Utility Control Points to manage BI database server resource utilization



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto