MSBI Online Training
SQL / TSQL Development
- Basic database and design
- What is DDL, DML
- Data Types
- What are Constraints & types
- Default
- System functions & User Defined Functions
- Triggers
Introduction to MSBI
Watch MSBI Tutorial for Beginners
- What is MS-BI
- Advantages of MS-BI
- DWH Concepts
- What is DWH?
- Definition of DWH (Ralph Kimball, Bill Inmon Definitions)
- OLTP Vs OLAP
- DWH Architecture
- Data Acquisition Process (ETL)
- Data Analysis Process (OLAP)
- DWH Design Guidelines (Star, Snowflake Schemas)
- Tools used in DWH
- Data Mart
Introduction to SSIS
- SSIS installation
- SSIS Architecture
- Package
- Tasks , Control Flow , Data Flow
Developing SSIS Packages
- SSIS Wizard
- SSIS Designer (SQL Server Data Tools)
- Variables and Expressions
- Breakpoints
- Data viewers
- Configuring Error Output
Errors & Debugging SSIS
- Events Handling
- Execution Logging
- Data Flow Tasks(ETL)
- Control Flow Tasks
- .Net Scripting Task
SSIS Administration
- Configuration
- Deployment
- Security
- Manually Executing SSIS Package
- Scheduling SSIS Package
- Importing and Exporting Packages
- Monitoring and Optimizing Packages
DWH with SSIS
- Dimension Tables Data Loading
- Fact Tables Data Loading
SSRS
- What is SQL Server Reporting Services?
- What can you do with SSRS reports?
- What components does SSRS use?
- Who uses SSRS?
Authorizing Reports
- Basics Of SSRS
- Data Source
- Data Set
- SSRS Expressions
- Reports Formatting
Authorizing Reports
- Parameter Reports
- Sub Reports
- Drill Down Reports
- Linked Reports In SSRS
- Filters in SSRS
- Actions In SSRS
SSRS Administration
- Installation and Configuration
- Deployment and Security
- Subscriptions and Rendering
- Caching and Snapshots
Ad-Hoc Reports Development
- Report Model Project
- Model Designer
- Report Builder
Introduction To SSAS
- Dimensions
- Facts
- Data Sources
- Data Source Views
Developing Cubes
- Cube Designer
- Partitions and Aggregations
- Dimension Usage
- Calculations and Kpis
- Perspectives, Actions
MDX Language
- Axes, Slice
- Tuple and set
- MDX Queries
- MDX expressions
SSAS Administration
- Installation
- Configuration
- Deployment
- Processing
- Security
- Backup and Restore