Qlik Training e Book Published 17062020 This presentation

Qlik Training e. Book Published: 17/06/2020 This presentation is best viewed in MS Power. Point. To view on mobile devices, please install MS Power. Point from the App Store /Google Play.

Contents Navigate this document using your keyboard arrow keys Training Journey Map Qlik Sense Visualizati on Contributor Workshop Create Visualization s with Qlik Sense This icon appears on every page. Click on it to navigate back to this page. Create Mashups with Qlik Sense Server Administratio n Qlik. View Developer Qlik. View Server Administratio n Qlik Sense Server Architectur e Qlik. View Methods and Visualizatio n Qlik. View Publisher Administratio n Qlik. View Designer Qlik. View Solution Design Qlik Sense BI Competency Center Qlik Sense Introduction Presentatio n Qlik Sense App Owner Workshop Qlik Sense Data Modeling Qlik Sense Governed Self-service Qlik Sense Navigation Consumer Workshop Qlik Sense for Qlik. View Developer Qlik Geo. Analyti cs Administer and Maintain Qlik Sense Click on the buttons to browse through a detailed overview

Training Journey Map 3/151

Qlik Sense Journey Phase Descriptions Busines s users Consumer Consumes the data on the app by reading, analyzing & reporting (Presents their data findings via stories) Contributor All of the above PLUS can duplicate existing sheets & create new sheets and objects, using the dimensions & measures created All of the above PLUS can create & publish new apps, using data from file locations made available to the app owner (Normally transformed QVD files) App owner Content admin Business analyst IT users Responsible for authorizing data & user-group allocations, creating streams, managing apps & sheets. Also responsible for governing and managing access to data connections and data sources Creates powerful, clean, cutting-edge visualizations, assisting users to explore information and gain critical insights on multiple devices Data analyst Manages and consolidates data from different tables and sources, and integrates them into an efficient data model Web developer Embeds and integrates Qlik Sense, using Qlik Sense APIs and extends apps with custom visualizations System administrator Enterprise architect Manages security and platform architecture, including reloading and publishing of documents Architects and secures your Qlik platform, including user accessibility and application access rule administration 4/151

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin Click on the buttons for more information Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 5/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin WSNC - Qlik Sense Navigation Consumer Workshop Click on the buttons moreatinformation This workshop isfor aimed consumers who would like to analyze, explore and discover data stories within Qlik Sense business apps. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 6/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin WSVC - Qlik Sense Visualization Contributor Workshop Click on the buttons This workshop for is aimed at self-service Qlik Sense more information contributors who would like to create and publish their own sheets and charts within existing Qlik Sense business apps. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 7/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin WSAO - Qlik Sense App Owner Workshop on the buttons This workshop Click is aimed at self-service Qlik Sense app owners who like to create and publish for would more information their own Qlik Sense business apps, create new sheets and charts, and work with the Qlik Sense Data Manager. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 8/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin QSDM - Data Modeling for Qlik Sense Course Click on the buttons This course addresses how to develop a coherent information data modelforinmore Qlik Sense by loading and transforming multiple data sources. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 9/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin WGSS - Qlik Sense Governed Self-service Presentation Click on the buttons for more information This presentation addresses the concepts of selfservice and governance considerations for BI teams. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 10/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin S 4 QV - Qlik Sense for Qlik. View Developers Workshop Click on the buttons for more information This workshop addresses migration from Qlik. View to Qlik Sense for established Qlik. View developers. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 11/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin QSCV - Create Visualizations with Qlik Sense Course Click on the buttons This course addresses theinformation fundamentals required for more self-service visualization, creating master dimensions, measures, and building your own chart objects and guided stories. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 12/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin QSDM - Data Modeling for Qlik Sense Course Click on the buttons This course addresses how to develop a coherent information data modelforinmore Qlik Sense by loading and transforming multiple data sources. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 13/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin WQGA - Qlik Geo. Analytics Workshop Click on the buttons This workshop addresses the approach to visualize for more information geospatial information within your Qlik app, using multi-layer maps. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 14/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin SWEB - Create Mashups with Qlik Sense Workshop Click on the buttons forprovides more information This workshop the foundational skills required to create web page mashups using Qlik Sense Dev Hub. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 15/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin QSAM - Administer and Maintain Qlik Sense Course Click on the buttons This course provides youinformation with the information, tools, for more techniques and skills necessary to set up, configure, administer and govern a Qlik Sense Enterprise platform. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 16/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik Sense Customer Training Journey Qlik Sense Data Modeling Content admin SARC - Qlik Sense Server Architecture Presentation Click on the buttons This presentation provides enterprise architects with more information techniques tofor advance their skills in Qlik Sense server components, architecture configurations, managing services, load balancing and single signon methods. Business analyst IT users Qlik Sense Governed Self-service Qlik Sense for Qlik. View Developer Create Visualizations with Qlik Sense Data Modeling Data analyst Qlik Geo. Analytics Consumer Business users Contributor App owner Qlik Sense Navigation Consumer Workshop Web developer Qlik Sense Visualization Contributor Workshop Qlik Sense App Owner Workshop 17/151 System administrator & Data architect Create Mashups with Qlik Sense Administer and Maintain Qlik Sense Server Architecture Click on the buttons for more information

Qlik. View Customer Training Business analyst Qlik. View Designer Qlik. View Developer IT users Data architect Qlik. View Methods and Visualization Click on the buttons for more information Qlik. View Solution Design Qlik. View Server Administration Administrator Qlik. View Publisher Administration 18/151 Click on the buttons for more information

Qlik. View Customer Training Business analyst IT users Data architect Qlik. View Designer Qlik. View Developer VDES - Qlik. View Designer Course Qlik. View Methods and Visualization Click on the buttons This course addresses the critical design more information concepts andfor components needed to create a well-guided Qlik. View app. Qlik. View Solution Design Qlik. View Server Administration Administrator Qlik. View Publisher Administration 19/151 Click on the buttons for more information

Qlik. View Customer Training Business analyst Qlik. View Designer VDEV - Qlik. View Developer Course Qlik. View Developer IT users Data architect Qlik. View Methods and Visualization Click onon theknowledge buttons of the data This course focuses model, creation the information proper data connections for of more and scripting fundamentals that are critical to creating Qlik. View apps, offering your organization powerful business discovery tools. Qlik. View Solution Design Qlik. View Server Administration Administrator Qlik. View Publisher Administration 20/151 Click on the buttons for more information

Qlik. View Customer Training Business analyst Qlik. View Designer VVIS - Qlik. View Methods and Visualization Workshop Qlik. View Developer IT users Data architect Qlik. View Methods and Visualization Click on the buttons This workshop addresses an intermediate for more information approach to rapid application development and data visualization techniques, delivering a solid Qlik. View application based on best practices for desktop and mobile designing interfaces. Qlik. View Solution Design Qlik. View Server Administration Administrator Qlik. View Publisher Administration 21/151 Click on the buttons for more information

Qlik. View Customer Training Business analyst IT users Data architect Qlik. View Designer Qlik. View Developer VSOL - Solution Design Workshop Qlik. View Methods and Visualization Click on the buttons This workshop addresses advanced insights forof more from a variety datainformation subjects and complex projects to help Qlik. View developers design, develop and deliver complex Qlik. View solutions. Qlik. View Solution Design Qlik. View Server Administration Administrator Qlik. View Publisher Administration 22/151 Click on the buttons for more information

Qlik. View Customer Training Business analyst Qlik. View Designer VQVS - Qlik. View Server Administration Workshop Qlik. View Developer IT users Data architect Qlik. View Methods and Visualization Click on the buttons This onsite workshop addresses the for more information management of the Qlik Sense server environment, setting up the Qlik Management Console, Windows server and network configuration correctly. Qlik. View Solution Design Qlik. View Server Administration Administrator Qlik. View Publisher Administration 23/151 Click on the buttons for more information

Qlik. View Customer Training Business analyst Qlik. View Designer VQVP - Qlik. View Publisher Administration Workshop Qlik. View Developer IT users Data architect Qlik. View Methods and Visualization Click on the buttons This workshop has been designed for infrastructurefor support personnel who manage more information the Qlik. View server. Technical by nature, it requires attendees to work with Qlik. View server settings, including managing the Qlik. View app reload tasks. Qlik. View Solution Design Qlik. View Server Administration Administrator Qlik. View Publisher Administration 24/151 Click on the buttons for more information

Qlik Sense Introduction Presentation Overview 3 -hour WQSI 25/151

Overview This presentation introduces users to the Qlik Sense product family in terms of data exploration, discovery and analyses. Intended audience • Business users • Qlik Sense consumers (Analyzers) Prerequisites for attendees 26/151 • Understanding business and previous working experience with data • Building your own Excel reports

Content • Introducing the Qlik portfolio • Working through Qlik Sense use cases • Self-Service visualization and exploration • Sharing knowledge and insights • Qlik Sense Enterprise platform functionalities • Qlik’s product range awareness • Qlik’s associative difference • Filtering data & searching in Qlik Sense • Interacting and exploring by using the Insight Advisor within Qlik Sense • Navigating through the Qlik Sense products • Working with a published Qlik Sense application • Presenting the concept of reusable dimensions & measures • Introducing new Qlik Sense visualizations available in the latest releases • Taking snapshots to be presented in your Qlik Sense story • Building a very basic Qlik Sense Story to present your findings 27/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 28/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The presentation is facilitated by an i. OCO pre-sales representative. Onsite presentation • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 29/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 30/151

Qlik Sense Navigation Consumer Workshop Overview 1 -day WSNC 31/151

Overview This workshop is aimed at all the Qlik Sense consumers who would like to analyze Qlik Sense business apps. You will learn how to navigate within Qlik Sense and use the correct tools to explore, discover and analyze business information, finding and presenting the true story within your data. Intended audience • Qlik Sense beginners • Qlik Sense consumers (Analyzers) Prerequisites for attendees 32/151 • Understanding business requirements • Basic data literacy • No prior Qlik Sense experience needed

Content • Planning your Qlik journey • Understanding data analytics • Navigating through Qlik Sense • Data filtering and searches • Visualization exploration • Creating bookmarks • Creating a story to present • Collaboration 33/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 34/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training because it is less effective due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 35/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 36/151

Qlik Sense Visualization Contributor Workshop Overview 1 -day WSVC 37/151

Overview This workshop is aimed at all the self-service Qlik Sense contributors who would like to create and publish their own sheets and charts within existing Qlik Sense business apps. This workshop will teach you how to create new sheets and charts, working with the Qlik Sense Master Items Library. Intended audience • Qlik Sense contributors • Qlik Sense power users Prerequisites for attendees 38/151 • Qlik Sense Navigation Consumer Workshop • Examples of analyzed Qlik Sense business apps

Content • Planning your Qlik journey • Designer navigation • Explaining the D-A-R concept • Creating new sheets • Working with sheet properties • Qlik Sense content administration • Working with assets pane • Working with master items • Dimensions, measures & visualization objects • Creating basic chart objects • Working with chart properties • Working with insight advisor • Publishing sheets and objects 39/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 40/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training because it is less effective due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 41/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 42/151

Qlik Sense App Owner Workshop Overview 1 -day WSAO 43/151

Overview This workshop is aimed at the self-service Qlik Sense app owners who would like to create and publish their own Qlik Sense business apps. You will learn how to create new sheets and charts, working with the Qlik Sense Data Manager. Intended audience • Qlik Sense app owners • Qlik Sense power users Prerequisites for attendees 44/151 • Qlik Sense Visualization Contributor Workshop • Experience in creating sheets and objects in existing Qlik Sense business apps

Content • Planning your Qlik journey • Managing your data • Extracting your data • Associating your data • Transforming your data via profiling cards • Loading your data • Building a simple data model • Building & finalizing an app • Collaborating your findings 45/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 46/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • While we do offer onsite training our past experience recommends that onsite training because it is less effective due to classroom interruption and attendees having easy access to emails. Onsite training requirements • 6 -week lead time for internal coordination. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 47/151

• 48/151 Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material • If they haven’t done so yet, users must pre-register on the Qlik website (www. qlik. com) and remember that their login details are needed for the class. • All the attendees’ Qlik user IDs, names, surnames & email addresses must be sent to qliktraining@ioco. tech 5 working days before the course starts to initiate the Qlik Continuous Class Enrolment process.

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 49/151

Qlik Sense for Qlik. View Developers Workshop Overview 1 -day S 4 QV 50/151

Overview This workshop is aimed at users who regularly develop with Qlik. View, want to see what Qlik Sense does and how to migrate from Qlik. View to Qlik Sense. Intended audience • Qlik. View developers Prerequisites for attendees 51/151 • Qlik. View designer and developer classes • 2 months of experience in developing with Qlik. View

Content • Qlik Sense components • Qlik Sense development lifecycle • Basic development techniques (including variables) • Qlik Sense Desktop entry point 52/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 53/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training because it is less effective due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 54/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 55/151

Create Visualizations with Qlik Sense Course Overview 2 -day QSCV 56/151

Overview Create Visualizations with Qlik Sense, a scenariobased course, addresses the fundamentals required to equip you for self-service visualization and discovery. The course combines demonstrations and hands-on exercises to teach the essential concepts for designing beautiful and effective Qlik Sense visualizations and guided stories. Additionally, you will look in depth at the different visualizations, selecting the appropriate one for your data and the type of questions you need to answer. This course provides you with the opportunity to build Qlik Sense visualizations and create guided story-telling. Intended audience • Business users • Contributors • App owners • Business analysts • Data architects Prerequisites for attendees Building an app tutorial (found under Tutorials in the online help of Qlik Sense Desktop) 57/151

Content • Perform advanced analysis in Qlik Sense • Identify data types and explain how they are interpreted as visualizations • Design and create Qlik Sense visualizations, based on user-centered workflows, for others to use • Discuss concepts of data visualization and how they are implemented in Qlik Sense • Identify best practices for Qlik Sense visualization design • Share insights with Qlik Sense guided story-telling • Explain how Qlik Sense’s responsive design enables developing multiscreen design 58/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 59/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • While we do offer onsite training our past experience recommends that onsite training because it is less effective due to classroom interruption and attendees having easy access to emails. Onsite training requirements • 6 -week lead time for internal coordination. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 60/151

• 61/151 Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material • If they haven’t done so yet, users must pre-register on the Qlik website (www. qlik. com) and remember that their login details are needed for the class. • All the attendees’ Qlik user IDs, names, surnames & email addresses must be sent to qliktraining@ioco. tech 5 working days before the course starts to initiate the Qlik Continuous Class Enrolment process.

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 62/151

Data Modeling for Qlik Sense Course Overview 3 -day QSDM 63/151

Overview This course addresses the need to learn how to develop a coherent data model in Qlik Sense by loading and transforming multiple data sources Intended audience • Data architects Prerequisites for attendees 64/151 • Create Visualizations with Qlik Sense Course • Database and SQL query knowledge

Content • Create a data model in Qlik Sense • Create and maintain data connections • Resolve data structure issues and script errors • Transform data • Discuss synthetic keys and circular reference • Leverage external data services • Define advanced uses of the data load editor • Add dimensions and measures to the library • Add simple visualizations 65/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 66/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training because it is less effective due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 67/151

• 68/151 Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material • Users must pre-register on the Qlik website (www. qlik. com) and remember that their login details are needed for the class. • All the attendees’ Qlik user IDs, names, surnames & email addresses must be sent to qliktraining@ioco. tech 5 working days before the course starts to initiate the Qlik’s Continues Class Enrolment process.

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 69/151

Qlik Geo. Analytics Workshop Overview 1 -day WQGA 70/151

Overview Location, location: visualize and analyze the whole story! Increasingly, there’s a need for detailed, comprehensive geospatial information. Geo. Analytics enables both Qlik Sense and Qlik. View users to easily add maps to their apps with automatic geo-data lookup to reveal crucial spatial information and then overlay them with different visualizations to see the whole story of their data. This workshop will enable users to create single to multi-layer maps using the powerful Geo. Analytics extensions. You will also learn how to perform geospatial calculations using the Geo. Analytics Connector. The workshop is a combination of lectures and demonstrations, followed by hands-on activities. Intended audience • Experience with Qlik app development • Business developer (power user) who has the prerequisite skills Prerequisites for attendees 71/151 • Qlik Sense development knowledge (While Geo. Analytics is available for both Qlik. View and Qlik Sense, this workshop will be conducted using Qlik Sense) • Basic geospatial understanding

Content By the end of this workshop, you will be able to: • Build maps using Geo. Analytics extensions • Geo. Analytics map • Geo. Analytics point layer • Geo. Analytics area layer • Geo. Analytics chart layer • Geo. Analytics line layer • Geo. Analytics animator • Create multi-layered maps (polygons, points, lines and charts) • Create data using Geo. Analytics Connectors such as: • • Closest • Routes • Within Load data from external source (Geo. JSON) 72/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 73/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 74/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 75/151

Create Mashups with Qlik Sense Workshop Overview 1 -day SWEB 76/151

Overview This introductory workshop provides the foundational skills required by developers to create web page mashups using Qlik Sense Dev Hub. Intended audience • Business analysts • Web developers Prerequisites for attendees 77/151 • Familiar with Qlik Sense architecture • Comfortable using common web scripting languages to create conditional operations, loops and variables

Content • Explain the concept of mashup • Create Qlik Sense mashups • Recognize supporting technologies upon which mashups are built • Manipulate supporting code layers for mashups • Identify how to learn more about supporting technologies • Share insights with Qlik Sense guided stories • Discuss security and licensing implications 78/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 79/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 80/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 81/151

Qlik Sense Governed Self-service Presentation Overview Half-day WGSS 82/151

Overview This presentation is aimed at BI teams who want to explore the concepts of self-service and governance considerations. The Qlik Sense features that support both concepts are explained and demonstrated. Best practise considerations are described. Intended audience • Qlik Sense site managers or BI leads (Please note that this presentation will not review the actual security rules used) Prerequisites for attendees • 83/151 Exposure to Qlik Sense HUB necessary

Content • • • Self-service concepts • The HUB • Visualization contribution • Data contribution Using i. Portal in a Qlik Sense development site • Impersonation • Governance • i. OCO Level 1, 2 and 3 GSS options Suggested road-map to establish a governed self-service BI with Qlik Sense 84/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 85/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The presentation is facilitated by an i. OCO pre-sales representative. Onsite presentation • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 86/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 87/151

Administer and Maintain Qlik Sense Course Overview 2 -day QSAM 88/151

Overview Administer and Maintain Qlik Sense is a technical course that gives you the information, tools, techniques and skills necessary to set up, configure, administer and manage a Qlik Sense Enterprise platform. Take advantage of Qlik Sense Enterprise class governance capabilities to ensure quality, accuracy and security of data and analytics. Intended audience • System administrators • Enterprise architects Prerequisites for attendees 89/151 • Fundamental knowledge of IT business systems and operations • Knowledge of Windows server operating system and active directory (or another user directory service) • Basic system security awareness • Understanding of Qlik Sense or Qlik. View recommended

Content • Install a single Qlik Sense Enterprise server node • Explore the QMC • Add and manage users • Add and manage apps, objects, streams and tasks • Understand Qlik Sense Enterprise security • Manage and audit system security • Understand data security with section access • Configure user license tokens • Add and manage data connections • Add and manage content libraries • Add and manage extensions • Monitor and troubleshoot typical system issues 90/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 91/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • The training is presented by an i. OCO consultant who is Qlik certified. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 92/151

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have ran training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, please register your specific requirement as this will trigger a scheduling. A training administrator will notify you ahead of a public announcement. 93/151

Qlik Sense Server Administration Workshop Overview 1 -day QSSA 94/151

Overview This workshop is aimed at the infrastructure support personnel who will manage the Qlik Sense server. It is very technical in nature and will require attendees to work with Qlik Sense Server settings, Windows server settings and network configuration. The workshop is run onsite only; please see Page 6 for onsite terms. Intended audience • Qlik Sense server administrators (up to 10 attendees) Prerequisites for attendees • 95/151 Proficiency in Windows server and network administration is not a definite prerequisite but can be beneficial.

Content The content listed here indicates the areas that could be covered, but may vary from client to client based on their needs and infrastructure. • Qlik Sense server installation and upgrades – Even though the software is likely already installed and in use, this workshop will include a discussion regarding installation and upgrades. • Qlik Sense hub introduction – Web portal for users to access their apps • Qlik Sense management console – Web interface to manage Sense • User directory connectors • User admin roles • License management • Stream management • App development lifecycle • App reload task management • Data connection management • Content libraries • Configuration of nodes, engines, proxies, schedulers and load balancing rules 96/151

• Qlik Sense security rules overview – Based on the implemented governance level • Qlik Sense architecture & components – Overview of what makes up your Qlik Sense environment • • • 97/151 • Services • Program folders Troubleshooting – How to find, solve and report issues in your Qlik Sense environment • Reload tasks • Host whitelisting • Qlik support OS infrastructure Q&A • Backups • Antivirus • File maintenance

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 98/151

Training venue Onsite training • The training is presented by an i. OCO consultant who is Qlik certified. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 99/151

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 100/151

Qlik Sense Server Architecture Presentation Overview 1 -day SARC 101/151

Overview This presentation provides enterprise architects with techniques to advance their skills in Qlik Sense server components, architecture configurations, managing services, load balancing and single sign-on methods. Intended audience • Enterprise architects Prerequisites for attendees 102/151 • Understand fundamentals of IT business systems and server architecture • Familiar with the Qlik community’s “New to Qlik Sense Server’ videos • Knowledge of administering Qlik Sense is advantageous

Content • Explain the components of Qlik Sense • Navigate the Qlik Sense deployment console • Deploy single and multi-node configurations • Configure multiple and virtual proxies • Manage multiple schedulers • Discuss different environment uses • Create sync rules with Qlik Sense • Explain various methods for load balancing • Discuss single sign-on concepts 103/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 104/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The presentation is facilitated by an i. OCO pre-sales representative. Onsite presentation • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 105/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 106/151

Qlik. View Designer Course Overview 2 -day VDES 107/151

Overview Having knowledge and understanding of critical concepts and design components needed to create a Qlik. View app is essential for building effective and powerful solutions. Qlik. View Designer is a scenario-based course that utilizes a business case scenario to lead the attendee through the processes and steps necessary to build a Qlik. View app. The course is a combination of lectures and demonstrations, followed by handson activities. Intended audience • Front-end developer • A user who meets the course prerequisite Prerequisites for attendees 108/151 • Strong spreadsheet authoring skills, i. e. using formulas with IF(), VLOOKUP() (Please be aware that this course is designed for IT professionals) • Laptop with Qlik. View Local Client installed

Content By the end of this course, you will be able to: • Work the Qlik. View Local Client software • Layout and design your Qlik. View app • Use Qlik. View sheet objects • Load data from a spreadsheet 109/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 110/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 111/151

• 112/151 Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material • If they haven’t done so yet, users must pre-register on the Qlik website (www. qlik. com) and remember that their login details are needed for the class. • All the attendees’ Qlik user IDs, names, surnames & email addresses must be sent to qliktraining@ioco. tech 2 weeks before the course starts to initiate the Qlik’s Continuous Class Enrolment process.

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 113/151

Qlik. View Developer Course Overview 3 -day VDEV 114/151

Overview Developer is a must if you are building Qlik. View apps. Knowledge of the data model, creation of proper data connections and scripting fundamentals are critical to creating Qlik. View apps that provide your organization with powerful business discovery tools. Qlik. View Developer gives you an opportunity to learn by going through a series of lectures and hands-on exercises focused on developing Qlik. View apps. Beginning with the Qlik. View environment and covering topics such as data modeling, synthetic keys and how to use the script editor, the Developer course will prepare you to take your Qlik. View apps to the next level. The course concludes with a business case where you can practice your skills by building a Qlik. View app from the beginning, using identified key performance indicators. Intended audience • Qlik. View app developers Prerequisites for attendees 115/151 • Attendance of the Qlik. View Designer course (or equivalent knowledge) • A programming background with good knowledge of SQL queries • Laptop with Qlik. View Local Client installed

Content By the end of this course, you will be able to: • Create a data model in Qlik. View • Build a Qlik. View app • Resolve data structure issues • Access debugger • Define advanced uses of the script editor • Use transformative functions in the script • Discuss synthetic keys 116/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 117/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 118/151

• 119/151 Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material • If they haven’t done so yet, users must pre-register on the Qlik website (www. qlik. com) and remember that their login details are needed for the class. • All the attendees’ Qlik user IDs, names, surnames & email addresses must be sent to qliktraining@ioco. tech 2 weeks before the course starts to initiate the Qlik’s Continuous Class Enrolment process.

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 120/151

Qlik. View Methods and Visualization Workshop Overview 2 -day VVIS 121/151

Overview This workshop is aimed at Qlik. View developers who have worked actively with Qlik. View for at least 2 months. It reviews the Qlik. View approach to rapid application development, followed by visualization techniques. Best practice considerations are shown for designing interface for desktop and mobile. Intended audience • Active Qlik. View app developer Prerequisites for attendees 122/151 • Attendance of the Qlik. View Designer course • Two months of active Qlik. View development • Laptop with Qlik. View Local Client installed

Content • Qlik. View development steps and the data model • Expression design • • Navigation • Variables • Set analysis • TOTAL option in aggregation functions • AGGR() function Qlik. View data visualization • Charts for comparison • Charts for composition • Charts for relationship • Charts for distribution 123/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 124/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 125/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 126/151

Solution Design Workshop Overview 2 -day VSOL 127/151

Overview This workshop is aimed at Qlik. View developers who have worked actively with Qlik. View for at least 4 months. We have gathered lessons and insight from a variety of data subjects and complex projects, creating this material to help Qlik. View developers design, develop and deliver complex Qlik. View solutions. Intended audience • Experienced Qlik. View app developer Prerequisites for attendees 128/151 • Attendance of the Qlik. View Developer course • Four months of active Qlik. View development • Laptop with Qlik. View Local Client installed

Content • Qlik. View development methodology • Qlik. View design considerations • • • Understanding a QVW document • Impact of “field” naming • Lessons from data warehouse theory • Types of Qlik. View solutions Qlik. View development toolbox • Qlik. View built-in features • Qlik. View South Africa template & development tools Complex solutions • Multiple FACTS • Performance considerations • Multi-tier data layer and QVDs 129/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 130/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 131/151

• Attendees must have sufficient access rights on the workstations to: • Install the Qlik application • Load training material from and onto a USB drive • Receive full internet connectivity • Be able to download training material i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 132/151

Qlik. View Server Administration Workshop Overview 4 -hour VQVS 133/151

Overview This workshop is aimed at infrastructure support personnel who will manage the Qlik. View server. It is very technical in nature and will require attendees to work with Qlik. View server settings, Windows server settings and network configuration. The workshop is run onsite only; please see page 6 for onsite terms. Intended audience • Qlik. View server administrator Prerequisites for attendees • 134/151 Proficiency in Windows server and network administration

Content • Qlik. View Server (QVS) prerequisites • Pre-installation preparations • Load implementation folders & files onto server • Qlik. View folders & files explained • Upgrades: user impact (new URL & plug-in upgrade) • Optional when upgrading: Deploy the suggested QVSA standard folder structure & files • Installation • Upgrade • Introduction to Qlik. View Management Console (QMC) • Configuration • Licensing (managing CALs & future license updates) • Monitoring Qlik. View Server using QMC status (tasks, services, users) • Access Point configuration • Security • Optional: Integrating Active Directory with Access Point • Testing Access Point & reloads with client models • Backups 135/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 136/151

Training venue Onsite training • The training is presented by an i. OCO consultant who is Qlik certified. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 137/151

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 138/151

Qlik. View Publisher Administration Workshop Overview 1 -day VQVP 139/151

Overview This workshop is aimed at infrastructure support personnel who will manage the Qlik. View server. It is very technical in nature and will require attendees to work with Qlik. View server settings and manage the Qlik. View app reload tasks. The workshop is run onsite only; please see page 5 for onsite terms. Intended audience • Qlik. View server administrator Prerequisites for attendees • 140/151 Proficiency in Qlik. View server and the Qlik. View app reload schedules

Content • Installing Publisher • Activating/licensing Publisher • Distribution service configurations • Working in a Publisher environment • Building Publisher tasks • Loop and reduce capabilities • Distribution capabilities • Supporting tasks 141/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 142/151

Training venue Onsite training • The training is presented by an i. OCO consultant who is Qlik certified. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 143/151

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 144/151

Qlik Sense BI Competency Center Workshop Overview Half-day WBIC 145/151

Overview This workshop is for BI teams who want to explore the details of managing a self-service Qlik solution. We unpack the procedures and considerations to ensure healthy teamwork between those who support the Qlik solution and those who use it. The Qlik Sense features that support the concepts are explained and demonstrated. Best practise considerations are described. Intended audience • Qlik Sense site managers or BI leads (specifically, anyone with a Qlik Sense content admin role) Prerequisites for attendees 146/151 • Exposure to Qlik Sense HUB necessary • Preferably attended the Qlik Sense Governed Self-service Workshop

Content • Governed self-service recap • BI Competency Center background • Application development lifecycle concepts • Building a BI Competency Center • People • Procedures • Feedback 147/151

Certification • We do not run or facilitate Qlik certifications. • Additional experience will be required before attempting the Qlik Certification exam. • All certification information can be found at this link. 148/151

Training venue i. OCO classroom • • We have 2 training venues: • Johannesburg • Cape Town The training is presented by an i. OCO consultant who is Qlik certified. Onsite training • We do not recommend onsite training due to classroom interruption and attendees having easy access to emails. • There can be a 6 -week lead time. • Site requirements – the client is required to arrange a suitable venue with: • Sufficient internet connection for the instructor and attendees • Large format display of sufficient proportions so that all attendees can easily read the presented material – typically a projector and screen combination • Seating and desks for attendees and instructor • Sufficient, working power points for all attendees and instructor with access to a projector • Workstations (PC/laptop/terminal) for all attendees and instructor. Where security policies permit, the instructor can supply own laptop 149/151

i. OCO ATP i. OCO is an authorized training provider for Qlik. Since 2005, we have run training classes and workshops for our local Qlik community. In 2014, we migrated part of our offering to the material prepared by Qlik Education. We continue to incorporate new material from Qlik Education as it is made available. For further enquiries, please email qliktraining@ioco. tech. On-demand or unscheduled If the class you need is not scheduled, send us an email with your specific requirements which will trigger a scheduling request. A training administrator will notify you on the outcome of the request prior to public announcement. 150/151

Should you wish to view any of the course descriptions again, refresh the presentation. To close the document, press Esc key. 151/151