OVERVIEW Prerequisites—DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models. During this course you will review: Writing DAX formulas. Defining calculated tables and columns. Defining measures. Using DAX iterator functions. Modifying filter context. Using DAX time intelligence functions. After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns. COURSE BENEFITS: Understand Analytic queries in Power BI Create calculated tables, calculated columns and measures Use DAX functions and operators to build DAX formulas Use DAX iterator functions Create formulas that manipulate the filter context Use DAX time intelligence functions WHO IS THE COURSE FOR? Analysts with experience of Power BI wishing to develop more advanced formulas in DAX Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable LAB OUTLINE Lab 1 Setup Connect to data and understand the objectives of the future labs Lab 2 Write DAX Formulas For Power BI Create a measure Use variables in the measure definition Lab 3 Add Calculated Table And Columns Duplicate a table Create a hierarchy Create a date table Add calculated columns Lab 4 Add Measures To Power BI Desktop Models Add an implicit measure to a report Add an explicit measure Add a compound measure Add a quick measure Lab 5 Use DAX Iterator Functions In A Power BI Desktop Model Complex summarization Higher grain summarization Create ranking measure Lab 6 Modify DAX Filter Context In Power BI Desktop Models Apply Boolean expression filter Remove filters: use ALL Remove filters: use AllSelected Preserve filters: use KeepFilters HASONEVALUE ISINSCOPE Context transition Lab 7 Use DAX Time Intelligence Functions In Power BI Desktop Models TOTALYTD SAMEPERIODLASTYEAR Calculate new occurrences Snapshot calculations
Facilitating Effective Meetings (Virtual) Billions of dollars and exorbitant amounts of time are wasted annually across the globe because of organizations' meeting practices. This contributes to serious performance problems for both organizations and employees, and it has a serious impact on culture and morale. But despite the costs and consequences, every-day people in any role have the ability to change that. They can reduce cost, improve productivity, and enhance their workplace cultures by improving their meeting facilitation skills. And that is because facilitation skills start in the planning stage, not in the live meeting stage. In this course, participants will learn that their responsibility as a facilitator is to be a steward of time, money, relationships, and performance. To do that, they will learn to estimate costs of meetings and practice a variety of strategic thinking and analysis tasks to effectively plan results-aligned meetings. They will also apply several techniques and strategies to proactively prevent and deal with conflict in meetings, as well as give objective, constructive feedback to others in order to create behavior change during meetings. Participants must bring laptops with them and have internet access during the course (both virtual classroom and traditional classroom). The laptops are needed for specific activities. Also note that this course pairs well with IIL's Conflict Resolution Skills and Decision Making and Problem Solving courses, which go much deeper into related skills and tools that support effective meeting facilitation. What you will Learn At the end of this program, you will be able to: Estimate the financial and time costs of attendance for real-world meetings Use a performance formula to define the purpose of meetings Describe the responsibilities and qualities of an effective facilitator Analyze situations to determine when a meeting is necessary Articulate performance-driven meeting goals and results Align meeting goals and results Strategize to invite, involve, and exclude appropriate attendees Explain research-based best practices for meeting decisions and agenda development Create an effective agenda for a results-driven meeting Apply proactive tools and strategies for relationship-building dealing with meeting conflict Give constructive behavioral feedback using the Situation-Behavior-Impact® technique Getting Started The Business Case for Effective Facilitation Embracing the research on meetings Estimating the real costs of meetings Determining a meeting's performance value Clarifying the meeting facilitator's role Facilitating the Meeting Plan Determining if a meeting is necessary Aligning meeting goals with meeting types Identifying the right attendees Creating a strategically effective agenda Facilitating the Live Meeting Building relationships from the start Dealing with conflict proactively Giving feedback on unproductive behavior Summary and Next Steps
This course is intended for Beginner-Moderate exposure is recommended for this course. The topics covered are cumulative in nature, and they require minimal understanding of email applications and composition. Overview The objective of the course is to give students the information needed to create emails that are written in a succinct, effective, and user-friendly manner. Students will learn how to set up an email subject, salutation, and will then work on how to write a credible email. In this course, students will learn about e-mail policies and learn how to write professional e-mail memos that convey appropriate messages. 1 - E-mail basics E-mail characteristics Writing online versus on paper Understanding the advantages and disadvantages of e-mail Understanding the cultural significance of e-mail E-mail programs Using an e-mail program to send e-mail When to use e-mail Communicating by e-mail Understanding when to avoid using e-mail Writing an e-mail message Using the MAIL acronym 2 - E-mail policies Company policies Avoiding improper e-mail messages Ensuring employee compliance to e-mail policies Copyright laws, viruses, and liability Avoiding copyright infringement Avoiding viruses Identifying e-mail liability 3 - E-mail features and security Features of an e-mail program Using attachments Using priority labels and signature files Features of an e-mail program Using attachments Using priority labels and signature files Discussing e-mail program options Securing e-mail Using encryption and digital signatures Using passwords 4 - E-mail messages Message headers Using headers E-mail message body Including proper greeting Structuring an e-mail message Closing an e-mail message 5 - E-mail effectiveness E-mail recipients Considering the factors that determine e-mail writing Anticipating recipient reaction Message management Managing your e-mail effectively 6 - Netiquette guidelines Netiquette style Using proper tone Following formatting guidelines Emoticons and abbreviations Using emoticons and electronic abbreviations 7 - Composing online correspondence Online communication Achieving the objective of the message Language and punctuation Improving online writing style Using punctuation correctly Efficient writing habits Constructing sentences Constructing paragraphs Editing e-mail messages
Duration 1 Days 6 CPD hours This course is intended for This course is intended for new managers, especially those with direct reports, who are responsible for increasing employee motivation and job performance. This course will assist students in understanding and implementing strategies that will help to motivate their work force. 1 - Getting Started Workshop Objectives Pre-Assignment Review 2 - A Psychological Approach Herzberg?s Theory of Motivation Maslow?s Hierarchy of Needs The Two Models and Motivation Case Study Module Two: Review Questions 3 - Object-Oriented Theory The Carrot The Whip The Plant Case Study Module Three: Review Questions 4 - Using Reinforcement Theory A History of Reinforcement Theory Behavior Modification in Four Steps Appropriate Uses in the Workplace Case Study Module Four: Review Questions 5 - Using Expectancy Theory A History of Expectancy Theory Understanding the Three Factors Using the Three Factors to Motivate in the Workplace Case Study Module Five: Review Questions 6 - Personality's Role in Motivation Identifying Your Personality Type Identifying Others? Personality Type Motivators by Personality Type Case Study Module Six: Review Questions 7 - Setting Goals Goals and Motivation Setting SMART Goal Evaluating and Adapting Case Study Module Seven: Review Questions 8 - A Personal Toolbox Building Your Own Motivational Plan Encouraging Growth and Development Getting Others to See the Glass Half-Full Case Study Module Eight: Review Questions 9 - Motivation on the Job The Key Factors Creating a Motivational Organization Creating a Motivational Job Case Study Module Nine: Review Questions 10 - Addressing Specific Morale Issues Dealing with Individual Morale Problems Addressing Team Morale What to Do When the Whole Company is De-Motivated Case Study Module Ten: Review Questions 11 - Keeping Yourself Motivated Identifying Personal Motivators Maximizing Your Motivators Evaluating and Adapting Case Study Module Eleven: Review Questions 12 - Wrapping Up Words from the Wise Additional course details: Nexus Humans Employee Motivation 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 Employee Motivation 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.
Learn how to better apply project management techniques to manage small projects as part of your normal role.
Introduction to Project Management: Virtual In-House Training This course provides practical insights into what is project management and how it is performed in a structured manner. This course provides practical insights into what is project management and how it is performed in a structured manner. You will learn how projects are selected, initiated, planned, executed, monitored and control, as well as closed, which could serve you ubiquitously. The goal of this course is to provide a minimally essential orientation to practical project management concepts, tools, and techniques. You will be provided with enough of these that can be applied from both a project manager and a key stakeholder perspective. What you Will Learn You will learn how to: Articulate on the basics of the project management profession Explain project management terms and concepts in practice Speak on how projects originate in mature organizations Employ a disciplined approach to initiating, planning, and managing projects to closure Identify and describe the roles and responsibilities of key project stakeholders Consider standard project processes to implement based upon the PMBOK® Guide Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Key terms and concepts Organizational framework Leadership framework Originating and Initiating Originating projects Initiating projects Planning Planning overview Scope and quality planning Resources and risk planning Schedule and cost planning Project baselining Executing and Controlling Executing Monitoring and Controlling Closing Project closing overview Closing administratively Closing financially Summary and Next Steps Review of goals, objectives, key concepts, and expectations Evaluations
Introduction to Project Management (Virtual) This course provides practical insights into what is project management and how it is performed in a structured manner.You will learn how projects are selected, initiated, planned, executed, monitored and control, as well as closed, which could serve you ubiquitously. The goal of this course is to provide a minimally essential orientation to practical project management concepts, tools, and techniques. You will be provided with enough of these that can be applied from both a project manager and a key stakeholder perspective. Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Key terms and concepts Organizational framework Leadership framework Originating and Initiating Originating projects Initiating projects Planning Planning overview Scope and quality planning Resources and risk planning Schedule and cost planning Project baselining Executing and Controlling Executing Monitoring and Controlling Closing Project closing overview Closing administratively Closing financially
Duration 1 Days 6 CPD hours This course is intended for This course is intended for customer service professionals with any level of experience who want to expand their knowledge, improve their skill set, and increase the understanding of customer benefits. Overview In this course, you will explore the background and techniques of customer interactions. You will: ?Describe the benefits of customer service, identify internal customers, identify the benefits to you of giving good customer service, and identify how you can help your company to excel. ?Identify the major trends in customer service today and the combination of criteria required for customer satisfaction. ?Identify the benefits of bringing respect, emotional support, and a personal touch to customer interactions, and apply the personal touch to customer interactions. ?Identify the six categories of face-to-face communication, the critical success factors in face-to-face communication, and the benefits of actively listening to your customers. ?Identify remote customer service communication channels and apply remote customer service best practices. ?Identify guidelines for handling unreasonable customers, explore ways to handle angry customers, and identify guidelines for handling unhelpful colleagues. ?Take action to increase the loyalty of the customers you serve. You will also identify guidelines for dealing with moments of truth, identify the benefits of customer complaints, identify the steps in the service recovery process, and analyze the moments of truth in a real-life situation. As a customer service representative, you are expected to handle customer interactions in the best way possible. The expectations of both your company and your customers hinge on your ability to provide the right service in the right way. In this course, you will explore the background and techniques of customer interactions. Providing quality customer care ensures that every single contact with your company is a positive experience. Customers can range from external consumers to internal employees in other departments. Knowing how to provide the same level of service to all customers will enrich your time spent at work by establishing positive business relationships. Recognizing crucial points throughout customer interactions increases your ability to solve problems and offer affirmative solutions. Applying this knowledge to trends in service and consumer desires allows you to contribute to the company?s bottom line and make a customer?s life a little easier. 1 - Understanding Customer Service Describe Customer Service Benefits Recognize the Importance of Internal Customer Service Identify How Customer Service Benefits You Excel with Customer Service 2 - Identifying How Customers Define the Success of Your Company Recognize Trends in Customer Service Identify Criteria for Customer Satisfaction 3 - Increasing Customer Satisfaction Identify Characteristics of the Personal Touch Create Lasting Positive Impressions on Your Customers 4 - Providing Face-to-Face Customer Service Identify Categories of Face-to-Face Contact Understand the Critical Success Factors in Face-to-Face Customer Service Identify the Characteristics of Active Listening 5 - Providing Remote Customer Service Identify Remote Customer Service Communication Channels Apply Remote Customer Service Best Practices 6 - Engaging Difficult Customers Serve Difficult Customers Manage Angry Customers Deal with Difficult or Unhelpful Colleagues 7 - Increasing Customer Loyalty Optimize Moments of Truth Recognize the Value of Customer Complaints Identify the Stages of the Service Recovery Process
Duration 1 Days 6 CPD hours Time management training most often begins with setting goals. These goals are recorded and may be broken down into a project, an action plan, or a simple task list. Activities are then rated based on urgency and importance, priorities assigned, and deadlines set. This process results in a plan with a task list or calendar of activities. Routine and recurring tasks are often given less focus to free time to work on tasks that contribute to important goals. This entire process is supported by a skill set that should include personal motivation, delegation skills, organization tools, and crisis management. 1 - Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - Setting SMART Goals The Three P?s The SMART Way Prioritizing Your Goals Visualization 3 - Prioritizing Your Time The 80/20 Rule The Urgent/Important Matrix Being Assertive 4 - Planning Wisely Creating Your Productivity Journal Maximizing the Power of Your Productivity Journal The Glass Jar: Rocks, Pebbles, Sand, and Water Chunk, Block, and Tackle Ready, Fire, Aim! 5 - Tackling Procrastination Why We Procrastinate Nine Ways to Overcome Procrastination Eat That Frog! 6 - Crisis Management When the Storm Hits Creating a Plan Executing the Plan Lessons Learned 7 - Organizing Your Workspace De-Clutter Managing Workflow Dealing with E-mail Using Calendars 8 - Delegating Made Easy When to Delegate To Whom Should You Delegate? How Should You Delegate? Keeping Control The Importance of Full Acceptance 9 - Setting a Ritual What is a Ritual? Ritualizing Sleep, Meals, and Exercise Example Rituals Using Rituals to Maximize Time 10 - Meeting Management Deciding if a Meeting is Necessary Using the PAT Approach Building the Agenda Keeping Things on Track Making Sure the Meeting Was Worthwhile 11 - Alternatives to Meetings Instant Messaging and Chat Rooms Teleconferencing E-mail Lists and Online Groups Collaboration Applications 12 - Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations Additional course details: Nexus Humans Time 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 Time 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 1 Days 6 CPD hours This course is intended for This course is designed for individuals who need to present information effectively in a professional environment. Overview This program can benefit anyone who presents; a trainer, a meeting facilitator, speaker, or seminar discussion leader. No matter which role you are assuming, this workshop will help you become more efficient and proficient with the skills of providing information to others. In this course, students will learn active listening skills to facilitate the exchange of ideas in meetings and presentations. They will also organize your ideas to create coherent and convincing oral presentations. Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives Creating the Program Performing a Needs Analysis Writing the Basic Outline Researching, Writing, and Editing Choosing Your Delivery Methods Basic Methods Advanced Methods Basic Criteria to Consider Verbal Communication Skills Listening and Hearing: They Aren?t the Same Thing Asking Questions Communicating with Power Non-Verbal Communication Skills Body Language It?s Not What You Say, it?s How You Say It Overcoming Nervousness Preparing Mentally Physical Relaxation Techniques Appearing Confident in Front of the Crowd Creating Fantastic Flip Charts Required Tools The Advantages of Pre-Writing Using Colors Appropriately Creating a Plan B Creating Compelling PowerPoint Presentations Required Tools Tips and Tricks Creating a Plan B Wow 'Em with the Whiteboard Traditional and Electronic Whiteboards Using Colors Appropriately Creating a Plan B Vibrant Videos and Amazing Audio Required Tools Tips and Tricks Creating a Plan B Pumping it Up a Notch Make Them Laugh a Little Encourage Discussion Dealing with Questions Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations Additional course details: Nexus Humans Presentation 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 Presentation 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.