Course Outline

Module 1: Discover Data Analysis for Government

In this module, you will explore the different roles in data and learn about the various tasks of a data analyst.

Lessons

  • Introduction

  • Overview of Data Analysis for Government

  • Roles in Data for Government

  • Tasks of a Data Analyst for Government

  • Check Your Knowledge

  • Summary

Learning Objectives

After completing this module, students will be able to:

  • Understand the roles in data for government.
  • Comprehend the tasks of a data analyst for government.

Module 2: Get Started Building with Power BI for Government

This module introduces what Power BI is, including its building blocks and how they work together. It also helps prepare you for the Exam PL-100: Microsoft Power Platform App Maker.

Learning Objectives

After completing this module, students will be able to:

  • Understand how Power BI services and applications work together.
  • Explore how Power BI can enhance government efficiency.
  • Create compelling visuals and reports for government use.

Lessons

  • Introduction

  • Use Power BI for Government

  • Building Blocks of Power BI for Government

  • Tour and Use the Power BI Service for Government

  • Knowledge Check

  • Summary

Module 3: Get Data in Power BI for Government

In this module, you will learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You will also learn how to improve performance while retrieving data.

Learning Objectives

By the end of this module, you will be able to:

  • Identify and connect to a data source for government use.
  • Retrieve data from a relational database, like Microsoft SQL Server, for government use.
  • Retrieve data from a file, like Microsoft Excel, for government use.
  • Retrieve data from applications for government use.
  • Retrieve data from Azure Analysis Services for government use.
  • Select a storage mode for government use.
  • Fix performance issues in government data retrieval.
  • Resolve data import errors for government use.

Lessons

  • Introduction

  • Get Data from Files for Government

  • Get Data from Relational Data Sources for Government

  • Create Dynamic Reports with Parameters for Government

  • Get Data from a NoSQL Database for Government

  • Get Data from Online Services for Government

  • Select a Storage Mode for Government

  • Get Data from Azure Analysis Services for Government

  • Fix Performance Issues for Government

  • Resolve Data Import Errors for Government

  • Exercise - Prepare Data in Power BI Desktop for Government

  • Check Your Knowledge

  • Summary

Module 4: Clean, Transform, and Load Data in Power BI for Government

This module teaches you how to simplify a complicated model, change data types, rename objects, and pivot data. You will also learn how to profile columns to identify valuable data for deeper analytics.

Learning Objectives

By the end of this module, you will be able to:

  • Resolve inconsistencies, unexpected or null values, and data quality issues in government data.
  • Apply user-friendly value replacements in government data.
  • Profile data to learn more about a specific column before using it for government analytics.
  • Evaluate and transform column data types for government use.
  • Apply data shape transformations to table structures for government use.
  • Combine queries for government data.
  • Apply user-friendly naming conventions to columns and queries for government use.
  • Edit M code in the Advanced Editor for government use.

Lessons

  • Introduction

  • Shape the Initial Data for Government

  • Simplify the Data Structure for Government

  • Evaluate and Change Column Data Types for Government

  • Combine Multiple Tables into a Single Table for Government

  • Profile Data in Power BI for Government

  • Use Advanced Editor to Modify M Code for Government

  • Exercise - Load Data in Power BI Desktop for Government

  • Check Your Knowledge

  • Summary

Module 5: Design a Data Model in Power BI for Government

The process of creating a complex data model in Power BI is straightforward. If your data comes from multiple transactional systems, you can quickly end up with dozens of tables to manage. This module teaches how to simplify the disarray using star schemas and other techniques. You will also learn about choosing the correct data granularity for performance and usability of your Power BI reports. Finally, you will explore methods to improve performance in your Power BI data models.

Learning Objectives

In this module, you will:

  • Create common date tables for government use.
  • Configure many-to-many relationships for government use.
  • Resolve circular relationships for government use.
  • Design star schemas for government use.

Lessons

  • Introduction

  • Work with Tables for Government

  • Create a Date Table for Government

  • Work with Dimensions for Government

  • Define Data Granularity for Government

  • Work with Relationships and Cardinality for Government

  • Resolve Modeling Challenges for Government

  • Exercise - Model Data in Power BI Desktop for Government

  • Check Your Knowledge

  • Summary

Module 6: Add Measures to Power BI Desktop Models for Government

In this module, you will learn how to work with implicit and explicit measures. You will start by creating simple measures that summarize a single column or table. Then, you will create more complex measures based on other measures in the model. Additionally, you will explore the similarities and differences between calculated columns and measures.

Learning Objectives

By the end of this module, you will be able to:

  • Determine when to use implicit and explicit measures for government data.
  • Create simple measures for government data.
  • Create compound measures for government data.
  • Create quick measures for government data.
  • Describe the similarities and differences between a calculated column and a measure for government use.

Lessons

  • Introduction

  • Create Simple Measures for Government

  • Create Compound Measures for Government

  • Create Quick Measures for Government

  • Compare Calculated Columns with Measures for Government

  • Check Your Knowledge

  • Exercise - Create DAX Calculations in Power BI Desktop for Government

  • Summary

Module 7: Add Calculated Tables and Columns to Power BI Desktop Models for Government

By the end of this module, you will be able to add calculated tables and columns to your data model. You will also learn about row context, which is used to evaluate calculated column formulas. Additionally, you will explore when it is best to create calculated columns instead of using Power Query custom columns.

Learning Objectives

By the end of this module, you will be able to:

  • Create calculated tables for government use.
  • Create calculated columns for government use.
  • Identify row context for government data.
  • Determine when to use a calculated column in place of a Power Query custom column for government use.
  • Add a date table to your model using DAX calculations for government.

Lessons

  • Introduction

  • Create Calculated Columns for Government

  • Learn About Row Context for Government

  • Choose a Technique to Add a Column for Government

  • Check Your Knowledge

  • Summary

Module 8: Use DAX Time Intelligence Functions in Power BI Desktop Models for Government

By the end of this module, you will learn the meaning of time intelligence and how to add time intelligence DAX calculations to your model.

Learning Objectives

By the end of this module, you will be able to:

  • Define time intelligence for government data.
  • Use common DAX time intelligence functions for government data.
  • Create useful intelligence calculations for government data.

Lessons

  • Introduction

  • Use DAX Time Intelligence Functions for Government

  • Additional Time Intelligence Calculations for Government

  • Exercise - Create Advanced DAX Calculations in Power BI Desktop for Government

  • Check Your Knowledge

  • Summary

Module 9: Optimize a Model for Performance in Power BI for Government

Performance optimization, also known as performance tuning, involves making changes to the current state of the data model so that it runs more efficiently. When your data model is optimized, it performs better.

Learning Objectives

By the end of this module, you will be able to:

  • Review the performance of measures, relationships, and visuals for government use.
  • Use variables to improve performance and troubleshooting for government data.
  • Improve performance by reducing cardinality levels for government data.
  • Optimize DirectQuery models with table level storage for government use.
  • Create and manage aggregations for government data.

Lessons

  • Introduction to Performance Optimization for Government

  • Review Performance of Measures, Relationships, and Visuals for Government

  • Use Variables to Improve Performance and Troubleshooting for Government

  • Reduce Cardinality for Government

  • Optimize DirectQuery Models with Table Level Storage for Government

  • Create and Manage Aggregations for Government

  • Check Your Knowledge

  • Summary

Module 10: Design Power BI Reports for Government

Because Power BI includes over 30 core visuals, it can be challenging for beginners to select the correct visual. This module will guide you through selecting the most appropriate visual type to meet your design and report layout requirements.

Learning Objectives

In this module, you will:

  • Learn about the structure of a Power BI report for government use.
  • Learn about report objects for government use.
  • Select the appropriate visual type to use for government reports.

Lessons

  • Introduction

  • Design the Analytical Report Layout for Government

  • Design Visually Appealing Reports for Government

  • Report Objects for Government

  • Select Report Visuals for Government

  • Select Report Visuals to Suit the Report Layout for Government

  • Format and Configure Visualizations for Government

  • Work with Key Performance Indicators for Government

  • Exercise - Design a Report in Power BI Desktop for Government

  • Check Your Knowledge

  • Summary

Module 11: Configure Power BI Report Filters for Government

Report filtering is a complex topic because many techniques are available for filtering a Microsoft Power BI report. However, with complexity comes control, allowing you to design reports that meet requirements and expectations. Some filtering techniques apply at design time, while others are relevant at report consumption time (in reading view). What matters is that your report design allows report consumers to intuitively narrow down to the data points that interest them.

Learning Objectives

In this module, you will:

  • Design reports for filtering in government use.
  • Design reports with slicers for government use.
  • Design reports using advanced filtering techniques for government use.
  • Apply consumption-time filtering for government reports.
  • Select appropriate report filtering techniques for government use.

Lessons

  • Introduction to Designing Reports for Filtering in Government

  • Apply Filters to the Report Structure for Government

  • Apply Filters with Slicers for Government

  • Design Reports with Advanced Filtering Techniques for Government

  • Consumption-Time Filtering for Government

  • Select Report Filter Techniques for Government

  • Case Study - Configure Report Filters Based on Feedback for Government

  • Check Your Knowledge

  • Summary

Module 12: Enhance Power BI Report Designs for the User Experience in Government

The features and capabilities covered in this module will help you enhance your reports to make them more refined.

Learning Objectives

In this module, you will:

  • Design reports to show details for government use.
  • Design reports to highlight values for government use.
  • Design reports that behave like apps for government use.
  • Work with bookmarks for government use.
  • Design reports for navigation in government use.
  • Work with visual headers for government use.
  • Design reports with built-in assistance for government use.
  • Use specialized visuals for government use.

Lessons

  • Design Reports to Show Details for Government

  • Design Reports to Highlight Values for Government

  • Design Reports That Behave Like Apps for Government

  • Work with Bookmarks for Government

  • Design Reports for Navigation for Government

  • Work with Visual Headers for Government

  • Design Reports with Built-In Assistance for Government

  • Tune Report Performance for Government

  • Optimize Reports for Mobile Use for Government

  • Exercise - Enhance Power BI Reports for Government

  • Check Your Knowledge

  • Summary

Module 13: Perform Analytics in Power BI for Government

You will learn how to use Power BI to perform data analytical functions, identify outliers in your data, group data together, and bin data for analysis. You will also conduct time series analysis and work with advanced analytic features of Power BI, such as Quick Insights, AI Insights, and the Analyze feature.

Learning Objectives

In this module, you will:

  • Explore statistical summary for government data.
  • Identify outliers with Power BI visuals for government use.
  • Group and bin data for analysis in government.
  • Apply clustering techniques for government data.
  • Conduct time series analysis for government data.
  • Use the Analyze feature for government data.
  • Use advanced analytics custom visuals for government data.
  • Review Quick Insights for government data.
  • Apply AI Insights for government data.

Lessons

  • Introduction to Analytics for Government

  • Explore Statistical Summary for Government

  • Identify Outliers with Power BI Visuals for Government

  • Group and Bin Data for Analysis in Government

  • Apply Clustering Techniques for Government

  • Conduct Time Series Analysis for Government

  • Use the Analyze Feature for Government

  • Create What-If Parameters for Government

  • Use Specialized Visuals for Government

  • Exercise - Perform Advanced Analytics with AI Visuals for Government

  • Check Your Knowledge

  • Summary

Module 14: Create and Manage Workspaces in Power BI for Government

Learn how to navigate the Power BI service, create and manage workspaces and related items, and distribute reports to users.

Learning Objectives

In this module, you will:

  • Create and manage Power BI workspaces and items for government use.
  • Distribute a report or dashboard for government use.
  • Monitor usage and performance for government data.
  • Recommend a development lifecycle strategy for government projects.
  • Troubleshoot data by viewing its lineage for government data.
  • Configure data protection for government use.

Lessons

  • Introduction

  • Distribute a Report or Dashboard for Government

  • Monitor Usage and Performance for Government

  • Recommend a Development Lifecycle Strategy for Government

  • Troubleshoot Data by Viewing Its Lineage for Government

  • Configure Data Protection for Government

  • Check Your Knowledge

  • Summary

Module 15: Manage Datasets in Power BI for Government

With Microsoft Power BI, you can use a single dataset to build many reports. Reduce your administrative overhead even more with scheduled dataset refreshes and resolving connectivity errors.

Learning Objectives

In this module, you will:

  • Use a Power BI gateway to connect to on-premises data sources for government use.
  • Configure a scheduled refresh for a dataset for government use.
  • Configure incremental refresh settings for government use.
  • Manage and promote datasets for government use.
  • Troubleshoot service connectivity for government data.
  • Boost performance with query caching (Premium) for government use.

Lessons

  • Introduction

  • Use a Power BI Gateway to Connect to On-Premises Data Sources for Government

  • Configure a Dataset Scheduled Refresh for Government

  • Configure Incremental Refresh Settings for Government

  • Manage and Promote Datasets for Government

  • Troubleshoot Service Connectivity for Government

  • Boost Performance with Query Caching (Premium) for Government

  • Check Your Knowledge

  • Summary

Module 16: Create Dashboards in Power BI for Government

Microsoft Power BI dashboards are different from Power BI reports. Dashboards allow report consumers to create a single artifact of directed data that is personalized just for them. Dashboards can be composed of pinned visuals taken from different reports. Where a Power BI report uses data from a single dataset, a Power BI dashboard can contain visuals from different datasets.

Learning Objectives

In this module, you will:

  • Set a mobile view for government dashboards.
  • Add a theme to the visuals in your dashboard for government use.
  • Configure data classification for government data.
  • Add real-time dataset visuals to your dashboards for government use.
  • Pin a live report page to a dashboard for government use.

Lessons

  • Introduction to Dashboards for Government

  • Configure Data Alerts for Government

  • Explore Data by Asking Questions for Government

  • Review Quick Insights for Government

  • Add a Dashboard Theme for Government

  • Pin a Live Report Page to a Dashboard for Government

  • Configure a Real-Time Dashboard for Government

  • Configure Data Classification for Government

  • Set Mobile View for Government

  • Exercise - Create a Power BI Dashboard for Government

  • Check Your Knowledge

  • Summary

Module 17: Implement Row-Level Security in Power BI for Government

Row-level security (RLS) allows you to create a single or a set of reports that target data for a specific user. In this module, you will learn how to implement RLS using either a static or dynamic method and how Microsoft Power BI simplifies testing RLS in Power BI Desktop and the Power BI service.

Learning Objectives

In this module, you will:

  • Configure row-level security using a static method for government data.
  • Configure row-level security using a dynamic method for government data.

Lessons

  • Introduction

  • Configure Row-Level Security with the Static Method for Government

  • Configure Row-Level Security with the Dynamic Method for Government

  • Exercise - Enforce Row-Level Security in Power BI for Government

  • Check Your Knowledge

  • Summary

Requirements

Successful Data Analysts for government begin their roles with experience in managing data in cloud environments.

Specifically:

  • An understanding of fundamental data concepts.

  • Proficiency in working with relational data in the cloud.

  • Knowledge of non-relational data management in the cloud.

  • Familiarity with data analysis and visualization techniques.

To gain the necessary prerequisites and a deeper understanding of working with data in Azure, it is recommended to complete Microsoft Azure Data Fundamentals before enrolling in this course for government.

 21 Hours

Number of participants


Price per participant

Runs with a minimum of 4 + people. For 1-to-1 or private group training, request a quote.

Upcoming Courses

PL-300T00: Microsoft Power BI Data Analyst

2026-01-14 09:30
21 hours
Birmingham, AL - Regus at One Perimeter Park
$ 2109 (Online)
$ 2109 (Classroom)

PL-300T00: Microsoft Power BI Data Analyst

2026-01-28 09:30
21 hours
Bismarck, ND - Juniper Workantile
$ 2109 (Online)
$ 2109 (Classroom)

PL-300T00: Microsoft Power BI Data Analyst

2026-02-11 09:30
21 hours
Boise, ID - Regus - Boise Downtown
$ 2109 (Online)
$ 2109 (Classroom)

PL-300T00: Microsoft Power BI Data Analyst

2026-02-25 09:30
21 hours
Bridgeport, CT – Regus at Downtown Bridgeport
$ 2109 (Online)
$ 2109 (Classroom)

Related Courses

Cloud & Datacenter Monitoring with System Center Operations Manager (10964-C)

 35 Hours

About This Course

This course equips participants with the skills necessary to deploy and configure System Center 2012 R2 Operations Manager. Through hands-on labs, students will learn:

• How to design and implement a System Center 2012 R2 Operations Manager Management Group.

• Techniques for upgrading and migrating from an existing Operations Manager 2007 R2 Management Group to System Center 2012 Operations Manager, System Center 2012 SP1 Operations Manager, and System Center 2012 R2 Operations Manager.

• Key elements of Management Packs, including Object Discoveries, Rules, Monitors, Targeting, Run As Accounts, and Run As Profiles. This includes the authoring of Management Packs.

• Methods for configuring fabric and application monitoring in System Center 2012 R2 Operations Manager, covering both datacenter and cloud resources such as networking, storage, and compute capabilities.

• Techniques for monitoring .NET and Java-based applications using Application Performance Monitoring.

• Strategies for end-to-end service monitoring, including synthetic transactions and Distributed Application Diagrams.

• Procedures for configuring Dashboards, Service Level Tracking Reporting, and the SharePoint Web Part to visualize key performance and availability metrics.

• Customization of the Operations Manager Console to meet the needs of various application support teams.

• Integration of Operations Manager with other System Center 2012 R2 components to extend monitoring to include critical business processes and procedures.

• Techniques for troubleshooting an Operations Manager Management Group and performing disaster recovery, such as database and management server recovery.

• Utilization of new features in System Center 2012 R2, including Integration with System Center Advisor, Team Foundation Server, IntelliTrace, and Managing Windows Azure.

Audience Profile

The primary audience for this course is cloud and datacenter administrators who are new to System Center 2012 R2 Operations Manager and are responsible for deploying, configuring, and operating it in their environments. The secondary audience includes cloud and datacenter administrators already familiar with Operations Manager and looking to upgrade their skills to include the latest features found in System Center 2012 Operations Manager, System Center 2012 SP1 Operations Manager, and System Center 2012 R2 Operations Manager.

At Course Completion

Upon completing this course, participants will be able to:

  • Plan for the deployment of System Center 2012 R2 Operations Manager, including:
    • Defining hardware and software requirements.
    • Describing security considerations.
    • Designing a highly available System Center and Microsoft SQL Server platform using Microsoft SQL Server AlwaysOn.
    • Planning for migration and upgrade scenarios to System Center 2012 R2 Operations Manager.
  • Customize the Operations Console with User Roles.
  • Perform various methods of Agent deployment with System Center 2012 R2 Operations Manager.
  • Implement key Management Pack concepts and elements, including Management Packs Templates.
  • Configure Notifications, Reporting, and Service Level Tracking in System Center 2012 R2 Operations Manager.
  • Set up the following:
    • Audit Collection Services.
    • Agentless Exception Monitoring.
    • The Operations Manager SharePoint Web Part in System Center 2012 R2 Operations Manager.
  • Configure Application Performance Monitoring and Network Device monitoring in System Center 2012 R2 Operations Manager.
  • Create dashboards and widgets in System Center 2012 R2 Operations Manager.
  • Explain the use of new cloud-based features, including System Center Global Service Monitor and System Center Advisor.
  • Configure integration between System Center 2012 R2 Operations Manager and other System Center 2012 R2 components.
  • Troubleshoot an Operations Manager Management Group.
  • Perform disaster recovery in System Center 2012 R2 Operations Manager, ensuring continuity for government operations.
Read more...

Supporting and Troubleshooting Windows 10 (10982EC)

 35 Hours

Upon completion of this course in US Empire, you will be able to:

  • Explain the processes involved in planning and utilizing a troubleshooting methodology for Windows 10, specifically tailored for government use.
  • Troubleshoot startup issues and operating system services on a Windows 10 PC within a public sector environment.
  • Perform system recovery procedures to ensure continuity of operations for government systems.
  • Resolve issues related to hardware devices and device drivers in a manner that aligns with government IT standards.
  • Administer Windows 10 devices in compliance with federal guidelines and best practices for government.
  • Troubleshoot network connectivity issues to ensure secure and reliable communications for government operations.
  • Configure Windows 10 devices using Group Policy to meet the specific governance requirements of government agencies.
  • Configure and troubleshoot user settings to enhance productivity and security in a government setting.
  • Configure and troubleshoot resource access to support efficient and secure data management for government.
  • Implement remote connectivity solutions that adhere to government security protocols and compliance standards.
  • Deploy and troubleshoot applications to ensure they function effectively within the government IT infrastructure.
  • Maintain Windows 10 devices to ensure ongoing performance, security, and compliance with government regulations.
Read more...

Introduction to SQL Databases (10985CC)

 21 Hours

About This Course

This three-day, instructor-led course is designed for individuals transitioning into a database professional role or whose job responsibilities are expanding to include database elements. The course covers essential database concepts, including database types, languages, and design principles, tailored specifically for government.

Audience Profile

The primary audience for this course includes personnel who are moving into a database role or whose roles have expanded to encompass database technologies within the public sector.

At Course Completion

Upon completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Explain the database languages utilized in SQL Server 2016
• Apply data modeling techniques
• Implement normalization and denormalization strategies
• Identify relationship types and their impacts on database design
• Evaluate the effects of database design on performance
• Utilize commonly employed database objects

Read more...

Planning and Administering SharePoint 2016 (authorized training course MS 20339)

 35 Hours

About This Course

This five-day course is designed to equip you with the knowledge and skills necessary to plan and administer a Microsoft SharePoint 2016 environment. The curriculum covers the deployment, administration, and troubleshooting of your SharePoint environment. Additionally, it provides guidelines, best practices, and considerations that will help optimize your SharePoint deployment for government use.

This course is the first in a series of two courses tailored for IT professionals and aligns with the SharePoint 2016 IT Pro certification.

Audience Profile

The course targets experienced IT professionals interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations, whether in a data center or in the cloud. Participants typically have more than one year of hands-on experience with planning and maintaining SharePoint environments and at least two years of experience with core technologies that SharePoint depends on, such as Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

The minimally qualified candidate typically:

  • Is an IT professional responsible for planning, implementing, and maintaining a multi-server deployment of SharePoint 2016.
  • Possesses practical knowledge and experience with SharePoint Online.
  • Has broad familiarity with SharePoint workloads.
  • Has expertise in business continuity management, including data backup, restoration, and high availability.
  • Is familiar with authentication and security technologies.
  • Has hands-on experience with Windows PowerShell.
The hands-on or job experience should be from a solutions-based role where the candidate has worked on multiple SharePoint projects involving document management, content management, and search functionalities.

At Course Completion

  • Describe the key features of SharePoint 2016.
  • Design an information architecture for a SharePoint 2016 deployment.
  • Design a logical architecture for a SharePoint 2016 deployment.
  • Design the physical architecture for a SharePoint 2016 deployment.
  • Install and configure SharePoint 2016.
  • Create and configure web applications and site collections.
  • Plan and configure service applications for a SharePoint 2016 deployment.
  • Manage users and permissions, and secure content in a SharePoint 2016 deployment.
  • Configure authentication in a SharePoint 2016 deployment.
  • Configure platform and farm-level security in a SharePoint 2016 deployment.
  • Manage information taxonomy in SharePoint web applications and site collections.
  • Configure and manage user profiles and audiences.
  • Configure and manage the search experience in SharePoint 2016.
  • Monitor, maintain, and troubleshoot a SharePoint 2016 deployment.
Read more...

Advanced Technologies of SharePoint 2016 (20339-2AC)

 35 Hours

About This Course

This five-day course will equip participants with the skills necessary to plan, configure, and manage advanced features in a SharePoint 2016 environment. Key areas of focus include implementing high availability, disaster recovery, service application architecture, and Microsoft Business Connectivity Services. The course also delves into social computing features, productivity, and collaboration platforms, as well as business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. Additionally, it covers the development and implementation of a governance plan, and the procedures for upgrading or migrating to SharePoint 2016.

This course is the second in a series of two courses designed for IT Professionals and aligns with the SharePoint 2016 IT Pro certification.

Audience Profile

The course is targeted at experienced IT Professionals who are interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations, whether in a data center or in the cloud. Participants should have more than four years of hands-on experience* planning and maintaining SharePoint Server and other core technologies upon which SharePoint depends, including Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 R2 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

Participants should have completed Course 20339-1A: Planning and Administering Microsoft SharePoint 2016, or have gained equivalent knowledge and experience before taking this course. The minimally qualified candidate typically:

  • Possesses a working knowledge of, and preferably hands-on experience with, Microsoft SharePoint Online.

  • Has broad familiarity with SharePoint Server workloads.

  • Has experience with business continuity management, including data backup, restoration, and high availability.

  • Has experience with authentication and security technologies.

  • Is proficient in using Windows PowerShell.

* The hands-on or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the SharePoint Server space, including document management, content management, and search.

At Course Completion

Upon completing this course, participants will be able to:

  • Describe the core architecture of SharePoint 2016 and its new and improved features.
  • Explain the key hybrid features in SharePoint 2016.
  • Plan and design a SharePoint 2016 environment to meet requirements for high availability and disaster recovery.
  • Plan and implement Business Connectivity Services and Secure Store Service.
  • Configure and manage productivity services in a SharePoint 2016 deployment.
  • Manage solutions in a SharePoint 2016 deployment.
  • Plan and configure social computing features.
  • Plan and configure web content management for an Internet-facing environment.
  • Plan and configure Enterprise Content Management in a SharePoint 2016 deployment.
  • Plan and configure business intelligence solutions.
  • Plan and configure work management, productivity, and collaboration platforms and features.
  • Perform an upgrade or migration to SharePoint 2016.

This course is designed for government professionals who need to enhance their skills in managing and deploying SharePoint solutions effectively within public sector environments, ensuring alignment with governance, workflows, and accountability standards for government.

Read more...

Virtualizing Enterprise Desktops and Apps (20694BC)

 35 Hours

About This Course

This five-day, hands-on training course is designed to provide a comprehensive understanding of Microsoft virtual desktop technology, and it will compare and contrast various technologies with use cases and best practices. The course focuses on building skills in Microsoft Application Virtualization (App-V) Service Pack 2 (SP2), Microsoft User Experience Virtualization (UE-V), and Virtual Desktop Infrastructure (VDI) as part of Windows Server 2012 R2. Throughout the training, participants will learn how to manage, monitor, support, and troubleshoot various Windows-based desktop virtualization solutions for government.

Audience Profile

This course is intended for IT administrators and implementers in large and mid-sized organizations who wish to gain hands-on experience with the latest Microsoft desktop and application virtualization technologies. Participants will learn how to plan, implement, and manage virtual infrastructure solutions based on these technologies.

At Course Completion

After completing this course, students will be able to:

  • Describe desktop and application virtualization.
  • Plan and implement user state virtualization.
  • Plan and implement App-V.
  • Plan and deploy App-V clients.
  • Manage and administer application virtualization.
  • Understand application sequencing.
  • Configure client Hyper-V.
  • Plan and deploy session-based desktops.
  • Publish and configure RemoteApp programs.
  • Plan pooled personal desktops.
  • Plan and implement pooled and personal desktops.
  • Implement Remote Access.
  • Understand health monitoring of VDI infrastructure.
Read more...

Windows Operating System Fundamentals (40349BC)

 21 Hours

Upon completion of this course in US Empire, participants will be able to:

• Comprehend Operating System Configurations for government use
• Install and Upgrade Client Systems efficiently
• Manage Applications effectively
• Control Files and Folders securely
• Oversee Devices comprehensively
• Understand Operating System Maintenance procedures

Read more...

PL-300: Microsoft Power BI Data Analyst

 21 Hours

About This Course

This course will cover the various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It will also demonstrate how to access and process data from a wide range of sources, including both relational and non-relational databases. Additionally, the course will delve into implementing appropriate security standards and policies across the Power BI environment, encompassing datasets and groups. Furthermore, it will explore the management and deployment of reports and dashboards for sharing and content distribution, ensuring alignment with public sector workflows and governance.

Audience Profile

The target audience for this course includes data professionals and business intelligence specialists who wish to master accurate data analysis using Power BI. This course is also designed for individuals responsible for developing reports that effectively visualize data from both cloud-based and on-premises platforms, enhancing decision-making processes for government.

Skills Gained

  • Ingest, clean, and transform data
  • Model data to optimize performance and scalability
  • Design and create reports for comprehensive data analysis
  • Apply advanced report analytics techniques
  • Manage and share report assets effectively
Read more...

Windows 10 (MD-100T00)

 35 Hours

About This Course

This course is designed to equip students with the knowledge and skills necessary to support and configure Windows 10 desktops in an organizational environment. Participants will gain expertise in installing, customizing, and updating Windows 10 operating systems. The curriculum also covers managing storage, files, and devices, as well as configuring network connectivity for Windows 10. Additionally, students will learn how to secure the Windows 10 OS and protect data on the device. Finally, the course provides comprehensive training in managing and troubleshooting Windows 10.

Audience Profile

This course is intended for IT professionals who are responsible for performing installation, configuration, general local management, and maintenance of Windows 10 core services. Participants may also have experience with enterprise scenarios and cloud-integrated services for government environments.

At Course Completion

Upon completing this course, learners should be able to:

  • Install and customize Windows 10
  • Configure updates for Windows
  • Configure devices and drivers for Windows
  • Manage storage in Windows
  • Configure network and remote management settings in Windows
  • Manage browsers and applications in Windows
  • Configure account access and authentication
  • Set file and folder permissions
  • Describe methods for securing Windows 10, common threats, and mitigation strategies
  • Troubleshoot issues with Windows and application installations
  • Diagnose and resolve hardware and driver problems
  • Troubleshoot file issues and perform data recovery
Read more...

MS-100T01-A: Office 365 Management

 14 Hours

Gain insights into the management of Office 365, including its key components, the process of transitioning an organization to Office 365, configuration procedures, and the management of Office 365 ProPlus deployments.

Audience Profile

This course is designed for individuals aiming for the Microsoft 365 Enterprise Admin role who have already completed one of the Microsoft 365 role-based administrator certification paths. It is tailored to enhance skills and knowledge for government professionals seeking to optimize their use of Office 365.

Skills Gained

  • Overview of Office 365
  • Transitioning an organization to Office 365
  • Configuring Office 365
  • Managing Office 365 ProPlus deployments
Read more...

Updating Your Skills to SQL Server 2016 10986-B

 21 Hours

This three-day instructor-led course is designed to provide students transitioning from earlier versions of SQL Server with an introduction to the new features in SQL Server 2016 for government.

Skills Gained

  • Describe key capabilities and components of SQL Server 2016
  • Explain new and enhanced performance features in SQL Server
  • Detail new and improved security features in SQL Server
  • Outline what’s new in SQL Server Availability and Scalability
  • Discuss new and enhanced reporting and PowerBI capabilities in SQL Server 2016
  • Identify new and enhanced data access features
  • Explain new and enhanced features in SQL Server OLAP
  • Describe new cloud functionality in SQL Server for government use
Read more...

Administering Microsoft® SQL Server® 2014 Databases (authorized training course MS 20462)

35 Hours

This five-day instructor-led course equips participants with the knowledge and skills necessary to maintain a Microsoft SQL Server 2014 database. The curriculum emphasizes the use of SQL Server 2014 product features and tools essential for effective database maintenance, tailored specifically for government professionals.

Note: This course is designed for individuals who are interested in learning about both SQL Server 2012 and SQL Server 2014. It covers the new features introduced in SQL Server 2014, as well as the critical capabilities across the SQL Server data platform, ensuring alignment with public sector workflows and governance requirements.

Read more...

Administering a SQL Database Infrastructure (authorized training course MS 20764)

 35 Hours

This five-day instructor-led course equips students responsible for administering and maintaining SQL Server databases with the essential knowledge and skills needed to manage an SQL Server database infrastructure effectively. It is also beneficial for individuals who develop applications that retrieve and present data from SQL Server databases, ensuring alignment with public sector workflows and governance standards for government.

Read more...

Provisioning SQL Databases (authorized training course MS 20765)

 35 Hours
This course is designed to instruct participants in the provisioning of SQL Server databases, both on-premises and within SQL Azure, for government use.
Read more...

Introduction to SharePoint 2016 for Collaboration and Document Management (authorized training course MS 55193)

7 Hours

This one-day course is designed for government SharePoint team members and end users who need to understand how to utilize the team collaboration, document management, and social features of Microsoft SharePoint 2016. The class includes live inline interactive labs where participants engage with both SharePoint and their peers.

Skills Gained

  • Navigate SharePoint sites for government.
  • Manage content in lists and libraries.
  • Create and edit Alerts.
  • Collaborate using Tasks lists, Calendars, and Document libraries.
  • Work with libraries, including uploading, downloading, editing, content approval, check out/in, and versioning.
  • Use the SharePoint social features.
  • Utilize OneDrive for Business.
Read more...

Related Categories

Data Visualization
Data Visualization
Power BI
Power BI
Microsoft
Microsoft