Case Studies  

SAS to Power BI: Legacy Migration Facilitating Modern BI

Kanon Cozad - Director of CIO Advisory Services

06 May 2022

The challenge is this trucking company being tasked with migrating a significant installation of SAS-based information reporting routines to a more modern and flexible framework, both for ETL and for end-user reporting. Additionally, they are in the early phases of a major cloud-infrastructure migration

CLIENT SUCCESS STORY

Company Highlights

Region: USA

Sector: Industrials

Industry: Transportation/Road & Rail Ops.

Division: Information Technology

Solution Technologies: Microsoft 

Solution Products: SSIS, ADF, Power BI

Solution Service Type: Project

 

I N T R O D U C T I O N

This client success story explains how a nationwide LTL (“Less Than Load”) trucking company engaged Pomerol Partners to design a framework to facilitate this complex migration, and to design new end-user toolsets using Power BI.

 

C H A L L E N G E

The challenge is this trucking company being tasked with migrating a significant installation of SAS-based information reporting routines to a more modern and flexible framework, both for ETL and for end-user reporting. Additionally, they are in the early phases of a major cloud-infrastructure migration. This multi-migration environment has the potential for the perfect storm and the company needed BI professionals to be able to consult them through it appropriately, as it was outside their scope of expertise.

 

S O L U T I O N

  • Pomerol designed a new set of processes to populate first populate data structures in a newly created data mart (which the client then brings into its data warehouse), with emphasis on data validation to validate data consistency with the legacy SAS processes.
  • Pomerol then worked with the client end-users to design useful and meaningful analytical dashboards using Power BI, while also replicating the existing reporting formats to build comfort for the users.
  • Pomerol is working hand-in-hand with Microsoft to ensure all new processes and technical solution can be migrated to Azure with minimal extra lifting when the time is right for that move. Microsoft is also actively engaged to help facilitate that migration.

 

R E S U L T

Our client views the initial Proof of Concept of these end-to-end mechanisms as a rousing success and is working with Pomerol to scope the migration of all SAS processes currently in Production on their mainframe.

 

A B O U T  P O M E R O L

Pomerol Partners creates and delivers meaningful data-driven business solutions and services. We’ve been operating in Data Analytics and Intelligence Reporting for over 9 years and our Partners have a cumulative 100 years in global experience. In 2013, Pomerol spun out of Deutsche Bank after a range of successful BI projects were delivered saving the bank over $3m. Ever since then we’ve been partnering with our clients (executives, managers, analysts, etc.) across all business verticals to optimize the intersect between changing business demands, technological progress and sustainable business growth.

Our consultants have helped hundreds of organizations, of all sizes and in all industries worldwide, make money. How do we do this? Leveraging your data to increase revenue, automate processes, decrease costs and understand your insights. Pomerol delivers value that helps you grow and change with better data-driven decisions and solutions that empower you as a Gold Data Platform, Silver Data Analytics and Silver Cloud Platform Microsoft Partner. Our professional consultants, that reside in three countries (United States, United Kingdom and Portugal), are experts that will partner with you for the technical as well as business-oriented solutions. Working with the same team in all capacities ensures you always know where we stand with our work and commitment to you. Our network of data experts delivers solutions throughout the entire Microsoft data analytics stack including the Power Platform (Power BI, Power Apps, Power Automate), Azure Synapse Analytics, Azure Data Factory and many more.

 

We can help your business get up to speed with Power BI with our comprehensive training program https://pomerolpartners.com/power-bi-training

 

 


MORE INSIGHT