2495 Courses in Leicester

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

M&O of engineering plant and services is becoming more important to the success of the core business. To select the right M&O technique for specific plant and equipment it is necessary to know what options are available, what they deliver and how they should be implemented. This course will help you consider options and techniques that provide best value based on that thorough understanding of the business need. M&O will increasingly be required to demonstrate it is delivering the optimum of cost and value and the main purpose of the course is to show how this can be achieved. Note: this is a purely indicative list of topics that can be covered. The content, duration, objectives and material used would all be adapted to match your specific requirements. This course will help you: Determine what the business needs from the M&O service Determine the cost and value of the various M&O options Prepare and present the business case for the selected M&O strategy Introduce meaningful KPIs based on performance-based service by the M&O provider Undertake a review of current M&O and make recommendations for improvement Introduce energy and carbon management performance criteria in M&O Better deal with project risk and uncertainties Motivate others to deliver a reliable and cost effective M&O service Note: this is a purely indicative list of topics that can be covered. The content, duration, objectives and material used would all be adapted to match your specific requirements. 1 What is maintenance and what is operation? - their relative importance to the business 2 Comparison of the various maintenance options and techniques, including: Planned preventative Run to failure Condition monitoring Business focused Business critical Total productive Reliability centred maintenance 3 Forms of contracts and service, including: Comprehensive Input driven Output driven Limited replacement Performance based M&O 4 Selecting the right options and making the business case 5 Continuous commissioning as a tool for delivering best value 6 Case studies

Budgeting is more than mere vague oversight. Budgeting should deliver the corporate strategy, add shareholder value and lead to a well-run business - for the benefit of all involved in it. Effective budgeting leads to real control - effective day-to-day operational control and more. This course demonstrates what proper budgeting and operational control can do. This course will help ensure that participants: Appreciate the importance of the budgeting process Take ownership of it Use it as a daily working tool - not an annual exercise - to help run their part of the operation Improve their reporting against budget Ensure their delivery against budget 1 Objectives of budgets The budget process Stages - what is the prime aim of a budget? What is forecasting? ObjectivesPlanningImplementation 2 Budget and cost control focus Choosing objectives Links with corporate strategy Links with resource management Can the accounting systems cope? 3 Traditional budgeting and control Benefits and drawbacks The process Control and feedback Reporting - what can be expected? 4 Advanced budgeting and control Understanding the business process Taking out costs Cost awareness ZBB - as valid as ever 5 Reports Reports for action The purpose of a report Content - deliverables and feedback Culture is so important

We all tend to have challenges throughout our lives that cause varying levels of pressure. It is healthy and essential that people experience such challenges because up to a certain point an increase in pressure improves performance and quality of life. Too much pressure can be harmful and affect our health and wellbeing. This participative half-day workshop will explore the causes and impact of stress and provide an opportunity to learn some new ideas and techniques to cope with it. Practical tasks and exercises will be used to promote discussion and participants will be encouraged to share their own experiences and approaches. By the end of the workshop participants will be able to: Understand the causes and symptoms of stress and how to spot them Become more aware of personal habitual behaviours and approaches that get in the way of dealing with stress productively Learn ideas and approaches that help you to cope with the thoughts, emotions and physical feelings that happen in stressful and difficult situations Review and evaluate learning and have an action plan to take back and put into practice at work 1 Welcome, introductions and objectives Breaking the ice 2 Stress Its sources and effects on you Defining stress, its signs and symptoms 3 Exploring your 'default' habits Their consequences in stressful situations 4 Dealing with perception Strategies and approaches for coping with stress 5 Setting goals with positive outcomes Review and evaluation of learning Action planning

Are you struggling with the 'creeping kilograms?' Many of us find that not only has our weight increased over the last few years but the diets either no longer work or become harder and harder to commit to. This session will help you re-evaluate your approach to losing weight and give you the foundations for creating a plan that makes it easy for you to reach and maintain a weight that feels right for you. Take away a tool that will enable you to assess your eating type, whether you are a protein or carbohydrate based eater, and eating style, whether you prefer to be a grazer or three meals a day, and develop an eating plan that works for you. You will have the opportunity to: Explore the myths and reality of losing weight Examine self-defeating eating habits and how to replace them with energy enhancing food Learn about one change you can make today that will not only help you lose weight but improve your ability to think and manage your emotions more constructively

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

Software comes in a variety of guises - application software, firmware, middleware, system software. Increasingly, however, it doesn't necessarily present that way, especially as the boundaries between software, data and source code are becoming more and more blurred. And as software becomes more complex and more difficult to disentangle, so it becomes harder to manage and to value. But as it becomes more integral to every aspect of a business, so it is ever more important to keep on top of the technical, legal and commercial issues that arise, issues such as: To address these issues, organisations need a process for evaluating their current situation from all perspectives and for identifying the key actions they need to take to ensure holistic management of their software. This very practical programme will help set your organisation on the right path. Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. This programme is designed to give you a deeper understanding of: The technical, legal and commercial risks associated with software development, procurement, use and commercial exploitation The most appropriate processes and responsibilities for managing those risks Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. 1 Software business model What is the software business model? What options exist? Has the software business model been thoroughly reviewed to ensure its viability? This means fully understanding the market opportunity, the business environment and customer and end-user expectations. 2 Technology What are the technologies? How has the technology selection been validated considering the competitiveness, structure, and potential for future innovation? 3 UI and UX What is the UI and UX? How to best articulate this? Has the user interface and user experience been studied from both a subjective and objective view to give insight into customer behaviour? 4 Legal framework / commercial aspects Has the necessary legal framework or commercial aspects that may impact upon use or operation of the software been understood and risks identified and mitigated? 5 Software development What is the software development process? Are both the business management and development team's processes resilient in order to improve the company's capability and the maturity of the software? 6 Software quality What is quality? What are the metrics around software quality? What is the maturity level, based around a qualitative and quantitative assessment? 7 Intellectual property associated What IP should be considered when it comes to software? Does the company understand both the intellectual property risks and potential opportunities associated with this software? 8 Security What does software security mean in this context? How is it being addressed? 9 An holistic approach Review of roles and responsibilities to ensure appropriate management and protection

This intensive one-day IACCM-approved programme helps participants develop the skills, knowledge and competencies required to plan for and carry out effective negotiations in a range of different environments. By the end of the programme participants will be able to: Understand the basic concepts of negotiation and how it adds value to the organisation Recognise the stages of negotiation and the skills required at each stage Make use of tried-and-tested negotiation planning tools Apply a range of negotiation tools and techniques to support the organisation in obtaining value for money, quality and fit-for-purpose outcomes Set negotiation objectives Appreciate the importance of interpersonal skills in maximising the opportunities for reaching win/win agreements 1 Welcome Introductions Aims and objectives Plan for the day 2 Why negotiate? Understanding the negotiation context Negotiating with suppliers Negotiating with stakeholders 3 Understanding the process The phases of negotiation and what to do in each phase Before During After 4 Planning Appreciating the importance of planning Different approaches Identifying the key variables Setting objectives for each of them Practical negotiation planning exercise 5 Doing The key skills required, Communication Numeracy empathy Applying these skills in a role play: practical exercise 6 Close Review of key learning points Personal action planning

Trade barriers are going up across the globe. And cybercrime is on the increase. The link between the two? The value of trade secrets. As countries become increasingly protectionist as regards international trade, so their IP law has been changing, with the result that companies that previously would have sought protection through patents are opting to go down the trade secret route instead. But is this a high-risk strategy? Technology is changing and this is having an impact on forms of commercial co-operation. Collaborative or open forms of innovation by their very nature involve the sharing of intellectual property (IP), and in many instances this IP is in the form of valuable confidential business information (ie, trade secrets). Little surprise, then, that trade secrets disputes have increased accordingly. At the same time, the changes in technology make trade secrets more vulnerable to attack, misappropriation, theft. So just how effective are the legal protections for trade secrets? How can organisations safeguard the value in their IP (increasingly, the single biggest line in their balance sheets)? This programme is designed to help you address these issues. Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. This session is designed to give you a deeper understanding of: Emerging trends in trade secrets protection and exploitation The current situation in key jurisdictions Recent case law How leading companies are responding The importance of trade secret metadata Different external stakeholders and their interests Key steps for effective protection of trade secrets Note: this is an indicative agenda, to be used as a starting point for a conversation between client and consultant, depending on the organisation's specific situation and requirements. 1 What are trade secrets? Definitions Examples Comparison with other forms of IP (patents, confidential information, know-how, copyright) 2 Current trends The various changes taking place affecting trade secrets - legal changes, trade wars, cybercrime, technology, commercial practice The current position in the UK, Europe, USA, China, Japan, Russia Corporate best practice 3 Trade secret disputes - how to avoid them Trade secret policies, processes and systems Administrative, legal and technical protection mechanisms The role of employees The sharing of trade secrets with others 4 Trade secret disputes - how to manage them Causes Anatomy of a trade secret court case 'Reasonable particularity' 5 Related issues Insurance Tax authorities and investigations Investor relations 6 Trade secret asset management roadmap Maturity ladder First steps Pilot projects

Wouldn't sales be a 'walk in the park' without challenging customers? Why is it that some customers are so difficult to please, so quick to call 'foul' at the slightest blip and so mean with their gratitude after we've bent over backwards to accommodate them? Whether we are looking at prospective or existing customers, there is a toolkit for dealing with the most challenging of them. This course will help participants: Use broad open questions to give the customer a platform for their opinions or issues Improve listening skills to really understand what's behind the customer's challenging style Probe specific phrases to show listening and earn deeper disclosure Use silence to let challenging customers 'blow off steam' Understand the negative impact of certain phrases on a challenging customer Summarise effectively and reassure the customer of our understanding of their needs Recognise the 'behaviour cycle' and avoid emotional escalation Understand 'transactional analysis' and how to bring people from 'child' to 'adult' state Create loyalty in customers who are slow to give trust 1 What makes a customer 'challenging'? Why customers challenge us - understanding their drivers 'Wearing their shoes' - seeing things from their perspective Understanding our own personality style How to flex with a style that is different from our own Ways to quickly recognise a customer's style The benefits of flexing with a challenging customer's style 2 Practical exercise - forum theatre Participants take it in turns to deal with the trainer (who plays the role of the challenging customer) Observers stop the action when they hear or see something they deem wrong The participant in the seat gets a chance to use a suggested alternative line The participant who makes the suggestion has the chance to occupy the seat and deliver it themselves Frequent feedback from the trainer as to how the participant's words are making him feel Opportunities to rewind the action if an ill-advised line is suggested and delivered Flipchart for capturing what worked, what didn't work and why Mehrabian principle - the importance of body language and tone over words used 3 Questioning and listening skills How to use open questions to get the customer talking What questions to avoid and why The use of pauses and silence to reduce tension and build trust What listening is and what it isn't Question funnelling - how to earn deeper disclosure through probing The power of summary 4 Transactional analysis explained What is transactional analysis (TA)? Exploring the TA states and why people behave in that way under pressure How to bring challenging customers to 'adult' state to reduce tension How 'parent' or 'child' behaviours can be inadvertently triggered Understanding the 'behavioural cycle' and how to break it Mini-role play 'vignettes' to demonstrate real time impact of ill-chosen words 5 How to build trust with challenging customers Techniques for placating current challenging customers Methods that the participants have already used effectively - understanding why those methods worked and how other participants can model them Participants' experiences of trust having been lost - understanding why those experiences had that negative outcome How to 'go the extra mile' with challenging customers 6 Bringing a 'real' challenging customer to life Participants give the trainer a brief profile of a specific challenging customer of theirs 5-10 minute roleplay in which the trainer brings that individual to life Observing participants - without interrupting - make notes on what is and isn't working Trainer stops the action half-way through to give feedback on how he is feeling Participant goes back into the roleplay having recalibrated their approach based on feedback Observers give feedback on what did and didn't work Trainer comes out of character to explain the impact of the participant's words and behaviours 7 Wrap-up Key learnings from each participant Individual action planning - steps that can and will be implemented in the workplace