Microsoft SQL Server 2014: Create and Manage Tabular Data Models

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
SQL Server Analysis Services or SSAS supports tabular modeling, which is a columnar database used to store data for analysis. Access to the data in a tabular model provides fast performance. It is easy for users to access and use because Data Analysis Expressions or DAX queries are used to gain access to the data, which is similar to Excel calculations in a spreadsheet. This course will discuss and show how to implement tabular models in SSAS, including how to create and manage the tables, create calculations to access the data stored, and how to manage the database. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.

Target Audience
Business intelligence developers who create reporting and analysis solutions and individuals interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam

Prerequisites
None

Expected Duration (hours)
2.8

Lesson Objectives

Microsoft SQL Server 2014: Create and Manage Tabular Data Models

start the course

use a project template to create a new tabular model and describe the Tabular Model Designer Interface

import data into a tabular model using the Table Import Wizard

define relationships between tables using the model designer

create hierarchies to define relationships between columns in a table

hide and freeze columns to manage their visibility

sort and filter columns

create perspectives to define viewable subsets of a model

create calculated columns to aggregate data, including using Data Analysis Expressions or DAX

create measures using a table's measure grid, including using Data Analysis Expressions or DAX to create the formula

create Key Performance Indicators or KPIs

create Data Analysis Expressions or DAX to implement tabular objects into a tabular model

implement time intelligence using different functions to support Business Intelligence or BI analysis, including specifying a Mark Table

implement context modification

create partitions using Partitions Manager

manage partitions using Partitions Manager

process partitions using different modes

configure the mode for data access for a tabular model

configure server roles and SQL Server Analysis Services or SSAS database roles to implement security

configure roles to grant permissions to a tabular model database

implement dynamic security for custom security approaches

implement row-level permissions

back up a tabular database

restore and import a PowerPivot model into an SSAS instance

define a Multidimensional Expression or MDX script to import a partial PowerPivot model

implement a tabular model, business logic, and data access as well as manage security

Course Number:
md_idmr_a08_it_enus

Expertise Level
Expert