Course Outline

Introduction

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

Understanding Big Data

  • Criteria for Big Data
  • Structure of Big Data
  • Working with Big Data in a Public Sector Context

Cloud Solutions for Government

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

Working with Databases in the Public Sector

  • Designing Data Warehouses
  • Dimensional Modeling
  • Implementation and Deployment of Database Solutions for Government

Comparison of Data Models for Government Use

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

Data Cleansing Strategies and Tools for Government

  • Effective Strategies and Tools for Data Cleansing

Report Models for Government

  • Building Power BI Tabular Models for Government Reporting
  • Understanding DAX in the Context of Government Reporting

Designing Power BI Reports for Government

  • Best Practices for Designing Power BI Reports for Government Use

Power BI Architecture for Government

  • Workspace Generation in a Government Setting
  • Licensing Considerations for Government Users
  • Permissions Management for Government Data

Administration of Data Solutions for Government

  • Administering Azure Solutions in a Public Sector Environment
  • Administering the Power BI Service for Government Users

Security in Government Data Management

  • Maintaining a Secure Azure Architecture for Government
  • Securing Azure SQL Database/Data Warehouse, Data Factory, and Databricks for Government
  • Addressing Data Masking and Privacy Issues in Government

Summary and Conclusion

Requirements

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

Audience

  • Database Engineers
  • Software Developers
 35 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories