538 Learning courses in Leicester

The work of a technical team is invariably challenging and often unpredictable. Definition of the work can be problematic, timescales can be hard to estimate and the right technical approach difficult to select. Staff involved in this type of work usually have very high levels of specialist knowledge in their field and have high expectations of those who lead them. In addition to the challenges of the work, the team leader often has to balance the need for professional excellence with financial and commercial considerations and to ensure that team goals are realistic by being an effective negotiator with other project and senior managers. These characteristics make technical team leadership a demanding and complex activity. This programme aims to help participants develop the skills needed to become an effective technical team leader. The objectives of this programme are to help participants: understand the significance of leadership skills and their impact on team performance review the key skills needed to be an effective, 'multi-dimensional' team leader and learn how to develop, adapt and apply them in practice learn how to identify the preferred leadership style for the context and organisational culture and how to develop personal style versatility understand the role of the project leader in building an effective team and the skills required to promote and sustain team performance gain a better understanding of the interpersonal skills needed to motivate individual team members and harness the full potential of the team DAY ONE 1 Technical teams and leadership What is a leader? How much can leadership be learned? The team environment and the impact of leadership skills The characteristics of high performance teams and their leaders Some useful models and theories of leadership explored Types of leadership; choosing how to use leadership power Evaluating personal leadership style; how to develop style flexibility 2 Essential skills for team leaders 3 key dimensions of effective leadership: inwards, outwards and upwards Developing and promoting a 'team vision': strategic thinking skills The vital role of communication skills and how to develop them Understanding others; emotional intelligence skills Being a visible leader; behavioural and influencing skills Building effective relationships; the importance of trust and respect DAY TWO 3 Leading inwards to build the team The role of leadership in developing team performance Understanding individuals in the team; recognising team role preferences Managing conflict and promoting positive team dynamics Setting standards, maintaining discipline and rewarding performance Harnessing team potential: building motivation within the team Promoting team learning; the team leader as coach / mentor 4 Leading outwards and upwards to support the team Negotiating realistic team goals; effective influencing skills Gaining empowerment and support from the key stakeholders Leading upwards: knowing when and how to take the initiative Building team credibility within the organisation; helping the team deliver Becoming an effective team player in leadership teams Building and maintaining rapport with influential stakeholders

Key Objectives for the Training provision Effective listening to a client's needs and requirements during various stages of the sales process. Engage in meaningful communication with clients, learn to identify challenges and opportunities that relate to the prospects. Overcome the identified challenge. Build long term rapport and establish trust with the prospect throughout the sales process, Ensure continued customer satisfaction that can turn into repeat business. Be able to build rapport with customers or clients. Know the right questions to ask to fully understand the customer or client’s needs without putting on any pressure. Be able to check you have the right information from the customer or client. Be able to match products and services to the customer or client using the information you have gathered. Be able to influence effectively. Know how to stand out from your competitors. Stage 1 – Research the Company’s ‘Value Propositions’ and USP Analysis  Conducting 30 min confidential interviews with a cross-section of the eligible Attendees & the Stakeholders, in order to gain an objective understanding of the various scenarios and clients that the Participants work with. the Company’s ‘Value Propositions’ Unique Selling Points The Customers’ journey(s) The Competition’s offers for analysis and comparisons. From these findings, a carefully calibrated bespoke Programme will be designed and delivered.  Stage 2 - Design the Bespoke 2 x day Course  nd Stage 3 - Delivery of the Course Programme This Programme can be delivered in 2 x consecutive days, or split between 2 – 3 weeks, to make it more ‘work-friendly’ – if required. It is very practical and commercially focussed in approach, with lots of interactive exercises designed to draw out the learning applications via the debriefings. The ‘Real Play’ scenarios on day 2 will be based on specific case studies drawn from the Research findings so that they are authentic to optimise the learning. Individual Action Plans will be captured at the end of each day to be debriefed by the Participants’ respective Line Managers.  Template Programme Day One – Foundation – Strategic Approach Section One – The Principles of Consultative Selling Defining ‘Consultative Selling’ The Company’s ‘Unique Selling Points’ & Value Proposition The Consultative Selling model – the five stages Avoiding appearing ‘pushy’, ‘pressurising’ or ‘talking through the sale’ Section Two –Strategy & Preparation  ‘Buy-Class’ Matrix Strategic plan Template – matching services/products to identified needs & opportunities. Preparing a range of objectives Constants and variables – USP’s Researching key Client/Decision Makers’ priorities, profile & background (LinkedIn etc.) Preparing for potential & likely Objections Section Three – Email etiquette & ‘influencing’ email correspondence.  Email etiquette A.B.S.U.R.D model Clarity and tone – discovery of clients’ needs & motivational factors. Techniques to influence and ‘nudge’. Ensuring the data and content have a ‘gentle’ motivational & appealing message. Top Tips Day Two – Practical Application Section Four – Rapport Building & Effective Communication skills ‘Behaviour Labelling’ techniques – setting a positive tone. Asking Open Questions – gaining a full understanding of the clients’ priorities & expectations. EQ - Inviting opinions; perspectives; experiences – winning confidence. Active Listening – focus and commitment to understand. ‘Reading the room’ – adapting to responses and reactions. Maintaining focus on relevant topics that the Client cares about; carefully consider the opportunities to influence. But NO PRESSURE! Building a ‘bond of trust’ with commitments and authentic, shared values. Section Five – Explaining the Benefits – aligned to the Customers’ Priorities Understanding ‘Why do People Buy?’ Research data analysis. Open questions that lead to understanding the key issues and Clients’ priorities. Avoiding the danger of ‘pressurising’ the Client. Responding to objections effectively, with confidence and sensitivity. Explaining the benefits that are aligned to the Clients’ stated requirements. Making the Data ‘sing’ – memorable takeaways for the Client. Augmented benefits – Brand confidence; Case studies; Warranty; Service; Range; Flexibility etc. in alignment with their stated preferences/requirements Differentials compared to Competitors Section Six – Winning Commitment Inviting commitment – with confidence Consultative Selling Closing techniques (e.g. Alternative Close/Assumptive Close et al) Avoiding ‘talking through the sale’ – knowing when to ‘Shut UP!’ Confirming agreement – ensuring Clients’ motivation for repeat business Section Seven – Practical Application ‘Real Play’ From the Research findings, carefully devised scenarios can be generated to provide the most valuable learning opportunities to underpin all the skills & techniques covered in the Programme.  Potential Real Play scenarios: A well-established customer has indicated that they are soon to be opening up additional new offices – this presents an opportunity to arrange for the Company to support them with their upcoming needs. After some very positive feedback and with the upcoming contract renewal imminent – how can the Company give the Customer more high-quality support in other areas of their business? A Competitor has been to see the client and they have prompted some concerns about ‘value for money’ & ‘quality of service’. How Real Play works… The group is split the group into 2 sub-groups, one with our Professional Actor (option available); the other with the Trainer or a willing Participant. Each group has a brief and has to instruct their Trainer/Actor/Participant on how to approach the scenario supplied. The Actor and Trainer (or willing Participant) perform the role play(s) as instructed by their respective teams; however, during the action they can be paused for further recommendations or direction. The outcome is the responsibility of the team(s) – not the performers. Debrief the full Programme Individual Action Plans - to be followed through. ‘Best Practices’ for application into the business Options for Exercises within the Programme  Sample Exercise – Red & White  There is a specific time managed agenda and itinerary, which puts the group under pressure.  The key challenge is for the sub-groups to maximise the commercial value from the task, however there is always a great danger that the individuals attempt to gain financial progress at the expense of the other group! Debriefing points: Persuasive communication and influence across barriers Gaining buy-in when others are sceptical Strategic planning accounting for others’ behaviours Sample Exercise – Communication Challenge Each Participant has different pieces of information, but are not allowed to share it visually. They are only allowed to communicate to work out the solution hidden among the large amount of data. Debrief: Structured approach Maintaining focus through distractions/interference Active Listening Controlled communication Sample Exercise – Persuasive emails Sample emails are shared to be critiqued and improved upon to be debriefed: Tone & impact Making the Data ‘sing’ Influential & motivational language Customer centric message. Sample Exercise –Juggling   Each Participant has to pass the ‘Customers’ (Juggling balls) carefully through the system with all the other Participants to reach a profitable conclusion  Debrief: EQ to read the room and effectively communicate, when the pressure is on Customer focus and adapting to challenges Devising a plan that wins buy-in Overcoming competing ideas to get to ‘best practice’ Consistent commitment, communication and motivational drivers that influenced performance. Sample Exercise –Critical Path  The group are provided with 30 x discs and some ‘post-it’ notes. (no pens or pencils are allowed) Their brief is to create a grid shape with the 30 x discs, which will act as ‘stepping stones’ for the ‘Critical Path’ But they have to follow the correct order through the grid from the start to finish, which they will have to work out through ‘trial & error’ All of the team must pass through the ‘Critical Path’ worked out on the grid, observing the constraints, within the time limit. No talking is permitted once they start using the materials Debrief: - Clear communication focussing on the ‘client’s journey’ Planning for challenges Identifying risks and mitigating them Role allocations & support Quality control and disciplines  Sample Exercise –Back to Back  Each Participant is positioned back-to-back with a partner. They have to work out precisely what the ‘statement’ given to the other person is without looking around. Each person has a different brief. Debrief: - Asking Open Questions Active Listening Accuracy in identifying the objective.

REFERENCE CODE 603/5204/8 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this Qualification for? This qualification is aimed those who carry out supervisory activities in a specific trade in the Construction Industry. The qualification certificate will carry an endorsement to show what trades the candidate was supervising during completion of this qualification. The qualification has a core group of 5 mandatory units that cover areas including Health and Safety, confirming work requirements and coordinating work operations. The qualification also has a group of optional units to allow flexibility to suit individual needs and responsibilities and completion of mandatory units and a minimum of 2 units from the optional group will give access to the relevant CSCS card. This qualification replaces version 1 of the GQA Level 3 NVQ Diploma in Occupational Work Supervision (Construction) QAN 601/3469/0 for anyone starting the qualification from 01/11/2019. What is required from candidates? This qualification consists of 5 mandatory units, which have a total of 57 credits and a group of optional units. Candidates must complete all 5 mandatory units and a minimum of 2 units from the optional group. GQA qualifications are made up of units that have a credit value or credits. These credits must be achieved in the correct combination of mandatory and optional units. Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria. The units of assessment set out learning outcomes which describe what learners need to be able to do and understand. The learning outcomes are defined by assessment criteria which are used to assess competence, expressed as skills achieved and learned knowledge and understanding, to achieve the units. Achievement of the mandatory units and chosen optional units will mean the qualification has been completed and will be subject to approval of a claim for certification. GQA Qualifications will issue a certificate complete with the learner’s name, the qualification and unit titles and the credits achieved. Mandatory units Level Credit Confirming Work Activities and Resources for an Occupational Work Area in the Workplace Developing and Maintaining Good Occupational Working Relationships in the Workplace Confirming the Occupational Method of Work in the Workplace Implementing and maintaining health, safety and welfare in the workplace Coordinating and organising work operations in the workplace Optional Units – Minimum of 2 units (19 credits must be achieved) Allocating and monitoring the use of plant, machinery, equipment or vehicles in the workplace Monitoring progress of work against schedules in the workplace Confirming work meets contractual, industry and manufacturers’ standards in the workplace Implementing procedures to support the team performance in the workplace 3 13 Co-ordinating and confirming the dimensional control requirements of the work in the workplace Entry requirements There are no formal entry requirements for learners undertaking this qualification. However, centres must ensure that learners have the potential and opportunity to gain the qualification successfully. Qualification support This qualification has been designed and developed by CITB and GQA Qualifications have authorised Oscar Onsite Academy to deliver this qualification in the Construction Sector. Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for Oscar Onsite Qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

The market for professional services is becoming increasingly competitive, with some firms and individuals becoming very effective at winning new work, leaving others lagging way behind. Given the choice between spending time on client work and business development work, we all tend to choose that which we feel to be easier, more attractive and more aligned with our image of ourselves. We stay within our comfort zones, we focus on client work, and we only resort to business development work when we have to, which can also lead to 'feast or famine' syndrome. The programme will help participants: Understand the professional business development approach and the style that is appropriate for their business and their clients Follow a process to guide their conversations and business development meetings Prepare thoroughly for a business development meeting/contact with a client to ensure they use their time efficiently and maximise results Create a great first impression and professional opening to a conversation Ask open questions and listen effectively in order to spot opportunities, understand needs and progress the opportunity Identify and understand buying and decision-making processes and criteria Skilfully and confidently handle questions and objections Sell the benefits of their services and approach over those of their competitors Progress the sale by agreeing next steps and gaining commitment appropriately 1 Introduction Aims and objectives of the programme Personal introductions and objectives Workshop overview 2 An introduction to business development and selling for professionals What is selling? Who are you selling to? The buying experience What clients want The four-step business development process The business development cycle and pipeline management Upselling and cross-selling as well as winning new clients 3 Networking and generating leads What is networking? Networking objectives It's not what you know but who you know Asking for referrals and introductions Making appointments from networking activity 4 Opening the sales relationship/sales meeting What potential customers are thinking Judging first impressions Creating positive first impressions Building rapport and creating interest and impact Earning the right 5 Core communication skills for professional selling Overcoming barriers to listening The art of listening Questioning refresher Types of questions Questioning funnel 6 Understanding and identifying needs and opportunities Identifying the questions to ask to identify needs and opportunities Questions to move us through the buying and selling process Understanding their buying processes Asking questions that position you as a 'trusted adviser' The questions that give you a competitive advantage Knowing when you have asked enough questions 7 Introducing solutions Tailoring your 'pitch' to the client Speaking the client's language Using features and benefits Applying the benefit cycle 8 Handling objections and concerns Identifying the typical objections and concerns Understanding why clients raise objections and concerns Following a structure for handling objections Handling the price objection 9 Gaining commitment Knowing when to close The art of checking Recognising buying signals Small c and big C 10 Putting it all together Personal learning summary and action plans

This programme has a simple objective: to help a sales team create and implementa comprehensive account development plan. If you want to earn strategic partner or preferred supplier status with your clients and customers then you need to add value to their business, consistently, and you can only do this if you have a plan - a key account management plan. This programme will help participants: Discover opportunities - through a deeper understanding of the customer's business Develop partnership - through a better 'value proposition' for the customer Increase repeat business - based on higher customer satisfaction Improve synergy - by getting everyone to 'sing from the same hymn sheet' Develop a collaborative account plan - validated by the customer and their own management Secure resources - management will align resources to execute soundly based account plans Win an increased share of 'customer wallet' - through systematic account development 1 The six principles of strategic account development Introduction to the PROFIT account development model:- Performance- Relationships- Objectives and goals- Feedback- Integration- Teamwork Practical account development strategies: overview and case studies 2 Performance Use practical tools to help you manage and measure account performance and success Design and build a monthly account dashboard for all sizes of account Prioritise and manage accounts and customers pro-actively and successfully, using proven planning tools Develop a cross-selling strategy to integrate products or solutions into the customer's business as closely as possible 3 Relationships How to build and manage key relationships within an account Qualifying and managing key influencers accurately Producing a 'relationship matrix' for each account quickly and easily Approaching and developing new contacts strategically Tools and techniques for successful tracking of contacts and call-backs Developing a coach or advocate in every customer organisation pro-actively 4 Objectives and goals Where are you now? - how to establish your competitive position within an account Know how to set, monitor and track key objectives for accounts over the short, medium and long term Selling against the competition - developing both long- and short-term sales strategies 5 Feedback - building loyal and satisfied customers The correct way to manage customer expectations and create listening loops within an account How to monitor and track your customer's perception and satisfaction with your organisation Building a personalised satisfaction matrix for each account Customer review meetings - best practice in building loyalty by regular joint planning events Understanding the concept of long-term customer value and the importance of adapting a customer-focused attitude 6 Integration How to integrate your products or solutions with the customer's business needs and processes Spot and react to early warning signals that may cause an account's loyalty to fade, reduce revenue or switch to a competitor Developing a loyalty strategy for key accounts or groups of smaller accounts Getting your message and strategy across to C-level contacts 7 Teamwork Working with others to achieve your account goals Gaining internal commitment from your organisation Managing and working with a virtual team Creating cross-departmental communication loops 8 Putting it all together Personal account reviews Personal learning summary and action plans

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet 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 use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

In order to be an effective manager, it is extremely important to have good communication skills so that you can get your instructions across clearly and in a manner which will get you the results you desire from your employees. Our 2-day Effective Communication and Influencing course aims to provide attendees with a range of skills and behaviours which will allow them to communication clearly and effectively. Course syllabus modules include explaining the communication process, the different styles of influencing, the importance of body language and tone of voice, non-verbal communication and more. Course Syllabus The syllabus of the Effective Communication and Influencing course is comprised of seven modules, covering the following: Module One The Communication Process Identifying, what is effective communication? Recognising the different ways in which we communicate The barriers to effective communication Looking at Johari's™ Window, to better understand how communication flows Module Two Effective Communication Skills Demonstrating a positive mental attitude Establishing active listening Developing your questioning skills Using positive language Module Three Different Types of Influencing Looking at influencing versus manipulation Developing your own preferred influencing style Understanding the different influencing styles and their uses adopting a flexible style for the desired outcome Module Four Behaviour Breeds Bahaviour (Transactional Analysis) Looking at the history of hidden transactions in communications The hidden meaning in what we say and what we receive How to recognise if what you're saying is calm, rational, logical and professional Module Five Body Language Understanding the impact of body language in effective communication Noticing how your own body language influences others positively and negatively Analysing and practicing the techniques of successful body language Module Six It's All in the Voice Learning the importance of tone of voice in effective communication Realising how your tone of voice influences others Module Seven Written Communication Understanding the pitfalls of opening a discussion Identifying the different types of written communication Recognising the importance of preparation and planning Looking at different structures and layouts of written communication Using the correct words and phrases Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.

REFERENCE CODE 610/0054/0 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This qualification is aimed at those who are involved in setting out and erecting masonry structures onsite working from drawings and specifications. The structures could be brick and blockwork or local materials. It is not expected that candidates working in this industry all do the same activities, so the qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the mandatory units’ candidates will also be able to select optional units recognising specific skills What is required from candidates? Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria, this qualification has a TQT of 610 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to receive in order to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 334. Group A MANDATORY UNITS Level Credit Confirming Work Activities and Resources for an Occupational Work Area in the Workplace Developing and Maintaining Good Occupational Working Relationships in the Workplace Confirming the Occupational Method of Work in the Workplace Conforming to General Health, Safety and Welfare in the Workplace Erecting and Dismantling Access/Working Platforms in the Workplace Preparing surfaces for painting and/or decorating in the workplace Applying surface coatings by brush and roller in the workplace Optional units Group A – Minimum of 1 unit must be achieved from this group Hang wallcoverings (standard and foundation papers) in the workplace Hanging non-standard width wallcoverings in the workplace 3 20 Optional units Group B-Minimum of 1 unit must be achieved from this group Applying coatings by the airless spray method in the workplace Summary of the: LEVEL 3 NVQ DIPLOMA IN DECORATIVE FINISHING-PAINTING AND DECORATING (CONSTRUCTION) Producing and applying complex stencils in the workplace 3 21 Hanging wallcoverings to complex surfaces in the workplace 3 32 Hanging wallcoverings (specialised paper) in the workplace 4 30 Assessment Guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for these qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

Whether you have to chair a meeting, pitch a proposal or speak at a conference you need good communication and presentation skills. Addressing a group of people with assurance and confidence does not come naturally to everyone. Our presentation skills training courses will teach you how to conquer your fears and give a successful and memorable performance. We will tailor the training to your specific needs, from coaching before an important keynote or honing your pitch to improving your negotiation and influencing skills, or learning how to network effectively. A typical course can cover: Recognising the strengths of your own communication style Using the different elements of voice and body language effectively Conquering your nerves and use body language to your advantage Pitching presentations so they meet your audiences’ needs Structuring a presentation so the audience is engaged from start to finish Using visual aids Handling questions All our presentation skills training is bespoke, with options including one-to-one coaching, combined training and coaching programmes and group training courses. All these courses can be delivered virtually, as well as face to face. As many of the skills needed to give a good presentation are shared with media interviews, we frequently combine our presentation skills and media interview skills training. Venue We deliver courses in the most appropriate format for your circumstances – whether face to face or online. Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises. Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.

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