REFERENCE CODE 600/6515/1 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with routine assignments. Candidates should require minimum supervision in undertaking the job. The qualification has been developed in a way to allow employees from companies of all sizes and specialisms equal opportunity to complete. This qualification is specifically aimed at those carrying out general construction operations work; there is a Level 2 qualification for those involved in maintenance along with a suite of specific qualifications in a wide range of construction occupations available.
This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint
As technology continues to develop and increasingly interact with our daily lives, so must our sales techniques to ensure we're leveraging advances in how people do business to our advantage. It is essential for all salespeople to understand how to navigate the various tools at our disposal and grow their skills and confidence to put them into action in order to build a solid business pipeline. We have developed this programme to be practical, fun and interactive, whilst ensuring that participants will learn how to utilise new technology to their advantage, self-generate new business leads and opportunities, gain additional business and referrals from existing contacts, and save time and effort using proven business development skills. This course will help participants: Understand the 'organized persistence' model of sales prospecting Develop skills in using video, online and social media to generate interest Understand how to write effective sales and outreach emails and using online tools Develop techniques for effectively managing telephone appointments Learn ways to use LinkedIn for connecting with customers and prospects Develop networking skills and learn how to source and develop referrals and professional introductions 1 Key principles of smart sales prospecting Set your sales prospecting goals and objectives Elevator pitch, core messages and your value proposition Targeting and segmenting your market 'Organised persistence' using your CRM effectively 2 Setting appointments by telephone - planning and preparation Why calling still works and the best times to call Creating a call prompt sheet: Opening a call and taking control Giving a reason to meet Key questions to ask Overcoming the cold calling blues 3 Setting appointments by telephone - advanced skills Giving a reason to meet and 'selling the appointment' Key questions to ask that will create interest and motivation to meet Voice tone, power words, phrasing, pausing, responding Getting past gatekeepers and getting through 4 Using LinkedIn for research and follow-up Why LinkedIn matters and how to use it Finding new contacts, connecting and Inmailing Short-cuts and advanced skills 5 Email strategies that work Using AIDA and other templates for sales emails Using personalized video emails to create interest Vertical targeting emails, with examples Building awareness with an email chain
REFERENCE CODE 603/7248/5 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview The aim of this qualification is to confirm that the candidate has the skills and knowledge to install Curtain Wall systems on site. It is not expected that all curtain wall installers will carry out identical tasks as there are many variations in system types and installation environments, so the qualification had been developed to allow as wide an uptake as possible. All of the work needs to be completed in accordance with relevant legislation, regulations and health and safety guidelines
REFERENCE CODE 610/0075/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at individuals wishing to prove they have the level and range of knowledge and skills required to install Interior Systems in the Construction working environment. It is not expected that all workers will complete the same tasks, there are 3 mandatory units common to all pathways. The Pathways will allow employees with specific skills and from companies of all sizes equal opportunity to complete. All work must be completed following Industry recognised Safe Working Practices and in accordance with relevant legislation. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with a range of tasks and situations. There is also a Level 2 Certificate and a Level 3 Diploma in Interior Systems available.
Our self-leadership and executive development programme can be fully ITA SDS funded supporting leaders and business owners and creating a growth plan. SDS INDIVIDUAL TRAINING ACCOUNTS (ITA) Rely On Our Team for Your Executive Development The Power Within Training offers unrivalled executive development training for go-getters and self-starters throughout England and Scotland. Did you know that approximately 55% of people making their living in sales don’t have the right skills to be successful? Good sales skills are some of the rarest and most sought-after skills in the workforce. Whether you’re running a business, looking to progress further in your career or want to sharpen your skills before returning to work, our self-leadership training will help you develop the skills you need to succeed. After completing our executive development training, you’ll have a sales mindset and the skills to secure your ideal role, perform better, and utilise high-payoff action-planning techniques. Don’t hesitate to contact us to learn more information. OUR TRAINING SOLUTIONS What is Self-Leadership Executive Training? Self-Leadership Development Our self-leadership development course was designed to give you total control of your career, business, and professional life. Most professionals will spend more than 80% of their time at work or in business. We’ve structured our executive training to help those looking to enhance their career prospects or business success by taking advantage of our unique Motivational Intelligence seven steps to success framework. The seven-step success system will take you through a journey of self-discovery, self-awareness, and self-development, which enables you to understand the barriers and self-limiting obstacles that have been holding you back. The Power Within’s self-leadership training will guide you through overcoming these barriers and eliminating them from your life. If you are looking to stand out from the crowd and build a career or business you can be proud of, then this live classroom-based programme is definitely for you. Benefits of Self-Leadership Development The self-leadership training has been designed from the ground up to inspire, guide, and develop you into not only achieving your goals but being able to measure success in your career, help you find your dream job, and help make an immediate impact in everything you do. Completing our executive leadership development course will allow you to utilise emotional intelligence to get the best of your team while focusing on clear values and principles that increase your overall success and profitability. Working on your self-leadership skills will grant you greater insight into the factors hindering or impacting your success while giving you the tools to make decisions and get into action. Here are some additional benefits of our self-leadership training: Build Awareness – When you’re a leader, you must inspire and motivate people to achieve and go after the bigger picture for your organisation. You’ll need an effective and flexible leadership style to ensure your team succeeds. We’ll help you discover your leadership style and how you can use it effectively to the advantage of your business. Increase Team Engagement, Motivation, and Accountability – How can you expect your team to behave if you’re no longer motivated to succeed? The Power Within will give you the tools to keep striving toward success while ensuring your business is focused and motivated. Cultivating a High-Performance Culture – The right high-performance culture installs peak performance into every team member. Through our executive development, you’ll be able to help each reach their targets while they look for ways to improve constantly. Develop Strategic Skills – We’ll help you develop leadership skills and self-improvement goals, allowing you to introduce changes to your business based on your guiding visions while encouraging others to share the same vision. If you are looking to stand out from the crowd and build a career or business you can be proud of, then this live classroom-based programme is definitely for you. What Are the Key Skills Learned from Executive Development Training One of the first sets of vital skills for self-leadership you’ll learn is the ability to stop, step back, and reflect on the things that trigger us to react. When we react, we’re being controlled by the trigger. Another skill we’ll help instill is to consider intention. Intention is important to us, such as our values and what we’re trying to achieve. When you become intentional, you start to live a life of choice. Self-leadership and executive development are a journey. The more self-leadership we attain, the more successful we’ll become. The more successful we become, the more self-leadership we need. Here are some additional critical skills you’ll learn from our self-leadership training: Self-Awareness – It’s vital to hone your ability to see yourself as clearly as you are. This skill takes dedication, introspection, and mindfulness. Also, a dose of self-awareness helps with self-control, self-confidence, and feelings of validation. Overall, you should be open to critique and accountability. Goal Setting – A good self-leader must be proactive in not only identifying their goals but how to reach those goals in a manageable manner. Our executive development training will teach you how to break down a larger goal into more attainable steps to avoid burnout while helping you celebrate smaller milestones. Self-Motivation – A classic way to handle self-motivation is to divide long-term goals into smaller, more attainable ones. This optimization means recognising what about the goal that appeals to you, then forming a strategy that aligns with your strengths and values toward that goal. Constructive Thought Patterns – Through our leadership skills and self-improvement course, you’ll be able to review your performance and assess your intentions and effectiveness while providing an opportunity to ensure your strategies are geared towards success. This is done by focusing on improving strengths and the mental imagery of yourself that recognizes your capacity to grow, develop, and change. Self-leadership training teaches you to see yourself as having the ability to create, improvise, innovate, and adapt. OUR LIVE WORKSHOPS ARE BACK What’s Covered in Our Executive Development? Self-Leadership "It's a mindset thing" When you undergo our self-leadership training, you’ll experience several modules designed to allow your conscious and subconscious belief systems to work together for a predetermined goal or set of outcomes. Self-leadership is one skill that will significantly impact your career, team, and even your life’s happiness. Our executive leadership development course promotes bold and powerful decisions to get you back into the driver’s seat of your life and make the best of each day by setting goals, shifting your mindset, and finding your purpose. During each module, we’ll work with you and help you design and deliver your team leadership programmes catered to your team and your business dynamic. Our goal is to allow you to evolve into a bigger and better leader. Here are some of the modules in our self-leadership training: Unleash Your True Potential Create Your Personalised 7-Step Success Framework Peak Performance and Self-Mastery Growth Mindset and Mindset Performance The Power of Feedback Taking Back Control of Your Personal & Professional Journey Goal Setting & Defining If you are looking to stand out from the crowd and build a career or business you can be proud of, then this live classroom-based programme is definitely for you. Discover Who’s Leading Our Self-Leadership Training James Fleming, the co-creator of The Power Within, will lead your self-leadership training. James founded The Power Within with his wife, Enas Fleming. They wanted to inspire people around the world to think better, be better and achieve more. James believes that everyone can be whatever they set their minds to. Founding The Power Within allowed James to turn that deep knowledge into a business that helps others think bigger, better, and achieve more daily. He strives to give leaders the tools and knowledge to achieve their full potential while increasing their self-confidence and self-belief through Motivational Intelligence Revolution. James wants to support today’s businesses to become tomorrow’s leaders. Course Overview Our self-leadership development course is a quick-paced training that is between eight and twelve hours in length. After you attend the face-to-face workshops, you’ll be given access to our online self-leadership training portal. This allows you to continue your journey of self-development by ensuring you’ll always have a system and process to fall back on when you need it. One of the best parts of our executive development course is that you receive this information fully funded. Even if you aren’t eligible for funding, you can still invest in this course and begin a new chapter of professional development for yourself. Elevate yourself if any of our eligibility requirements apply and you early less than 22,000 a year.
This very practical one-day programme provides participants with the skills and knowledge required to be an effective member of the procurement team and to enable them to procure a wide range of resources for the organisation, in a compliant and cost-effective manner. It also empowers them to be able to collaborate with all key stakeholders. By the end of the programme participants will be able to: Understand the basic concepts of good procurement practice Apply a range of tools and techniques for developing scopes of work and specifications Apply various methods to select and evaluate suppliers Develop robust contract award strategies Appreciate the commercial importance of effective procurement and opportunities to reduce cost and add value Develop appropriate procurement strategies depending on risk and value Appreciate the legal aspects of procurement 1 Welcome Introductions Aims and objectives Plan for the day 2 The basics of procurement The concept of total cost of ownership v price The procurement cycle The roles of the customer and the contractor Impact upon profit 3 Specification process Importance of effective specifications Specification development process Types of specification Team approach Use of performance specifications Early supplier involvement (ESI) / early contractor involvement (ECI) 4 Quality Concepts and practices Defining 'fit for purpose' Conformance to requirements Compliance to standards Role of the supplier Quality assurance tools and techniques 5 Procurement methods RFP RFQ ITT Negotiated procurement Strategic partnerships Outsourcing 6 Tendering How to undertake a formal tendering process Business case to award Critical stages in the process Risks and benefits 7 Tender evaluation How to undertake a quotation analysis Tools of analysis Use of VFM models Role of the customer Comparisons around cost, quality, and delivery 8 Supplier selection and evaluation Developing critical selection criteria Using the 10Cs model Importance of effective selection process Weighting systems Importance of validity and evidence 9 Capital equipment procurement Life cycle cost issues Payback calculations Compatibility issues Maintenance and training issues After-sales support 10 Supplier relationships Corporate social responsibility issues Communication 360 feed-back Open and ethical Initial understanding Clear and fair terms and conditions 11 Close Review of key learning points Personal action planning
Maximising the relationship and sales potential of each active account is key to the sustainability of any business relying on repeatable custom. In this workshop we start by looking at key techniques for analysing the profitability and development opportunities for different clients before deciding upon the strategy and skills needed for moving the relationship to that of trusted adviser and partner. By understanding and creating the need we can use our influencing skills to harness any sales development potential. By creating the habit of explaining our ideas in a way that also meets the need of the other party we help everybody make the right decisions for them. This course will help participants: Assess the sales profitability and potential of existing key accounts Prioritise where time and energy is directed for maximum profitability Understand the key players in the decision making unit Create a strategic plan for the development of each client target Develop proactive sales consultancy skills Learn advanced communication and influencing techniques 1 What makes an effective account manager? The difference between order taking and account management How do you define a key account in your business? Why should existing customers remain with your company? How do you compare to the competition? 2 How do I prioritise my account management activity? Use practical tools to help you assess revenue potential Analyse the investment required versus the return on your time Create a SWOT analysis on your clients - Strengths, Weaknesses, Opportunities & Threats Appreciate how this knowledge will improve your sales development 3 Planning strategies for each account Create a list of priority accounts and activities Learn how to develop a long-term and sustainable relationship Discover how they make their purchasing decisions Research the make-up of the Decision Making Unit for each client 4 Learning and utilising the six principles of influence Learn the secrets these principles offer sales people Discover how these principles will work for you Create an influencing strategy for influencers within the client Learn new habits of influence 5 Proactive sales skills Plan proactive sales meetings for key accounts Set primary and secondary objectives for every touch point with the customer Structure sales meetings for maximum effectiveness Help the customer commit and achieve their objectives 6 Putting it into practice Discuss real scenarios to plan for putting these skills into practice Share common issues with fellow sales people Create a personal development plan
REFERENCE CODE 600/8370/0 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in carrying out insulation or associated treatments to buildings; this could be on internal or external surfaces or structures. The qualification is designed to ensure that there is a high degree of flexibility within the units available that will allow employees from companies of all sizes and specialisms equal opportunity to complete. All work completed must be done in accordance with Building Regulations and Industry recognised safe working practices, including the disposal of waste. The standards cover the most important aspects of the job. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with routine assignments. Candidates should require minimum supervision in undertaking the job.
English Language courses at Bath Academy are suitable for every type of student. Join classes every Monday.