606 AI courses in Bradford

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

This five-day programme empowers participants with the skills and knowledge to understand and effectively apply best practice commercial and contracting principles and techniques, ensuring better contractor performance and greater value add. This is an assessed programme, leading to the International Association for Contracts & Commercial Management (IACCM)'s coveted Contract and Commercial Management Practitioner (CCMP) qualification. By the end of this comprehensive programme the participants will be able to: Develop robust contracting plans, including scopes of work and award strategies Undertake early market engagements to maximise competition Conduct effective contracting and commercial management activities, including ITT, RFP, negotiated outcomes Understand the legalities of contract and commercial management Negotiate effectively with key stakeholders and clients, making use of the key skills of persuading and influencing to optimise outcomes Undertake effective Supplier Relationship Management Appreciate the implications of national and organisational culture on contracting and commercial activities Appreciate professional contract management standards Set up and maintain contract and commercial management governance systems Take a proactive, collaborative, and agile approach to managing commercial contracts Develop and monitor appropriate and robust KPIs and SLAs to manage the contractor and facilitate improved contractor performance Appreciate the cross-functional nature of contract management Collaborate with clients to deliver sustainable performance and to manage and exceed client expectations Understand the roles and responsibilities of contract and commercial managers Use effective contractor selection and award methods and models (including the 10Cs model) and use these models to prepare robust propositions to clients Make effective use of lessons learned to promote improvements from less than optimal outcomes, using appropriate templates Effectively manage the process of change, claims, variations, and dispute resolution Develop and present robust propositions Make appropriate use of best practice contract and commercial management tools, techniques, and templates DAY ONE 1 Introduction Aims Objectives KPIs Learning strategies Plan for the programme 2 The contracting context Key objectives of contract management Importance and impact on the business 3 Critical success factors Essential features of professional commercial and contract management and administration The 6-step model 4 Putting the 'management' into commercial and contract management Traditional v 'new age' models The need for a commercial approach The added value generated 5 Definitions 'Commercial management' 'Contract management' 'Contracting' ... and why have formal contracts? 6 Stakeholders Stakeholder mapping and analysis The 'shared vision' concept Engaging with key functions, eg, HSE, finance, operations 7 Roles and responsibilities Contract administrators Stakeholders 8 Strategy and planning Developing effective contracting plans and strategies DAY TWO 1 Contract control Tools and techniques, including CPA and Gantt charts A project management approach Developing effective contract programmes 2 The contracting context Key objectives of contract management Importance and impact on the business 3 Tendering Overview of the contracting cycle Requirement to tender Methods Rationale Exceptions Steps Gateways Controls One and two package bids 4 Tender assessment and contract award I - framework Tender board procedures Role of the tender board (including minor and major tender boards) Membership Administration Developing robust contract award strategies and presentations DAY THREE 1 Tender assessment and contract award II - processes Pre-qualification processes CRS Vendor registration rules and processes Creating bidder lists Disqualification criteria Short-listing Using the 10Cs model Contract award and contract execution processes 2 Minor works orders Process Need for competition Role and purpose Controls Risks 3 Contract strategy Types of contract Call-offs Framework agreements Price agreements Supply agreements 4 Contract terms I: Pricing structures Lump sum Unit price Cost plus Time and materials Alternative methods Target cost Gain share contracts Advance payments Price escalation clauses 5 Contract terms II: Other financial clauses Insurance Currencies Parent body guarantees Tender bonds Performance bonds Retentions Sub-contracting Termination Invoicing 6 Contract terms III: Risk and reward Incentive contracts Management and mitigation of contractual risk DAY FOUR 1 Contract terms IV: Jurisdiction and related matters Applicable laws and regulations Registration Commercial registry Commercial agencies 2 Managing the client-contractor relationship Types of relationship Driving forces Link between type of contract and style of relationships Motivation - use of incentives and remedies 3 Disputes Types of dispute Conflict resolution strategies Negotiation Mediation Arbitration DAY FIVE 1 Performance measurement KPIs Benchmarking Cost controls Validity of savings Balanced scorecards Using the KPI template 2 Personal qualities of the contract manager Negotiation Communication Persuasion and influencing Working in a matrix environment 3 Contract terms V: Drafting skills Drafting special terms 4 Variations Contract and works variation orders Causes of variations Risk management Controls Prevention Negotiation with contractors 5 Claims Claims management processes Controls Risk mitigation Schedules of rates 6 Close-out Contract close-out and acceptance / completion HSE Final payments Performance evaluation Capturing the learning 7 Close Review Final assessment Next steps

REFERENCE CODE 601/8331/7 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in installing Rainscreen wall cladding systems and/or roof sheeting and cladding systems that involve curved and complex roof and wall formations in the workplace, working from drawings and specifications. It is not expected that candidates working in this industry all do the same activities or use the same equipment and machinery so the qualification has been developed to make it as widely available as possible by having 2 distinct pathways. All work completed must be carried out in accordance with Building Regulations and Industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the relevant mandatory pathway units of installation of the relevant system (roof and wall sheeting and cladding or rainscreen wall cladding systems) , candidates will also be able to select optional units recognising skills including, repair and/or refurbishment of roof sheeting/cladding/rainscreen systems, working with boom and/or scissor type mobile elevating platforms (MEWPs), installing solar collectors, use of ergonomic manipulating machines or slinging/signalling the movement of loads. The standards cover the most important aspects of the job. This qualification is at Level 3, although some units may be at different levels, qualifications at this level are primarily aimed at those who are fully trained and experienced in a wide range of roles that may involve decision making, quality checks, work planning and dealing with non-routine or complex installations. The qualification consists of 3 mandatory units and 2 pathways, Wall sheeting and cladding and Rainscreen Wall Systems. Candidates must achieve the 3 qualification mandatory units plus the required credits from the selected pathway. The minimum credit value of the Wall sheeting and cladding qualification is 132 credits, the minimum credit value of the Rainscreen wall systems qualification is 104 credits.

BLS Training First Aid Training Mandatory Training

REFERENCE CODE 610/0054/0 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This qualification is aimed at those who are involved in setting out and erecting masonry structures onsite working from drawings and specifications. The structures could be brick and blockwork or local materials. It is not expected that candidates working in this industry all do the same activities, so the qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the mandatory units’ candidates will also be able to select optional units recognising specific skills What is required from candidates? Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria, this qualification has a TQT of 610 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to receive in order to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 334. Group A MANDATORY UNITS Level Credit Confirming Work Activities and Resources for an Occupational Work Area in the Workplace Developing and Maintaining Good Occupational Working Relationships in the Workplace Confirming the Occupational Method of Work in the Workplace Conforming to General Health, Safety and Welfare in the Workplace Erecting and Dismantling Access/Working Platforms in the Workplace Preparing surfaces for painting and/or decorating in the workplace Applying surface coatings by brush and roller in the workplace Optional units Group A – Minimum of 1 unit must be achieved from this group Hang wallcoverings (standard and foundation papers) in the workplace Hanging non-standard width wallcoverings in the workplace 3 20 Optional units Group B-Minimum of 1 unit must be achieved from this group Applying coatings by the airless spray method in the workplace Summary of the: LEVEL 3 NVQ DIPLOMA IN DECORATIVE FINISHING-PAINTING AND DECORATING (CONSTRUCTION) Producing and applying complex stencils in the workplace 3 21 Hanging wallcoverings to complex surfaces in the workplace 3 32 Hanging wallcoverings (specialised paper) in the workplace 4 30 Assessment Guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for these qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

REFERENCE CODE 610/0134/X COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This qualification is aimed at those who are involved in either site carpentry including first and second fixing, those who are involved in shopfitting site work or those who carry out shopfitting bench work. The qualification is at level 3 although there may be some units at different levels. Level 3 qualifications are primarily aimed at those who are fully trained and experienced in a wide range of work activities, It is not expected that candidates working in this industry all do the same activities or use the same equipment and machinery so the qualification has been developed to make it as widely available as possible. All work completed must be carried out in accordance with Building Regulations and Industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the pathways and units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. The qualification consists of 3 pathways. What is required from candidates? Qualifications are also required to indicate the number of hours of teaching someone would normally need to receive in order to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 404. Pathway 1 Site Joinery, Pathway mandatory units Level Credits Installing bespoke first fixing components in the workplace Installing bespoke second fixing components in the workplace Setting up and using transportable cutting and shaping machines in the workplace Erecting roof structure carcassing components in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 1 Site joinery – Optional units minimum of 1 unit must be achieved Erecting structural carcassing components in the workplace Maintaining non-structural and structural components in the workplace Pathway 2-Shopfitting site work-Pathway mandatory units Marking out from setting out details for routine shopfitting products in the Summary of the: GQA LEVEL 3 NVQ DIPLOMA IN WOOD OCCUPATIONS (CONSTRUCTION) Installing shopfitting frames and finishings in the workplace Installing shopfitting fitments in the workplace Installing shopfronts and finishings in the workplace Setting up and using transportable cutting and shaping machines in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting-Bench Work – Pathway mandatory units Producing setting out details for routine shopfitting products in the workplace Marking out from setting out details for routine shopfitting products in the workplace Manufacturing routine shopfitting products in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Manufacturing bespoke shopfitting products in the workplace Setting up and using fixed machinery in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting – Bench work – Pathway optional units a minimum of 1 unit must be achieved Producing CAD setting out details in the workplace Producing wood and wood-based products using computer numerically controlled/numerically controlled (CNC/NC) machinery in the workplace Producing setting out details for bespoke shopfitting products in the workplace Assessment Guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, contact Oscar Onsite Academy

Everyone shares responsibility for safeguarding and promoting the welfare of children and young people, irrespective of individual roles. This course is for those who have already completed a Level 1 course and need to gain an advanced knowledge of Child Protection, including working towards becoming a Designated Safeguarding Lead (DSL), manager or policy writer. This course is designed for individuals who work with children in either a paid or voluntary capacity. It relates to the issues surrounding safeguarding children by exploring the concepts of "child vulnerability", "child protection" and "significant harm"; coupled with the individual and organisational responsibilities of protecting children from abuse.

Our Legionella/Water Quality Risk Management – General Awareness course offers a basic introduction to Legionnaires' disease Management and Control.

This course presents the role of the care worker using demonstrations of good and bad practices. It includes information on Core Values, Code of Conduct, and Continual Professional Development. This subject forms Standard 1 of the Care Certificate.

A key-worker role is to provide the best individual care for people they support and carry out effective assessment and support planning. Staff need to know how to motivate individuals to achieve their personal goals and understand how to advocate on their behalf. Staff also need to know how to improve communication between colleagues, individuals, other professionals, and contribute to service improvement.