Developing SQL Data Models (20768)

Category	ID	Duration	Level	Price
SQL Server	M20768	3 Day(s)	Intermediate	$1,737.00

Anchorage, AK Class Schedule

GTR

Guaranteed to Run

Delivery Format		Date	Time	Register
Classroom Virtual		10/26/2020 - 10/28/2020	10:00 AM - 5:00 PM EDT	Register

Anchorage Training Center

Address

310 K Street

Suite 200

Anchorage, AK 99501

Map and Driving Directions

Call Us

US Toll Free 844-238-8607

Email Us

info@productivitypointls.com

Course Overview

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.

Course Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able 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

MCSA: SQL 2016 BI Development
MCSE: Data Management and Analytics

To ensure successful completion of this course, we recommend the following:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.

• Working knowledge of Transact-SQL.

• Working knowledge of relational databases.

Analyzing Data with Power BI (20778)

Implementing a SQL Data Warehouse (20767)

10990-Analyzing Data with SQL Server Reporting Services

Anchorage, AK

Training Schedule

Course Objectives