study overseas chennai +91 - 44 - 42115338
+91 - 9884987719 (Adyar)
+91 - 7550245795 (Velachery)
it training institutes in chennai job openings in chennai
mcsa training chennai

Microsoft Business Intelligence

Global Certification

:

Microsoft SQL Server 2014

Exam Code

:

70-467

Training Name

:

Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Batch

:

Weekend Batch

Duration

:

24 Hrs

Venue

:

HB Educational Services,39/40,1st Main Road,Gandhi Nagar, Adyar, Chennai-20. HB Educational Services, 2/189, 2nd Floor, 100 Feet Road, Vijayanagar, Velachery, Chennai-42.

Description

Business Intelligence certification will qualify you for a position as a BI and reporting engineer.

Target Audience

IT Professionals

Training Overview

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.

Training Content

Module 1: Planning a BI Solution

This module enables students to plan the components of a BI Solution.

Lessons

  • Elements of a BI Solution
  • Planning a BI Project
  • The Microsoft BI Platform

Module 2: Planning SQL Server Business Intelligence Infrastructure

This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.

Lessons

  • Considerations of BI Infrastructure
  • Planning Data Warehouse Hardware

Module 3: Designing a Data Warehouse

This module describes how to design a data warehouse given a set of user requirements.

Lessons

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Design FACT tables

Module 4: Designing an ETL solution

This lesson describes how to design an extract, transform and load (ETL) solution.

Lessons

  • ETL Overview
  • Planning for Data Extraction
  • Planning for Data Transformations
  • Planning for Data Loading

Module 5: Designing Analytical Data Models

This module describes how to design analytical data models for specific BI scenarios.

Lessons

  • Introduction to Analytical data Models
  • Designing Analytical Data Models

Module 6: Planning a BI Delivery Solution

This module describes how to choose an appropriate delivery solution for a given scenario.

Lessons

  • Considerations for BI delivery
  • Common Reporting Scenarios
  • Choosing a Reporting Tool

Module 7: Designing a Reporting Services Solution

This module describes how to design a reporting services solution.

Lessons

  • Planning a Reporting Solution
  • Designing Reports
  • Planning Report Consistency

Module 8: Designing an Excel Based reporting Solution

In this module students will learn how to design a reporting solution using Excel.

Lessons

  • Using Excel for Data Reporting and Analysis
  • PowerPivot in Excel
  • Power View in Excel

Module 9: Planning a SharePoint Server BI Solution

This module introduces the use of SharePoint Server as a BI solution.

Lessons

  • Introduction to SharePoint Server as a BI Platform
  • Planning Security for a SharePoint Server BI Solution
  • Planning Reporting Services Configuration
  • Planning PowerPivot Configuration

Module 10: Monitoring and Optimizing a BI Solution

At the conclusion of this module you will be able to optimize and monitor a BI solution.

Lessons

  • Overview of BI Monitoring
  • Monitoring and Optimizing the Data Warehouse
  • Monitoring and Analyzing Analysis Services

Module 11: Operating a BI Solution

At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.

Lessons

  • Overview of BI Operations
  • ETL Operations
  • Data Warehouse Operations
  • Analysis Services Operations
  • Reporting Services Operations

Pre-Requisites

:

Graduates (any discipline) /BCA /MCA/ B.E/ Diploma Holders with good communication skills

Participant Fee

:

On Request

Please reach our Adyar Center @ +91-44-42115338, or 91-9884987719 (Whatsapp & Call Support)

Please reach our Velachery Center @ +91-7550245795 (Whatsapp & Call Support)

Live Chat Business

_+

Live Chat Business