1737 Basic courses in Sheffield delivered Live Online

Duration 2.75 Days 16.5 CPD hours This course is intended for This course is designed for a person with an understanding of project management concepts, as well as general desktop computer skills, and who will be responsible for creating and maintaining project plans. This course will give you the fundamental understanding as well as acquiring the advanced knowledge and skills needed to update a project plan in Microsoft Project during the execution, monitoring, and controlling phases of a project. Overview Identify project management concepts and navigate Microsoft 2. 2. Project Professional. Create a new project plan. Add tasks to a project. Manage task relationships within a project. Manage project resources. fnalize a project plan. Update a project plan. Generate project views to manage a project. Create project reports to share a project's status. Reuse project plan information. Work with multiple projects. This course will familiarize the user with the basic features and functions of MS Project so that it can be used effectively and efficiently in a real-world environment. MS project will give the ability to project managers to update a project plan in Project during the execution, monitoring, and controlling phases of a project GETTING STARTED WITH MICROSOFT PROJECT Topic A: Identify Project Management Concepts Topic B: Navigate in the Microsoft Project Desktop environment DEFINING A PROJECT Topic A: Create a New Project Plan File Topic B: Set Project Plan Options Topic C: Assign a Project Calendar ADDING PROJECT TASKS Topic A: Add Tasks to a Project Plan Topic B: Enter Task Duration Estimates MANAGING TASKS Topic A: Create a Work Breakdown Structure Topic B: Define Task Relationships Topic C: Schedule Tasks MANAGING PROJECT RESOURCES Topic A: Add Resources to a Project Topic B: Create a Resource Calendar Topic C: Enter Costs for Resources Topic D: Assign Resources to Tasks Topic E: Resolve Resource Conflicts FINALIZING A PROJECT PLAN Topic A: Optimize a Project Plan Topic B: Set a Baseline Topic C: Share a Project Plan UPDATING A PROJECT PLAN Topic A: Enter Task Progress Topic B: Enter Overtime Work Topic C: Edit Tasks Topic D: Update Cost Rate Tables Topic E: Update a Baseline VIEWING PROJECT PROGRESS Topic A: Use View Commands Topic B: Add a Custom Field Topic C: Create Custom Views Topic D: Format and Share the Timeline View REPORTING ON PROJECT PROGRESS Topic A: View Built-in Reports Topic B: Create Custom Reports Topic C: Create a Visual Report REUSING PROJECT PLAN INFORMATION Topic A: Create a Project Plan Template Topic B: Share Project Plan Elements with Other Plans WORKING WITH MULTIPLE PROJECTS Topic A: Share Resources Topic B: Link Project Plans Additional course details: Nexus Humans Microsoft Project training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Project course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is recommended for technical professionals who automate, orchestrate, and troubleshoot Check Point secured environments. Overview Explain how automation and orchestration work together Understand the key drivers for incorporating automation and orchestration into security management Execute a shell script that demonstrates how to build a comprehensive Security Policy. Recognize how the Check Point API framework integrates with R80 Security Management to support automation and orchestration of daily tasks Describe Check Point API tools and demonstrate how they are used to manage Check Point Security Management solutions Demonstrate how to define new objects and modify existing ones by using the Check Point API The goal of this course is to provide an understanding of the advanced concepts and skills necessary to automate and orchestrate tasks relating to managing Check Point Security Policies Course Ouline Explain how automation and orchestration work together Understand the key drivers for incorporating automation and orchestration into security management Execute a shell script that demonstrates how to build a comprehensive Security Policy. Recognize how the Check Point API framework integrates with R80 Security Management to support automation and orchestration of daily tasks Describe Check Point API tools and demonstrate how they are used to manage Check Point Security Management solutions Demonstrate how to define new objects and modify existing ones by using the Check Point API Demonstrate how to create API commands to efficiently maintain the Check Point Security Management Server database Demonstrate how to use different methods to update the database with API commands Become familiar with client-side and server-side scripting and scripting languages Understand how to use the Bash shell to develop APIs Recognize and describe many of the open source tools that are available to assist with API development Demonstrate how to use a custom REST application to update the database of a Security Management Server Demonstrate how to use Postman to manage the Security Policy database through the Check Point API Understand what steps to take to troubleshoot and debug API scripts Demonstrate basic troubleshooting techniques by reviewing debugging messages in various forms Understand how to use self-service portal capabilities to provide general IT services Recognize how automation tools work with Check Point APIs to automate security management tasks and orchestrate workflow behind service portals Demonstrate common tasks that are automated in a Web portal to manage the Security Policy LAB Exercises Demonstrate Check Point automation and orchestration Manage objects using the Check Point API Create a management API shell script Use a variety of methods to execute API commands Use a custom REST tool for API calls Use Postman for API calls Debug the Check Point management API Automate tasks using a Check Point API enabled Web portal Additional course details: Nexus Humans CCAS Check Point Certified Automation Specialist training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CCAS Check Point Certified Automation Specialist course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for Students in this course are interested in Microsoft 365 development platform or in passing the Microsoft 365 Developer Associate certification exam. Students should also have 1-2 years experience as a developer. This course assumes students know how to code and have a basic understanding of REST APIs, JSON, OAuth2, OData, OpenID Connect, Microsoft identities including Azure AD and Microsoft accounts, Azure AD B2C, and permission/consent concepts. Overview Implementing Microsoft Identity Working with Microsoft Graph Determining workload platform targets Integration Points, including Microsoft Teams, Office Add-ins, and SharePoint Framework This course covers five central elements of Microsoft 365 platform ? implementing Microsoft Identity, working with Microsoft Graph, extending and customizing SharePoint, extending Teams, and extending Office. In this course, students will learn how to implement Microsoft Identity and work with Microsoft Graph. Students will also gain the knowledge on UI elements (including Adaptive Cards and UI Fabric), Integration Points (including Microsoft Teams, Office Add-ins, SharePoint Framework, Actionable Messages), and determining workload platform targets. In implementing Microsoft Identity, students will learn to implement Microsoft identity including registering an application, implanting authentication, configuring permissions to consume an API, and creating a service to access Microsoft Graph. In working with Microsoft Graph, students will learn how to access user data, explore query parameters, manage a group lifecycle, access files, and optimize network traffic using Microsoft Graph. In extending and customizing SharePoint, students will learn about SharePoint Framework web parts, extensions, and how to package and deploy a SPFx solution. In extending Teams, students will look at the components of a Teams App, work with webhooks, tabs, and conversational bots. In extending Office, students work with Office Add-ins, task pane add-ins, JavaScript APIs, Office UI Fabric, and actionable messages with adaptive cards. Implement Microsoft Identity Microsoft Identity platform Register an Application Implement Authentication Configure Permissions to consume an API Implement Authorization to consume an API Implement Authorization in an API Create a Service to access Microsoft Graph Work with Microsoft Graph What is Microsoft Graph Access user data from Microsoft Graph Data usage with query parameters Manage a group lifecycle on Microsoft Graph Access files with Microsoft Graph Optimize network traffic Extend and Customize SharePoint SharePoint Framework web parts SharePoint Framework extensions Package and deploy a SPFx solution Consumption of Microsoft Graph Consumption of 3rd party APIs secured with Azure AD from within SPFx Web Parts as Teams Tabs Branding and theming in SharePoint Extend Teams Microsoft Teams App Webhooks in Microsoft Teams Tabs in Microsoft Teams Messaging extensions in Microsoft Teams Conversational bots in Microsoft Teams Extend Office Office Add-ins Office JS APIs Customization of Add-ins Testing, debugging, and deployment options Actionable message Additional course details: Nexus Humans MS-600T00 Building Applications and Solutions with Microsoft 365 Core Services training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the MS-600T00 Building Applications and Solutions with Microsoft 365 Core Services course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This is an intermediate and beyond level SQL course geared for experienced end users, data scientists, business analysts, application developers and database administrators. Students should have recently attended a basic SQL class or have equivalent experience. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment led by our expert practitioner, attendees will learn advanced skills needed to: Advanced Query Techniques Manipulating Table Data Using SQL's Data Manipulation Language (DML) User-Defined Functions Stored Procedures Triggers A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. Next Level SQL explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work in this course is ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, MySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Advanced Query Techniques Join inner outer (Left, Right, Full) Subqueries Simple Correlated Using the Exists Operator Tips for Developing Complex Queries Performing Set Operations Aggregating Results Using Group by Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) Inserting Data into Tables Updating Existing Data Deleting Records Truncating Tables Implementing Data Integrity with Transactions Beginning Explicit Transactions Committing Transactions Rolling Back Transactions User-Defined Functions Definition and Benefits of Use CREATE FUNCTION Syntax RETURN Clause and the RETURNS Statement Scalar vs. Table Functions Comparison with Stored Procedures Returning Scalar Values and Tables ALTER and DROP FUNCTION Stored Procedures Definition and Benefits of Use CREATE PROCEDURE Syntax Variables and Parameters Control of Program Flow ALTER and DROP PROCEDURE Implementation Differences Triggers Definition and Benefits of Use Alternatives (e.g., Constraints) CREATE TRIGGER Syntax Trigger Types 'Inserted' (or 'NEW') and 'Deleted' (or 'OLD') Tables Event Handling and Trigger Execution ALTER and DROP TRIGGER Additional course details: Nexus Humans Advanced SQL Programming (TTSQL005) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Advanced SQL Programming (TTSQL005) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for application programmers who need to write embedded SQL COBOL or PL/I programs in either a DB2 9 or DB2 10 for z/OS environment. Overview Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution. CV720G;CF82G;DB2 Concepts Identify DB2 family products Explain DB2 workstation component functions Identify DB2 objects Identify the key differences between static SQL and other application alternatives for accessing DB2 data Program Structure I Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs Effectively communicate with DB2 when processing NULL values and determining success of statement execution Demonstrate use of DB2 coding aids Code CONNECT statements within an application program Identify connection types and impacts on a unit of work Program for the Call Attach Facility (CAF) Program Preparation Identify the additional steps necessary to prepare a program that contains embedded SQL for execution Describe the functions of the DB2 PRECOMPILE and BIND processes Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements Program Structure II Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs Issue positioned UPDATE and DELETE statements Identify how scrollable cursors can be used Recovery and Locking Concepts Define a unit of recovery Identify the basic locking strategies used by DB2 Dynamic SQL Introduction Describe the difference between static and dynamic SQL List the types of dynamic statements Code dynamic SQL in a program Managing Test Data Identify methods to insert data into a table Use the LOAD or IMPORT utility Identify the purpose of the RUNSTATS utility Identify the purpose of the REORG utility Performance Considerations Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts Identify the access paths available to DB2 List common causes of deadlocks and avoid such causes when possible Use the EXPLAIN tools as aids to develop applications that emphasize performance Additional course details: Nexus Humans CV722 IBM DB2 11 for z/OS Application Programming Workshop training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CV722 IBM DB2 11 for z/OS Application Programming Workshop course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Excel Data Analysis Course Overview The Excel Data Analysis course is designed to equip learners with the essential skills needed to analyse and interpret data using Microsoft Excel. This course covers a range of tools and techniques that are vital for processing, summarising, and visualising data. Learners will explore functions, pivot tables, charts, and data manipulation strategies that will enable them to work efficiently with data sets. By the end of the course, learners will be able to transform raw data into meaningful insights, making it an invaluable skill for professionals across various industries. Whether you're looking to improve your data skills or progress in your career, this course offers the foundational knowledge required for data analysis in Excel. Course Description This course delves into the core aspects of Excel Data Analysis, starting with basic functions and advancing to complex data manipulation techniques. Learners will explore how to create and manage pivot tables, perform data filtering, and apply functions such as VLOOKUP and INDEX MATCH. Visualisation tools like charts and graphs will be covered, enabling learners to present their findings in a clear and impactful way. Additionally, learners will be introduced to data modelling, conditional formatting, and advanced formula techniques that will enhance their data analysis capabilities. The course is structured to provide a comprehensive understanding of Excel’s data analysis features, building competency for a wide range of practical applications in both personal and professional settings. Excel Data Analysis Curriculum Module 01: Introduction to Excel for Data Analysis Module 02: Using Excel Functions for Data Manipulation Module 03: Working with Pivot Tables and Pivot Charts Module 04: Data Visualisation: Creating Charts and Graphs Module 05: Advanced Excel Functions for Complex Data Analysis Module 06: Data Filtering and Sorting Techniques Module 07: Conditional Formatting for Data Insights Module 08: Introduction to Data Modelling and Forecasting Module 09: Data Analysis Best Practices and Case Studies (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to advance in data-centric roles. Beginners with an interest in data analysis and Excel. Anyone looking to improve their Excel knowledge for career development. Career Path Data Analyst Business Analyst Financial Analyst Marketing Analyst Operations Manager Administrative Assistant Project Manager Research and Development Analyst

Learn to Code HTML, CSS, Javascript: Guide for Beginners Course Overview This course offers a comprehensive introduction to HTML, CSS, and JavaScript, designed for those looking to build a strong foundation in web development. Covering the essential web technologies, it equips learners with the skills to create fully functional websites and interactive web pages. From understanding basic structure and styling to mastering advanced JavaScript concepts, this course ensures that learners develop a solid understanding of how modern websites are built and maintained. By the end of the course, learners will be confident in their ability to build, style, and add functionality to websites, preparing them for a variety of web development roles. Course Description "Learn to Code HTML, CSS, and JavaScript: Guide for Beginners" takes learners through every stage of web development, starting with the core technologies: HTML, CSS, and JavaScript. It covers the fundamentals and gradually advances to more sophisticated techniques, helping learners build their skills step by step. The course explores HTML structure, CSS styling, and JavaScript logic, covering essential areas such as strings, operators, and control flow. In addition to these core concepts, learners will delve into client-side validations, error handling, and data visualisation. By the end of the course, students will be equipped to create professional websites and publish them for live use, with a full understanding of front-end development. Learn to Code HTML, CSS, Javascript: Guide for Beginners Curriculum Module 01: Getting Started Module 02: Setting up Development Environment Module 03: HTML Fundamentals Module 04: HTML Intermediate Module 05: HTML Advanced Module 06: HTML Expert Module 07: HTML Website Project Module 08: CSS Fundamentals Module 09: CSS Intermediate Module 10: CSS Advanced Module 11: CSS Expert Module 12: CSS Website Project Module 13: JavaScript Getting Started Module 14: JavaScript Fundamentals Module 15: Strings Module 16: Operators Module 17: Conditional Statements Module 18: Control Flow Statements Module 19: Functions Module 20: Data Visualisation (Google Charts) Module 21: Error Handling Module 22: Client-side Validations Module 23: Publish Your Website for Live (See full curriculum) Who is this course for? Individuals seeking to learn web development. Professionals aiming to enhance their web development skills. Beginners with an interest in building websites. Anyone looking to enter the tech industry or web development field. Career Path Front-End Developer Web Developer Web Designer UI/UX Developer JavaScript Developer Full-Stack Developer Website Project Manager Digital Marketer

Foundation Day Training in Clinical Hypnosis Refresh. Practise. Connect. Transform. Whether you're just starting your journey in clinical hypnosis or you're a graduate looking to refresh and refine your skills, our Foundation Day Training is the perfect opportunity to reconnect with the core techniques that make hypnosis such a powerful therapeutic tool. 🔁 For Graduates: Reignite your confidence, polish your technique, and deepen your understanding of trance work in a supportive and hands-on environment. 🎓 For Trainees: This immersive day is a practical companion to your eLearning journey. It brings the theory to life with live demonstrations, peer-to-peer hypnotic practice, and real-time feedback—your chance to induce trance for the very first time! 🌀 What You’ll Learn and Practise: Trance Inductions & Deepeners – Multiple approaches, techniques, and live demonstrations. Building Confidence – For both you and your clients. Consultation Skills – Learn how to structure effective client sessions from the very first meeting. Therapeutic Techniques – Grounded in modern clinical hypnosis and NLP. Peer Practice – Hypnotise each other under supervision in a safe, encouraging environment. 💡 Course Highlights: Introduction to the world of clinical hypnosis Health and safety, mental wellbeing, and contraindications of hypnosis The history of hypnosis and NLP, including key pioneers The 3 laws of suggestion and why they matter How to handle common client questions Understanding the power of the mind and the subconscious The basics of suggestion, sensory systems, and rapport building Creating a therapeutic space and planning effective therapy Exploring premature cognitive conditioning and the unique client 🧠 Included: Access to a self-paced eLearning module Weekly live Masterclasses Group practice sessions Peer supervision and support Step into the transformative world of clinical hypnosis with clarity, confidence, and competence. Whether you’re revisiting or discovering it for the first time, Foundation Day is your gateway to lasting change. 👉 Book Your Place Today and take the next confident step in your hypnotherapy journey.

This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups