SSIS Fundamentals
Comprehensive training to understand the components of SQL Server Integration Services (SSIS), build your ETL packages, automate your data flows and manage events, errors and logs in your integration projects.
Purpose(3)
Developing efficient loading scripts : Master the Qlik scripting language to import, transform and structure your data according to best practices.
Building an optimized data model : Learn how to manage relationships, merge tables and create a reference calendar to guarantee high-performance analyses.
Applying professional development standards : Use variables, organize your scripts, comment on your code and implement maintenance techniques for sustainable, scalable applications.
Content
Development methodology
Data loading techniques
Best practices for data loading
Reference calendar
Optimization 1 table merge
Optimization 2 advanced integration
Linking tables and performance
Integration of complex expressions
Advanced set analysis
Data storage and optimization
Prerequisites(1)
Duration 2,5 jours
Qlik Sense Developer
This course comprises 10 modules, 9 lasting 1 hour 45 minutes and one lasting 3 hours 30 minutes. You'll learn how to write loading scripts, create efficient data models, use variables, optimize performance and automate data management. All materials are provided via our learning platform.
References : FQSD25
