Batch Date: May 4th @ 6:30PM-8:00PM

Faculty: Mr. Shiva

Duration: 45 days

Fee : 12000/-INR + Reg Fee 100/-INR

Location : KPHB, Hyderabad.

Venue :
3rd floor, above HDFC bank
Near JNTU signal, Kukatplly
Hyderabad-500085

Syllabus:

SQL Server Integration Service- SSIS

Chapter-1 Introduction to BI and other BI tools
Introduction to BI
Difference between BI, DWH, Data Mining and Data Mart
Future for BI
MSBI and its Modules

Chapter -2 Introduction to SSIS
SSIS Framework/Architecture
SSIS Overview of Components
Blocked VS Non-Blocked Transformations
Synchronous and Asynchronous Transformations

Chapter -3 Control Flow Elements

Precedence Constraints
Containers
For Loop Container
For Each Loop Container
Sequence Container

Tasks

The Execute SQL Task
The Bulk Insert Task
The File System Task
The FTP Task
The Send Mail Task
Bulk Insert Task
Data Flow Task
Execute Package Task
Execute Process Task
Script Tasks

Chapter -4 Data Flow Transformations
Sort Transformation
Aggregate Transformation
Audit Transformation
Character Map Transformation
Conditional Split Transformation
Copy Column Transformation
Derived Column Transformation
Data Conversion Transformation
Multicast Transformation
OLE DB Command Transformation
Percentage Sampling Transformation
Row Count Transformation
Union All Transformation

Advanced Transformations

Lookup Transformation
Merge Transformation
Merge Join Transformation
Slowly Changing Dimension Transformation
Export and Import Transformation
Pivot and Unpivot Transformation

Chapter-5 Debugging, Error Handling and Logging
SSIS debugging overview
Configuring Package Logging
Breakpoints in SSIS
Event handler in SSIS
Configure Error output in Data Flow
Data Viewers
Configure Check Points
Transactions in SSIS
SSIS Security

Chapter-6 Data Profiling and Data Cleansing
Fuzzy Lookup Transformation
Fuzzy Grouping Transformation

Chapter-7 SSIS Deployment
Create Configuration Files
Implement Logging
Different Deployment Options
Executing packages using utilities – DTExec and DTExecUI
Schedule SSIS Packages with SQL Server Agent Jobs
Monitoring Jobs in SQL Server
Call SSIS Packages in Stored Procedures
Call SSIS Packages in cmd prompt

SQL Server Analysis Service- SSAS

Chapter-1 Introduction to SSAS
Brief Introduction to SSAS and ITS Components
BIDS Environment for SSAS
Creating Project SSAS

Chapter-2 Dimensional Modeling
Introduction to Dimensions and Fact Tables
Snowflake and Star Schema Methodology
Building Data Warehouse
Loading Data using OLTP to OLAP using SSIS Packages
Full and Incremental Loading of Data
Understand Dimensions and Facts
Types of Dimension and Facts
Fact less Fact Table
SSAS Architecture

Chapter-3 Data Source and DSV
Introduction and Creation of DS, DSV
Named Queries
Options in DSV

Chapter-4-Cube Designing and development
Different Ways to Create CUBE
Measures and Measure Groups
Diff between BUILD, DEPLOY and PROCESS
Calculated Columns

Chapter-5-Hierarchies
Creating and Managing Hierarchies
Translations

Chapetr-6-Intro to MDX
Syntax of MDX
Understanding MDX
About Members, Tuple and Sets
Common MDX Functions
New or Updated MDX Functions or Keywords
Understanding the Calculations
Adding Calculated Members

Chapter-7-Processing Options
Understanding Processing
Different Processing Options

Chapter-8- Relationships
Different Types of Relationships
Creating Relationship between Fact and Dimensions

Chapter-9-Storage Modes
Different Storage Modes
How to select different Storage Modes

Chapter-10 Partitions-Aggregations
What are Partitions and How to create Partitions?
On what basis a Partition are created?

Chapter-11 Actions, Calculations, Perspectives and KPIs
What are Actions and How to create IT?
Understand KPIs and Create KPIs
Understand Calculations and Create Calculations
Creating Perspectives

Chapter-12 Deploying the Cube
Generate XMLA Script and Deploy a Cube in SQL Server
Create Jobs to process the cube in SQL Server
Different Approaches to Deployment
Client Interactions with Excel

SQL Server Reporting Services - SSRS

Chapter-1 Introduction to SSRS
Architecture of SSRS
Components in SSRS
Phases of Report Development Life Cycle
What is a Report?

Chapter-2 Creating Basic Report in SSRS
Wizard to develop SSRS Report
Shared Vs. Embedded Data Sources & Data Sets

Chapter -3 Report Authoring
Table Reports and Matrix Reports
Report Designer Paging Options
Drill-down Reports
Chart Reports, Indicator, Gauge Control Reports
List Reports
Use Page Header and Page Footer
Drill-Through or Linked Reports
Sub Reports
Create Report Template and use it in new Reports
Parameter Reports

Single Parameter
Multiple Parameters
Cascading Parameter
Create Calendar in Parameters
Default Values and Drop Down list options

Expressions in SSRS
Understand conditional formatting
Adding images
Grouping and Sorting
Page Header and Page Footer
Aggregate Functions
Sub Totals and Grand Totals
Document Map Reports
Create Reports with Stored Procedures
Create Reports with SSAS Cube

Chapter-4 Deploying Reports
Report Server Configuration
Configure Report Server details in SSRS Project
Report Deployment to Report Server

Chapter-5 Report Manager and Delivery
Report Builder to create ad-hoc Reports
Create Linked Reports
Create Subscriptions
Standard Subscriptions
Data Driven Subscriptions
Cache a Report
Snapshot a Report
Report Logging