Organizations need to make informed strategic and tactical decisions. This is why they rely more and more on business intelligence (BI). A well-built data warehouse will help managers understand the situation (sales level, revenue evolution, customer quality...) and make the right decisions. With this training you will be able to use data warehouses to practice business intelligence and monitor market trends, as you will be able to put into practice the principles of multidimensional modeling and data warehouse design. Make sense of the data: gather and analyze it to identify solutions and assist in the decision-making process.
Objectives
To provide the knowledge and skills required to identify the main concepts of data warehousing and to make use of effective approaches in designing a data warehouse.
Is it for you ?
Business analysts and developers.
Prerequisite
General knowledge of computer science.
Content
- What are data warehouses and why do they exist?
- Architecture of data warehouses and data stores
- Business Intelligence: data mining, data warehousing and data visualization
- Referential/Universal set (metadata)
- Different stages of data warehouse design
Détails + / -
- Modeling, and the star, snowflake and galaxy models
- Considerations for Power BI
- Normalization rules for multidimensional schemas
- Modeling approaches: ascending, descending, mixed
- OLAP techniques (OnLine Analytical Processing): roll-up, drill-down, slice, dice, pivot, drill-through and drill-cross
- ROLAP, MOLAP and HOLAP servers
- Data warehousing applications (ETL, OLAP, etc.)
- Case studies and exercises in multidimensional modeling
- Illustration of various features using the Integration Services and Analysis Services modules in MS SQL Server.
Notes
Public sessions are not taken into account by Scale AI for grant allocation. Only customized versions of these training programs are eligible.
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote