PDF Add to WishList
This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.
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.
This module introduces key BI concepts and the Microsoft BI product suite.
Lessons
Lab: Exploring a Data Warehouse
After completing this module, students will be able to:
This module describes the steps required to create a multidimensional database with analysis services.
Lessons
Lab: Creating a multidimensional database
After completing this module, students will be able to:
This module describes how to implement dimensions in a cube.
Lessons
Lab: Working with Cubes and Dimensions
After completing this module, students will be able to:
This module describes how to implement measures and measure groups in a cube.
Lessons
Lab: Configuring Measures and Measure Groups
After completing this module, students will be able to:
This module describes the MDX syntax and how to use MDX.
Lessons
Lab: Using MDX
After completing this module, students will be able to:
This module describes how to customize a cube.
Lessons
Lab: Customizing a Cube
After completing this module, students will be able to:
This module describes how to implement a tabular data model in PowerPivot.
Lessons
Lab: Working with an Analysis services tabular data model
After completing this module, students will be able to:
This module describes how to use DAX to create measures and calculated columns in a tabular data model.
Lessons
Lab: Creating Calculated Columns and Measures by using DAX
After completing this module, students will be able to:
This module describes how to use data mining for predictive analysis.
Lessons
Lab: Perform Predictive Analysis with Data Mining
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: $2745 Government: $2415
Jul 18 - 20
(3 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Sep 5 - 7
(3 Days)
9:00 AM - 4:30 PM EDT
Alexandria, VA / Online (AnyWare)
Reserve Your Seat
Oct 10 - 12
(3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Jan 16 - 18
(3 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare)
Reserve Your Seat
Feb 20 - 22
(3 Days)
9:00 AM - 4:30 PM EST
Alexandria, VA / Online (AnyWare)
Reserve Your Seat
Mar 20 - 22
(3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / 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.With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.
PLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!
For enrolling multiple subscribers at the same time, contact us »
Enroling 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 »
$2745
$2415
$1195*
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