BI Consulting - Data Warehousing - Open Source BI - Pentaho Partner

Technology Partners

Data Warehouse Jumpstart

The following service can help address the following customer issues:

  • Do you have a very large data warehouse that you need to build with several gigabytes to terabytes size of data?
  • Are large processing loads and integration tasks required to be run repeatedly without fail? Is performance (time to load) a critical factor in data warehouse reports?
  • Do you require experienced expertise to help design the data warehouse infrastructure, schema or ETL transformations?
  • Are you looking to leverage open source in your project to reduce costs and use the latest cutting edge technology?


BrainChild's business intelligence consultants can help you with your data warehouse solution.
Learn more about BrainChild's BI consultants

BrainChild's BI consultants will work hand in hand with customers who purchase this service to:

  • Fundamental data warehouse guidance
    • Schema design
    • Database selection, methods of storage access
    • Scalability & Avaibility
    • Infrastructure design
  • Install, configure and administer an Oracle, Postgres, MySQL or InfoBright database for data warehouse implementation
  • Deliver a data model based on analysis of reporting and usage requirements, architecture included
  • Provide an initial ETL data load from existing customer source data
  • Provide an initial performance benchmark on the schema and queries intended to run on the platform
  • Create a recommended backup and recovery plan for the customer, including hardware and software recommendations
  • Create working source data extracts as foundation for ETL transformations


BrainChild Consultants have extensive experience with Data Warehouse systems and can provide expertise on the following subjects:

  • OLAP (Online Analytical Processing), specifically ROLAP technologies
  • Dimension modelling, de-normalized schemas
  • Using additional open source components to enhance the capability of the data warehouse
  • Migrating/extracting from non-relational data sources such as EDI, XML and proprietary formats (binary, sensors, real-time streaming)
  • Query optimization, reducing table scans, efficient index creation
  • Aggregate/Materialized Views


Deliverables:

  • ETL loads
  • System Architecture, including hardware, software and connectivity
  • Documented benchmark and performance results
  • Optimized set of initial queries and POC reports
  • Complete data warehouse schema
  • Backup & Recovery plan
  • Proposed data warehouse project plan including timelines


Benefits

  • Reduce data warehouse implementation time by eliminating trial & error and going with best practices from day 1
  • Build from an optimized schema vs. continually revising a non-optimal schema over time
  • Ensure that the data warehouse functions on day 1, and is available to scale to the terabyte level in the future


Duration

  • Minimum 10 days
  • On-site at customer location. Remote access will be required.

Pricing
Learn more about our pricing.

How to buy
If you're interested to purchase this service, please contact us.

Home Business Intelligence Data Warehouse Design