Training

Home/Services/Training

Analyzing Data with Power BI

TOTAL DAYS: 4 | TOTAL HOURS: 26

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

Data Analysis & Visualization with Microsoft Excel (D.A.V.E.)

TOTAL DAYS: 2 | TOTAL HOURS: 13

Data is the lifeblood of every business and understanding data through descriptive, predictive, and prescriptive analytics is critical to driving business success in a data driven economy. Creating great visualizations is another key to extracting maximum value out of their data. This 2-day class teaches you all these techniques and more.

• Data Analysis Fundamentals
• How to Visualize Data in Excel
• Using Formulas and Functions to analyze data
• Analyzing data with Pivot Tables
• Presenting Dashboards
• Creating Geospatial Visualizations
• Statistical Analysis
• Getting and Transforming Data
• Modelling Data with Power Pivot
• Presenting Insight with Reports

Designing an Azure Data Solution

TOTAL DAYS: 2 | TOTAL HOURS: 13

In this course, the students will design various data platform technologies into solutions that are in line with business and technical requirements. This can include on-premises, cloud, and hybrid data scenarios which incorporate relational, NoSQL, or Data Warehouse data. They will also learn how to design process architectures using a range of technologies for both streaming and batch data. The students will also explore how to design data security, including data access, data policies, and standards. They will also design Azure data solutions, which includes the optimization, availability, and disaster recovery of big data, batch processing, and streaming data solutions.

Get Going With QuickBooks 2018 for Windows

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Benefits: First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2018.

Prerequisites: You can successfully complete this course without any prior software knowledge or computer experience. A basic understanding of the computer operating system you are using is recommended.

Implementing an Azure Data Solution

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

In this course, the students will implement various data platform technologies into solutions that are in-line with business and technical requirements, including on-premises, cloud, and hybrid data scenarios incorporating both relational and NoSQL data. They will also learn how to process data using a range of technologies and languages for both streaming and batch data.

The students will also explore how to implement data security, including authentication, authorization, data policies, and standards. They will also define and implement data solution monitoring for both the data storage and data processing activities. Finally, they will manage and troubleshoot Azure data solutions which includes the optimization and disaster recovery of big data, batch processing, and streaming data solutions.

Integrated Project Management 2016

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Managing Modern Desktops

TOTAL DAYS: 5 | TOTAL HOURS: 32.5

In this course, students will learn how to plan and implement an operating system deployment strategy using modern deployment methods, as well as how to implement an update strategy. Students will be introduced to key components of modern management and co-management strategies. This course also covers what it takes to incorporate Microsoft Intune into your organization. Students will also learn about methods for deployment and management of apps and browser-based applications. Students will be introduced to the key concepts of security in modern management including authentication, identities, access, and compliance policies. Students will be introduced to technologies such Azure Active Directory, Azure Information Protection and Windows Defender Advanced Threat Protection, as well as how to leverage them to protect devices and data.

Master Intuit QuickBooks Online: from Setup to Tax Time

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

Microsoft 365 Identity and Services

TOTAL DAYS: 5 | TOTAL HOURS: 32.50

This course covers three central elements of Microsoft 365 enterprise administration – Microsoft 365 tenant and service management, Office 365 management, and Microsoft 365 identity management. In Microsoft 365 tenant and service management, you will examine all the key components that must be planned for when designing your Microsoft 365 tenant. Once this planning phase is complete, you will learn how to configure your Microsoft 365 tenant, including your organizational profile, tenant subscription options, component services, user accounts and licenses, and security groups. Finally, you will learn how to manage your tenant, which includes the configuration of tenant roles and managing your tenant health and services.

With your Microsoft 365 tenant now firmly in place, you will examine the key components of Office 365 management. This begins with an overview of Office 365 product functionality, including Exchange Online, SharePoint Online, Microsoft Teams, Microsoft Power Platform, additional product resources, and device management. You will then transition to configuring Office 365, with a primary focus on configuring Office client connectivity. Finally, you will examine how to manage Microsoft 365 Apps for enterprise (formerly Office 365 ProPlus) deployments, from user-driven client installations to centralized deployments. You will wrap up this section by learning how to configure Office Telemetry and Microsoft Analytics.

The course concludes with an in-depth examination of Microsoft 365 identity synchronization, with a focus on Azure Active Directory Connect. You will learn how to plan for and implement Azure AD Connect, how to manage synchronized identities, and how to implement password management in Microsoft 365 using multi-factor authentication and self-service password management. This section wraps up with a comprehensive look at implementing application and external access. You will learn how to add and manage applications in Azure Active Directory, including how to configure multi-tenant applications. You will then examine how to configure Azure AD Application Proxy, including how to install and register a connector and how to publish an on-premises app for remote access. Finally, you will examine how to design and manage solutions for external access. This includes licensing guidance for Azure AD B2B collaboration, creating a collaborative user, and troubleshooting a B2B collaboration.

Microsoft 365 Messaging

TOTAL DAYS: 5 | TOTAL HOURS: 32.5

This course examines the key elements of Microsoft 365 messaging administration, including message transport and mail flow, messaging security, hygiene, and compliance, messaging infrastructure, and hybrid messaging. This course is designed for IT Professionals who deploy and manage the messaging infrastructure for Microsoft 365 in their organization.