SYLLABUS

Day 1

• SSIS Basics

solution and projects
Two ways to run packages

• Data Flow Task

Connection managers
source and destinations
Excel, OLEDB and flat files

• Data transformations

sorting and aggregating
Fully and Partially blocking
Sampling Data

• Data Views

Attaching data viewers
Using dead-end destinations

Day 2

• Variables

The row count transform
System variables
changing scope
System variables
Changing scope

• Scripting

Script tasks
Script components
The variable dispenser

• Fore-each loops

Looping over files
Looping over records
Other for each loops

• Expressions

Expression Syntax
Data types and casting
Conditional split transform
Derived column transform

• Controlling flow

Precedence and Constraints
Event Handling

Day 3

• Managing Errors

Redirecting and ignoring errors
Dealing with truncations
SSAS
Getting started

• Multidimensional vs tabular

Separate names instances
The development environment

• Connecting to a data model

Hiding from client tools
Renaming tables/columns

• Relationships

Diagram view
Creating Relationships
Multi-column relationships
Basket analysis

• Excel Pivot tables

Analyzing data in Excel
Connecting from Excel
using excel pivot tables

Day 4

• Introduction to SSRS

BID and Report manager
Solution and projects
The 4 main visual studio windows

• Gauges

Creating and formatting gauges
gauge panels
pointers, scales and ranges

Maps

• Indicators

Creating indicators
Changing the symbols displayed
Stopping indicators

• Using Report Manager

moving and deleting reports
creating folders
using report manager

• Subscriptions

How subscriptions work
creating a new subscription
Managing subscriptions

Day 5

• Charts

The areas of a chat
formatting charts
creating charts

• Tables

Structure of a table
Formatting tables
Inserting rows
Interactive sorting

• Grouping Tables

using the grouping panes
Row and column groups
Displaying subtotals
Outlining

• Lists

creating and formatting lists
Grouping using lists
using rectangles in lists

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects