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
Our teaching method is designed to optimise learning and participant engagement by integrating a variety of interactive and practical techniques:
- Sessions begin with interactive presentations where key KPI concepts are explained in detail. Using advanced multimedia technologies, these presentations encourage the active participation of learners.
- In order to put theory into practice, we incorporate real-life case studies and concrete examples from a variety of industry sectors. This allows participants to see how KPIs are applied in real-life situations, enhancing their ability to link theory to practice.
- A significant part of the course is dedicated to practical exercises where participants apply the KPI calculation formulas to real or simulated data sets.
- To promote collective understanding and encourage the exchange of perspectives, group discussion sessions are organised. These discussions allow participants to share their experiences, offer personal insights and collaborate on complex problems, enriching the learning experience for all.
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
DataSets for free download
Data generation
http://gofile.me/5mF2y/IeDE9TqRb
Other Formations...
ABC log methodology for industrial performance
Level : Diagnostic
Optimising CBN settings
Level : Expert
Deployment of daily tracking files
Level : Intensive
Manager profiles
Level : Optimal
