Dump Data From FlatFile to Excel Destination | MSBI | Day 2
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
100 % Practical Classes
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
KPI
Creating Perspectives
Creating Translations
Working with Multiple Fact Tables
Using the Business Intelligence Wizard
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