"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Courses


hey this is here

INTRODUCTION This 4 day course is intended for IT professionals, business analysts, and developers who need to implement data transfer, or ETL (Extract, Transform, and Load), solutions by using Microsoft SQL Server 2016 or 2017 Integration Services. Students will learn about the SQL Server Data Tools (SSDT) development environment to create SSIS projects and packages, work with Control Flow Tasks, and design Data Flows using a variety of transformations and data sources/destinations (including SQL Server databases, flat files, and Excel). Delegates will also learn about SSIS project and package management, deployment, debugging, error handling, and logging techniques. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises. With the course structure being fully modularised, customised versions of this course can also be devised and delivered. For example, clients interested in only the essentials of SSIS could attend just the first 3 days of the course, omitting the Advanced SSIS Concepts ordinarily covered on day 4. PREREQUISITES No prior knowledge of the subject matter is assumed. However, students should ideally be familiar with basic programming concepts, and understand the fundamental design of relational databases and data normalization. Some prior working knowledge of SQL Server 2017 (or earlier), and the use of SQL Server Management Studio, is assumed. Attendees should additionally be familiar with the SQL query language, in particular the SELECT, UPDATE, INSERT, and DELETE statements.

FURTHER DETAILS
hey this is here

Content and overview: Module One – Getting Started with Power BI – the essentials Module Two - Advanced features & techniques to optimise reports and the consumer’s experience Module Three – Using the Power BI Service

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS
hey this is here
hey this is here

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

FURTHER DETAILS
hey this is here

This course recommended rather than course M10978 'Introduction to Azure for Developers' due to the rapid changes that occur with Azure and that Microsoft have not updated course M10978 to reflect those Changes This course is intended for students who have experience building vertically scaled applications. Students will also have experience with the Microsoft Azure platform and a basic understanding of the services offered.

FURTHER DETAILS
hey this is here

An Excel dashboard is a visual dynamic interface showing a summary of consolidated data on a single screen. On this course you will learn how to create Dashboards using the existing tools in Excel. You don’t need any knowledge of Visual Basic macros and there is no need for extra ‘add-ins’. Some experience of using Tables and basic PivotTables would be advantageous. Suitable for Excel 2013 and 2016 users.

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS
hey this is here

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

FURTHER DETAILS
hey this is here

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.

FURTHER DETAILS
hey this is here

What is the Power BI Service? The Microsoft Power BI Service is sometimes referred to as Power BI online or app.powerbi.com. Power BI helps you stay up to date with the information that matters to you. With the Power BI Service, dashboards help you keep a finger on the pulse of your business. Your dashboards display tiles that you can click to open reports for exploring further. Connect to multiple datasets to bring all the relevant data together in one place. If you have important data in Excel or CSV files, you can create a Power BI dashboard to stay informed anywhere and share insights with others. Do you have a subscription to a SaaS application like Salesforce? Get a head start by connecting to Salesforce to automatically create a dashboard from that data or check out all the other SaaS apps you can connect to.

FURTHER DETAILS