Microsoft Business Intelligence Training and Certification Course In Pune

• Launching BIDS
• Project templates
• The package designer
• The Toolbox
• Solution Explorer
• The Properties window
• The Variables window
• The SSIS menu

Download Curriculum

• Control Flow Overview
• Precedence Constraints
• The Execute SQL Task
• The Bulk Insert Task
• The File System Task
• The FTP Task
• The Send Mail Task
• Containers – grouping and looping
• The Web Service Task
• The WMI tasks
• The Analysis Services tasks
• The Execute Process Task, Execute Package Task
• Data Flow Overview
• Data Sources
• Data Destinations
• Data Transformations
• The Copy Column Transformation
• The Derived Column Transformation
• The Data Conversion Transformation
• The Conditional Split Transformation
• The Aggregate Transformation
• The Sort Transformation
• Data Viewers

Download Curriculum

• Variables Overview
• Variable scope
• SSIS system variables
• Using variables in control flow
• Using variables in data flow
• Using variables to pass information between packages
• Property expressions
• Configuration Overview
• Configuration options
• Configuration discipline

Download Curriculum

• SSIS debugging overview
• Breakpoints in SSIS
• SSIS debugging windows
• Control Flow: The OnError event handler
• Data Flow: Error data flow
• Configuring Package Logging
• Built-in log providers

Download Curriculum

• The Import and Export Wizard
• Importing and Exporting Data
• Scheduling and Executing Plans

Download Curriculum

• Revisiting data sources and destinations
• The Lookup Transformation
• Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
• The Multicast Transformation
• The Merge and Merge Join Transformations
• The Slowly Changing Dimension Transformation
• Transaction Handling in SSI
• Check Point configurations

Download Curriculum

• The SSIS script editor
• The SSIS object model
• Script in Control flow: The Script Task
• Script in Data flow: The Script Component
• Introduction to SSIS component development

Download Curriculum

• Configurations and deployment
• The deployment utility
• Deployment options
• Deployment security
• Executing packages – DTExec and DTExecUI

Download Curriculum

• The SSIS Service
• Managing packages with DTUtil
• Managing packages with SQL Server Management Studio
• Scheduling packages with SQL Server Agent

Download Curriculum

• Overview of SQL Server Analysis Services
• Installing SQL Server Analysis Services

Download Curriculum

• Modeling source schemas—stars and snowflakes
• Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
• Understanding fact (measures) and cube modeling
• Other types of modeling—data mining etc

Download Curriculum

• Creating Data Sources and Data Source Views
• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Attribute
• Creating cubes
• Refining Dimensions and Measures in BIDS

Download Curriculum

• KPIs
• Perspectives
• Translations – cube metadata and currency localization
• Partitions
• Storage topics – basic aggregations, MOLAP, ROLAP, HOLAP
• Aggregations
•  

Download Curriculum

• Using the MDX query editor in SQL Server Management Studio
• Most-used Functions & Common tasks
• New MDX functions\

Download Curriculum

• Securing a cube
• Deployment and processing the CUBE

Download Curriculum

• Tour of Features
• Reporting Services Architecture
• Reporting Services Terminology
• Reporting Services Editions
• Taking Reporting Services for a Spin
• Creating Reports
• Deconstructing Reporting Services
• Shared Data Sources
• Creating Reports from Scratch
• Calculations and Formatting
• Creating Expressions
• Using the Global Collections
• Formatting Items
• Conditional Formatting
• Grouping and Sorting
• Creating Groups
• Calculating Totals and Percentages
• Interactive Sorting
• Creating Drill-Down Reports
• Report Parameters
• Creating Report Parameters
• Creating Drop-Down Parameters
• Multi-Valued Parameters
• Debugging Parameter Issues
• Creating Matrix Reports and Charts
• Creating a Basic Matrix Report
• Matrix Subtotals
• Creating a Basic Chart
• Exploring the Charting Possibilities
• Managing Reporting Services
• Deploying Reports and Data Sources
• Exporting Reports and Printing
• Using the Web-Based Report Manager
• Using SQL Server Management Studio-based Reporting Services Manager
• Reporting Services Security
• Two Parts to Reporting Services Security
• Securing Access to Reports
• Data Source Security
• Programming Reporting Services
• The Many Reporting Services APIs
• Integrating Reporting Services into Applications using URL Access
• Using the Report Viewer Controls
• Advanced Reporting Services Programming
• Using the Reporting Services Web Service
• Working with Custom Assemblies
• Snapshots and Subscriptions
• Caching and Snapshots
• Creating Standard Subscriptions
• Creating Data-Driven Subscriptions
• Managing Subscriptions
• Ad-Hoc Reporting with Report Builder
• The Report Builder Architecture
• Creating Report Model Projects
• Running Report Builder

Download Curriculum