Business Intelligence Solutions SQL Server Course

Business Intelligence Solutions with Microsoft SQL Server, South Africa


2KO South Africa offers online SQL BI courses in South Africa. We also offer full time Designing Business Intelligence courses in Cape Town for groups of four or more delegates. 2KO South Africa's SQL Designing Business Intelligence 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 Business Intelligence certification in South Africa. 2KO South Africa's SQL course in South Africa is designed specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around designing business intelligence solutions with Microsoft SQL Server 2012.  2KO South Africa also offers online courses to our international and local students.



This course is designed for BI Architects, who focus on the overall design of the BI infrastructure, including how it relates to other data systems in use. Primary responsibilities may include but are not limited to:

BI Solution architecture and design

Provisioning of software and hardware

Data warehouse and data mart design

Online Analytical Processing (OLAP) cube design

Integration with SharePoint or line of business applications


This 2KO Africa training course on designing business intelligence solutions with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-467.

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

Performance planning

Scalability planning

Planning for managing upgrades

Maintaining server health

Designing a security strategy

SQL partitioning strategy design

Backup strategy design

Designing a logging and auditing strategy

Reporting Services dataset design

Managing Excel Services/Reporting for SharePoint

Data acquisition strategy design

Planning and managing reporting services configuration

BI reporting solution architecture design

Data warehouse design

Designing a schema

Designing cube architecture

Designing fact tables

BI Semantic Model design

Designing and creating MDX calculations

Designing SSIS package execution

Planning to deploy SSIS solutions

Designing package configurations for SSIS packages


2KO Africa creates the highest quality course curriculum possible, ensuring you receive the training and knowledge required to succeed.

Microsoft 70-467
Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Module 1

Course Introduction

Course Modules

Introduction to Data Warehousing

On-Line Transaction Processing (OLTP) vs. OLAP

Data Warehousing

Data Warehouse Architecture

Creating a Data Warehouse

Presenting On-Line Analytical Processing (OLAP) Data

OLTP vs. OLAP Demonstration

Exam Scenarios

Module Review


Module 2

Designing a Data Warehouse

Data Modeling

Data Warehouse Schemas

Time Dimensions

Data Modeling Considerations

Implementing a Data Model

Logical Model

Physical Model

Working with Dimensions and Fact Tables

Exam Scenarios

Module Review


Module 3

Extraction, Transformation, and Load (ETL) with SSIS

Introduction to SQL Server Integration Services (SSIS)

Upgrading SSIS Packages

SSIS Tools

Introduction to Data Flow Tasks

Data Sources



Control Flow





Control Flow Containers


Package Execution with Checkpoints

Working with SSIS Packages

Exam Scenarios

Module Review


Module 4

Deploying and Securing Packages

Deploying Options

Deploying Packages

Deploying Projects

Securing Packages

Deploying and Securing Packages

Exam Scenarios

Module Review


Module 5

SQL Server Reporting Services (SSRS)

Introduction to Reporting Services

SSRS Reports Creation and Delivery

SSRS Reports






Visual Components

Creating Reports Within Reporting Services

Exam Scenarios

Module Review


Module 6

SSRS Reports

Deploying Reports

Report Security

Report Execution

Report Caching

Report Snapshot


Data Alerts

Deploying Reports and Report Security

Exam Scenarios

Module Review


Module 7 

Multidimensional Cubes

Introduction to Cubes

Components of a Multidimensional Cubes


Measure Format and Aggregation Functions

Measure Groups



Dimension Storage

Dimensions Hierarchies

Grouping and Sorting



Key Performance Indicators


SSAS Security

Cell Permissions

Dimension Permissions

Creating and Configuring a Cube

Exam Scenarios

Module Review


Module 8

Tabular Data Models

Introduction to Tabular Data Models


Working with PowerPivot

Linked and Non-Linked Tables

PowerPivot Features

Server Based Tabular Data Models

Creating a Tabular Data Model

Tabular Models with SSDT

Workspace Database

Tabular Data Model

Tabular Data Model Security

Creating a Tabular Data Model Using PowerPivot

Exam Scenarios

Module Review


Module 9


Introduction to Multidimensional Expressions (MDX)

Why Use MDX?

MDX Syntax


Where is MDX Used?

Introduction to Data Analysis eXpressions (DAX)

Working with DAX

DAX Functions

DAX Queries

Calculated Columns

DAX Measures

Multiple Relationships

Exam Scenarios

Module Review


Module 10

Data Mining

Introduction to Data Mining

Data Mining Algorithms

Data Mining Components

Validating and Presenting Data Mining Models

Creating a Data Mining Model

Exam Scenarios

Module Review

Course Review