286 Logic courses delivered Live Online

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

Unleash the power of your unpleasant emotions in our online event Emotional Logic – embrace the superpower within your feelings!

The Emotional Logic workshop is designed to provide enlightening mindset shifts and educational activities around emotions, their purpose, and our values.

EFQM Performance Improvement Practitioner Course A 2-day deep-dive workshop on RADAR and how to use it as an agile project performance framework. The essential course for anyone wanting to learn more about the RADAR logic and how to build a continuous improvement culture and mindset across your whole organisation.   Who is it for? This course is suitable for anyone who wants to understand the RADAR logic and how it can be used to make their organisation more effective. Whilst this training is effective as a stand-alone course; it is also a Level 1 option for anyone considering one of the EFQM qualification routes as a way of progressing their management development and career.   Benefits By the end of the course, participants will be able to: Explain the overall RADAR logic Explain the main principles of positive culture and mindset for driving performance Describe how RADAR can be implemented into an organisation to improve performance at every level Identify how to use RADAR to drive the management agenda Apply RADAR across day-to-day initiatives and key projects as an agile project performance framework. Programme The main topics covered during the EFQM Performance Improvement Practitioner training are: RADAR logic and examples of how it can be used Using RADAR to drive the management agenda Using RADAR to drive strategic initiatives Using RADAR to set up strategic KPI’s RADAR as a Performance Improvement Framework Case studies and group exercises RADAR Improvement Matrix self-assessment The training is spread over two days and is delivered in a virtual classroom setting (Zoom or Microsoft Teams), using videos, group discussions, case studies and activities in breakout rooms and presentations from the trainer.   Further Development The EFQM Performance Improvement Practitioner training provides core knowledge about the RADAR Logic. In some cases, the training will have fulfilled an individual's learning needs. In many cases, the individual will want to consolidate their learning by applying the theory to a practical task. We encourage you to apply RADAR to a practical, work-based project, and we provide guidance on how to approach and complete your project.    Completion of the RADAR Performance Improvement Project also allows you to progress to one of the advanced EFQM qualification programmes: EFQM Performance Improvement Leader, EFQM Assessor or EFQM Organisational Change Leader.   EFQM Performance Improvement Leader If you successfully complete the EFQM Performance Improvement Practitioner training and the subsequent project, you are invited to apply for the EFQM Performance Improvement Leader assessment. You will be guided and coached by an EFQM trainer and asked to present your project to the EFQM expert panel. Here you will answer questions about how you applied the RADAR logic and principles (we provide participants with templates for running the project, as well as a high-level mid-term review). You will also receive feedback on how to improve and maximise the use of RADAR for future endeavours. Dates and time: This is a two day on-line workshop delivered on the 12th of June & 18th of June from 9:00 AM to 3:30 PM GMT Cost: £1000 + VAT

About this Training Course This 5 full-day course provides detailed description of all combustion equipment and systems used in pulverized coal boilers and circulating fluidized bed (CFB) boilers including pulverized coal burning systems, coal feeder, pulverizer and classifier, pulverized coal burners, furnace and fans. This course provides also a comprehensive explanation of all boiler combustion control systems including pulverizer control system, combustion control, control of coal and air flow into the boiler, furnace pressure control, oxygen trim control, nitrogen oxides (NOx) and sulfur oxides (SOx) control, control of ammonia injection, flue gas dew point control, purge control, flame monitoring and tripping system as well as their tuning methods. All boiler control systems are covered as well in this course including drum level feedwater control, main steam and reheat steam temperature control, boiler limits and runback, sliding or variable pressure control, heat rate optimization with sliding pressure control, boiler-turbine coordinated control, etc. The course provides also detailed explanation of Boiler NFPA 85 Code (Boiler and Combustion Systems Hazards Codes) and American National Standard Institute/Instrument Society of America Code (ANSI/ISA-77-44-01-2007 Code). The burner management systems (BMS) and examples of boiler permissive starting logic and protective tripping logic will be explained thoroughly. The various methods used to calculate the boiler efficiency are covered in detail in this course including the direct and indirect methods. All the factors which affect the efficiency and emissions of pulverized coal boiler and CFB boiler will be explained thoroughly. The course covers also all the methods used to improve the efficiency of pulverized coal boilers and CFB boilers including improvement to their combustion efficiency and control systems performance. Training Objectives Boiler Combustion Equipment and Systems: Gain an in-depth understanding of all boiler combustion equipment and systems including pulverized coal burning systems, coal feeder, pulverizer and classifier, pulverized coal burners, furnace and fans Boiler Combustion Control Systems: Gain a thorough understanding of all boiler combustion control systems for pulverized coal boilers, and CFB boilers including pulverizer control system, combustion control, control of coal and air flow into the boiler, furnace pressure control, oxygen trim control, nitrogen oxides (NOx) and sulfur oxides (SOx) control, control of ammonia injection, flue gas dew point control, purge control, flame monitoring and tripping system Boiler Conventional Control Systems: Gain an in-depth understanding of all boiler conventional control systems including drum level feedwater control, main steam and reheat steam temperature control, boiler limits and runback, sliding or variable pressure control, heat rate optimization with sliding pressure control, and boiler-turbine coordinated control Boiler NFPA 85 Code (Boiler and Combustion Systems Hazards Codes) and American National Standard Institute/Instrument Society of America Code (ANSI/ISA-77-44-01-2007 Code): Learn about NFPA 85 code and ANSI/ISA-77-44-01-2007 code Burner Management System and Boiler Permissive Starting Logic and Protective Tripping Logic: Gain an in-depth understanding of burner management system and boiler permissive starting logic and protective tripping logic Boiler Efficiency Calculations: Learn how to calculate the boiler efficiency using the direct and indirect methods Factors Affecting the Efficiency and Emissions of Boilers: Understand all the factors which affect the boiler efficiency and emissions Methods Used to Improve the Efficiency of Boilers: Learn about all the methods used to improve the efficiency of pulverized coal boilers, and CFB boilers including improvement to their combustion efficiency and control systems performance Boiler Instrument and Piping Diagrams: Gain an in-depth understanding of all boiler instrument and piping diagrams CFB and Pulverized Coal Boilers Equipment and Systems: Learn about various types of equipment and systems used in CFB and pulverized coal boilers including economizers, steam drum, superheaters, air preheaters, ammonia injection systems, etc. Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods Your specialist course leader relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: Excerpt of the relevant chapters from the 'POWER GENERATION HANDBOOK' second edition published by McGraw-Hill in 2012 (800 pages) Excerpt of the relevant chapters from the 'POWER PLANT EQUIPMENT OPERATION AND MAINTENANCE GUIDE' published by McGraw-Hill in 2012 (800 pages) COMBUSTION ENGINEERING FOR COAL FIRED POWER PLANTS MANUAL (includes practical information about combustion engineering for coal fired power plants - 550 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Duration 1 Days 6 CPD hours This course is intended for The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones. Overview #NAME? This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates. 1 - An Introduction to Power Automate What is Microsoft Power Automate? The benefits of automation How to get to Power Automate Lab 1: Setup your tenant Setup Office 365 Download Course Files Customise your App Launcher Create accounts for colleagues After completing this module, students will be able to: Know what Microsoft Power Automate is The Benefits of using Power Automate to automate processes How to access a Power Automate 2 - Getting Started with Power Automate Using Power Automate templates Navigating in Power Automate Editing a Power Automate Publish and trigger a Power Automate Turn off or delete a Power Automate Lab 1: Building processes in Office 365 Create a Team with a channel Build an absence business process Testing the absence process Optional: Create Feedback Form Optional: Power Automate to Notify of Bad Ratings Optional: Test your Form and Power Automate After completing this module, students will be able to: How to use Power Automate tempaltes How to navigate around Power Automate How to edit Power Automates How to publish and trigger Power Automates How to turn off or delete Power Automates 3 - Power Automate Logic Adding conditions Designing switches Using apply to each Configuring do until logic Adding a scope Lab 1: Scheduling documentation reviews Setup a policy library in SharePoint Design a policy review schedule Testing the policy review process Optional: Notify if a file nears review After completing this module, students will be able to: How to add condtions in a Power Automate How to design switches for a Power Automate How to use apply to each How to configure do until logic How to add a scope 4 - Integration Standard and premium connectors Connecting to web services Using Power Automate with on-premises data Lab 1: Using Power Automate and SQL to Review Sales Create a new orders list Designing the price check process Testing the price check process Optional: Update with managers After completing this module, students will be able to: How to use Standard and Premium connectors How to connect to web services How to using Power Automate with on-premises data 5 - The Mobile App Downloading the mobile app Signing in and account management Building and managing Power Automates Creating buttons Feeds and approvals Lab 1: Optional: Using the Power Automate mobile app Setting up the Power Automate mobile app Create a new Power Automate in the mobile app Using Power Automate buttons in the app Uninstall the Power Automate mobile app After completing this module, students will be able to: How to download the mobile app How to sign into the mobile app How to build and manage Power Automates in the mobile app How to create buttons in the mobile app How to feed and use approvals in the mobile app 6 - Administration and Maintenance Maintaining a Power Automate View history and analytics Sharing a Power Automate Export and import Power Automates Office 365 administration for Power Automate Environments Data policies Data integration Lab 1: Maintaining your Power Automates Share a Power Automate with a colleague Disabling an active Power Automate Deleting a Power Automate After completing this module, students will be able to: How to maintain a Power Automate How to view history and analytics for a Power Automate How to share a Power Automate How to export and import Power Automates How to administrate a Power Automate in Office 365 How to use data policies in a Power Automate How to use data integration in a Power Automate

EFQM Performance Improvement Practitioner Course A 2-day deep-dive workshop on RADAR and how to use it as an agile project performance framework. The essential course for anyone wanting to learn more about the RADAR logic and how to build a continuous improvement culture and mindset across your whole organisation.   Who is it for? This course is suitable for anyone who wants to understand the RADAR logic and how it can be used to make their organisation more effective. Whilst this training is effective as a stand-alone course; it is also a Level 1 option for anyone considering one of the EFQM qualification routes as a way of progressing their management development and career.   Benefits By the end of the course, participants will be able to: Explain the overall RADAR logic Explain the main principles of positive culture and mindset for driving performance Describe how RADAR can be implemented into an organisation to improve performance at every level Identify how to use RADAR to drive the management agenda Apply RADAR across day-to-day initiatives and key projects as an agile project performance framework. Programme The main topics covered during the EFQM Performance Improvement Practitioner training are: RADAR logic and examples of how it can be used Using RADAR to drive the management agenda Using RADAR to drive strategic initiatives Using RADAR to set up strategic KPI’s RADAR as a Performance Improvement Framework Case studies and group exercises RADAR Improvement Matrix self-assessment The training is spread over two days and is delivered in a virtual classroom setting (Zoom or Microsoft Teams), using videos, group discussions, case studies and activities in breakout rooms and presentations from the trainer.   Further Development The EFQM Performance Improvement Practitioner training provides core knowledge about the RADAR Logic. In some cases, the training will have fulfilled an individual's learning needs. In many cases, the individual will want to consolidate their learning by applying the theory to a practical task. We encourage you to apply RADAR to a practical, work-based project, and we provide guidance on how to approach and complete your project.    Completion of the RADAR Performance Improvement Project also allows you to progress to one of the advanced EFQM qualification programmes: EFQM Performance Improvement Leader, EFQM Assessor or EFQM Organisational Change Leader.   EFQM Performance Improvement Leader If you successfully complete the EFQM Performance Improvement Practitioner training and the subsequent project, you are invited to apply for the EFQM Performance Improvement Leader assessment. You will be guided and coached by an EFQM trainer and asked to present your project to the EFQM expert panel. Here you will answer questions about how you applied the RADAR logic and principles (we provide participants with templates for running the project, as well as a high-level mid-term review). You will also receive feedback on how to improve and maximise the use of RADAR for future endeavours. Dates and time: This is a two day on-line workshop delivered on the 31st of January & 7th of February from 9:00 AM to 3:30 PM GMT Cost: £650 + VAT

Duration 1 Days 6 CPD hours This course is intended for Managers and other professionals who want to gain the critical skills to successfully interact with or lead others through cooperative teamwork, as well as those desiring to improve their overall communication skills will benefit from this course. Overview Recognize the difference between hearing and listening Enhance interpersonal relationships through the use of verbal and non-verbal communication Apply techniques to move towards high-quality conversation Create a positive impression through a powerful introduction Influence others through sharing perspectives and opinions constructively Use logic and emotion to persuade and collaborate Identify ways of sharing thoughts and opinions constructively Prepare for and conduct simple negotiations This course will prepare students for the collaborative situations inherent in every facet of business, whether working with colleagues, partners, vendors, or clients. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. The Importance of Interpersonal Skills 2. Verbal Communication Techniques Hearing versus Actively Listening Connecting with Powerful Communication 3. Non-Verbal Communication Understanding the Elements of Vocal Delivery Interpreting and Applying Body Language Building Self-Awareness 4. Creating a Powerful First Impression Creating a Powerful Introduction Cultivating Your Impact 5. The Art of Conversation Mastering the 4 Levels of a Conversation Moving a Conversation Along Applying Tools for Deepening Conversation 6. Influence and Persuasion Influencing Others Seeing the Other Side Building Bridges Extending Your Influence 7. Interacting Positively Applying Logic and Owning Emotions Disagreeing Constructively Bringing People to Your Side Building Consensus 8. Negotiation Basics Planning for Negotiation Managing the 4 Stages of Negotiation Arriving at an Agreement Additional course details: Nexus Humans Developing Successful Interpersonal Skills 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 Developing Successful Interpersonal Skills 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 course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.