• My account
  • Cart
English courses / USD

MCSE Business Intelligence SQL 2012 Online Training Bundle

Regular Price: $422

Special Price: $169

  • Flexible
  • 2 students have purchased
  • Express
Centre
Learning247
Town
Birmingham
Address
61 Caroline Street, B3 1UF See in Google maps
Contact
sales@learning247.co.uk
http://www.learning247.co.uk
Map
Description
Learning247's mission has always been to provide the most effective and straight-forward route to learning and certification. By utilising the very latest multimedia and video-based training technology, our internationally recognised instructors deliver superb results. We also understand that price is a concern for everyone, and so we seek to offer the very best prices available online, with regular savings of up to 30% over standard Recommended Retail Prices. As one of the UK’s market-leaders in distance-learning and self-study multimedia-based training, Learning247 provides the most cost-effective route to enable you to update and improve upon your skills; and all without the massive prices that are regularly seen throughout the IT Training industry! By utilising the latest multimedia instructor-led study techniques, you’ll get the most comprehensive training available at consistently unbeatable prices, and the peace of mind that comes from dealing with a company that’s provided affordable study-solutions for thousands of happy students.

Benefits

  • Tutor support available for 12 months
  • Make your own study schedule and take advantage of online tutoring hours
  • Obtain a certified diploma once you finish the course.

Details

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!

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

Conditions

Thanks to this offer, valid exclusively for one person, you will obtain a MCSE Business Intelligence SQL 2012 Online Training Bundle.

How to register

By buying the course in Emagister Express, you will obtain an access coupon. We will send you the codes and keys to the coupon. Send the coupon code and the key to sales@learning247.co.uk. The training provider will then give you access to the course.

This course has not been reviewed yet
Hi! According to your location, we have changed your payment currency to USD.
You can change to other currency by using the option on the header.