Data Administrator
This learning path is designed for Data Administrators who are responsible for onboarding data into CryspIQ®, applying governance controls and ensuring enterprise data is prepared correctly for business consumption.
Data Administrators play a critical role in the CryspIQ® methodology by transforming raw source data into trusted, governed enterprise information.
As a Data Administrator, you:
- Are a registered user within Microsoft Entra ID.
- Configure and manage source data onboarding.
- Create and maintain Source Messages.
- Build and manage Message Maps.
- Apply business context to data.
- Configure data security.
- Manage data quality rules and validation.
- Monitor operational processing.
- Support Natural Language Query through Semantic Context.
- Work closely with Data Stewards to ensure data governance requirements are met.
Start Here
Before configuring data within CryspIQ®, we recommend completing the following overview material.
| # | Topic | Outcome |
|---|---|---|
| 1 | Industry Problem | Understand why organisations struggle with enterprise data. |
| 2 | CryspIQ® Introduction | Understand what CryspIQ® does and how it works. |
| 3 | Navigation Guide | Learn how to move around the CryspIQ® platform. |
| 4 | CryspIQ® Methodology | Understand the CryspIQ® approach to preparing and governing enterprise data. |
| 5 | CryspIQ® Architecture | Understand how data flows through the CryspIQ® platform. |
Core User Training
All Data Administrators should first complete the standard user training.
| # | Guide | Outcome |
|---|---|---|
| 1 | Enterprise Data Glossary | Understand how business users discover data. |
| 2 | Questions | Understand how Natural Language Query consumes data. |
| 3 | Query Library | Understand how approved queries are used across the organisation. |
| 4 | Dashboards | Understand how data is consumed by business users. |
Learning Videos
| # | Video | Outcome |
|---|---|---|
| 1 | CryspIQ® Solution Architecture | Understand the CryspIQ® architecture and data flow. |
| 2 | CryspIQ® Source Messages | Understand Source Messages and source structures. |
| 3 | CryspIQ® Data Mapping | Understand the mapping process and contextualisation of data. |
| 4 | CryspIQ® Data Security | Understand security and access controls. |
| 5 | Importing Data into CryspIQ® | Learn how data is pushed into CryspIQ®. |
Sources Training
Learn how to onboard and manage source data.
| # | Guide | Outcome |
|---|---|---|
| 1 | Source Messages | Create and manage source message structures. |
| 2 | Upload Source Message | Upload source data for processing. |
| 3 | FetchXML Queries | Manage extraction queries for Microsoft Dynamics and other source systems. |
Maps Training
Learn how to prepare, organise and contextualise enterprise data.
| # | Guide | Outcome |
|---|---|---|
| 1 | Create Message Map | Map source data into the CryspIQ® Enterprise Data Model. |
| 2 | Methods | Apply transformations and standardisation rules. |
| 3 | Defaults | Enrich and standardise data using default values. |
| 4 | Data Quality Rules | Validate data quality during processing. |
Security Training
Learn how to protect enterprise data.
| # | Guide | Outcome |
|---|---|---|
| 1 | Access Control | Configure Microsoft Entra Security Groups. |
| 2 | Contextual Security | Protect dimensional and contextual data. |
| 3 | Business Object Security | Protect factual and business object data. |
Quality Training
Understand how CryspIQ® manages data quality and governance.
| # | Guide | Outcome |
|---|---|---|
| 1 | Parking Lot | Investigate records waiting for contextual data. |
| 2 | Function Dashboard | Monitor quality performance by business function. |
| 3 | Steward Dashboard | Monitor stewardship performance and accountability. |
| 4 | Data Quality Deep Dive | Investigate root causes using Power BI. |
Operations Training
Monitor the Push → Prepare → Load process.
| # | Guide | Outcome |
|---|---|---|
| 1 | Dynamics Operations | Monitor source system extraction processes. |
| 2 | Mapper Operations | Monitor mapping and contextualisation processing. |
| 3 | Load Operations | Monitor loading into the Enterprise Data Model. |
AI and Semantic Training
Help CryspIQ® understand how your organisation speaks.
| # | Guide | Outcome |
|---|---|---|
| 1 | Semantic Context | Maintain organisational terminology and definitions. |
| 2 | User Feedback | Review user behaviour and improve AI performance. |
Your Responsibilities
As a Data Administrator, your primary responsibilities include:
Data Onboarding
- Create Source Messages.
- Configure source integrations.
- Manage data ingestion.
Data Preparation
- Build Message Maps.
- Apply business context.
- Configure defaults and transformations.
Data Security
- Configure Security Groups.
- Apply access controls.
- Protect sensitive information.
Data Quality
- Create validation rules.
- Monitor quality exceptions.
- Support Data Stewards.
Platform Operations
- Monitor processing services.
- Investigate failures.
- Support operational stability.
AI and Discovery
- Maintain Semantic Context.
- Review User Feedback.
- Improve Natural Language Query results.
Expected Outcome
After completing this learning path, you will be able to:
- Onboard enterprise data into CryspIQ®.
- Apply the CryspIQ® methodology to source data.
- Secure data appropriately.
- Configure mappings and business context.
- Monitor operational processing.
- Support governance and stewardship activities.
- Improve AI and Natural Language Query outcomes.
- Deliver trusted enterprise data for business consumption.
Data Administrators are responsible for ensuring enterprise data is trusted, governed, contextualised and ready for reporting, analytics and AI.