Developing SQL Data Models
* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us: sales@ccslearningacademy.com.
Student financing options are available.
Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
Looking for group training? Contact Us
About This Course
Course Description
The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups.
Learning Objectives
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
Inclusions
- 3 Day Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
Pre-requisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Experience of querying data using Transact-SQL.
Target Audience
- Data analysts and power information workers
- Database professionals who fulfill a BI developer role and create enterprise BI solutions and whose primary responsibilities include:
- Implementing multidimensional databases by using SSAS
- Creating tabular semantic data models for analysis by using SSAS
Curriculum
40 Lessons24h
1. Introduction to Business Intelligence and Data Modeling
Introduction to Business Intelligence
Microsoft Business Intelligence Platform
2. Create Multidimensional Databases
3. Working Cubes and Dimensions
4. Working with Measures and Measure Groups
5. Introduction to Multidimensional Expressions (MDX)
6. Customize Cube Functionality
7. Implement a Tabular Data Model by Using Analysis Services
8. Introduction to Data Analysis Expression (DAX)
9. Perform Predictive Analysis with Data Mining
Labs Outline
Your Instructors
Write a review
$2,095.00
24 hours
Inclusions
- 3 Day Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
