Qlik Certifications & Qualifications

• Practical experience developing production-quality applications in Qlik Sense
• Experience creating dimensions, measures and objects for the master library
• Understands user experience and design best practices and has experience building visualizations.

• Instructor-Led Training: Create Visualizations with Qlik Sense
• Qlik Continuous Classroom – Business Analyst
• Qlik Sense Certification Exam Study Guide
• FREE Qlik Sense Business Analyst Certification Practice Questions

Identify Requirements (23% of the exam)

• Describe how the Qlik Sense capabilities can assist in analysis of data.
• Determine which Qlik products and QSE features/methods are needed to meet business requirements.
• Translate business needs into technical requirements.

Design Application (22% of the exam)

• Organize the application layout to meet business needs.
• Determine which visualizations meet business requirements.
• Determine design elements needed for flexibility, ease of use, and maintenance.

Prepare and Load Data (25% of the exam)

• Apply the steps to create the associative data model using the data manager.
• Troubleshoot basic data modeling and data issues.

Develop Application (30% of the exam)

• Configure dashboards and visualizations to illustrate business insights.
• Apply steps to share business insights.

• Practical experience developing multiple production-quality applications in Qlik Sense
• Ability to write Qlik Sense LOAD scripts and validate data
• Basic understanding of Extract-Transform-Load (ETL)
• Create and use connectors to various data sources
• Understand the QVD layer and architecture of the Qlik platform
• Ability to architect data to provide optimal performance
• Familiar with SQL and relational databases

• Instructor-Led Training: Data Modeling for Qlik Sense
• Qlik Continuous Classroom – Data Architect
• Qlik Sense Certification Exam Study Guide
• FREE Qlik Sense Data Architect Certification Practice Questions

Identify Requirements for Data Models (16% of the exam)

• Identify the data load and refresh requirements (e.g., tiered architecture, multiple data sources, varying refresh times)
• Given a scenario, identify Qlik Sense features to meet customer needs (e.g., associative data model, master items, ODAG, GeoAnalytics)
• Outline steps to implement security requirements

Design Data Models (28% of the exam)

• Determine an appropriate data model design to meet customer needs
• Decide on an appropriate data model that prioritizes reuse, scalability, and efficiency (e.g., tiered architecture, data governance)
• Determine how to manage complex scenarios (e.g., calendar, set analysis, flags, functions)

Build Data Models (34% of the exam)

• Create data models (e.g., join, keep, resident load, where clause, incremental load, purge strategy, variable)
• Given a scenario, use data transformation techniques with both data load editor and data manager
• Manage security using section access
• Use the Qlik Converter to migrate QlikView documents to Qlik Sense applications
• Use appropriate data connections

Validate Data (22% of the exam)

• Validate data models against source information using Qlik Sense visualizations
• Resolve data modeling issues (e.g., synthetic keys, circular references, scripting errors, debugging)
• Resolve data issues (e.g., null values, data formatting)

• At least 6 months experience as an administrator of a Microsoft Windows Server-based environment
• Experience working with Qlik Sense sites and the Qlik Management Console, to provide data and application governance, library maintenance, as well as user and application security
• Experience managing the policies and options that run the Qlik Sense servers and apps
• Experience creating rules and managing the visualization streams
• Knowledge of networking and Active Directory configuration, proxies, intermediate web servers, load balancers, etc.
• Familiarity with Windows tools and logs created (e.g., Event Viewer, Services Console, DCOM Console, Windows Registry)
• Experience using NSLookUp, Telnet, Ping, NetStat, Fiddler, and other browser tools to troubleshoot connectivity, interoperability, configuration, performance, etc.

• Instructor-Led Training: Deploy and Administer Qlik Sense
• Qlik Continuous Classroom: System Administrator
• Qlik Sense Certification Exam Study Guide
• FREE Qlik Sense System Administrator Certification Practice Questions

Plan Installation (20% of the exam)

• Given a scenario, recommend environment architecture
• Given a scenario, determine appropriate security strategies

Install System (22% of the exam)

• Configure initial environment for Qlik Sense access
• Configure multi-node deployment
• Configure proxy and virtual proxies

Manage Content (34% of the exam)

• Configure tasks based on business and system needs
• Apply procedural concepts to organize external content (Content Library and Extensions)
• Apply steps to manage streams and apps
• Apply steps to manage privileges in the Qlik Sense deployment
• Configure user roles and properties

Monitor and Maintain (24% of the exam)

• Investigate Qlik Sense errors and issues
• Given a scenario, demonstrate an understanding of how to monitor system performance
• Apply the steps to perform a backup and restore
• Apply the steps to perform upgrade(s)

• Prerequisites are identified on the Qualification Course Page
• Ability to build a Qlik Sense application

• Business Analyst courses in the Qlik Continuous Classroom
• Create Visualizations with Qlik Sense Instructor-Led Training

• Describe the various views in Qlik Sense
• Demonstrate navigating between different views
• Explain the value of stories
• Demonstrate building stories
• Describe circumstances in which to use stories
• Describe the use of effects in stories
• Identify the components of an app
• Demonstrate creating basic sheets
• Examine and conduct an analysis in an app
• Tell a simple story
• Describe how to create a bookmark
• Describe elements saved in a bookmark
• Manage bookmarks
• Search for and apply bookmarks
• Explain the value of creating master items
• Explain the process to create master items
• Analyze data for other users
• Demonstrate configuring master dimensions
• Compare the 'Add data' and 'Data load editor' options
• Compare the app sections for loading data into an app
• Demonstrate loading tables from multiple data sources
• Explain how key fields are identified and associations created
• Use various chart types
• Select the appropriate chart type
• Apply visual analysis features
• Distinguish between Qlik Sense Enterprise, Qlik Sense Desktop, and Qlik Sense Cloud
• Determine which features are locked upon publishing
• Describe the value of sharing apps in Qlik Sense Cloud
• Describe the benefits of 'in-memory' data
• Reload data in Qlik Sense Desktop
• Explain data reload tasks in Qlik Sense Enterprise
• Describe the benefits of the associative selection model
• Demonstrate selecting data in visualizations
• Describe the benefits of the selections bar and selections tool
• Explain the uses and benefits of snapshots
• Demonstrate taking a snapshot
• Use snapshot annotations
• Demonstrate managing the snapshot library
• Demonstrate adding a snapshot to a story
• Explain the difference between dimensions and measures
• Apply dimensions and measures to visualizations
• Determine which chart type to use based on dimensions and measures
• Demonstrate configuring alternative dimensions and measures
• Identify the various types of searches
• Explain what is searched for each type
• Demonstrate the various types of searched

• Prerequisites are identified on the Qualification Course Page
• Ability to build a Qlik Sense application

• Data Architect courses in the Qlik Continuous Classroom or
• Data Modeling for Qlik Sense Instructor-Led Training

• Describe the various views in Qlik Sense
• Evaluate when to use the 'Add data' option or the data load editor
• Demonstrate loading tables from multiple data sources
• Explain how key fields are identified and associations created
• Demonstrate using the data model viewer to evaluate the underlying data
• Explain the capabilities of the data manager view
• Explain how the data manager creates and edits data load script
• Demonstrate accessing and using association recommendations
• Describe the purpose of the data load script
• Apply techniques resolve data issues
• Demonstrate creating a connection to a database
• Use various database file connection options
• Use the data connections during execution
• Evaluate associations created by aliasing fields in the data load script
• Describe a table loading structure
• Demonstrate transforming data using expressions
• Evaluate scenarios in which to use a stacked preceding load
• Determine causes of synthetic keys in a data model
• Recommend solutions for resolving synthetic keys
• Recommend solutions for resolving circular references
• Demonstrate creating concatenated keys
• Demonstrate fully qualifying field names
• Examine solutions to script errors using the debugging tool
• Demonstrate locating and identifying errors in the data load script
• Demonstrate creating a data comparison table in a data model
• Demonstrate creating a validation object in an app
• Use counter fields for row counting
• Appreciate what is meant by 'in-memory' data
• Describe how data reload tasks are handled in Qlik Sense Enterprise
• Explain visibility of variables in an INCLUDE statement
• Demonstrate creating a custom sort order with INLINE statement
• Demonstrate creating a subset table with RESIDENT statement
• Determine when to create a dedicated calendar dimension
• Demonstrate creating a master calendar table
• Evaluate the various methods of combining tables
• Demonstrate various types of table concatenation
• Demonstrate various types of joins
• Evaluate scenarios for using mapping tables
• Demonstrate loading data from Qlik DataMarket into a data model
• Evaluate the changes to the data load script when using Qlik DataMarket
• Explain the value of creating master items
• Explain the process to create master items

• Fundamental knowledge of Business Intelligence, reporting and data analysis
• Practical experience working with QlikView to design applications
• Visualization and user interface design experience

• Instructor-Led Training: QlikView Designer
• Qlik Continuous Classroom - Business Analyst
• Additional recommended training: QlikView Developer and Advanced Topics in Design and Development
• FREE QlikView Business Analyst Certification Practice Questions

Gather and Interpret Requirements (12% of the exam)

• Given a set of business objectives, determine KPIs, dimensions, or measures

Identify and Analyze Data Sources (12% of the exam)

• Given a dataset, determine the relationships among data

Design and Develop the QlikView Application User Interface (76% of the exam)

• Determine the result of a given function or complex expression
• Identify where alternate uses of expressions are appropriate
• Given a scenario, determine the appropriate function or complex expression to use
• Explain how to implement Actions/Triggers in the QlikView interface
• Given a scenario, determine the appropriate object or chart type to use
• Explain the purpose/functionality of common object properties
• Given a scenario, determine the appropriate application User Interface performance tuning option to use
• Given user requirements, identify the appropriate screen resolution

• Advanced knowledge of Business Intelligence, reporting and data analysis
• Knowledge of SQL and/or other scripting languages, data modeling, data visualization and advanced QlikView functions
• Practical experience working with QlikView to design and develop applications
• User interface design experience

• Instructor-Led Training: QlikView Designer, QlikView Developer
• Qlik Continuous Classroom - Business Analyst, Data Architect
• Additional recommended training: Advanced Topics in Design and Development
• FREE QlikView Data Architect Certification Practice Questions

Gather and Interpret Requirements (8% of the exam)

• Given a set of business objectives, determine KPIs, dimensions, or measures
• Given customer requirements, determine an appropriate solution to meet the customer needs

Identify and Analyze Data Sources (18% of the exam)

• Given a data set, identify quality issues
• Determine the expected effects of data quality issues
• Given a data set, determine how the data characteristics at the field level will affect the QlikView data model (e.g., performance, accuracy)
• Interpret an entity relationship (ER) diagram
• Given a data set, determine the relationships among data
• Given a data set, determine how the relationships among data will affect the QlikView data model (e.g., performance, accuracy)

Create the QlikView Associative Data Model (39% of the exam)

• Explain methods and considerations for connecting to different types of data sources
• Describe the circumstances under which different load strategies should be used
• Explain the circumstances under which QVD files and/or n-tiered data architectures should be recommended
• Describe the use and properties of fact tables and dimension tables
• Explain load techniques relevant to data transformation
• Explain the use of QlikView functions to transform data
• Explain how to resolve complex calendar scenarios
• Explain the use and effects of different types of joins
• Given business requirements, determine appropriate section access configuration
• Given a scenario, determine how to resolve table association issues (e.g., synthetic keys/circular references, data types)
• Explain the use of control statements and/or variables
• Explain the purpose and functionality of the Table Viewer/System Fields
• Determine the root cause for discrepancies between values in legacy reports and QlikView values
• Explain the purpose and functionality of QlikView troubleshooting tools or functions
• Given a script, determine the cause and/or solution for a script error

Design and Develop the QlikView Application User Interface (25% of the exam)

• Determine the result of a given function or complex expression
• Identify where alternate uses of expressions are appropriate
• Given a scenario, determine the appropriate function or complex expression to use
• Explain how to implement Actions/Triggers in the QlikView interface
• Given a scenario, determine the appropriate object or chart type to use
• Explain the purpose/functionality of common object properties
• Given a scenario, determine the appropriate application performance tuning option to use
• Given a scenario, determine the appropriate reload performance tuning option to use

Deliver the QlikView Application (10% of the exam)

• Describe how to give the user information or direction for using the application
• Explain the purpose and functionality of the QV Server and Publisher
• Determine the circumstances under which particular client types can be used

• Fundamental knowledge of Business Intelligence, reporting, data analysis
• Practical experience working with the QlikView product suite, specifically the Server and Publisher components
• Knowledge and experience with Microsoft Windows Server based environments

• Instructor-Led Training: QlikView Server Publisher
• FREE QlikView System Administrator Certification Practice Questions

Install and Configure the Environment (22% of the exam)

• Explain the purpose of different QlikView services
• Determine the appropriate service installation to meet customer requirements
• Determine how to share system resources between QlikView services
• Determine the implications and outcomes of a specific configuration

Administer the Environment (35% of the exam)

• Differentiate between functionality of licensed and unlicensed Publisher
• Determine the appropriate task type to meet customer requirements
• Determine an appropriate method to monitor tasks
• Given a scenario, determine the appropriate options for configuring a task
• Given a scenario, determine the appropriate CAL type to use and describe methods to apply CAL types
• Describe how to proactively manage QlikView platform infrastructure
• Determine an approach to proactively manage Windows platform infrastructure (e.g. IIS, event logs, folder permissions)

Troubleshoot the Environment (43% of the exam)

• Identify an error based on log file information
• Determine the appropriate steps to identify issues (e.g., user reported, dialog box)
• Determine the cause of common performance issues
• Determine the appropriate system resource allocation to meet requirements
• Determine an appropriate strategy to resolve a performance issue
• Determine the cause of an environmental issue
• Describe how to handle client-server communication problems