From Start to Finish
Companies are often faced with the need to upgrade their aging legacy information systems. A major entertainment studio engaged Aviana to assist in upgrading their 10-year old BI environment to the newest version – a major revision written in an entirely new technology.
Although the client's staff received training from the BI vendor and could handle routine conversion, administration and reporting tasks, Aviana provided customized solutions for connectivity, security, rollback and recovery, and event scheduling. Aviana also provided recommendations to create a scalable environment based on a completed capacity planning survey. Before finishing the project, Aviana presented client-specific and customized training to system and server administrators, best practice metadata design to developers, and advanced reporting techniques to end users. The success of the partnership during this engagement led to additional projects that tapped into other areas of Aviana's knowledge and expertise: a "best-shore", cost-effective solution to design and support reporting requirements for a new Employee Benefits and Earnings system based on PeopleSoft HR data, and a project to create a group of reports to analyze global media (e.g. DVD) sales. Real Solutions for the Real WorldThe Difference is Planning
When a theater chain wanted to consolidate data from several disparate systems, it chose Aviana to organize its data. The client had potential data sources from over ten different systems, tracking information such as ticket sales, food sales, film royalties, and employee timecards. The client had a manual "Flash" reporting process that was time consuming, based on manual entry to Excel spreadsheets.
With Aviana's input, the client chose Business Objects as its reporting system and SQL Server as its database. Aviana implemented a Data Warehouse to consolidate the data, including ETL from several different systems. The primary item Aviana generated was a Flash report from the database – automatically loaded from the source systems, automatically generated, available immediately after data load. This was no easy task. The manual spreadsheets had evolved over time and required significant analysis to uncover the business logic behind them. The spreadsheets took input from several different source systems, and each had to be loaded to the data warehouse in a consistent format. Additionally, Aviana created Key Performance Indicator reports, built on data from the data warehouse. And, the Data Warehouse allowed ad-hoc analysis by the client. Case Studies & White PapersA Guide to Successful ProjectsHow do you define project success? Customers typically refer to successful projects as being on time, on budget and to specification, enhancing their business practices and processes, returning specific measures of ROI.
|
Entertainment Related NewsA Guide to Successful ProjectsHow do you define project success? Customers typically refer to successful projects as being on time, on budget and to specification, enhancing their business practices and processes, returning specific measures of ROI. |