Course Outline

Foundations of Data Warehousing for Government

  • Purpose, components, and architecture of data warehouses
  • Overview of data marts, enterprise warehouses, and lakehouse patterns
  • Fundamentals of OLTP versus OLAP and workload separation

Dimensional Modeling for Government

  • Understanding facts, dimensions, and grain
  • Comparison of star schema and snowflake schema
  • Handling Slowly Changing Dimensions types and methods

ETL and ELT Processes for Government

  • Strategies for extracting data from OLTP systems and APIs
  • Techniques for transformations, data cleansing, and ensuring conformance
  • Patterns for loading data, orchestration, and managing dependencies

Data Quality and Metadata Management for Government

  • Methods for data profiling and validation rules
  • Strategies for aligning master and reference data
  • Practices for lineage tracking, cataloging, and documentation

Analytics and Performance for Government

  • Concepts of cubing, aggregates, and materialized views
  • Techniques for partitioning, clustering, and indexing to enhance analytics
  • Approaches for workload management, caching, and query tuning

Security and Governance for Government

  • Implementation of access control, roles, and row-level security
  • Considerations for compliance and auditing
  • Best practices for backup, recovery, and ensuring reliability

Modern Architectures for Government

  • Cloud data warehouses and their elasticity
  • Methods for streaming ingestion and near real-time analytics
  • Strategies for cost optimization and monitoring

Capstone: From Source to Star Schema for Government

  • Modeling a business process into facts and dimensions
  • Constructing an end-to-end ETL or ELT workflow
  • Publishing dashboards and validating metrics

Summary and Next Steps for Government

Requirements

  • A solid understanding of relational databases and SQL
  • Practical experience in data analysis or reporting
  • Basic knowledge of cloud or on-premises data platforms

Audience for Government

  • Data analysts transitioning to data warehousing roles
  • BI developers and ETL engineers
  • Data architects and team leaders
 35 Hours

Number of participants


Price per participant

Testimonials (5)

Upcoming Courses

Related Categories