Client:

Leading Provider of Broadband Solutions

The Aviana team's expertise with Cognos products and its ability to coordinate with Cognos® (as a Platinum Certified Partner) was a critical factor in the company's decision process. Also, Aviana's reputation of doing implementations on time and on budget was the other factor. Aviana was asked to implement the following products for the project.

 

Report Studio® Reports (For Enterprise wide Reporting using the intranet)

 

Cognos Visualizer® (For Dashboard Reporting)

 

Cognos Powerplay® Enterprise Server (For multidimensional Analysis on the Web)

Cognos Report Studio®, an enterprise reporting product to enable the client and its key personnel to do both standard reports and adhoc reports, utilize Visualizer® in dashboard format to condense large volumes of data or present multiple dimensions at once, and Cognos Powerplay® to analyze information all of this using the company intranet. The Management was thus able to have its pulse on the sales performance of the company on a daily basis and to take corrective and proactive steps to further the company’s sales process and increase efficiency.

The company's top management was unable get the big picture in terms of sales of the company’s products in various regions around the world. The top management needed to know both Demand and Supply risk, and opportunities in different bands (red, blue, green) depending on the successful closing factor. Sales Information by various dimensions such as Region, Customer, Sales office, Distribution Channel down to the sales personnel level was not available before. The information required to provide the big picture was contained in disparate systems, and to bring all this information together from its various systems, the company embarked on a data warehouse project TDW. This included getting information from its various systems such as SAP, Sales System, etc. After the data warehouse TDW was created the company needed a reporting and analytical tool to present this information to the top management. The Cognos suite of products, the industry leader in providing reporting and analysis tools, was chosen.

Aviana enabled the company to implement Cognos tools to build mission critical reports, analytical cubes, and dashboard reports to provide management with a total reporting solution. This enables the management to track, trend and analyze its sales information by various products around it sales offices spread across the globe. Management was able to discern its supply and demand risks, its performance by product groups, product types, sales offices, distribution channels and a host of previously unavailable information to make informed decisions and to gauge the performance of the company.

The Management is now able to make informed decisions with the information available to them. This information is available by means of standard reports, ad-hoc reporting via Report Studio® Reports, Power Play® cubes and dashboard reports with Visualizer®.

The strategic value to the client in terms of better information translates to better decisions. This increases efficiency, reduces cost and has a direct impact to the bottom-line.