Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature
I Stress, Eustress, We All Stress Stress is a natural response, and not all stress is bad—eustress can motivate and enhance performance, while distress can overwhelm. We believe everyone can control stress through recognition, self-care and conversation. Let’s turn stress into a catalyst for growth, not burnout. Ready to rethink how you handle stress? Workshop outline: Stress and mental health Eustress and distress Discuss approaches to coping with stress Explore what might be helpful to promote self-care Practice conversation starters Self-care and wellbeing resources Our 2-hour workshop packages At Mindmaps Wellbeing, we know that every business is unique, and no team is the same. That’s why we’ve developed our range of short, specialist wellbeing and mental health themed workshops—a fully flexible approach to workplace training. With our selection of engaging and impactful 2-hour workshops, you can build a programme that truly meets your organisation’s needs. Whether you’re looking to manage stress, challenge stigma, or avoid burnout, you choose the sessions that suit your team best. Our training courses and workshop collection Book multiple workshops on the same day to save Why Mindmaps Wellbeing? Mindmaps Wellbeing is the trusted training provider for businesses looking to enhance workplace mental health and employee wellbeing. Our training is designed and delivered by registered Mental Health Nurses, ensuring credibility, expertise, and real-world application. Focus on culture change – Our training goes beyond theory transfer, aiming to embed lasting behavioural shifts that foster a positive, mentally healthy workplace Flexible delivery options – We offer in-person, online, and hybrid training solutions to fit your organisation’s needs Proven impact and measurable results – Our training leads to improved employee engagement, productivity, and retention Engaging and actionable – All our courses include interactive activities, case studies, and real-world applications for immediate impact
Duration 1 Days 6 CPD hours This course is intended for This is a basic course for IBM Engineering Requirements Management DOORS users. Overview Upon completion of the course, students will be able to: Navigate within a DOORS database Create structured data in a DOORS formal module Modify existing data in a DOORS formal module Review existing data in a DOORS formal module Create relationships in a DOORS database Report on relationships in a DOORS database This course is for new IBM Engineering Requirements Management DOORS (DOORS) users. It introduces basic DOORS concepts and functionality. It includes hands-on exercises that teach users to create, edit, manipulate, and analyze requirements data in DOORS. Unit 1 Navigating a DOORS Database Unit 2 Viewing information Unit 3 Editing information Unit 4 Structure Unit 5 Capturing additional information Unit 6 Working with Microsoft Word documents Unit 7 Locating information Unit 8 Manipulating the display Unit 9 Creating traceability Unit 10 Traceability analysis Unit 11 Object linking and embedding Unit 12 Discussions Additional course details: Nexus Humans QN101G IBM Engineering Requirements Management DOORS V9.6 - Foundation 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 QN101G IBM Engineering Requirements Management DOORS V9.6 - Foundation 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.
Your grumpiest customers can become your biggest advocates if you solve their problems quickly, effectively and permanently. We supply the top tips for dealing with tricky customers so your teams can create positive outcomes from every interaction with some simple techniques that make a difference to relationships straight away. Bespoke courses include: Customer needs and expectations Communication styles and how to influence them Assertiveness The 4 psychological fears Dealing with difficult customer behaviour The power of your behaviour Five steps to customer problem solving
Understanding cultural differences in the global sales environment is critical to your salespeople’s success. Developing their intercultural communication skills and knowledge of the sales and negotiation techniques of different cultures and nationalities, will help them to ensure relationships are as effective and rewarding as possible. Bespoke courses include: The impact of language and cultural differences on the sales environment Communication techniques in international sales Effective sales questions A global mindset Culture and its impact on sales Delivering on different cultural expectations Perceptions of time across cultures and the impact on sales cycles and timelines
This 2-day workshop is offered with an internal and external focus. Day 1 will focus on building your internal network and relationships by focusing on your personal network, your brand, influencing skills and perceptions. Day 2 focuses on your external relationships with suppliers, patient groups etc. This will focus on assertiveness, outcome rather than relationship focus, and influencing and negotiating skills. DAY ONE 1 Can you succeed by yourself? 2 Relationship awareness theory 3 The Strengths Deployment Inventory / Your FACET5 profile 4 Building rapport 5 Influencing power bases 6 Active listening 7 Building your personal internal network 8 Perceptions 9 Your brand DAY TWO 3 Preparing for conflict 2 The negotiation conversation 1 Your stakeholders and what they want from you 4 Influencing others 5 Your communication approaches for success 6 Emotional Intelligence 7 The trust model 8 Knowing your outcomes
The principles of effective time management are applicable to all aspects of life. When successfully applied in a sales environment they can lead to improved performance, higher sales and increased customer satisfaction. All salespeople would benefit from learning the tools and techniques to introduce impactful time management to their working lives. We have developed this programme to be practical, fun and interactive. Participants will better understand how to increase the amount of time spent on high-value sales activities, be able to improve their self-motivation and ability to get more done, and be better able to plan, delegate and speed up routine tasks. This course will help participants: Learn key principles of managing sales priorities, meeting targets and getting 'everything' done! Learn proven techniques for structuring your day, week and normal routine Develop effective sales time management at the office and on the road Learn a seven-step process for setting goals and objectives in your work and personal life Understand how to make time for sales prospecting, designated call days Understand practical ways to improve your time management 1 Key principles of sales time management Course objectives and review of time log Essential principles of sales time management How do you use your time now? Reviewing your working day (from pre-course survey) Beliefs and feelings about time 2 Managing sales priorities and planning systems Managing priorities and planning systems Use organised persistence to plan your sales activity Planning your territory and prospecting activity How to use priority ratings not urgency to react to tasks 3 Dealing with distractions and communication skills Know your time 'bandits' and creating more positive habits to overcome them Making time by saying 'no' assertively and managing expectations Assertiveness techniques for handling colleagues and clients Making meetings worthwhile - preparation and planning 4 Sales goal setting and action planning Set clear, concise, and motivating sales goals and action plans How to set and use goal setting as way of managing your time and increasing results The principles of linking SMART objectives to action plans and daily activities 5 Creating results focus - every day, week, and month Batch sales tasks together, starting with emails Planning your day and week and protecting sales 'prime' time Apply the 80/20 to your sales contacts, clients, and prospects 6 Overcoming procrastination and structuring your day Understanding procrastination, what it is and how to recognise it in yourself and others How to stop procrastinating and start making progressing Build a power prospecting hour into every day Smart stuff to make more sales time: five automated tools Live the $64,000 dollar question
The ability to influence others is a life skill but also one that has never been so critically useful at work. This one day workshop will set you on the road to discover what you need to be able to think and do that will help you take people with you. This involves learning some new tools and strategies that fit the situation you are in and making sure you use the right skills and behaviours to influence well, whether it is a single person or a room full of cynical expectant people! This workshop will enable you to: Learn about and understand influencing styles and strategies available and formulate plans and ideas on how to use them in influencing situations Understand which skills and behaviours to use to be the most effective influencer Have greater confidence in situations where they need to influence someone Use thinking, speaking and behavioural techniques that enable influencing to be effective and positive Review and evaluate learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions & getting to know you and why you are here Course objectives 2 Personal objectives Introducing a learning diary 3 Gallery exercise - using images of exemplars brought by participants Plenary discussion The skills and behaviours of an exemplar influencer 4 Group task - what does your self-evaluation say? Discussion and conclusions 5 Influencing - what is it? - why do we need it? The current organisational landscape including values and behaviours the influencer operates in 6 Pit Stop - 'pull / push', 'the lost horse' and 'talking at' 7 Direct / support / delegate / coach: the different choices and approaches to choose from 8 Updating the learning diary 9 Power and types of power - its impact on influencing ability and approach and what is within your control Group task and discussion 10 The 5 influencing styles tool Series of tasks and exercises Drilling down to a personal action plan for maximising influence 11 'The person with the most flexibility has the most influence' Skills and behaviours for effective influencing Exercises and techniques that develop skills for influencing 12 Review and evaluation Action planning
In this webinar you will learn the essential real estate concepts including risk and return dynamics, value and cap rates. We will discuss the types of residential properties and the specific property companies that invest in residential real estate. Additionally, we will explore the current market trends and their impact on residential real estate in the UK. Join this webinar if you would like to have a better understanding of residential real estate market.
Our telephone training takes place in your normal working situation, using the actual telephones and software, and the programming software clients that trainees will use when fully trained. Our trainers will travel anywhere in the world to train you face to face, or if you prefer, we can offer our whole training catalogue remotely using Teams or Zoom. On-site and live remote telecoms training sessions have a general reputation as most effective for trainees to continue to efficiently carry out their telecoms usage, programming and own in-house training of future new employees. On-site training involves employees training at their place of work while they are doing their actual job, or in pre-organised classroom training sessions, based around hands-on interaction, trainer Q&A and all carried out using your own site telephone system. Our telephone trainers also offer consultations on your new or current telephone systems: looking into how you currently use your system, making suggestions on how programming could be tweaked and changed to improve your current usage, how to improve on call handling methods, and informing you of additional products which may be available on your system that you may not be aware of. This could help improve the level of communication across your company and interactions with your customers. We believe telephone handset and voicemail training sessions are essential to the smooth and efficient running of your company, making sure your staff are aware of all the features and benefits that the telephone handsets can offer, and ensuring calls are dealt with quickly and effectively. System administration training is available to teach new administrators how to manage and control a variety of system features. This type of training is especially important when new administrators have little or no previous telecom knowledge or experience, but it is equally important at all levels to ensure the new system is utilised to its maximum capability. Administration days or Call Centre Software training days take one full day to complete. Full Day Example: 9:30 - 16:00 Day Structure 09:30 - 10:45 Handset & VM session for up to 8 people 10:45 - 12:00 Handset & VM session for up to 8 people 12:00 - 12:45 Lunch 12:45 - 14:00 Handset & VM session for up to 8 people 14:00 - 15:15 Handset & VM session for up to 8 people 15:15 - 16:30 Handset & VM session for up to 8 people Half Day Example: 9:30 - 13:00 Switchboard training takes half a day (3-4 hours for up to 3 people). If you want to train more than 3 people, you may need to extend the day to a full day, to ensure everyone gets to have hands-on training on the switchboard. Super Users and Train the Trainer Sessions Super User sessions can also be organised to show advanced system features in order to provide an ongoing training service to their colleagues, once the trainers have left the site.