58885 Courses

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a 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 utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

This course follows the Institute of Occupational Safety and Health's syllabus. A one-day programme, it is suitable for all people at all levels in the workplace and gives a basic introduction to the principles of environmental management. On successful completion of the course, participants will be able to: Understand the terms 'environment' and 'pollution' Understand the terms 'hazard' and 'risk' related to the environment Better appreciate environmental issues generally, and specifically in respect of their organisation Identify hazards to the environment from working practices Outline the procedures/controls necessary to prevent damage to the environment 1 What is the environment? - putting the environment in context Key environmental issues and how we contribute Definition of the environment 2 Working with the environment What is pollution? Sources, receptors and pathways Environmental consequences workshop - identifying the environmental consequences of our working practices Environmental risk assessment Effective control mechanisms 3 Protecting the environment - Environmental Management Systems What is an Environmental Management System (EMS)? What are the benefits of having an EMS? EMS structure and models Identifying what elements of EMS your company has and how they work Roles and responsibilities 4 Choice of module Option 1: Organisation-specific moduleThis module can be used to introduce environmental concepts that are specific to your activities and operations, and will be compiled through discussion with your organisation Option 2: Environmental best practiceIf no organisation-specific module is required, or if participants from a number of organisations attend, generic operational environmental best practices can be covered instead. Areas covered include waste management, fuel storage and use, hazardous materials, emissions to air and water and environmental incidents

It is essential that those charged with responsibility for credit control and debt recovery have a full appreciation of the relevant law: no-one can negotiate effectively to recover a debt if they don't understand the ultimate sanctions they can apply. This programme is designed to give them a practical, up-to-date understanding of the law as it applies to your particular organisation. This course will help ensure that participants: Understand the relevant laws Know how and when to invoke legal processes Avoid legal pitfalls in debt collection negotiations Specific, practical learning points include: Definition of 'harassment' How to set up an in-house collection identity Whether cheques in 'full and final settlement' are binding The best steps to trace a 'gone away'... and many, many more. 1 Data protection and debt recovery There are a whole range of things which can be checked on members of the public and which are not affected by the restraints of the Data Protection Act. These will be explained in simple, clear terms so that staff can use this information immediately. 2 County Court suing The expert trainer will show how to sue for money owed, obtain judgment and commence enforcement action without leaving your desk. This module is aimed at showing how to make the Courts work for you instead of the other way around! 3 Enforcement of judgments There are many people who have a County Court Judgment (CCJ) against their debtor but who still remain unpaid. This session explains each of the enforcement methods and how to use them to best effect. Enforcement methods covered include: Warrant of Execution Using the sheriff (now known as High Court Enforcement Officers) Attachment of earnings Third Party Debt Orders Charging Orders (over property and goods) Winding-up companies and making individuals bankrupt 4 Office of Fair Trading rules on debt recovery Surprisingly few people are aware of the Office of Fair Trading rules on debt recovery and many of those that do know think they don't apply to them - but they do. Make sure you know what you need to! 5 New methods to trace elusive, absentee and 'gone away' debtors Why write the money off when you can trace the debtor and collect the money you are owed? 6 Credit checking of new and existing customers It makes sense to credit check would-be, new and existing customers to evaluate the likelihood of payment delays or perhaps not being paid at all. This session shows a range of credit checking steps, many of which can be done completely free of charge, including a sample credit application/ account opening form. 7 Late Payment of Commercial Debts Regulations Do your staff understand this legislation and how to use it to make people pay quicker than ever before? The trainer shows how. 8 The Enterprise Act The Enterprise Act made some startling changes to corporate and personal insolvency. What are the implications for credit control and debt recovery within your organisation?

This training day will help managers explore what they need to do to create a motivating environment at work and learn some theory, tools and ideas to inspire motivation at individual and team level. Motivation is a key factor in effective people management and successful team performance. It involves engaging and inspiring your people and developing them in such ways as to improve their effectiveness and thus have a greater benefit to customers. It can also involve having tough conversations with those who do not seem to be motivated. By the end of the workshop participants will be able to: Identify key motivating factors at work and learn and create ideas to better engage staff Learn a conversation tool to use for challenging discussions Explain their role in motivating staff and understand a range of techniques and approaches to use in the workplace Review learning and have an action plan to take back and implement at work 1 Welcome, housekeeping, objectives Breaking the ice Setting personal objectives 2 Group work: identifying personal motivators and where they come from 3 Defining motivation The characteristics of a motivated team Input and group discussion 4 Factors impacting on motivation at work Using pre-work to identify challenges, hotspots and obstacles Feedback in plenary Exploring the benefits of motivation that address current challenges and agreeing outcomes for change 5 Commitment vs. compliance - organisational engagement and the manager's approach to buy in 6 Team challenge task using a theory about motivation Trainer input and review in plenary 7 Group task - complete a plan for individuals identified in pre-workshop task 8 Skill / will - a motivation tool: trainer input, followed by tasks that are assessed and discussed in peer groups 1-2-1 feedback task on approaches and plans to be taken back and used at work Feedback and plenary review 9 DEAL - a conversation tool: how to construct a conversation plan about motivation with an individual Peer professional 1-2-1s to practice the discussion planned and gain feedback 10 Review, evaluation and action planning

Any successful business manager will tell you that you never get the deal you deserve - you always get the deal you negotiate! This two-day workshop includes recent research and practical techniques from the Harvard Business School Negotiation Project and provides a unique opportunity to learn and practice these skills in a safe environment using up to date materials and life-like practice negotiation case studies. This course will help participants to: Understand the basics of negotiation Develop negotiating skills Increase their business acumen Develop their communication skills Learn the models, techniques and tools for an effective negotiation Identify the barriers to agreements Close the deal 1 What is negotiation? Key skills for negotiation Types of negotiation Win-lose negotiations versus Win-win negotiations Wise agreements and Principled Negotiation 2 Four key negotiating concepts BATNA - Best alternative to negotiated agreement Setting your reservation price ZOPA - Zone of possible agreement Creating and trading value 3 Business acumen Understanding pricing, gross margins and profit Knowing the key points on which to negotiate 4 A Four Phase Model for negotiation Nine steps to successful planning Discussing a deal - creating and claiming value Making and framing proposals Bargaining for the winning deal 5 Effective communication Effective questioning Active listening skills Understanding and interpreting body language Barriers to effective communication 6 Understanding influence and persuasion Influencing strategies Ten proven ways to influence people Six universal methods of persuasion Understanding why people do business with other people 7 Negotiating tactics Tactics for win-lose negotiations Tactics for win-win negotiations Effective team negotiating Understanding and using powerv What do you do when the other side has more power? 8 Barriers to agreement Common barriers to agreement The Negotiators Dilemma Dealing with die-hard negotiators Dealing with lack of trust 9 Potential barriers to cross-border agreements Understanding business methods and practice in other cultures Figuring out who has the power and who makes decisions Recognising and dealing with cultural differences What's OK here might not be OK there 10 Closing the deal Four steps to closing the winning deal

This very practical workshop is designed to enable participants to improve the impact, clarity and accuracy of their business documents - both internal and external.: This workshop will help participants: Identify the purpose of writing their documents - to themselves and to their readers Recognise and meet the needs of their readers Plan documents systematically and improve the layout, flow and structure Express the content more clearly, concisely and correctly Adapt the tone and style of writing to the circumstances Proof-read and edit work effectively, using formal marks and techniques Improve visual layout, format and appearance 1 Course objectives Welcome and Introductions The problems now - group discussion 2 Writing better business documents What points to highlight / exclude Starting off Introductions Conclusions Executive summaries 3 Rules and standards George Orwell's famous maxim Why write? - clarifying your aims and objectives A seven-step method for better preparation The three-stage process for writing well Grouping information for your reader 4 Proof-reading and editing The difference between proof-reading and editing Proof-reading methods and strategies Proof-reading marks and techniques Training your eye for detail Knowing what to look for 5 Effective editing Grammar and English standards Words - usage and spelling Sentences - units of thought Paragraphs - themes Punctuation - spotting and correcting common errors Say what you mean - active v passive language 6 How's your English? Grammar quizzes and punctuation test Spotting spelling errors Rephrasing jargons and clichés Common error's and mistakes 7 Document layout House style Use of white space Fonts and effects 8 One-to-one workshops These are practical sessions with one-to-one consultation with colleagues and the trainer They are held at key points to consolidate the learning from different sessions 9 Course summary Summary of key points Action plans

All organisations are legally required to have at least one designated Fire Warden. It's also common sense, given that every year there are nearly 20,000 commercial fires in the UK. This course will help participants: Assess their awareness and knowledge of the principles of fire safety and the associated risks involved at work Understand the responsibilities of being a Fire Warden Understand the main types of firefighting equipment 1 Introduction to fire safety What to do in an emergency Causes and effects of fire The fire warden's duties and responsibilities 2 Fire risk control How to raise the alarm Assembly points, roll calls, drills Fire prevention and fire risk assessment Understanding the fire triangle 3 Practical fire safety Types of portable fire extinguishers Maintenance of firefighting equipment Fire signs In-house checks The fire bag/box

Some 60% of injuries at work are caused by lifting heavy objects. This powerful, practical programme is designed to help stop any of your staff from becoming the next statistic. 1 Introduction and objectives 2 Overview of Health and Safety Legislation and HSE Injury Statistics Health and Safety at Work Act 1974 Management of Health and Safety at Work Regulations (MHSWR) 1992 MHSWR 1999 specific duties to risk assess Manual Handling Operations Regulations (MHOR) 1992 Breakdown of injury statistics and costs of poor manual handling 3 The musculoskeletal system explained Prevention and ill-health Ergonomics RSI The spine in detail 4 Risk assessment General principles The TILE method Employees' duties Workplace scenarios

This is a very popular, comprehensive, practical and experiential programme, covering: Assessing risks: Defines and demystifies risk and risk assessment. Risk assessments and a simple scoring system are introduced, and participants carry out assessments. Controlling risks: Cutting risks down, concentrating on the best techniques to control key risks and how to choose the right methods. Understanding your responsibilities: The legal framework; health & safety management systems. Identifying hazards: The main issues any organisation has to deal with: entrances and exits, work traffic, fire, chemicals, electricity, physical and verbal abuse, bullying, stress, noise, housekeeping and the working environment, slips, trips and falls, working at height, computers and manual handling. Investigating accidents and incidents: Why accidents should be investigated, why things go wrong and how to carry out an investigation when they do. Measuring performance: How checking performance can help to improve health & safety. How to develop basic performance indicators. Auditing and proactive and reactive measuring. Protecting the environment: Introduction to waste and pollution. How organisations and individual managers can get involved in cutting down their environmental impacts. The programme enables participants to: Assess and control risks and hazards Understand their own responsibilities for safety and health Investigate incidents Measure their own performance Reflect on good practice and plan how to ensure the safety of the staff for whom they are responsible

Meetings are a fact of working life - both virtual and physical meetings. Recording the key points from meetings is critical to making sure that accurate information is captured, and action points are clearly identified and allocated. This virtual training session will support members of staff to develop their skills in recording the key points from meetings and discussions. This course will help participants: Describe the different levels of note taking and pick the appropriate style for the meeting Prepare to take minutes in the virtual and the physical environment Liaise and work in partnership with the meeting Chair Use a template to enable the capturing of key points Set up the room ready for the meeting Identify key points to record, versus what not to record Interrupt the meeting confidently to check key points Take neutral, accurate and concise records Produce a well-laid out set of minutes. 1 Introduction Objectives and overview Introductions and personal aims 2 An introduction to minutes Purpose and use Different levels of notetaking 3 Preparing to take minutes Identifying the purpose of the meeting Working with the Chair Tips and techniques to prepare effectively Case studies, review and discussion The physical environment: setting up for a meeting 4 Listening and recording Tips and techniques to make the process easier How to interrupt a meeting What to record; what to leave out Recording in short-form using playscript and bullet-points Listening neutrally Activity: Minuting a Meeting The tricky ones and how to overcome problems in the meeting 5 Preparing the minutes Producing a set of draft minutes Tips on grammar, punctuation and layout Stylistic variation Managing feedback from the Chair 6 Review Summary of key learning points Action planning