ML21201A371

From kanterella
Jump to navigation Jump to search
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:
References
Download: ML21201A371 (4)


Text

AI Enabling Technologies Enterprise Data Warehouse June 29, 2021

Overview Central repository of integrated data from NRCs authoritative systems Purpose is to provide timely, accurate data from authoritative data sources to be used for reporting and data analytics What is the Enterprise Data Warehouse (EDW)?

Data Warehouse D a t a S o u r c e s

Overview Interfacing systems -

NRCs operational systems, authoritative data sources ETL Process - The Enterprise Data Warehouse extracts data from authoritative sources, transforms it in a staging area then loads it into the EDW on a scheduled interval EDW - Database that stores the data to be used for reporting and data analytics Enterprise Data Warehouse Architecture Operational Systems ETL Process Data Warehouse Analysis Reporting /

Visualization

Overview Improved Reporting Performance and Efficiency Improved Data Quality and Consistency Empowers Users to Gain Data Insights Benefits of the Data Warehouse Azure Cloud Data Warehouse migration to Azure Cloud Data Warehouse

  • Azure Analysis Services
  • Azure Cognitive Services