ML21201A371

7 Jun Lee Bruce Jones - Data Warehouse Ai Workshop 06292021

ML21201A371
Person / Time
Issue date:	07/07/2021
From:	NRC/RES/DSA
To:
Matthew D
Shared Package
ML21201A227	List: ML21201A365 ML21201A366 ML21201A370 ML21201A371 ML21201A375 ML21201A376
References
Download: ML21201A371 (4)

Text

AI Enabling Technologies Enterprise Data Warehouse June 29, 2021

Overview What is the Enterprise Data Warehouse (EDW)?

• Central repository of integrated data from NRCs authoritative systems D a t a S o u r c e s

• Purpose is to provide timely, accurate data from authoritative data sources to be used for reporting and data analytics Data Warehouse

Overview Enterprise Data Warehouse Architecture

• Interfacing systems -

NRCs operational Operational systems, authoritative Systems data sources

• ETL Process - The Enterprise Data Warehouse extracts data ETL Process from authoritative sources, transforms it in a staging area then loads it into the EDW on Analysis a scheduled interval

• EDW - Database that stores the data to be Data used for reporting and Warehouse data analytics Reporting /

Visualization

Overview Benefits of the Data Warehouse

• Improved Reporting Performance and Efficiency

• Improved Data Quality and Consistency

• Empowers Users to Gain Data Insights Azure Cloud

• Data Warehouse

• Azure Analysis Services migration to Azure

• Azure Cognitive Services Cloud

• Azure Machine Learning Data Warehouse