• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

31 Courses in London

Stopping Addictions: effective treatment and recovery

By Human Givens College

Discover the highly effective psychological techniques that are helping people overcome all kinds of addictions and compulsive behaviours… Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) Hugely informative - one of the best addiction training daysADDICTIONS COUNSELLOR NEXT available date: Tuesday 27th February, London – join Emily Gajewski for this popular addiction recovery training workshop – to ensure your place, book online now or call our friendly team on 01323 811690. Other dates and venues available. When combined with key insights into the addictive process and what drives it, the techniques covered on this day prove effective at helping people successfully quit a wide range of addictions. They also help to reduce withdrawal symptoms, minimise relapses and give people the best chance at effective, long-lasting recovery… What will you learn New insights into the addictive process and why people become addicted Common traps to avoid when treating addictions A range of psychological techniques for overcoming addiction How to develop a treatment plan and deepen a client’s commitment to change Ways to overcome resistance – and prevent relapses Also covered: Demonstrations – by a leading expert in addiction counselling – of the powerful skills that help to quickly break the patterns of addictive behaviour Guidance and practise in using some of these yourself How to break the cycle of shame involved in addictions, using self-compassion and generation of hope Essential motivational interviewing techniques – and how to incorporate them into the ‘cycle of change’ Up-to-date knowledge of the most useful ways to beat a wide variety of addictions – and prevent relapse Increased understanding of the addictive trance and its false promises How to use harm-reduction techniques Why the social-based model of addiction is more helpful than the disease-based model An understanding of the importance of guided imagery in overcoming addictions and substance abuse (particularly ‘counter-conditioning’ which is taught on Guided Imagery 2: additional techniques) Co-morbid conditions – the link with addiction and how to deal with them as effectively and quickly as possible A total revelation – very upliftingMENTAL HEALTH WORKER Why take this course The numbers of people affected by addictions and substance abuse continue to rise – causing immense mental, physical and financial suffering to individuals, their families and colleagues – while the resources to help are dwindling. But thankfully it is possible to help most addicts transform their lives – often in only a few sessions – as you will discover on this practical day which draws together, from various schools of solution-focused therapy, the most effective and proven techniques for treating addictions (including motivational interviewing and self compassion techniques) with essential neuroscientific insights into the addictive process to create powerful interventions. You will leave the day with renewed confidence knowing how it is possible to help most people with addictions, enabling them to transform their lives, often in a small number of sessions. The skills covered are essential to have (along with guided imagery) if you wish to improve your effectiveness when helping people quit any addiction, including: alcohol addiction, smoking, gambling addiction, shopping, social media addiction, sex, substance abuse, self-harm and eating disorders. Please note You will leave this workshop with essential information and a variety of skills that you can implement straight away. However, the key concepts and most effective ways of treating addictions, which you will see demonstrated and explained, incorporate guided imagery skills. We therefore recommend, if you aren’t proficient in these already, that you attend the Guided imagery and visualisation for therapeutic change workshop (either before or after this one). The counter-conditioning technique that you will see demonstrated and explained on ‘Stopping Addictions’, is taught in detail and practiced by workshop participants on Guided Imagery Day 2: additional techniques. ‘Stopping Addictions’ complements our online course Tackling Addiction and what you will learn on it will also be very useful if you support or work with people who self-harm. Course Programme The ‘Stopping Addictions: effective treatment and recovery’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am How and why people develop addictions 11.00am Discussion over tea/coffee 11.30am Dealing with resistance 1.00pm Lunch (included) 1.45pm How to create the optimal environment for positive change 2.45pm Discussion over tea/coffee 3.00pm Utilising the imagination 4.00pm Day ends Who is this course suitable for? All members of the caring professions, including: psychotherapists, addiction counsellors, drug workers, youth workers, nurses and detox support specialists, doctors, sober companions and drug and alcohol workers, therapists, vocational counselors, clinical psychologists, occupational therapists, psychiatrists, cognitive behavioural therapists, teachers and education professionals, social workers, supervisors, physiotherapists, support workers and anyone wishing to improve their understanding of addictive behaviour and how to treat it. 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.

Stopping Addictions: effective treatment and recovery
Delivered In-PersonFlexible Dates
£198

3ds max and V-Ray Training Course

By ATL Autocad Training London

Why 3ds max and V-Ray Training Course? This course is ideal for 3D artists and professionals in various industries seeking advanced rendering skills. If you work with 3ds Max and want to master superior photorealistic rendering using V-Ray, this course is tailored for you. V-Ray, a third-party engine compatible with 3ds Max,  Click here for more info: Website Duration: 10 hours. Approach: Personalized 1-on-1 Sessions and Flexible Learning. Scheduling Flexibility: Mon to Sat between 9 am and 7 pm. Choose your own day and time. 10-hour Vray for 3ds Max Training Course Outline: Module 1: Introduction to Vray for 3ds Max (2 hours) What is Vray and its integration with 3ds Max? Installation and setup of Vray for 3ds Max Understanding Vray interface and workflow Overview of Vray materials Module 2: Lighting with Vray (2 hours) Various lighting techniques in Vray Types of Vray lights and their configurations Creating and managing Vray sun and sky Vray dome lighting and IES light usage Efficient lighting workflows in Vray Module 3: Vray Camera (2 hours) Understanding Vray camera settings Controlling exposure with Vray camera Working with Vray depth of field Creating Vray camera animations Utilizing Vray frame buffer Module 4: Vray Materials (2 hours) Understanding Vray material properties Creating realistic materials using Vray Building and storing custom Vray material libraries Implementing Vray material overrides Module 5: Vray Rendering and Post Production (2 hours) Overview of Vray rendering settings Rendering images and animations with Vray Post-production techniques in Photoshop Understanding and utilizing Vray frame buffer Compositing Vray render elements in Photoshop Working with Vray denoiser Modeling Techniques: Edit Poly Modeling Extrude, Chamfer, Cut, and Slices Symmetry Mirror Modeling Designing furniture and basic architectural models Lines, Shapes, and Plan Import from AutoCAD/Vectorworks Modifiers: Compound objects (Connect, Scatter, Pro Boolean, Loft, Terrain) Bend and Taper Basic Lights: Omni Light, Spot Light, Direct Light Camera Control: Free Camera, Target Camera Texturing and Rendering: Diffuse and Bump Mapping Environment and Background Images Advanced Rendering Techniques (Interior and Exterior Scenes) Vray Specifics: VRay Lights (Plane, Dome, Sphere, Sun, Shadow) VRay Camera Settings (Focal Length, Film Speed, Shutter Speed) VRay Materials (Diffuse Color, Reflection, Refraction, Blurry Reflections) Upon completing the 10-hour Vray for 3ds Max Training Course, participants will: Master Vray Integration: Understand setup, interface, and tools for effective usage. Excel in Vray Lighting Techniques: Learn diverse Vray lighting methods, enhancing scene realism. Vray Camera Control: Manipulate camera settings, exposure, and create dynamic animations. Vray Material Skills: Create realistic materials, manage libraries, and override material properties. Perfect Rendering and Post-Production: Optimize rendering, produce high-quality images, and enhance results in post-production. Advanced 3D Modeling Expertise: Develop complex shapes, utilize modifiers, and import plans effectively. Recommended Resources: "V-Ray My Way: A Practical Designer's Guide to Creating Realistic Imagery Using V-Ray & 3ds Max" by Lee Wylde "3ds Max Modeling for Games: Insider's Guide to Game Character, Vehicle, and Environment Modeling" by Andrew Gahan "Photoshop for 3D Artists, Volume 1" by 3DTotal Publishing Job Opportunities: Students can pursue careers as: 3D Visualization Artists: Creating realistic visuals for architecture, products, and entertainment. Game Designers: Developing game environments and assets for interactive experiences. Architectural Visualizers: Producing high-quality architectural renders for firms and clients. Product Designers: Crafting detailed product visualizations for marketing and prototyping. Freelance 3D Artists: Offering services on platforms like Upwork, catering to diverse client needs. Opportunities exist in architecture, gaming, animation, advertising, and freelancing. A strong portfolio and networking enhance job prospects. Skills Acquired: Vray Advanced Lighting: HDRI, Global Illumination Mastery. Vray Material Expertise: Shaders, Textures, Realistic Material Replication. Scene Optimization: Large-scale Scene Handling, Speed Optimization. Post-Production Skills: Vray and Photoshop Enhancement, Atmosphere Addition. Career Opportunities: Architectural Visualization Specialist Product Design Visualizer 3D Visualization Artist Freelance Rendering Expert In-House Rendering Consultant Learn the advanced Vray rendering skills, 1-on-1 training courses, boost your career prospects in architectural visualization, product design, and animation industries.  Download 3ds max. Autodesk Download a free 30 day trial of 3ds Max, 3D modelling and rendering software for design visualisation, games and animation to create with full artistic Download Vray V-Ray for 3ds max is an integral rendering software for SketchUp, enabling designers to experience their designs in real-time. Say Goodbye to Group Courses: Welcome to our Personalized Learning Experience! Why Choose Us? Our Course Benefits Include: ​ One-on-One Training: Experience personalized coaching from practicing architects and designers tailored exclusively for you. 1-on-1, Face to Face at (SW96DE) or Live online. Open: Monday to Saturday 9 am to 7 pm. Customized Tutorials: Take home bespoke video tutorials designed to enhance your learning journey. Comprehensive Resources: Receive a digital reference book for thorough revision, ensuring you grasp every concept. Free Ongoing Support: Enjoy continuous after-course support via phone or email, guaranteeing your success even after the class ends. Flexible Syllabus: We adapt syllabus and projects to match your needs, ensuring you learn precisely what matters most to you. Official Certificate: Certificate upon course completion. Why Us? Supported Individual Learning: Our courses, ranging from 10 hours to 120 hrs Diploma training Courses, offer unwavering support at every step. With personalized homework assignments and free after-course assistance, we pave the way to mastering software with unparalleled guidance. Personalized Attention, Not Crowded Classrooms: Bid farewell to crowded classrooms. Experience the intimacy of one-on-one learning. This ensures you receive the undivided attention you deserve, fostering a confident and comfortable learning environment. Financial Flexibility: Embarking on your educational journey shouldn't be a financial burden. We offer a variety of payment plans tailored to your needs. Discover the options available to you and start your learning adventure today. Expert Instructors, Real-world Insight: Our instructors are experts meticulously chosen for their extensive industry knowledge and passion for teaching. They are dedicated to imparting invaluable skills to anyone eager to learn.

3ds max and V-Ray Training Course
Delivered in London or OnlineFlexible Dates
£396

Power BI Advanced

4.9(75)

By Acuity Training London

Master Power BI’s most powerful functions on this 2 day Advanced Power BI training course.  This is a hands-on course. You get lots of time to practise creating and editing reports and data visualisations. This ensures that you really get to grips with what you are being taught. By the time you finish, you’ll be an expert Power BI user.  ✔ A course covering all of Power BI’s most advanced functions.  ✔ Plenty of one-to-one attention and time to ask questions.  ✔ Friendly expert trainers, small groups and a comfortable place to learn.  ✔ All the materials and extras that you’ll ever need.  ✔ Ongoing support and help with issues you have after the course. Our courses are delivered in Guildford, London, Online, or even on-site at your offices!

Power BI Advanced
Delivered In-PersonFlexible Dates
£995

Online and phone therapy training

By Human Givens College

– essential guidance for safe and effective remote working Join our expert tutors to discover how you can make online therapy work for your practice Accredited CPD Certificate: 4 hours Length: 9am – 1.15pm (BST) LIVE ONLINE – Specialist training in delivering effective therapy online or over the phone – Join Ros Townsend live online on Tuesday 11th June 24 for this jam-packed, informative session. You will receive your Zoom link the day before the event. NB. Spaces are limited and tend to go quickly. Register your interest here if you can’t make this date, and we’ll let you know when there’s another one. BONUS RECORDING – the training is recorded, in case of technical difficulties, so you will also get a recording for 2 weeks afterwards to maximise your learning. Delivering online therapy, or counselling clients on the phone, requires a particular set of skills and brings with it specific considerations. This live online workshop will help you gain confidence in working safely and ethically, examining the advantages, potential drawbacks and adjustments you need to make to work remotely successfully. There will be plenty of time for questions, and helpful discussions with your peers and experienced tutors. Why take this course Whether you are a new practitioner wanting to develop your online practice, or an experienced therapist who has decided to start offering services online or on the phone, this course will help you gain the skills and understanding you need to do so safely and effectively. Unlike other online courses, this practical live online CPD training gives you the opportunity to ask our experienced tutors questions about any aspects that concern you, as well as learning from their case histories about what has worked – and what hasn’t – for them. Covering essential areas such as managing client expectations, setting up a therapeutic online environment, risk management, and the use and adaptation of various skills and techniques for online or telephone work, this course gives you the essential information you need to deliver therapeutic interventions remotely. Both Jo Baker and Ros Townsend, the course tutors, have extensive experience of working with clients online, with Ros now running her entire therapy practice remotely. Jo works using a blended approach (combining face-to-face counselling and online psychotherapy), and both bring a wealth of practical tips, hands on experience and real-life examples to the training. During the day, there will be ample opportunity to discuss and share ideas with both tutors and peers, and to enter into both structured and more free-ranging discussions about both the benefits and potential difficulties that one might encounter when working therapeutically through remote mediums. What the training covers: The importance of aligning client and therapist expectations for online therapy, or therapy over the phone How to set-up successfully for work on the phone or online – including template agreements to use with your clients Managing your technology and ensuring good communication – key things to ascertain, plus troubleshooting tips What to do when the call won’t connect The importance of confidentiality and privacy – and the potential problems you need be aware of when working online Agreeing safe communication methods between sessions How to successfully manage dual therapy spaces The importance of setting and maintaining professional boundaries Discussion regarding what is / is not acceptable in a home therapy space How to manage transitions before and after the session – for clients and therapists The key differences between online and face to face therapy work How to adapt and work successfully with a range of key therapeutic skills – such as Guided Imagery and The Rewind technique Assessing suitability of client presentations – including guidance on cases that are not suitable for online therapy How to manage risk effectively in an online or telephone environment How to put in place effective contingency plans for when technology fails Developing flexibility: dealing with the unexpected – including what to do if a session is interrupted When to refer a client on The additional pressures and potential stressors of online and telephone working Working in a blended way – combining remote and face-to-face sessions Key differences for the client of receiving therapy online or over the telephone The particular considerations of working with a wider client group from different geographical locations The importance of self-care and self-awareness Insurance and GDPR considerations when delivering online therapy or counselling, or working via the phone The importance of appropriate supervision Course Programme The ‘Online and phone therapy training’ course starts at 9.00am and runs until 1.15pm. (BST). 9.00am Join the Zoom meeting 9.15am First session starts 11.00am Comfort break and discussion 11.30am Second session 1.15pm Day ends Who is this course suitable for? This course is designed for both trainee and fully-qualified therapists, psychotherapists and counsellors It is recommended to all HG practitioners by the Human Givens Institute – trainee HG Therapists are expected to take this training if they are considering working online. This course has been independently accredited by the internationally recognised CPD Standards Office for 4 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Online and phone therapy training
Delivered OnlineFlexible Dates
£110

Microsoft Power BI Desktop (now with live online classes)

By Microsoft Office Training

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualisations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Microsoft Power BI Desktop (now with live online classes)
Delivered In-Person in LondonFlexible Dates
£750

Angelic Reiki Level 1&2

By Paulina Tanye

Angelic Reiki London

Angelic Reiki Level 1&2
Delivered In-PersonJoin Waitlist
£252

SSRS Report Builder Course, 2 Days

4.6(12)

By PCWorkshops

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

SSRS Report Builder Course, 2 Days
Delivered In-PersonFlexible Dates
FREE

SSRS Report Builder Course, 2 Days

4.6(12)

By PCWorkshops

SSRS Report Builder Course Summary. Practical SSRS Report Builder course, to leavy you full conversant with queries, DML and DDL statements. Hands-on, Practical SSRS course. PCWorkshops SSRS Course Certificate. Max 4 people per course, we keep it personalised. Where is the SSRS Report Builder Course? Online: Instructor-led. Classroom: Request per email. SSRS Course Materials SSRS Coding Examples Manuals and Notes: In-depth reference materials Exercises: Practical exercises Payment Options → £600, Follow the booking link Arrange for installments Included with SSRS Report Builder Course: SSRS Course Certificate on completion. SSRS Course Manual. Practical SSRS Course exercises. SSRS Code Samples. After the course, 1 free session for questions. Max group size, online and in classroom, on this SSRS Course is 4. Course Topics SSRS Report Builder Course Topics SSRS Course topics: This course focus on producing reports using MS SQL SSRS Report Builder, to use the product features and tools related to data retrieval, visualisations and deployment. The Target Audience: end-users who will produce reports for their department or group using datasets. SSRS Course Topics Report Models: Data source views Creating a model Entities, attributes and roles Tables: Creating tables Interactive sorting Floating headers Grouping: Inserting groups Group headers/footers Displaying group totals Expanding and collapsing Expressions: The expression builder The Report Items collection Built-in fields Conditional formatting expressions Page headers and footers Page names and numbers Exporting reports: The various report formats Using RenderFormat. Parameters: Creating parameters Filtering using parameters Drop list parameters Coping with empty tables Matrices: Row and column groups Sorting and filtering matrices Creating subtotals Charts: Creating charts The parts of a chart Formatting charts Basic reports: Text boxes and images Selecting report items Formatting parts of a report Miniature charts Creating sparklines Creating data bars Graphical indicators Creating and customising indicators Linear and radial gauges Lists: Page-per-record lists Dashboard lists Other list ideas Subreports: Creating a child report Creating the main report Linking the two reports Report parts: Publishing report parts The report part gallery Updating report parts Book the SSRS Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

SSRS Report Builder Course, 2 Days
Delivered In-PersonFlexible Dates
FREE

Power BI - introduction to intermediate (2 days) (In-House)

By The In House Training Company

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

Power BI - introduction to intermediate (2 days) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Tableau Desktop Training - Foundation

By Tableau Training Uk

This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc. The course is split into 3 phases and 9 modules: PHASE 1: GET READY MODULE 1: LAUNCH TABLEAU Check Install & Setup Why is Visual Analytics Important MODULE 2: GET FAMILIAR What is possible How does Tableau deal with data Know your way around How do we format charts Dashboard Basics – My First Dashboard MODULE 3: DATA DISCOVERY Connecting to and setting up data in Tableau How Do I Explore my Data – Filters & Sorting How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates Phase 2: GET SET MODULE 4: MAKE CALCULATIONS How Do I Create Calculated Fields & Why MODULE 5: MAKE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps MODULE 6: MAKE TABLES Creating Tables – Creating Tables, Highlight Tables, Heat Maps Phase 3: GO MODULE 7: ADD CONTEXT Reference Lines and Bands MODULE 8: MAKE MAPS Answering Spatial Questions – Mapping, Creating a Choropleth (Filled) Map MODULE 9: MAKE DASHBOARDS Using the Dashboard Interface Dashboard Actions 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 use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Excellent Trainer – knows his stuff, has done it all in the real world, not just the class room.”Richard L., Intelliflo “Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.”Trevor B., Morrison Utility Services “I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.”Chelsey H., QVC “He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.”Matthew H., ISS Group

Tableau Desktop Training - Foundation
Delivered in Birmingham + 2 more or UK Wide or OnlineFlexible Dates
Price on Enquiry