20767: Implementing a SQL Data Warehouse
Date: 15 - 19 Jul 2019 (5 days)
Time: 8h30am – 5:00pm
Training Fee: 12.000.000 VND
REGISTER NOW
|
|
Mục tiêu
After completing this course, students will be able to
- Describe the key elements of a data warehousing solution
- Describe the main hardware considerations for building a data warehouse
- Implement a logical design for a data warehouse
- Implement a physical design for a data warehouse
- Create column store indexes
- Implementing an Azure SQL Data Warehouse
- Describe the key features of SSIS
- Implement a data flow by using SSIS
- Implement control flow by using tasks and precedence constraints
- Create dynamic packages that include variables and parameters
- Debug SSIS packages
- Describe the considerations for implement an ETL solution
- Implement Data Quality Services
- Implement a Master Data Services model
- Describe how you can use custom components to extend SSIS
- Deploy SSIS projects
- Describe BI and common BI scenarios
View more: click here
|
20768: Developing SQL Data Models
Date: 30 Jul - 01 Aug (3 days)
Time: 8h30am – 5:00pm
Training Fee: 8.000.000 VND
REGISTER NOW
|
|
Mục tiêu
After completing this course, students will be able to:
- Describe the components, architecture, and nature of a BI solution
- Create a multidimensional database with Analysis Services
- Implement dimensions in a cube
- Implement measures and measure groups in a cube
- Use MDX syntax
- Customize a cube
- Implement a tabular database
- Use DAX to query a tabular model
- Use data mining for predictive analysis
View more: click here
|