Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

MCSE - Business Intelligence

( Duration: 5 Days )

By attending MCSE - Business Intelligence workshop, delegates will learn:

  • The technical skills required to implement data models and reports with Microsoft SQL Server
  • The knowledge and skills to design business intelligence solutions with Microsoft SQL Server
  • Key topics and concepts addressed in the exams 70-466 - Implementing Data Models and Reports with Microsoft SQL Server and 70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server

  • MCSA - SQL Server 2012 certification or equivalent knowledge
  • Three years of hands-on experience working in a SQL Server environment
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

This MCSE - Business Intelligence class is intended for:

  • IT Professionals with at least three years of hands-on experience implementing and administering database systems
  • Database Administrators, Systems Engineers, System Analysts and Technical Consultants who have completed the MCSA - SQL Server 2012 certification or have equivalent knowledge
  • IT Professions who want to prepare for the MCSE - Business Intelligence certification

COURSE AGENDA

Implementing Data Models and Reports with Microsoft SQL Server

1

Introduction to Business Intelligence and Data Modeling

  • Elements of an Enterprise BI Solution
  • The Microsoft BI Platform
  • Planning an Enterprise BI Project
Designing Business Intelligence Solutions with Microsoft SQL Server

1

Planning a BI Solution

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

Creating Multidimensional Databases

  • Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube Cube
  • Security
2

Planning a SQL Server BI Infrastructure

  • Considerations for a BI Infrastructure
  • Planning Data Warehouse Hardware
3

Working with Cubes and Dimensions

  • Configuring Dimensions
  • Attribute Hierarchies
  • Sorting and Grouping Attributes
3

Designing a Data Warehouse

  • Data Warehouse Design
  • Designing Dimension Tables and Fact Tables
  • Designing a Data Warehouse Physical Implementation
4

Working with Measures and Measure Groups

  • Measures
  • Measure Groups
4

Designing an ETL Solution

  • ETL Overview
  • Planning Data Extraction, Data Transformation, and Data Loading
5

Multidimensional Expressions (MDX)

  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube
5

Designing Analytical Data Models

  • Analytical Data Models
  • Designing an Analytical Data Model
  • Designing Dimensions
  • Enhancing Data Models
6

Enhancing a Cube

  • Implementing Key Performance Indicators
  • Implementing Actions, Perspectives, and Translations
6

Planning a BI Delivery Solution

  • Considerations for Delivering BI
  • Common Reporting Scenarios
  • Choosing a Reporting Tool
7

Implementing an Analysis Services Tabular Data Model

  • Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in the Enterprise
7

Designing a Reporting Services Solution

  • Planning a Reporting Services Solution
  • Designing Reports
  • Planning Reporting Consistency
8

Data Analysis Expression (DAX)

  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
8

Designing a Microsoft Excel-Based Reporting Solution

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

Implementing Reports with Reporting Services

  • Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Showing Data Graphically
  • Filtering Reports using Parameters
  • Publishing and Viewing a Report
9

Planning a SharePoint Server BI Solution

  • SharePoint Server as a BI Platform
  • Planning Security for a SharePoint Server BI Solution
  • Planning Reporting Services Configuration
  • Planning PowerPivot Configuration
  • Planning for PerformancePoint Services
10

Enhancing Reports with SQL Server Reporting Services

  • Show Data Graphically
  • Filter Reports Using Parameters
  • Visualizing Data with Power View
10

Monitoring and Optimizing a BI Solution

  • BI Monitoring Overview
  • Monitoring and Optimizing the Data Warehouse, Analysis Services, and Reporting Services
11

Managing a Report Execution and Delivery

  • Managing Security
  • Managing Report Execution
  • Subscriptions and Data Alert
  • Troubleshooting Reporting Services
11

Operating a BI Solution

  • BI Operations Overview
  • ETL Operations
  • Data Warehouse, Analysis Services, and Reporting Services Operations
12

Delivering BI with SharePoint PerformancePoint Services

  • Introduction to SharePoint Server as a BI Platform
  • Introduction to PerformancePoint Services
  • PerformancePoint Data Sources and Time Intelligence
  • Reports, Scorecards, and Dashboards
13

Performing Predictive Analysis with Data Mining

  • Data Mining
  • Create and Validate a Data Mining Model
  • Using the Data Mining Add-In for Excel
  • Using a Data Mining Model in a Report

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X