I have worked exclusively with Idea Integration for the past five years, because unlike other consulting companies I have dealt with, Idea works with me to develop my long-term career and not just deal with the short-term assignment. Many times, I have several assignments to choose from.
- Frank, Idea SAS Consultant
My assignments through Idea Integration have afforded me opportunities to use my skills and learn new ones.
- Sylvester, Idea SAS Consultant
Home > Case Studies
Leading Consumer Retailer
A leading consumer retailer needed a solution developed to integrate, align, and measure multi-channel marketing tools in a real-time environment. Idea SAS was able to design a solution to prioritize needs, consolidate results, and overall improve efficiency for the marketing team.
After initial assessments of disparate data sources (Oracle and Teradata), Idea developed a process for merging these systems for ad hoc analysis to evaluate campaign performance across multi-channels. Idea developed and oversaw triggered email marketing campaign data using SAS and leveraged advanced statistical analysis techniques to evaluate campaign success. Idea further analyzed customer and product behaviors through segmentation to assist business teams in improving customer-centric decision making. The solution included customized dashboards within HBX for business teams and marketing groups that utilized customized segments providing enhanced insights. Idea also extracted data using SAS and SQL to perform ad hoc data analysis to quickly identify key insights for performance indicators identification.
Leading Healthcare Provider
A leading healthcare provider needed to install a system that would make them proactive versus reactive to their data systems. Their immediate need was related to a Member Identification Interaction System which was designed to improve the health of its members by sending health reminders for necessary screening and medication renewals. Idea SAS utilized SAS Data Integration with a custom application built with Enterprise Guide to extract the data and produce the lists more efficiently.
Leading Healthcare Insurance Provider
A leading healthcare insurance provider needed to upgrade the way they communicated with both internal employees and external customers. Idea SAS used the Enterprise BI Server to design and implement a self-service BI portal so that members could receive ad hoc and standard reports. The complete solution included designing and implementing the reporting infrastructure, configuration performance tuning and security.
Leading Financial Firm
A leading financial firm had a need to standardize pricing and portfolio offerings across the business following their recent merger and acquisition. Idea SAS was able to use SAS technology to do analysis and standardize pricing.
Leading Consumer Packaged Goods Company
A leading consumer packaged goods company needed an analytic tool to assist with category management analytics such as shelf space optimization, merchandizing analytics, and planograms. Idea SAS used base SAS technology and Enterprise Miner to do a complete tools assessment, provide implementation and configuration of the new analytic tool and mentor and train on Enterprise Miner.
Leading Financial Firm
A leading financial firm needed assistance re-installing and re-configuring their existing SAS BI Server. Idea SAS provided a solution around this need with the appropriate SAS experts and assisted in adding value to the thier use of existing technology.
Leading Marketing Company
A leading marketing company wanted to increase the efficiency of their marketing campaigns and customer loyalty programs through automation. SAS Idea increased campaign efficiency through the implementation and configuration of SAS Marketing Automation Suite.
Leading Financial Firm
A leading financial firm needed a professional update conversion performed from an older release of SAS to SAS BI. Idea SAS planned and executed the roll-out of the conversion and combined data from multiple sources in the old databases and data warehouses.
Leading Pharmaceutical Company
A leading pharmaceutical company had compliance issues related to FDA guidelines while reporting on clinical trial data. Idea SAS designed a comprehensive solution which allowed them to request reports, graphs, and listings on trials from various clinical studies. Data was extracted from Oracle Clinical databases and manipulated to output to PDF files using ODS through SAS. Idea SAS was also able to assist lead statisticians with patient profiles on multiple studies to meet clinical demands for report submission to the FDA. The solution also included the validation of existing macros and structuring of the databases to meet required CDISC standards.