Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data warehouse - Coggle Diagram
Data warehouse
data warehouse life cycle
implementation
ETL design &development
This step is about designing and building the data pipelines that extract, transform, and load data from the different sources into the data warehouse
extract data from the source systems.
BI application
set up BI or business intelligence tools to interact with the data warehouse and create reports needed by the organization
support/maintenance
maintenance
update the warehouse table designs or make other necessary changes
test & deploy
planning phase
requirements gathering.
data modeling
It is planning based on business requirements on how the team transforms data from different input sources and integrates it into our data warehouse.
plan data pipelines from the database systems to the warehouse.
defined as: Data modeling is the process of diagramming data flows. When creating a new or alternate database structure, the designer starts with a diagram of how data will flow into and out of the database. This flow diagram is used to define the characteristics of the data formats, structures, and database handling functions to efficiently support the data flow requirements. After the database has been built and deployed, the data model lives on to become the documentation and justification for why the database exists and how the data flows were designed.
types of data modeling
Data Warehousing
characteristics
big data
vs.
database
vs.
datawarehouse
OLTP vs OLAP
datawarehouse
vs
datalake
vs
datamart