Data warehouse: A telecommunications business solution

The telecommunications industry is rapidly becoming the largest user of high volume information systems. This is especially true in the United States, where telecommunications, Internet, video and audio services all fall under the larger umbrella of the information superhighway. Our project team is adept at providing customized business solutions to telecommunications managers by creating specialized information systems to meet their individual needs. We design personalized systems which transcend the traditional boundaries of data warehousing systems by gathering and storing important data, analyzing and transforming the data, and then summarizing and reordering it in accordance with the demands of the user. This provides a dynamic and efficient front-end presentation and reporting tools that transform the users from reactive recipients of hard copy reports to competitive executives poised to make efficient, well informed decisions. This paper will discuss how the power and versatility of the SAS system were used to provide data warehousing business solutions to Pacific Bell, one of the largest telecommunication companies in the United States. It will then demonstrate how millions of data are gathered on a daily basis, stored in tens of on-line tables and then delivered to the user's desk in real time for strategic decision making.