Qlik Continuous Classroom:
- All courses in the Overview of Data Literacy section
- All courses in the Data Fundamentals section
- All courses in the Data-Informed Decision Making section
- Under the Analytical Techniques section, the Understanding Signal and Noise and Correlation vs Causation courses
- Book: The Functional Art by Alberto Cairo
- Book: Data Visualization by Andy Kirk
Exam Topics
Interpret Business Requirements
- Discuss business requirements for feasibility to implement
- Change a business question into an analytical question
- Explain data sources and refresh frequency needed to implement requirements
- Discuss KPIs, dimensions, and measures for analysis
Understand and Transform the Data
- Explain various data types and implications for analysis
- Compare various classifications of data
- Explain data structure and implications for analysis
- Explain subset of data needed for analysis using coding terminology
- Contrast data schemas and how they impact analyses
- Use basic statistics
- Explain aggregations needed for analysis
- Contrast types of distributions and explain implications in analysis
- Assess the need for data governance and security
- Transform data structure
Design and Build Visualizations
- Use appropriate visualizations and level of complexity for audience
- Use appropriate measurements Use appropriate properties of visualizations
- Arrange visualizations to engage audience and enable analysis
Interpret Visualizations
- Determine whether visualization is valid and can answer the analytical question
- Interpret visualizations to create observations
- Explain outliers, trends, and relationships between data elements
- Recommend a theory, then validate or invalidate it
Analyze Results
- Break down thoughts and ideas into a cohesive and logical analysis plan
- Analyze data and visualizations iteratively
- Examine your point of view for objectivity
- Evaluate different perspectives
- Question visualizations to develop insights
- Test for correlations and causations in the data
- Examine the data and visualizations with curiosity
Act on Results
- Decide the insights gained from analysis
- Recommend actions based on analysis
- Predict potential consequences of actions to minimize unintended consequences
- Assess actual results of actions
- Analyze feedback and determine adjustments needed for analysis
Share Results
- Summarize audience member types and what they care about
- Justify your analysis, observations, and insights
- Justify your conclusions, recommendations, and proposed actions with confidence
- Evaluate and incorporate feedback into action plan
- Use information ethically and appropriately
Data Analytics Certification
The Data Analytics Certification Exam measures your analytic and statistics knowledge, from a basic to advanced level. The exam is product-agnostic and covers four categories of analytics: Data Foundations, Foundational Analytics, Interpretation of Analytics, and Advanced Analytics. Recommended for Data Analysts and Data Scientists.
Prerequisites
The Data Analytics Certification Exam measures your technical ability within the world of data, analytics, data science, and data literacy. The exam covers technical aspects of statistics and analytics, including the ability to use data visualizations appropriately. To be prepared for this examination, individuals should have an understanding of the following elements:
- Data Fundamentals
- Analytical Testing
- Basic and Intermediate Statistics
- Hypothesis Testing
- Data Visualizations
- Decision Making with Statistics and Analytics
Recommended Preparation Resources
- All courses in the Overview of Data Literacy section
- All courses in the Data Fundamentals section
- All courses in the Data-Informed Decision Making section
- All courses in the Analytical Techniques section
- All courses in the Advanced Analytics section
Since there are many topics covered in this comprehensive exam, additional resources are recommended, for example the podcast, Data Skeptic.
Exam Topics
Data Foundations
- Back-End: Data Architect
- Database Design
- Data Basics
- Types - Ordinal, Cardinal, etc.
- Attributes
- Forms
- Normalization/Optimization
- Big Data
Foundational Analytics
- Aggregations
- Distribution Analysis
- Standard Deviation
- Correlation and Causation
- Signal and Noise
- Probability
- Sampling
- Decision Tree Modeling
- Goodhart’s Law
Interpretation of Analytics
- Hypothesis Testing
- Type I/II Errors
- Visualization Interpretation
- Descriptive Statistics
- Bias
- Histogram/Box Plots
- Inferential Statistics
Advanced Analytics
- K-Means Clustering
- Markov Analysis
- Regression Modeling
- T-Test
- Chi-Square Test
- AB Testing
- Algorithms
- ANOVA
Data Literacy Qualification
The Data Literacy Qualification Exam is a non-technical, product-agnostic exam, measuring an individual’s fundamental-level and applied understanding of skills and abilities to read, work with, analyze and communicate with data. This exam has 30 multiple-choice questions to answer in 1 hour.
Prerequisites
A candidate for the Data Literacy Qualification exam will have experience and ability to demonstrate proficiency in
- Awareness of the value of data
- Describing Data: Describe that the data is showing
- Reasoning with data: Understand what the data means relative to the question
- Communicating with data: Sharing insights using data, narrative and visualizations to gain support
- Making decisions that are influenced by data
Recommended Preparation Resources
- All courses in the Overview of Data Literacy section
- All courses in the Data Fundamentals section
- All courses in the Data-Informed Decision Making section
- Under the Analytical Techniques section, the Understanding Signal and Noise and Correlation vs Causation courses
Exam Topics
Interpret business requirements
- Change a business question into an analytical question
- Discuss KPIs, dimensions and measures for analysis
Understand and Transform data
- Explain various data types and implications for analysis
- Use basic statistics
- Explain aggregations needed for analysis
- Contrast types of distributions and explain implications in analysis
Interpretation visualizations
- Determine whether visualization is valid and can answer the analytical question
- Interpret visualizations to create observations
- Explain outliers, trends and relationships between data elements
Analyze results
- Examine your point of view for objectivity
- Question visualizations to develop insights
- Test for correlations and causations in the data
Act on results
- Recommend actions based on analysis
- Predict potential consequences of actions to minimize unintended consequences
- Assess actual results of actions
Share results
- Summarize audience member types and what they care about
- Justify your analysis observations and insights
Support a data literacy culture
- Rewarding and incentivizing the use of data
- Challenging non-data influenced decisionsM
- Why Data Literacy is important
Qlik Sense Business Analyst Certification
The Qlik Sense Business Analyst Certification Exam measures your ability to identify requirements, design applications, prepare and load data, and develop applications. This exam is platform neutral, which means that the content applies to both the client managed and SaaS editions of Qlik Sense. This exam has 50 multiple-choice questions to answer in 2 hours.
Prerequisites
- 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.
Recommended Preparation Resources
- Instructor-Led Training: Create Visualizations with Qlik Sense
- Qlik Continuous Classroom – Business Analyst
- FREE Qlik Sense Business Analyst Certification Practice Questions
Exam Topics
Identify Requirements (30% of the exam)
- Given a set of requirements, determine Qlik Sense product capabilities to deliver a solution.
- Based on business requirements, recommend KPIs, dimensions, and measures.
- Discuss the needs of the business users and how they will consume information.
- Apply understanding to interpret results from Qlik Associations.
- Given a scenario, determine optimal data loading and application development processes.
Design Applications (24% of the exam)
- Based on business requirements, determine visualization layout and characteristics.
- Given stakeholder feedback, evolve and enhance application design.
- Given data security requirements, distinguish when to use section access and/or access permissions.
Prepare and Load Data (14% of the exam)
- Given a scenario, use Data Manager to create a basic data model.
- Given a set of requirements, enhance and augment the data model.
- Given a scenario, verify the data model using the data model viewer.
Develop Application (32% of the exam)
- Given a scenario, build an application.
- Given a scenario, refine and finalize an application.
Qlik Sense Data Architect Certification
The Qlik Sense Data Architect Certification Exam measures your ability to identify requirements for data models, design and build data models, and validate the data. This exam is platform neutral, which means that the content applies to both the client managed and SaaS editions of Qlik Sense. This exam has 50 multiple-choice questions to answer in 2 hours.
Prerequisites
- 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
Recommended Preparation Resources
- Instructor-Led Training: Data Modeling for Qlik Sense
- Qlik Continuous Classroom – Data Architect
- FREE Qlik Sense Data Architect Certification Practice Questions
Exam Topics
Identify Requirements (20% of the exam)
- Determine primary requirements with business users.
- Given a scenario, choose stakeholders.
- Given a scenario, determine metrics and levels of granularity and aggregation.
- Determine dimensionality and need for slowly changing dimensionality support.
- Given a scenario, determine the appropriate level of security.
Data Connectivity (8% of the exam)
- Given a scenario, determine the data sources and connectors needed.
- Determine the appropriate method to create connections for data sources.
Data Model Design (28% of the exam)
- Given a scenario, determine the measures and attributes from each data source.
- Given a scenario, identify the appropriate type of data model.
- Determine the correct method to optimize the data model for Qlik Sense.
- Determine the correct method to implement data structures efficiently.
Data Transformations (38% of the exam)
- Determine the correct method to build data content based on requirements.
- Analyze and evaluate null and blank data handling required to support filtering.
- Determine the correct method to document Data Load scripts.
- Determine the correct method for date handling techniques.
- Determine the correct method to perform script organization and cleansing.
- Analyze relevant variables to build scripts for incremental loading for extract layer.
Validation (6% of the exam)
- Given a scenario, determine the appropriate method to validate and test scripts.
- Given a scenario, determine the appropriate method to validate and test data.
Qlik Sense System Administrator Certification
The Qlik Sense System Administrator Certification Exam measures your ability to identify requirements for environments, install and set up Qlik Sense Enterprise, manage environments, and monitor and troubleshoot. Exam content is based only on the client managed edition of Qlik Sense. This exam does not cover the knowledge and skills required to administer Qlik Sense SaaS edition. This exam has 50 multiple-choice questions to answer in 2 hours.
Prerequisites
- 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.
Recommended Preparation Resources
- Instructor-Led Training: Deploy and Administer Qlik Sense
- Qlik Continuous Classroom: System Administrator
- FREE Qlik Sense System Administrator Certification Practice Questions
Exam Topics
Installation (30% of the exam)
- Apply concepts to plan the infrastructure for the Qlik Sense Deployment.
- Determine how to install Qlik Sense Enterprise on Windows using Shared Persistence.
- Determine the appropriate methods to deploy single and multi-node configurations.
Configuration (32% of the exam)
- Given a scenario, create and manage streams and applications based on organization’s needs.
- Given a scenario, create and manage automated tasks based on different triggers.
- Given a scenario, create and manage load balancing rules.
- Given a scenario, create and manage AD connection and synchronize users and groups.
- Given a scenario, configure nodes to meet business needs.
Security and Licensing (16% of the exam)
- Describe the Qlik Sense licensing model.
- Determine how to configure user license access.
- Given a scenario, apply Qlik Sense Enterprise security rules.
Monitor, Troubleshoot, and Maintenance (22% of the exam)
- Identify how to monitor app issues.
- Determine the appropriate methods to monitor and troubleshoot typical system issues.
- Determine the appropriate methods to perform server maintenance.
Qlik Sense SaaS Business Analyst Endorsement
The Qlik Sense SaaS Business Analyst endorsement is designed to complement the Qlik Sense Business Analyst Certification - 2022. This endorsement validates skills in the SaaS specific capabilities of Qlik Sense needed in the role of business analyst.
Qlik Sense Business Analyst Certification - 2022 is required.
Prerequisites
- Prerequisite knowledge required for Qlik Sense Business Analyst certification
- Practical experience developing production-quality applications in Qlik Sense SaaS edition
- Qlik Sense Business Analyst certification
Exam Topics
Overview of Qlik Cloud edition
- Differentiate the features and navigation of the Qlik Sense Cloud hub (e.g., navigation menus, Insight Advisor, home, collections, profile settings, catalogs)
- Given a scenario, determine the appropriate tenant feature
Creating, publishing, and sharing apps
- Given a dataset, create an app.
- Apply the steps to add apps to the cloud environment.
- Confirm the process of publishing, sharing, and duplicating of apps.
- Given a scenario, identify parameters for using app action menu items related to app management.
- Given a scenario, manage organization of analytic content (including interacting with the User In).
- Build logical models to generate analyses based on queries (Business Logic, Insight Advisor).
- Demonstrate application of Simplified Authorin.
Adding and managing data
- Given a scenario, identify parameters for using app action menu items related to data management.
- Apply the steps to add/connect data to the Qlik cloud tenant and analyze via Data manager.
- Confirm the process of sharing datasets.
- Review datasets.
- Manage collections.
- Given a scenario, determine impact of classifications during impact analysis.
Collaborating with Qlik Cloud users
- Recognize the collaborative features of Notes.
- Given a scenario, demonstrate the management of spaces (shared, personal, and managed.
- Distinguish member roles that access apps and sheets.
- Apply steps to share app content (including sharing of Notes, Charts, On-demand apps, and subscriptions.
Qlik Sense SaaS Data Architect Endorsement
The Qlik Sense Data Architect SaaS endorsement is designed to complement the Qlik Sense Data Architect Certification - 2022. This endorsement validates skills in the SaaS specific capabilities of Qlik Sense needed in the role of data architect.
Qlik Sense Data Architect Certification - 2022 is required.
Prerequisites
- Prerequisite knowledge required for the Qlik Sense Data Architect certification.
- Practical experience developing multiple production-quality applications in Qlik Sense SaaS edition.
- Practical experience with data modeling, loading data, and creating data connections in Qlik Sense SaaS edition.
Exam Topics
Overview of Qlik Cloud edition
- Differentiate the features and navigation of the Qlik Cloud (e.g., navigation menus, Insight Advisor, home, collections, profile settings, catalogue)
- Given a scenario, apply appropriate data-level permissions and governance
Data modeling considerations
- Identify limitations of data model optimization (e.g., SaaS limitations on sizing).
- Given a scenario, select the appropriate Catalog option for data discovery (e.g. dataset review, details, tags).
Adding and managing data
- Apply the steps to add/connect data to the Qlik cloud tenant (both new and existing).
- Given a scenario, develop an app from a dataset.
- Determine appropriate data source management (e.g. details, classification, connections, scheduled reloads).
- Manage membership in managed spaces.
- Differentiate the use of Data gateway -Direct Access versus Qlik DataTransfer versus Direct Query.
- Explain the data connection options. (e.g. DataFiles default folder, ODBC…).
Collaborating with Qlik Cloud users
- Recognize the collaborative features of Notes.
- Given a scenario, demonstrate the management of datasets and notes in shared spaces.
- Distinguish member roles that access datasets, metadata, and apps.
- Apply steps to share notes, datasets and connections.
Qlik Sense SaaS Administrator Endorsement
The Qlik Sense SaaS Administrator endorsement validates the knowledge and skills required to plan, implement, and manage a Qlik Sense SaaS environment.
The role of a Qlik Sense SaaS Administrator requires an understanding of Qlik Sense functions and features, Qlik Sense Business Analyst Certification- 2022 is required.
Prerequisites
- 2022 Qlik Sense Business Analyst certification.
- Practical experience working with Qlik Sense SaaS edition in a production or development environment.
- Practical experience administering Qlik Sense SaaS edition, along with knowledge of other IT solutions to aid user management and software integration.
Exam Topics
Planning a Qlik Cloud Deployment
- Given a scenario, assign administrator and developer roles to users
- Given a scenario, identify appropriate Qlik Sense SaaS subscription (Qlik Sense Business and Qlik Sense Enterprise SaaS)
- Given a scenario, identify appropriate data security and governance to a tenant
Deployment of Qlik Cloud
- Management of Qlik Cloud subscription.
- Create and configure the Qlik Cloud tenant.
- Manage inbound and outbound traffic (allowlisting IP addresses and domain names).
Administering Qlik Cloud
- Given a scenario, identify appropriate use case for the Management Console (governance, content, integration, configuration).
- User management (including identity providers).
- Email configuration (including email sharing).
- Management of Qlik Cloud features (Data gateways, on-demand data tools).
- Manage lineage and impact usage.
Security considerations for Qlik Sense Cloud
- Given a scenario, manage Content Security Policy.
- Configure Multi-Factor Authentication (MFA).
- Manage and monitor users who generate API keys.
- Configure the Qlik Data Gateway to access data behind a firewall.
- Apply steps to configure Qlik DataTransfer and Data Gateway – Direct Access.
Qlik Sense Business Analyst Qualification
The Qlik Sense Business Analyst Qualification measures your fundamental skills and applied knowledge. It requires you to build a Qlik Sense application and complete a multiple-choice question exam. You will have 1 hour 15 minutes to complete this exam.
NOTE: This is not our expert-level certification, see the Qlik Sense Certifications tab on this page.
Prerequisites
- Prerequisites are identified on the Qualification Course Page
- Ability to build a Qlik Sense application
Recommended Preparation Resources
- Business Analyst courses in the Qlik Continuous Classroom
- Create Visualizations with Qlik Sense Instructor-Led Training
Exam Topics
- 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
Qlik Sense Data Architect Qualification
The Qlik Sense Data Architect Qualification measures your fundamental skills and applied knowledge. It requires you to build a Qlik Sense application and complete a multiple-choice question exam. You will have 1 hour 30 minutes to complete this exam.
NOTE: This is not our expert-level certification, see the Qlik Sense Certifications tab on this page.
Prerequisites
- Prerequisites are identified on the Qualification Course Page
- Ability to build a Qlik Sense application
Recommended Preparation Resources
- Data Architect courses in the Qlik Continuous Classroom or
- Data Modeling for Qlik Sense Instructor-Led Training
Exam Topics
- 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
QlikView Business Analyst Certification
The QlikView Business Analyst Certification Exam measures your knowledge of interface design of QlikView applications. This certification is recommended for all roles involved in the analysis, design and layout of the QlikView application user interface. This exam 50 multiple-choice questions to answer in 2 hours.
Prerequisites
- Fundamental knowledge of Business Intelligence, reporting and data analysis
- Practical experience working with QlikView to design applications
- Visualization and user interface design experience
