Digital Transformation delivered by BDO and Microsoft, for Sysco Ireland

Summary

 

Sysco is the largest food business on the island of Ireland. With a team of over 1,300 people delivering food solutions to thousands of customers every night, they provide businesses with a range of over 10,000 fresh, frozen, ambient food products, and non-food products.

Their reporting requirements became unsupported by the software vendor, and the whole organisation was facing challenges with the legacy software used. With no mechanism in place to migrate these reports to another software, Sysco Ireland sought a comprehensive reporting solution. They needed to efficiently migrate approximately 100 critical and non-critical reports to a cloud-based analytical tool. 

BDO's approach aligned technology with their specific needs, resulting in successful implementation and establishing the first successful stepping stone to a wider adoption of Power BI within the Sysco Ireland organisation. 

 

Sysco Ireland Explained


Sysco is the largest food business on the island of Ireland. What once was started by the Geary family has now grown to a team of over 1,300 people delivering food solutions to thousands of customers every night. 

Operating from a central Dublin location and seven regional centres, Sysco guarantees next-day island-wide delivery. They are the only food business in the country capable of delivering on their customers’ expectations regardless of how remote the business location is.


Sysco Ireland Project Overview

 

The project involved migrating the payroll reporting system of Sysco Ireland from Oracle Discoverer BI, which became defunct in September 2021, to Microsoft Power BI. The migration was necessary due to the discontinuation of Discoverer and the need for a more robust long-term reporting solution. The project aimed to seamlessly transition critical payroll reports and provide the payroll team with the capability to create ad-hoc reports using Power BI.


Sysco Ireland Project Objectives


  • Migrate Existing Reports
  • Maintain Continuity
  • Set up VPN for Database Connection
  • Assist with Power BI Licensing and Setup
  • Implement Data Access Mechanism 
  • Build Data Models in Power BI
  • Implement Power BI Gateway for Live Data Connection
  • Test Data Connections and Ensure Data Integrity
  • Training and Upskilling 
  • Report Prioritisation
  • Stakeholder Collaboration
  • Post-Migration Support


Sysco Ireland Challenges


  • Data Migration Complexity
  • Data Source Integration
  • VPN Setup and Security 
  • Data Validation and Quality Assurance 
  • Power BI Licensing and Configuration
  • User Training and Adoption 
  • Technical Compatibility
  • Data Governance
  • Communication and Collaboration
  • Change Management
  • Scalability and Performance 
  • Project Timeline and Resources 

 

Addressing these challenges required careful planning, technical expertise, effective project management, and collaboration between all stakeholders involved in the project.


BDO’s approach 

 

Our approach neutralises the problems that emerge in a technology-focused delivery.

  • BDO helps clients to be clear on what they want to achieve and why. Only then we configure or customise. This avoids unnecessary spending and time lost on things that clients will simply not use based on their current and projected needs. 

This can also reduce annual licensing costs. 

  • BDO talks to business leaders and managers about what they really need to achieve and why. We aim to understand what they are asking for on a non-technical level first. Then, we solve their challenges through technology. 

We do this to leverage ‘out of the box’ (OOTB) solutions and reduce lifetime cost by understanding the why of the outcome, not only the current how of inputs. 

This approach enables us to reimagine the current workflows in streamlined ways, more efficient to configure and maintain. And this is how we reduce lifetime costs and support complexities. 

  • BDO supports leadership teams to demystify the technology. By understanding how and why, they get to engage and lead the systems and processes we put in place. 

We help them understand how they can instil the right behaviours and address challenges. 

This is how we enable business leaders to “own” the solution and truly get its value.

  • BDO engage targeted users in conversations, validations, checking and testing to create the groundswell of positivity for the new platform.

We believe it’s much better to land a change on an eager audience than not. 

  • For most employees in an organisation, the details of the technology are irrelevant. It is simply assumed – like our car - that we expect it to work when we start it up. 

However, we reassure them of the reliability, security, compliance, and functionality of the technologies we are using. 

As they are proven leaders in their field, so will their security, compliance, GDPR capabilities, integrations, lifetime costs, support, exit options, and other processes work smoothly.  

 

BDO and Sysco Ireland, in agreement

 

In response to the imminent obsolescence of Oracle Discoverer, BDO collaborated closely with Sysco to tackle this challenge systematically. We focused on strategic planning, execution, and proved a clear commitment to deliver the following project milestones:

 

Report Prioritisation and Finalisation

At the beginning of the project, the team worked with Sysco Ireland to identify and prioritise the existing reports to be migrated. This step was crucial to ensure that critical reports were addressed first.

  • Reviewed existing reports and assessed their importance.
  • Collaborated with stakeholders to finalise the list of reports for migration.
  • Documented the prioritised list of reports.

 

Data Access Mechanism Setup

Establishing a robust data access mechanism was essential to connect Power BI with CoreHR data sources. This step ensured that data could be retrieved efficiently for reporting purposes.

  • Configured the necessary connections to CoreHR data systems.
  • Implemented security protocols and access controls for data retrieval.
  • Tested data access mechanisms for reliability and performance.

 

Migration of Critical Reports

This milestone focused on migrating the most critical reports, such as Payroll Journals and other high-priority reports, from Oracle Discoverer to Power BI.

  • Extracted data and report structures from Oracle Discoverer.
  • Transformed and loaded data into Power BI.
  • Built or recreated report templates in Power BI.
  • Verified the accuracy and functionality of migrated reports.

 

Data Model Development

Developing a comprehensive data model was essential to support the migrated reports and enable future ad-hoc reporting.

  • Designed and created the data model that aligned with the reporting requirements.
  • Defined relationships between data tables.
  • Implemented calculations and measures as needed for reporting.

 

User Training and Upskilling

Training and upskilling of the Sysco Ireland team were crucial to ensure they could effectively use Power BI for creating ad-hoc reports and queries.

  • Conducted training sessions for users on Power BI basics and advanced features.
  • Provided hands-on guidance for creating and customising reports.
  • Offered support and answered user questions.

 

Testing and Quality Assurance

Rigorous testing and quality assurance processes were vital to identify and rectify any issues in the migrated reports and data access mechanisms.

  • Conducted thorough testing of all reports, data access, and data models.
  • Addressed and resolved any discrepancies, errors, or performance issues.
  • Ensured data accuracy and report consistency.

 

Full Report Migration

After successful testing and validation, proceeded to migrate the remaining reports from Oracle Discoverer to Power BI.

  • Followed the same data extraction, transformation, and loading (ETL) processes for the remaining reports.
  • Verified the functionality and correctness of each migrated report.

 

Post-Migration Support and Optimisation

Provided ongoing support to address any issues that may arise after the migration. Additionally, optimised report performance and ensured a smooth transition to full Power BI utilisation.

  • Addressed user queries and issues promptly.
  • Monitored report performance and made necessary adjustments.
  • Conducted user feedback sessions to fine-tune reports and data access.

 

These key milestones were essential components of the project plan, ensuring a systematic and successful migration of the Sysco Ireland payroll reporting system to Power BI. Each milestone represented a critical phase of the project, contributing to the overall project's success.


BDO delivers strong outcomes

 

After careful consideration, strategizing, and planning, BDO delivered clear and measurable outcomes:


Report Migration Listing and Plan

  • Agreement on the listing and prioritisation of reports for migration.
  • A finalised migration report listing, including the grouping of reports.
  • Signed-off priority groupings.

 

Power BI Reports Migration

  • Developed data model as required for the reports.
  • All agreed reports successfully migrated to Power BI Desktop.
  • IT support provided for accessing client-side systems.

 

Self Service Reporting

  • Completed datasets and data modelling to enable user-friendly ad-hoc reporting by the Payroll Team.
  • SME (Subject Matter Expert) support as needed for self-service reporting.

 

Power BI Gateway Setup

  • Power BI Gateway set up for a live data connection.
  • Required infrastructure and access provided for setting up the Gateway internally.

 

Reporting Suite LIVE in Client-side Power BI Online Environment

  • Migration of the reporting suite from Power BI Desktop to the Online environment.
  • Reports published in Power BI Online for all end users to access.
  • Ongoing support provided as needed for the Online environment.

 

Training, Documentation and Support

  • Completed training sessions for users.
  • Supporting documentation for Power BI usage.
  • Support provided to the Sysco Ireland team during the Go-Live phase.
  • Handover of the project, ensuring the correct SMEs attend training or handover sessions as required.

These deliverables represent the tangible outcomes and milestones of the project, demonstrating the successful migration to Power BI, the establishment of self-service reporting capabilities, and the provision of training and support to enable Sysco Ireland to use the new reporting system effectively.


Case Study Conclusion

 

In the ever-evolving landscape of data-driven decision-making, the journey of Sysco Ireland towards modernising its payroll reporting has been one of transformation and empowerment. 

This case study underscores the profound impact of migrating from Oracle Discoverer to Power BI. This transition has not only averted disruptions but has also elevated the organisation's reporting capabilities to new heights.

Sysco Ireland recognised the imperative need to adapt to changing times, as Oracle Discoverer faced obsolescence. In collaboration with BDO Eaton Square, this project exemplifies a meticulous approach that encompassed planning, execution, and relentless commitment to delivering superior results.

The deliverables are a testament to this commitment, from the strategic prioritisation of reports to the meticulous migration of data and the seamless transition to Power BI Desktop & Online environments. 

The project has successfully equipped the payroll team with the power to wield data as a tool for strategic decision-making.

Beyond the technical facets, this case study also illuminates the human element. It showcases the importance of change management, user engagement, and ongoing support in ensuring a smooth transition. It highlights how knowledge transfer and training have been pivotal in empowering the team to harness the full potential of Power BI.

Looking forward, this change underscores Sysco Ireland's readiness to embrace a data-centric future and sets the stage for continued innovation. The journey from legacy systems to Power BI is not just a migration; it's a transformation that ensures Sysco Ireland is primed for a future where data is not just a tool but a strategic advantage.

In conclusion, this case study is a testament to resilience, adaptability, and the unwavering commitment to progress. It exemplifies how an organisation can chart its path forward, even in the face of impending change, to emerge stronger, smarter, and ready for whatever the future holds.


Sysco Ireland transformation


Donna Curley, Payroll and Benefits manager at Sysco Ireland, commented on the impact left by BDO’s attention to detail:


“We cannot stress enough how much of an absolute pleasure you are to work with. Nothing is too much trouble; you are so helpful and practical and always on hand to offer advice and best practices. 

We would genuinely be lost without you and very much value your contribution to the Sysco Ireland family! 

I’d just like to pass on a huge thank you from myself and the team for all of your dedication and hard work; it’s very much appreciated and hasn’t gone unnoticed by anyone here within the payroll department.”


Is your organisation being buried in repetitive tasks and manual data entry? Or maybe you’re frustrated with intricate operations, budgetary woes, and incident tracking…  

James-Gaskin-director-bdo-ireland

James Gaskin

Director Management Consulting & Head of Business Transformation, BDO Eaton Square, BDO Dublin
personView bio