15 Courses in Leeds

– the practical skills you need Discover how to combine key new insights into the causes and symptoms of depression with a range of powerful psychological techniques to make treatment easier and more consistently effective … -------------------------------------------------------------------------------- * Accredited CPD Certificate : 6 hours * Length 1 day (9.30am - 4.00pm) -------------------------------------------------------------------------------- > Practical, inspiring and full of hope > > DR GINA JOHNSON, GP WHY TAKE THIS COURSE Until recently depression was little understood but key new insights into its causes and symptoms have made treatment easier and more consistently effective. On this day you will learn how combining these insights with a wide range of different psychological techniques enables the majority of cases to be lifted surprisingly quickly … even severe ones. Although antidepressants can play a role in reducing symptoms, they can also be dangerous and prove hard to withdraw from – research shows that appropriate counselling is more effective at lifting even the most severe depression, with a much lower rate of relapse.  The approach you will learn on this workshop is in this category and is proving very effective – 10,000s of people have already been successfully helped with the knowledge and skills you will learn on the day. > I feel much more confident in my understanding of the process of depression > and how to target it with helpful interventions > > DANIEL COOPER WHAT WILL YOU LEARN * New insights into why depressed people wake up tired and unmotivated, and what to do about it * Information about the links between inflammation and depression * Clear, practical steps for lifting even severe depression * Demonstrations of the skills that quickly break the cycle of depression, move people on and prevent relapse * A profound understanding of why these work and are a big improvement on drug therapy * Practice sessions in using these proven skills and techniques yourself * What to do if you suspect someone may be feeling suicidal * How to establish what’s not working in a person’s life and why, using a case history * Techniques for tackling rigid thinking, negative expectancy and the pessimistic rumination that causes depression * How to work with your clients to find effective ways they can get their innate emotional needs met well and in balance * A range of additional useful tips and strategies that you can easily incorporate into your work * The opportunity to watch a film of master therapist Joe Griffin working quickly and successfully with a highly depressed patient * You will also have plenty of time to ask questions of the tutor, who is also a practising therapist herself… > Everyone, not just the caring professions, should do this day. > > GENERAL PRACTITIONER    WHO IS THIS COURSE SUITABLE FOR? * If your life is affected by depression in any way – perhaps the staff or students you are responsible for at work present with depression, or a friend or family member is depressed – you will benefit from attending * Anyone who, for whatever reason (personal or professional), would like to better understand the causes of depression and be able to offer practical help to people who are depressed * If you would like to know how best to prevent relapses and help clients build long-lasting resilience against future setbacks, this workshop is for you * Anyone concerned about the side effects of drug treatments for depression, who would like to know about the easy-to-learn psychotherapeutic techniques that can lift depression quickly, will benefit from attending * It is essential training for counsellors, psychotherapists, social workers, occupational therapists, HR professionals and all other health and welfare professionals – since depression is now so common, it is crucial to understand it and know how to treat it quickly and effectively. -------------------------------------------------------------------------------- GOOD TO KNOW This workshop complements our online course: How to break the cycle of depression. Guided imagery and visualisation and Therapeutic Language are useful skills to have for implementing the strategies taught on this workshop.    -------------------------------------------------------------------------------- COURSE PROGRAMME * From 8.30am * Registration (Tea and coffee served until 9.25am) * 9.30am Understanding depression and what you can do about it * 11.00am Discussion over tea/coffee * 11.30am Exploring how to work with depression * 1.00pm Lunch (included) * 1.45pm Practice in using the HG approach * 2.45pm Discussion over tea/coffee * 3.00pm Guided imagery for depression * 4.00pm Day ends -------------------------------------------------------------------------------- This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

OVERVIEW -------------------------------------------------------------------------------- Data and visual analytics are emerging fields concerned with analysing, modelling, and visualizing complex high-dimensional data. It can be analysed and visualised with many languages like Python, R Programming and more. This course will help to attain the skills and give in-depth knowledge to the participant's enhanced way of modelling, analysing and visualizing techniques.  The course will highlight practical challenges including composite real-world data and will also comprise several practical studies

ADVANCED KIBANA TRAINING COURSE DESCRIPTION This training course is aimed at users who already have some experience with Kibana, who are looking to further their knowledge. WHAT WILL YOU LEARN * Lens * Timelion * Maps * Custom Visualisations with Vega * Canvas * Filters and Controls * Drilldown and Dashboards * KQSL and ElasticQueries * Scripted and RunTime Fields * Alerts and Alarms ADVANCED KIBANA TRAINING COURSE DETAILS * Who will benefit: Users who already have some experience with Kibana, who are looking to further their knowledge. * Prerequisites: None * Duration 1 day ADVANCED KIBANA TRAINING COURSE CONTENTS Topics * Lens Visualisation types (tables,bars,charts) Category breakdown Adding multiple metrics Using formulas in metrics Labels Adding reference layer Limitations * Visualise Library Timeseries, Metrics Different types of aggregations * Maps GeoMapping Heat Maps Using ES index as data source Visualisation, tool tips * Custom Visualisations with Vega Introduction to vega scripting * Canvas Widgets and Texts Elasticsearch SQL Canvas Expressions * Filters and Controls Dropdown filters Ad-hoc filters Searchbar filters * Drilldown Dashboards Linking one dashboard to another * KQSL and ElasticQueries Bool Query AND/OR Phrase Part match vs keyword search Wildcard search * Scripted and RunTime Fields Creating ad-hoc calculated fields using scripts Performance issues * Alerts and Alarms Query Based Formatting output Connector types(email,index,teams etc)

– a psychotherapy skills masterclass The language we use has a huge impact on others – on this practical, inspiring course you will learn how to combine solution-focused techniques and effective language skills to help relieve distress and improve outcomes, as quickly as possible… -------------------------------------------------------------------------------- * Accredited CPD Certificate : 12 hours * * Length 2 days (9:30am - 4:00pm) -------------------------------------------------------------------------------- > Excellent course! I’ve learnt so much and been inspired so much. Gareth has a > wonderful style of delivery... > > MARY FLYNN This course is suitable for anyone working with adults, teens or children – the knowledge and skills you will gain have a wide range of applications in addition to therapy and counselling, including coaching, healthcare, teaching, motivation, overcoming resistance, emotional turmoil and much more. You will leave with a powerful toolkit of precisely-targeted and creative therapeutic language skills, as well as a range of effective brief therapy strategies. These can be easily tailored to any individual and used to successfully help people resolve a wide range of conditions and problems as quickly as possible. If you want to be more effective in what you do, these are core skills to have…   Denise Winn previously taught this course, it is now delivered by Gareth Hughes WHY TAKE THIS COURSE Language is key to everything we do – being aware of the power of language to help or do harm is essential when we’re trying to help people. Knowing how to use it well can make all the difference to a successful therapeutic outcome. Paying attention to the language we use is central to the human givens approach to therapy and counselling: our choice of words is crucial in building rapport with people, learning more about someone – their unique qualities and abilities – in listening and responding, in providing motivation and in collaborating to agree goals and strategies for the effective resolution of their problems. The careful use of language is essential for other areas of life too: at work, home, with family and friends – and this  2-day course is accessible to all. It can be taken as part of the Human Givens Diploma or as a stand-alone course. You will gain a solid foundation in the most effective brief solution-focused strategies and language skills that are essential if you want to be able to help people as quickly as possible. By distilling the essence of proven brief therapy approaches and working in tune with the givens of human nature, outcomes can be dramatically improved and suffering successfully reduced. You will also learn how any team of professional healthcare workers can safely incorporate brief therapy techniques into their work with patients suffering from depression, anxiety, panic attacks, PTSD, anger, OCD, eating disorders, addiction and relationship/marital/family problems, thereby improving outcomes and reducing suffering on an even wider scale. -------------------------------------------------------------------------------- GOOD TO KNOW This course gives you essential skills that are used in the successful treatment of a wide range of conditions, such as anxiety disorders, depression [https://www.humangivens.com/college/lift-depression/], addictions, self-harm, OCD and the rewind technique [https://www.humangivens.com/college/rewind-technique-training/] for treating trauma and phobias. They are also fundamental skills to have when using guided imagery and visualisation [https://www.humangivens.com/college/guided-imagery-and-visualisation/]. This course is an essential component of Part 1 of the HG Diploma. > I feel very excited and energised. I can't wait to start using these > techniques... > > OCCUPATIONAL THERAPIST WHAT WILL YOU LEARN * The essential skills needed for successful brief therapy * New information about the APET™ model – why it is so important to construct therapy that is in tune with our how brains work (our emotional reactions come first) – this speeds up therapy and explains why purely cognitive and behavioural approaches can take so long * An ability to get to the root of the matter quickly by establishing which innate needs are not being met and why (the essence of effective brief therapy) * Quick rapport building skills * How to use the RIGAAR™ structure to improve therapy outcomes * Reflective listening and reflective reframing * How to use therapeutic language skills directly and indirectly to initiate change * Ways to use solution-focused questioning to create a framework for change * How to identify and use your client’s own life resources * An understanding of why the human givens approach dramatically increases the likelihood of therapy being brief, regardless of the presenting problem * A range of psychological interventions to use with common psychiatric problems: anxiety, panic attacks, depression, intrusive thoughts, relationship difficulties and so on * Promoting cooperation by developing realistic and achievable goals * How to identify exceptions (when the problem doesn’t occur) and get the patient to take credit for them * How to generate motivation for change in your patients * Separating the patient’s core identity from their problem * How to minimise or overcome resistance * How not to be drawn in to a client’s negative self-view * Great use of case histories to illustrate the skills covered * How to use the psychological laws of positive expectancy and concentrated attention * An understanding of why taking this collaborative human givens stance, reduces stress and pressure on you * Plenty of opportunity to consolidate what you are learning by practising the skills yourself -------------------------------------------------------------------------------- HOW IS THE COURSE STRUCTURED? Held over two consecutive days, this skills-based practical workshop combines a blend of talks, demonstrations and exercises.  Each day starts at 9.30pm and finishes at 4.00pm, with 2 breaks for networking and refreshment and 45 minutes for lunch. Course notes, refreshments and lunch are included on both days. -------------------------------------------------------------------------------- WHO IS THIS COURSE SUITABLE FOR? You and your patients will benefit enormously from you attending these two days. If you are a counsellor, psychotherapist, clinical psychologist, mental health nurse, GP, doctor, nurse, OT, physiotherapist, youth worker, social worker, health visitor, support worker or any other caring professional, and wish to be more effective in what you do, this course gives you the perfect opportunity to discover new, subtle but highly effective skills with plenty of time to practise to help you assimilate them into your own work. Many other professions – such as educational and business professionals – also find the skills and information covered highly applicable to and beneficial for their own work. It is also suitable for anyone who is thinking of a career in this field as these are core skills needed for successful brief, solution-focused psychotherapy. -------------------------------------------------------------------------------- This course has been independently accredited by the internationally recognised CPD Standards Office for 12 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

ABOUT THIS TRAINING Front End Loading (FEL) is a methodology that takes a deliberate approach to capital project planning. Where traditional project plans seek to help an operator reach production targets and budgets, FEL methodology aligns an operator's technical and business goals to create a more comprehensive development plan. The FEL approach increases project definition and lowers risk to positively impact total investment costs and return on investment. Training Objectives Upon completion of this course, participants will be able to: * Learn the methods applied for Pre-FEL and FEL process * Understand the importance of FEL, FEL stages; visualisation, conceptualisation, definition * Uncover how to apply project management during FEL * Determine risk management in the FEL process * Understand benchmarking & value improving practices   Target Audience The course is recommended for anyone who wish to gain in-depth knowledge and understanding of the importance of Front-End Loading and how to apply Front End Loading best practices, including: * Team Leaders * Senior Managers (Line and Function) * Project Managers * Development Engineers * Graduate Engineers * Quality Assurance Engineers * Key Contractor's Management * FEED engineers * Design engineers * Mechanical engineers * Process engineers   Course Level * Basic or Foundation Trainer Your expert course leader is a subsea pipeline consultant with extensive experience in the design, construction, and installation of subsea pipelines for the oil and gas industry. As a consultant, he provides technical expertise and support to clients on all aspects of subsea pipeline projects, from the initial planning and design phase through to construction and commissioning. He is knowledgeable about industry standards, regulations, and best practices for subsea pipelines, and works closely with clients to ensure that projects are delivered safely, on time, and within budget. He has over thirty years' experience in early concept and front-end studies for the initiation of numerous high value upstream oil and gas projects worldwide. He has worked for both Operating Companies and Consultants managing the FEL process for complex, multi-discipline and technically challenging concepts, combining both his technical and project management skills. He has been working with companies like ExxonMobil, Quantum Power, North Caspian Operating Company, OMV Petrom, Port Meridian, BG Group, and etc.   POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

This practical workshop covers the unique challenges of working with complex trauma cases and gives you clear guidance on the most effective ways to help -------------------------------------------------------------------------------- * * Accredited CPD: 6 hours * Length: 1 day (9.30am - 4.00pm) -------------------------------------------------------------------------------- > Absolutely jam-packed with techniques/information and resources. Ros is > superlative. A calm, confident and articulate trainer... > > J YAP, THERAPIST WHY TAKE THIS COURSE Clients suffering from Complex PTSD (C-PTSD) or who have experienced trauma in a shutdown or dissociative state, can present unique challenges to practitioners working with them – but with the right knowledge and skills we can help sufferers move forward in their lives. In this hands-on, experiential workshop you will learn more about what makes trauma ‘complex’, why shutdown or dissociation are often experienced by sufferers, and how to best work with such presentations using the Human Givens framework of understanding. You will also have the chance to collaborate with other experienced practitioners and clinicians during exercises designed to further your understanding, add to your existing skillsets, and bring wider context to an often-misunderstood area of work. During this intensive day of live, in-person training, experienced psychotherapist Ros Townsend will introduce you to a framework within which you can set your understanding of complex trauma presentations and discover the opportunities that we have to help clients move forward from their difficulties. You will learn more about the neurobiology of the automatic survival options that we have available to us, especially dissociative and ‘shutdown’ states, and leave with an understanding of how to use this knowledge to inform your work, giving you greater confidence to work creatively and flexibly with such presentations. From understanding the symptoms that are now recognised as distinguishing C-PTSD, to adapting existing HG techniques and strategies and introducing new tools and skills, this course will explore how we, as clinicians, can approach such complex presentations without getting lost in the complexity ourselves. Using case histories and discussion you will have the chance to understand more about the unique challenges that such work presents and to leave feeling more confident in your ability as a therapist to work effectively and contextually with these. > Such a thought-provoking and informative day. Complex PTSD is a real buzz word > at present, this took the mystery out of it in a clear and understandable way > – highly recommend... > > MELISSA DERRICOURT     WHAT WILL YOU LEARN * What Complex PTSD (C-PTSD) is * What other symptoms a client may present with in addition to those meeting the criteria for ‘classic’ PTSD * How to effectively work with these within the Human Givens framework of understanding * Vital tools for psycho-education – both adding to your own understanding and to pass on to clients * Why individuals enter into a dissociative or ‘shutdown’ state * The difference between ‘freeze’ and ‘shutdown’ * Why anger can present when an individual comes out of a ‘shutdown’ state * How to help a client deal effectively with anger if it does arise * The crucial role of the pattern-matching processes in the brain in post-traumatic stress symptoms – and how the kinds of templates stored can subtly differ in more complex trauma * How to adapt existing techniques – such as rewind and deconditioning molar memories – to work creatively with such presentations * The Dos and Don’ts when working with Guided Imagery in complex presentations * How to refine your Guided Imagery skillset to powerfully benefit clients who have experienced trauma in a shutdown state * Why any work that we do must be informed by the innate ability we all have to recover from trauma * How to avoid negatively reframing trauma and making symptoms worse * The most effective ways to help clients towards recovery and post-traumatic growth Under careful guidance from the tutor, you will: * Explore and discuss the different survival options available to us as humans in traumatic situations * Learn more about the neurobiology of these states – including our passive survival responses * Develop a new framework of understanding within which to set your work with all kinds of trauma * Understand more about why ‘shutdown’ or ‘dissociation’ are often associated with complex presentations * Understand why addictions and self-harming behaviours are often a part of the picture * Work collaboratively with peers and colleagues to extend and develop your own skillsets and knowledge * Explore how guided imagery can be adapted and used to most powerfully benefit clients suffering in this way You will leave with: * The confidence to work creatively and flexibly with a wider range of presentations * A clear understanding of a framework within which you can work and continue to develop and adapt your tools and skillsets * An appreciation of the importance of taking your time with such work and proceeding at a pace right for each individual client * An understanding of how to support clients in moving forward from the use of faulty coping strategies – such as addiction and self-harm * Greater confidence in creating metaphors that work powerfully for clients * An understanding of how helping a client to meet their emotional needs is particularly key to recovery in the most complex cases Throughout the day there will be plenty of opportunity for you to ask questions and to engage in collaborative work and discussion with the tutor and with experienced colleagues and practitioners. -------------------------------------------------------------------------------- IMPORTANT NOTE Working with Complex PTSD requires specific skills and experience and thus is only suitable for practitioners either already working in this area and looking to extend their skillset or those who are already practicing as therapists and wish to begin working in this area. If you are an experienced practitioner from another modality, we recommend you familiarise yourself a little with the HG approach before you attend, see: About HG therapy [https://www.humangivens.com/human-givens/human-givens-therapy/hg-approach-difference/], benefits of the approach [https://www.humangivens.com/college/about-the-college/benefits-of-human-givens-approach/], and what is RIGAAR [https://www.humangivens.com/2021/11/25/why-human-givens-practitioners-use-rigaar/]. WHO IS THIS COURSE SUITABLE FOR? * Any qualified therapist working with distressed or traumatised people. In order to take full benefit from the course, you will ideally have already taken our Guided Imagery and Visualisation for therapeutic change [https://www.humangivens.com/college/guided-imagery-and-visualisation-workshop/] and Rewind Technique [https://www.humangivens.com/college/rewind-technique-training-workshop/] workshops. NB If you are an experienced practitioner from another modality, we recommend you familiarise yourself a little with the HG approach before you attend, see: About HG therapy [https://www.humangivens.com/human-givens/human-givens-therapy/hg-approach-difference/], benefits of the approach [https://www.humangivens.com/college/about-the-college/benefits-of-human-givens-approach/], and what is RIGAAR [https://www.humangivens.com/2021/11/25/why-human-givens-practitioners-use-rigaar/]. * Any qualified practitioner in the field of psychiatry, psychology, psychotherapy or counselling can attend; again you would benefit most by having previously attended our Guided Imagery and Visualisation [https://www.humangivens.com/college/guided-imagery-and-visualisation-workshop/] and Rewind Technique [https://www.humangivens.com/college/rewind-technique-training-workshop/] workshops and familiarising yourself a little with the HG approach to therapy. COURSE PROGRAMME This intense 1-day training proceeds through a blend of talks, skill-developing exercises, discussions and deconstruction of real-life case-studies. There is also plenty of opportunity for networking and discussion during the breaks. The training runs from 9.30am–4.00pm. * From 8.30am Registration (Tea and coffee served until 9.25am) * 9.30am What is complex trauma? A framework for understanding * 11.00am Discussion over tea/coffee * 11.30am Adapting our toolkit: working creatively with complex presentations * 1.00pm Lunch (included) * 1.45pm Self-efficacy: supporting a client to become an active agent in life * 2.45pm Discussion over tea/coffee * 3.00pm Reframing: adding context in complex cases * 3.30pm Serving clients well * 4.00pm Day ends -------------------------------------------------------------------------------- https://directory.cpdstandards.com/providers/human-givens-college/ This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.

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

This course is very much a discussion, so be prepared to present and critically analyse your own and class mates work. You will also need to bring a few examples of work you have done in the past. Learning and applying best practice visualisation principles will improve effective discussions amongst decision makers throughout your organisation. As a result more end-users of your dashboards will be able to make better decisions, more quickly. This 2 Day training course is aimed at analysts with good working knowledge of BI tools (we use Tableau to present, but attendees can use their own software such as Power BI or Qlik Sense). It is a great preparation for taking advanced certifications, such as Tableau Certified Professional. -------------------------------------------------------------------------------- Contact us to discuss the Visual Analytics Best Practice course Email us if you are interested in an on-site course, or would be interested in different dates and locations -------------------------------------------------------------------------------- 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 INCLUDES THE FOLLOWING TOPICS: WHAT IS VISUAL ANALYSIS? * Visual Analytics * Visual Analytics Process * Advantages of Visual Analysis * Exercise: Interpreting Visualisations HOW DO WE PROCESS VISUAL INFORMATION? * Memory and Processing Types * Exercise: Identifying Types of Processing * Cognitive Load * Exercise: Analysing Cognitive Load * Focus and Guide the Viewer * Remove Visual Distractions * Organise Information into Chunks * Design for Proximity * Exercise: Reducing Cognitive Load SENSORY MEMORY * Pre-attentive Attributes * Quantitatively-Perceived Attributes * Categorically-Perceived Attributes * Exercise: Analysing Pre-attentive Attributes * Form & Attributes * Exercise: Using Form Effectively * Colour & Attributes * Exercise: Using Colour Effectively * Position & Attributes * Exercise: Using Position Effectively ENSURING VISUAL INTEGRITY * Informing without Misleading * Gestalt Principles * Visual Area * Axis & Scale * Colour * Detail * Exercise: Informing without Misleading CHOOSING THE RIGHT VISUALISATION * Comparing and Ranking Categories * Comparing Measures * Comparing Parts to Whole * Viewing Data Over Time * Charts Types for Mapping * Viewing Correlation * Viewing Distributions * Viewing Specific Values DASHBOARDS AND STORIES * Exercise: Picking the Chart Type * Exercise: Brainstorming Visual Best Practice * Development Process for Dashboards and Stories * Plan the Visualisation * Create the Visualisation * Test the Visualisation * Exercise: Designing Dashboards and Stories -------------------------------------------------------------------------------- This training course includes over 20 hands-on exercises to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives an extensive training manual which covers the theory, practical applications and use cases, exercises and solutions together with a USB with all the materials required for the training. The course starts at 09:30 on the first day and ends at 17:00. On the second day the course starts at 09:00 and ends at 17:00. Students must bring their own laptop with an active version of Tableau Desktop 10.5 (or later) pre-installed. -------------------------------------------------------------------------------- WHAT PEOPLE ARE SAYING ABOUT THIS COURSE "Steve was willing to address questions arising from his content in a full and understandable way" Lisa L. "Really enjoyed the course and feel the subject and the way it was taught was very close to my needs" James G. "The course tutor Steve was incredibly helpful and taught the information very well while making the two days very enjoyable." Bradd P. "The host and his courses will give you the tools and confidence that you need to be comfortable with Tableau." Jack S. "Steve was fantastic with his knowledge and knowhow about the product. Where possible he made sure you could put demonstrations in to working practice, to give the audience a clear understanding." Tim H. "This was a very interesting and helpful course, which will definitely help me produce smarter, cleaner visualisations that will deliver more data-driven insights within our business." Richard A. "Steve is very open to questions and will go out of his way to answer any query. Thank you" Wasif N. "Steve was willing to address questions arising from his content in a full and understandable way" Lisa L. "Really enjoyed the course and feel the subject and the way it was taught was very close to my needs" James G.

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 THE QUERY EDITOR * Split by row delimiter * AddDays to determine deadlines * Advanced query editor 2 FUZZY MATCHING JOINS * Matching inconsistencies by percentage * Matching with transformation table 3 LOGICAL COLUMN FUNCTIONS * Logical functions IF, AND, OR * Using multiple conditions * Including FIND in functions 4 EDITING DAX MEASURES * Make DAX easier to read * Add comments to a measure * Using quick measures 5 THE ANATOMY OF CALCULATE * Understanding CALCULATE context filters * Adding context to CALCULATE with FILTER * Using CALCULATE with a threshold 6 THE ALL MEASURE * Anatomy of ALL * Create an ALL measure * Using ALL as a filter * Use ALL for percentage 7 DAX ITERATORS * Anatomy of iterators * A closer look at SUMX * Using RELATED in SUMX * Create a RANKX * RANKX with ALL 8 DATE AND TIME FUNCTIONS * Overview of functions * Create a DATEDIFF function 9 TIME INTELLIGENT MEASURES * Compare historical monthly data * Create a DATEADD measure * Creating cumulative totals * Creating cumulative measures * Visualising cumulative totals 10 VISUALISATIONS IN-DEPTH * Utilising report themes * Create a heatmap * Comparing proportions * View trends with sparklines * Group numbers using bins * Setting up a histogram 11 COMPARING VARIABLES * Visualising trendlines as KPI * Forecasting with trendlines * Creating a scatter plot * Creating dynamic labels * Customised visualisation tooltips * Export reports to SharePoint 12 USER LEVEL SECURITY * Setting up row level security * Testing user security