DA-100T00 Analyzing Data with Power BI

TOTAL DAYS: 4 | TOTAL HOURS: 28

DA-100T00 Analyzing Data with Power BI

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 Analysis & Visualization with Microsoft Excel (D.A.V.E.)

Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of “big data” has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.

Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.

Microsoft® Excel® is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-backed visualizations to show insights and trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.

Completion of this course will earn 1.15 CEUs.

DP-050T00 Migrate SQL workloads to Azure

TOTAL DAYS: 2 | TOTAL HOURS: 16

DP-050T00 Migrate SQL workloads to Azure

In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. They will also explore each stage of the data platform modernization process and define what tasks are involved at each stage, such as the assessment and planning phase. Students will also learn the available migration tools and how they are suitable for each stage of the data migration process. The student will learn how to migrate to the three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Database Managed Instances. The student will learn the benefits and limitations of each target platform and how they can be used to fulfil both business and technical requirements for modern SQL workloads. The student will explore the changes that may need to be made to existing SQL based applications, so that they can make best use of modern data platforms in Azure.

DP-100T01 Designing and Implementing a Data Science Solution on Azure

TOTAL DAYS: 3 | TOTAL HOURS: 24

DP-100T01 Designing and Implementing a Data Science Solution on Azure

Gain the necessary knowledge about how to use Azure services to develop, train, and deploy, machine learning solutions. The course starts with an overview of Azure services that support data science. From there, it focuses on using Azure’s premier data science service, Azure Machine Learning service, to automate the data science pipeline. This course is focused on Azure and does not teach the student how to do data science. It is assumed students already know that.

DP-300T00 Administering Relational Databases on Microsoft Azure

TOTAL DAYS: 1 | TOTAL HOURS: 6.5

DP-300T00 Administering Relational Databases on Microsoft Azure

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

DP-900T00 Microsoft Azure Data Fundamentals

TOTAL DAYS: 1 | TOTAL HOURS: 8

DP-900T00 Microsoft Azure Data Fundamentals

In this course, students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.

Excel 2013/2016 Programming with VBA

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Excel 2013/2016 Programming with VBA

Prerequisite

Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.

Completion of this course will earn 1.725 CEUs.

Integrated Project Management 2016

TOTAL DAYS: 3 | TOTAL HOURS: 19.5

Integrated Project Management 2016

Completion of this course will earn 1.725 CEUs.

MB-300T00 Microsoft Dynamics 365: Core Finance and Operations

TOTAL DAYS: 2 | TOTAL HOURS: 14

This course discusses: Core common features of Dynamics 365 Finance, Core configuration in Dynamics 365 Finance, Data migration and preparing for go-live with Dynamics 365. Finance Organizations use Dynamics 365 Finance to reduce operational costs and rapidly respond to changing business needs. This solution lets organizations achieve these goals. This course discusses core components and configuration of Microsoft Dynamics 365 Finance, and data migration and preparing for go-live.

MD-100T00 Windows 10

TOTAL DAYS: 5 | TOTAL HOURS: 40

MD-100T00 Windows 10

In this course, students will learn how to support and configure Windows 10 desktops in an organizational environment. Students will develop skills that include learning how to install, customize, and update Windows 10 operating systems. Students will learn how to managing storage, files, and devices as well as how to configure network connectivity for Windows 10. Students will also learn how to secure the Windows 10 OS and protect the data on the device. Finally, students will learn how to manage and troubleshoot Windows 10.