Data Marketplace
A central interface for exploring and learning more about Enterprise Data and Analytics assets
Enterprise Data Knowledge Hub
Enterprise Data Platform Architecture
Enterprise Data Warehouse (EDW): centralized, maintained storage repository for structured, integrated, and historical data across Stanley Black and Decker.
Data Source Systems
System where data is sourced, including standard ERPs, data input applications, or externally sourced / web sracped sites
Raw Zone 3
Uncategorized data directly mirroring a source system's backend table and field configurations. Requires direct source system expertise
Consolidated Zone 4
Combines data across multiple sources systems, merging it in a unified manner within business oriented fields and tables
Data Marts Zone 5
Targeted and mature data repositories for focused analysis, business ready reporting, and data application development
Report/Consumption
Composed using fully managed, purpose-built, analytics services that enable interactive SQL, BI dashboarding, automation, and ML
Key Terms Flash Cards
Available Data and Reporting
Accessing and Using Data
Data Architecture
Data Technologies
Snowflake Role
A data access method which allows data to be grouped and viewed seamlessly across databases and schemas
Database
The main architectural component, including DEV, TEST, and PROD iterations, of a data storage environment
Collibra
Data governance and cataloging platform for managing, organizing, and showcasing available data assets
Data Dictionary
Centralized repository of metadata surrounding available enterprise data assets with added business context
Data Connection
The combination of using authentication methods to point to and utilize data within storage environments
Data Schema
Data storage architecture element that defines the logical organization of data tables and views
Snowflake
Cloud-based data platform providing solutions for both scalable analytics and enterprise data storage
Report Catalog
Centralized repository of reports providing information and access to available reports within an organization
Data Domain
Categories of data that classify and organize it by what information it provides vs. where it is sourced
Snowflake Zone
Databases describing data maturity. Diagram Above. Zone 3 (Raw) Zone 4 (Consolidated) Zone 5 (Business Ready)
Power BI
Microsoft business intelligence (BI) tool for creating data visualization dashboards and reporting