Why MSBI ? | Integrated Services Project | SSIS Package Day 01
#learning #onlinetraining #elearning #programing #freedemo #analystera #powerbi #msbi #ssis #ssas #ssrs
Enroll for Course :
SSIS :http://www.analystera.com/course/ssis
SSIS
Introduction to SQL Server Integration Services
• SSIS Package Architecture Overview
• Introduction to SSIS & Data Warehouse
• Basic ETL Entities in SSIS
• Data and Management Tools
• The Import and Export Wizard
Guided tour of Sql Server Data Tools
Introduction to Data Flow
• Data Flow Overview
• Data Sources
• Data Destinations
• Data Flow Transformations
• Data Viewers
Data Sources
• Excel Source
• Flat File Source
• OLE DB Source
• XML Source
Data Flow Transformations
• Aggregate Transformation
• Audit Transformation
• Character Map Transformation
• Conditional Split Transformation
• Copy Column Transformation
• Derived Column Transformation
• Script component Transformation
• Data Conversion Transformation
• Multicast Transformation
• OLE DB Command Transformation
• Percentage Sampling Transformation
• Row Count Transformation
• Sort Transformation
• Union All Transformation
• Audit Transformation
• Character Map Transformation
• Copy Column Transformation
• Data Mining Query Transformation
Advanced Data Flow
• Lookup Transformation
• Merge Transformation
• Merge Join Transformation
• Slowly Changing Dimension Transformation
• Pivot Transformation
• Export Transformation
• Import Transformation
• Unpivot Transformation
• Term Extraction Transformation
• Term Lookup Transformation
• Fuzzy Lookup Transformation
• Fuzzy Grouping Transformation
Data Flow Destinations
• Data Reader Destination
• Excel Destination
• Flat File Destination
• OLE DB Destination
Introduction to Control 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
• Bulk Insert Task
• Data Flow Task
• Execute Package Task
• Execute Process Task
• Web Service Task
• XML Task
• Backup database Task
• Analysis Services Processing Task
• WMI Event Watcher Task
Advanced Control Flow
• For Loop Container
• For Each Loop Container
• Sequence Container
Variables and Configurations
• Variables Overview
• Variable scope
• SSIS system variables
• Using variables in control flow
• Using variables in data flow
• Property expressions
• Configuration Overview
• Configuration options
• Configuration discipline
Debugging, Error Handling and Logging
• SSIS debugging overview
• Breakpoints in SSIS
• Control Flow: The On Error event handler
• Data Flow: Error data flow
• Configuring Package Logging
• Built-in log providers
Extending SSIS through Custom Code – Scripting
• SSIS Customizations with .NET
• 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
• Deployment options
SSIS Package Management
• The SSIS Service
• Managing packages with SQL Server Management Studio
• Scheduling packages with SQL Server Agent
• Master - Child Packages & Fact Loads
SSAS
What Is Microsoft Business Intelligence?
• Defining Microsoft Business Intelligence
• Viewing a Cube Using Excel
• Using SSAS in SSDT
• Understanding SSDT
• Creating Data Sources
• Creating Data Source Views
• Creating a multidimensional cube
• Creating a Tabular cube
• Creating Data Mining
• Refining Dimensions and Measures
SSAS Installation and Configuration
• Multidimensional Mode Configuration
• Tabular Mode Configuration, In-Memory
• Testing SSAS Workspace Servers in SSDT
• Understanding Real-world Databases
• Need for OLAP Databases and Mining
• Need for Cubes and Faster Reports
• Identifying OLAP / Analysis Entities
• SSAS Usage and Target Access Methods
• Column Storage, Row Storage Options
Dimension Wizard and Attributes
• Creating Multi-Dimensional Entities
• Attributes and Key Member Names
• Cube Dimension Templates and Options
• Dimension Hierarchies and Limitations
• Cube Attribute Relations and Uses
• Composite Attribute Keys in OLAP Cubes
• Building Attribute Levels and Hierarchies
Intermediate SSAS
Cube Wizard and Relations
• Cube Design - Regular Templates
• Cube Measures and Dimension Keys
• Additive and Semi-Additive Measures
• Cube Customization Options and MDX
• Calculations and MDX Members
• MDX Scripts for Member Calculations
• Cube Calculation Sets and MDX Scripts
• BI Enhancements and MDX in MOLAP
• Time-Based Calculations with MDX
SSRS
SQL Server Reporting Services (SSRS) Architecture
Authoring Reports
Creating basic reports
Leveraging expressions
Grouping and sorting data
Implementing Parameters and Filters
Building parameters into reports
Restricting report data with filters