MSBI Training Provided by Technogeeks Training Institute in Pune,Aundh
MSBI free videos and free material uploaded by Technogeeks Training Institute. This session contains about MSBI Updated syllabus , Lecture notes , videos , MCQ , Privious Question papers and Toppers Training Provided Training of this course. If Material not uploaded check another subject
Introduction to SQL Server
Integration Services
Datawarehousing Basics
Product History
SSIS Package Architecture Overview
Development and Management Tools
Business Intelligence
Development Studio
Launching BIDS
Project templates
The package designer
The Toolbox
Solution Explorer
The Properties window
The Variables window
The SSIS menu
Introduction to Control Flow
and Data Flow
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
Variables and Configurations
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
Debugging, Error Handling and
Logging
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
SSIS Using SQL Server
Management Studio
The Import and Export Wizard
Importing and Exporting Data
Scheduling and Executing Plans
Advanced Data Flow
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
Introduction to SSIS scripting
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
SSIS Package Deployment
Configurations and deployment
The deployment utility
Deployment options
Deployment security
Executing packages – DTExec and
DTExecUI
SSIS Package Management
The SSIS Service
Managing packages with DTUtil
Managing packages with SQL Server
Management Studio
Scheduling packages with SQL
Server Agent
Introduction to Microsoft SQL
Server Analysis Services
Overview of SQL Server Analysis
Services
Installing SQL Server Analysis
Services
OLAP Modeling
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…
Understanding the development
environment
Creating Data Sources and Data
Source Views
Configuring Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Attribute
Creating cubes
Refining Dimensions and Measures
in BIDS
Intermediate SSAS
KPIs
Perspectives
Translations – cube metadata and
currency localization
Partitions
Storage topics – basic
aggregations, MOLAP, ROLAP, HOLAP
Aggregations
MDX
Using the MDX query editor in SQL
Server Management Studio
Most-used Functions & Common
tasks
New MDX functions\
Security
Securing a cube
Deployment and processing the CUBE
Introduction to SQL Server
Reporting Services
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
Write a public review