You are here:Courses|Microsoft|Microsoft SQL SERVER 2012|MCSE: SQL Server 2012 Data and BI Platform

MCSE: SQL Server 2012 Data and BI Platform

This MCSE course is meant for BI professionals, BI Architects and database professionals trying to develop skills in designing BI solutions. These professionals account for the complete design of Business Intelligence infrastructure which includes the way it relates to different data systems.

The key responsibilities of BI professionals include:

  • Business Intelligence design and solution architecture
  • Hardware and Software Provisioning
  • Data mart and data warehouse design
  • OLAP (Online Analytical Processing) cube design
  • Integrating applications with SharePoint or other business applications

Course Objectives :

The MCSE SQL 2012 BI course from Ramsys Infotech Solutions covers core skills on how a BI infrastructure is designed and implemented. The course focuses on discussing design, configuration, installation and administration of an SQL 2012 BI platform. Completing this course helps you develop skills in the following areas:

  • Designing database for Analysis Services
  • Managing, Maintaining and Troubleshooting SSAS database
  • Creating tabular data models
  • Creating reports with SRSS (SQL Server Reporting Services)
  • Planning and Designing a BI infrastructure
  • Designing Reporting Solutions
  • Designing Data Models for SQL 2012 BI infrastructure
  • Designing ETL Solutions

 

  • Implementation of reports and data models with MS SQL 2012 Server
  • Designing BI solutions with MS SQL 2012 Server

 

 

Course # Course Content Exam # Exam

Regular Track
(days)

10774 Querying Microsoft SQL Server 2012 Databases 70-461 Querying Microsoft SQL Server 2012 Databases 6
10775 Administering Microsoft SQL Server 2012 Databases 70-462 Administering Microsoft SQL Server 2012 Databases 6
10777 Implementing a Data Warehouse with Microsoft SQL Server 2012 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 5
10778 Implementing Data Models and Reports with Microsoft SQL Server 2012 70-466 Implementing Data Models and Reports with Microsoft SQL Server 2012 5
20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012 5
Balance Days  for day of arrival and practice 8
Total duration 35

Prerequisites:

Before attending this course, students must have:

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email: [email protected]