We can analyse your requirements. Using rigorous definitions will provide a good foundation for reporting on those facts and figures you need to drive your crucial business decisions. Included is a plan to approach the task of turning the data in your company into actionable information.
A 1-day course on “What is a datawarehouse” is available on request. This course gives you an insight in the do’s and don’ts of organizing your data in a data warehouse. Ranging from the history of data warehousing to architecture of a general datawarehouse solution. The course is aimed at people with at least a general knowledge or background in IT.
For in-company courses on data modelling, or other topics of interest, please call us for a discussion and a quote. Our fees are competitive. If we do not have the expertise, we can refer you to one of our partners.
We maintain wikipedia pages on several data modelling methods. We have a large amount of experience with and/or good knowledge of Data Vault (certified), Anchor and Dimensional Modelling, as well as standard database modelling for applications.
Architecture and design
Standard design patterns and data warehouse automation are part of our architecture. Keywords: loose coupling, resilient, restartable, data-driven.
Best practices: ITIL, Prince2, Agile Development practices
In our work we use standard best practices such as ITIL, Prince 2 and Agile development practices, where applicable and desired.
We can work with any ETL-tool, but have the most experience with Oracle Warehouse Builder and SAP Business Objects Data Integrator.
We are certified on Cognos BI-tools, up to Cognos 8.4. Other tools will take a few days to pick up. This qualifies you for a discount on our fee.
We have experience working in a validated (pharmaceutical) environment.