Training: ERP data model and queries
Level : Diagnostic (DIAG02EN)
Short description
This course aims to familiarise supply chain professionals, data managers, ERP analysts and IT managers with the data models of ERP systems. Participants will learn about ERP structures, data types, and how to formulate effective queries.
The programme includes an introduction to ERP, an exploration of data models, and query techniques, complemented by practical workshops on a test ERP system. The course combines interactive presentations and practical exercises, providing all the tools needed to effectively exploit ERP data.
Trainer(s)
- Senior Supply Chain Consultant
Duration
- 1 to 5 days
Rate
- A quotation will be provided once the requirements have been analysed.
Program
Introduction to ERP systems (1 hour)
- Definition and role of ERP systems in the company
- Overview of typical ERP modules (Finance, HR, Production, etc.)
Understanding the ERP data model (2 hours)
- ERP database structure
- Types of data stored (master, transactional, configuration)
- Relationships between data in an ERP
- Examples of data models in popular ERPs (SAP, Oracle, Microsoft Dynamics)
Data queries in ERP (2 hours)
- Basic principles for creating queries
- Use of ERP-specific query languages (e.g. SQL for relational databases)
- Techniques for optimising queries
- Examples of common queries in an ERP context
Practical workshop (2 hours)
- Practical exercises on a test ERP system
- Formulation of basic queries to extract data
- Analysis of results and best practices
Objectives of this course
This course is designed to introduce participants to the essential concepts of data models in Enterprise Resource Planning (ERP) systems and to provide them with the skills required to create effective queries within these systems.
Requirements
- Basic computer skills.
- General understanding of database principles
Target audience
01. Supply Chain Professionals
02. Data managers
03. ERP Systems Analysts
04. IT Managers
Why take this course?
This course is essential for supply chain professionals, data managers, ERP analysts and IT managers looking to deepen their understanding of data models in ERP systems. Participants will acquire the skills to create and optimise queries in these systems, using specific languages such as SQL.
Through practical workshops on a test ERP system, they will practice formulating queries and analysing the results. This training enhances operational efficiency by enabling better exploitation of data in an ERP environment, making it essential for those who aspire to optimise the use of ERP technologies in their functions.
Teaching Method
- Interactive presentations using multimedia tools to explain KPIs and engage participants.
- Real-life case studies from various sectors to make theoretical concepts concrete.
- Hands-on exercises for KPI calculations using real/simulated data sets.
- Group discussions to promote experience sharing and collaborative problem-solving.
DIAGNOSTIC
Are you a data scientist in an industrial company who wants to learn new methods of data analysis? Try our games to discover new key indicators. Discover the best methodologies for calculating both basic CBN parameters and item records and replenishment models.
ERP data model and queries
