Avenues provide the business and technical expertise required to extract key business data from corporate systems and deliver it based on your specific user requirements. We will partner with you to build a solution that allows your organization
to efficiently access, analyze and share information in a consistent format across your enterprise.
Avenues utilizes its project methodology to properly deliver a solution that gives you the capability-building advantages of in-house development, the domain expertise and experience of systems integrators, and the flexibility of high tech experts on demand. We are successful because we work with you to leverage what you have, build what you need, and leave your organization stronger than when we started.
Conducted by the Data Warehouse Architect, this service spells out the architectural components best suited to delivering on the needs identified in the Opportunity Assessment, Business Analysis and Data Assessment services. Architectural components include
the Technology Architecture, Data Architecture, Security Architecture and Data Warehouse Architecture.
The Technology Architecture specifies the technologies to be used, and will be influenced by the company’s existing technology standards, such as intranet/web, client/server, middleware and ETL software, RDBMS software, security software, and hardware.
The Data Architecture specifies which data sources will be used, how they will be accessed by middleware or ETL (Extract Transform Load) software, how they will be loaded to the data warehouse.
The Security Architecture specifies how the security requirements will be met, whether through LDAP (Lightweight Directory Access Protocol) or other method, and how tightly the security will be integrated with the company’s existing security methods.
The Data Warehouse Architecture specifies the structure of the data warehouse and/or data marts, including the handling of metadata. Typically the architecture consists of staging tables for data loading and preparation (Entity-Relationship schema), and production tables (star schema) to house the read-only data which will be made available for analysis. Often this production data will be further distributed to conformed data marts for high-performance access by local applications.
Using requirements gathered in Opportunity Assessment and Business Analysis, the Data Warehouse Architect creates detailed data models for the data warehouse and/or data mart(s) and creates the physical database definitions.
Facts, dimensions, summaries, indexes, loading tables, staging tables and public tables are defined. Sizing estimates are refined. Database ids and security are implemented.
The Data Warehouse Architect works with your company’s Database Administrator (DBA) throughout this process to ensure compatibility with corporate standards and to ensure the DBA will be comfortable supporting the databases into the future.
This service is delivered by an ETL Specialist with assistance from IT and user staff who are very familiar with the data sources and the business rules.
The ETL products are configured to deliver the data from the legacy sources to the data warehouse environment.
Wherever possible, the ETL rules will be stored in a single repository for consistency of definition and ease of maintenance. This is best accomplished with an ETL software tool. In some cases, it may be necessary to use custom business logic, that should be implemented as Stored Procedures and Triggers in the RDBMS. As a last resort, unique requirements may have to be met using a programming language such as C++.
This service can be targeted at producing a new Data Warehouse (DW) strategy or for working within your company’s existing DW strategy. Both business and IT management will be interviewed by the Data Warehouse Architect to develop a well-grounded strategy for the long-term and short-term. We assess your data warehouse and business intelligence needs. Then we develop a prioritized, high level plan on how to reach your goals.
Working from the results of the Opportunity Assessment, and using the Data Warehouse Strategy as a framework, the Senior Business Analyst identifies the detailed requirements for the solution.
The Senior Business Analyst works with end users to capture their intended use of the information for business growth, determine what information they need to see, and how they need to see it:
Based on findings from the Business Analysis service, the Data Warehouse Architect works with the company’s Data Administrator to determine the data sources that are required to support the business needs, and the quality of the
data in those sources.
Sources may be internal or external. Internal data sources typically belong to the company and reside in operational databases such as an order processing database. External data sources may be acquired from outside the organization, and often are used for demographic analyses or database marketing.
If similar data exists in more than one source, we work with the Data Administrator and business user to determine the single authoritative source.
We will recommend solutions for addressing data quality issues. It is imperative that the best quality data be used to drive your analytics.
Data quality improvement may involve one-time and ongoing activities such as removing duplicates, standardizing names and addresses, deriving implied values, and improving data validation or logic in the operational system which generates the data.