This Tableau Desktop Training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. Attendees should have a good understanding of the fundamental concepts of building Tableau worksheets and dashboards typically achieved from having attended our Tableau Desktop Foundation Course. At the end of this course you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. The Tableau Desktop Analyst training course is aimed at people who are used to working with MS Excel or other Business Intelligence tools and who have preferably been using Tableau already for basic reporting. The course is split into 3 phases and 9 modules: Phase 1: AMPLIFY MODULE 1: CHECK ABILITIES Revision – What I Should Know What is possibleHow does Tableau deal with dataKnow your way aroundHow do we format chartsHow Tableau deals with datesCharts that compare multiple measuresCreating Tables MODULE 2: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 3: ADVANCED CALCULATIONS Row Level v Aggregations Aggregating dimensions in calculations Changing the Level of Detail (LOD) of calculations – What, Why, How Adding Table Calculations Phase 2: ANALYSE MODULE 4: EXPAND APPLICATION Making things dynamic with parameters Sets Trend Lines How do we format charts Forecasting MODULE 5: ADVANCED MAPPING Using your own images for spatial analysis Mapping with Spatial files MODULE 6: DATA COMPARISONS Advanced Charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Phase 3: ACT MODULE 7: ADVANCED DASHBOARDS Using the dashboard interface and Device layout Dashboard Actions and Viz In tooltips Horizontal & Vertical containers Navigate between dashboards MODULE 8: PRESENT STORIES Telling data driven stories MODULE 9: ENABLE DECISIONS What is Tableau Server Publishing & Permissions How can your users engage with content This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must bring their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium “Steve not only provided a comprehensive explanation of the content of the course, but also allowed time for discussing particular business issues that participants may be facing. That was really useful as part of my learning process.”Juan C., Financial Conduct Authority “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium
Effective communication is a skill. This half-day workshop is very interactive - participants can practise their communication skills in a positive, supportive environment. 1 Welcome, introductions and objectives The definition of effective communication Exercise: sending a message 2 Verbal communications Effective communicators - who are they? What skills or attributes do they have? Listening skills, clear use of words, presence, eye contact, body language 3 How good a listener are you? Exercise: listening skills questionnaire and evaluation 4 Impact versus intent - what did you really mean to say? Attitudes influence behaviour and behaviour breeds behaviour Exercise: 'I never said she stole money' The need to avoid misunderstanding or misinterpretation 5 The 5 key principles to effective communication Exercise: 'What would you say?' 6 Written communication What makes an effective written communication? Kipling's 6 Honest Men: who, what, where, when, why and how Planning to write an email 7 Fuzzy meanings Probabilities for misunderstandings and misinterpretations 8 Practical exercise Hone written communication skills and put into practice hints and tips from the session 9 Review of key learning points and objectives
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 clicheÌ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 today operate in an environment of constant and rapid change. Managing this change effectively is often achieved through a portfolio of formal projects. Many organisations today have qualified and experienced project management staff to run their projects. Some organisations today have dedicated functions, staff or processes to support their project management teams. The very largest organisations have in-house Enterprise Programme Offices, or project management specialists in corporate audit or risk functions; or organise 'Red Team Reviews' of a project by other staff with project management experience who are not participating in the reviewed project. But for many mid-size businesses and SMEs - and even some larger organisations - these resources are simply not available. For them, having access to external expertise to assure project management disciplines and to coach project managers can be a major contributor to project success. Such reviews can take place at project initiation; at major stage-gates (especially if significant capital is to be committed at the stage-gate); or at any other time if concerns arise concerning project quality, cost or timescales. And it is for those organisations that we offer the necessary expertise, on an ad hoc basis, in reviewing projects and coaching senior project management staff. A document review and workshop led by one of our consultants can help you assess whether: The strategic goals and priorities for the project are clear and being addressed Governance of the project within the business is defined and being effectively executed Project roles and responsibilities are clear and effective The credibility and robustness of the project plan can be enhanced Performance measures and reporting procedures are effective Critical risks are identified and being managed and contingencies are agreed The roles, responsibilities and capabilities of the key players in the project team are fit for purpose Budgets are realistic and costs being managed effectively Communication and change management activities are effectively planned and being executed At your discretion, you can capture the outcomes from the workshop for yourselves, in terms of identifying opportunities for improvement, or you can have our consultant write a report and make recommendations to you.
Mental Health First Aid (MHFAider) is an internationally recognised training course that teaches people how to spot the signs and symptoms of mental ill health and provide help on a first aid basis. We don't teach people to be therapists, but we do teach people how to respond in a crisis, and how to reach out before a crisis happens. The training gives people tools to support themselves and each other, so everyone can talk about mental health and seek help when needed. As an MHFAider you will be able to: Recognise those that may be experiencing poor mental health and provide them with first-level support and early intervention Encourage a person to identify and access sources of professional help and other support Practise active listening and empathy Have a conversation with improved mental health literacy around language and stigma Discuss the role in depth, including boundaries and confidentiality Practise self-care This course is ideal for those who would like to become an MHFAider to: Gain the knowledge and skills to spot signs of people experiencing poor mental health Be confident starting a conversation and signpost a person to appropriate support Alongside the best evidence-based Mental Health First Aid (MHFA) training, MHFAiders are also provided with three-year access to ongoing learning and support through the MHFAider Support App 1 Introduction to MHFAider (3 hours 30 mins) MHFA and the MHFAider role Introduction to the MHFAider Action Plan 'ALGEE' What is Mental Health? Helpful and unhelpful language Undersign our Frame of Reference, understanding how we make sense of the world Understanding stress & the Stress Container 2 Understanding Mental Health (4 hours) What influences mental health? The Mental Health Continuum What is anxiety? What is a traumatic event? Active listening and empathy What are eating disorders? What is self-harm? What is substance misuse? MHFA conversation practice 3 MHFAider in practice (4 hours) Applying ALGEE What is depression? What is suicide? What is psychosis? MHFA conversation practice 4 Next steps (3 hours) Recovery and lived experience Applying ALGEE Boundaries in the MHFAider role MHFA conversation practice Moving forward in the MHFAider role and your MHFA action plan Self-care
It is important for Officers to understand the roles and responsibilities, processes and procedures involved when working with Elected Members. They also need to appreciate the significance of Elected Members as the decision-makers in local government. Officers have a responsibility to work and communicate with Elected Members effectively. This very successful course is designed to help Officers with this. Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. To provide managers with the knowledge and understanding they need to have productive working relationships with Elected Members and provide appropriate support. By the end of the course participants will: Understand the roles, responsibilities, processes and procedures in place for working with Elected Members Be able to identify the best way to approach potentially sensitive issues Understand the skills and behaviours required for working effectively with Members Be able to deploy their influencing skills more successfully Review their learning and have an action plan to take back and implement at work Note: this is very much an indicative outline. The programme is tailored to the needs of each particular organisation. 1 Introduction Welcome and introductions Objectives and programme overview 2 Working in a political environment What is political awareness? Contact and experience with Members Importance of the role of Members 3 Why be an Elected Member? Perceptions of what Elected Members are and do Values of Members and their motivations for doing what they do 4 Political decision-making in local government Current challenges and drivers affecting the organisation / the council Roles and responsibilities of Officers and Members Centrality of Members' strategic role 5 (Option) A day in the life of an Elected Member An Elected Member gives a talk about what they do 6 Having a beneficial relationship between Officers and Members 7 Member / Officer communication Discussion of the formal processes, service procedures, etc (whether enshrined in a protocol, Memorandum of Understanding, etc) Response times and requirements Procedures required by Heads of Service [if appropriate] 8 Influencing styles and strategies Different forms of power and how they impact Developing an appropriate 'influencing style' Exploring strategies for improving communication and influencing at work 9 Review and evaluation Review and evaluation of learning Personal action plans
This intensive one-day training programme has been developed to help those involved in producing specifications create high quality documents in an organised and effective way. The programme explains the primary purpose of specifications and the importance of understanding the context in which they are used. It focuses particularly on how to develop and structure content and write requirements that are clear and concise. The methods and techniques presented will provide a practical foundation course for those new to the topic whilst offering new insights to those with more experience. The objectives of the workshop are to: Review and discuss the role and purpose of specifications Present a structured approach for organising and producing specifications Explain each of the key steps involved in creating effective specifications Review some methods for assisting in defining requirements Explain how to define the scope and develop the structure for a specification Present methods to assist the writing and editing of specifications Review how specifications should be issued and controlled 1 Introduction Course objectives Review of participants' needs and objectives 2 Specifications in perspective The role and purpose of specifications The impact of specifications on commercial performance The qualities of an effective specification The five key steps of 'POWER' writing: prepare-organise-write-edit-release 3 Step 1: Preparing to write Defining the purpose the specification; integrating the specification and contract Deciding how to specify: when to specify in functional and technical terms Getting the right people involved at the right time; engaging stakeholders Applying procedures for writing, issuing and controlling specifications 4 Step 2: Organising the specification content Scoping the document: scope maps, check lists, structured brainstorming Clarifying requirements; separating needs and desires Dealing with requirements that are difficult to quantify Useful techniques: cost benefit analysis, Pareto analysis Deciding what goes where; typical contents and layout for a specification Creating and using model forms: typical sections and sub sections 5 Step 3: Writing the specification Identifying and understanding the readers needs Choosing and using the right words; dealing with jargon Important words; will, shall, must; building a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity; being concise and ensuring clarity 6 Step 4: Editing the specification Why editing is difficult; how to develop a personal editing strategy Key areas to review: structure, content, accuracy, clarity, style and grammar Editing tools and techniques 7 Step 5: Releasing and controlling the specification Key requirements for document issue and control Final formatting and publication issues; document approval Requirements management: managing revisions and changes 8 Course review and action planning What actions should be implemented to improve specifications? Conclusion
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
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?
When managers have too many decisions to make, it can have a serious impact on the speed and efficiency of the organisation. When those decisions are commercial ones, the results can wreak havoc with the bottom line. Often the problem arises when those below them or in operational areas of the organisation aren't equipped or allowed to make a decision for themselves. Issues get passed back up and that wastes time. This programme provides a solution, giving your entire team the skills to: And most importantly, they'll be able to do this in line with the broader aims and commercial objectives of the business. By the end of the programme participants will be able to: Fully appreciate the importance of effective decision-making in business Use the five-step 'Stop, Think, Act!' decision-making process Stop leaping to conclusions Really understand the situations and decisions they are dealing with Identify good options Evaluate those options Make decisions and then put them into action Apply these tools and techniques to all their decisions in future 1 Understanding the business we work in What are the critical factors in our business? What is the SWOT analysis for our business? 2 Understanding what decision-making is 3 Background Culture of 'having to be doing' To change things we have to think about it! We are paid to make decisions! 4 Recognise the opportunity to make a decision 5 The 'Stop, Think, Act!' technique 6 STOP! Recognise the opportunity to make a decision Don't leap to conclusions Get ready to think Initial questions:Is this my decision? (Do I have the authority?)Who is this going to affect? (Do they need to be included?)When do I need to make the decision? (What's the timeline?) 7 THINK! The 3 Cs - making sure we understand the decisions we have to make What is the context of this decision?What is the overall situation?Why is this decision important?What do we need to achieve?What will success look like? Do I have clarity about the decision I need to make?Can I write it down?Can I express it clearly in two sentences? What are the criteria?What are the critical commercial factors that we will use to select our options?What will we use to measure the business success? 8 ACT! Identifying options What data do I need to collect?Issues with today's overloadIdentifying what will help you Select optionsHow many options?Must match your criteriaMust achieve success'Decision compass' exercise Analyse optionsTabular methodRisk analysis (likelihood v effect)Head, heart and gut (is there any organisational history/bias that we are up against?) Making your decision Taking it to actionFirst actionsPlanning how to make it happen