155 Courses in Bradford

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online

This very practical two-day workshop analyses the content and implications of key MoD terms and conditions of contract. The programme explains the principles and terminology of the contractual aspects of defence procurement as well as considering a number of relevant policies and initiatives. The course covers key components, constructs and methodologies associated with any commercial venture entered into with the UK MoD. Starting at the MoD organisational level the workshop sets the scene by looking at the acquisition process and organisation, detailing the various roles and responsibilities of MoD personnel. The workshop provides an in-depth examination of MoD DEFCONs and many narrative terms, setting them in the context of the organisation and its structures. The workshop helps participants to gain an understanding of the content and purpose of the range of MoD DEFCONs and narrative conditions commonly used throughout the acquisition lifecycle. It includes a review of Part 2 of the Defence Reform Act 2014 regarding Single Source Pricing, which comes into effect in 2015 and is already starting to be applied to significant contracts. On completion of this programme the participants will understand the terminology associated with the MoD terms and conditions of contract and will have an accurate view of their relevance, usage and their legal basis and how they can affect contractual and commercial decision-making. They will have gained an insight into defence acquisition contracting and they will be more commercially aware. DAY ONE 1 The commercial environment Key roles and responsibilities of the MoD organisations at the heart of the acquisition process 2 Tendering to MoD An appraisal of some of the obligations placed upon contractors when they are submitting a proposal to the MoD pre-contract 3 Standardised contracting MoD have introduced non-negotiable standardised contracts for certain levels of procurement. This section considers their use and relevance to defence contracting 4 Pricing, profit, post-costing and payment The parameters specific to a costing structure and the differences between competitive and non-competitive bidding The role of the QMAC, the profit formula, the requirements for equality of information and post-costing Different types of pricing and issues surrounding payment 5 Defence Reform Act - Single Source Pricing Single Source Pricing under Part 2 of the new Defence Reform Act Changes from the existing position, how contractors are affected and the compliance regime that accompanies the new requirements 6 Delivery and acceptance Specific requirements and the significance and impact of failing to meet them Acceptance plans Non-performance and the remedies that may be applied by the Customer - breach of contract, liquidated damages and force majeure DAY TWO 7 Protection of information and IPR Contractor's and MoD's rights to own and use information How to identify background and foreground intellectual property Technical information and copyright in documentation and software How to protect IPR at the various stages of the bidding and contracting process 8 Defence Transformation and Defence Commercial Directorate Widening and increasing roles and functions of the Defence Commercial Directorate Background to the Defence Reform Act 2014 9 Legal requirements Terms used in MoD contracts to reflect basic legal requirements Records and materials required for MOD contracts and therefore the obligations, responsibilities and liabilities that a company undertakes when it accepts these conditions Overseas activities 10 Subcontracting and flowdown Understanding the constructs required by the MoD for subcontracting Which terms must be flowed down to the subcontractor and which are discretionary 11 Termination Termination of a contract for default Termination for convenience How to optimise the company's position on termination 12 Warranties and liabilities Obligations and liabilities a company might incur and how they might be mitigated MoD policy on indemnities and limits of liability 13 Electronic contracting environment Electronic forms of contracting Progress toward a fully electronic contracting environment

This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document

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

An insightful, enjoyable and experiential programme to help you analyse data and information and make a balanced decision based upon sound commercial reasoning. It will enable you to identify options, make decisions and take actions based on a thorough analysis combined with instinct and intuition to make a positive effect on profitability. This programme will help you: Identify ways to analyse data and sort relevant from irrelevant information Develop analytical and numerate thinking, and consider the financial implications of a decision Make decisions based on sound commercial reasoning - a mix of intuition and analysis Select from a range of tools to analyse a situation and apply these effectively Understand how costs and profits are calculated Use tried-and-tested techniques to manage and control your budgets Appreciate the fundamentals of financial analysis Focus on the bottom line Identify the basics of capital investment appraisal for your business Evaluate results and seek opportunities for improvement to your business 1 The commercial environment What do shareholders and investors want? What do managers want? Profit v non-profit organisations Investor expectations 2 Financial and non-financial information Risk and reward considerations Drivers of commercial decisions 3 Running a business A practical exercise to bring financial statements to life Different stakeholder interests in a business The impact and consequences of decisions on financial statements 4 Where do I make a difference to the organisation? How can I contribute to an improved business performance? Key performance indicators - measuring the right things A 'balanced scorecard' approach - it's not all about money! 5 A 'balanced scorecard' approach Analysing and reviewing my contribution to the business direction What is the current focus of my commercial decisions? Developing the business in the right way - getting the balance right! Where should/could it be in the future? Do my decisions support the overall vision and strategy? 6 Making commercial decisions Left-brain and right-brain thinking Convergent and divergent thinking Analysis and instinct Interactive case study exercise - emotional and rational decisions Reflection - what is my style of making decisions 7 Let's consider the customer! Identifying target markets Differentiating propositions and products Customer service considerations Marketing considerations and initiatives Pricing strategies and considerations 8 Strategic analysis The external environment The internal environment LEPEST analysis SWOT analysis Forecasting Group activity - analysing markets and the competition How do these improve your decisions? 9 Comparing performance Analysing key financial ratios Ways to compare performance and results Break-even analysis 10 Profit and loss accounts and budgeting Managing income and expenditure The budgeting process How does this link to the profit and loss account? Managing and controlling a cost centre/budget The role of the finance department Different ways of budgeting Incremental budgeting Zero-based budgeting 11 Understanding the balance sheet Purpose of balance sheets Understanding and navigating the content What does a balance sheet tell you? How do you affect your balance sheet? Links to the profit and loss account A practical team exercise that brings financial statements to life 12 Business decisions exercise How does this improve your decisions? A practical exercise to apply new knowledge and bring commercial thinking to to life The impact and consequences of decisions on financial statements 13 Working capital Why is this important? The importance of keeping cash flowing Business decisions that affect cash Calculating profit 14 Capital investment appraisal Capex v Opex Payback Return on investment The future value of money The concept of hurdle rate 15 Lessons learned and action planning So what? Recap and consolidation of learning The decisions that I need to consider Actions to achieve my plan