• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

184 Courses in Manchester

ILM Level 2 Award in Leadership and Team Skills

By Dickson Training Ltd

An accredited qualification to prepare supervisors and team leaders for a future management role. This programme gives Team Leaders & Managers the skills, disciplines and confidence to manage their team effectively and add a great deal more value to the organisation - where they have to apply their learning in order to achieve the highly coveted ILM qualification. In order for a business to obtain maximum results, it is important that employees are motivated and supported in their job roles. It is the responsibility of the team leader or supervisor to lead their team effectively and present feedback to management. This 3-day programme will guarantee to boost your performance as a team leader and help you make the transition from working in a team to leading a team. We use a combination of theory and practical to help you develop yourself, and a toolkit of resources to use in the workplace. This is an internationally accredited course which not only carries kudos but it ensures you apply the learning back into the workplace for an immediate impact. All of our ILM Programmes are provided in partnership with BCF Group Limited, which is the ILM Approved Centre we deliver under. Course Syllabus The syllabus of the ILM Level 2 Award in Leadership and Team Skills course is split into three main modules, covering the following: Module One Developing Yourself as a Team Leader Learning the various roles, functions and responsibilities of a team leader - depending on workplace Recognising limits of authority and accountability, and how these are defined Developing personal skills and abilities for effective team leading Using reflective learning skills to improve performance Identifying areas of strength and possible improvement Finding ways of obtaining feedback from others Receiving and responding positively to feedback Module Two Workplace Communications Learning stages in the communication process Consideration of the recipient's needs Spotting barriers to communication and how to overcome them Establishing a range of direct communication methods relevant to the team Collating a range of direct communication methods relevant to people outside own area of responsibility. This includes written, telephone, e-mail and face-to-face Recognising the aspects of face-to-face communication, including appearance, impact, body language Realising the importance of succinct and accurate records of one-to-one oral communication Reasons for maintaining records of one-to-one communication (e.g. potential disciplinary or legal issues) Module Three Managing Yourself Setting SMART objectives and using them to prioritise own actions Learning simple time management techniques Developing an awareness of own skills and abilities Giving yourself personal objectives in relation to team objectives Developing flexibility and responding to daily changing circumstances Diagnosing the causes and impacts of stress at work Identifying symptoms of stress in yourself Knowing the implications of stress for workplace and non-work activities/relationships Developing simple stress management techniques Available sources of support Action planning and review techniques Accreditation As with all ILM accredited programmes, participants will need to complete the post-programme activity in order to achieve their full ILM Level 2 Award in Team Leading. This element is designed to show to ILM that you are able to apply what you have learned in the workplace. Who Is It For? This programme is ideal for practising or aspiring team leaders, in any industry sector, who is looking to gain a solid foundation or develop their existing skills as a team leader. This internationally recognised course will give you a solid understanding of what is needed to be a successful team leader, how to delegate, motivate and how to implement these skills in to your work place. What Will I Learn? At the end of the course, successful candidates will: Have a good understanding of the team leader role Apply a range of effective communication skills to overcome barriers Know how to motivate, build confidence and gain the best from their teams Identify, build and encourage effective team behaviours Apply practical skills and knowledge to be transferred to the workplace Gain an internationally recognised qualification What Is Required? There are no formal entry requirements, but participants will normally be either practising or aspiring team leaders, with the opportunity to meet the assessment demands and have a background that will enable them to benefit from the programme. Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. For more information about running this course in-house at your premises, please contact us for more information.

ILM Level 2 Award in Leadership and Team Skills
Delivered in Bardsey + 3 more or UK Wide or OnlineFlexible Dates
Price on Enquiry

Advanced Excel Course in Abu Dhabi

By Time Training Center

Improove your excel skills with Time Training Center’s advanced excel course in Abdu Dhabi. Our advanced Training can help you master the latest functions and tools in MS Excel.Acquire multiple skills, such as calculating, evaluating, organising, and coordinating data through spreadsheets. Enroll now! Call us: 97126713828 Mail : info@timetraining.ae Learn more:https://www.timetraining.ae/course/advanced-excel-course-in-abu-dhabi Address: Office 203, ADCP Tower - B,Behind City Seasons, Electra Street, Abu Dhabi United Arab Emirates

Advanced Excel Course in Abu Dhabi
Delivered In-PersonFlexible Dates
FREE

NPORS Plant Mover Training

5.0(3)

By Vally Plant Training

NPORS Plant Mover Training Provide candidates with the training and knowledge to enable them to carry out the movement of plant equipment safely. NPORS Plant Mover Training course is aimed at people who are responsible for moving the machinery around the site, this could be maintenance staff or drivers who deliver the machinery to site. All staff should be trained in the safe operation of plant or machinery. NPORS is an approved CSCS Partner Card Scheme, providing evidence that individuals working on construction sites have the appropriate training and qualifications for safe movement of construction machinery. Furthermore, Plant Mover training criteria is based on the approved standards of the Construction Leadership Council. Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Your skills, our commitment—always at the best price. Course Content Have a basic understanding of the industry, the dangers of working in the industry and their responsibilities as an operator. Have a working knowledge of the manufacturer‘s handbook for each machine. Be able to locate and identify the major components of the machine and explain their functions. Be able to locate and identify all controls and operate the machine safely. Conduct all pre-operational checks in accordance with the manufacturer‘s recommendations. Use the correct PPE for Plant Movers. Prepare machinery for movement and operate machinery safely in forward and reverse gears over varying terrain. Conduct all necessary safety checks in the working area. Correct Storage and transportation of machinery attachments (buckets, forks, breakers etc). Carry out all end of shift and shut down procedures. Variations: Lifting equipment Earthmoving equipment Accessing Equipment Plant Mover Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of plant movers and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical training area to simulate an actual working environment for the movement of plant Our Plant Mover training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS Plant Mover Tester to your site nationwide, to reduce the amount of time away from work Frequently Asked Questions 1. What qualifications do I need to enroll in the Plant Mover Training course? The course is intended for individuals who have some prior training or extensive experience with plant moving. If unsure, it’s advised to contact the training center for specific eligibility requirements. 2. What does the Plant Mover Training include? The training covers industry basics, safety responsibilities, machine operations, pre-operational checks, and correct use of personal protective equipment. It includes both theoretical and practical sessions to ensure comprehensive learning. 3. How long does the course last, and what are the class sizes? The course duration varies: 2 days for novices with a maximum of 6 candidates, and 1 day for experienced workers with a maximum of 8 candidates. 4. Are there any certifications provided after completing the course? Yes, successful candidates receive an NPORS card, which is a recognized certification for operating plant machinery safely. The type of card (traditional or with CSCS logo) depends on the specific requirements met during the course. 5. Can I take this course at my workplace? Yes, the training center offers options to conduct training at your site nationwide, though additional charges for mileage and accommodation may apply. 6. Is there funding available for this training? CITB funding might be available for eligible candidates, which can help cover the cost of the training. More courses: Polish your abilities with our dedicated Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Plant Loader Securer, Ride-On Road Roller, Abrasive Wheel Training, Lorry Loader Training and Scissor Lift Training sessions. Learn the safe and effective operation of these vital machines, crucial for construction and maintenance tasks. Elevate your skills and career prospects by enrolling in our comprehensive courses today. For those looking for a “NPORS Scissor Lift Training near me,” our widespread operations make it convenient for you to access Vally Plant Trainings top-quality training no matter where you are in the UK

NPORS Plant Mover Training
Delivered In-Person in Tewkesbury or UK WideFlexible Dates
Price on Enquiry

NPORS Cat & Genny Training

5.0(3)

By Vally Plant Training

NPORS Cat And Genny Training or Cable Avoidance Training Prioritising the safety of underground utilities in construction and excavation projects is essential, necessitating comprehensive Cat and Genny training. In these sessions, workers receive education on operating Cable Avoidance Tools (CAT) and Signal Generators (Genny), Cat and Genny. The Cat and Genny use electromagnetic signals to detect buried cables and pipes before digging commences. Through comprehensive Cat and Genny training, workers become proficient in using CAT and Genny equipment, enabling them to accurately map out the locations of underground infrastructure. This proactive approach not only enhances on-site safety but also contributes to efficient project management by minimising the risk of accidental damage and costly delays. The aim of the NPORS Cat & Genny Training is to Provide training in Cable Avoidance and Service Location (Cat and Genny).The Cat and Genny Course is designed for any person working on the roads, setting out before a build, surveying and any others who may be excavating an area where pipes or cables may be buried underground. Price Match Promise Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Price Match Promise. When you choose us for your Cat and Genny Course, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Cat And Genny Course, we’ll match it—ensuring you receive top-quality training at the best possible rate. Your skills, our commitment—always at the best price. CAT & GENNY Training is designed for construction professionals and workers involved in excavation who need to operate Cable Avoidance Tools and Signal Generators. This training is ideal for individuals who have prior experience in excavation but require formal instruction on the safe and effective use of these specific tools to prevent accidental damage to underground services. Participants should have a basic understanding of excavation work, and if unsure of their eligibility for this advanced training, are encouraged to contact our training coordinators for more information. The CAT & GENNY training program is divided into two main sections: a theoretical module and a practical application module. The theory part covers the principles of operation, safety procedures, and risk assessment associated with underground utility detection. The practical module provides hands-on experience with both the Cable Avoidance Tool and Signal Generator, emphasising field techniques and problem-solving. Upon completion of the Cat And Genny course, participants will receive comprehensive revision materials to reinforce key concepts covered during the training. Introduction to CAT and Genny Training CAT and Genny , also referred to as CAT & Genny or CAT and Genny Training, are essential tools used in the construction and utility sectors to help locate and avoid underground cables and pipes during excavation works. CAT, which stands for Cable Avoidance Tool, is designed to detect signals naturally emitted by metallic services like electrical cables. Meanwhile, the Genny, short for Signal Generator, is used alongside the CAT to apply a signal to underground utilities that do not naturally emit detectable signals, such as telecoms or fibre . Understanding how to operate these tools is crucial for anyone involved in excavation. Proper use of CAT and Genny can prevent costly and dangerous errors, such as accidentally cutting through power lines or water pipes. The training not only focuses on how to use these devices effectively but also covers the best practices for scanning different types of terrain and interpreting the signals received. This ensures that workers can conduct their tasks safely and efficiently, minimising the risk of disruption and damage to underground services. What Is CAT and Genny Training? CAT and Genny Training provides comprehensive instruction on using Cable Avoidance Tools (CAT) and Signal Generators (Genny) to locate underground utilities safely. This training is critical to reduce the risk of accidentally striking underground assets during excavation, which can lead to severe safety hazards and financial losses. What Does Our CAT and Genny Training Course Cover? Our CAT and Genny Training Course covers: Basics of operating CAT and Genny equipment: Understanding the device controls, functions, and proper handling. Detection techniques: Learning how to detect different types of services, including electric, gas, and water. Practical applications: Hands-on training with both simulated and live environments to practice safe scanning and detection. Safety protocols: Emphasising safety procedures to prevent injuries and accidents. Legal compliance: Overview of health and safety regulations related to excavation work. Who Needs CAT and Genny Training? CAT and Genny Training is essential for anyone involved in excavation and groundworks. This includes utility workers, construction workers, civil engineers, site managers, and anyone else who may need to locate underground utilities as part of their job. The Cat And Genny Course is crucial for preventing damage to underground infrastructure like gas, water, telecoms and electrical lines, which can result in costly repairs and dangerous accidents. Do You Need to Be Trained to Use a CAT Scanner? Yes, training is highly recommended to use a CAT scanner effectively and safely. While not legally mandatory, proper training ensures that operators can accurately interpret the scanner’s signals and avoid potential hazards when working near underground utilities. Specialised Genny Tool Training Course Overview: The Genny Course is designed specifically to train users on the effective operation of the Genny tool, a crucial component of the CAT and Genny system used for detecting underground utilities. Key Learning Outcomes: → Understanding Genny Signals: Participants will learn how different signals can be applied and traced using the Genny, improving their ability to detect non-metallic utilities such as plastic water pipes. → Optimising Signal Strength: Training includes adjusting the Genny’s signal strength to suit various soil conditions and utility types, ensuring clearer and more accurate detections. Practical Applications: → Hands-on Practice: Extensive field practice sessions are included to give participants real-world experience in using the Genny effectively. →Troubleshooting Common Issues: Learners will be taught how to troubleshoot common operational issues to minimise downtime and enhance field productivity. Advanced Techniques: → Using Genny with CAT4: Instructions on how to integrate Genny use with the CAT4 detector for enhanced detection capabilities. → Interpreting and Mapping: Skills in interpreting the Genny’s output and using integrated mapping tools for accurate utility mapping. Safety Protocols: → Safe Operation Practices: Emphasis on safety measures to prevent accidents during the use of high-frequency signals. → Maintenance and Daily Checks: Training on regular maintenance routines and daily checks to keep the Genny in optimal working condition. Certification: → Qualification and Certification: Upon completion of the course, participants receive a certification that validates their proficiency in using the Genny tool according to industry standards. Scanning Techniques with CAT and Genny General Scanning Techniques: → Sweeping Motion: Always use a slow, steady sweeping motion with the CAT device. Begin scanning at least a few meters away from the expected area of the utilities to avoid missing any signals. → Directional Scans: Perform scans in multiple directions — both parallel and perpendicular to the expected direction of the utility lines to ensure thorough coverage. → Depth Perception: Adjust the depth settings based on preliminary scans to get an accurate depth estimate of buried utilities. Specific Use of Genny: → Direct Connection: When available, use the direct connection method with the Genny to induce a precise signal into a specific utility line. This is particularly useful in crowded areas with multiple utility lines. → Induction Mode: Use the Genny’s induction mode when direct connections are not possible. Ensure the Genny is placed on the ground vertically for optimal signal transmission. How to Use the CAT and Genny to Find Hidden Wires and Pipes Getting Ready: Check the Tools: Make sure the CAT and Genny are ready to use and have full batteries. Set Up the Genny: Pick the right sound for the Genny to use so it can find wires or pipes under the ground. If you can, connect the Genny to the pipe or wire with a special wire. Using the Genny: Stand it on the Ground: Put the Genny on the ground where you think there might be something hidden. Turn it on to send a beep into the ground. Connect it for Better Finding: Sometimes, you connect the Genny to something like a pipe for a clearer beep. Using the CAT: Start with Power Mode: Turn on the CAT and use the power mode to find beeps from wires that are on. Try Radio Mode: Next, switch to radio mode to hear beeps from metal things like pipes. Finally, Use Genny Signal Mode: Use this mode to hear the special beeps from your Genny to find hidden stuff like plastic pipes. How to Look Properly: Move Slowly: Walk slowly with the CAT over the area. If you move too fast, you might miss some beeps. Check in a Cross Pattern: First walk in one direction and then the other direction to make sure you cover all the area. Understanding What You Hear: Listen to the Beeps: A loud beep means you are close to a wire or pipe. If the beep sounds the same as you move, it probably means you found a wire or pipe. Staying Safe: Look Before You Dig: Always check by looking in the hole to make sure what the CAT and Genny found before you start digging. Keep the Tools Working Well: Make sure your tools are working right by checking them often. 500 mm from utilities; Always use insulated digging tools when close to underground utilities Frequently Asked Questions On Cat & Genny Training What is CAT and Genny training? CAT and Genny training provides instruction on how to use Cable Avoidance Tools (CAT) and Signal Generators (Genny) effectively to detect underground utilities and avoid accidental strikes during excavation. The training covers operational techniques, safety procedures, and the correct interpretation of the equipment’s signals. Why is CAT and Genny training important for construction workers? This Cat And Genny Course is crucial for safety and efficiency on construction sites. It helps workers avoid costly damages to underground utilities such as water pipes, electricity cables, and communication lines, which can lead to severe consequences including service outages, legal liabilities, and endangerment of worker and public safety. 3. How Long Is the Certification Valid? The certification received after completing CAT and Genny Training is generally valid for three to five years. After this period, a refresher course is recommended to keep up with new technologies and changing safety regulations. 4. Is CAT and Genny training required by law in the UK? While not specifically mandated by law, CAT and Genny training is strongly recommended under the UK Health and Safety Executive guidelines (HSE) to meet the legal duties under the Health and Safety at Work Act. It is considered best practice for anyone involved in excavation works. Cat & Genny Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of cable avoidance and the construction industry We have our own training centre conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical training area to simulate an actual working environment for the cat & genny course. Our Cable Avoidance training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS cat & genny Tester to your site nationwide, to reduce the amount of time away from work Our more courses: Polish your abilities with our dedicated Lift Supervision Training, Slinger Signaller Training, Telehandler Training, Cat & Genny Training, Plant Loader Securer, Ride-On Road Roller, Abrasive Wheel Training, Lorry Loader Training and Scissor Lift Training sessions. Learn the safe and effective operation of these vital machines, crucial for construction and maintenance tasks. Elevate your skills and career prospects by enrolling in our comprehensive courses today.

NPORS Cat & Genny Training
Delivered In-Person in Tewkesbury or UK WideFlexible Dates
Price on Enquiry

Online Options

Show all 3033

PRP - Collagen Induction Therapy Course (GPT701)

4.6(39)

By Geopace Training

Platelet-rich Plasma (PRP) treatments Nationally Recognised Qualification No previous experience or qualifications needed Open College Network Accreditation Level 4 (as required for minimally invasive procedures) Covers standards set by HEE Employed (salon) or Self-Employed opportunities Basic understanding of English language required OPEN TO ALL APPLICANTS

PRP - Collagen Induction Therapy Course (GPT701)
Delivered in Slough + 5 more or Online + more
£295

SQL Intermediate Course, 3 Days

4.6(12)

By PCWorkshops

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

SQL Intermediate Course, 3 Days
Delivered Online + more
£600

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

4.3(5)

By Bayfield Training

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)
Delivered in person or Online + more
£1,750

Real Estate Financial Modelling School

4.3(5)

By Bayfield Training

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Real Estate Financial Modelling School
Delivered in person or Online + more
£4,600

DP-080T00 Querying Data with Microsoft Transact-SQL

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.

DP-080T00 Querying Data with Microsoft Transact-SQL
Delivered Online
£1,190

Introduction to DAX for Power BI

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY

Introduction to DAX for Power BI
Delivered Online
£900

PL-300T00 Microsoft Power BI Data Analyst

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Prerequisites Understanding core data concepts. Knowledge of working with relational data in the cloud. Knowledge of working with non-relational data in the cloud. Knowledge of data analysis and visualization concepts. DP-900T00 Microsoft Azure Data Fundamentals is recommended 1 - Discover data analysis Overview of data analysis Roles in data Tasks of a data analyst 2 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 3 - Get data in Power BI Get data from files Get data from relational data sources Create dynamic reports with parameters Get data from a NoSQL database Get data from online services Select a storage mode Get data from Azure Analysis Services Fix performance issues Resolve data import errors 4 - Clean, transform, and load data in Power BI Shape the initial data Simplify the data structure Evaluate and change column data types Combine multiple tables into a single table Profile data in Power BI Use Advanced Editor to modify M code 5 - Design a semantic model in Power BI Work with tables Create a date table Work with dimensions Define data granularity Work with relationships and cardinality Resolve modeling challenges 6 - Add measures to Power BI Desktop models Create simple measures Create compound measures Create quick measures Compare calculated columns with measures 7 - Add calculated tables and columns to Power BI Desktop models Create calculated columns Learn about row context Choose a technique to add a column 8 - Use DAX time intelligence functions in Power BI Desktop models Use DAX time intelligence functions Additional time intelligence calculations 9 - Optimize a model for performance in Power BI Review performance of measures, relationships, and visuals Use variables to improve performance and troubleshooting Reduce cardinality Optimize DirectQuery models with table level storage Create and manage aggregations 10 - Design Power BI reports Design the analytical report layout Design visually appealing reports Report objects Select report visuals Select report visuals to suit the report layout Format and configure visualizations Work with key performance indicators 11 - Configure Power BI report filters Apply filters to the report structure Apply filters with slicers Design reports with advanced filtering techniques Consumption-time filtering Select report filter techniques Case study - Configure report filters based on feedback 12 - Enhance Power BI report designs for the user experience Design reports to show details Design reports to highlight values Design reports that behave like apps Work with bookmarks Design reports for navigation Work with visual headers Design reports with built-in assistance Tune report performance Optimize reports for mobile use 13 - Perform analytics in Power BI Explore statistical summary Identify outliers with Power BI visuals Group and bin data for analysis Apply clustering techniques Conduct time series analysis Use the Analyze feature Create what-if parameters Use specialized visuals 14 - Create and manage workspaces in Power BI Distribute a report or dashboard Monitor usage and performance Recommend a development life cycle strategy Troubleshoot data by viewing its lineage Configure data protection 15 - Manage semantic models in Power BI Use a Power BI gateway to connect to on-premises data sources Configure a semantic model scheduled refresh Configure incremental refresh settings Manage and promote semantic models Troubleshoot service connectivity Boost performance with query caching (Premium) 16 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 17 - Implement row-level security Configure row-level security with the static method Configure row-level security with the dynamic method Additional course details: Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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.

PL-300T00 Microsoft Power BI Data Analyst
Delivered Online + more
£1,785

CertNexus Certified Cyber Secure Coder (CSC-210)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is designed for software developers, testers, and architects who design and develop software in various programming languages and platforms, including desktop, web, cloud, and mobile, and who want to improve their ability to deliver software that is of high quality, particularly regarding security and privacy. This course is also designed for students who are seeking the CertNexus Cyber Secure Coder (CSC) Exam CSC-210 certification Overview In this course, you will employ best practices in software development to develop secure software.You will: Identify the need for security in your software projects. Eliminate vulnerabilities within software. Use a Security by Design approach to design a secure architecture for your software. Implement common protections to protect users and data. Apply various testing methods to find and correct security defects in your software. Maintain deployed software to ensure ongoing security... The stakes for software security are very high, and yet many development teams deal with software security only after the code has been developed and the software is being prepared for delivery. As with any aspect of software quality, to ensure successful implementation, security and privacy issues should be managed throughout the entire software development lifecycle. This course presents an approach for dealing with security and privacy throughout the entire software development lifecycle. You will learn about vulnerabilities that undermine security, and how to identify and remediate them in your own projects. You will learn general strategies for dealing with security defects and misconfiguration, how to design software to deal with the human element in security, and how to incorporate security into all phases of development. Identifying the Need for Security in Your Software Projects Identify Security Requirements and Expectations Identify Factors That Undermine Software Security Find Vulnerabilities in Your Software Gather Intelligence on Vulnerabilities and Exploits Handling Vulnerabilities Handle Vulnerabilities Due to Software Defects and Misconfiguration Handle Vulnerabilities Due to Human Factors Handle Vulnerabilities Due to Process Shortcomings Designing for Security Apply General Principles for Secure Design Design Software to Counter Specific Threats Developing Secure Code Follow Best Practices for Secure Coding Prevent Platform Vulnerabilities Prevent Privacy Vulnerabilities Implementing Common Protections Limit Access Using Login and User Roles Protect Data in Transit and At Rest Implement Error Handling and Logging Protect Sensitive Data and Functions Protect Database Access Testing Software Security Perform Security Testing Analyze Code to find Security Problems Use Automated Testing Tools to Find Security Problems Maintaining Security in Deployed Software Monitor and Log Applications to Support Security Maintain Security after Deployment

CertNexus Certified Cyber Secure Coder (CSC-210)
Delivered Online
£2,085

55133 PowerShell for System Center Configuration Manager Administrators

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is intended for IT professionals who need to manage the day-to-day environment of an SCCM 2012 SP1 or newer environment. Knowledge of the workings of a standalone primary SCCM site and basic PowerShell experience is recommended. Overview Create additional site system roles on existing or new servers. Modify high level site settings. Create and modify Discovery Methods, Boundaries and Boundary Groups. Create Collections using any of the membership rules available. Delegate authority through Roles and Scopes. Install the Configuration Manager client, modify client settings and restrict access to site systems. Deploy software to clients. Deploy software updates to clients. Configure compliance settings targeted against collections. Modify settings that govern monitoring functions such as Alerts and Status Settings. Work with Task Sequences for Operating System Deployment. Write basic PowerShell scripts using cmdlets learned and scripting constructs to accomplish configuration tasks. This course provides students with the knowledge and skills needed to use PowerShell for System Center Configuration Manager (SCCM) administration. In this course, students learn how to access the PowerShell cmdlets included with SCCM 2012 R2 and use them to perform configuration tasks for a primary site. Individual cmdlets will be used in working with objects such as Boundaries, Boundary Groups, Collections, Software Deployment, Patching, Compliance Settings, OSD Task Sequences, and many others. Basic scripting will also be covered so that students can learn how to put PowerShell to use when working with large sets of objects. Prerequisites Basic Windows and Active Directory knowledge. Conceptual knowledge of Configuration Manager objects and how they interact. Basic experience performing configuration tasks in ECM using the graphical console. Experience working from a command prompt. Basic knowledge of the fundamentals of Windows PowerShell. 1 - REVIEW OF SYSTEM CENTER CONFIGURATION MANAGER CONCEPTS Architecture of an System Center 2012 Configuration Manager Installation Managing Assets Content Delivery and Management Security, Monitoring, and Remote Management 2 - MANAGING RESOURCES Implementing Discovery Organizing Resources with Collections Working with Boundaries 3 - WORKING WITH CLIENTS Installing the Configuration Manager Client Managing Client Settings Managing Client Operations Monitoring Client Status 4 - DISTRIBUTING SOFTWARE Configure the Software Distribution Components Working with Distribution Points Creating Content for Distribution Deploying Software Applications 5 - UPDATING SYSTEMS WITH WSUS AND SCCM Integrating Configuration Manager and WSUS Managing Updates through Software Update Groups Creating and Deploying Update Packages Working with Automatic Deployment Rules 6 - HOW POWERSHELL CAN MANAGE COMPLIANCE SETTINGS Creating Compliance Settings Objects Deploying and Monitor the Baseline 7 - CONFIGURING OPERATING SYSTEM DEPLOYMENT OBJECTS Preparing the OSD Environment Working with Task Sequences 8 - WORKING AT THE SITE LEVEL Modify the Site Adding Site System Roles Adding a Secondary Site 9 - SECURITY AND MONITORING Configuring Role Based Administration Implementing Endpoint Protection Configuring Monitoring Options 10 - USING POWERSHELL SCRIPTING TO AUTOMATE SCCM TASKS Review of Scripting Constructs Introduction to the Configuration Manager WMI Classes

55133 PowerShell for System Center Configuration Manager Administrators
Delivered Online
£1,785

Python EVENINGS Course, Online Instructor-led

4.6(12)

By PCWorkshops

Basic Python syntax and principles of Object Orientated Programming. Most attendees are in-work IT Professional. Private individuals are also very welcome. Evening courses also running. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 6 weeks, 1 evening per week, 6pm - 8pm Times: arrange a time for your time zone

Python EVENINGS Course, Online Instructor-led
Delivered Online
£100

Educators matching "Functions"

Show all 8
defibshop

defibshop

Manchester

Defibshop was born in 2005. At this point people really did not know what a defibrillator was, despite it being common place in countries like America. If it was going to happen here in the UK we’d need to educate people about what an AED was, when they should be used, how important they were in the event of a sudden cardiac arrest, the impact of using one to the casualty and how easy they are to use whether you are trained or not. For many years it has been an uphill struggle to educate people about defibrillators. Common objections include “Is it law to have one?” and “we’ve never needed one so far so why should I buy one?”, but, after years of education in the importance of early CPR and defibrillation in the event of sudden cardiac arrest (SCA), some changes in legislation, high profile incidents and saves by defibs such as Fabrice Muamba in 2012 and Christian Erikson in 2021, as well as the introduction of defibrillator training within workplace first aid courses, these units are now a natural extension of first aid provision. Today we have a highly knowledgeable team working to ensure the correct defibrillator is placed in the correct environment. All defibs deliver a shock of course, but it is important to take the environment into account as models vary and offer different functions. We have also been working with the British Heart Foundation to promote The Circuit, the UK’s national defibrillator network that is linked directly to the 999 ambulance response service and enables the operator to send a caller to the nearest available registered defibrillator, so potentially saving valuable minutes and saving more lives. Please register your unit if you have not done so already. We continue to put pressure on the Government to pass the proposed Automated External Defibrillator Public Access Bill to legislate defibrillators that are accessible to all in public places. Without this, people are going to continue to die from sudden cardiac arrest because there wasn’t a unit close enough to hand. That could happen to any one of us. After you've purchased your life-saving AED, our commitment doesn't end there. As part of our FREE pad and battery reminder service, we will contact you when your consumables are due to expire, so you have plenty of time to replace them and ensure your device is always ready for use.

Wills & Wills Mentoring

wills & wills mentoring

Wilmslow

BOSTON – MENTOR, the unifying champion of the mentoring movement, announces the expansion of its leadership team with the addition of Tim Wills who joins as the organization’s first Chief Impact Officer on March 7. Tim will drive strategy, coordination, integration, and effectiveness of MENTOR’s teams focused in the areas of training and technical assistance; product design, development and ongoing usage; field research and evaluation; strategic partnerships and systems innovation; and Affiliate partnership, support, effectiveness, sustainability, and expansion. MENTOR CEO David Shapiro says, “We are so fortunate Tim is bringing his decades of experience as an advocate for youth, an innovator, a communicator, and local leader in one of the nation’s oldest and most expansive youth development organizations to our team and the mentoring movement. His personal and professional journey, commitment to supporting others’ development, community building talent, and deep commitment to young people will be such key drivers in our expanded and dynamic efforts to ensure all young people have the relationships they need to strive and thrive.” A native of Ferguson, Mo., Tim holds a bachelor’s degree in broadcast journalism from Southern Illinois University Carbondale. As a college student, he developed his passion for youth by covering human interest stories as on-air talent for his college television and radio stations which led to a 17-year career in youth development, including at the Boys & Girls Clubs in Chicago, the District of Columbia, and Harford County, Md. In 2016, because of his extensive experience in organizational transformation and increasing club membership, quality improvement, innovative programming and funding, Tim was named the CEO of Boys & Girls Clubs of South Alabama. In this role over the last six years, Tim led twelve year-round sites, three summer only programs, a 150-acre campground, and POINTE Academy, a school for detained and adjudicated youth. He’s received several honors and awards, including Boys & Girls Clubs Professional of the Year for his leadership, Mobile Bay 40 Under 40, and Benjamin Mays Excellence in Mentoring Award. Tim is an active member of the Lion’s Club and a member of the board of directors for Voices for Alabama’s Children and Linking All So Others Succeed (LASOS) in Maryland. He’s completed executive-level training in leadership, non-profit management, and advanced philanthropy from Harvard Business School, Stanford University, and Boys & Girls Clubs of America. For 12 years, Tim has been a single foster parent and has fostered 20 children. He also has spent significant time teaching in VolunTourism trips to Haiti. “I’m thrilled to join the MENTOR community to continue the work of elevating the voices of young people across our country,” said Tim. “This new role will further deepen our ability to impact systematic change in order to open doors of opportunity and to close the mentoring gap. I am excited to get started working with our team, board, and stakeholders to continue strengthening and expanding the mentoring movement.” The role of Chief Impact Officer provides a critical new link and integration between so many of MENTOR’s core functions, key stakeholders, valued partners, and Affiliate network which provides local delivery, leadership, and innovations in service to the youth mentoring field nationwide. It will drive expanded impact, efficiency, and responsive servant leadership. Currently, MENTOR operates in collaboration with 24 local Affiliates across the country that galvanize their regional or statewide mentoring movements and provide leadership and structure to support quality mentoring through training, advocacy, and public awareness. Operating under the framework of One MENTOR, MENTOR Affiliates share resources and strategies to strengthen the national mentoring movement. Sadiq Ali, Executive Director of MENTOR Maryland | DC and a member of the CIO interview committee added, “I am greatly excited about Tim joining our One MENTOR family in such a critical role and at such a critical time. His perspective, having been on the frontlines of both local and national youth serving work, will be invaluable as he helps lead us into our next chapter as an Affiliate network, champions for young people, systems change advocates, and a sustainable, impactful organization.” ABOUT MENTOR MENTOR is the unifying champion for expanding the quality and quantity of mentoring relationships across the United States. 30 years ago, MENTOR was created to expand opportunities for young people by building a youth mentoring field and movement. The result: a more than 10-fold increase in young people in structured mentoring relationships. Today, MENTOR is the expert voice representing a movement that meets young people everywhere they are – from schools, to workplaces, and beyond. MENTOR operates in collaboration with 24 local Affiliates across the country. For more information, visit mentoring.org.