XHVERSE / Practical tools
Tools
Start with the problem.
15 free tools by Rujikorn Ngoensaard (XH / bossruji). Compare a design choice, check a risk, or work through a technical idea.
Architecture
Placement, table layout, data contracts, and platform maturity.
Workload Placement Simulator
Compare Databricks, Fabric, and Power BI placement paths for a workload. Get a directional recommendation, runners-up, and review warnings.
Lakehouse Table Layout Advisor
Assess table size, file pressure, query filters, update patterns, and engine mix to get layout and maintenance guidance.
Data Product Contract Builder
Turn ownership, grain, freshness, quality, access, lifecycle, and consumer expectations into a copyable data product contract brief.
Data Platform Maturity Checker
A lightweight, anonymous maturity signal for platform architecture, governance, analytics delivery, operations, and documentation. Get a directional benchmark in under 3 minutes.
Governance
Access models and readiness for a governance program.
Access Model Simulator
Pressure-test Databricks, Fabric, and Power BI access paths against least-privilege controls, sensitivity, and masking expectations.
Governance Readiness Scorecard
Evaluate whether your organization is ready to implement a data governance program. Get a readiness tier, top blockers, and a prioritized 90-day action plan.
Modeling
Change history, analytical grain, and semantic models.
SCD Design Lab
Practice Slowly Changing Dimension design with realistic customer, product, and membership changes. Preview Type 1, Type 2, Type 3, Type 6, and ignore strategies.
Power BI Semantic Model Doctor
Check fact grain, relationships, measures, refresh mode, and report symptoms before a semantic model becomes slow or inconsistent.
Operations
Recovery decisions and a usable runbook.
Cost estimates
Directional estimates for cloud egress and lakehouse compute.
Cloud Egress Pricing Calculator
Estimate AWS, Google Cloud, and Azure egress costs for Thailand and Singapore internet, external cloud, and same-cloud regional paths.
Lakehouse Cost Calculator
Estimate monthly Databricks costs from your cluster config. See optimization suggestions with projected savings.
Practice and experiments
Explore Spark, compare SQL, and test architecture choices.
Spark Explained
Animated pipeline visualizer showing how data flows through Spark stages - partitions, shuffles, skew, and spills.
SQL Deathmatch
15 rounds of paired Spark SQL queries. Pick the winner, learn execution plan reasoning, and discover your tier.
Architecture Decision Roulette
10 real-world data platform scenarios. Pick your approach, then see how a Senior Data Engineer would call it.
Data Stack Roast
Select your stack components and get a brutally honest 3-paragraph roast of your architecture choices.