878 Professional Development courses in Crewe delivered Live Online

Training - Grants Fundraising: preparing and prospecting Session aimed at charitable trusts, foundations and grants fundraisers FREE for HIGN members | £25 for non-members THIS SESSION WILL NOT BE RECORDED Capacity capped at 50 sign-ups. We will operate a waiting list if we reach this number, and may ask hospices with more than one sign-up to release places. Grants are the most significant source of income for small charities, but what are the key elements underlying a successful grants income stream? In this session we look at those foundational criteria essential to setting your organisation up for a win and tips how to find the best grants. This session is less appropriate for those with mature grant funding programmes. By the end of this session, we aim for you to: · Gain insight into the overall process of grants funding · Understand what fundraisers need to know before writing applications · See how to cost effectively find funders David describes himself as a “product of small charities”. A service user as a child, volunteer since his teenage years and now is helping to payback through training, mentoring and consultancy projects. He started a ranging career in fundraising in 2006, before maturing into a training and consultancy role with small charities some 12 years later. In early 2022, David joined the FSI and re-built their partnership training programme, carrying it forward in his own style with Triceratops Training after the closure of the previous charity. Most of our associate trainers, like David, were also training or consultancy associates for the FSI, NCVO, Lloyds Bank Foundation or DSC. David currently leads training programmes with Battersea Dogs & Cats Home, several funders, CVS and other sector infrastructure organisations across the UK.

Learners will develop knowledge from the FD&FA foundation module and/or industry experience and apply this to the maintenance of FD&FA systems.

Designed as a follow-on to The Practical Manager, this course will take your managers to the next level. Give them the skills to develop high performing teams through the application of tailored motivation strategies, effective performance appraisal and razor-sharp decision-making.

CRRUK equips professionals with the concepts, skills and tools to build conscious, intentional relationships, and to coach relationship systems of any size.

Overview Improve your knowledge of the English language and pronunciation and practice your speaking and vocabulary with our video lessons and with live face to face with the trainer online and In-Class. Choose your English course level from our wide range of english courses and start learning online today. Take any of our high quality online English lessons with the highlu experienced trainer and improve your English speaking skills along with your grammar, reading and writing. Start by taking our English lessons to help you find your level and increase your communication skills also find lessons and resources to improve your English skills. Throuh this course you will get more practice to improve your general English with our extended listening and reading materials and online trainer led training. Improve your the grammar and vocabulary and support your learning.

So often change fails because of our own pursuit of perfection. Learning to love imperfect change will improve your resilience and help you deliver positive change.

Learn how to create people and planet strategies that identify the lifecycles that exist within your business, and promote them widely, helping your business and the planet flourish.

Learners will develop knowledge from the FD&FA foundation module and/or industry experience and apply this to the commissioning, handover, and acceptance of FD&FA systems.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55232 Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Prioritising and creating order is the first step towards your success. There may be some skills that are fundamental to your results, while others are not something you should focus your efforts on. The Inner Genius Assessment is the perfect tool for you to identify your own personal roadmap.