Aviana

Our Business Solutions

How would you go from where you are today to where you want to be? Aviana's AVIScope/BI service offering, a BI Project Planning and ROI Assessment Service, can help you design a BI solution that will collect data from all the diverse sources in your organization (financial, sales, inventory) and transform it into valuable business information. AVIScope/BI can also help justify or build a case for the BI initiative by providing an estimate of the ROI. AviScope/BI is a unique assessment methodology used to identify key business drivers, evaluate technical and data architecture and document organizational structure.

The AviScope/BI engagement concentrates on the following critical areas:

  • Requirements Definition - identifies all crucial facets of your BI vision and strategy including the critical success factors and business drivers.
  • Data Source Assessment - identifies the data sources needed to support the requirements identified above.
  • Technical Gap Analysis - compares your BI requirements with your current IT environment and data sources.
  • BI Tools and Database Evaluation - selects the best-practice analytic tool(s) based on your requirements and IT infrastructure.
  • ETL Analysis - determines and documents data movement processes based on the requirements identified and BI tools recommended in preceding steps.
  • Solution Design - design and recommend the best solution for your organization, based on the previous steps outlined above.
  • Business Policy/Process Impact Assessment - review your current business processes and assess how they will be affected by any new functionality or architectural changes that are a part of the proposed solution.
  • Training Assessment - we work with you to determine possible training requirements for end users as well as project team members.

 

We Provide Real Business Solutions


When a manufacturer / distributor of a niche product wanted more insight into its data, it called on Aviana for help. The source ERP had plenty of data, but not a lot of options for reporting. Additionally, the ERP allowed entry in nonstandard formats, leading to "dirty" data.

Aviana implemented a "data cleansing" process that took data in several formats and transformed it into a consistent output. This clean data was then fed to a Data Mart and used to create PowerPlay cubes and several reports.

Following this first phase, the client brought Aviana back for several buildouts of its Data Mart. Among these was the addition of Sales data to Financial and Operational data, a process which required detailed work to keep all data in conformed dimensions so that the client could make meaningful comparisons.

Aviana also performed several upgrades for the client. These included multiple upgrades of Cognos BI and Cognos Finance, and upgrades from SQL Server 2000 to 2005. The client remains satisfied with Aviana’s work and is an ongoing customer.

A Slice of Services Advice

11/11/2009

Live Hands On Workshops

The term Business Intelligence (BI) may sound like an oxymoron to many, however, it actually encompasses a function that must be a vital part of the strategic management arsenal of all companies, especially in these turbulent times. This article attempts to explain why that is so.

Read All Services Advice

Services Related News

10 Mistakes to Avoid When Selecting and Deploying BI Tools

As data warehousing reaches maturity, companies are increasingly focusing on improving access to the data warehouse. While there are generally accepted best practices for designing data warehouses, there are few such standards for selecting and managing business intelligence (BI) tools.

Read All Services News


Latest Business Intelligence Headlines

 
  • Loading...
    Please wait