Digi Academy

Updating your Business Intelligence Skills to Microsoft SQL Server 2012

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

Overview of SQL Server 2012 for Business Intelligence SQL Server 2012 for Enterprise Integration Management SQL Server 2012 for Data Warehousing SQL Server 2012 for Data Analysis and Reporting After completing this module, students will be able to:

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
Business intelligence
Windows
SQL
e-Business

Programma

Describe the role of SQL Server in a BI solution.


Describe features of SQL Server 2012 that support enterprise information management.


Describe features of SQL Server 2012 that support data warehousing.


Describe features of SQL Server 2012 that support data analysis and reporting.


This module describes the new and enhanced features in SQL Server Integration Services that can be used to create an ETL solution to load a data warehouse.


Using the CDC Control Task for Incremental Data Loads


Deploying and Operating SSIS Packages


Extracting Modified Data


Deploying and Operating an SSIS Project


After completing this module, students will be able to:


Use the CDC Control task to perform incremental data extractions in an ETL solution.


Deploy and operate an SSIS project.


This module provides an introduction to SQL Server Data Quality Services, and teaches you how to build knowledge based data quality solutions for cleansing and matching data.


Introduction to Data Quality


Using Data Quality Services to Cleanse Data


Using Data Quality Services to Match Data


Creating a DQS Knowledge Base


Using a DQS Project to Cleanse Data


Using DQS in an SSIS Package


Creating a Matching Policy


Using a DQS Project to Match Data


After completing this module, students will be able to:


Describe how Data Quality Services can help you manage data quality.


Use Data Quality Services to cleanse data.


Use Data Quality Services to match data.


This module provides an introduction to master data management with SQL Server 2012 Master Data Services.


Introduction to Master Data Services


Implementing a Master Data Services Model


Managing Master Data


Creating a Master Data Hub


Creating a Master Data Services Model


Using the Master Data Services Add-in for Excel


Enforcing Business Rules


Loading Data into a Model


Consuming Master Data Services Data


After completing this module, students will be able to:


Describe key Master Data Services concepts.


Implement a Master Data Services model.


Use Master Data Services tools to manage master data.


Use Master Data Services tools to create a master data hub.


This module provides an introduction to new and enhanced features in SQL Server 2012 Reporting Services.


Reporting Services Overview


Reporting Services and Microsoft SharePoint Server


Introduction to Data Alerts


Viewing SharePoint Mode Configuration


Authoring, Publishing, and Viewing a Report


Creating and Managing Data Alerts


After completing this module, students will be able to:


Describe the key capabilities of Reporting Services.


Install and configure Reporting Services in SharePoint Mode.


Use data alerts to notify users of changes to report data.


This module provides an introduction to new and enhanced features in PowerPivot.


Introduction to Tabular Data Models and PowerPivot Technologies


Using PowerPivot


Using DAX in a PowerPivot Data Model


Creating a Tabular Data Model by Using PowerPivot for Excel


Using a Tabular Data Model in Excel


Sharing a PowerPivot Workbook to PowerPivot Gallery


Creating Calculated Columns


Creating Measures


After completing this module, students will be able to:


Describe the key features and benefits of tabular data models and PowerPivot technologies.


Create a PowerPivot for Excel workbook.


Share a PowerPivot for Excel workbook to PowerPivot Gallery and use a PowerPivot for Excel workbook as a data source.


This module describes how to create tabular Analysis Services databases.


Introduction to Analysis Services Tabular Data Model Projects


Developing an Analysis Services Tabular Data Model


Creating an Analysis Services Tabular Data Model Project


Implementing a Perspective


Implementing Partitions


Deploying an Analysis Services Tabular Data Model


Using a Tabular Data Model


Configuring DirectQuery Storage Mode


Implementing Security in a Tabular Data Model


After completing this module, students will be able to:


Describe Analysis Services tabular data model projects.


Implement an Analysis Services tabular data model by Using SQL Server Data Tools.


This module provides an introduction to Power View, and describes how it can be used to create interactive data visualizations.


Introduction to Power View


Visualizing Data with Power View


Configuring a Tabular Data Model for Power View


Creating a Simple Power View Report


Using Interactive Visualizations


Creating a Scatter Chart and a Play Axis


Exporting a Power View Report to PowerPoint


After completing this module, students will be able to:


Describe the Power View and its place in the BI ecosystem.


Create data visualizations by using Power View.


This module introduces Microsoft cloud technologies that can be used in a BI solution.


Overview of Cloud Data Sources


SQL Azure


SQL Azure Reporting Services


The Windows Azure Marketplace DataMarket


Creating a SQL Azure Solution


Extracting Data from SQL Azure


Obtaining Data from the Windows Azure Marketplace DataMarket


After completing this module, students will be able to:


Describe cloud data scenarios.


Use SQL Azure.


Use SQL Azure Reporting Services.


Use the Windows Azure Marketplace DataMarket.



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