THIS SITE IS UNDER CONSTRUCTION
SCRIBEKEY DATA PROFILING BOOK
Data Profiling: The ScribeKey Method at Amazon
SCRIBEKEY DATA PROFILER: DESCRIBE CONTENTS, MEASURE QUALITY, TRACK CHANGE
- Get the free version and sample data:
ScribeKey Data Profiler Installer V1.1
Sample Data
Solutions Data
Get the brochure:ScribeKey_Data_Profiler_Brochure.pdf
Take a look at a sample profile:
ScribeKey_Sample_Profile.zip
Works with SQL Server, Oracle, DB2, MySQL, Postgres, SQLite, MS Access, dBase, MS Excel, CSV, and XML.
Key features:
- Capture table, view, column, and value structure and contents.
- Highly configurable to focus in on only tables and columns of interest.
- Generate vendor specific metadata collection tables.
- Create HTML data dictionaries.
- Capture schema and contents differences between 2 database versions.
- Capture relationships and cardinality between database columns.
- Match column values against lookup tables or regular expressions.
- Easily share profile results as MS Office documents or in your database.
- Profile XML files.
- List .NET and OLEDB providers, and ODBC drivers on your computer.
- Database neutral SQL command line tool, interactive or batch.
What is data profiling?
- Data profiling is systematically exploring and capturing the essential information describing the structure, contents, and meaning of the data in a database.
- Data profiling is an important tool in data quality improvement, data cleansing, data migration, data warehousing, and business intelligence.
- If you think of your database as a large book with lots of details, the data profiler can be thought of as a tool to generate a table of contents and an index, or if you think of your database as a large building with lots of floors and rooms, the data profiler is a tool that can generate a set of architectural blueprints.
- The results of the data profile are themselves stored in a relational database, commonly referred to as a metadata repository.
Create structured, concise, and detailed data profiles of your datasets for more efficient:
- Application Development
- Data Quality Improvement
- Integration, Migration, and ETL
- Data Exploration and Analysis
- Schema Matching
- Metadata & Data Dictionary Development
Highly beneficial for:
- Master Data Management
- Data Stewards
- Developers and System Integrators
- Data Brokers and Providers
- Data Evaluators
- Data Analysts
- Project Managers
- End Users
Easy to use, flexible, affordable:
- Start profiling right away.
- Share profile results easily with your team as MS Access, MS Excel, HTML, XML, or in your database.
- Industrial strength batch command line built with .NET.
- Wide variety of configurable settings.
- Comprehensive user guide includes tutorial and workflow use cases.
- Webinar or on-site training, project implementation assistance, and custom profiler development available.
SCRIBEKEY GIS DATA PROFILER FOR ARCGIS
ScribeKey's GIS Data Profiler for ArcGIS 10.3 and later, is freeware, no licensing is required.
GIS Cafe Press Release
ScribeKey Releases GIS Data Profiler
- Download evaluation copy:
SKGDP 1.6 for ArcGIS 10.3
SKGDP 1.6 for ArcGIS 10.3 Installation Instructions
SKGDP 1.5 for ArcGIS 10.2
SKGDP 1.4 for ArcGIS 10.1
SKGDP 1.4 for ArcGIS 10.0
SKGDP 1.2 for ArcGIS 9.3.1
- Download US Census sample data: mydata.zip
- Download sample data results: mydata_solutions.zip
- Request a demonstration using the contact form below.
- All HTML, Metalayer, and XML/Metadata tools are fully functional in the evaluation version.
Learn more:
Get the brochure:ScribeKey_GIS_Data_Profiler_Brochure.pdf
Take a look at a sample profile:
ScribeKey_GIS_Data_Profiler_Sample.zip
Short presentation: ScribeKey_GIS_Data_Profiler_Short_Presentation.pdf
In-depth presentation: ScribeKey_GIS_Data_Profiler_Presentation.pdf
Explore the comprehensive user guide: SKGDP_User_Guide.pdf
Presentations
Scribekey Data Change Tools
Geospatial Metadata: Revising the Approach
Data Modeling Demystified
Building A Geospatial Data Dictionary
Geo Rollup and Drilldown: Geospatial BI and Data Aggregation
Using Meta-Layers for GIS Dataset Tracking and Management
Enhanced Data Description Presentation
Finding and Fixing Data Quality Problems
SCRIBEKEY DATA PROFILING BOOK
Data Profiling: The ScribeKey Method at AmazonSCRIBEKEY DATA PROFILER: DESCRIBE CONTENTS, MEASURE QUALITY, TRACK CHANGE
- Get the free version and sample data: ScribeKey Data Profiler Installer V1.1 Sample Data Solutions Data
Works with SQL Server, Oracle, DB2, MySQL, Postgres, SQLite, MS Access, dBase, MS Excel, CSV, and XML.
Key features:
- Capture table, view, column, and value structure and contents.
- Highly configurable to focus in on only tables and columns of interest.
- Generate vendor specific metadata collection tables.
- Create HTML data dictionaries.
- Capture schema and contents differences between 2 database versions.
- Capture relationships and cardinality between database columns.
- Match column values against lookup tables or regular expressions.
- Easily share profile results as MS Office documents or in your database.
- Profile XML files.
- List .NET and OLEDB providers, and ODBC drivers on your computer.
- Database neutral SQL command line tool, interactive or batch.
What is data profiling?
- Data profiling is systematically exploring and capturing the essential information describing the structure, contents, and meaning of the data in a database.
- Data profiling is an important tool in data quality improvement, data cleansing, data migration, data warehousing, and business intelligence.
- If you think of your database as a large book with lots of details, the data profiler can be thought of as a tool to generate a table of contents and an index, or if you think of your database as a large building with lots of floors and rooms, the data profiler is a tool that can generate a set of architectural blueprints.
- The results of the data profile are themselves stored in a relational database, commonly referred to as a metadata repository.
Create structured, concise, and detailed data profiles of your datasets for more efficient:
- Application Development
- Data Quality Improvement
- Integration, Migration, and ETL
- Data Exploration and Analysis
- Schema Matching
- Metadata & Data Dictionary Development
Highly beneficial for:
- Master Data Management
- Data Stewards
- Developers and System Integrators
- Data Brokers and Providers
- Data Evaluators
- Data Analysts
- Project Managers
- End Users
Easy to use, flexible, affordable:
- Start profiling right away.
- Share profile results easily with your team as MS Access, MS Excel, HTML, XML, or in your database.
- Industrial strength batch command line built with .NET.
- Wide variety of configurable settings.
- Comprehensive user guide includes tutorial and workflow use cases.
- Webinar or on-site training, project implementation assistance, and custom profiler development available.
SCRIBEKEY GIS DATA PROFILER FOR ARCGIS
ScribeKey's GIS Data Profiler for ArcGIS 10.3 and later, is freeware, no licensing is required.GIS Cafe Press Release
ScribeKey Releases GIS Data Profiler- Download evaluation copy: SKGDP 1.6 for ArcGIS 10.3 SKGDP 1.6 for ArcGIS 10.3 Installation Instructions SKGDP 1.5 for ArcGIS 10.2 SKGDP 1.4 for ArcGIS 10.1 SKGDP 1.4 for ArcGIS 10.0 SKGDP 1.2 for ArcGIS 9.3.1
- Download US Census sample data: mydata.zip
- Download sample data results: mydata_solutions.zip
- Request a demonstration using the contact form below.
- All HTML, Metalayer, and XML/Metadata tools are fully functional in the evaluation version.
