1309 Courses in Bradford

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

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

Project management can seem scary and rather intimidating. The whole aim of this programme is to give people a simple and straightforward way of dealing with projects without having to use complex and confusing systems. This two-day course is designed to introduce the apparently complex world of project management in a simple and practical manner. The programme is for anybody who has to run a project of any nature. It has been attended by people from as diverse fields as events management, fashion, charities, oil companies and so on. The programme is run without using any IT project management systems although an introduction can be given if required. At the end of the programme participants will leave understanding: What a project is and why projects are so important today The roles of a project manager Some key language and concepts A simple 5-step model for organising projects How to make sure you understand what your 'client' really wants A set of three simple tools to plan the project How to make decisions What to monitor when the project is running How to close the project 1 Introduction What is the aim of this programme? 2 Background thinking What is a project? The project manager's eternal triangle (cost-quality-time) What are the characteristics of successful projects? Who are the key characters in a project? What are the roles of a project manager? 3 The project process Why have one? 4 Project initiation What is the aim? Identifying key information Key skill: mission analysis Initial risk analysis Document and sign-off 5 Decision-making - 'Stop, Think, Act!' The 'Stop, Think, Act!' technique Recognise the opportunity to make a decision The 3 Cs - making sure we understand the decisions we have to make Identifying options Making your decision Taking it to action 6 Creativity 7 The planning stage Identify all discrete tasks Sequence and dependencies Time line - critical path Resources Project base-line 8 Execution stage - delivering the result Monitor Evaluate Adapt Control Review 9 The project close Review Documentation Have we delivered? What have we learned?

Successfully closing a sale and negotiating the best outcome for the business is a key skill for all salespeople, and often an area that is overlooked. Investing in this skill will have a positive impact on interactions with customers, both new and existing, and lead to improved sales performance. Whilst understanding how to reach a conclusion with a customer faster means increased efficiency and more time to invest in sourcing new business. We have developed this programme to be practical, fun and interactive. Participants will learn proven techniques for influencing, persuading and negotiating with clients, gain increased confidence and clarity when reviewing contract terms and prices, and understand how to structure and manage sales negotiation and contract review meetings. This course will help participants: Learn a structured and proven approach to the negotiation of contract terms Apply the key principles of negotiation, playing the person and the problem Create a contract negotiation strategy - from opening to close Recognize and put to use proven negotiation tactics and techniques Learn how to embrace conflict positively - to 'say no, then negotiate' Plan and prepare for any commercial negotiation conversations Understand the stages of negotiation and how to move through them 1 Closing and negotiating from a position of personal power The eight steps of a sales or commercial negotiation Ten ways to resist price pressure How to draw on sources of power when you have less authority The six principles of influence and persuasion and how to use them 2 Effective negotiation - planning and theory How to plan and structure your negotiation for a successful and quick conclusion Influence: knowing how to 'push or pull' to win an argument Achieving a BATNA - a range of practical skills and techniques Case study: planning for a client negotiation around contract or price issues 3 Effective closing and negotiation - practice and reality Higher-level questioning techniques to investigate and solve problems Listening to lead - active listening and structuring your conversation The most common 'unforced' negotiation mistakes and errors Case study: setting objectives, sources of value, trading concessions 4 Sales negotiation tactics and playing the game How high - how hard - how soon; why now How to identify hidden or perceived currencies and values How to use these to establish a higher base price Negotiation best-practice checklist and summary

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

When staff are new to sales it can seem daunting, especially when they have targets to meet. If the staff you need to promote your products and services get it wrong then it can knock their confidence and negatively impact how your customers see you as an organisation. This programme provides staff with the basic skills they need to sell. This course will help participants: Profile customers Research and identify potential new customers Use the consultative sales process Build effective rapport with customers Identify customer needs through effective questioning and listening Position products and services effectively Close the sale or gain commitment to further action Manage their customer portfolio to maximise sales 1 Introduction Aims and objectives of the training Personal introductions and objectives Self-assessment of existing sales skills Overview of content 2 Knowing your customers Who are your customers, and what do they want from you? What are your strengths, compared to your competitors? Who are your new potential customers? How do you communicate with new customers? What do you need to know about your customers before you start to sell? Making the initial approach Planning your pipeline - keeping the customers coming 3 The four-step sales process Overview of the consultative sales process Key benefits of using the consultative sales process Focusing on behaviours not targets The behaviours of a good salesperson Common pitfalls and mistakes Personal strengths and weaknesses 4 Building rapport First impressions - Mehrabian theory of communication Short cuts to building rapport Looking out for clues as to how the customer is thinking Looping back to keep the conversation flowing Acknowledging past communication Dealing with emotions such as anger Setting the agenda to keep control Getting past gatekeepers 5 Questioning and listening How to ask open questions to uncover information Left brain questions When closed question can be useful What stops us listening? The four levels of listening How to develop your listening skills 6 Presenting products and services to customers When to present Using benefits not features Making it personal Using reciprocity The tendency towards the middle Using consistency 7 Gaining commitment Testing the water Dealing with objections using ACLEO Asking for the business Getting referrals Ending with a personalised close Following-up 8 Managing your customer pipeline Spotting opportunities for cross-sales Managing your portfolio Maximising sales proactively Review meetings Customer satisfaction measures and surveys Mystery shopping 9 Putting it all together Skills practice Personal learning summary and action plans

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

This workshop will provide participants with the insight and skills to be more effective business networkers, face-to-face and online. The approach taken is to build on the strengths people already have and their successes. It is easier to develop what you already have than to try and develop skills that do not come easily. Being yourself is the most effective tool for business networking and building relationships. This course will help those attending: Appreciate the importance of networking, and different forms of networking Understand the dynamics of communication that are specific to networking Become more confident and assured when 'working' a room Improve their influencing skills, especially with people who are experts and in positions of authority 'Sell' themselves and promote their company Identify and manage their profiles using online social networking sites Use effective follow-up to maintain active contacts and connections Select the correct networking groups, clubs and events Create their own personal network 1 The importance, and different types, of networking Personal objectives and introductions Test networking session Examples of the importance, purpose and format of various types of networking, and benefits you can expect 2 How to work a room - preparation and strategy Three things to know before you attend any event Non-verbal communication and art of rapport Breaking the ice - worked examples with practical demonstration 3 Communication dynamics in networking - the power of the listening networker Why it is better to listen than talk Effective questioning and active listening Creating a natural and engaging conversation, 1-2-1 and in a larger group 4 Assumptions when networking How to use the 'instant judgement' of others to your advantage What assumptions are you making? How to keep an open mind 5 Business networking etiquette Meeting and greeting at a business networking event - approaching complete strangers and introducing yourself Socialising: joining and leaving groups easily Making a good first impression in 30 seconds The use of status when networking 6 Making connections Asking for cards, contact details and referrals Gaining a follow-up commitment Some tips and tricks 7 Business networking rehearsals Practice sessions 8 Personal business networking online Overview of different types of networking sites - there is a lot more out there than just Facebook! Examples of creating an effective profile Using social networking effectively - case studies and application 'Advanced' applications - blogs, articles, twitter, feeds, etc. Online demonstration and examples 9 Building relationships - follow-up and follow-through Maintaining a good database Developing a contact strategy with different types and levels of contact How to analyse your contact base

We've all sat through far more bad presentations than good ones, but knowing what 'good' looks like is easier than successfully replicating it. Sales presentations are a performance and, as salespeople, fluffing our lines can cost us a lot more than hurt pride. Having discovered and understood the specific needs and burning issues our prospect has, then this course will help any salesperson avoid dropping the ball and instead wowing their prospects with a high-impact, tailored and compelling case for purchase. This course will help participants: Prepare mentally and physically for stand-up presentations Use voice modulation and bullet-pointing to demand attention Avoid boring their prospects Master the do's and don'ts of PowerPoint Deal more effectively with technical hitches and prospect's interruptions Use eye contact and engagement to avoid prospects 'tuning out' Deploy best practice essentials for presenting with colleagues Steer through the toughest Q&A 1 Preparing your presentation Mindset Knowing your objective(s) Vocal warm-up techniques Assembling pre-agreed benefits Time management Room set-up Technical preparation 2 How to open your presentation Vocal energy Summary and agreement of prospect's needs How to have posture and confidence Use of humour What to do with those dreaded hands Confident v non-confident body language 3 How to get and keep people's attention Bullet pointing Linking benefits to specific, stated needs Practical exercise - formulating and delivering tailored benefits Being selective with features Third party reinforcement and case studies 'Watering the garden' eye contact technique Practical exercise - participants practise 'sharing out' eye contact to audience How to handle a prospect's negative body language Handling interruptions 4 Presenting in groups Credentialing all participants Role delineation for group presentations Edifying other participants' messages - do's and don'ts How to maintain energy when not speaking Practical exercise - good and bad practice when not speaking Teamwork in Q&A sessions How to hand over professionally 5 PowerPoint do's and don'ts Use of visual aids Good and bad PowerPoint slides How to make PowerPoint work for you Classic PowerPoint errors Avoiding and handling technical problems Good and bad flipchart practice 6 Closing and / or achieving next action steps Power of summary Good Q&A practice Handling objections Practical exercise - handling objections on one's feet Creating consensus among prospect panel What to do when prospects disagree with each other When to trial close How to close on next action steps 7 Wrap-up Key learning points from each participant Action steps to be implemented on next presentations

Telephone selling can be a challenge. It can be a pressured environment and sales professionals need to be able to maintain peak performance in order to meet - and preferably exceed - their targets. This programme will help make it easier for them. The expert trainer covers the whole process, to help participants see it from their customer's perspective. The focus is on how to use a practical understanding of sales psychology, and of the nature of the telephone sales conversation, to help make it easier for customers to buy. This programme will give your team the skills to: This course will help participants: Understand why people buy - and how that makes it easier to sell Manage the sales process better Steer their sales calls to a more positive outcome Recognise - and respond to - customer buying signals Meet and overcome objections Choose the most appropriate techniques for closing with confidence Enhance their resilience Improve their communication skills on the telephone 1 Introduction Aims and objectives Overview Self-appraisal of current skills and development areas 2 The sales approach What selling means Why selling is like nature 3 The telephone as an instrument of communication Qualities of the telephone How telephone communication differs from face-to-face Advantages and drawbacks of the telephone How to optimise selling over the telephone Communication techniques to help you stand out from the crowd 4 Creating a relationship Professional telephone etiquette Building a rapport Connecting with the customer so that they feel you are on the same wavelength 5 The structure of a sales call Opening the call - creating a positive first impression Effective questioning to gather information and establish need Identifying and presenting the features and benefits of the product or service Matching the benefits to customers' needs Recognising and responding to buying signals Anticipating, meeting and overcoming objections Closing the sale and asking for the order - different closing techniques The importance of testimonials - how to obtain them and when to use them 6 Listening skills The challenges of accurate listening How to enhance listening skills Ensuring the customer feels heard and understood through empathetic listening 7 Shaping and using a script Developing a script to increase levels of confidence Leaving the door open 8 Managing the campaign Organisation and call planning Identifying your target market group Planning who and when to call Logging constructive information 9 Personal management The importance of persistence Is there a time to back off? Stamina - optimising energy levels Bouncing back 10 Practising the new information Pulling the details together Practising in a supportive environment 11 Action planning Personal learning summary and action plan