Client Overview
Our client is an American Company and one of the world’s largest producers and marketers of tobacco, cigarettes, and other related products. It has a worldwide distribution network, with its headquarters in the US.
Business Objective
The client needed a better suited cloud platform for their business demands as Teradata lagged in performance, cost, cost, and features as compared to Microsoft Azure
The Solution
- TekLink designed an Azure Data Lake store and leveraged our Client’s Azure Databricks using Spark data frames to migrate initial data set into the Azure Data Lake Store. By doing this, we leveraged Spark’s fast data frames with parallel processing and distributed computing.
- Once the data was transformed and converted into the required format for reporting, the team loaded the filtered data into our Client’s Azure Data Lake Store. These files were then analyzed in Power BI making a direct query from Azure’s Data Lake Store.
- TekLink’s Global Delivery Center was leveraged to reduce the cost of migration and for continued sustainment of analytics applications.
Key Project Benefits
The project achieved its goals and exceed the performance expectations of our Client.
- Processing time for Azure’s Load and Transform activities is reduced to a fraction of earlier run-times in Teradata.
- The complexity of the system was decreased significantly from the original Teradata model.
- Leveraging Databricks’ pay-as-you-go service, our Client minimized their overall processing cost as compared to Teradata.