Origin of Cohelion: The action of process of multiple independent parts to become aligned around a central theme. Used in Astronomy and in Information Theory

Implementation

Integrating data from all your IT applications can sound like a scary process, luckily for our consultants it is daily business. With our unique approach and standardized data platform we make data integration and data management easy and more fun.

Here’s how to start your data integration project with our six step implementation approach. Let’s start the journey in order to get the most our of your data.

Six step process

  • 01 - Intake

    Identify your reporting & analytic requirements Our onboarding process starts with an intake to determine the expectations of your data warehouse. We determine the reporting requirements, how you currently get to your reports, all the way from sources, transformations, mappings and manual corrections. Next is understanding your current IT landscape, what applications can provide what data and what are the interface options.
  • 02 - Analyze

    Analyze the data sources We analyze your data sources in detail and with our experience, we recognize the common data process flow and the many pitfalls (in order) to reach data of the highest quality. Most importantly we understand that "Garbage-in = garbage-out" is not an excuse for poor quality reports. Our business logic cleans, validates and even disqualifies your dataflow on an ongoing basis. We model the ideal structure of your KPIs, and map the existing data-exports to it.
  • 03 - Implementation

    Setup and configuration of the Data Platform We have various ways of extracting the data from your local IT applications, ranging from custom API programming to uploading existing business spreadsheets to entering data manually via a structured data-entry form. And many options in between. After the ETL processes have initially been set up by us, your business users can manage and monitor it. Lock dates, de-duplication rules, merges etc. can be managed from an easy to understand web-application. With our integrated off-the-shelf software solution: 1. Mapping tables are migrated to our self-service Master Data Management (MDM) tool. 2. Data-transformation to our ETL (Extract Transform Load) processor 3. Reminders are sent our automatically based on predetermined lock date definitions. Within Cohelion your users can see the result of these steps in full detail. If needed corrections can be made to it. If there is no data-set that we can import, then these data-entry screens can be used to enter or upload the data. Do you have LDAP or another Active Directory server? Great, we'll base our single sign-on authentication on that. We'll set up Master Data Management together with you. Define the domains, dimensions, attributes and connecting systems is a well-defined process. Left for you to do is follow up any mapping conflicts in a simple drag-and-drop interface.
  • 04 - Validate

    Test and dry runs Once all your data sources are connected, mapped and consolidated, it's time to validate the output. After keeping track of all slowly changing dimensions you'll see a whole new level of detail in your data. Typically your data quality is already as good or better than you were used to.
  • 05 - Train

    On-site & hand-over After finishing the setup process and dry runs, we'd like to close off the initial phase: we will train your business users or IT staff in the user friendly Cohelion Data Platform, hand over the tailor made manual, instructions on maintaining Master Data Management and the administration. If you want to make use of self service BI (like PowerBI), we can provide training in that or prepare some initial reports and dashboards for you.
  • 06 - Ongoing support

    Helpdesk & improvements With an up and running Data Platform we continue to improve and support the Data Platform users in your organization. After finishing the setup process, we'd like to close off the initial phase: hand over the tailor made manual, instructions on maintaining MDM and PM administration. If you want to make use of self service BI (like PowerBI), we can provide training in that or prepare some initial reports and dashboards for you.
  • Identify your reporting & analytic requirements Our onboarding process starts with an intake to determine the expectations of your data warehouse. We determine the reporting requirements, how you currently get to your reports, all the way from sources, transformations, mappings and manual corrections. Next is understanding your current IT landscape, what applications can provide what data and what are the interface options.
  • Analyze the data sources We analyze your data sources in detail and with our experience, we recognize the common data process flow and the many pitfalls (in order) to reach data of the highest quality. Most importantly we understand that "Garbage-in = garbage-out" is not an excuse for poor quality reports. Our business logic cleans, validates and even disqualifies your dataflow on an ongoing basis. We model the ideal structure of your KPIs, and map the existing data-exports to it.
  • Setup and configuration of the Data Platform We have various ways of extracting the data from your local IT applications, ranging from custom API programming to uploading existing business spreadsheets to entering data manually via a structured data-entry form. And many options in between. After the ETL processes have initially been set up by us, your business users can manage and monitor it. Lock dates, de-duplication rules, merges etc. can be managed from an easy to understand web-application. With our integrated off-the-shelf software solution: 1. Mapping tables are migrated to our self-service Master Data Management (MDM) tool. 2. Data-transformation to our ETL (Extract Transform Load) processor 3. Reminders are sent our automatically based on predetermined lock date definitions. Within Cohelion your users can see the result of these steps in full detail. If needed corrections can be made to it. If there is no data-set that we can import, then these data-entry screens can be used to enter or upload the data. Do you have LDAP or another Active Directory server? Great, we'll base our single sign-on authentication on that. We'll set up Master Data Management together with you. Define the domains, dimensions, attributes and connecting systems is a well-defined process. Left for you to do is follow up any mapping conflicts in a simple drag-and-drop interface.
  • Test and dry runs Once all your data sources are connected, mapped and consolidated, it's time to validate the output. After keeping track of all slowly changing dimensions you'll see a whole new level of detail in your data. Typically your data quality is already as good or better than you were used to.
  • On-site & hand-over After finishing the setup process and dry runs, we'd like to close off the initial phase: we will train your business users or IT staff in the user friendly Cohelion Data Platform, hand over the tailor made manual, instructions on maintaining Master Data Management and the administration. If you want to make use of self service BI (like PowerBI), we can provide training in that or prepare some initial reports and dashboards for you.
  • Helpdesk & improvements With an up and running Data Platform we continue to improve and support the Data Platform users in your organization. After finishing the setup process, we'd like to close off the initial phase: hand over the tailor made manual, instructions on maintaining MDM and PM administration. If you want to make use of self service BI (like PowerBI), we can provide training in that or prepare some initial reports and dashboards for you.

Interested?

Get in touch
Contact