Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App
Learn the skills of being more confident and assertive in the workplace plus be able to influence people to do the things you would like them to do. Course overview Duration: 1 day (6.5 hours) This ‘Assertiveness and Influencing Techniques’ workshop is interactive and practical and facilitated by a subject matter expert via a virtual platform. Exercises and breakout rooms will be used during this training. Delegates are encouraged to login from a location where they feel safe to turn on their camera, use their microphones and engage in conversations as required. Objectives The aim of this course is to introduce delegates to a variety of influencing skills and techniques to deal with aggression and challenging situations. These skills and techniques will improve confidence and personal effectiveness when working in groups / meetings. By the end of the course delegates will be able to recognise and define what assertive behaviour is and its benefits, the impact of non-verbal communication and how to use it to enhance influencing behaviours. Content What is influencing and assertiveness? Sources of power Influencing skills and choosing the right approach When to be assertive and alternative behaviours Assertive behaviour Behavioural styles and their impact on working relationships Identifying different behaviour types; assertive, aggressive, passive Building confidence and negotiating a win/win result Developing Skills Communication skills – the language of influence and communication dynamics Different influencing techniques and when to use them The art of saying ‘No’ - having the confidence to challenge Receiving criticism assertively and assertiveness behaviour analysis The language of assertion Meeting skills Giving and receiving feedback Dealing with confrontation, aggression and challenges in a confident manner Practical Exercises and Action Planning Practical exercises will be used throughout the training and the training will culminate with the creation of a personal action plan
AAT Courses Online Live AAT online courses give you the opportunity to join live online classes. You can interact with your tutor and fellow students and enjoy a shared learning experience. Whilst you are studying, live classes are held regularly to provide you with the support and structure you would get from a traditional classroom environment, wherever you are. The classes are interactive and led by a expert course tutor. Students are able to ask questions in real-time, participate in polls and check their knowledge against their fellow students. You get access to ample study resources online. AAT Level 2 Online Courses When you study aat level 2 online courses, you get coursebooks and workbooks delivered to your home address. You also get access to VLC for additional learning resources such as Practice Assessments, mock tests, crosswords, interactive assessment etc. In addition, you would be given a schedule of live classes. AAT Level 3 Online Courses When you choose to study aat level 3 online courses, you get coursebooks and workbooks delivered to your home address. You also get access to VLC for additional learning resources such as Practice Assessments, mock tests, crosswords, interactive assessment etc. In addition, through your schedule of live classes you can keep yourself up to date with rest of the group. AAT Level 4 Online Courses With aat level 4 online courses, you get coursebooks and workbooks for your chosen subjects delivered to your home address. Through your access to VLC you can join live online classes. In addition, you get ample learning resources such as Practice Assessments, mock tests, crosswords, interactive assessment etc. through your VLC account.
Understand how to effectively manage conflict and learn that conflict can be healthy and need not damage relationships. Course overview Duration: 1 day (6.5 hours) Conflict and differences of opinion are inevitable in the today’s fast moving, complex business world, some would argue they are even necessary. This highly interactive and practical course addresses the many aspects of effectively managing conflict and will help you ensure that conflict can be healthy and need not damage the relationship. This workshop has been specifically designed to give you an opportunity to learn and test a range of influencing and conflict handling models and techniques. The course is aimed at anyone who interacts with others on a regular basis. Objectives By the end of the course you will be able to: Utilise influencing skills to pre-empt and defuse conflict Resolve conflict by choosing the right approach Recognise the impact of non-verbal communication in managing conflict Use language skills necessary to get you message across in the ‘right’ way Present your case in a reasonable and responsible manner Identify behaviours that can help or hinder interactions with others Apply different techniques for managing conflict positively and for dealing with aggression Content Developing Influence Networking Sources of influence Influencing techniques Effective Behaviour Choosing the right approach Techniques to pre-empt or defuse conflict Behavioural styles and their impact on working relationships Triggers to aggressive behaviour Managing conflict flash points Dealing with different behaviour types Developing Skills Communication skills in conflict situations Using the right language Verbal and non verbal communications Managing our body language Your conflict management style analysis Thomas Killman Conflict Handling Instrument Working in groups Practical exercises and case studies The language of mediation Transactional Analysis Practical Practical exercises Case studies Personal action planning
This course will explore ways to support and enhance the quality of care provided to the individual approaching end of life, their families and their carers.
AAT Revision Courses - Overview AAT Revision Courses are greatly beneficial for people who want to prepare for AAT synoptic assessments. For each AAT Qualification, there is a synoptic assessment which students need to pass to gain the qualification for any particular level. (Level 2/Level 3/Level 4). Getting extra support just before the synoptic assessment can help you understand various exam strategies to achieve greater marks/grade and avoid wasted time and the cost of resitting. Osborne Training is an AAT Approved Training Provider and we are proud to maintain the highest standard of teaching. From a recent survey, it was found that people who studied the revision course at Osborne Training are 70% more likely to pass the Synoptic Assessment on the first sitting. Benefits For each revision course for any level, you get the following benefits. 1 Synoptic Workbook Lectures led by Expert & Qualified Teacher Helping you to get ready for the exam Achieve better grade/marks Exam Booking Service Supports you with your preparation for the Synoptic Exam Structure your revision by module Tutor feedback and workings provided Full walkthrough a practice assessment by a tutor Professional or Industry specific qualification
This confidentially & effective record keeping training course is aimed at assisting staff to understand what is expected of them regarding confidentiality, maintaining accurate up to date records and documents.
Our Equality and Diversity Training course covers the Equality Act 2010 and discusses the details relating to discrimination as well as unfair treatment within a professional environment.
AAT Courses London AAT courses London campus offers Modern IT Lab, flexible timing and expert tutors. At Osborne Training London Canary Wharf campus, we offer various AAT courses to reach your dream career in accounting. AAT Level 2 Courses in London You can join evening, weekend or weekdays time for AAT Level 2 courses in London. We provide all books and study materials to ensure you are ready for aat level 2 exams. AAT Level 3 Courses in London You may join evening, weekend or weekdays training for AAT Level 3 courses in London. We provide all books and study materials for AAT Level 3 to ensure you are ready for aat level 3 exams and pass them first time. AAT Level 4 Courses in London You may join evening and weekend training sessions for AAT Level 4 courses in London. We provide all books and study materials for AAT Level 4 to ensure you are ready for aat level 4 exams and pass them first time. We also offer AAT Level 4 project support for students. AAT Evening Courses in London Our AAT evening courses mainly run between 6 pm to 9 pm. AAT evening courses in London are suitable for people who are working full time or have other commitments during daytime. We offer AAT Level 2, AAT Level 3 and AAT Level 4 courses in the evening. Our Canary Wharf campus is minutes away from the financial hub of London. AAT Weekend Courses in London Our AAT weekend courses mainly run on Saturdays daytime. AAT weekend courses in London are suitable for people who are working full time (Monday to Friday) or have other commitments during weekdays. We offer AAT Level 2, AAT Level 3 and AAT Level 4 courses in the weekend. Day Release AAT Courses London Our AAT day release courses in London mainly run on Wednesdays. AAT day release courses are suitable for people who can commit at least one day during weekdays. We offer AAT Level 2 and AAT Level 3 day release courses.
Our monthly Social Media Marketing Update will break down the need-to-know marketing trends across TikTok, Instagram, LinkedIn, YouTube and more!