From Flawed Assumptions to Accurate Insights: The Power of Store-Level Data and AI in Retail Banner