Microsoft SQL Server Data Models & Reports

Microsoft SQL Server Data Models & Reports Course Namibia


2KO Namibia offers online SQL Data Models and Reports courses in Namibia. We also offer full time SQL Data Models and Reports courses in Windhoek for groups of four or more delegates. 2KO Namibia's Data Models course is offered to our international and local students. 2KO Africa conducts hands-on computer courses on most of the major IT Platforms, and has a sizeable range of online IT courses which are available internationally over the Internet, to ensure the best Data Models training in Namibia.



2KO Namibia's SQL course in Windhoek 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 Namibia 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


Drilldown Report


Visual Components

Creating SQL Server

Exam Scenarios

Module Review


Module 3

SSRS Management

Deploying Reports

Report Security

Executing Reports

Report Caching

Report Snapshot


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


Formatting Measures

Measure Groups

Measure Group Storage



Dimension Storage


Grouping and Sorting

Working with Measures

Exam Scenarios

Module Review


Module 6

Customizing Cubes and Security



Key Performance Indicators


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


Applying MDX

Working with MDX

Exam Scenarios

Module Review


Module 8

Tabular Data Models

Introduction to TDM


Linked and Non-Linked Tables


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


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