V.le P.A. Pirelli 6, Milano - academy@digi.it - 0269438264

Corsi Microsoft

Cerca un corso

Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Codice corso: 20467D
Durata corso: 5gg

Introduzione

This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.

This course is not designed for students who are new to SQL Server 2014 BI technologies; it is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.

Obiettivi del corso

After completing this course, students will be able to:

Plan a BI solution

Plan SQL Server BI infrastructure

Design a data warehouse

Design an extract, transform and load (ETL) solution

Design analytical data models

Plan a BI delivery solution

Design a Reporting Services solution

Design a Microsoft Excel-based reporting solution

Plan a SharePoint Server BI solution

Monitor and optimize a BI solution

Operate a BI solution

Prerequisiti

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

A basic understanding of dimensional modeling (star schema) for data warehouses

Basic server hardware knowledge

The ability to create Integration Services packages that include control flows and data flows

The ability to create a basic multidimensional cube with Analysis Services

The ability to create a basic tabular model with PowerPivot and Analysis Services

The ability to create Reporting Services reports with Report Designer

The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services

Familiarity with SharePoint Server and Microsoft Office applications – particularly Excel

Struttura del Corso

MODULE 1: Planning a BI Solution

This module enables students to plan the components of a BI Solution.

Lessons

After completing this module, you will be able to:

Describe the components of a BI Solution

Identify the components of a BI Solution

Plan a BI Project

Lab : Planning BI Solutions

MODULE 2: Planning SQL Server Business Intelligence Infrastructure

This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.

Lessons

After completing this module, you will be able to:

Describe the components of a BI Infrastructure and where you would use them

Plan for the hardware requirements of a Data Warehouse implementation

Lab : Planning BI Infrastructure

MODULE 3: Designing a Data Warehouse

This module describes how to design a data warehouse given a set of user requirements.

Lessons

After completing this module, you will be able to:

Design a Data Warehouse

Design Dimension Tables

Design FACT tables

Design a logical schema for a data warehouse

Lab : Designing a Data Warehouse Logical Schema

MODULE 4: Designing an ETL solution

This lesson describes how to design an extract, transform and load (ETL) solution.

Lessons

After completing this module, you will be able to:

Describe the components of an ETL solution

Design an ETL solution

Plan for Data Extraction

Plan for Data Transformations

Plan for Data Loading

Lab : Designing an ETL Solution

MODULE 5: Designing Analytical Data Models

This module describes how to design analytical data models for specific BI scenarios.

Lessons

After completing this module, you will be able to:

Describe the features of an Analytical data Models

Design an Analytical Data Models

Lab : Designing Analytical Data Model

Lab : Designing Dimensions and Hierarchies

MODULE 6: Planning a BI Delivery Solution

This module describes how to choose an appropriate delivery solution for a given scenario.

Lessons

After completing this module, you will be able to:

Describe the components of a BI delivery solution

Describe some common Reporting Scenarios

Choose an appropriate delivery solution for a given scenario

Lab : Planning a BI Delivery Solution

MODULE 7: Designing a Reporting Services Solution

This module describes how to design a reporting services solution.

Lessons

After completing this module, you will be able to:

Plan for a Reporting Services Solution

Design reports for a reporting services solutions

Plan for consistency of reporting

Lab : Designing a Reporting Services Solution

MODULE 8: Designing an Excel Based reporting Solution

In this module students will learn how to design a reporting solution using Excel.

Lessons

After completing this module, you will be able to:

Describe key features of excel reporting solutions

Use PowerPivot in Excel to create reports

Use Power View in Excel to create reports

Lab : Designing and Excel Reporting Solution

MODULE 9: Planning a SharePoint Server BI Solution

This module introduces the use of SharePoint Server as a BI solution.

Lessons

After completing this module, you will be able to:

Describe the components of a SharePoint Server BI Solution

Plan Security for a SharePoint Server BI Solution

Plan reporting solutions for a SharePoint Server BI Solution

Describe the components of a PerformancePoint Solution

Implement PerformancePoint services

Lab : Implementing PerformancePoint Services

Lab : Implementing a SharePoint Server BI Solution

MODULE 10: Monitoring and Optimizing a BI Solution

At the conclusion of this module you will be able to optimize and monitor a BI solution.

Lessons

After completing this module, you will be able to:

To be Monitor and Optimiz the Data Warehouse

To be Monitor and Analyz Analysis Services

To be Monitor and Optimiz Reporting Services

Lab : Monitoring and Optimizing a BI Solution

MODULE 11: Operating a BI Solution

At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.

Lessons

After completing this module, you will be able to:

Describe the components to be managed in a BI Solution

Be able to manage the components of a BI solution

ETL Operations

Data Warehouse Operations

Analysis Services Operations

Reporting Services Operations

Lab : Operating a BI Solution

P.IVA 06249920965
C.C.I.A.A. REA: MI - 1880014
Cap. Soc. € 12.000,00

Contatti

V.le P.A. Pirelli 6,20126 Milano
Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.
Tel.: +39 02 694 382 64
Fax.: +39 02 694 382 35

© Copyright 2020 DI.GI. Academy
Privacy Policy | Cookie Policy