Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (2)
All good, nothing to improve
Ievgen Vinchyk - GE Medical Systems Polska Sp. Z O.O.
Course - AWS Lambda for Developers
IOT applications