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
Testimonials (2)
All of the training was great. Especially liked the training documentation to reference. Looking forward to the Advanced Training, when we are ready.
Amy Gregg - Qualfon
Course - Boomi Integration Fundamentals
I've find out new interesting things about Lambda and Serverless