1510 Courses in Edinburgh

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

English Language courses at Bath Academy are suitable for every type of student. Join classes every Monday.

The aim of this course is to provide an overview of the principles and practice for leading and managing a portfolio of smaller projects in a multi-project / multi-task environment. It presents a range of practical methods and techniques relevant to the smaller project scenario, using exercises and case studies to show how these can be applied. The scope of the programme includes: The course also emphasises the importance of the leadership and team-working skills needed by project managers and team members in carrying out their roles. The principal training objectives for this programme are to: Explain and demonstrate the key principles of successful project management Demonstrate a range of useful project management tools and techniques Define the role, and help participants understand the skills required by, the project leader Provide a structured framework to help participants manage multiple projects Identify opportunities to improve project management within the organisation DAY ONE 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 Managing smaller projects Projects and project management Lessons from past projects; the essential requirements for success Differences between projects; characteristic project life cycles Key issues and challenges of smaller projects The multi-project world; project portfolio management 3 Project exercise Syndicate teams plan and manage a small project Review of the project exercise: What are the keys to successful management of small projects? 4 Setting up the project Getting organised Managing the definition process Identifying and managing project stakeholders Working with the customer to define the scope and agree deliverables 5 Case study 1 Defining the project scope and deliverables Syndicate teams define the scope and deliverables for a typical project 6 Project planning The importance and cost benefit of effective planning Planning the plan; deciding how detailed a plan to create Packaging the work and estimating timescales and costs Developing project / resource schedules; setting milestones for control v Identifying and managing critical path activities 7 Case study 2 Creating the project plan Syndicate teams develop and analyse the project plan DAY TWO 8 Managing project risks Identifying risks to the project outcome, timescale and cost Evaluating risks and adopting an appropriate risk strategy Defining risk ownership; keeping a simple risk log Keeping risk management up to date; staying pro-active Integrating planning and risk management 9 Project control Managing change, minimising scope creep Selecting the data needed to provide early warning of problems Monitoring performance easily with 'S' curves and slip charts Using trend forecasting to assess true project status Running project review meetings 10 Managing a multi-project portfolio Understanding the world of multiple projects Establishing ownership of project / programme management Classifying projects and creating the 'master schedule' Defining and applying project lifecycle management Resource management: essential pre-requisites and mechanisms Project prioritisation criteria and techniques; pain / gain analysis 11 Managing the multi-project team Characteristics of small project teams / part-time team membership Clarifying line and project management responsibilities Implementing effective manpower planning Establishing professional working practices in the team Developing project management competences in the team Establishing team roles and integrating team members 12 Course review and transfer planning (Course sponsor present) Identify actions to be implemented individually Identify corporate opportunities for improving project management Sponsor-led review and discussion of proposals Conclusion

Generating new leads and new business can be both time-consuming and frustrating. It's not easy - it takes skill, careful preparation and the creation of effective models and methods, even perhaps using formal approaches and scripts. Once generated, a new lead or enquiry must also be carefully managed to maximise the potential revenue it can generate. But it's crucial to get it right. If your company can afford not to worry about getting new business - congratulations! If your company is completely confident that it is performing at peak potential in generating new leads - again, congratulations! But if your company is working in the real world, couldn't your team do with some help, to become even just that little bit more effective, to make the process just that little less painful? This highly practical, intensive workshop gives sales teams the proven strategies and tactics they need to build a sustainable new business pipeline. This course will help participants: Develop a clear and consistent process for new business development and lead-generation Master the secret of effective new business development and lead-generation - 'only sell the appointment or next stage of the sales process, not your product or service' Set and achieve the right level of new business development and lead-generation activity to achieve your personal and organisational sales goals Apply the key principles of effective prospecting and pipeline management using a proven toolkit and approach Overcome the most common 'put-offs' when conducting telephone or face-to-face business-development and lead-generation activities Develop an engaging telephone voice and manner - and a 'networking personality' Qualify potential opportunities with more accuracy on a consistent basis Prioritise opportunities and manage their time when sourcing new business Discover online sources of leads, contacts and referrals Overcome psychological blocks to cold or warm calling - theirs and the client's Identify potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Make outbound sales or appointment calls with improved confidence, control and results Improve the conversion of calls to appointments by using more effective questions and sales messages Get past gatekeepers and assistants more effectively Make the most of your CRM software and systems 1 Online marketing - what works! Workshop overview and learning objectives Choosing your social media channels LinkedIn for sales and marketing Designing and implementing an effective new business email campaign online Creating a lead-generation strategy online - with case studies Avoiding common mistakes in social media marketing Case study: 'Best practice in social media sales and marketing' Using blogs and video-based marketing (eg, YouTube) New trends and how to keep your finger on the 'social media' pulse Twenty essential websites and online marketing tools 2 Making appointments by telephone Planning the call, telephone techniques, integrating with email and online marketing Developing a clear and consistent process to appointment-making Setting and achieving the right level of telephone activity to achieve your appointment goals Applying the key principles of effective prospecting and pipeline management generation, using a proven toolkit and approach Overcoming the most common 'put-offs' to seeing or engaging with you Overcoming psychological blocks to cold or warm calling - yours and the client's Identifying potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Making outbound sales or appointment calls with improved confidence, control and results Improving conversion of calls to appointments by using more effective questions and sales messages The five keys to developing an engaging telephone voice and approaching manner 3 Power networking Strategies for networking and B2B referral-based marketing The importance, and different types, of networking How to work a room - preparation and strategy Communication dynamics in networking - the power of the listening networker Assumptions when networking Business networking etiquette Making connections, asking for cards, contact details and referrals, gaining follow-up commitments Building relationships - follow-up and follow-through 4 Developing new leads Strategies for first-time sales calls Gaining rapport and opening first-time and new business sales calls effectively Advanced consultative selling - questioning techniques to quickly and efficiently uncover opportunities, need areas and preferences Presenting your solution to a new or first-time customer - creating an enthusiastic and compelling personalised and persuasive summary of your proposal Value message - differentiate your solutions clearly and accurately, with tailored value statements Presenting the right initial USPs, features and benefits and making them relevant and real to the customer Smart ways to position price, emphasise value and be a strong player without being the cheapest or leading on price Learn and use advanced techniques to determine customer needs, value and decision-making criteria in depth on a first-time call 5 Organised persistence - CRM and prospect-tracking Organised persistence - sales tracking, following up on 'sleeping' customers, gaining referrals, time and territory management Maintaining a good database for maximising new business ROI Developing a contact strategy with different types and levels of contact Analysing your contact base using state-of-the-art software and tools Making the most of your CRM systems and solutions Understanding that your attitude makes a difference when sourcing new business Setting SMART objectives for new business development and lead-generation Practical exercise - setting personal development and business goals Time management tips to improve daily productivity New business pipeline management strategies for peak sales performance 6 Workshop summary and close Practical exercise - developing your new business action plan Review and feedback

Dysphagia presents a multifaceted challenge that can culminate in aspiration, malnutrition, and a diminished quality of life. This course serves as a comprehensive exploration of dysphagia, unravelling its root causes, evaluation techniques, and measures for ensuring secure swallowing practices.

This two-day programme gives the key insights and understanding of contracting principles and the impact they have on business and operations. The course is designed for individuals involved in or supporting contracting who want to improve their commercial management skills; individuals in functions such as project management, business development, finance, operations who need practical training in commercial management; general audiences wanting to gain a basic understanding of commercial management. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Associate (CCMA) qualification. The programme addresses 31 different subject areas, across the five stages of the contracting process. By the end of the course the participants will be able, among other things, to: Develop robust contract plans, including scope of work and award strategies Conduct effective contracting activities, including ITT, RFP, negotiated outcomes Negotiate effectively with key stakeholders, making use of the key skills of persuading and influencing and to work with stakeholders to improve outcomes Set up and maintain contract management systems Take a proactive approach to managing contracts Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Develop and monitor appropriate and robust Key Performance Indicators to manage the contractor and facilitate improved performance Understand the approvals process and how to develop and present robust propositions Make appropriate use of best practice contract management tools, techniques and templates DAY ONE 1 Introductions Aims Objectives Plan for the day 2 Commercial context Explaining the contracting context Define the key objective The importance of contact management Impact upon the business 3 Stakeholders How to undertake stakeholder mapping and analysis Shared vision concept, How to engage with HSE, Finance, Operations 4 Roles and responsibilities Exploring the key roles and responsibilities of contract administrators, HSE, Finance, Divisional managers, etc 5 Initiating the contract cycle Overview of the contracting cycle Requirement to tender Methods Rationale and exceptions 6 Specifications Developing robust scope of works Use of performance specifications Output based SOW 7 Strategy and award criteria Developing a robust contract strategy Award submissions/criteria 8 Managing the tender process Review the pre-qualification process Vendor registration rules and processes Creation of bidder lists Evaluation, short listing, and how to use of the 10Cs© model template and app 9 Types of contract Classify the different types of contracts Call-offs Framework agreement Price agreements Supply agreements 10 The contract I: price Understanding contract terms Methods of compensation Lump sum, unit price, cost plus, time and materials, alternative methods Cost plus a fee, target cost, gain share contracts Advanced payments Price escalation clauses DAY TWO 11 Risk How to manage risks Risk classification Mitigation of contractual risks 12 Contractor relationship management session Effectively managing relationships with contractors, Types of relationships Driving forces? Link between type of contract and style of relationship 13 Disputes Dealing with disputes Conflict resolution Negotiation Mediation Arbitration 14 Contract management Measuring and improving contract performance Using KPIs and SLAs Benchmarking Cost controls 15 The contract II: terms and conditions Contract terms and conditions Legal aspects Drafting special terms 16 Managing claims and variations How to manage contract and works variations orders Identifying the causes of variations Contractor claims process 17 Completion Contract close-out process Acceptance/completion Capture the learning/HSE Final payments, evaluation of performance 18 Close Review Final assessment

Customers are astute and well-practised in researching and seeking information, solutions and added value in the minimum number of clicks online. There's only so much time they're willing to spend carrying on clicking. This mentality isn't just restricted to the world of B2C. In our increasingly hectic world, where information is expected to be available instantly, it applies just as much to B2B. In this workshop, we look at how putting yourself in the shoes of your customer and mapping their decision-making and buying journey is critical to ensuring that you provide what they perceive as fast solutions and added value. You will learn all about the three pillars for creating competitive brand experiences: Customer engagement planning puts you firmly in the shoes of your customer, helping you to build meaningful marketing communications delivered through the right resources at the right time to inspire your customers to engage with you. This programme will help participants to: Understand the evolution of the customer buying journey Map a customer buying journey for your brand or solutions Understand the customer micro-moments and signals indicating interest and buying intent, both online and offline Apply the psychology of branding to build marketing communications with impact Develop sales and marketing content that differentiates your brand(s) from the competition by demonstrating unique value and how you can meet your customer's needs 1 The evolution of the customer journey Understand how the use of mobile has had an impact on the customer buying journey where today's customers can research and compare products and solutions whenever and wherever they like, making the purchase journey even less linear Explore how marketers are adapting to this new customer behaviour and drawing upon various strategies to win the hearts and minds of their audiences 2 The See-Think-Do-Care framework Explore the many different frameworks used to track the customer journey Understand and apply the modern marketing model, where the internet has enabled the customer to hop between multiple touchpoints before making a purchase decision 3 Customer micro-moments and signals in their buying journey Understand the online and offline moments when customers seek information to research and make buying decisions Apply this understanding to build a marketing communication plan to reach customers at all stages of their buying journey 4 The role of branding in the customer journey Explore the psychology of branding Learn how to ensure your branding is relevant to your target customer needs Bring together your brand value and story to achieve brand loyalty 5 The Why-How-What framework Apply a systematic approach to build a successful and compelling brand Understand how starting with 'why' will help build your brand purpose Apply the content marketing matrix to communicate your brand's value Apply the hero-help-hub model to build engaging content marketing Actionable outcomes We will use your brand examples to provide opportunities for practice: You will learn and reflect on best practice examples of customer engagement You will discover your brand value, purpose and the 'sweet spot' to drive engagement with your customers You will create a customer engagement plan that can be implemented immediately within your business You will receive immediate feedback on your customer engagement plan You will have the opportunity to share common issues and solutions with your colleagues in the group

Using an excavator as a crane is a common practice in certain construction and lifting operations. Using the digger as a crane requires appropriate training and skills However, it’s important to note that excavators are primarily designed for digging and earthmoving, not lifting. Using an Excavator as a Crane involves some inherent risks, and it’s crucial to follow safety guidelines and manufacturer recommendations. To book the NPORS Excavator as a Crane training or test please contact us to schedule your Training Here are some general considerations and steps you might take when using an excavator as a crane: 1. Check Manufacturer Guidelines: Always consult the manufacturer’s guidelines and specifications for the specific excavator model you are using. Manufacturers provide load charts and other essential information to ensure safe operation. 2. Understand Load Capacities: Know the lifting capacities of your excavator at various boom lengths and angles. Exceeding these capacities can lead to instability and accidents. 3. Use Proper Attachments: If your excavator is equipped with a lifting attachment, make sure it is designed and rated for lifting operations. Using inappropriate attachments can compromise safety. 4. Stabilise the Excavator: Ensure that the excavator is on stable ground. Extend the outriggers or stabilisers to provide additional support and prevent tipping. 5. Inspect the Excavator: Regularly inspect the excavator for any signs of wear, damage, or malfunction. Pay particular attention to the boom, hydraulics, and other critical components. 6. Position the Excavator: Position the excavator in a way that allows for a stable lifting operation. Avoid working on slopes or uneven surfaces. 7. Rigging and Lifting Techniques: Use proper rigging techniques, and ensure that the load is properly secured. Lift the load smoothly and avoid sudden movements. 8. Maintain Clear Communication: Establish clear communication between the operator and any ground personnel involved in the lifting operation. Use hand signals or radios to coordinate movements. 9. Avoid Exceeding Reach Limits: Do not exceed the excavator’s reach limits. Lifting loads beyond the recommended reach can lead to instability. 10. Training and Certification: Ensure that operators are properly trained and certified for lifting operations. Holding the NPORS Excavator As A Crane bolt on is essential for lifting operations Operating an excavator as a crane requires specific skills and knowledge. 11. Weather Conditions: Consider weather conditions, especially wind speeds, as they can affect the stability of the excavator during lifting operations. Always prioritise safety when using equipment for tasks it wasn’t originally designed for. If the lifting requirements are frequent or extensive, it may be more appropriate to use a dedicated crane with the necessary capacity and features. Remember, safety is paramount in any construction or lifting operation. Frequently Asked Questions 1. What is Excavator As A Crane Training, and why is it necessary? Excavator As A Crane Training provides individuals with the skills and knowledge required to safely and effectively use excavators for lifting operations. Although excavators are primarily designed for digging and earthmoving, this training ensures operators can perform lifting tasks safely, minimizing risks and accidents on job sites. 2. Who should undergo Excavator As A Crane Training? This training is essential for anyone involved in using excavators for lifting operations, including machine operators, construction workers, and site supervisors. Proper training ensures that individuals understand equipment operation procedures, load capacities, and safety protocols. 3. What topics are covered in Excavator As A Crane Training programs? Training programs cover a range of topics, including: Manufacturer guidelines and load charts Understanding load capacities at various boom lengths and angles Proper use of lifting attachments Excavator stabilization techniques Rigging and lifting techniques Positioning and communication strategies Safety procedures and weather considerations Regular inspection and maintenance of equipment 4. Is Excavator As A Crane Training mandatory in certain industries? While not legally mandated in all areas, many employers in the construction and lifting industries require operators to undergo training as part of their occupational health and safety policies. Compliance with excavator as a crane training requirements helps prevent accidents and ensures regulatory compliance. 5. Where can I find reputable Excavator As A Crane Training courses? Reputable Excavator As A Crane Training Courses are offered by various institutions, including industry associations, equipment manufacturers, and specialized training providers like Vally Plant Training. It is important to choose a program that offers accredited certification and covers relevant industry standards and best practices.

This programme provides an intensive, two-day overview of the key elements of operations management, including an array of practical tips and tools to help managers be more proactive and effective in the operations management environment - whether that's in an industrial manufacturing context or in operational leadership in the service sectors. At the end of the programme, participants will: Understand the 6Cs approach to operations management Be able to apply a range of practical tools and techniques to improve their personal effectiveness towards being a more effective operations manager Be able to prepare an action plan for the critical first (or next) 100 days in their operational leadership role 1 Introduction What is Operations Management and where does it fit in? What makes a successful Operations Manager? Introducing the 6Cs of Operations Management 2 Context Link to business strategy Making a year plan Performance measurement 3 Controls Governance Reputational controls Costs and budgets Quality Operational 4 Customers Internal External Stakeholder management 5 Communication Planning Meetings Reporting Emails Notices Networking Walking the talk 6 Care People Safety, Health, Environment & Security Assets 7 Continuous improvement Process Product Proactivity Link to KPIs and Year Plan 8 Putting it all together Action planning for the first (or next) 100 days Conclusions