Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Course Code:
MS20467

Duration:
5 days
9.00am to 5.00pm
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
Course Fees:
S$3,000 (excl of G.S.T)
2019 Course Dates
29 Jul – 2 Aug 2019
23 – 27 Sep 2019
25 – 29 Nov 2019
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.
Do note that this course listed is a Microsoft Digital Class (DMOC Class). You are required to bring your own device.

Course Overview

This five-day instructor-led course teaches students how to design and implement a BI infrastructure. The course discusses design, installation. The course discusses design, installation, and maintenance of a BI platform.

This course maps to skills and knowledge measured by Microsoft Exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam.

Program Objectives

After completing this course, students will be able to:

• 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 Outline

Module 1: Planning a BI Solution

Module 2: Planning SQL Server Business Intelligence Infrastructure

Module 3: Designing a Data Warehouse

Module 4: Designing an ETL Solution

Module 5: Designing Analytical Data Models

Module 6: Planning a BI Delivery Solution

Module 7: Designing a Reporting Services Solution

Module 8: Designing a Microsoft Excel-Based Reporting Solution

Module 9: Planning a SharePoint Server BI Solution

Module 10: Monitoring and Optimizing a BI Solution

Module 11: Operating a BI Solution

Click here for full course Outline

Take The Next Step

It Takes Less Than 5 Min