**BACKGROUND** Please share information about your company and your role. I serve as the Vice President of Data and Analytics at a sanitation company. Can you summarize what your company does in one sentence? We provide route-based sanitation services. **OPPORTUNITY / CHALLENGE** What specific goals or objectives did you engage Dynamic Data to achieve? We aimed to enhance our capabilities in Analytics Engineering, Business Intelligence, and Digital Marketing. **SOLUTION** How did you come across Dynamic Data? Through a referral. What led you to choose Dynamic Data over others? They had excellent reviews, a great cultural fit, and I was referred to them, plus their values aligned with ours. How many team members from Dynamic Data worked on this project? Between 6 and 10 employees. Please provide a detailed overview of the work scope, including key deliverables. Dynamic Data was tasked with implementing a modern, cloud-based data analytics and business intelligence infrastructure for our company for the first time. This involved deploying Snowflake as our central data warehouse, using Fivetran for efficient data ingestion, and leveraging DBT for automating data transformations. The team crafted high-performance data pipelines to facilitate real-time analytics, allowing us to scale from 200 to 1,000 users. They also established Tableau as our primary business intelligence tool and added Sigma to enhance user experience, especially for those without technical backgrounds. Moreover, the team instituted governance frameworks to provide secure and consistent access to data. Integrating Zenlytic AI further improved user engagement with BI tools, offering a chatbot for real-time data inquiries and report generation, which allowed users to quickly gain insights and lowered the need for manual support. They also prioritized scalability to ensure the infrastructure could accommodate increased usage while sustaining performance levels. To support ongoing development and deployment, they set up a CI/CD pipeline using GitHub for version control, automated testing, and streamlined system updates. **RESULTS & FEEDBACK** What measurable outcomes did the project yield that indicate progress or success? Improved Operational Efficiency: The team optimized our routes and provided real-time visibility into service appointments using data displayed on Tableau and Sigma dashboards. This led to fewer unnecessary trips, reduced missed services, and less demand on service technicians, enhancing overall operational efficiency. Enhanced Sales Performance: They integrated Salesforce sales data into Tableau, offering real-time insights into customer trends, sales performance, and progress toward targets. This empowered the sales team to identify orders requiring additional services or increased frequency. Streamlined Financial Reporting Migration: We transitioned all P&L financial reporting from Adaptive Insights to Tableau, which improved reporting and data accuracy for hundreds of users. This transition reduced report generation time by 30%, especially during month-end closings, allowing the finance team to focus more on strategic analysis and decision-making. There are numerous examples of how Dynamic Data quickly integrated into our organization, providing actionable insights and tools that have transformed our once unsophisticated operations into a highly professional entity. Our ongoing partnership reflects not only their consistent high-quality performance but also their adaptability and growth in skills. Describe their project management. Did they deliver items on schedule? How did they respond to your requests? Dynamic Data exhibited strong project management capabilities by implementing JIRA and fully digitizing our project management process for task handling through intake and CI/CD. They reliably delivered items on time and within the defined scope. They maintained clear communication and were quick to adapt to changing needs and priorities. Whenever new requirements or changes emerged, they proactively addressed them, ensuring minimal timeline disruptions. Their effective collaboration with various functional teams and flexibility contributed to smooth project execution. What was your primary means of communication with Dynamic Data? Virtual meetings and email or messaging applications. What impressed you most about this company? The team's professionalism and integrity stood out. They communicated effectively, were highly responsive to our needs, and consistently followed through on their commitments. They were not only intelligent but also approachable and friendly, facilitating collaboration at all levels. They made the effort to understand our challenges and proposed thoughtful, practical solutions with a positive attitude. Their commitment to delivering high-quality results while nurturing a supportive relationship made them a remarkable partner for us over the years. Are there any areas for improvement or something Dynamic Data could have done differently? None come to mind; I have been entirely satisfied with the quality of work and attitude displayed by Dynamic Data throughout the process.