Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
MSBI - SSIS - SSAS - SSRS
Overview

This course applies to SQL Server 2005, 2008, 2012 and level of this courses is 300/400 (Intermediate to Advanced )

Prerequisites

Knowledge on Basic SQL Syntax

Target Audience

RDBMS Developers, Entry Level Engineers, Data base Administrators

Course duration

9 Days

Course outline

DWH Life Cycle, DWH Architecture, Analysis of General ETL, Cube building, Reporting tools in market

Introduction to SSIS

  • Package
  • Tasks
  • SSIS Installation
  • SSIS Architecture
Developing SSIS packages
  • SSIS Wizard
  • SSIS Designer
  • Control Flow Tasks
  • Data Flow Tasks(transformations)
  • Variables and expressions
  • .Net Scripting in SSIS
  • Hands on Sessions
Advanced Transformations
  • Slowly changing transformations
  • Fuzzy lookup
  • Synchronous Transformations
  • Asynchronous Transformations
  • Blocking , Non-Blocking and Semi -Blocking transformations
  • New connectivity Features
  • Change Data Capture
  • SSIS Power Shell
  • SSIS Reports
  • Hands on Sessions
Error and Debugging in SSIS
  • Events
  • Configure error output in transformations
  • Data Viewers
  • Breakpoints
  • Execution Logging
  • Hands on sessions
SSIS Administration
  • Deployment
  • Configuration
  • Security
  • Manually executing SSIS package
  • Scheduling SSIS package
  • Importing and Exporting packages
  • Monitoring packages
  • Hands on sessions
DWH with SSIS
  • DWH Concepts and Architecture
  • Dimensions table data loading
  • Fact table data loading
  • Case Study - SSIS - A programmatic Example
Introducing Reporting Services
  • Application and Reporting Technology
  • Solution Types
  • Report Design Tools
  • Simple Application Integration
  • Seamless Application Integration
  • Managing and Customizing the Report Server
Reporting Services Architecture
  • The Reporting Life Cycle
  • Reporting Services Tools
  • Reporting Services Web Service
  • Reporting Services Application Databases
Authoring Reports
  • Report Items
  • Report Layout sections
  • SSRS expressions
  • Working with Data Regions
  • Hands on sessions
Advanced Reporting
  • Parameterized Reports
  • Drill Down Reports
  • Sub Reports
  • Filters in SSRS
  • Actions in SSRS
  • .Net Scripting
  • Data Alerts
  • SQL Server Data Tools For SSRS
  • Hands on sessions
SSRS Administration
  • Installation and configuration
  • Deployment and Security
  • Subscriptions
  • Caching and snapshots
Ad-hoc Reporting
  • Report model project
  • Report Designer
  • Report Builder
  • Tabular Models
  • Visual Analytics with Power View
  • Hands on sessions
Introducing Analysis Services
  • Multi-dimensional database concepts
  • Developing Cubes
  • Cube Designer
  • Partitions and aggregations
  • Dimension Usage
  • Calculations
  • Perspectives
  • Translations
  • Advanced Dimension Design
  • Parent child Dimension
  • Degenerate Dimension
  • Server Time Dimension
  • Advanced Measure Groups
  • Debugging
  • Write-back feature
  • BI Semantic Mode
MDX Language
  • Axes, Slices
  • Tuples and Sets
  • MDX expressions
  • MDX Queries
  • MDX Scripts
SSAS Administration
  • Installation
  • Configuration
  • Deployment
  • Processing
  • Security
  • Backup and restore



 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy