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