2753 Professional Development courses in Coventry delivered Online

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.

This Coaching Program is unlike any other Coaching certification in the Market, It gives you the exclusive opportunity to be qualified as an Executive & Life Coach, as well as learn the NLP tools and the business building aspect.

Thinking about a job as a Digital Product Manager? The BCS Practitioner Certificate in Digital Product Management encourages individuals in both technical and non-technical product-related roles to develop the practical behaviours required to succeed in leading a product project or team.

Facilitation Skills for Business Analysts: In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP™). Business analysts are communicators who bridge the gap between people with business needs and knowledge and the people who will provide solutions. Business analysts are continuously involved in communications with stakeholders and developers as they create the solution to business problems. They participate in information-gathering sessions including interviewing, joint requirements definition, and Joint Application Design (JAD) workshops which are used to streamline information gathering and get immediate validation from user representatives. The business analyst is also involved with negotiating the solution with the stakeholders, upper-level management, and the developers, mediating among the groups when disagreements take place, and influencing the results of decisions during the solution cycle. This course teaches the methods needed to organize and run information-gathering events. It combines the basics of graphic decision making and modeling with facilitation, communication, and meeting management skills. What you will Learn At the end of this program, you will be able to: Identify the major touch points between key BABOK® Guide knowledge areas and business analysis communication Describe the facilitation skills that are most supportive of those intersections Improve your ability to apply these skills in the context of your business analyst functions Foundation Concepts The role of the Business analyst (BA) An Introduction to the BABOK® Guide Business analyst roles and the product / project life cycle (PLC) Facilitation skills for the business analyst The BABOK® Guide and Communication An introduction to the communication process Addressing basic communications challenges Planning business analysis communication Communication and BABOK® Guide tasks Targeted Elicitation Techniques Synergy between communication and targeted elicitation techniques Preparing for elicitation Cornerstone targeted technique: interviews Other targeted elicitation techniques Related general communication skills Group Elicitation Techniques Synergy between requirements communication and group elicitation techniques Cornerstone group elicitation technique - requirements workshops Other group elicitation techniques Related general communication skills - meeting management best practices Related general communication skills - facilitating best practices Process / Model-Based Elicitation Techniques Synergy between requirements communication and process / model-based elicitation techniques Process / model-based elicitation techniques Related interpersonal skills - problem solving and decision making Investigative Elicitation Techniques Synergy between requirements communication and investigative elicitation techniques Cornerstone investigative elicitation technique - document analysis Other investigative elicitation techniques Summary of elicitation techniques by usage in the requirements process Using Presentations, Structured Walkthroughs, and Influencing Structured walkthroughs, presentations, and influencing within BABOK® Guide tasks Cornerstone technique - structured walkthroughs General communication skill - presenting Related interpersonal skill - influencing Special Facilitation Skills - Negotiating and Mediating Negotiating Mediating

Join the Analyst Academy Pro and get a job as a job as a research analyst or simply fast-track your career in asset management.

Duration 2 Days 12 CPD hours Overview This program is designed to provide you with the knowledge and skills necessary to: Build a solid foundation in human resource management. Discuss key pieces of federal legislation that impact HR. Understand the role of the EEOC and its investigatory process. Improve your employee recruitment and selection process to help avoid legal pitfalls. Understand the importance of effectively communicating base pay, incentive compensation, and benefits information to staff at all levels. Gain knowledge of employee orientation, onboarding, and training and development. Learn the process, methods and purpose of performance appraisals. Gain the critical knowledge necessary to help reduce costs, avoid potential lawsuits, and improve your ability to handle challenging HR issues. This program is ideal if you are just starting out in the HR profession. 1 - HUMAN RESOURCE MANAGEMENT The HR profession Strategic and human resource planning 2 - EMPLOYMENT LAW Federal CEO legislation The EEOC and affirmative action Compensation legislation Other federal 3 - RECRUITMENT AND SELECTION Recruiting The selection process Evaluating applicants 4 - COMPENSATION AND BENEFITS Total compensation Pay increases and incentives Compensation system design Benefits overview 5 - EMPLOYEE DEVELOPMENT Orientation, training, and development Training program design Training evaluation 6 - PERFORMANCE MANAGEMENT Performance management systems Performance appraisal process Disciplinary action Termination Additional course details: Nexus Humans SHRM Essentials of HR Management 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 SHRM Essentials of HR Management 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.

Creating Family Friendly Museums: Afternoon Cuppa Session (Wales) Monday 7 July, 2-3pm Join us for an informal virtual briefing and Q&A session to help you think about low and no cost changes you could make to enhance your museum’s family provision using the Kids in Museums Manifesto. The Kids in Museums Manifesto is a set of simple guidelines for museums, heritage sites and cultural organisations, which we update every two years. In late 2024, we consulted hundreds of children, young people and families about what makes a heritage site a great place to visit, using their responses to shape a new version of the Manifesto. In this session, we will introduce the new version, along with low and no cost changes you could make to improve your museum for a family audience. You can also find out about the Kids in Museums Manifesto Self-Assessment Tool, which can support you to do a light touch self-audit of how well your museum or heritage site meets the Kids in Museums Manifesto. The Kids in Museums Manifesto Self-Assessment Tool is particularly aimed those with limited budgets. In this session, we will: Provide a range of practical ideas to inspire your family friendly provision. Share how your organisation can use the Kids in Museums Manifesto Self-Assessment Tool to improve your family offer. Hear a case study from Ruthin Gaol about the changes they made to their family offer following a Kids in Museums Family Friendly Museum Audit. Please bring along your own cuppa and snacks! Take a look at the full schedule. This event will be delivered virtually over one hour. This session will be delivered in English with bilingual slides, with the option to provide a Welsh language interpreter. The Kids in Museums Manifesto and self-assessment tool are also available in Welsh. Generously supported by the Welsh Government. Who should attend? This training is aimed at staff and volunteers who work in museums, art galleries and heritage sites who are interested in making their organisations more family friendly. This training webinar is for staff and volunteers from Welsh museums only. Creu Amgueddfeydd sy’n Croesawu Teuluoedd: Sesiwn Paned Prynhawn (Cymru) Dydd Llun 7 Gorffennaf, 2-3pm Ymunwch â ni ar gyfer sesiwn briffio a holi ac ateb anffurfiol ar-lein i’ch helpu i ystyried sut y gallech chi wneud newidiadau am ddim, neu am gost isel, i wella darpariaeth eich amgueddfa i deuluoedd gan ddefnyddio Maniffesto Kids in Museums. Mae Maniffesto Kids in Museums yn gyfres o ganllawiau syml i amgueddfeydd, safleoedd treftadaeth a sefydliadau diwylliannol, yr ydym yn ei ddiweddaru bob dwy flynedd. Tua diwedd 2024, aethom ati i holi cannoedd o blant, pobl ifanc a theuluoedd am yr hyn sy’n gwneud safle treftadaeth yn lle da i ymweld ag o. Yna aethom ati i ddefnyddio eu hatebion i siapio fersiwn newydd o’r Maniffesto. Yn y sesiwn hon, byddwn yn cyflwyno’r fersiwn newydd hwn, ac yn awgrymu newidiadau cost isel, neu am ddim, y gallech eu gwneud i wella eich amgueddfa i deuluoedd sy’n ymweld. Gallwch hefyd ddysgu am Offeryn Hunanasesu Maniffesto Kids in Museums, sy’n gallu eich cefnogi chi i wneud hunan-archwiliad ysgafn o’r graddau y mae eich amgueddfa neu safle treftadaeth yn cyfateb â Maniffesto Kids in Museums. Mae Offeryn Hunanasesu Maniffesto Kids in Museums wedi’i anelu’n arbennig at safleoedd sydd â chyllidebau cyfyngedig. Yn y sesiwn hon, byddwn yn: Cynnig amrywiaeth o syniadau ymarferol i ysbrydoli eich darpariaeth sy’n addas i deuluoedd. Rhannu sut y gall eich sefydliad ddefnyddio Offeryn Hunanasesu Kids in Museums i wella eich cynnig i deuluoedd. Clywed astudiaeth achos o Garchar Rhuthun am y newidiadau a wnaethant i’w cynnig i deuluoedd yn dilyn Archwiliad Amgueddfeydd sy’n Croesawu Teuluoedd gan Kids in Museums. Dewch â’ch paned a’ch byrbryd eich hun! Gwelwch yr amserlen lawn. Bydd y sesiwn hon yn para awr ac yn cael ei darparu ar-lein. Bydd yn cael ei chyflwyno drwy gyfrwng y Saesneg gyda sleidiau dwyieithog, a’r opsiwn i gael cyfieithydd Cymraeg. Mae Maniffesto Kids in Museums a’r pecyn hunanasesu ar gael yn Gymraeg hefyd. Gyda chefnogaeth hael gan Lywodraeth Cymru. Pwy ddylai fynychu? Mae’r hyfforddiant hwn wedi’i fwriadu ar gyfer staff a gwirfoddolwyr sy’n gweithio mewn amgueddfeydd, orielau celf a safleoedd treftadaeth sydd â diddordeb mewn gwneud eu sefydliadau’n fwy croesawgar i deuluoedd. Mae’r gweminar hyfforddi hwn i staff a gwirfoddolwyr mewn amgueddfeydd yng Nghymru yn unig.  

Learn user experience fundamentals and master the design process with a user-centered approach. This UX Design Course has been designed to fully equip you with all the tools and methodologies you need to succeed as a UX designer.

Our excellent value long-term support option for RICS APC candidates, covering all RICS APC routes, pathways and world regions. This is one of our most popular packages providing you with your own personal APC support team. This can include a Counsellor sign-off, subject to separate agreement between you and Property Elite. This includes: Submission Review APC Question Pack E-mock Interview 2 hours of 1-2-1 or small group online/telephone mentoring per month with a current RICS APC assessor. If you wish, this can be saved up to use at any time during your sign-up period with Property Elite. Full suite of online revision quizzes Full revision guide package Our minimum sign up period is 4 months - minimum £350 + VAT per month over 4 months = total of £1,400 + VAT. You will need to sign up at least 1 month before you submit your final assessment documents to ensure you are able to take full advantage of this package.

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.