Overview

This Course cover some of the important topics that will be tested during Qlikview data architect certification.About the certification exam:This exam is based on QlikView Version 12.1, and has 60 questions to complete in 2 hours.Passing the QlikView Data Architect Certification Exam grants you both the QlikView Data Architect (DA) and QlikView Business Analyst (BA) certifications.Syllabus from Qlik for QlikView Data ArchitectGather and Interpret Requirements (8% of the exam)Given a set of business objectives, determine KPIs, dimensions, or measuresGiven customer requirements, determine an appropriate solution to meet the customer needsIdentify and Analyze Data Sources (18% of the exam)Given a data set, identify quality issuesDetermine the expected effects of data quality issuesGiven 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) diagramGiven a data set, determine the relationships among dataGiven 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 sourcesDescribe the circumstances under which different load strategies should be usedExplain the circumstances under which QVD files and/or n-tiered data architectures should be recommendedDescribe the use and properties of fact tables and dimension tablesExplain load techniques relevant to data transformationExplain the use of QlikView functions to transform dataExplain how to resolve complex calendar scenariosExplain the use and effects of different types of joinsGiven business requirements, determine appropriate section access configurationGiven 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 variablesExplain the purpose and functionality of the Table Viewer/System FieldsDetermine the root cause for discrepancies between values in legacy reports and QlikView valuesExplain the purpose and functionality of QlikView troubleshooting tools or functionsGiven a script, determine the cause and/or solution for a script errorDesign and Develop the QlikView Application User Interface (25% of the exam)Determine the result of a given function or complex expressionIdentify where alternate uses of expressions are appropriateGiven a scenario, determine the appropriate function or complex expression to useExplain how to implement Actions/Triggers in the QlikView interfaceGiven a scenario, determine the appropriate object or chart type to useExplain the purpose/functionality of common object propertiesGiven a scenario, determine the appropriate application performance tuning option to useGiven a scenario, determine the appropriate reload performance tuning option to useDeliver the QlikView Application (10% of the exam)Describe how to give the user information or direction for using the applicationExplain the purpose and functionality of the QV Server and PublisherDetermine the circumstances under which particular client types can be usedTopics Covered in this course:How to load data from excel file.How to apply cross tab while loading data from excel file.How to use of QlikView functions to transform data.How to use common string function while loading data.How to aggregate data using group by.How to restrict your data by using where.How to export your data from a internal table using Qlik scripts.How to implement set analysis.Upcoming modules: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 variablesExplain the purpose and functionality of the Table Viewer/System FieldsAbout Set Analysis:Set analysis offers a way of defining a set (or group) of data values that is different from the normal set defined by the current selections.Normally, when you make a selection, aggregation functions, such as Sum, Max, Min, Avg, and Count aggregate over the selections that you have made: the current selections. Your selections automatically define the data set to aggregate over. With set analysis you can define a group that is independent of the current selections. This can be useful if you want to show a particular value, for example, the market share of a product across all regions, irrespective of the current selections.Set analysis is also powerful when making different sorts of comparisons, such as what are the best-selling products compared with poorly-selling products, or this year against last year.

Skills

Reviews