IL - MOC 20768: Developing SQL Data Models

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).

Course Details
  • Duration: 3 Days
  • Level: 300

Who this course is designed for
  • Data analysts and power information workers
  • Database professionals who fulfill a BI developer role and create enterprise BI solutions

What You Will Learn

  • 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

Prerequisites:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases

Learning Format

  • Onsite at your location
  • Virtual Training
;

Contact the experts at Opsgility to schedule this class at your location or to discuss a more comprehensive readiness solution for your organization. Contact us to enroll or book a class

Contact Us
Looking for on-demand training?
Try SkillMeUp.com