Data Warehouse Fundamentals
Designed for a non-technical audience this course establishes the foundational data warehousing knowledge necessary for all team members to participate in the project. At the end of the course attendees will understand: |
|
The business case for data warehousing |
> |
What a data warehouse is and how it’s different than a transactional database |
|
Why spreadsheets are killing your productivity |
> |
How a data warehouse supports ad-hoc analysis |
> |
Key terms and concepts (cube, dimensions, measures, ETL, OLAP, etc) |
|
The importance of metadata |
|
How to organizing the team for success |
|
| |
|
Data Warehousing Design
Designed for a technical audience this course teaches the fundamentals of data warehouse design. Key concepts covered in this course include: |
|
Fact tables and the four steps to designing |
> |
Dimensional modeling & star schema, shared dimensions, conformed dimensions |
|
How to handle slowly changing dimensions |
> |
Identifying and declaring the correct grain |
> |
Primary keys, surrogate keys, foreign keys, degenerate dimensions |
|
Processing a fact table record |
|
| |
|
| |
|
|
DW Implementation – ETL
Designed for a technical audience this course teaches the fundamentals of ETL (extraction, translation & loading) in data warehousing. This course includes lecture and lab work as well as a detailed review and discussion of sample SQL code and how Microsoft SSIS is used for ETL. Key concepts covered in this course include: |
|
Data staging, extraction tables, staging tables, dimension tables, fact tables. |
> |
Staging stored procedures: prewash, postwash, lock, unlock, stage, cleanup, process, etc) |
|
Best practices for handling data quality |
|
| |
|
Organizing the Team for Success
This course is designed for both a business and technical audience and can be delivered during the initial stages of a new data warehouse project or to an organization with an established data warehouse. At the conclusion of the course the team will understand how to organize a business intelligence center of excellence (BICOE) and how it is critical to the long-term success of a corporate reporting initiative. Key concepts covered in this course include: |
|
Defining the BICOE and why it’s important |
> |
How to organize a cross functional team for data warehousing success |
|
How to balance technical and business requirements |
> |
How to prioritize new reporting requests |
> |
Governance and communication processes for the BICOE |
|
|
| |
|
