Course Duration in Hours
16
16
We are expertise in Providing corporate training s
------------------------------------------------
SSRS SQL Server Reporting Services
Getting Started
1. Understanding Reporting (Authoring,Management,Delivery)
2. Installing Reporting (Native Mode, SharePoint Integration mode)
3. Building your first report
Authoring Reports
1. Developing Basic Reports (RDL,wizard,designer,datasource,dataset,formatting)
2. Working with expressions (expression to calculate value, Agg functions, exp for objects)
3. Organizing Data (Data Regions, Table, Matrix, Chart, List)
4. Advance Report (Parameter, drill down, drill through, links,
5. Report Model (Data Source, Data Source View, Model , Report Builder 3.0)
Managing Report ( Report Manager)
1. Managing Content (deploying report, folders, linked reports, datasources, value etc)
2. Managing Security (Item Level , Site navigation, localhost sql)
3. Managing Server Config (Config Manager, Report Manager, Report Server DB)
Delivering Report
1. Accessing Report (Viewing Report, Report History, saving in diff format, printing)
2. Rendering Report ( online mhtml, doc pdf,tiff, data excel,csv)
3. Managing Subscription (Standard subscription, Data driven subscription)
Programming Report
1. Using Code.
2. Using Reporting Service
3. Custom Assembly
SSIS SQL Server Integration Services
Getting Started With SSIS
1. Introduction
2. Import and Export wizard
3. Building first package
4. Components
Designing Packages
1. Extracting and Loading Data
2. Using Dataflow Transformations
3. Control Flow
4. Scripting Task
5. Debugging
6. Managing Package Execution
Managing Packages
1. Detecting and Handling Processing errors.
2. Configurations and deployment.
Applying SSIS to DW
1. DW Concepts
2. Populating DW structures
3. General Principles
SSAS SQL Server Analysis Services
Getting Started
1. Business Intelligence and Data Warehousing
2. OLAP and Analysis Services
3. First Cube
Design Fundamentals
1. Data Source and Data Source Views (Creating and Modifying)
2. SSAS Cube (Creating and Modifying)
3. Dimensions (Creating and Modifying , hierarchies , assigning dimension to cube)
4. Measure Group (Creating, adding measure group and measure)
5. Adding KPIs (Goal,Status,Trend), Actions (URL,DrillThrough,Reporting) etc.
6. Storage Modes MOLAP,ROLAP,HOLAP
7. Perspective
8. Translations.
Production Management
1. Deployment (impersonation mode, processing cube)
2. Partitions (partitions), Aggregations (Aggregations Design , Usage based optimization)
3. MDX - introduction
Who can attend this training?
A Fresh Graduate Who would like take up the role of MSBI Developer A professional working on MS Technologies such as .Net &SharePoint as SSRS and SSIS has become the mandatory required skill in their job Any Professional who would like upgrade to latest technology trends
BITECH, Thane,IN