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 interview to determine the expectations of your data warehouse. We work together to determine:
    • reporting requirements
    • current report processes
    • sources
    • transformations
    • mappings
    • manual corrections
    • and more.

    Next is understanding your current IT landscape, what applications can provide what data, and what the interface options are.
  • 02 - Analyze

    Analyze the data sources We analyze all your data sources in detail. We then recognize the data process flow and any pitfalls 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 Data Platform cleans, validates, and even disqualifies your data flow on an ongoing basis. We model the ideal structure of your KPIs and map the existing data exports to it.
  • 03 - Implement

    Setup and configure the data platform We have various ways of extracting the data from your local business applications. It ranges from custom API programming to uploading existing business spreadsheets to entering data manually via a structured data-entry form - and much 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 a user-friendly, drag-and-drop web application.

    With our integrated, off-the-shelf software solution:
    • Mapping tables are migrated to our self-service MDM tool.
    • Data transforms to our ETL processor.
    • Reminders are sent out 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. Whether you have no data, LDAP, or any other directory server, we’ll base our single sign-on authentication on what works best for you.

    From defining the domains to dimensions to connecting systems, it is a well-defined MDM process we create with you.
  • 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.
  • 05 - Train

    On-site & hand-over After finishing the setup process and dry runs, we close off the initial phase by training your business users or IT staff in the user-friendly Cohelion Data Platform. We also hand over the tailor-made manual then instruct on maintaining the Master Data Management system and our platform. If you want to make use of self-service business intelligence (like PowerBI), we can provide training in that or prepare some initial reports and dashboards for you.
  • 06 - Ongoing support

    Help desk & updates With an up and running data platform, we continue to improve the platform and support the users in your organization.
  • Identify your reporting & analytic requirements Our onboarding process starts with an intake interview to determine the expectations of your data warehouse. We work together to determine:
    • reporting requirements
    • current report processes
    • sources
    • transformations
    • mappings
    • manual corrections
    • and more.

    Next is understanding your current IT landscape, what applications can provide what data, and what the interface options are.
  • Analyze the data sources We analyze all your data sources in detail. We then recognize the data process flow and any pitfalls 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 Data Platform cleans, validates, and even disqualifies your data flow on an ongoing basis. We model the ideal structure of your KPIs and map the existing data exports to it.
  • Setup and configure the data platform We have various ways of extracting the data from your local business applications. It ranges from custom API programming to uploading existing business spreadsheets to entering data manually via a structured data-entry form - and much 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 a user-friendly, drag-and-drop web application.

    With our integrated, off-the-shelf software solution:
    • Mapping tables are migrated to our self-service MDM tool.
    • Data transforms to our ETL processor.
    • Reminders are sent out 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. Whether you have no data, LDAP, or any other directory server, we’ll base our single sign-on authentication on what works best for you.

    From defining the domains to dimensions to connecting systems, it is a well-defined MDM process we create with you.
  • 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.
  • On-site & hand-over After finishing the setup process and dry runs, we close off the initial phase by training your business users or IT staff in the user-friendly Cohelion Data Platform. We also hand over the tailor-made manual then instruct on maintaining the Master Data Management system and our platform. If you want to make use of self-service business intelligence (like PowerBI), we can provide training in that or prepare some initial reports and dashboards for you.
  • Help desk & updates With an up and running data platform, we continue to improve the platform and support the users in your organization.

Interested?

Get in touch
Contact