Duration
2 days
Schedule
9h to 16h
Regular fee
$955
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.
$860
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.Targeted audience
Business analysts and developers.Prerequisite
General knowledge of computer science.Trainers
Course architecture
- 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
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$955
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.
$860
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote