Make Better Decisions, Faster!

Communications/Utilities

LARGE NATIONAL TELECOMMUNICATIONS COMPANY

Project Synopsis

SAS Forecasting Server Implementation

The client had a mostly manual and very labour intensive forecasting process that was prone to delays and errors. Different departments used their own processes and standards to produce the forecasts with varying level of details. Some departments had more experience and better resources in place to produce these forecasts; therefore, they were able to produce more reliable forecasts in a reasonable time. Departments with fewer resources were not as successful in producing accurate forecast in a timely manner. This discrepancy in the forecasts prevented the organization to have a holistic view of the future revenue and demand. Any refactoring due to abrupt changes in the economic landscape or alternate modeling of the forecasting scenarios was not possible due to the labour intensive forecasting process.

Solution

Denologix was assigned to implement the SAS Forecasting Server in September 2010. Denologix proposed to setup a SAS Enterprise Business Intelligence environment alongside the SAS Forecasting Server SAS Forecasting Server for executing analytical reports and ad-hoc queries to prepare the data to be processed through the Forecasting server, and present results of the forecasting model executions via web reporting interface. The steps undertaken to implement this project successfully are as follows:

  • Hardware capacity planning for the implementation of the SAS Forecasting Server and Enterprise Business Intelligence platform
  • Planned security architecture for role based security to ensure proper data governance
  • Installed and configured SAS Forecasting Server and Enterprise Business Intelligence platform
  • Configured data sources that provided data for forecasting and analytical purposes
  • Configured business rules to clean, standardize and transform the data
  • Define metadata for all data attributes within the SAS Forecasting and Enterprise Business Intelligence platform
  • Configured data security rules to ensure access by authorized users only
  • Provided training for the forecasting analysts to setup and execute various models
  • Assisted forecasting modellers during the preparation and the execution of the models
  • After the first year after the implementation, the forecasting process was automated and consistent within the organization

Technology

  • SAS Forecast Server,
  • SAS Enterprise Miner
  • SAS Data Flux Server
  • SAS EBI
  • SAS SPDS
Back

what clients are saying

  • Canadian Bank - Data Analytics Regulatory Project

    Their ability to understand customer needs is quite special. Denologix was very good at listening to us and coming up with solutions, which they were able to sell to our own internal clients easily.

    Director, Major Canadian Bank

  • Insurance Company SAS Implementation and Migration

    Their team is very honest. Their leaders are very transparent and open. Partnership like this, you don’t find anywhere. I met very few vendors that I could say that I trusted. This vendor is amazing. I am happy I chose Denologix and would do it again.

    Sr. Manager, Global Insurance Provider

  • Major Bank Regulatory Data Analytics Project

    Terrific. Denologix has a fantastic reputation with our business in terms of being flexible. They are very rapid in acquiring new capabilities. They have established strong customer relationships and relationships with internal SAS departments. I have nothing but good things to say about them.

    Vice President, Alliances Business Development

Read More