ブログ
地味な半分からの記録
扱いにくい文書の解析、権限をあるべき場所で効かせること、答えを再現可能に保つこと——その技術記録。
Reproducing last quarter's number after the definition changed
The report said 41.2 percent in April. The same question returns 39.8 today, and nothing is wrong with either figure. Whether you can explain the gap in ten minutes or ten days depends on one architectural choice.
Row-level rules belong in the query, not in the prompt
If the only thing stopping an AI from returning another region's salary data is an instruction telling it not to, you do not have access control. You have a suggestion.
Why merged cells break retrieval, and what to do about it
A merged cell that flattens into the wrong row does not produce an error. It produces a confident, wrong number that looks exactly like a right one, and it is the most common silent failure in document AI.
Analysis rules are knowledge objects, not prompt text
Suppress cells under n=30. Control for age before reporting anything by marital status. Every senior analyst carries a hundred rules like these, and almost every AI analytics tool asks you to paste them into a prompt and hope.
エンタープライズ・データAIの二つの半分と、それを繋ぐ者がほとんどいない理由
文書AIは契約書を読めるが、データウェアハウスには問い合わせられない。分析AIはウェアハウスに問い合わせられるが、その契約書を読んだことがない。経営を左右する問いは、そのつなぎ目にある。