There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
PDF Add to WishList
The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
This is a Microsoft Official Course (MOC) delivered by a Learning Tree expert instructor.
This course is part of a Microsoft Certification Path and can help you prepare for your MCSA Certification, MCSE Certification, or MCSD Certification.
As a SQL Server database professional, you may be required to participate in, or perhaps even lead, a project with the aim of implementing an effective enterprise BI solution. Therefore, it is important that you have a good understanding of the various elements that comprise a BI solution, the business and IT personnel typically involved in a BI project, and the Microsoft products that you can use to implement the solution.
Lessons
Lab : Exploring a BI Solution
After completing this module, students will be able to:
This module provides an introduction to multidimensional databases and introduces the core components of an Online Analytical Processing (OLAP) cube.
Lessons
Lab : Creating a Multidimensional Database
After completing this module, students will be able to:
This module describes how to create and configure dimensions and dimension hierarchies in an Analysis Services multidimensional data model.
Lessons
Lab : Working with Cubes and Dimensions
After completing this module, students will be able to:
This module describes measures and measure groups. It also explains how you can use them to define fact tables and associate dimensions with measures.
Lessons
Lab : Configuring Measures and Measure Groups
After completing this module, students will be able to:
This module describes the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets.
Lessons
Lab : Using MDX
After completing this module, students will be able to:
This module describes how to enhance a cube with Key Performance Indicators (KPIs), actions, perspectives, and translations.
Lessons
Lab : Customizing a Cube
After completing this module, students will be able to:
This module describes Analysis Services tabular data models and explains how to develop a tabular data model using the SQL Server Data Tools for Business Intelligence (BI) add-in for Visual Studio.
Lessons
Lab : Implementing an Analysis Services Tabular Data Model
After completing this module, students will be able to:
This module explains the fundamentals of the DAX language. It also explains how you can use DAX to create calculated columns and measures, and how you can use them in your tabular data models.
Lessons
Lab : Creating Calculated Columns and Measures by using DAX
After completing this module, students will be able to:
This module introduces Microsoft SQL Server Reporting Services and discusses the tools and techniques that a professional BI developer can use to create and publish reports.
Lessons
Lab : Creating a Report with Report Designer
After completing this module, students will be able to:
This module describes how to apply security and report execution settings, and how to create subscriptions to deliver reports.
Lessons
Lab : Implementing Report Subscriptions
After completing this module, students will be able to:
This module introduces Microsoft SharePoint Server as a platform for BI, and then focuses on building BI dashboards and scorecards with PerformancePoint Services.
Lessons
Lab : Implementing PerformancePoint Services
After completing this module, students will be able to:
This module introduces data mining, describes how to create a data mining solution, how to validate data mining models, how to use the Data Mining Add-ins for Microsoft Excel, and how to incorporate data mining results into Reporting Services reports.
Lessons
Lab : Using Data Mining to Support a Marketing Campaign
After completing this module, students will be able to:
Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
Tuition — Standard: $3710 Government: $3260
May 6 - 10
(
5 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Jun 17 - 21
(
5 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Jul 29 - Aug 2
(
5 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Oct 21 - 25
(
5 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Dec 16 - 20
(
5 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Reserve Your Seat
Jan 27 - 31
(
5 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 1-888-843-8733 or Click here »
$3710
$3260
Course Tuition Includes:
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm