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 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
Testimonials (2)
All good, nothing to improve
Ievgen Vinchyk - GE Medical Systems Polska Sp. Z O.O.
Course - AWS Lambda for Developers
IOT applications