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.
Duration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Objectives of the training
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.Targeted audience
Business analysts and developers.Prerequisite
General knowledge of computer science.Trainers
Course architecture
Training eligible for SCALE AI grants
- 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.
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 quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
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