|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/section-access-and-set-analysis-qlik/
课程评论：没有评论
课程名称：QlikView数据架构师认证入门 课程概述： 本课程涵盖了在QlikView数据架构师认证考试中将测试的一些重要主题。该认证考试基于QlikView版本12.1，共有60道题目，需在2小时内完成。通过QlikView数据架构师认证考试后，考生将获得QlikView数据架构师（DA）和QlikView业务分析师（BA）两个认证。 考试内容大纲： 1. **收集与解释需求（占考试8%）** - 根据一系列商业目标确定KPI、维度或度量。 - 针对客户需求，确定合适的解决方案。 2. **识别和分析数据源（占考试18%）** - 确定数据集中的质量问题及其预期影响。 - 理解实体关系图及数据之间的关系。 3. **创建QlikView关联数据模型（占考试39%）** - 解释与不同类型数据源连接的方法及注意事项。 - 描述何时使用不同的加载策略及QVD文件的适用性。 - 解释与数据转换相关的加载技术。 4. **设计与开发QlikView应用程序用户界面（占考试25%）** - 确定给定函数或复杂表达式的结果。 - 根据场景选择合适的对象或图表类型。 5. **交付QlikView应用程序（占考试10%）** - 描述如何为用户提供应用程序使用的信息或指导。 - 解释QV服务器和发布者的功能及其适用情境。 课程内容涵盖： - 从Excel文件加载数据的方式。 - 在加载Excel数据时应用交叉表的技巧。 - 使用QlikView函数进行数据转换。 - 聚合数据的技术，如使用GROUP BY。 - 通过WHERE语句限制数据。 - 使用Qlik脚本从内部表导出数据。 即将推出的模块包括： - 解决表关联问题的方法（例如，合成键/循环引用）。 - 控制语句和变量的使用及其功能。 - 表查看器/系统字段的用途。 关于集合分析： 集合分析提供了一种定义与当前选择不同的数据值集合的方法，能够在不受当前选择影响的情况下进行聚合，便于进行特定值的展示或不同种类比较，例如，自由选择市场份额或不同年份之间的对比。 该课程旨在为希望获得QlikView数据架构师认证的人员奠定坚实基础，并帮助他们熟悉考试中可能会遇到的各种概念和内容。
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.
