Developing SQL Server Data Models (20768)
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.
You Will Learn How To
- Describe the components, architecture, and nature of a BI solution
- Create a multidimensional database with analysis services
- Implement dimensions in a cube
- Implement measures and measure groups in a cube
- Use MDX syntax
- Customize a cube
- Implement a tabular database
- Use DAX to query a tabular model
- Use data mining for predictive analysis
Important Course Information
Requirements:
- This course requires that you meet the following prerequisites:
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of Transact-SQL
- Working knowledge of relational databases
Exam Information:
- This course helps you prepare for the Microsoft 70-768 certification exam, Developing SQL Data Models.
Redeem Your Microsoft Training Vouchers (SATV):
- This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
- Want to learn more about Microsoft SATVs? Click to view our SATVs infographic.
Course Outline
- Module 1: Introduction to Business Intelligence and Data Modeling
This module introduces key BI concepts and the Microsoft BI product suite.
Lessons
- Introduction to Business Intelligence
- The Microsoft business intelligence platform
Lab: Exploring a Data Warehouse
After completing this module, students will be able to:
- Describe the concept of business intelligence
- Describe the Microsoft business intelligence platform
- Module 2: Creating Multidimensional Databases
This module describes the steps required to create a multidimensional database with analysis services.
Lessons
- Introduction to multidimensional analysis
- Creating data sources and data source views
- Creating a cube
- Overview of cube security
Lab: Creating a multidimensional database
After completing this module, students will be able to:
- Use multidimensional analysis
- Create data sources and data source views
- Create a cube
- Describe cube security
- Module 3: Working with Cubes and Dimensions
This module describes how to implement dimensions in a cube.
Lessons
- Configuring dimensions
- Define attribute hierarchies
- Sorting and grouping attributes
Lab: Working with Cubes and Dimensions
After completing this module, students will be able to:
- Configure dimensions
- Define attribute hierarchies.
- Sort and group attributes
- Module 4: Working with Measures and Measure Groups
This module describes how to implement measures and measure groups in a cube.
Lessons
- Working with measures
- Working with measure groups
Lab: Configuring Measures and Measure Groups
After completing this module, students will be able to:
- Work with measures
- Work with measure groups
- Module 5: Introduction to MDX
This module describes the MDX syntax and how to use MDX.
Lessons
- MDX fundamentals
- Adding calculations to a cube
- Using MDX to query a cube
Lab: Using MDX
After completing this module, students will be able to:
- Describe the fundamentals of MDX
- Add calculations to a cube
- Query a cube using MDX
- Module 6: Customizing Cube Functionality
This module describes how to customize a cube.
Lessons
- Implementing key performance indicators
- Implementing actions
- Implementing perspectives
- Implementing translations
Lab: Customizing a Cube
After completing this module, students will be able to:
- Implement key performance indicators
- Implement actions
- Implement perspectives
- Implement translations
- Module 7: Implementing a Tabular Data Model by Using Analysis Services
This module describes how to implement a tabular data model in PowerPivot.
Lessons
- Introduction to tabular data models
- Creating a tabular data model
- Using an analysis services tabular model in an enterprise BI solution
Lab: Working with an Analysis services tabular data model
After completing this module, students will be able to:
- Describe tabular data models
- Create a tabular data model
- Be able to use an analysis services tabular data model in an enterprise BI solution
- Module 8: Introduction to Data Analysis Expression (DAX)
This module describes how to use DAX to create measures and calculated columns in a tabular data model.
Lessons
- DAX fundamentals
- Using DAX to create calculated columns and measures in a tabular data model
Lab: Creating Calculated Columns and Measures by using DAX
After completing this module, students will be able to:
- Describe the fundamentals of DAX
- Use DAX to create calculated columns and measures in a tabular data model
- Module 9: Performing Predictive Analysis with Data Mining
This module describes how to use data mining for predictive analysis.
Lessons
- Overview of data mining
- Using the data mining add-in for Excel
- Creating a custom data mining solution
- Validating a data mining model
- Connecting to and consuming a data mining model
Lab: Perform Predictive Analysis with Data Mining
After completing this module, students will be able to:
- Describe data mining
- Use the data mining add-in for Excel
- Create a custom data mining solution
- Validate a data mining solution
- Connect to and consume a data mining solution
Convenient Ways to Attend This Instructor-Led Course
Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
In the Classroom
Live, Online
On Demand +
Instructor Coaching
Private Team Training
In the Classroom — OR — Live, Online
Tuition — Standard: $2650 Government: $2355
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.
On Demand + Instructor Coaching
Tuition — $895
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!
- Flexibility to take the course on your own time, at your own pace
- Forever access to the digital course materials – for any refreshers
- You will receive a code with your purchase. The code may be redeemed for online access to this On Demand course for up to six months
- Upon course activation, the MOC On Demand videos and labs are available for three months
- 2 FREE hours of individual coaching from an MCT Learning Tree Instructor
- This delivery is also eligible for Microsoft Assurance Training Vouchers (SATVs)
- NOTE: Only live, in-class training is eligible for NASBA CPEs; on-demand training is not eligible for CPE credit
For enrolling multiple subscribers at the same time, contact us »
Private Team Training
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 »
Tuition
Standard
Government
In Classroom or
Online
Standard
$2650
Government
$2355
On Demand
$895*
Private Team Training
Course Tuition Includes:
Training Hours
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
Enhance Your Credentials with Professional Certification
Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.
Earn 17 Credits from NASBA
This course qualifies for 17 CPE credits from the National Association of State Boards of Accountancy CPE program. NOTE: Only live, in-class attendance qualifies for NASBA CPEs. Read more ...