Analytics Partners LogoOracle Certified Partner

Analytics Partners has a proven data warehouse methodology to deliver a robust/scalable enterprise data warehouse. Our methodology is a reusable process that can be used continually to enhance the enterprise data warehouse as your company expands in new business initiatives. Analytics Partners not only builds enterprise data warehouses from scratch, but works with existing data warehouses and prepackaged data warehouses like Siebel Data Warehouse and Oracle Financials. The following is a high level approach and deliverables that make-up our methodology:
  • Assessment of existing data warehouse
  • Warehouse vision strategy for 1-5-10 years
  • Business Intelligence Strategy (How the business capability will be delivered)
  • Requirements Gathering (JAR/JAD)
  • Logical and Physical Data modeling
  • Design
    • Mapping source attributes to EDW target attributes
    • Mapping EDW target attributes to BI tool repository
    • Dashboard prototypes
    • Mapping BI repository to Dashboard/Reports
  • Build Extract Transform Load (ETL) script
  • Build BI repository
  • Build Dashboard and Reports
  • Testing throughout the project's lifecycle
  • Place quality check points throughout the project's lifecycle
  • Mentoring throughout the project's lifecycle
  • End user training
  • Establish end user adoption program