Data Academy Core Components
Delivering data warehouse projects within time and budget is the goal of all business
intelligence project managers. Data Academy delivers a framework that provides the
capability of achieving this goal. This course will provide developers of all skill
ranges with the requisite knowledge of the Data Academy core product to achieve
significant productivity gains in the development of complex data warehouses.
Duration:
4 days
Objectives:
By the end of this course, you will be able to:
- Design a data warehouse using Data Academy.
- Create Data Loaders to import
data from multiple sources.
- Apply data quality rules and raise data alerts.
- Create sophisticated data
transformations, such as summaries, pivots and un-pivots.
- Design and build star
schemas.
- Create basic and advanced Analysis Services cubes.
Who Should Attend?
The course will be of most benefit to database administrators, or management information
system developers who are involved in planning or developing a Data Academy data
warehouse.
Pre-Requisites:
A working knowledge of SQL Server database development:
- Creating a database
- Adding tables and views
- Run T-SQL queries with
"WHERE" and "GROUP BY" clauses
- Use a SELECT query to "JOIN"
tables and form relationships
To check availability, please e-mail Training@DataAcademy.com.