Data modeling
We are continually amazed at the number data integration methodologies and projects that have and are conducted without proper, and in many cases, no data modeling. Many times this occurs as projects are staffed with technical resources that lack data modeling experience, or even worse, no business background. Our process starts with comprehensive logical business modeling that helps uncover the entities, attributes relationships and business rules that are critical to your organization. We then develop a physical data model that becomes the basis for your data warehouse architecture.
Data Warehousing/Real-time and Batch Data Integration (EII, ETL, EAI)
Every organization has different requirements when it comes to data integration. In the past, and sometimes today, data warehousing was pitched as the silver bullet for all data integration challenges. Unfortunately, many projects failed as organizations discovered that they had operational or tactical reporting and analysis requirements but the data warehouse architecture implemented only delivered strategic data. We embrace not only batch oriented integration, but real-time technologies as well such as enterprise information integration (EII) and enterprise application integration (EAI) to ensure that the architecture implemented meets all your reporting and analysis requirements. We also utilize data profiling, data quality and metadata tools to ensure that the data is not only accurate, but contains the context necessary to turn data into information.