Data Warehouse Consulting

Intertech offers data warehouse consulting.  Our experts help you:

• Understand data warehouse, OLAP, and BI architecture, infrastructure, and metadata
• Implement data warehouse security
• Select products, install, configure, and secure the system
• Understand and use metadata, dimensional modeling, and the enterprise data warehouse bus architecture
• Leverage the multi-dimensional modeling process
• Create standards for your data warehouse
• Develop the physical data model, design processing stores, and create an index plan
• Design the OLAP database including aggregations and database instance
• Understand extracting data and cleaning and conforming data
• Deliver data for presentation
• Manage the ETL environment including developing a ETL plan, one-time historic load processing, and incremental ETL processing
• Use Business Intelligence (BI) applications, create a BI cycle, and setup a BI portal
• Implement BI resource planning specification, development, and maintenance
• Create data warehouse documentation
• Deliver data warehouse training from coverage of the fundamentals to standards at your organization
• Perform a data warehouse security audit
• Troubleshoot performance issues