As a pioneer of low cost phone calls using subscribers' PCs and the internet as a transport mechanism, CallServe are at the very forefront of telephony technology. Believing in leading edge technology, they had implemented a datawarehouse based upon Microsoft SQL Server and Microsoft Analysis Services.
Having seen the business benefits brought by business intelligence, CallServe wanted to improve the data extraction, transformation and loading times of their datawarehouse as well as get expert opinion on enhancing the performance and flexibility of their existing database and cube design.
CallServe turned to their regular IT service provider, Sentient Ltd who engaged DataSurge to provide the in-depth knowledge essential to the assignment.
DataSurge provided consulting detailing improvements to be made through load parallelisation, table redesign, index optimisation and cube redesign including partitioning.
CallServe were delighted with the consultation and Sentient are looking forward to further collaboration with DataSurge in the near future.