Developer Certification

QlikView 11 Developer Certification

The QlikView Developer Certification exam tests your ability to gather and interpret requirements, identify and analyze data sources, create the associative data model, design and develop the application user interface, and deliver the QlikView application.

The QlikView Developer Certification exam is a scenario-based, multiple choice knowledge test delivered at thousands of Pearson VUE test centers globally. This exam is available in 8 languages: Brazilian Portuguese, Chinese (Simplified), English, French, German, Japanese, Spanish and Russian.

Passing the QlikView 11 Developer Certification Exam grants you both the Developer and Designer certifications.

Exam Prerequisites

As this is an advanced technical exam, the following knowledge and experience is suggested:

  • 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

Recommended Preparation Resources

Exam Domain Areas

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 (19% 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 (24% 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

Audience

QlikView Designers
QlikView Developers