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:
5 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 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 2005 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.
Click to find out more
or Call us on 0118 921 1555