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
– in yourself and others Research shows that exercising self-compassion creates more resilience against stress, greater ability to focus, increases happiness and optimism, improves relationships and more. This live online course explains why and gives you a range of effective techniques you can use straight away… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm BST) Absolutely brilliant live workshop from beginning to end!CARMEL AUSTIN Many people struggle with showing themselves compassion – they may be highly critical of themselves, or wracked with feelings of shame, self-doubt or self-worth – but with the right approach it is possible to help them develop this key component of recovery and wellbeing. This new online self-compassion course provides you with all you need to know to bring self-compassion into your practice, your personal life and the lives of others – with plenty of time to try out the techniques for yourself. Join our expert tutor Julie Johnson live online on Tuesday 4th June 2024 for this helpful CPD training delivered via Zoom. When you book, we’ll email your booking confirmation – your link for joining the Zoom workshop will be sent the day before the event – numbers are limited so book soon to ensure your place. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties, so you’ll also get a recording afterwards for a limited time to maximise your learning. Why take this course Being compassionate towards ourselves when things go wrong, or we are struggling to cope, is not self-pity – it is an essential skill that can be learnt and developed, giving people the strength to move forward. When things don’t go our way or we feel we can’t cope – or something bad has happened to us – we may feel ashamed or blame ourselves for not being good enough, capable enough, strong enough and so on. This negative self-criticism can be highly damaging and hold us back. It is far more empowering to turn towards ourselves with compassion (which is what self-compassion literally means). Helping people to find the best ways to draw out their self-compassion is a skill that needs to be learned. Different from empathy (the ability to appreciate what another person is experiencing) and from self-pity (which is self-focused, exaggerates personal suffering and is disempowering and draining), self-compassion enhances resilience, allowing us to recognise our personal failings while appreciating that we are all human and make mistakes – thus helping us to move on past them. Learning how to use self-compassion from a human givens perspective makes it an extra-valuable tool for supporting our clients in getting their innate needs met and making best use of their innate resources. It may also help you in your own life. This indepth 1-day live online self-compassion experiential training day shows you how. A wonderful online learning experience, jam-packed full of useful teaching and loads of references to resources for further self study and development...KARSTEN ALVA-JORGENSEN, EXECUTIVE COACH What will you learn What self-compassion is and isn’t Research findings that demonstrate the positive effects on the body and mind of exercising self-compassion Why some people find self-compassion difficult The roots of self-compassion A new empowering perspective on making mistakes How practising self-compassion helps our ability to problem solve An important adjunctive tool for working with harsh self-criticism, trauma, emotional pain; bereavement, loss, change, and chronic-conditions Why self-compassion increases resilience Simple techniques for self-soothing and self-care How to apply these new understandings in therapy The especial value of using these techniques with parents and children How to bring these technique seamlessly into everyday life Ways that self-compassion helps with meeting emotional needs The impact of self-compassionate practice on organisations How self-compassion can help children become happier and kinder Why compassion for oneself enhances sense of status Ways that exercising self-compassion lowers emotional arousal and unhelpful thinking How self-compassion differs from both compassion and empathy The dangers of too much self-compassion How self-compassion helps focus the imagination positively Creative applications of self-compassion How self-compassion maps onto every human need and innate emotional resource, making it an essential tool in every HG practitioner’s toolbox Practical examples and case histories to learn from Who is this course suitable for? Anyone interested for personal or professional reasons Including anyone working as a practitioner helping those in mental distress or with chronic physical conditions Anyone interested in skills to help promote their own wellbeing and that of others Anyone working or living with children, or young and older people Anyone working with parents Anyone working within a caring context, such as carers, teachers, NHS workers, foster carers, social workers etc Therapists, counsellors and mental health professionals Course Programme The ‘Developing Self-Compassion’ live online training day starts at 9.15am and runs until 4.00pm. (BST). 9.15am Join the Zoom meeting 9.00am Introduction to self-compassion 11.00am Comfort break and discussion 11.30am Unpacking self-compassion 1.00pm Lunch break 1.45pm Self-compassion skills 2.45pm Comfort break and discussion 3.00pm Pulling it all together 4.00pm End days 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 Internal auditing is an independent and objective activity to evaluate an organisation's internal operations. You'll learn how to initiate an audit, prepare and conduct audit activities, compile and distribute audit reports and complete follow-up activities. It is very important for the organisation to have a smooth flow of accounting as it plays a very important role in the development of the organisation. Financial Managers or any person who deals with Accounts need to see that the company accounts are very updated and are free from any risks that can become a problem during the time of Auditing. Objectives By the end of the course, participants will be able to: Efficiently dealing with senior leaders with confidence Effective Contribution and Strategically Analysing and Auditing towards business success Analysing and Evaluating as an effective internal audit leader How to manage key relationships with the audit committee Practical methods for managing the audit committee and senior management Describing the significance to help maximize the contribution to their organization
Empty Spaces, Expressionless Faces. Supporting colleagues in a hybrid workplace Dementia touches more than memory — it weaves into the lives, relationships, and wellbeing of everyone involved. This engaging 2 hour workshop dives into the types and prevalence of dementia, the daily realities for those affected, and how we can step up—individually, locally, and nationally. We’ll explore support, tackle tricky ethical questions, and break down stigma Workshop outline: Understand the types and symptoms of dementia Explore sources of support Reflect on ethical considerations Learn how to support others effectively Apply awareness in your workplace and communities Expect fresh insights, straight-talking discussions, and practical supports you can take back to your workplace. Plus, further signposting to keep your learning journey going. 2-hour workshop packages At Mindmaps Wellbeing, we know that every business is unique, and no team is the same. That’s why we’ve developed our range of short, specialist wellbeing and mental health themed workshops—a fully flexible approach to workplace training. With our selection of engaging and impactful 2-hour workshops, you can build a programme that truly meets your organisation’s needs. Whether you’re looking to manage stress, challenge stigma, or avoid burnout, you choose the sessions that suit your team best. Our training courses and workshop collection Book multiple workshops on the same day to save Why Mindmaps Wellbeing? Mindmaps Wellbeing is the trusted training provider for businesses looking to enhance workplace mental health and employee wellbeing. Our training is designed and delivered by registered Mental Health Nurses, ensuring credibility, expertise, and real-world application. Focus on culture change – Our training goes beyond theory transfer, aiming to embed lasting behavioural shifts that foster a positive, mentally healthy workplace Flexible delivery options – We offer in-person, online, and hybrid training solutions to fit your organisation’s needs Proven impact and measurable results – Our training leads to improved employee engagement, productivity, and retention Engaging and actionable – All our courses include interactive activities, case studies, and real-world applications for immediate impact
CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.
This Business English tutoring course is designed to help adult learners improve their English language skills within a professional context. Participants will focus on developing their communication skills, vocabulary, and cultural understanding necessary for success in the business world. Through practical exercises, role-plays, and industry-specific materials, learners will enhance their ability to effectively communicate in English within various business situations. Course Duration: 12 weeks (48 sessions) Course Objectives: By the end of this course, participants will: 1. Communicate confidently and effectively in English within a business setting. 2. Expand business-related vocabulary and improve language accuracy. 3. Develop listening skills to understand business conversations and presentations. 4. Enhance reading comprehension skills for business-related texts. 5. Write accurately and coherently for business correspondence. Course Outline: Week 1: Introduction to Business English - Introduction to course objectives, expectations, and methodology - Assessment of participants' current language proficiency and individual learning goals - Overview of key business English skills and areas of focus Week 2: Business Communication Skills - Developing effective oral communication skills for business settings - Role-plays and discussions related to common business scenarios - Enhancing fluency, clarity, and confidence in expressing ideas and opinions Week 3: Business Vocabulary Expansion - Expanding business-related vocabulary and terminology - Exercises and activities to reinforce and practice key business terms - Incorporating industry-specific jargon into oral and written communication Week 4: Business Writing Skills - Improving writing skills for business correspondence - Practice exercises for emails, reports, memos, and other business documents - Enhancing clarity, coherence, and professional tone in written communication Week 5: Listening and Comprehension in Business Contexts - Developing listening skills to understand business conversations, presentations, and meetings - Authentic listening materials related to various business topics - Strategies for note-taking, understanding accents, and extracting key information Week 6: Reading and Comprehension for Business - Developing reading skills for business-related texts - Strategies for skimming, scanning, and understanding complex business documents - Identifying main ideas, supporting details, and summarising key information Week 7: Business Presentation Skills - Developing effective presentation skills for business contexts - Techniques for organising content, engaging the audience, and delivering impactful presentations - Practice sessions with feedback and guidance Week 8: Business Negotiation Skills - Enhancing negotiation skills for business interactions - Role-plays and practical exercises for successful negotiations - Polishing language and strategies for effective business communication Week 9: Business Etiquette and Cultural Understanding - Understanding business etiquette and cultural nuances in professional settings - Developing intercultural communication skills for international business contexts - Practicing effective communication in diverse and multicultural environments Week 10: Business Networking and Socialising - Developing language skills for networking and socialising in business contexts - Role-plays and exercises for effective communication at conferences, events, etc. - Polishing conversational skills, small talk, and building professional relationships Week 11: Business Grammar and Language Accuracy - Reviewing and reinforcing essential grammar rules and structures in a business context - Identification and correction of common errors in business writing and speaking - Exercises and activities to improve language accuracy Week 12: Review and Final Evaluation - Reviewing course content and addressing individual needs - Comprehensive review exercises for all language skills in a business context - Final evaluation and feedback session Note: This syllabus serves as a guideline and can be customised based on the specific needs, interests, and proficiency levels of the participants. The course may also include guest speakers or industry-specific case studies to provide further immersion and practical application of language skills.
Time: 4pm Date: 17th January Location: Studio A We're kicking off 2024 with a season of films by Greta Gerwig! First up, her heartfelt and nostalgia-laced debut, 2017's Lady Bird. Saoirse Ronan (in one of her best ever roles) stars as Christine 'Lady Bird' McPherson, an out-spoken teenager looking to establish her own identity away from Sacramento, where she's spent her whole life. At the same time she faces complex relationships with her mother, first love, best friend and home identity. We look forward to welcoming you all back to the CFS Film Club this year!
This MS Access Advanced Course mostly covers creating advanced MS Access reports, forms, and macros. Create and amend Advanced Forms and Advanced Reports. Macro buttons. This assists you to build user-friendly forms to facilitate effective navigation, effective data capture and effective viewing and querying data This course will help you to structure MS Access tables, import, and manage your data effectively.
This Access Course concentrates on using creative queries, to extract data from large data sets to get insight from your data and report it. Learn and explore various query techniques from where clauses, to aggregation, joins and more. This private style tuition helps to maximise the value you get from the day.
Are you looking for something that will help you understand yourself and how to interact with others more effectively? Would you like something that uses a simple four colour model to quickly allow you to understand your personality type and how you can use this knowledge to enhance your relationships and reach your goals, whatever they are? We think that Insights Discovery might be just the thing for you! What's even better is that our Discovery bundle includes both a copy of your unique profile and a 90 minute personal session with our executive coach, Cami Rose, to chat it all through and set you up for success using your new knowledge for the future. Just request a session and we'll be in touch with the link that will allow you to complete the Insights evaluator and arrange your personal coaching session at a time to suit you. Want Discovery for your team? We can do that too. Leave us your name and details and we'll be in touch to chat through your needs and objectives.