260 Courses in Edinburgh

How to turn your creative passion into a career: take your first steps on this relaxed and welcoming workshop at The Arienas Collective in Edinburgh led by Laura Ogilvie Jones coaching

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

Belonging & Connection

Japanese Yoga and Vegan Gyoza Cooking Class Join us for a unique experience combining movement and nourishment! This class begins with one hour session of Japanese Yoga, run by Giada, founder of Art and Spirituality and School of Shamanism. This is a dynamic and meditative practice that harmonizes body, mind, and spirit. Rooted in traditional Japanese principles, the yoga focuses on breath, posture, and gentle stretches to promote flexibility, balance, and relaxation. Japanese Yoga is part of Shamanic Yoga, which is ancestral, ancient, pre-vedic. It has the element of ecstasy, of a non ordinary state of consciousness, where you work with nature, animals, yantras, mantras, mudras, rituals, initiations in the imaginal forest, in the natural code, non the social code. Merceliade says that this yoga is the oldest form of yoga and we find it in various traditions: Hindu tradition (Shaktism), Himalayan (Naropa, Milarepa etc), South America (Andean yoga), Siberia, Mongolia, Japan (Yamabushi), Taoism, Alchemy. No experience required and mats are provided. After the yoga session, we’ll dive into the culinary world with a hands-on vegan gyoza cooking class, run by Gloria, founder of Madebyflour. Learn how to prepare delicious and healthy gyoza, a popular Japanese dumpling, using fresh, plant-based ingredients. Our step-by-step guidance will show you how to fold and cook these savory delights to perfection. Recipes in the class include gluten and other allergens. Please add a note in your booking if you have any dietary requirement or allergy. The lessons are suitable for all levels of experience and materials and mats are provided. By attending this class you release Giada Gaslini, Gloria Civillini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending.

Cacao Ceremony and Vegan Chocolate Cake Cooking Class Step into a heart-centered experience with our Cacao Ceremony and Vegan Chocolate Cake Cooking Class. We begin with a traditional cacao ceremony, run by Giada, Shamanic Teacher, founder of Art and Spirituality and School of Shamanism. This is an ancient ritual that uses pure ceremonial-grade cacao to foster connection, mindfulness, and self-reflection. In a peaceful and sacred space, you'll be guided through a journey of meditation, gratitude, and intention-setting, allowing the cacao to open your heart and deepen your inner awareness. Following the ceremony, we will move a fun and interactive vegan chocolate cake cooking class run by Gloria, Founder of Madebyflour. Using wholesome, plant-based ingredients, you'll learn how to create a rich and decadent chocolate cake that’s both delicious and healthy. Our simple, step-by-step approach ensures you’ll be able to recreate this indulgent treat. This class offers a perfect blend of spiritual nourishment and culinary creativity. Please add a note in your booking if you have any dietary requirement or allergy. The lessons are suitable for all levels of experience and materials are provided. The only medical contraindications are mixing Ceremonial Cacao with antidepressants, anti-psychotics, suffering from heart conditions, low blood pressure or serious illness.If you are on any anti-depressants, antipsychotics or any medication for mental health please get in touch with me. Ceremonial Cacao can cause serious interactions.Please arrive with an empty stomach - no food for 2/3 hours prior to the ceremony. Some light fruit is fine. Please avoid caffeine, alcohol, dairy, red meat for 24 hours before and after - they do not mix well with Cacao. Keep well hydrated by drinking plenty of water. If you smoke, please try to reduce as much as possible, especially if it is not pure tobacco due to the chemicals as cacao is a strong stimulant & detoxifier.If you want to get the very best out of the ceremony and support your integration, it is recommended to continue this diet for 48-72 hours before and after.  By attending this class you release Giada Gaslini, Gloria Civillini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending.

Our ‘Professional Behaviour – A workplace Priority’ training programme provides delegates with a set of tools and increased knowledge to deal with the issues of bullying and harassment appropriately as they arise. These issues are far from easy and for many managers, the reality of dealing with complaints of this nature is both time consuming and stressful Currently it is estimated that bullying and harassment costs the UK economy £18 billion a year in lost productivity, staff retention and legal costs. Our bespoke and specialized services, developed to meet your organizational requirements in these challenging areas, can reduce stress levels, develop increased awareness, and better understanding. In addition to this face to face training, NGT will assess your organisation’s current position and where you would like it to be as its future unfolds; we will help your organization to identify improvements and assess the benefits to you of making them; we will work with you to implement the agreed solutions, at a time and in a way that fits with your operational needs; we will help you track the benefits both long term and short term via regular monitoring, evaluation, and continued discussion. Our facilitator is highly experienced in delivering this training to all levels of staff and NGT welcomes your enquiry to take this matter forward. How is this course delivered and how long is it? This is a face to face course only and lasts a full day Is the course accredited? Yes, it is a CPD accredited course Who is it for? Although it will benefit managers of all grades it is equally important that all staff are made aware of these issues How much does it cost? Course fees are fixed at a fair daily rate, details of which are available upon enquiry. Travel costs are extra. How large are the groups? We can only effectively deliver this course to groups of 15 people or less. Will you be able to deliver the course at my workplace? Based in the Midlands, we are well suited to travelling to all corners of the UK, enabling us to deliver this programme to you at your location.

This 2-day workshop is offered with an internal and external focus. Day 1 will focus on building your internal network and relationships by focusing on your personal network, your brand, influencing skills and perceptions. Day 2 focuses on your external relationships with suppliers, patient groups etc. This will focus on assertiveness, outcome rather than relationship focus, and influencing and negotiating skills. DAY ONE 1 Can you succeed by yourself? 2 Relationship awareness theory 3 The Strengths Deployment Inventory / Your FACET5 profile 4 Building rapport 5 Influencing power bases 6 Active listening 7 Building your personal internal network 8 Perceptions 9 Your brand DAY TWO 3 Preparing for conflict 2 The negotiation conversation 1 Your stakeholders and what they want from you 4 Influencing others 5 Your communication approaches for success 6 Emotional Intelligence 7 The trust model 8 Knowing your outcomes

Early Years Room Leader Training.

Make two silver clay rings on this one day intermediate workshop in Edinburgh City Centre.

If you're looking for a short, sharp high-impact intervention that will help motivate and inspire your sales team then a 'bite-sized' session could be just what you're looking for. We have a range of sessions that can be delivered on an 'off-the-shelf' basis, or they can be tailored to your specific requirements or, of course, we can develop something specifically for you on an entirely bespoke basis. And the length of the session is entirely up to you - 45-minutes, an hour, a half-day - whatever you prefer. Sessions can be run for small groups as part of your regular team meetings or they can be delivered for larger audiences, conference-style - the choice is yours. The session outlines below are just to give you an idea of the possibilities. If one of them whets your appetite please just give us a call on 01582 463463 to talk through what we can do for you - we're here to help!