QV12DA: QlikView Data Architect

– Given a set of business objectives, determine KPIs, dimensions, or measures
– Given customer requirements, determine an appropriate solution to meet the customer needs

– 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)

– 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

– 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

– 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