Embracing Data Warehousing Strategic Play for Optimized Storage and Visibility

Client Background

The client is the second oldest labor union of four North American professional sports leagues established to provide formal representation to players for compensation negotiation and other agreements. The organization represents more than 2,000 active and former players and works to protect their rights and ensure their overall well-being both on and off the field.

• Data Management: The client relied on Dynamics CRM to store player data, contracts, marketing details, and financial data, leading to performance issues for analytics and reporting.
   
• Historical Insights: The client sought historical executive dashboards, reports, and audit logs to gain a 360-degree view for informed decision-making.
   
• Optimization: They needed to optimize data storage, enhance performance, and ensure efficient utilization of resources.

Xoriant Solution | Key Contributions

Xoriant provided a comprehensive solution to the client’s data warehousing needs. They designed and developed ETL pipelines to efficiently move the required data from Dynamics CRM standard, custom entities and log tables to Microsoft Azure. This ensured that the performance for analytics and reporting was optimized.

Xoriant also designed semantic models for BI Reports and Dashboards, providing the client with clear and concise data visualizations. They created analytical reports and drill-down reports using the provided views of the data warehouse. This gave them the ability to gain insights into their data and make data-driven decisions.

To ensure that the data warehouse remained optimized and streamlined, Xoriant installed plugins for data archiving and audit log archiving in CRM. This allowed the data archival plugin to purge records once they had been moved over to Synapse, freeing up valuable storage space. Overall, Xoriant's solution provided the client with an effective and efficient data warehousing solution that allowed them to make informed business decisions.

Business Benefits

As a result of the solution provided by Xoriant, the client achieved the following outcomes:

• Significant Reduction in CRM Storage Space Cost: By moving the data to Azure, the client experienced a notable reduction in CRM storage space cost. This reduction occurred as the data was efficiently transferred to Azure, freeing up storage space within the CRM system.
   
• 90% Empty CRM Storage: The implementation of the solution led to the migration of data to Azure, specifically to Azure Data Lake Storage (ADLS) and Synapse Dedicated SQL Pool. As a result, approximately 90% of the CRM storage was left empty, indicating a successful and effective transfer of data to the Azure environment.

Overall, Xoriant's solution provided the client with an effective and efficient data warehousing solution. The solution optimized performance, allowed for clear and concise data visualizations, and reduced CRM storage space cost significantly. By leveraging Azure and implementing data archiving plugins, the client was able to streamline their data storage and make informed business decisions based on insights gained from the data warehouse.

Technology Stack

Dynamics CRM, Microsoft Azure and Power BI