Get in Touch

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.
  • Identify the tasks of a data analyst for government.

Module 2: Get Started Building with Power BI for Government

This module introduces you to Power BI, including its building blocks and how they work together. It also prepares 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 for government.
  • Explore how Power BI can enhance the efficiency of government operations.
  • 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 various sources, including Microsoft Excel, relational databases, and NoSQL data stores. You will also learn techniques 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.
  • Retrieve data from a relational database, such as Microsoft SQL Server, for government.
  • Retrieve data from a file, like Microsoft Excel, for government.
  • Retrieve data from applications for government.
  • Retrieve data from Azure Analysis Services for government.
  • Select an appropriate storage mode for government.
  • Address performance issues for government.
  • Resolve data import errors for government.

Lessons

  • Introduction

  • Retrieve Data from Files for Government

  • Retrieve Data from Relational Data Sources for Government

  • Create Dynamic Reports with Parameters for Government

  • Retrieve Data from a NoSQL Database for Government

  • Retrieve Data from Online Services for Government

  • Select a Storage Mode for Government

  • Retrieve Data from Azure Analysis Services for Government

  • Address 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 complex models, 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 for government.
  • Apply user-friendly value replacements for government.
  • Profile data to gain insights into specific columns before using them for government.
  • Evaluate and transform column data types for government.
  • Apply data shape transformations to table structures for government.
  • Combine queries for government.
  • Apply user-friendly naming conventions to columns and queries for government.
  • Edit M code in the Advanced Editor for government.

Lessons

  • Introduction

  • Shape Initial Data for Government

  • Simplify 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 end up with numerous tables to manage. Building an effective data model involves simplifying this complexity. This module covers the terminology and implementation of star schemas, the importance of choosing the correct data granularity for performance and usability, and techniques to improve performance in Power BI data models.

Learning Objectives

In this module, you will:

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

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 move on to more complex measures based on other measures in the model. You will also 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.
  • Create simple measures for government.
  • Create compound measures for government.
  • Create quick measures for government.
  • Describe the similarities of and differences between calculated columns and measures for government.

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 understand row context, which is used to evaluate calculated column formulas, and 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.
  • Create calculated columns for government.
  • Identify row context for government.
  • Determine when to use a calculated column in place of a Power Query custom column for government.
  • 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 understand the concept 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.
  • Use common DAX time intelligence functions for government.
  • Create useful intelligence calculations for government.

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 variables to improve performance and troubleshooting for government.
  • Improve performance by reducing cardinality levels for government.
  • Optimize DirectQuery models with table-level storage for government.
  • Create and manage aggregations for government.

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

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

Learning Objectives

In this module, you will:

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

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 specific requirements and expectations. Some filtering techniques apply at design time, while others are relevant at report consumption time (in reading view). The key is ensuring your report design allows users to intuitively narrow down to the data points of interest.

Learning Objectives

In this module, you will:

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

Lessons

  • Introduction to Designing Reports for Filtering for 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 refine your reports to make them more user-friendly.

Learning Objectives

In this module, you will:

  • 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.
  • Use specialized visuals for government.

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, group and bin data for analysis, conduct time series analysis, and work with advanced analytic features such as Quick Insights, AI Insights, and the Analyze feature.

Learning Objectives

In this module, you will:

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

Lessons

  • Introduction to Analytics for Government

  • Explore Statistical Summaries for Government

  • Identify Outliers with Power BI Visuals for Government

  • Group and Bin Data for Analysis for 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

This module teaches you 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.
  • 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.

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 multiple reports. This module also covers reducing administrative overhead 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.
  • Configure a scheduled refresh for a dataset 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.

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 distinct from Power BI reports. They allow report consumers to create a single, personalized artifact of directed data. Dashboards can be composed of pinned visuals taken from different reports, while a Power BI report uses data from a single dataset.

Learning Objectives

In this module, you will:

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

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 set of reports that target data for specific users. 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.
  • Configure row-level security using a dynamic method for government.

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 within cloud environments.

Specifically:

  • An understanding of fundamental data concepts.

  • Proficiency in handling relational data in the cloud.

  • Proficiency in managing non-relational data in the cloud.

  • Familiarity with data analysis and visualization principles.

To acquire these prerequisites and a deeper understanding of working with data in Azure, individuals are encouraged to complete the Microsoft Azure Data Fundamentals course before enrolling in this program.

 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.

Testimonials (1)

The subject was taught in an engaging way, making me want to learn more.

kgotla Moncho - Martin Engineering Africa
Course - PL-300T00: Microsoft Power BI Data Analyst

Upcoming Courses

PL-300T00: Microsoft Power BI Data Analyst

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

PL-300T00: Microsoft Power BI Data Analyst

2026-05-29 09:30
21 hours
Bismarck, ND - Juniper Workantile
$ 2109 (Online)
$ 3909 (Classroom)

PL-300T00: Microsoft Power BI Data Analyst

2026-06-12 09:30
21 hours
Boise, ID - Regus - Boise Downtown
$ 2109 (Online)
$ 3909 (Classroom)

PL-300T00: Microsoft Power BI Data Analyst

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

PL-300T00: Microsoft Power BI Data Analyst

2026-07-10 09:30
21 hours
Burlington, VT – Regus at Williston
$ 2109 (Online)
$ 3909 (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, you will be able to: - Describe the processes involved in planning and applying a troubleshooting methodology for government use with Windows 10. - Troubleshoot startup issues and operating system services on a Windows 10 PC used in government environments. - Perform system recovery procedures for government systems. - Resolve issues related to hardware devices and device drivers in a government setting. - Administer Windows 10 devices within government agencies. - Troubleshoot network connectivity issues for government networks. - Configure Windows 10 devices using Group Policy for government compliance. - Configure and troubleshoot user settings for government employees. - Configure and troubleshoot resource access for government systems. - Implement remote connectivity solutions for government operations. - Deploy and troubleshoot applications in a government context. - Maintain Windows 10 devices to ensure ongoing reliability and security for government use.
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 responsibilities are expanding to include database elements. The course covers essential database concepts, including database types, languages, and design methodologies.

Audience Profile

The primary audience for this course includes professionals who are moving into a database role or whose job duties now encompass database technologies.

At Course Completion

Upon completing this course, students will be able to:
• Describe key database concepts within the context of SQL Server 2016
• Identify and explain the database languages used in SQL Server 2016
• Apply data modeling techniques effectively
• Understand and implement normalization and denormalization techniques
• Recognize different relationship types and their impacts on database design
• Analyze how database design influences performance
• Utilize commonly employed database objects

This course is tailored to provide comprehensive training for government professionals seeking to enhance their database management skills.
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 provide comprehensive training on how 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, business intelligence solutions, Enterprise Content Management, web content management infrastructure, and app development. Additionally, participants will learn how to develop and implement a governance plan for government, as well as perform an upgrade or migration to SharePoint 2016.

This 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 tailored for experienced IT Professionals who are interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations either 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 possess equivalent knowledge and experience before enrolling in this course. The minimally qualified candidate typically:

  • Has a working knowledge of, and preferably hands-on experience with, Microsoft SharePoint Online.
  • Is familiar with SharePoint Server workloads.
  • Has experience with business continuity management, including data backup, restoration, and high availability.
  • Has experience with authentication and security technologies.
  • Has 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 Server solutions that include 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 for 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.
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 overview of Microsoft virtual desktop technology. The course will compare and contrast various technologies with specific use cases and best practices. Participants will gain skills in managing, monitoring, supporting, and troubleshooting Windows-based desktop virtualization solutions, including 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. This training is tailored to align with the needs and workflows for government IT professionals.

Audience Profile

This course is intended for IT administrators and implementers in large and mid-sized organizations, including those in the public sector, 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 concepts and their benefits.
  • Plan and implement user state virtualization for efficient data management.
  • Plan and deploy App-V to streamline application delivery.
  • Configure and manage App-V clients effectively.
  • Administer and maintain application virtualization environments.
  • Understand the process of application sequencing to ensure compatibility and performance.
  • Set up client Hyper-V for enhanced virtualization capabilities.
  • Plan and deploy session-based desktops for shared resource optimization.
  • Publish and configure RemoteApp programs for seamless user experience.
  • Develop strategies for pooled personal desktops to enhance user productivity.
  • Implement pooled and personal desktop solutions for diverse organizational needs.
  • Configure Remote Access to ensure secure connectivity.
  • Monitor the health of VDI infrastructure to maintain optimal performance and reliability.
Read more...

Windows Operating System Fundamentals (40349BC)

 21 Hours
Upon completion of this course in US, participants will be able to: • Understand operating system configurations for government systems. • Install and upgrade client systems. • Manage applications effectively. • Manage files and folders securely. • Manage devices efficiently. • Understand the principles of operating system maintenance.
Read more...

Active Directory® Services with Windows Server® (authorized training MS 10969)

 35 Hours

This 5-day Microsoft Official Course offers hands-on instruction and practice in administering Active Directory technologies for government in Windows Server 2012 and Windows Server 2012 R2. Participants will gain the skills necessary to better manage and protect data access and information, simplify deployment and management of identity infrastructure, and provide more secure access to data. The course covers key features such as Active Directory Domain Services (AD DS), Group Policy, Dynamic Access Control (DAC), Work Folders, Workplace Join, Certificate Services, Rights Management Services (RMS), Federation Services, and the integration of on-premises environments with cloud-based technologies like Windows Azure Active Directory. Practical learning is enhanced through hands-on exercises in a virtual lab environment.

Audience:

This course is designed for Information Technology (IT) Professionals who have experience with Active Directory Domain Services (AD DS) and are seeking to expand their knowledge and skills using Access and Information Protection technologies in Windows Server 2012 and Windows Server 2012 R2. The target audience typically includes:

  • AD DS Administrators looking to deepen their expertise in the latest Access and Information Protection technologies with Windows Server 2012 and Windows Server 2012 R2.
  • System or Infrastructure administrators with foundational AD DS experience who are interested in building on that knowledge and cross-training into advanced Active Directory technologies in Windows Server 2012 and Windows Server 2012 R2.
  • IT Professionals who have completed the 10967A: Fundamentals of a Windows Server Infrastructure course and are looking to expand their Active Directory knowledge.
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...

MS-100T01-A: Office 365 Management

 14 Hours

This course provides a comprehensive overview of Office 365 Management, including the key components of Office 365, strategies for transitioning an organization to Office 365, configuration procedures, and management techniques for Office 365 ProPlus deployments.

Audience Profile

This course is tailored for individuals who are aspiring to the Microsoft 365 Enterprise Admin role and have already completed one of the Microsoft 365 role-based administrator certification paths.

Skills Gained

  • Understand the overview of Office 365
  • Plan and execute an organization's transition to Office 365
  • Configure Office 365 settings and services
  • Manage Office 365 ProPlus deployments effectively

This training is designed to equip participants with the necessary skills and knowledge for government organizations to optimize their use of Office 365, ensuring efficient and secure operations.

Read more...

Updating Your Skills to SQL Server 2016 10986-B

 21 Hours

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

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 measures in SQL Server
  • Outline advancements in SQL Server Availability and Scalability
  • Discuss new and enhanced reporting and Power BI capabilities in SQL Server 2016
  • Identify new and enhanced data access features
  • Describe new and improved functionalities in SQL Server OLAP
  • Explain the 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 database maintenance. Note: This course is tailored for individuals interested in learning about SQL Server 2012 or SQL Server 2014. It highlights the new features introduced in SQL Server 2014, while also covering critical capabilities across the SQL Server data platform. The training is designed to support effective database management and aligns with best practices for government agencies.
Read more...

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

 35 Hours
This five-day instructor-led course is designed to equip professionals responsible for administering and maintaining SQL Server databases with the necessary knowledge and skills to effectively manage an SQL Server database infrastructure. It is also beneficial for those who develop applications that retrieve and present data from SQL Server databases, ensuring alignment with public sector workflows and governance requirements for government operations.
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, ensuring alignment with best practices for government.
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