Course Outline

Introduction

Overview of On-Premise and Cloud-Based Data Storage and Analysis Solutions for Government

Understanding Big Data for Government

  • Criteria for Big Data in the Public Sector
  • Structure of Big Data
  • Working with Big Data in Government Operations

Cloud Solutions for Government

  • Azure SQL Database
  • Azure Data Warehouse
  • Azure Data Factory
  • Azure Databricks
  • Power BI

Working with Databases for Government

  • Design of Data Warehouses
  • Dimensional Modeling
  • Implementation and Deployment in the Public Sector

Comparison of Data Models for Government

  • SSAS Tabular Data Models
  • SSAS Multidimensional Models
  • Power BI Models

Data Cleansing for Government

  • Strategies and Tools for Data Cleansing in the Public Sector

Report Models for Government

  • Building Power BI Tabular Models for Government Use
  • Understanding DAX in a Government Context

PowerBI Reports for Government

  • Designing Power BI Reports for Government Operations

Power BI Architecture for Government

  • Workspace Generation in the Public Sector
  • Licensing Requirements for Government
  • Permissions Management for Government Users

Administration of Data Solutions for Government

  • Administering Azure Solutions in the Public Sector
  • Administering the Power BI Service for Government Agencies

Security Considerations for Government

  • Maintaining a Secure Azure Architecture for Government
  • Security Features of Azure SQL Database, Data Warehouse, Data Factory, and Databricks
  • Data Masking and Privacy Issues in the Public Sector

Summary and Conclusion for Government

Requirements

  • Experience with basic data analysis techniques (e.g., using Excel).
  • A general understanding of cloud computing concepts (e.g., AWS) for government applications.

Audience

  • Database Engineers
  • Developers
 35 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories