Online képzési lehetőségek

Designing Business Intelligence Solutions with Microsoft SQL Server 2014

MS20467
5 nap
315 000 Ft + ÁFA
tanfolyamkezdési időpontok:
Jelentkezem!
oktatók:

A tanfolyam célja

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.

Tudásszint: Advanced
Verzió: D
Tanfolyami forma: Instructor-Led, tantermi képzés, magyar nyelven
Frissítve: 07 April 2016

Hivatalos Microsoft On-demand online képzés jelenleg nem elérhető.

Tematika

Module 1: Planning a BI Solution
Elements of a BI Solution
Planning a BI Project
The Microsoft BI Platform

Module 2: Planning SQL Server Business Intelligence Infrastructure
Considerations of BI Infrastructure
Planning Data Warehouse Hardware

Module 3: Designing a Data Warehouse
Data Warehouse Design Overview
Designing Dimension Tables
Design FACT tables

Module 4: Designing an ETL solution
ETL Overview
Planning for Data Extraction
Planning for Data Transformations
Planning for Data Loading

Module 5: Designing Analytical Data Models
Introduction to Analytical data Models
Designing Analytical Data Models

Module 6: Planning a BI Delivery Solution
Considerations for BI delivery
Common Reporting Scenarios
Choosing a Reporting Tool

Module 7: Designing a Reporting Services Solution
Planning a Reporting Solution
Designing Reports
Planning Report Consistency

Module 8: Designing an Excel Based reporting Solution
Using Excel for Data Reporting and Analysis
PowerPivot in Excel
Power View in Excel

Module 9: Planning a SharePoint Server BI Solution
Introduction to SharePoint Server as a BI Platform
Planning Security for a SharePoint Server BI Solution
Planning Reporting Services Configuration
Planning PowerPivot Configuration
Planning for PerformancePoint Services

Module 10: Monitoring and Optimizing a BI Solution
Overview of BI Monitoring
Monitoring and Optimizing the Data Warehouse
Monitoring and Analyzing Analysis Services
Monitoring and Optimizing Reporting Services

Module 11: Operating a BI Solution
Overview of BI Operations
ETL Operations
Data Warehouse Operations
Analysis Services Operations
Reporting Services Operations

Kinek ajánljuk

Előfeltételek

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

Vizsgák

  • Designing Business Intelligence Solutions with Microsoft SQL Server (70-467)

Kapcsolódó tanfolyamok



Ajánlja másoknak is!