Power BI Relationship Auditor
Find duplicate dimension keys, blank keys and unmatched fact rows before creating Power BI relationships.
Open tool →Focused browser-based utilities for software developers, data analysts and automation engineers. Inspect data, troubleshoot SQL, generate code and validate common workflows without creating an account.
20 TOOLS · 15 AVAILABLE
Search utilities for SQL, data analysis, APIs, automation and software development.
Find duplicate dimension keys, blank keys and unmatched fact rows before creating Power BI relationships.
Open tool →Analyze join keys, unmatched records and potential row multiplication across two CSV datasets.
Open tool →Compare Docker Compose variable references with an .env file to find missing, empty and unused variables.
Open tool →Generate MySQL column definitions for automatic created_at and updated_at timestamps.
Open tool →Map INSERT target columns to source tables and SELECT expressions in common SQL statements.
Open tool →Test supported KNIME Rule Engine expressions against sample records with first-match evaluation.
Open tool →Explore SQL TRUE, FALSE and UNKNOWN results with interactive AND, OR, NOT and NULL examples.
Open tool →Inspect JSON responses and Link headers to identify cursor, offset and next-page pagination patterns.
Open tool →Find duplicate package declarations and obvious version-constraint conflicts in requirements.txt.
Open tool →Compare package.json dependencies with package-lock.json to identify missing entries and version drift.
Open tool →Explore how CALCULATE and common DAX filter modifiers change a sample filter context.
Open tool →Flag missing WHERE clauses and broad conditions in SQL UPDATE and DELETE statements.
Open tool →Generate culture-aware Power Query M code for date, number and time conversions.
Open tool →Validate CSV structure, quoting, column counts, headers and likely data types before import.
Open tool →Find missing properties, explicit nulls and mixed value types in JSON array records.
Open tool →Compare how MySQL INSERT IGNORE, REPLACE and ON DUPLICATE KEY UPDATE handle sample rows.
Coming soonTest file paths against .gitignore patterns and inspect which rule matches.
Coming soonCompare environment variable names across files while masking sensitive values.
Coming soonVisualize references between named steps in a Power Query M expression.
Coming soonTest supported n8n expression patterns against sample workflow data.
Coming soonFEATURED TOOL 1 OF 20
Explore focused utilities for data analysis, software development and workflow automation.
Available nowBROWSE BY TOPIC
Filter the toolbox by the tools and workflows you work with.
Queries, joins, MySQL and data checks.
Relationships, Power Query and DAX helpers.
KNIME, n8n and workflow expression tools.
Docker, environment files and Git utilities.
Packages, JSON and web development tools.
CSV, APIs and everyday developer tasks.
ABOUT THIS PROJECT
NewTechie Tools is a growing collection of focused utilities for developers, data analysts and automation engineers. Each tool is designed to solve a specific technical problem quickly, with no complicated setup.