Data Warehouse ETL Framework

EDW Catapult Users Guide Data Warehouse ETL Framework Real Time Analytics Defined Docs Why Do You Need An ETL Framework?Data as a Competitive Necessity The Benefits Of Using Python And SQL

Introduction To The ETL Framework
Framework Overview
General Principles
DataOps For The Uninitiated
ETL Developer's Field Guide
ETL Environment Set Up
Standard SSIS ETL Development Package
Sample Script Guide
A Methodology To Rapidly Convert OLTP Databases to OLAP Solutions
Data Model Creation Tool
Performance Monitoring
Data Warehouse Troubleshooting Guide
- Generalized Troubleshooting Steps
Business Analytics Capability Maturity Model
Appendices
- Appendix A. What is Medium Data®?
- Appendix B. The Benefits Of Using Python And T-SQL Over SSIS For ETL

Powered by GitBook

On this page

Data Warehouse User Profiles

PreviousThe Plain English Explanation Of What You Are About To Build NextUsing Data Source Names

Last updated 3 years ago

The users of the data warehouse will have may different titles, but, for the purposes of access control, they can be rolled into the following categories

Job Category

Description

Data Engineer

These are people that actually work on the data warehouse. They could actually be, DBAs, data architects. Basically people with the technical capability to make changes to the database without breaking things.

Data Analyst

These people are business users with some technical capability. Basically they know how to write SQL and can understand an ERD. They do not need their data fed to them. They can create complex reports with minimal help from IT.

Business User

These people are generally mid-level managers and executives who have need for data but not the technical capability to get it themselves without significant assistance from IT.