200 Courses in Bristol

LOOKING FOR: ADULT FICTION / NON-FICTION Ciara McEllin is building her list as a Junior Agent at Watson Little. She reads widely across book club, upmarket and literary fiction. Within these areas, she is drawn to novels that examine family and relationship dynamics, sexuality, identity, and vulnerability. Ciara is keen to hear from writers who take a fresh approach to these themes, whether that be a new perspective on a traditional narrative or a focus on characters and voices that remain underrepresented: think Kairos by Jenny Erpenbeck, Asymmetry by Lisa Halliday or Monkey Grip by Helen Garner. She will always want to read beautifully written novels with a strong sense of place, tangible characters and an essence that stays with you – living deep in your bones – long after you’ve finished reading. Recent reads Ciara has enjoyed include: Lonesome Dove by Larry McMurtry, Enter Ghost by Isabella Hammad, Close to Home by Michael Magee, Siblings by Brigitte Reimann, Trespasses by Louise Kennedy, The Idiot by Elif Batuman, Highway Blue by Ailsa McFarlane and My Phantoms by Gwendoline Riley. At the moment Ciara is particularly eager to see: - Sexy, sensual and seductive stories that explore desire and sexual boundaries not often represented in literature such as Little Rabbit by Alyssa Songsiridej, Cleanness by Garth Greenwell and Mrs. S by K Patrick - An atmospheric and existential thriller in the vein of Intimacies by Katie Kitamura, In The Cut by Susanna Moore and Drive Your Plow Over the Bones of the Dead by Olga Tokarczuk - An intoxicating coming of-age-tale that captures the aliveness, intelligence and wildness of girlhood like Brutes by Dizz Tate, The Virgin Suicides by Jeffrey Eugenides and The Girls by Emma Cline - Books that are joyful or brutal, particularly those that are both, similar to Headshot by Rita Bullwinkel, Kick the Latch by Kathryn Scanlan and Small Things Like These by Claire Keegan - Stories exploring an Australia or Ireland that is rarely seen in literature for example A Loving, Faithful Animal by Josephine Rowe and Wild Houses by Colin Barrett In non-fiction, Ciara enjoys narrative, memoir and essay collections. She is interested in hearing from experts, academics, critics and journalists writing about society, culture and food, and excited by writers seeking to revise, reshape or revolutionise the conversation in their area of expertise. Some of her favourite non-fiction titles include How To Survive A Plague by David France, The Transgender Issue by Shon Faye, the Living Autobiography Series by Deborah Levy, Last Witnesses: Unchildlike Stories by Svetlana Alexievich, King Kong Theory by Virginie Despentes; and she particularly enjoys the work of M.F.K Fisher, Annie Ernaux, Natalia Ginsburg and Helen Garner. Ciara is not looking for Children’s, YA or Fantasy. Ciara would like you to submit a covering letter, 1 -2 page synopsis and the first 5,000 words of your completed manuscript in a single word document. (In addition to the paid sessions, Ciara is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 6th January 2025

LOOKING FOR: MG, YA, ADULT FICTION / NON-FICTION Kesia Lupo joined Donald Maass Literary Agency in 2024 after 11 years working across the publishing industry. She started out as an editorial assistant at Pan Macmillan London in 2013, transitioning to children’s fiction in 2015 when she moved to Chicken House (a UK imprint of Scholastic), where she worked her way up from junior to senior editor. Here she acquired and edited bestselling, internationally successful and prize-winning fiction for middle grade (MG) and YA readers. In 2023 she transitioned over to the US and agenting, working with the Bindery Agency before finding a home with DMLA. At DMLA, Kesia is building a list leaning 60/40 towards MG and YA fiction, with the rest consisting of adult fiction and a smattering of adult non-fiction. She is especially, but not exclusively, interested in underrepresented voices, whether BIPOC, LGBTQ+, neurodivergent, disabled writers or other identities not listed here. Across all age-groups, she’s seeking: Fantasy/Science Fiction: High fantasy, low fantasy, cosy fantasy. Particularly interested in fantasy and SF inspired by underrepresented cultures with unique world-building. Romantasy is fine but the fantasy elements MUST be strong! Horror: Psychological and paranormal horror in particular but will consider slashers. Kesia loves gothic horror and is not generally fazed by gory content. Thrillers: Upmarket thrillers with a unique spin. Loves plot twists! Historical: Open to everything with a strong hook and informed by excellent research. Would love to find non-Eurocentric historical fiction. For adult fiction only, she’s seeking: Bookclub/women’s fiction: Voice-driven, high-concept novels across these categories. Romance: Upmarket romance with a great one-line pitch. Happy with spice. For adult non-fiction, she’s interested in accessible political, cultural or historical topics with broad appeal. Please don’t self-reject – if you are unsure about whether your story might be a good fit, Kesia would rather see it. In one single word document, Kesia would like you to submit a covering letter, 1 page synopsis and the first three chapters or 5,000 words of your manuscript in a single word document, whichever is shorter. (In addition to the paid sessions, Kesia is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Monday 27th January 2025

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

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.

Keeping your vision alive

Successful Teams

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

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!

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Even if you have completed a level 3 NVQ or a previous version of the wiring regulations, you still will have to prove you are conversant with the current standards. So therefore, keeping up to date with the latest wiring regulations satisfies these requirements. Although the BS 7671 can be a tricky book to navigate, our course has been designed in such a way as to ensure that you will have the knowledge to identify and find the topics covered in each of the relevant parts of the book. Further information can be found here: C&G 2382-22 BS7671 18th Edition — Optima Electrical Training (optima-ect.com)