Broad Coverage of Pre-Built Business Intelligence Content for major ERP, SCM, CRM applications
Data warehouse projects are complex and demand a variety of skills to build and maintain. The upfront work: gathering reporting requirements, defining data models, and creating the metadata that catalogs the content of the data warehouse is a huge undertaking. It’s not uncommon for users to have difficulty articulating their reporting needs, so just getting a project off the ground can be a hurdle.
One of the most technically challenging and labor intensive parts of a custom data warehouse project is writing the data extraction, transformation, and loading integration code — mapping tens of thousands of columns from various source systems into the data warehouse. The integration architecture should be able to not only load historical data, but also efficiently identify changes and deletions to quickly update the data warehouse on a timely basis.
While many reports may only need data that is current as of last night, an operational data store may be necessary to address near real-time reporting requirements to avoid bogging down the transaction system.
Integrating a custom data warehouse with an organization’s BI platform involves the time-consuming process of defining the semantic layer metadata that enables users to build reports and dashboards.
Keeping up with changes to the database structures in the source systems introduced by application patches and upgrades is often overlooked in the resource planning phase of a project, but can require significant ongoing development effort. This is perhaps the single largest source of ongoing cost savings from using a packaged data warehouse offering like Analytecs
Analytecs can speed time to value while dramatically lowering costs and risks associated with custom development projects. Analytecs can do this by providing pre-built data models, integration maps, automated semantic layer metadata generation, and dashboard and report templates.
As you evaluate a buy versus build decision or even when comparing packaged alternatives, get answers to these key questions:
- Does the vendor offer pre-built solutions for the ERP, CRM, SCM applications we are using? (Section 3 link)
- What is the vendor’s strategy for performing incremental updates?
- Can incremental updates be performed multiple times per day?
- Does the vendor support our existing or future BI platform(s)?
- What is the total cost of acquiring, implementing, and maintaining the packaged solution, including prerequisite software and hardware components?