Skip to main content

Analytics Data Platform Facilitating a Greener Future

At Allston Yale, our mission is "Powerful Decisions. Powered by Data." We are dedicated to helping businesses with valuable insights. We do this through our Analytics Data Platform and advanced data analytics services. In a recent engagement with GFL Environmental Inc., a leader in the environmental and waste industry.

We created a custom Power BI solution for GFL. This helped simplify their data collection and reporting. Now, they can make decisions based on data. We also checked how well their Microsoft 365 training webinars worked. Additionally, we found ways for them to improve strategically.

Sustainable Waste Management Data Analytics Challenges

GFL Environmental Inc. operates within the environmental and waste management sector, focusing on innovative solutions to improve sustainability. Their challenge arose from an inability to efficiently analyze customer satisfaction data from Microsoft 365 training webinars hosted on GoTo.com. These training sessions, aimed at improving employee proficiency in tools like Teams and SharePoint, were critical to their internal operations.

However, manually compiling data from GoTo.com into usable reports was a time-consuming and error-prone process, preventing GFL from gaining timely insights. They turned to Allston Yale, a trusted Data Analytics Consultant, to bridge this gap and deliver actionable insights.

The primary goal of the project was to create a comprehensive Data Visualization solution that allowed GFL to quickly assess participant satisfaction and attendance across all webinars. Specific objectives included:

  • Enabling data-driven decision-making about future training initiatives.
  • Validating the return on investment (ROI) for their webinar resources.
  • Providing a clear view of customer feedback to inform strategic business planning.

Nestlé required a demand forecasting system capable of accurately predicting finished goods demand 78 weeks in advance. The system needed to function seamlessly across six product hierarchies while ensuring forecast roll-ups and roll-downs maintained a 99.99% accuracy rate. With such high precision required, traditional forecasting methods and manual processes were not scalable.

Furthermore, Nestlé needed a way to integrate historical sales data with anticipated demand trends to prevent stockouts, reduce overproduction, and optimize inventory levels—all while keeping their supply chain responsive and efficient.

To overcome these challenges, Nestlé turned to Allston Yale, a trusted Data Analytics Consultant, to design a scalable, automated forecasting solution that would streamline their operations and improve decision-making.

Empowering Sustainable Waste
IT Team with Data Visualization

Allston Yale provided end-to-end Data and Analytics Consulting services to address GFL’s challenges. Using our expertise in Power BI and Data Visualization, we:

Requirements Gathering
& Wireframing 

Collaborated closely with GFL stakeholders to understand their goals and design a wireframe for approval.

Collaborated with Nestlé stakeholders to understand their objectives and data structures.

Designed an intuitive framework for forecasting roll-ups and roll-downs.

Report Development

Leveraged Power BI to transform raw data from GoTo.com into an intuitive, dynamic dashboard.

Built robust data pipelines using Azure Synapse and Azure Data Factory to automate data processing.

Integrated historical sales data with external market indicators for more precise forecasting.

User Acceptance Testing 
and Knowledge Transfer

Validated the solution with GFL’s team, ensured it met all requirements, and provided training for seamless adoption.

Developed dynamic Power BI dashboards to visualize demand trends across the six product hierarchies.

Enabled real-time tracking of key metrics such as days until stockout, forecast accuracy, and working
capital impact.

Data Analytics
Platform Deployment

Delivered the final report, empowering GFL with real-time access to customer satisfaction insights.

Conducted extensive testing to validate the accuracy of forecasts and system usability.

Provided hands-on training for Nestlé’s internal teams to ensure seamless adoption of the solution.

Data-Driven Decisions with Analytics Data Platform

Our Data Analytics Consulting services delivered measurable
outcomes for GFL, including:

Successfully deployed the forecasting solution, allowing Nestlé to generate automated, real-time demand forecasts with 99.99% precision.

Enabled continuous enhancements through iterative improvements based on new market trends and
business needs.

Data-Driven Decisions with
Analytics Data Platform

With Allston Yale’s Data and Analytics Consulting, Nestlé achieved transformational improvements in their supply chain forecasting

With Allston Yale’s Data and Analytics Consulting, Nestlé achieved transformational improvements in their supply
chain forecasting

 Enhanced Decision-Making through Data Analytics Consulting

The Power BI solution empowered GFL to evaluate their training initiatives effectively, revealing that 97% of participants were highly satisfied with the webinars. This validates the effectiveness of their training programs.

Improved Information Visibility with Data Visualization

The report highlighted over 90% satisfaction in areas such as webinar timeliness and content quality, enabling GFL to showcase the value of these sessions to stakeholders.

Time and Resource Optimization

By automating data collection and reporting processes, GFL significantly reduced the manual effort involved, freeing up resources for strategic initiatives.

Impactful Decisions Through Data Visualization Clarity

The collaboration between GFL Environmental Inc. and Allston Yale showcases how the power of clear, actionable data can shape business strategies and drive success. By leveraging our expertise in data analytics consulting and data visualization, we transformed GFL's manual reporting challenges into streamlined processes that enabled data-driven decisions. GFL not only validated the effectiveness of their training initiatives but also gained valuable insights to align their investments with organizational goals.

At Allston Yale, we specialize in empowering organizations to wield their data masterfully, unlocking new opportunities for growth and innovation. Ready to transform your data into impactful decisions?

Schedule a consultation with our team today!

Allston Yale Serves Businesses in Texas and across the USA