> > > 20467

Designing Self-Service Business Intelligence and Big Data Solutions (20467)

Course Description Schedule Course Outline
 

Who should attend

BI professionals, BI Architects or Database Professionals who need to design BI solutions.

Prerequisites

  • A basic understanding of dimensional modeling (star schema) for data warehouses.
  • 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.

Students who attend this training can meet the prerequisites by attending the following courses.

  • M10777: Implementing a Data Warehouse with Microsoft SQL Server 2012
  • M10778: Implementing Data Models and Reports with Microsoft SQL Server 2012

Course Objectives

  • Plan the components of a BI solution.
  • Plan a BI infrastructure.
  • Design a data warehouse.
  • Design an ETL solution.
  • Plan analytical data models.
  • Plan a BI delivery solution.
  • Design a Reporting Services solution.
  • Design an Excel reporting solution.
  • Plan a SharePoint Server BI solution.
  • Monitor and optimize a BI solution.
  • Plan for BI operations.

Course Content

This course teaches students how to design and implement a BI infrastructure and helps prepare students for Microsoft Exam 70-467. The course discusses design, installation, and maintenance of a BI platform.

Classroom Training
Modality: G

Duration 5 days

Price (excl. VAT)
  • Eastern Europe: 1,250.- €
  • SA Voucher: 5
Enroll now
 
Click on the location to go directly to the booking pageSchedule
Slovenia
18/12/2017 - 22/12/2017 Ljubljana Course language: English Enroll
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!