The Challenge
A major market research group relied on SAS analytics to generate reports for their partners.
Their goals were as follows:
- Upgrade to open-source analytics running in a cloud-based Databricks environment.
- Gain more flexibility & capabilities with the R model
- Save a significant amount of money on licencing pricing
The existing SAS code pulled large point-of-sale and consumer survey data from cloud-based data sources and summarized various metrics and projections across product groupings and customer demographics using DATA steps and SQL commands. Aggregated results are published and shared with their clients to facilitate business planning.
ProCogia provided decades of cumulative experience working between SAS and R to engineer a migration strategy that guaranteed a precise and maintainable codebase to optimize their business needs and maintain process continuity. Our team successfully migrated existing SAS processes into self-contained modules which are designed to be portable across analytic environments and including quality control of the results and continuous integration strategies.
Procogia’s Approach
- Deployed a team with extensive expertise in SAS and R. Our North American staff were embedded with the client to stay abreast of requirements and incorporate feedback while our team lead managed ProCogia developers based in our global delivery centres (India/Ireland)
- We developed a set of libraries for all code development. These libraries facilitated local code development that could be efficiently scaled to a larger production environment
- Developed automated testing protocols and code reviews ensuring that migrated code produced results that exactly matched original SAS processes without any loss of quality or efficiency
- Managed and maintained written documentation of migration details for delivery team
- Seamlessly integrated development process within client’s existing Agile project management framework.
The Results
- Global delivery team provided round the clock code development to meet all deadlines ahead of schedule
- The final open-source code base is scalable across the latest in big-data analytic platforms and developed with futureproofing and portability as a specification.
- R processes optimized for use on a Spark cluster using an Azure-based Databricks environment
- Automatic testing integrated into CI/CD processes for long term maintenance ensuring a reliable codebase over the long term
- Client can eliminate their reliance on SAS and its associated licensing costs
- Data analysts and content experts now have access to the latest in analytic technology, enabling them to incorporate the latest data science tools for making market insights to better serve their customers.
Services Used
Data Operations
We build a robust, scalable, and enterprising codebase that enhance reporting and analytic processes.
Migration Consultancy
We provide expertise to organizations seeking to migrate from expensive proprietary data analytics into scalable open-source solutions that make use of the latest technology and methods. Our team provides specialists in data reporting and statistical modeling to reproduce all existing services provided by SAS.
Related Blogs
Let’s Connect
What can we help you with?
T: +1 425-624-7532
Alternatively, simply fill in this form and we’ll be in touch.