• Instructor: Rajan R.
  • Students: 2237
  • Duration: 10 weeks

MSBI

  1. Understanding SSIS
  1. BIDS
  1. Building and Executing a Package
  1. Control Flow
  1. Control Flow Constraints
  1. Data Flow
  1. Data Flow Transformations
  1. Variables
  1. Data Flow Variables
  1. Control Flow Variables
  1. Containers
  1. For Loop Containers
  1. Transaction Report
  1. Checkpoints and Handling  Errors
  1. Outputs and Break Points
  1. Package Logging
  1. Event Handling
  1. Advanced Data Flow
  1. Slowly Changing Dimensions
  1. Deploying Packages
  1. Installing Packages
  1. Managing Packages
  1. Packages and Security
  1. Scripting
  1. Data Flow Scripting

Package Design Best Practices

SQL Server Analysis Services (SSAS)

  1. Build and Connect
  1. Building a Cube
  1. Connecting using Excel
  1. Cube Modelling
  1. Using Visio
  1. Cube Modelling
  1. Data Source and Data Source Views
  1. Creating a Cube
  1. KPIs and Perspectives
  1. Translations
  1. DataBus
  1. Slowly Changing Dimensions
  1. Aggregations – MOLAP
  1. Profiler
  1. Partitions – MOLAP, ROLAP and HOLAP
  1. MDX Queries
  1. MDX Functions
  1. Calculated Members
  1. MDX Scripts
  1. Security

SQL Serer Reporting Services(SSRS)

  1. Features
  1. SSRS Architecture
  1. Reporting Services projects
  1. Creating Tabular Report
  1. Adding Controls
  1. Creating List Report
  1. Creating Expressions
  1. Global Collections
  1. Formatting
  1. Creating Groups
  1. Calculating Totals
  1. Interactive Sorting
  1. Creating Parameters
  1. Drop Down List
  1. Parameter Sorting
  1. Creating Matrix Reports
  1. SSRS 2008  Matrix Features
  1. Creating a Chart
  1. Adding Guages
  1. Deploy Reports
  1. Report Manager
  1. Reporting Services Security
  1. SSL
  1. Data Source Security

Curriculum is empty

Price

Free
Call Now ButtonCall NowRequest Form