Publication date : 10/03/2025
Course : Building a data warehousedata quality and BI IS performance
Synthesis course - 3d
- 21h00 - Ref. DAW
|
Download in PDF format
Share this course by email
 | Understand the strategic stakes and benefits of a BI system |
| Identify the different organizational layers of a decision-making system |
| Modeling a data warehouse at the heart of a business intelligence system |
| Identify the essential steps in building a data warehouse |
| Mastering the roles and deliverables of a data warehouse construction project |
| Gain a comprehensive overview of business intelligence solutions on the market |
Intended audience
Data center managers, IT managers, design managers, information systems architects, functional and technical project managers.
Prerequisites
Good knowledge of database management. Basic knowledge of decision analysis.
Course schedule
1 The data warehouse, purpose and principles
- The strategic challenges of a business intelligence system.
- The technical and cultural reasons behind the data warehouse.
- Bill Inmon's definition of a data warehouse.
- Solutions provided by the data warehouse's technical and functional architecture.
- Characteristics of BI system data.
- The Infocenter and decision-support systems.
- Presentation of the different data warehouse and Infocentre approaches, their advantages and disadvantages.
2 The architecture of an enterprise BI system
- The different layers of data warehouse (DW) organization.
- Data collection and integration.
- Operational Data Store and Data Staging area.
- The presentation layer, the decision-making portal.
- Analysis engines Online Analytical Processing (OLAP): (MOLAP) and/or relational OLAP (ROLAP).
- Analysis techniques "data mining": predictive methods, descriptive methods.
- Growth in the volume and nature of data, the challenges of Big Data.
- Documenting DW data: data repository concepts.
- How does DW make data repository management (MDM) more reliable?
- Flow management: source data capture, transformation rules.
Example
Presentation of examples of various decision analysis projects.
3 Data warehouse modeling principles
- Operational and denormalized relational models.
- Hybrid models.
- Generic models.
- Understand the star model and its purpose.
- Understanding the concepts of facts and analysis. Analysis axis hierarchies.
- The flake model.
- The problem of evolving dimensions.
- Management of aggregates and functional perimeter stability.
- Which approach favors details or aggregates? Best practices, questions to ask the business.
Group discussion
Collective construction and enrichment of a star-shaped data model, based on several case studies. Development of the questioning to be proposed to gather the user's needs.
4 The data warehouse construction process
- Identify candidate functional scope. Determine the objective and the management events to be monitored.
- Estimate the volume of the perimeter.
- Functional analysis, collection of user requirements.
- Detailed technical architecture design.
- Establish a generic implementation approach.
- The benefits of an iterative approach, the content of an iteration.
- Choosing the right first iteration or pilot project. Role of sponsor, project owner, project manager, impact on the organization.
- Administration and monitoring of the operational solution.
Storyboarding workshops
Presentation of the data warehouse functional scope design process.
5 Project organization, players and deliverables
- The fundamental role of the sponsor or promoter.
- The steering committee.
- The role of the functional team, the user project group: validate the design of the user environment.
- Skills transfer to end users by the functional team: training and documentation.
- The technical team, the architects.
- The main deliverables of a BI project.
Storyboarding workshops
Presentation of deliverables and who is responsible for them at each stage of the process.
6 Business intelligence tools
- The latest technical developments in RDBMS for business intelligence.
- Overview and typology of BI solutions on the market. SaaS offers.
- Reporting solutions: SSRS, IBM Cognos, SAS, BusinessObjects... Implementation of query tools.
- Server-side and client-side OLAP analysis tools: use, scalability, DataMart approach, response times.
- Data mining analysis solutions: SAS Enterprise Miner, IBM, OBI data mining. Requirements and strengths.
- Extract-transform-load (ETL) solutions: IBM, Informatica, Oracle, SAP, Talend...
- Relational modeling tools: possibilities and limits.
Example
An overview of the possibilities offered by various business intelligence (BI) tools.
7 Summary
- Trends in decision-making systems.
- Best practices for modeling.
- Recommendations for data warehouse project organization.
Customer reviews
4,1 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
DAVID G.
10/03/26
5 / 5
très clair et partage son expérience terrain
PAULINE V.
17/12/25
4 / 5
My objectives have been achieved: to have methods for designing DWH data models + to better understand the overall context of the BI system.
JÉRÉMIE SYMPHOR N.
20/10/25
4 / 5
I appreciated the content of the course and the expertise of the trainer with his various practical cases.
PARTICIPANTS
Data center managers, IT managers, design managers, information systems architects, functional and technical project managers.
PREREQUISITES
Good knowledge of database management. Basic knowledge of decision analysis.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
Data center managers, IT managers, design managers, information systems architects, functional and technical project managers.
PREREQUISITES
Good knowledge of database management. Basic knowledge of decision analysis.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TEACHING AIDS AND TECHNICAL RESOURCES
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
Last places available
Guaranteed date, in person or remotely
Guaranteed session