Discover key principles, techniques, tools and applications.
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.
Is it for you ?
Business analysts and developers.
Prerequisites
General knowledge of computer science.
Training 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
- 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.
Keep in Mind
Public sessions are not taken into account by Scale AI for grant allocation. Only customized versions of these training programs are eligible.
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
