Big Data Training Database Structuring and Relationships

Prerequisites

No prior knowledge required

Objectives

◗ Identify the fundamental concepts of databases and modeling.

◗ Design multiple relationships between databases to create a model suitable for decision-making.

◗ Formulate requests regarding the organization of the data warehouse.

Training program

◗ Understanding data and its characteristics

– Definition of data: nature, structure, types
– Differences between structured and unstructured data
– Data sources in business
✔ UNDERSTAND | Illustration: concrete examples of data used in management
✔ EVALUATE | Quiz: In your opinion… Can an image be considered structured data?
✔ APPLY | Practical exercise: Convert a descriptive sentence into a formatted data row

◗ Mastering databases and relational logic

– Types of databases: relational, hierarchical, object-oriented, dimensional
– Tables, attributes, records, relationships
– Primary keys, foreign keys, cardinalities, and normalization rules
✔ UNDERSTAND | Case study: Representing a relational model using Excel tables
✔ APPLY | Practical Exercise: Build an entity-relationship diagram with relationships (1:1 / 1:n / n:n)
✔ EVALUATE | Quiz: In your opinion… Why normalize a relational model?

◗ Design a dimensional model for analysis

– Differences between the relational model and the star schema
– Fact table, dimensions, granularity, hierarchies
– Importance of consistency in cross-joins and aggregations
✔ UNDERSTAND | Illustration: Building an OLAP cube with multidimensional views
✔ APPLY | Practical exercise: Identifying facts and dimensions in a sales report
✔ EVALUATE | Quiz: In your opinion… What is granularity in a dimensional model?

◗ Adopt a project modelling approach

– Key Steps: Requirements Definition, Conceptual, Logical, and Physical Models
– Building the Data Dictionary
– The Role of Users, Business Experts, and IT in the Project
✔ UNDERSTAND | Illustration: Project Roadmap and RACI Matrix
✔ PRACTICE | Workshop: Building a Data Dictionary for an HR Model
✔ EVALUATE | Quiz: In your opinion… What is the difference between a logical model and a physical model?

◗ Apply what you have learned to a practical case

– Case Study: Inventory of Sports Facilities
– Identifying Sources, Dimensions, and Facts
– Building a Data Model Suitable for Analysis
✔ APPLY | Practical Exercise: Create a Data Model Using Public Data (RES)
✔ EXPERIMENT | Scenario: Discuss with the “requesters” (facilitator) to define the requirements
✔ EVALUATE | Quiz: In your opinion… Can a model be created without clarifying its intended uses beforehand?

Why choose this course?

If your company (or your department) is in the process of building or redesigning its data model, this module is for you!

In particular, you'll learn the vocabulary and methods needed to become a credible point of contact for the IT Department.

Teaching and assessment methods

Before the training: Submit your expectations via your online portal 15 days before the training begins and complete a self-assessment of your skills.

Teaching Methods: A variety of teaching methods to cater to different learning styles, encourage active participation, and reinforce learning through experimentation and practice.

Educational materials: presentation materials, reference materials (summary sheets, tables, etc.), and other resources available in your account.

During the training: theoretical concepts are alternated with examples drawn from real-life cases. Participants are given the opportunity to engage in role-playing exercises. Numerous practical exercises allow participants to demonstrate their mastery of the skills as the training progresses.

Training monitoring and evaluation: attendance sheet and certificate of completion. Immediate and post-training evaluations conducted using the LearnEval platform.

Price

1 295 € EXCL. TAX

Testimonials

Big data training

Jonathan C.
Company
Training

Generalist trainings