SYLLABUS
Day 1
- SSIS Basics
- Data Flow Task
- Data transformations
- Data Views
solution and projects
Two ways to run packages
Connection managers
source and destinations
Excel, OLEDB and flat files
sorting and aggregating
Fully and Partially blocking
Sampling Data
Attaching data viewers
Using dead-end destinations
Day 2
- Variables
- Scripting
- Fore-each loops
- Expressions
- Controlling flow
The row count transform
System variables
changing scope
System variables
Changing scope
Script tasks
Script components
The variable dispenser
Looping over files
Looping over records
Other for each loops
Expression Syntax
Data types and casting
Conditional split transform
Derived column transform
Precedence and Constraints
Event Handling
Day 3
- Managing Errors
- Multidimensional vs tabular
- Connecting to a data model
- Relationships
- Excel Pivot tables
Redirecting and ignoring errors
Dealing with truncations
SSAS
Getting started
Separate names instances
The development environment
Hiding from client tools
Renaming tables/columns
Diagram view
Creating Relationships
Multi-column relationships
Basket analysis
Analyzing data in Excel
Connecting from Excel
using excel pivot tables
Day 4
- Introduction to SSRS
- Gauges
- Indicators
- Using Report Manager
- Subscriptions
- Charts
- Tables
- Grouping Tables
- Lists
BID and Report manager
Solution and projects
The 4 main visual studio windows
Creating and formatting gauges
gauge panels
pointers, scales and ranges
Maps
Creating indicators
Changing the symbols displayed
Stopping indicators
moving and deleting reports
creating folders
using report manager
How subscriptions work
creating a new subscription
Managing subscriptions
Day 5
The areas of a chat
formatting charts
creating charts
Structure of a table
Formatting tables
Inserting rows
Interactive sorting
using the grouping panes
Row and column groups
Displaying subtotals
Outlining
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