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
    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


  • 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

  • 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