Courses

INTRODUCTION: This course is aimed at existing users of Power BI, Excel Power Pivot, or SQL Server Analysis Services (SSAS) Tabular, who need to take their data analysis skills to the next level. COURSE AIMS: You will learn how to mine and expose hidden information with the DAX (Data Analysis eXpressions) language. Common business scenarios are covered, highlighting useful DAX patterns that can be implemented and adapted to solve a variety of simple and complex calculations. The theory behind the concepts of DAX will be emphasised through practical examples.

This five-day course will teach you how to plan, configure, and manage the advanced features in a SharePoint 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Students also will learn about business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016. This is the second in a sequence of two courses for IT Professionals and is aligned with the SharePoint 2016 IT Pro certification.

This course is comprised of the following Microsoft Official Curriculum modules: MS-300T01 Managing Office 365 Content Services MS-300T02 Managing SharePoint Online

This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement, and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.

This course provides students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a corporate Windows Server domain environment. The skills that this course details include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity and storage. Students also will learn how to configure security for data, devices, and networks, and maintain, update, and recover Windows 10.

Installing and Configuring Windows 10. This course is designed to provide students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a Windows Server domain corporate environment. These skills include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity and storage. Students will also learn how to configure data security, device security, and network security, and maintain, update, and recover Windows 10. Audience Profile

This course is intended for IT professionals who are interested in: Expanding their knowledge base and technical skills about Windows 7 Client. Acquiring deep technical knowledge of Windows 7. Learning the details of Windows 7 technologies. Focusing on the 'how to' associated with Windows 7 technologies.

Objectives: Tutor led hands on training day covering Excel Formulae. In this course we concentrate on Excel Formulae from a basic level through to advanced – the exercises used through this training are designed to help the candidate master financial modelling whist showing shortcuts and tips to assist with effective use of this spreadsheet software. Who should attend? This course is beneficial for candidates who need a good understanding of formulas and functions.

This course offers a good grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level. Target student: People who intend to design databases from scratch or improve existing Access database skills. Introduction

Course Objective To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level. Target student People who intend to design databases from scratch or improve existing Access databases also covers conversion of databases made in other applications and spreadsheet (flat file) databases. The training also cover the Conversion of databases made in other applications and spreadsheet (flat file) databases. Prerequisites This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

During this intermediate/advanced training day we concentrate on Macros, Database Utilities, Security, and create a Switchboard. Prerequisites: Candidates should have ideally attended Access Level 1 & Level 2 training or have equivalent working knowledge before attending this Access intermediate/advanced training day.

During this advanced training day we concentrate on using Visual Basic for Applications (VBA) thus building on the skills learnt in MS Access L3 training. Prerequisites: Candidates should have ideally attended the Microsoft Access L3 training or have equivalent working knowledge.