Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.
IL - MOC 20768: Developing SQL Data Models
Instructor-Led Training
Intermediate
3 Days
Onsite or Virtual
Course Overview
In this course, you will learn about business intelligence (BI) solutions that implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).
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
Pre-Requisites
  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Onsite at your location
  • Virtual Training
Dedicated Training
Contact Us Today

Dedicated instructor-led training is designed for group training and is delivered by the experts at Opsgility. Delivery availability is anywhere in the world at your location or using advanced virtual training software.

Benefits
  • Standard or Customized Curriculum
  • Globally Available for Delivery
  • Holistic Learning Plans are Available
  • Industry Recognized Subject Matter Experts