31867 Courses

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

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who use PowerPoint for their business communication needs. Overview To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. This course is intended for those who wish to take advantage of the application for high quality business presentations and reports. Presentations Create Attractive Presentations from Existing PowerPoint Templates Creating Presentations Quickly using Outline to build a Structure Incorporating and reusing slides from other presentations into your own Templates and Customization Using Slide Layouts Using the Slide Master Creating Custom Slide Layout Working with Charts and Tables Create and Modify Tables Create Charts and Graphs Copying Charts into PowerPoint Link Vs Embed Add Visual Elements to a Presentation Create and Modify Shapes Add Images Create SmartArt to Make Easily Modifiable graphics Use SmartArt to Give Dull Text a More Visual Appeal Working with Media and Animation Add Audio to A Presentation Add Video to A Presentation Add and Customize Animations Add and Customize Transitions Preparing to Present Add Notes to A Presentation Presenter View And Slide Show Controls Create A Custom Slide Show Saving and Sharing the Presentation Printing Options and Handouts Additional course details: Nexus Humans Microsoft PowerPoint for the Business User 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 Microsoft PowerPoint for the Business User 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.

Course Introduction Our Venepuncture and Phlebotomy training equips delegates with the skills and knowledge needed to take blood safely. Please note: this course is for health care professionals and nurses only. About this event Applicable to Nurses, Health Care Assistants and Phlebotomists in primary care, the community, hospitals or nursing homes, this course is interactive and involves a demonstration session on performing blood tests. Our venepuncture training will give delegates the theoretical and practical awareness to undertake a competence assessment framework in the workplace that will deem them competent to take blood safely and appropriately. Each delegate will receive a competence-based framework to allow them to do this. Course Aims Identify and describe equipment used for routine venepuncture Be able to assess and select suitable sites used for venepuncture as well as locations to avoid Describe and utilize the required steps to perform routine venepuncture Describe actions that ensure safety during performance of a venepuncture Identify suitable vein selection and identify factors influencing this Understand relevant professional and legal issues Be able to identify potential complications Understand anatomy and physiology and correct vein selection Be familiar with equipment and exercise choice in using most appropriate equipment Practice safely in terms of infection control and waste management Become skilled and competent at phlebotomy To recognise any complications arising and be able to take the appropriate action Course Content Background and importance of training and competence Supervision and practice Scope and responsibilities Accountability Professional and legal issues Consent and capacity What is phlebotomy? Tools of the trade-equipment Needles and patient safety Blood collection systems and devices Syringes and when to use them Blood collection tubes Labelling Anatomy and physiology Vein Selection: - Identification of Veins - Arm Veins - Hand Veins Vein assessment Unacceptable sites for venous collection Venepuncture procedure Attempts Order of Fill Specimen collection procedures Specimen handling post-phlebotomy Personal protective equipment Needle stick injuries Legislation-EU Directives Disposal Needle phobias Dealing with anxiety/fainting etc. Practical session Potential Complications (including infection control) Practical Application - techniques and troubleshooting Case scenarios Troubleshooting Audit Who should attend / would be applicable? Nurses HCAs Those interested in careers as Phlebotomists AB Health Group awards CPD points / certificate of attendance for each course. If you would prefer an accredited certificate by our accrediting body Aim Qualifications we can organise this. The charge for the certificate including postage is £30.00. Annie Barr AB Health Group Organiser Description Annie Barr is a leading provider of high quality, accredited healthcare training. With a selection of engaging healthcare training that has been developed by experts to equip you and your workforce with the skills, knowledge and competence needed to provide compassionate and high quality care.

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

City & Guilds 18th edition course with 2382-22 final exam only £234.00. Exams available every week across the UK, same day results, quick certificate, best prices..

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is any IT, facilities or data centre professional who works in and around the data centre and has the responsibility to achieve and improve efficiency and environmental sustainability, whilst maintaining the availability and manageability of the data centre. Overview After completion of the course the participant will be able to: Understand the impact of data centres on the environment Describe the various environmental/energy management standards Understand the purpose and goals of the legally binding international treaties on climate change Implement various sustainable performance metrics and how to use them in the data centre environment Manage data centre environmental sustainability using international standards Set up the measurement, monitoring and reporting of energy usage Use power efficiency indicators in a variety of data centre designs Use best practices for energy savings in the electrical infrastructure and in the mechanical (cooling) infrastructure Use best practices for energy savings for the ICT equipment and data storage Understand the importance of water management and waste management Understand the different ways to use sustainable energy in the data centre Get practical tips and innovative ideas to make a data centre more sustainable The CDESS© course is aimed at providing knowledge of the standards and guidelines related to environmental sustainability, and how to move your data centre (existing or new) to a more environmentally sustainable design and operations. Impact of Data Centres on the Environment Predictions in 2010 Current situation Outlook and commitments What is Environmental Sustainability The importance of sustainability Senior management commitment Environmental sustainability framework Sustainability policies Performance standards and metrics Information policies Transparency Awareness Service charging models Environmental Management Environmental sustainability framework (ISO 14001) Standards and guidelines ? ISO 50001 / ISO 30134 Measurement and categories Baselining Trend analysis Reporting Power Effiðciency Indicators Various eðfficiency indicators Power Usage Effectiveness (PUE) PUE measurement levels Factors affecting PUE Measurement points and intervals PUE in mixed source environments Measuring PUE in a mixed-use building PUE reporting Impact of PUE after optimising IT load Electrical Energy Savings (Electrical) Identifying the starting point for saving energy Sizing of power DC power Generators UPS systems Power Factor (PF) Energy savings on lighting Electrical Energy Savings (Mechanical) Energy savings on the cooling infrastructure Temperature and humidity setpoints Various energy eðcient cooling technologies Energy savings on the airflow Liquid cooling Energy reusage PUE, ERE/ERF and Control Volume Electrical Energy Savings (ICT) Procurement IT equipment energy eðfficiency ITEEsv, SMPE, SMPO IT equipment utilisation Server virtualisation Open compute project Electrical Energy Savings (Data Storage) Data management Data storage management Data storage equipment effiðciency Water Management Water Usage Effectiveness (WUE) Improving WUE Water usage at the power generation source Energy Water Intensity Factor (EWIF) Waste Management Waste management policies Life-cycle assessment (Cradle to the grave) 3 R?s for waste management Reduce Reuse Second-hand market Recycle Sustainable Energy Usage Sustainable energy sources Power purchase agreements Energy attribute certificates Renewable Energy Factor (REF) Matching renewable energy supply and demand Sustainable energy storage Carbon trading Automated Environmental Management Systems Use of AI and machine learning Load migration Data Centre Infrastructure Management (DCIM) solutions

THIS COURSE PACKAGE INCLUDES: 1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5) 2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6) 3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom) Learn how to take blood ... train as a Phlebotomist FAST-TRACK YOUR PHLEBOTOMY TRAINING WITH OUR COMPLETE TRAINING PACKAGE 20% off - Multi-Course Discount Cover all stages from beginner through to Level 4 Available as Classroom or Virtual Classroom Complete your beginner to advanced training in 2 days Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications Both courses are dually accredited (OCN & CPD) Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom Covers all steps up to live blood draw Learn advanced skills and techniques Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep) Basic understanding of English language required OPEN TO ALL APPLICANTS