Executive Summary
The client faced a challenge with inconsistent data counts for new customers, causing confusion in various departments regarding the relevance of the numbers for marketing strategies. Factspan identified the SQL query differences causing the mismatch, leading to improved communication and a Power BI dashboard implementation. The streamlined approach now provides the company with consistent and reliable reporting, enabling well-informed marketing decisions and accurate growth tracking.
Project Highlights
- Uncovered SQL disparities affecting new customer counts
- Implemented a streamlined query approach to ensure consistent reporting
- Elevated leadership’s awareness of the logical flaw for informed decision-making
- Enhanced team communication to prevent future discrepancies
- Utilized Power BI dashboard for efficient monitoring of brand-new customers
