Enhancing business intelligence for a leading lighting solutions provider