|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/informatica-data-quality-analyst-beginners-guide/
课程评论：没有评论
课程名称：Informatica 数据质量分析师 - 初学者指南 课程概述：Informatica 分析师（IDQ Analyst）是一个基于网络的应用程序客户端，供分析师用于分析、清洗、标准化、分析和评分企业数据。商业分析师和开发人员使用 Informatica 分析师进行数据驱动的协作。课程内容涵盖了列和规则剖析、评分卡管理以及不良记录和重复记录的管理。此外，您还可以管理参考数据，并将其提供给开发人员以实现数据质量解决方案。 本课程的主要任务包括： 1. 数据剖析：创建并运行数据剖析，以分析企业数据的结构和内容，识别其优缺点。您还可以深入查看剖析结果的基础行，并将列添加到评分卡和参考表中。 2. 在剖析中创建规则：在剖析内创建和应用规则，规则是可重用的业务逻辑，定义运行剖析时应用于数据的条件。使用规则进一步验证剖析中的数据，并衡量数据质量的进展。 3. 数据评分：创建评分卡，对任何列的有效值或规则的输出进行评分。评分卡展示了剖析中列的值频率，以分数的形式显示数据质量的进展，并可以查看趋势图，以观察分数随时间的变化历史。 4. 管理参考数据：创建和更新供分析师和开发人员使用的参考表，以便用于数据质量标准化和验证规则，并导入数据质量字典文件作为参考表，以建立源数据与有效和标准值之间的关系。 5. 管理不良记录和重复记录：修复不良记录，合并重复记录。 该课程旨在为初学者提供掌握 Informatica 数据质量分析工具的基础知识，帮助学员提升数据管理和分析技能。
Informatica Analyst or IDQ Analyst is a web-based application client that analysts can use to analyze, cleanse, standardize, profile, and score data in an enterprise.Business analysts and developers use Informatica Analyst for data-driven collaboration. You can perform column and rule profiling, scorecarding, and bad record and duplicate record management. You can also manage reference data and provide the data to developers in a data quality solution.Organizations use Informatica Analyst to accomplish the following tasks:Profile data. Create and run a profile to analyze the structure and content of enterprise data and identify strengths and weaknesses. After you run a profile, you can selectively drill down to see the underlying rows from the profile results. You can also add columns to scorecards and add column values to reference tables.Create rules in profiles. Create and apply rules within profiles. A rule is reusable business logic that defines conditions applied to data when you run a profile. Use rules to further validate the data in a profile and to measure data quality progress.Score data. Create scorecards to score the valid values for any column or the output of rules. Scorecards display the value frequency for columns in a profile as scores. Use scorecards to measure and visually represent data quality progress. You can also view trend charts to view the history of scores over time.Manage reference data. Create and update reference tables for use by analysts and developers to use in data quality standardization and validation rules. Create, edit, and import data quality dictionary files as reference tables. Create reference tables to establish relationships between source data and valid and standard values. Developers use reference tables in standardization and lookup transformations in Informatica Developer.Manage bad records and duplicate records. Fix bad records and consolidate duplicate records.
