D&B’s Trusted Company Data Sample
收藏资源简介：
Dun & Bradstreet’s Commercial Graph™ transforms fragmented enterprise data into trusted, connected, and continuously updated business identities—forming the foundation for modern Master Data Management (MDM) and AI-ready workflows. By grounding your data in verified business identities, your organization can create a consistent, enterprise-wide view of prospects, customers, and third-party relationships; helping to enable more confident decision-making across growth use cases. **Power Master Data Management with a Trusted Foundation** This dataset functions as a **foundational layer for Master Data Management**, enabling a **single, trusted view of business entities** across systems powered by the D‑U‑N‑S® Number. - Establish a persistent, verified identity for every business entity - Validate company firmographics such as location, industry, and employee size. - Enable governed, automated data stewardship and lifecycle management As an AI-ready data layer, it ensures that workflows and decisions are grounded in verified business identities and relationships. This 10,000 row synthetic dataset can be used to get a feel for what D&B B2B Company data can do for your credit, risk management, sales, marketing, data management and goals. The complimentary Cortex AI agent will help your team simulate how this data can be used across your business. **Use Cases:** - Establish a single, trusted source of truth for business entities - Enable entity resolution and identity management at scale - Deliver data enrichment and completeness - Support AI-ready data foundations and agent-driven workflows
数据集详情总结：D&B’s Trusted Company Data Sample
数据集名称：D&B’s Trusted Company Data Sample
提供商：Dun & Bradstreet
定价：免费
访问权限：无限访问
数据集类型：10,000 行合成数据样本，用于体验 D&B B2B 公司数据的功能。
核心描述
该数据集是 Dun & Bradstreet Commercial Graph™ 的一部分，专注于将碎片化的企业数据转化为可信、连接且持续更新的商业身份，为主数据管理（MDM）和 AI 工作流奠定基础。通过 D-U-N-S® Number，为每个企业实体建立持久、验证过的身份，支持企业级数据一致性。
主要功能与用途
- 主数据管理（MDM）：作为基础层，实现跨系统的统一、可信业务实体视图。
- 数据验证与丰富：验证公司基础信息（如地点、行业、员工规模），支持数据治理和生命周期管理。
- AI 就绪：作为 AI 就绪的数据层，确保工作流和决策基于经过验证的商业身份和关系。
- 关联 Cortex AI 代理：帮助团队模拟如何在不同业务场景中使用这些数据。
应用场景
- 建立单一、可信的业务实体真实来源
- 大规模实现实体解析和身份管理
- 提供数据丰富和完整性
- 支持 AI 就绪的数据基础和代理驱动的工作流
数据字典
- 表名称：B2B_COMPANY_SDMR_TB
- 列总数：134 列
- 数据预览示例（显示前 50 列中的部分列）：
FILLER_1(Varchar)DUNS_NUMBER(Varchar) - D-U-N-S 编号BUSINESS_NAME(Varchar) - 企业名称TRADESTYLE_NAME(Varchar) - 交易名称STREET_ADDRESS(Varchar) - 街道地址CITY_NAME(Varchar) - 城市名称STATE_PROVINCE_ABBREVIATION(Varchar) - 州/省缩写POSTAL_CODE(Varchar) - 邮政编码COUNTRY_NAME(Varchar) - 国家名称LATITUDE(Number) - 纬度LONGITUDE(Number) - 经度CEO_FULL_NAME(Varchar) - 首席执行官全名SALES_VOLUME_USD(Number) - 销售额（美元）- 其他列包括：层级代码、母公司 DUNS 编号、员工数量、行业代码等（共 134 列）
使用示例
-
层级代码分布分析： sql SELECT hierarchy_code, COUNT(DISTINCT duns_number) AS company_count FROM SHARED_MDM_COMPANY_SAMPLE.B2B_COMPANY_SDMR_TB GROUP BY all ORDER BY hierarchy_code;
-
查询有父子关系的 DUNS 数量： sql WITH c_b2b_company_sdmr AS ( SELECT duns_number, parent_duns FROM SHARED_MDM_COMPANY_SAMPLE.B2B_COMPANY_SDMR_TB ) SELECT COUNT(DISTINCT duns_number) AS child_duns_count, COUNT(DISTINCT parent_duns) AS unique_parents, (SELECT COUNT(DISTINCT d) FROM ( SELECT duns_number AS d FROM c_b2b_company_sdmr WHERE NOT parent_duns IS NULL UNION SELECT parent_duns AS d FROM c_b2b_company_sdmr WHERE NOT parent_duns IS NULL )) AS total_duns_in_relationships FROM c_b2b_company_sdmr WHERE NOT parent_duns IS NULL;
其他信息
- 刷新频率：每月
- 交付方式：安全共享（Secure share）
- 法律条款：标准
- 分类：AI & ML，Cortex AI Ready
- 联系方式：销售 - snowflakeLeads@dnb.com；支持 - snowflakesupport@dnb.com
提供商简介
Dun & Bradstreet 致力于帮助企业利用数据和洞察做出更智能的决策，其数据和洞察通过 Dun & Bradstreet Data Cloud 及支持的解决方案交付。
