Curriculum
1 Section
37 Lessons
35 Hours
Expand all sections
Collapse all sections
MSBI Course Syllabus
37
1.1
Introduction to SQL Server Integration Services
1.2
SSIS for DBAs: Using SQL Server Management Studio
1.3
SQL server Data Tools
1.4
Introduction to Control Flow
1.5
Advanced Control Flow
1.6
Introduction to Data Flow
1.7
Variables and Configurations
1.8
Slowly Changing Dimensions
1.9
Change Data Capture
1.10
Pivoting & unpivoting in SSIS Debugging, Error Handling and Logging
1.11
Advanced Data Flow
1.12
Extending SSIS through Custom Code
1.13
SSIS Package Deployment
1.14
SSIS Package Management
1.15
SQL Server 2019 Reporting Services
1.16
Creating Reports
1.17
Calculations and Formatting
1.18
Grouping and Sorting
1.19
Report Parameters
1.20
Creating Matrix Reports and Charts
1.21
Managing Reporting Services
1.22
Reporting Services Security
1.23
Programming Reporting Services
1.24
Advanced Reporting Services Programming
1.25
Snapshots and Subscriptions
1.26
Ad-Hoc Reporting with Report Builder
1.27
SQL Server 2019 Analysis Services
1.28
Using SSAS in SSDT
1.29
Intermediate SSAS
1.30
Advanced SSAS
1.31
Cube Storage and Aggregation
1.32
Beginning MDX (All Basics)
1.33
Intermediate MDX
1.34
SSAS Administration
1.35
Introduction to Data Mining
1.36
Introduction to Reporting Clients
1.37
Difference between 2017& 2019
MSBI Online Training
Search
This content is protected, please
login
and enroll in the course to view this content!
Modal title
Main Content