KT-20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014 - Course 20467DC Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Designing Business Intelligence Solutions with Microsoft SQL Server 2014 - Course 20467DC


Description: 

About This Course

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.

Audience Profile

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.

At Course Completion

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.

 
Click here to view the Course Outline
     
Prerequisite: 

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
 
   
     
Duration: 
5 Days  
     
     

View Printer Friendly Page

 

Course Schedule
  Start Date  City  Price  
 7/31/2017
 $2295
 8/21/2017
 $2295
 8/21/2017
 $2295
 9/18/2017
 $2295

To Inquire About Future Classes

Request a class date

if one is not scheduled.