Qlik-Sense-Business-Analyst Exam Format | Qlik-Sense-Business-Analyst Course Contents | Qlik-Sense-Business-Analyst Course Outline | Qlik-Sense-Business-Analyst Exam Syllabus | Qlik-Sense-Business-Analyst Exam Objectives

Exam Name: Qlik Sense Business Analyst Certification
Exam Format: Multiple-choice, multiple-response, and scenario-based questions
Number of Questions: ~40-60 questions
Duration: ~60-90 minutes (varies by exam version)
Passing Score: ~70% (may vary)
Delivery Method: Online proctored or at a Pearson VUE test center

- Based on business requirements, identify Qlik products, needed for the solution (QSE, QDC, QABDI, ODAG, Qlik Core, Attunity, Insight Bot, NPrinting, etc.)
- Explain Qlik Sense features (e.g., smart search, responsive design, accessibility features, themes, etc.) and how they impact app design
- Describe the differences between the Qlik deployment options
- Based on business requirements, identify KPIs, dimensions and measures

- Ask appropriate questions to understand the needs of the potential users of the Qlik Sense application
- Identify user types and their typical devices to use to access apps
- Explain the purpose of APIs, server-side extensions (such as R, Python), Qlik GeoAnalytics, web mashups, widgets, section access
- Explain and interpret results from Qlik Associative Engine
- Identify Qlik Cognitive Engine uses
- Consider performance during data loading and application development (removing unused columns, consider calculation condition)

- Create a basic data model using Data Manager (e.g., spreadsheets, CSV, flat files, QVDs, etc.)
- Define the steps to load and associate data
- Apply filters while loading data in Data Manager
- Manually create data table in Data Manager (creates Inline Load script)
- Explain synthetic keys and possible methods of resolution
- Create folder and file data connections
- Leverage data connections already in Qlik Sense Enterprise

- Based on the business requirements and desired insight, determine the optimal number of charts, correct chart type, order of dimensions, use of color, and measures
- Design the order of the sheets in an application to provide an overall flow matching the expectations of the user journey (DAR concept)
- Select object types appropriate for the required data analysis (e.g., a line chart to show a trend over time)
- Understand when and why to use an alternate chart recommendation
- Identify the proper expression to create the appropriate visualization to meet the business requirements

- Explain the impact of using mobiles devices on app design
- Leverage appropriate method for data comparisons (filters, bookmarks, alternate states, set analysis)
- Distinguish between situations when data security requirements need to use section access or security rules
- Add dimensions, measures, and objects
- Use the latest objects and features in the Visualization Bundle, e.g., trellis chart, Profit & Loss pivot table
- Use Advanced Authoring features, e.g., specify a default landing sheet, native container object, etc.
- Set up visualizations with alternate states

- Change the grid size after adding objects
- Create and use variables
- Use custom color in charts (e.g., ColorMix, CSS colors, If statements, etc.)
- Know what extensions are and when to use them
- Create a story
- Create master items

- Apply filters and create bookmarks
- Use advanced functions like AGGR and set analysis
- Perform tasks around making a production ready application (e.g., create a thumbnail image, appropriate title, etc.)
- Use Insight Advisor to generate visualizations
- Use chart suggestions to change visualization type
- Select appropriate screen layout



- Understanding Qlik Sense’s associative model
- Differences between QlikView and Qlik Sense
- Qlik Sense deployment options (Qlik Sense Desktop, Enterprise, Cloud)
- Qlik Sense Hub and its components (Sheets, Stories, Apps)
- Data model optimization techniques

- Associative Engine – Qlik’s in-memory data indexing technology
- In-memory processing – Data loaded into RAM for fast analysis
- QIX Engine – The underlying engine powering Qlik Sense
- QMC (Qlik Management Console) – Admin tool for managing Qlik Sense Enterprise
- Qlik Sense Hub – Central interface for accessing apps and visualizations

- Loading data from various sources (Excel, CSV, SQL, Web, REST APIs)
- Using the Data Load Editor and Script Editor
- Understanding ETL (Extract, Transform, Load) processes
- Optimizing data models (Star Schema, Snowflake Schema, Synthetic Keys, Circular References)
- Handling incremental loads and partial reloads
- Using variables and parameters in scripts

- Data Load Script – Script used to extract and transform data
- Resident Load – Loading data from an already loaded table
- Concatenate – Combining tables with similar fields
- Qualify / Unqualify – Handling field name conflicts
- Synthetic Key – An automatically created key due to multiple linking fields
- Circular Reference – A loop in table relationships

- Best practices for dashboard design
- Choosing the right chart types (Bar, Line, Pie, Scatter, Gauge, KPI, etc.)
- Using Master Items (Dimensions, Measures, Visualizations)
- Creating interactive filters (List Box, Dropdown, Slider, Search)
- Implementing Set Analysis for advanced filtering
- Using Bookmarks and Selections for user navigation

- Master Items – Reusable dimensions, measures, and visualizations
- Set Analysis – Advanced filtering syntax (e.g., ={$})
- Alternate States – Multiple selection states in the same app
- Bookmark – Saved selection state for quick access
- Storytelling – Creating guided analytics narratives

- Writing expressions using Aggregation Functions (Sum, Avg, Min, Max, Count)
- Using Conditional Functions (If, Pick, Match, etc.)
- Implementing Advanced Aggregations (Set Analysis, Aggr())
- Working with Date and Time Functions
- Creating Calculated Dimensions and Calculated Fields

- AGGR() – Nested aggregation function
- Set Analysis – Dynamic filtering in expressions (e.g., Sum({$} Sales))
- Calculated Dimension – A dimension derived from an expression
- Measure – A calculated metric (e.g., Sum(Sales))
- Variables – Storing reusable expressions (e.g., vTotalSales = Sum(Sales))

- Understanding Section Access for row-level security
- User roles in Qlik Sense (Admin, Developer, Analyst, User)
- Managing security rules in QMC (Qlik Management Console)
- Best practices for app security and governance
- Section Access – Script-based row-level security
- Data Reduction – Limiting data visibility based on user roles
- Stream – A folder-like structure for organizing apps
- Task – Scheduled reloads and distribution tasks

- Identifying and resolving performance bottlenecks
- Optimizing data models (reducing synthetic keys, minimizing joins)
- Using Qlik Sense Performance Analyzer
- Best practices for script optimization
- RAM Utilization – Monitoring memory usage
- Cache Management – Handling cached data for faster reloads
- QVD (Qlik Data File) – Optimized Qlik-native data storage format
- Partial Reload – Updating only changed data

- Publishing apps to the Qlik Sense Hub
- Sharing insights via Stories and Snapshots
- Exporting data and visualizations (Excel, PDF, Image)
- Using Qlik Sense Mobile for on-the-go analytics
- Publish – Making an app available to end-users
- Snapshot – A static image of a visualization with current selections
- Mashups – Embedding Qlik Sense apps in external websites
- Qlik Sense Mobile – Accessing dashboards on mobile devices