ResponsePoint
Project Overview: ResponsePoint is a leading marketing company in the United States, managing the database for Regal Cinemas. Our team was tasked with creating an environment for managing data and running promotional campaigns, as well as developing tools to enhance customer experience, including finding the nearest cinema using ZIP codes.
Project Goals
- Automate reporting for promotional campaigns using Power BI and Tableau.
- Clean and manage large datasets for cinema operations and customer analytics.
- Develop a SQL-based solution to determine the nearest cinema for customers using ZIP codes.
- Enhance data-driven decision-making by creating comprehensive dashboards and reports.
Technologies Used
- SQL: Calculated nearest cinemas for customers based on ZIP code proximity.
- Power BI & Tableau: Developed and published dashboards for campaign performance and customer insights.
- SSRS: Scheduled reports for automated delivery to stakeholders.
- ETL Pipelines: Cleaned and transformed data for reporting and analytics.
Achievements & Impact
The project delivered several key benefits:
- Automated the process of finding the nearest cinema using a SQL-based distance calculation algorithm.
- Improved data accuracy and efficiency for managing promotional campaigns.
- Developed dashboards providing actionable insights for marketing strategies and customer engagement.
- Reduced manual effort in data preparation and reporting.
Challenges & Solutions
A significant challenge was determining the nearest cinema for a customer based on ZIP codes, which required geographical calculations:
- We implemented a SQL algorithm that calculated distances between customer ZIP codes and cinema locations using the Haversine formula.
- Optimized database indexing and queries to handle large datasets efficiently.
- Integrated the solution with Power BI dashboards, allowing users to visualize nearest cinema locations dynamically.
Project Results
By successfully implementing the nearest cinema calculation, ResponsePoint significantly improved customer experience. Promotional campaigns became more targeted, and operations became more efficient, ultimately driving better business outcomes.