MSBI – MICROSOFT BUSINESS INTELLIGENCE (SSIS,SSRS & SSAS)
Back to Dashboard
Hey there, great course, right? Do you like this course?
All of the most interesting lessons further. In order to continue you just need to purchase it
Get course
₹15,000
₹9,999
Course sections
Section 1
MSBI introduction
1
Introduction to MSBI course – SSIS, SSRS & SSAS
Section 2
Installation process
1
How to Install SQL Server 2019
2
How to install SSDT in Visual Studio 2019
Section 3
SQL Server Integration Services (SSIS) - Basics
1
SSIS Terminology
2
SSIS or ETL Structure
3
Sections in SSIS Designer
4
Connection Managers in SSIS
5
Precedence Constraints in SSIS
Section 4
SSIS - Data transformations
1
Union all
2
Look up
3
Data conversion
4
Conditional split
5
Derived column
6
Merge join etc.,
Section 5
SSIS - Error handling
1
Control Flow -Error Handling in SSIS
2
Data Flow -Error Handling in SSIS
Section 6
SSIS - Incremental loading
1
Incremental loading using Change Data Capture (CDC)
Section 7
SSIS - Deployment and Scheduling
1
Deployment : SSIS Integration Services Catalog
2
Deployment : SSIS Package Deployment
Section 8
SQL Server Reporting Services (SSRS) - Basics
1
Basic terminology
2
Data sources
3
Data sets
Section 9
SSRS - Reports
1
Tabular reports
2
Matrix reports
3
Chart reports
4
List reports
Section 10
SSRS reports - Types
1
Parameterized Reports
2
Multivalued Parameterised Reports
3
Cascaded Reports
4
Drill through and Drill down Reports
5
Sub reports
6
Actions in SSRS
7
Go To URL in SSRS
8
Paging in SSRS
Section 11
SSRS Deployment and security
1
SSRS Deployment : SSRS Server and Manager Configuration
2
SSRS Deployment : SSRS Reports Deployment
Section 12
SQL Server Analysis Services (SSAS)
1
Introduction to SSAS
2
SSAS Terminology
3
Cube Development
Questions
My Question
{{ comment.replies_count }}
Send
Load More
Back to Q&A List
Add Comment
{{ message }}
Send
SSIS - Data transformations
Look up
Lesson is locked. Please Buy course to proceed.
SSIS - Data transformations
Union all
Complete
SSIS - Data transformations
Data conversion
w
Login
Sign Up
Remember me
Forgot Password?
Sign In
Sign Up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
Email Reset Link
Cart
Your cart is empty!
Return to shop
Shopping Cart
Cart is empty!
Total
₹0.00
Apply Coupon
APPLY
0
Questions
My Question