Business Intelligence Solutions SQL Server Course

Business Intelligence Solutions with Microsoft SQL Server, Namibia

 

2KO Namibia offers online SQL BI courses in Namibia. We also offer full time Designing Business Intelligence courses in Windhoek for groups of four or more delegates. 2KO Namibia's SQL Designing Business Intelligence course is offered to our international and local students. 2KO International, part of 2KO Africa network of companies delivers a vast range of classroom based computer courses across the African continent, and is in addition, a leading provider of certified online IT training, to ensure the best Business Intelligence certification in Namibia. 2KO Namibia's SQL course in Windhoek 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. 

 

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

Transformations

Destinations

Control Flow

Variables

Expressions

Precedence

Containers

Control Flow Containers

Transactions

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

Grouping

Expressions

Drilldown

Parameters

Drillthrough

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

Subscriptions

Data Alerts

Deploying Reports and Report Security

Exam Scenarios

Module Review

 

Module 7 

Multidimensional Cubes

Introduction to Cubes

Components of a Multidimensional Cubes

Measures

Measure Format and Aggregation Functions

Measure Groups

Aggregations

Dimensions

Dimension Storage

Dimensions Hierarchies

Grouping and Sorting

Actions

Perspectives

Key Performance Indicators

Translations

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

PowerPivot

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

MDX/DAX

Introduction to Multidimensional Expressions (MDX)

Why Use MDX?

MDX Syntax

Sets

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