Shop Catalog

---

Here’s what you will have access to as a Subscriber:

Manuals – Texts and Diagrams sharing wisdom derived from experienced , “busted knuckle , data wrench wrangling” authors.

• Abstracts
• “How To” Guides
• White Papers
• Books

Blueprints – Precision diagrams for your data repository “chassis” to ensuring your structure can perform at speed.

• Modeling Standards –
  • Naming Standards in general
  • Class Words and Data Types
  • Abbreviations
• Data Models – Entity Relationship Diagrams with Attribute Definitions
  • Logical Models – readable Entity & Attribute names
  • Physical Models – standardized / abbreviated Table & Column names
  • Data Dictionaries – Entity / Table and Attribute / Column descriptive definitions

• DDL Scripts – SQL Server Data Definition Language code to create the database objects shown in the Data Models supporting:
  • a Metadata Repository
  • Data Lineage Tracking with ETL Logic for
    • Transformation Rules
    • Validation Rules
    • Disposition Rules
  • Data Profiling
  • Data Quality Scoring
  • Multi-Source Discrepancy Tracking
  • Reference Data
• Load Scripts for Reference Data for
  • Geography
  • Healthcare Code Sets

Tools – Discounted / individually priced, downloadable technical assets  as ready to deploy code

• Excel Templates
  • Data Requirements Gathering with non-compliance identification against your naming standards
  • Data Quality Scoring with configurable rules, file summary and individual field scores and problem highlights
• SQL Functions
  • Data Pattern to generate a generic alpha-numeric representation of actual data values
  • Clean String to “strip out” unwanted characters that you specify with a Regular Expression
  • MD5 HASH to generate a HASK values from the values found in the specified columns
• SQL Stored Procedures
  • Data Profiling – Table Statistics
  • Data Profiling – Column Statistics
  • Data Profiling – Domain Statistics
  • Data Profiling – Column Statistics Enhancements
  • Data Profiling Suite
  • Data Profiling – Data Quality Scoring Add-on
  • Multi-Source Data Discrepancy Reconciliation
  • AI Custom Language Model – Metadata Narrative Generation — Prepping high-octane fuel from your raw “crude oil” data so your AI models perform reliably “on the track”.
• Parameter Controlled Scripts
  • T-SQL
    • Data Profiling – controlled calls to the Stored Procs that gather / produce
    • Data Quality Scoring
    • Discrepancy Tracking
    • Metadata Narrative Generation
  • PowerShell
    • Metadata Narrative Splitter — Break your Metadata “Chilton Manual”  into Chapters that your AI engine can consume

Subscriber’s Blog – Your area to share

How to Subscribe – Put on your coveralls and step inside the Metadata Garage where two veterans with eighty plus years of “grease under their fingernails” wrangling data have gathered instructions, diagrams and code while overhauling misfiring enterprise data engines.