 |
|
 |
|
|
| Cognos ReportNet Implementation for a Broadband Solutions company |
| Client |
Leading Provider of Broadband Solutions |
 |
| Project |
CRN Implementation |
Executive Summary:
The Company is a worldwide leader in semiconductor solutions for broadband communications, enterprise networks and the digital home. The Company is an industry powerhouse that enables the seamless delivery of broadband information between public access networks and the homes and businesses they serve.
Key semiconductor products include digital subscriber line (DSL) and cable modem solutions, home network processors, broadcast video encoders and decoders, digital set-top box components and systems solutions, and the company's foundation dial-up modem business.
The Company also provides a full range of standards-based integrated circuits, software and reference designs for all symmetric and asymmetric DSL CO applications, which have been recognized as the industry's number one copperwire solutions for broadband communications. |
|
| Why Aviana and Cognos? |
| The Aviana team's expertise with Cognos products and its ability to coordinate with Cognos (as a Premium 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. |
 |
Impromptu Web Reports (For Enterprise wide Reporting using the intranet) |
|
Cognos Visualizer (For Dashboard Reporting) |
|
Cognos Powerplay Enterprise Server (For multidimensional Analysis on the Web) |
|
| Cognos Impromptu Web reporting product, an enterprise reporting product to enable the client and it's 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 it's pulse on the sales performance of the company on a daily basis and to take corrective and proactive steps to further the companies sales process and increase efficiency. |
| What Was The Problem? |
| The company's top management was unable get the big picture in terms of sales of the companies products in various regions around the world. The top management needed to know both Demand and Supply risk, opportunities in different bands (red, blue, green) depending on the successful closing factor. Sales Information by various dimensions like Region, Customer, Sales office, Distribution Channel down to the sales personnel level was not available before. The information required providing the big picture was contained in disparate systems and to bring all this information together from its various systems the company embarked on a datawarehouse project TDW. This included getting information from its various systems such as SAP, Sales System, etc. After the datawarehouse TDW was created the company needed a reporting and analytical tool to present this information to the top management. Cognos suite of products, the industry leader in providing reporting and analysis tools was chosen. |
|
| Aviana's Solution |
| 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. |
|
| Benefits to Customer |
Management able to take informed decisions with the information available to them. This information was available by means of standard reports, adhoc reporting via Impromptu Web Reports, Power play cubes and dashboard reports with Visualizer.
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. |
 |
Reduce overall system complexity to control costs. |
|
Increased processing efficiencies with web-based, self-service information availability. |
|
Complex Reports such as the OPTIA report. This is as the name suggests a (one page tells it all) which allows the Management to capture the company's sales performance in a single report. This report tracks the daily billings,backlog, bookings, risks and Opportunities for the Quarter. This was unavailable to the top management previously. |
|
Creation of Powerplay cubes with Time, Products, Location to enable trend analysis, drilldown, drill thru to detail. Etc |
|
Dashboard reporting using Cognos Visualizer to present multiple dimensions at once. |
|
Created Standard reports like Backlog to Shipped, Net Report Billing and Backlog (In Dollars and Units |
|
|
|
|
|
|
|
