1390 Courses

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.

Cloud technologies training course description This course provides an introduction to cloud technologies, including, configuration and deployment, security, maintenance, and management. It covers all aspects of cloud computing infrastructure. It will help you to master the fundamental concepts, terminology, and characteristics of cloud computing. . What will you learn Contrast and compare AWS, GCP and Azure. Explain the different cloud services, models and characteristics. Explain cloud virtualization components and options. Explain cloud security options. Describe cloud automation, orchestration, monitoring and performance options. Cloud technologies training course details Who will benefit: Anyone working with or looking to work with cloud technologies. Prerequisites: None. Duration 2 days Cloud technologies training course contents What is the cloud? The Internet Cloud computing Benefits Disadvantages Cloud services IaaS, PaaS, SaaS, others. Cloud service providers AWS, GCP Microsoft Azure, others Cloud architectures Private, public, hybrid others Cloud based delivery The cloud and virtualization Virtual Machines, networks, storage, deployment. Accessing the Virtual Machine Secure cloud environments Security considerations. Data privacy considerations Automation and orchestration Monitoring and performance Performance Cost issues Cost containment

Duration 2 Days 12 CPD hours This course is intended for The primary audiences for this course are quality directors and quality assurance managers, managers responsible for the governance of an enterprise and management of its risks, technical experts, project managers and consultants, internal auditors, compliance officers and virtually anybody involved in ANSI/TIA-942 compliance certification related projects either from an end-user or vendor perspective. Participants must hold a valid CTDC certificate in order to be able to register for the CTIA class. Overview After completion of the course the participant will be able to: 1. Prepare the organisation for an audit according to ANSI/TIA-942 including preparation of the required documents, resource planning and management of the audit process itself 2. Conduct an internal audit according to ANSI/TIA-942 following ISO-19011 guidelines 3. Facilitate and support the external audit to ANSI/TIA-942 4. Manage the post-audit process with respect to CAR (Corrective Action Reports), gap closing and _nal certification 5. Facilitate surveillance and recertification audits This intensive course builds further on the technical understanding of the standard acquired in the CTDC© (Certified TIA-942 Design Consultant) course. Fundamental concepts and process of an internal audit Terms and de_nitions Difference between an internal and external auditor Audit principles Auditor competency requirements Managing an audit programme Establishing the audit objectives Establishing the audit programme Planning the audit Planning the schedule Resource planning Tools/equipment required Document requirements - Design documents - Process documents - Declarations Conducting the audit Conducting an opening meeting Conducting the audit Interviews Document review Facility review Typical non-conformities - Architectura - Electrica - Mechanical - Telecommunications Preparing the audit conclusions Conducting the closing meeting Preparing and distributing the audit report Audit report requirements Classification of non-conformities Typical format of an audit report Following up on the audit The CAR ? Corrective Action Report Evaluation of the Corrective Action Report Requesting a formal external auditIssuing a conformity certificate Requirements of the certificate Registration of the certificate Surveillance auditsRecertification auditsExam: Certified TIA-942 Internal Auditor) Actual course outline may vary depending on offering center. Contact your sales representative for more information. Additional course details: Nexus Humans Certified TIA-942 Internal Auditor (CTIA) 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 Certified TIA-942 Internal Auditor (CTIA) 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 Executives, directors, managers, and others tasked with making important decisions for their organizations will benefit from this course. Overview Make intelligent decisions with limited time and information Reframe issues to ensure greater problem-solving accuracy Convert conflicting opinions into useful insights In this course, students will learn to evaluate options, generate possible solutions, and decide on logical strategies. 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. Prerequisites While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training. 1. The Complexity of Decision Making Establishing the Needs of the Organization Defining Organizational Objectives and Goals Measuring Your Goals Calculating Probabilities of Success 2. Dealing with Opinion in the Face of Uncertainty Understanding Theories of Decision-Making Avoiding Irrationality Being Aware of Risks Reframing the Options Asking the Right Questions Knowing What You Want Making Proper Comparisons Working with Stereotypes and Expectations 3. Adapting Decision Strategies for a Complex World Reviewing Your Plans Engaging Stakeholders Enlisting Your Network Managing Risks Planning for Risks - Avoidance, Mitigation, Transference, and Acceptance Applying Complexity Theory and the Butterfly Effect Adjusting Decisions Building in Metrics & Measurements Monitoring Progress and Managing Risks Looking for Emerging Trends Additional course details: Nexus Humans Making the Right Decisions Under Pressure 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 Making the Right Decisions Under Pressure 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 Professionals wishing to maximize their productivity and efficiency by investing their time more effectively will benefit from this course. Overview Time Management Prioritization Organization Workflow Productivity Time is limited, so getting the most out of every minute is critical. In this course, students will learn to improve their focus, prioritize tasks, identify and avoid obstacles to staying on track, and develop strategies to get the most out of their time. Students will acquire time management tools and decision-making techniques to help focus on purpose and achieve your goals, balancing the needs of both business and personal life. 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. Wise Time Management Identifying Time Wasters Applying the 80/20 Rule Utilizing Calendars Creating Rituals 2. Prioritizing Your Time Taking Charge of Your Time Protecting Your Time through Assertiveness 3. Planning Wisely Managing the Power of Your Productivity Journal Finding Hidden Time Chunking, Blocking, and Tackling 4. Organizing Your Workspace Decluttering Managing Workflow Taking Control over Email 5. Tackling Procrastination Knowing Why You Procrastinate Nine Ways to Avoid Procrastination 6. Crisis Management Weathering the Storm Creating and Executing a Plan Applying Lessons Learned 7. Increase Your Productivity Applying Productivity Tools Finding What Works Eliminating the Word \'Should\' Building on Success Additional course details: Nexus Humans Prioritizing Your Time Effectively 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 Prioritizing Your Time Effectively 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 Operations managers, account representatives, customer service staff, help desk and technical support, and anyone working directly with customer will benefit from this course. Overview Define customer service in relation to both internal and external customers Recognize how your attitude affects customer service Identify your customer\'s needs Generate repeat business with outstanding customer service Build goodwill through in-person customer service Provide outstanding customer service over the phone Connect with customers through online tools Deal effectively with difficult situations This course offers practical tools and techniques to win clients, create loyal advocates for your business, and deliver excellent customer service. 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. Customer Service - A Baseline Recognizing Your Customers Understanding Your Role in Customer Service 2. Developing A Customer Service Mind-Set Leveraging Your First Impression Feeling Positively About Customers Mastering Moods and Emotions 3. Identifying Customer Needs Understanding the Customer\'s Situation Avoiding Assumption and Prejudgment Meeting Basic Needs Seeking to Exceeding Expectations Building Repeat Relationships 4. Connecting with the Customer Achieving Authenticity through Body Language Responding Effectively to Problems Mastering Online Etiquette Seeking Customer Feedback 5. Dealing with Difficult Situations Effectively Addressing Complaints De-escalating Anger Establishing Common Ground Remaining Calm, Respectful and Objective 6. Effectively Addressing Complaints Creating a Memorable Customer Experience Additional course details: Nexus Humans Providing Outstanding Customer Service 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 Providing Outstanding Customer Service 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 Professionals who manage teams and desire to understand what leads to conflict, help peacefully navigate team members through potentially antagonistic situations, encourage and empower others to disagree respectfully and productively, and effectively manage disputes between team members will benefit from this course. Overview Identify and manage sources of conflict Define an effective strategy to deal with conflict Implement a process to manage conflict situations Build civility in the workplace In this course, students will learn to recognize the warning signs that precede quarrels and how to mitigate their impact, as well as constructive ways to harness the differences between team members and shift them toward productive, positive outcomes. 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. Understanding conflict Identifying the Causes of Conflict Harnessing the Benefits of Conflict Resolving Conflict Understanding the Key People in Conflict Resolution 2. Civility in the Workplace Recognizing Uncivil Behavior Reaping the Benefits of Civil Behavior Working with Difficult People Identifying and Avoiding Incivility Creating, Implementing, and Enforcing a Civility Policy 3. Conflict Resolution Process Making an Effective Atmosphere Developing Mutual Understanding Focusing on individual and Shared Needs Getting to the Root Cause Generating Options Building a Solution 4. Conflict Resolution Strategies Differentiating Resolution Strategy Versus Process Recognizing the Advantages and Disadvantages to Collaborating, Competing, Compromising, and Avoiding Additional course details: Nexus Humans Constructive Conflict Management 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 Constructive Conflict Management 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 Professionals who want to make the best decisions and develop creative and elegant solutions to challenging problems will benefit from this course. Overview Enable you to evaluate, identify, and distinguish between relevant and irrelevant information Engage critical thinking through curiosity and your ability to ask good questions Apply the eight best practices of critical thinking in practice Leverage open-mindedness to become more receptive and highly tuned for new ideas Students will learn to explore challenges, defy incorrect assumptions, and look at things with new and differing perspectives, incorporating these insights into your thought processes, and enabling them to find solutions to even the most difficult tasks. 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 Challenges of Modern Thinking Becoming a Rational Thinker Critical Thinking in Application Applying Reason Developing Open-Mindedness Stepping Out of Your Comfort Zone Avoiding Jumping to Conclusions Expecting and Initiating Change Being Ready to Adapt Thinking Logically 2. Critical Thinking Best Practices Listening Actively Evaluating Information Making Assumptions Watching Out for Bias Asking Clarifying Questions Performing SWOT Analysis Benefitting from Critical Thinking 3. Putting It All Together Changing Your Perspective Considering Other Viewpoints Dealing with New Information Solving Problems Identifying Inconsistencies Asking Why Evaluating the Solution Retaining Your New Skills Reflecting and Learning from Mistakes Asking Questions on an Ongoing Basis Additional course details: Nexus Humans Thinking with Critical Insight 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 Thinking with Critical Insight 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 Any professionals who need to work effectively with others without direct authority, as well as mid- and upper-level executives and managers who would benefit from understanding the motivations of others to achieve successful results for the business. Overview Build workplace relationships based on mutual trust and respect Collaborate effectively through influence and persuasion Recognize and enhance your sources of personal power Choose and apply appropriate influence strategies Work with resistance to gain commitment and buy-in In this course, you will learn to become proficient in the art of persuasion, selecting and utilizing appropriate styles and strategies to have the most influential effect, as well as understanding how to protect yourself from being manipulated by others. 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. An Influence Baseline Enabling Collaboration Facilitating Constructive Dialogue 2. Elements of Influence Focusing on the Outcome Seeing Influence as a Mental Equation Differentiating Influence from Manipulation 3. Power and Persuasion Developing and Using Power Sources Developing the Art of Persuasion Appealing to Integrity, Emotions, and Intellect Building Five Types of Trust Applying Five Principles of Influence 4. A Network of Influence Building a Purposeful Network Strategic Reputation Management Protecting Your Credibility 5. Applying Influence Strategies Adapting the Approach Identifying Thinking Differences Applying Strategies to Styles 6. Working With Resistance Encountering and Addressing Resistance Building Collaboration through Quality Dialogue Getting Results through Persistence and Persuasion Additional course details: Nexus Humans Extending Your Sphere of Influence 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 Extending Your Sphere of Influence 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 Individuals taking this course are business professionals seeking to develop or increase their emotional intelligence. Overview Develop a leadership style that gets results Employ suitable motivation techniques for your team or unit Utilize your communication style to provide influence to drive direction Empower your team to achieve the results you and they want Success is measured by results and results are only accomplished with effective planning efforts. Detailed plans and a captivating vision are important, but true accomplishment is in carrying your goals through to a winning outcome. In this workshop, you will learn how to find and strengthen your leadership voice and foster employee buy-in to exceed expectations while achieving the most positive outcome. 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. Leadership Style Guide Leadership characteristics Crucial abilities of leaders Determining the Type of Leader You Want to Be 2. Understanding Motivation What motivates people? Strategies for motivation Motivation for behavior modification 3. Adapting Communication Understanding communication styles Comparing the 4 Style Traits Adapting to Differing Communication Communication adaptability 4. Strategy and Results Strategy and planning Building effective team visions Creating personal visions 5. Building a Better Team Team development Handling conflict within a team Developing Trust and Respect 6. Enabling Others to Act Managing the Workload Major factors of delegation Steps in delegation Successful delegation Avoiding Wasted Time and Energy Following-Up to Ensure Success Additional course details: Nexus Humans Accomplishing the Results You Want (Second Edition) 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 Accomplishing the Results You Want (Second Edition) 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.