Microsoft SQL Server Data Models & Reports

Microsoft SQL Server Data Models & Reports Course South Africa

 

2KO South Africa offers online SQL Data Models and Reports courses in South Africa. We also offer full time SQL Data Models and Reports courses in Cape Town for groups of four or more delegates. 2KO South Africa's Data Models course is offered to our international and local students. 2KO Africa is a network of companies that offers a substantial series of computer courses across the entire African region, and is a leading provider of internationally recognised online IT training, online, IT training, to ensure the best Data Models training in South Africa.

 

2KO South Africa's SQL course in South Africa is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012. 2KO South Africa also offers online courses to our international and local students. This course is designed for BI Developers who most-likely focus on hands-on work creating the BI solution including implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.

 

Primary responsibilities may include but is not limited to:

Working with large data sets across multiple database systems

Cube/warehouse/views fundamentals

Data model decisions: Unified Dimension Model (UDM) versus Business Intelligence Semantic Model (BISM)

Develop Cubes and Multidimensional Expressions (MDX) queries to support analysts

Online Analytical Processing (OLAP) cube performance

Building pivot tables from cubes

Building PowerPivot solutions

Design and test report models, layouts and templates

Manage reporting system: configuration and subscriptions

Using report builder to create reports

Develop complex SQL queries for reports

Building reports Using Crescent

 

This 2KO Africa training course on implementing data models and reports with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-466

This course will deliver all the skills and knowledge for the following areas:

Designing dimensions and measures

Implementing and configuring dimensions in a cube

Designing a schema to support a cube architecture

Creating measures

Implementing a cube

Creating Multidimensional Expressions (MDX) queries

Implementing custom logic in a data model

Implementing storage design in a multidimensional model

Selecting an appropriate model for data analysis

Analyzing data model performance

Processing data models

Troubleshooting data analysis issues

Deploying SSAS databases

Installing and maintaining an SSAS instance

Configuring permissions and roles in a Business Intelligence Semantic Model (BISM)

Implementing a tabular data model

Implementing business logic in a tabular data model

Implementing data access for a tabular data model

Designing a report

Implementing a report layout

Configuring authentication and authorization for a reporting solution

Implementing interactivity in a report

Troubleshooting reporting service issues

Managing a report environment

Configuring report data sources and datasets

  

Microsoft 70-466 Implementing Data Models and Reports with Microsoft SQL Server 2012

Module 1

Course Introduction

Course Modules

SQL Server 2012 Business Intelligence

Introduction to Business Intelligence

Data Warehouse

Extract, Transform and Load (ETL)

SQL Server Integration Services

SQL Server 2012 BI Tools

Developer Tools

Exam Scenarios

 

Module 2

SQL Server Reporting Services

Introduction to SSRS

Creation and Delivery

SSRS Reports

Report Grouping

Expressions

Drilldown Report

Parameters

Visual Components

Creating SQL Server

Exam Scenarios

Module Review

 

Module 3

SSRS Management

Deploying Reports

Report Security

Executing Reports

Report Caching

Report Snapshot

Subscriptions

Data Alerts

Managing Reporting Services

Exam Scenarios

Module Review

 

Module 4

Multidimensional Cubes

Introduction to Cubes

Cube Components

Creating and Configuring Analysis Services Cube

Exam Scenarios

Module Review

 

Module 5

Advanced Cube Concepts

Measures

Formatting Measures

Measure Groups

Measure Group Storage

Aggregations

Dimensions

Dimension Storage

Hierarchies

Grouping and Sorting

Working with Measures

Exam Scenarios

Module Review

 

Module 6

Customizing Cubes and Security

Actions

Perspectives

Key Performance Indicators

Translations

SSAS Security

Cell Permissions

Dimension Permissions

Customizing Cubes and Cube Security

Exam Scenarios

Module Review

 

Module 7

MultiDimensional eXpressions (MDX)

Introduction to MDX

Why Use MDX?

MDX Syntax

MDX Queries and Filters

Sets

Applying MDX

Working with MDX

Exam Scenarios

Module Review

 

Module 8

Tabular Data Models

Introduction to TDM

PowerPivot

Linked and Non-Linked Tables

PowerPivot

Server Based Tabular Data Models

Creating a Tabular Data Model

Workspace Database

Tabular Data Model

Working with Tabular Data Modeling

Exam Scenarios

Module Review

 

Module 9

Data Analysis eXpressions (DAX)

Introduction to DAX

Working with DAX

DAX Functions

DAX Queries

Calculated Columns

Measures

Multiple Relationships

Working with DAX within PowerPivot

Exam Scenarios

Module Review

 

Module 10

Data Mining

Introduction to Data Mining

Data Mining Algorithms

Data Mining Components

Validating Mining Models

Presenting Mining Data

Creating a Mining Structure

Exam Scenarios

Module Review

Course Review