CASE
STUDY

Note: Make sure to add Page Categories to show this on the case study hub

Approach

The approach involved 2 phases across people, processes and technology. The first phase involved gaining a deep understanding of current state inefficiencies by mapping processes and then defining priorities and key success metrics. The second phase involved defining the ‘to be’ state before exploring solution options for systems configuration and rollout.

Phase 1: – current state blueprinting
  • Visualise current workflow – map out existing processes to provide a clear visual representation
  • Visualise current workflow – map out existing processes to provide a clear visual representation
  • Visualise current workflow – map out existing processes to provide a clear visual representation
  • Visualise current workflow – map out existing processes to provide a clear visual representation
  • Visualise current workflow – map out existing processes to provide a clear visual representation
Phase 1: – current state blueprinting
  • Visualise current workflow – map out existing processes to provide a clear visual representation
  • Visualise current workflow – map out existing processes to provide a clear visual representation
  • Visualise current workflow – map out existing processes to provide a clear visual representation
  • Visualise current workflow – map out existing processes to provide a clear visual representation
  • Visualise current workflow – map out existing processes to provide a clear visual representation

Outcomes

Overall the firm was able to evolve its information and communication technology, optimise systems, streamline and automate law firm processes to achieve operational excellence and stay competitive in the market.

  • Benefits Realisation from technology investments in document management and practice management systems by reconfiguring technology platforms and removing redundancy in technology processes
  • Benefits Realisation from technology investments in document management and practice management systems by reconfiguring technology platforms and removing redundancy in technology processes
  • Benefits Realisation from technology investments in document management and practice management systems by reconfiguring technology platforms and removing redundancy in technology processes

Overview

A prominent Australian not for profit organization was leveraging Dynamics 365 to manage its extensive customer engagement activities.

Over time, data from various campaigns and donor initiatives grew to over 600 GB, complicating management, reducing efficiency, and increasing operational costs. With an upcoming change in the discounting regime for not-for-profits using Dynamics 365, Ignite’ s client needed to review its data storage practices, particularly as managing the Principal Objects Access (POA) table had become increasingly challenging. Ignite’s solution was to offer an out-of-the-box solution for adatabase cleanup, which involved resetting obsolete database
tables within the POA table without compromising Microsoft warranties related to the licence. In turn, the reduction of data storage from the POA table then facilitated an easier data migration to an Azure Data Lake enabled further cost savings to be achieved for the client.

The Customer’s Challenges

The organization’s Principal Objects Access (POA) table had grown to 53 million rows, consuming over 123 GB, which significantly increased storage requirements and costs. This data bloat not only added financial strain but also degraded system performance, affecting donor management and engagement. The POA table’s size increased due to entries from direct shares and cascade parental relationship behaviours.

As an internal security table, the POA could not be cleaned up directly. Also more significantly, traditional methods of data management often rely on generic cleanup jobs that do not adequately address the specific needs of organizations using Microsoft Dynamics 365.

As an internal security table, the POA could not be cleaned up directly. Also more significantly, traditional methods of data management often rely on generic cleanup jobs that do not adequately address the specific needs of organizations using Microsoft Dynamics 365.

As an internal security table, the POA could not be cleaned up directly. Also more significantly, traditional methods of data management often rely on generic cleanup jobs that do not adequately address the specific needs of organizations using Microsoft Dynamics 365.

Solution

A tailored approach that involves in-depth analysis and targeted cleanup strategies can significantly enhance database performance.

Ignite executed a meticulous cleanup and optimization of the Dynamics 365 environment, specifically targeting the relationships within the POA table. By refining entity associations and removing redundant access IDs, Ignite streamlined data storage, significantly reducing unnecessary data accumulation.

Ignite performed a thorough cleanup and optimization of the Dynamics 365 environment, focusing on the POA table relationships. They refined entity associations and removed redundant access IDs, which streamlined data storage and reduced unnecessary data accumulation.

Key features of their approach included:

Identifying targets for cleanup, particularly filtering records by custom entities

Identifying targets for cleanup, particularly filtering records by custom entities

Identifying targets for cleanup, particularly filtering records by custom entities

Identifying targets for cleanup, particularly filtering records by custom entities

Identifying targets for cleanup, particularly filtering records by custom entities

Outcomes

  • Substantial savings on storage costs by decreasing the size of the POA table from 122GB to approx. 38-53 GB.
  • Increased data quality management enabling a more seamless migration of data to an Azure Datalake leading to further savings.
  • Enhanced database performance achieved by reducing lag times.

By adopting a more tailored approach and focusing on specific areas, such as the POA table and other critical data structures in Dynamics 365 environments, organisations can streamline their operations and reduce reliance on expensive storage solutions.

Ignite’s expertise in delivering small-scale targeted initiatives within Microsoft Dynamics 365 environments can result in significant operational efficiencies and cost savings. For organisations of all sizes.

Solution

Ignite delivered a comprehensive managed services solution tailored to the client’s specific needs which included:

  • IMACD Rollout: end-user computing (EUC) services, including the deployment, maintenance and secure disposal of assets and managing the lifecycle of point of sale systems, registers, desktops and laptops at scale and in a very flexible manner
  • IMACD Rollout: end-user computing (EUC) services, including the deployment, maintenance and secure disposal of assets and managing the lifecycle of point of sale systems, registers, desktops and laptops at scale and in a very flexible manner
  • IMACD Rollout: end-user computing (EUC) services, including the deployment, maintenance and secure disposal of assets and managing the lifecycle of point of sale systems, registers, desktops and laptops at scale and in a very flexible manner

Outcomes

The client saw a marked improvement in their store operations, allowing them to focus more on their core business and less on IT-related issues. As a result, customer satisfaction levels rose, and the internal IT team experienced a reduction in workload and stress.  Specific benefits included:

Identifying targets for cleanup, particularly filtering records by custom entities

Identifying targets for cleanup, particularly filtering records by custom entities

Identifying targets for cleanup, particularly filtering records by custom entities

Identifying targets for cleanup, particularly filtering records by custom entities

Identifying targets for cleanup, particularly filtering records by custom entities

Connect with Ignite today.

    Contact Information