Venue & Date
Place and date according to your availability
About this workshop
Objective:
- Data loading, transformation, and modeling (level: advanced)
- Visuals (tables/graphs): advanced functionalities
What will you learn:
- Database connection (ODBC, OLDB)
- Advanced data loading scripting
- Link tables, loops, temporary tables
- Table concatenation, joins
- Correspondence tables
- Script variables
- Modeling
- Multi-layer architecture: Data Load (extraction) - Data Model (transformations) - Data Visualization (Application)
- Time management: Master calendar, Date link
- External script integration
- Resolution of synthetic keys and circular references
- Security: data segmentation (Section Access)
- User interface
- Advanced dimensions and measures (Set Analysis, aggregations)
- Choose between Master items / variables / scripting
- Extensions and mashups
- Best practices
Target audience:
- BI Consultants
- Developers
- Architects
- Project Managers
Prerequisites:
Developing Qlik Sense visuals (Qlik Sense Designer)
Qlik Sense base modeling
SQL and database language
Evaluation Certificate, diploma:
This hands-on, interactive training course leads to the Qlik Sense Data Architect certification. Participants will receive a certificate of attendance.