Comprehensive Video Tutorials

MCSE Business Intelligence SQL 2012 Online Training Bundle

CareerVision Training
Online

£ 360 - (427 )
+IVA

Informazione importanti

  • Corso
  • Online
  • Durata:
    Flexible
  • Quando:
    Da definire
  • Campus online
Descrizione

MCSE Business Intelligence SQL Server 2012 Certification Training:

The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Informazione importanti
Sedi

Dove e quando

Inizio Luogo
Da definire
Online

Cosa impari in questo corso?

IT
SQL
MCSE training
Business Intelligence
MCSE

Programma

PACKAGE INCLUDES: • Instructor Led Video Training - 12 Months Online On-Demand Access
• Demos and Lab Learning
• Multimedia Presentations and Self-Paced Navigation
• Practice Exam and Test Simulator

COURSE DESCRIPTION This certification provides you the skills, techniques and opportunities required to build, deploy and design solutions. These solutions deliver more data across the entire organization. Earning an MCSE: Business Intelligence certification will qualify for a position as a BI and reporting engineer.

Our MCSE Business Intelligence SQL 2012 Training Package includes the following exams:

  • 70-461
  • 70-462
  • 70-463
  • 70-466
  • 70-467

As a Microsoft Certified Partner, you can be certain that our comprehensive SQL Server 2012 training courses will provide you with all the tools necessary to successfully prepare for your MCSE Business Intelligence SQL 2012 Certification.

COURSE OUTLINE

MCSE Business Intelligence SQL Server 2012 Certification Training:

Microsoft Exam 70-461 - Querying SQL Server 2012 Course Curriculum:
Microsoft Exam 70-462 - Administering Microsoft SQL Server 2012 Databases Course Curriculum:
Microsoft Exam 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012 Course Curriculum:
Microsoft Exam 70-466 - Implementing Data Models and Reports with Microsoft SQL Server 2012 Course Curriculum:
Module 1
Course Introduction
Course Modules
SQL Server 2012 Business Intelligence
Introduction to Business Intelligence
Data Warehouse
Extract, Transform and Load (ETL)
SQL Server Integration Services
SQL Server 2012 BI Tools
Developer Tools
Exam Scenarios

Module 2
SQL Server Reporting Services
Introduction to SSRS
Creation and Delivery
SSRS Reports
Report Grouping
Expressions
Drilldown Report
Parameters
Visual Components
Creating SQL Server
Exam Scenarios
Module Review

Module 3
SSRS Management
Deploying Reports
Report Security
Executing Reports
Report Caching
Report Snapshot
Subscriptions
Data Alerts
Managing Reporting Services
Exam Scenarios
Module Review

Module 4
Multidimensional Cubes
Introduction to Cubes
Cube Components
Creating and Configuring Analysis Services Cube
Exam Scenarios
Module Review

Module 5
Advanced Cube Concepts
Measures
Formatting Measures
Measure Groups
Measure Group Storage
Aggregations
Dimensions
Dimension Storage
Hierarchies
Grouping and Sorting
Working with Measures
Exam Scenarios
Module Review

Module 6
Customizing Cubes and Security
Actions
Perspectives
Key Performance Indicators
Translations
SSAS Security
Cell Permissions
Dimension Permissions
Customizing Cubes and Cube Security
Exam Scenarios
Module Review

Module 7
MultiDimensional eXpressions (MDX)
Introduction to MDX
Why Use MDX?
MDX Syntax
MDX Queries and Filters
Sets
Applying MDX
Working with MDX
Exam Scenarios
Module Review

Module 8
Tabular Data Models
Introduction to TDM
PowerPivot
Linked and Non-Linked Tables
PowerPivot
Server Based Tabular Data Models
Creating a Tabular Data Model
Workspace Database
Tabular Data Model
Working with Tabular Data Modeling
Exam Scenarios
Module Review

Module 9
Data Analysis eXpressions (DAX)
Introduction to DAX
Working with DAX
DAX Functions
DAX Queries
Calculated Columns
Measures
Multiple Relationships
Working with DAX within PowerPivot
Exam Scenarios
Module Review

Module 10
Data Mining
Introduction to Data Mining
Data Mining Algorithms
Data Mining Components
Validating Mining Models
Presenting Mining Data
Creating a Mining Structure
Exam Scenarios
Module Review
Course Review


Microsoft Exam 70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Course Curriculum
Module 1
Course Introduction
Course Modules
Introduction to Data Warehousing
On-Line Transaction Processing (OLTP) vs. OLAP
Data Warehousing
Data Warehouse Architecture
Creating a Data Warehouse
Presenting On-Line Analytical Processing (OLAP) Data
OLTP vs. OLAP Demonstration
Exam Scenarios
Module Review

Module 2
Designing a Data Warehouse
Data Modeling
Data Warehouse Schemas
Time Dimensions
Data Modeling Considerations
Implementing a Data Model
Logical Model
Physical Model
Working with Dimensions and Fact Tables
Exam Scenarios
Module Review

Module 3
Extraction, Transformation, and Load (ETL) with SSIS
Introduction to SQL Server Integration Services (SSIS)
Upgrading SSIS Packages
SSIS Tools
Introduction to Data Flow Tasks
Data Sources
Transformations
Destinations
Control Flow
Variables
Expressions
Precedence
Containers
Control Flow Containers
Transactions
Package Execution with Checkpoints
Working with SSIS Packages
Exam Scenarios
Module Review

Module 4
Deploying and Securing Packages
Deploying Options
Deploying Packages
Deploying Projects
Securing Packages
Deploying and Securing Packages
Exam Scenarios
Module Review

Module 5
SQL Server Reporting Services (SSRS)
Introduction to Reporting Services
SSRS Reports Creation and Delivery
SSRS Reports
Grouping
Expressions
Drilldown
Parameters
Drillthrough
Visual Components
Creating Reports Within Reporting Services
Exam Scenarios
Module Review

Module 6
SSRS Reports
Deploying Reports
Report Security
Report Execution
Report Caching
Report Snapshot
Subscriptions
Data Alerts
Deploying Reports and Report Security
Exam Scenarios
Module Review

Module 7
Multidimensional Cubes
Introduction to Cubes
Components of a Multidimensional Cubes
Measures
Measure Format and Aggregation Functions
Measure Groups
Aggregations
Dimensions
Dimension Storage
Dimensions Hierarchies
Grouping and Sorting
Actions
Perspectives
Key Performance Indicators
Translations
SSAS Security
Cell Permissions
Dimension Permissions
Creating and Configuring a Cube
Exam Scenarios
Module Review

Module 8
Tabular Data Models
Introduction to Tabular Data Models
PowerPivot
Working with PowerPivot
Linked and Non-Linked Tables
PowerPivot Features
Server Based Tabular Data Models
Creating a Tabular Data Model
Tabular Models with SSDT
Workspace Database
Tabular Data Model
Tabular Data Model Security
Creating a Tabular Data Model Using PowerPivot
Exam Scenarios
Module Review

Module 9
MDX/DAX
Introduction to Multidimensional Expressions (MDX)
Why Use MDX?
MDX Syntax
Sets
Where is MDX Used?
Introduction to Data Analysis eXpressions (DAX)
Working with DAX
DAX Functions
DAX Queries
Calculated Columns
DAX Measures
Multiple Relationships
Exam Scenarios
Module Review

Module 10
Data Mining
Introduction to Data Mining
Data Mining Algorithms
Data Mining Components
Validating and Presenting Data Mining Models
Creating a Data Mining Model
Exam Scenarios
Module Review
Course Review