• 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 Sens
• Qlik Continuous Classroom – Business Analyst
• Qlik Sense Certification Exam Study Guide
• FREE Qlik Sense Business Analyst Certification Practice Questions

Identify Requirements (20% of the exam)

• Describe benefits of Qlik Sense features (e.g., smart search, responsive design, green-white-gray-light gray, APIs, extensions, web mashups, bookmarks, and stories)
• Evaluate business requirements for feasibility to implement within the Qlik platform
• Based on requirements identify the KPIs, dimensions, and measures
• Select security options to meet business requirements

Design Applications (22% of the exam)

• Determine visualizations needed to meet business requirements
• Determine methods needed to meet business requirements
• Determine sheets needed to meet business requirements
• Select the order of sheets within the application to provide an overall flow for user

Prepare and Load Data (18% of the exam)

• Identify data sources required to meet the business requirements
• Determine the steps and options to create a basic data model using the data manager
• Given a scenario, troubleshoot basic data modeling issues

Develop Applications (40% of the exam)

• Create applications using the available visualization design tools
• Use appropriate calculated fields, dimensions, and master items based on the design
• Identify options for implementing calculations within the application
• Apply the steps to build bookmarks and stories
• Distinguish editing capabilities between a published and unpublished application
• Determine the source of rendering issues in applications

• 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

Identify Requirements for the Qlik Sense Environment (14% of the exam)

• Evaluate environment options for a Qlik Sense deployment based on requirements
• Given a scenario, ensure Qlik Sense has access to required data sources
• Understand how to configure network access
• Determine the correct authentication and authorization method based on requirements

Install and Set Up Qlik Sense Enterprise (26% of the exam)

• Given a scenario, decide how to configure user access to Qlik Sense
• Configure user directory connectors and schedule synchronizations
• Determine the appropriate Qlik Sense proxy configuration
• Make decisions about loading and organizing apps into streams
• Demonstrate an understanding of how to deploy single- or multi-node architectures
• Determine the type of scheduler needed to support tasks

Manage the Environment (40% of the exam)

• Configure tasks
• Given a scenario, determine the load balancing configuration
• Given a scenario, determine how to configure data connectors
• Manage content libraries
• Install and manage extensions
• Perform backup and restore procedures
• Perform upgrade procedures
• Given a scenario, determine the appropriate security rule

Monitor and Troubleshoot the Environment (20% of the exam)

• Given a scenario, determine the appropriate monitoring tools or logs to troubleshoot Qlik Sense Enterprise environments
• Use the audit functionality
• Given a scenario, find the root cause of issues in Qlik Sense environments

• 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