The purpose of this Data Catalog is to help you understand and make use of the data that is available in our Snowflake Data Warehouse for reporting and analysis. Snowflake contains Data Sources extracted from Tech Stack Applications, then transformed and integrated into the Trusted Data Model for simple and easy reporting and analysis. Trusted Data Models are expressed using standard dimensional modeling. Reporting and analysis is performed using either SQL run versus Snowflake (UI or Command Line), or using the Sisense BI Tool that connects to Snowflake.
We follow an ELT approach, not an ETL approach because the ELT approach gives us more flexibility in storing historical data and transforming it all within Snowflake. Data is stored in different schemas and databases in Snowflake as it progresses through Loading and Transformation Stages. For Data Access and Security reasons, only data surfaced in the PROD database is accessible to Sisense. Learn more about our Snowflake Data Storage process design in the Data Storage guide
Extraction and Loading: We use a variety of tools to extract data from Tech Stack applications and follow the Extraction Solution decision tree to ultimately decide which is the best tool to use for a given data source. The Pipelines guide contains more information about our Extraction processes.
Transformation: dbt is used for all in transformations. See our dbt guide for more details on why and how we use this tool. All dbt code is stored in our Analytics Project.
Sisense is our enterprise standard BI tool. See how Sisense is being used with the Sisense Usage Overview dashboard.
We are migrating to Tableau as our Enterprise BI Tool in FY24. During the transition period, we will use both Sisense and Tableau.
We used a boring solution for our first iteration of the Tableau production workbooks catalog. The production workbooks with meta data about the workbooks, handbook urls, and workbook urls are contained in YAML files in the GitLab Tableau Repository. In a future iteration, we intend to render the contents of the YAML files directly in the Data Catalog to provide a more direct method to access the workbooks. You can access the department or business motion YAML files below.
The analytics hubs provide links to the current SSOT dashboards for an area of business analysis. The data guides provide solution recipes to develop reporting, insights, and analysis for a business area. The ERDs provide the entity relationships between data objects in the enterprise dimensional model.
Coming SoonComing SoonThese data lineage diagrams illustrate how the data from critical Lead to Cash source tables flow through the Snowflake data models.
These data dictionaries provide definitions for the Lead to Cash fields used in the Snowflake Enterprise Dimensional Data Model.
The analysis section provides references to analytical projects developed by the Functional Analysts teams.
Coming soon
Coming soon
Coming soon
The analytics hubs provide links to the current SSOT dashboards for an area of business analysis. The data guides provide solution recipes to develop reporting, insights, and analysis for a business area. The ERDs provide the entity relationships between data objects in the enterprise dimensional model.
These data lineage diagrams illustrate how the data from critical Release to Adoption source tables flow through the Snowflake data models.
Coming Soon
These data dictionaries provide definitions for the Release to Adoption fields used in the Snowflake Enterprise Dimensional Data Model.
The analysis section provides references to analytical projects developed by the Functional Analysts teams.
Coming Soon)Coming Soon
The analytics hubs provide links to the current SSOT dashboards for an area of business analysis. The data guides provide solution recipes to develop reporting, insights, and analysis for a business area. The ERDs provide the entity relationships between data objects in the enterprise dimensional model.
These data lineage diagrams illustrate how the data from critical Team Member source tables flow through the Snowflake data models.
Coming Soon
These data dictionaries provide definitions for the Team Member fields used in the Snowflake Enterprise Dimensional Data Model.
Coming Soon
The analysis section provides references to analytical projects developed by the Functional Analysts teams.
Coming Soon
The analytics hubs provide links to the current SSOT dashboards for an area of business analysis. The data guides provide solution recipes to develop reporting, insights, and analysis for a business area. The ERDs provide the entity relationships between data objects in the enterprise dimensional model.
Coming SoonComing Soon
Coming Soon
These data lineage diagrams illustrate how the data from critical Team Member source tables flow through the Snowflake data models.
Coming Soon
These data dictionaries provide definitions for the Team Member fields used in the Snowflake Enterprise Dimensional Data Model.
Coming Soon
The analysis section provides references to analytical projects developed by the Central Data Team.
Coming Soon
📊 indicates that the solution is operational and is embedded in the handbook.
🚧 indicates that the solution is in a Work In Progress and is actively being developed. When using this indicator, an issue should also be linked from this page.
🐔 indicates that the solution is unlikely to be operationalized in the near term.