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

35574 Courses in Cardiff delivered Online

Safety Audits

By St. Paul's College

This course delves into the theoretical underpinnings of safety audit practices, from meticulous planning to advanced risk assessment and continuous improvement strategies.

Safety Audits
Delivered Online On Demand2 hours
£11.99

NFT for Beginners - CPD Accredited

By Imperial Academy

CPD Accredited | Free PDF Certificate | 20 CPD Points | Lifetime Access | Tutor Support

NFT for Beginners - CPD Accredited
Delivered Online On Demand
£15

CNS-420 Citrix (NetScaler) Networking Assessment, Design, and Advanced Configuration

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Built for IT Professionals with extensive networking and Citrix ADC experience. This course is built for IT Professionals who are responsible for defining the overall structure or architecture of a Citrix networking environment. This course encompasses advanced Citrix networking configurations and leading Citrix design principles. Overview How to identify and prioritize business drivers, constraints, and requirements using the Citrix Consulting methodology Assess environment requirements and learn to apply leading design principles to address them in a multi-site Citrix ADC deployment Apply advanced authentication and load balancing principles In this expert level 5-day training course you will be exposed to advanced networking and Citrix ADC concepts and configurations. Through lecture, lab exercises, and real-world case studies, you will learn to look critically at environment requirements, constraints, and business drivers to create a complex Citrix networking solution. Topics to be covered in this course include multi-site and multitenant deployments, advanced authentication and load balancing, and automation and orchestration and advanced troubleshooting. This training will also prepare you for the Citrix Certified Expert in Networking (CCE-N) exam. Module 1: Networking Methodology and Assessment Understanding the Citrix methodology Business Drivers and Requirementrs User Segmentation Application Assessment Capabilities Assessment Module 2: Citrix Networking Deployment Architecture and Topology Multi-Site Deployments Multi Tennant Infrastructure Cloud Deployments High Availability Citrix ADC Double-Hop Scenarios Secure Web Gateway Module 3: Advanced Authentication and Authorization Authorization Policies Access Policies Advanced Authentication Options Multi-Factor Authentication nFactor Authentication AAA Session Management Module 4: Citrix ADC Security Authorization Pre-authentication and Endpoint Analysis Scans Protection against Layer 4-7 Attacks Web App Firewall Module 5: Citrix Gateway Configuration Considerations ICA Proxy Configuration VPN Access Clientless Access Split Tunneling RDP Proxy Deployment and Configuration Module 6: Advanced Load Distribution and Link Load balancing Advanced Load Balancing Advanced Load Balancing Link Load Balancing Firewall Load Balancing Microsoft Exchange Load Balancing Advanced Global Server Load Balancing Global Server Load Balancing Persistence DNS, Policies, Expressions, Actions, and Views GSLB Monitoring and Considerations Module 7: Application Delivery Management Automation and Orchestration Application Delivery Management Outbound Traffic Dashboard Automation Orchestration Configuration Jobs Configuration Audit NITRO API StyleBooks (Net-new)

CNS-420 Citrix (NetScaler) Networking Assessment, Design, and Advanced Configuration
Delivered OnlineFlexible Dates
Price on Enquiry

Cisco SD-WAN Security and Cloud Onboarding v1.0 (SDWSCS)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is designed for the following roles: Network engineers Network security engineers Network architects Sales/presales engineers Overview After taking this course, you should be able to: Describe Cisco SD-WAN security functions and deployment options Understand how to deploy on-premises threat prevention Describe content filtering options Implement secure Direct Internet Access (DIA) Explain and implement service chaining Explore Secure Access Service Edge (SASE) and identify use cases Describe Cisco Umbrella Secure Internet Gateway (SIG) and deployment options Implement Cisco Umbrella SIG and Domain Name System (DNS) policies Explore and implement Cloud Access Security Broker (CASB) and identify use cases (including Microsoft 365) Describe how to use Cisco ThousandEyes to monitor cloud services Configure Cisco ThousandEyes to monitor Microsoft 365 applications Examine how to protect and optimize access to the Software as a Service (SaaS) application with Cisco SD-WAN Cloud OnRamp Describe and deploy Cloud OnRamp for multi-cloud, including interconnect and colocation use cases Examine Cisco SD-WAN monitoring capabilities and features with vManage and vAnalytics The Implementing Cisco SD-WAN Security and Cloud Solutions (SDWSCS) v1.0 course is an advanced training course focused on Cisco SD-WAN security and cloud services. Through a series of labs and lectures you will learn about on-box security services, including application-aware enterprise firewall, intrusion prevention, URL filtering, malware protection, and Transport Layer Security (TLS) or Secure Socket Layer (SSL) decryption. You will also learn about cloud integration with multiple cloud service providers across multiple use cases. Additionally, the course labs will allow you to configure and deploy local security services and cloud security services with the Cisco Umbrella Secure Internet Gateway (SIG), as well as integrate the Cisco SD-WAN fabric with a cloud service provider using the Cisco vManage automated workflows. The course lab environment is built using Cisco Catalyst 8000v IOS XE routers and Cisco SD-WAN 20.7 code, and it includes the integration of Cisco FirePOWER Threat Defense for network security and Cisco ThousandEyes for network monitoring. The course will allow you to earn 24 Continuing Education (CE) credits toward recertification. Course Outline Introducing Cisco SD-WAN Security Deploying On-Premises Threat Prevention Examining Content Filtering Exploring Cisco SD-WAN Dedicated Security Options Examining Cisco SASE Exploring Cisco Umbrella SIG Securing Cloud Applications with Cisco Umbrella SIG Exploring Cisco SD-Wan ThousandEyes Optimizing SaaS Applications Connecting Cisco SD-WAN to Public Cloud Examining Cloud Interconnect Solutions Exploring Cisco Cloud OnRamp for Colocation Monitoring Cisco SD-WAN Cloud and Security Solutions Additional course details: Nexus Humans Cisco SD-WAN Security and Cloud Onboarding v1.0 (SDWSCS) 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 Cisco SD-WAN Security and Cloud Onboarding v1.0 (SDWSCS) 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.

Cisco SD-WAN Security and Cloud Onboarding v1.0 (SDWSCS)
Delivered OnlineFlexible Dates
Price on Enquiry

CCIE Enterprise Infrastructure

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for For those seeing to prepare for CCIE Enterprise Infrastructure certification Overview This course will help prepare for CCIE Enterprise Infrastructure certification The new CCIE Enterprise Infrastructure certification program prepares you for today?s expert-level job roles in enterprise infrastructure technologies. CCIE Enterprise Infrastructure now includes automation and programmability to help you scale your enterprise infrastructure. VTP VTP and different versions Pruning EtherChannel LACP Layer 2 and Layer 3 Spanning Protocol 1d, 802.1w, and 802.1s SPAN, RSPAN, and ERSPAN DMVPN All Phases Redundancy: Two Clouds One Hub Two Hubs one Cloud Two hubs two Clouds Running Routing Protocols DMVPN over MPLS EIGRP RD, CD, S, FC, FS, and FD Configuration, and hidden debugging Authentications: MD5, and SHA, Summarization Load Balancing:Equal Cost, Unequal Cost, Add-Path, Filtering, Default Route Injection Optimization: Query Propagation Boundary, IP FRR, STUB routing (All Options) Metric: Classic, Wide Metric Route Tags: Decimal and Dotted-Decimal Notations, OTP OSPFv2 Overview and special cases GRE or Virtual-Links LSAs, FA, and RFCs (1583, 1587, 2328, 3101, 5185 and many more) Best Path Selection Network Types Area Types Optimization: GTSM, LFA, Default Route Injection Authentication: RFC 2328, RFC 5709, Summarization, Filtering BGP States Establishing a Peer Session: Regular method,Peer-Groups,Templates,Best Path Selection Attributes: Weight, AS-Path, Origin, Next-Hop, Local-Preference, Atomic-Aggregate Communities, Aggregator, and MED Load Balancing: Equal Cost,Unequal Cost,Conditional Advertisement,Out/In Bound Route Filtering and the order,ORF,Multihoming Scenarios AS-Path Manipulation: Regexp,Local-as,Allow-as,Remove-Private-as Convergence and Scalability: Route Reflectors,Confederation,Aggregation (All Options) Other BGP Features: MultiPath,Add-Path,Route-Refresh,Soft Reconfiguration IPv6 Acquiring an IPv6 Address: IPv6 General Prefix SLAAC DHCPv6 Rapid-Commit Relay Prefix Delegation IPv6 and DMVPN EIGRPv6 OSPFv3: Both flavors, LSAs, RFCs BGP for IPv6: IPv6 transport, and IPv4 route exchange Transitional Solutions: NAT-PT,6VPE,Multicast,MLD,Static RP,BSR,Embedded RP,IPv6 Traffic Filters,RA Guard,ND Inspection MPLS LDP, VRFs, RD, and RT L3VPNs Route Leaking PE to CE Routing Security Control Plane Policing VACLs Storm Control DHCP Snooping IP Source Guard DAI Private VLANs Port Security Access-lists uRPF Device Tracking IPsec Identity Use Case For FlexVPN: Site-to-Site, IKEv1, and IKEv2 Using Preshared Keys 1x Port Base Authentication : Device Roles,Port States,Authentication Process,Host Modes Network Services FHRP: HSRP, VRRP, and GLBP NAT: Static NAT, and PAT,Dynamic NAT,Policy-Base NAT,VRF-Aware NAT,VASI NAT Software Defined Infrastructure Cisco SD Access: Design a Cisco SD Access solution Underlay network (IS-IS, manual/PnP) Overlay fabric design (LISP, VXLAN, Cisco TrustSec) Fabric domains (single-site and multi-site using SD-WAN transit) Cisco SD Access deployment: Cisco DNA Center device discovery and device management Add fabric node devices to an existing fabric Host onboarding (wired endpoints only) Fabric border handoff Segmentation Macro-level segmentation using VNs Micro-level segmentation using SGTs (using Cisco ISE) Assurance Network and client health (360) Monitoring and troubleshooting Cisco SD-WAN: Design a Cisco SD-WAN solution Orchestration plane (vBond, NAT) Management Plane (vManage) Control Plane (vSmart, OMP) Data Plane (vEdge/cEdge) WAN edge deployment Onboarding new edge routers Orchestration with zero-touch provisioning/PnP OMP TLOC Configuration templates Localized policies (only QoS) Centralized policies Application aware Routing Topologies

CCIE Enterprise Infrastructure
Delivered OnlineFlexible Dates
Price on Enquiry

Advanced Piping & Instrumentation Diagrams P&IDs

5.0(1)

By Course Gate

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Advanced Piping & Instrumentation Diagrams P&IDs will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Advanced Piping & Instrumentation Diagrams P&IDs will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Advanced Piping & Instrumentation Diagrams P&IDs and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Advanced Piping & Instrumentation Diagrams P&IDs is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Advanced Piping & Instrumentation Diagrams P&IDs. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Advanced Piping & Instrumentation Diagrams P&IDs will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Introduction Introduction 00:04:00 About P&id's What's a P&ID ? 00:03:00 Why is a P&ID so important ? 00:02:00 Who uses P&ID's ? 00:06:00 How do P&ID's look like ? 00:08:00 Introduction to P&id Reading Introduction- PID READING 00:02:00 Anatomy of a P&ID 00:01:00 The title block 00:03:00 The drawing scale 00:03:00 The grid system 00:02:00 The revision block 00:03:00 Changes 00:02:00 Notes and legends 00:03:00 Basic P&id Symbols Valve symbols 00:14:00 Valve actuator symbols 00:09:00 Control valve designations 00:02:00 Standards and conventions for valve status 00:07:00 Process equipment symbols 00:12:00 Piping symbols 00:03:00 Pipe fitting symbols 00:03:00 Isolating, venting & draining symbols for ease of maintenance 00:05:00 Instrumentation 00:03:00 Sensing devices and detectors 00:04:00 Location symbols 00:04:00 Modifiers and transmitters 00:05:00 Indicators and recorders 00:03:00 Let's Get Some Practice : Basic P&id Symbols Example #1 : Identifying process equipment and flow paths 00:05:00 Example #2 : Identifying valve position and failure mode 00:03:00 Example #3 : Identifying the symbols 00:02:00 P&id Designation Codes Piping designation code 00:06:00 Equipment designation code 00:03:00 Instrument designation code 00:02:00 Miscellaneous designation codes 00:02:00 The Importance of Process Control The process 00:01:00 Process control 00:06:00 Control Theory Basics The control loop 00:02:00 Process control terms 00:10:00 Basic Process Control Systems (BPCS) Control loops : Feedback control 00:02:00 Pressure control loops 00:01:00 Flow control loops 00:01:00 Level control loops 00:01:00 Temperature control loops 00:01:00 Multi-variable loops 00:02:00 Feedforward control 00:02:00 Feedforward + Feedback 00:01:00 Cascade control 00:08:00 Split range control 00:03:00 Operations on control signals 00:02:00 Ratio control 00:02:00 Batch control 00:01:00 Selective control 00:01:00 Controllers 00:03:00 Advanced Process Control Do we need to control at all ? 00:01:00 Principles of equipment-wise control 00:10:00 Pipe control system 00:02:00 Control of a single pipe 00:02:00 Control of pressure in a pipe 00:03:00 Control of flow in a pipe 00:04:00 Flow merging 00:08:00 Flow splitting 00:05:00 Centrifugal pump control 00:04:00 Control valve vs Variable Frequency Drive (VFD) for centrifugal pumps 00:03:00 Minimum flow control for centrifugal pumps 00:09:00 Positive displacement pump control 00:02:00 Control by a recirculation pipe for PD pumps 00:03:00 Variable Speed Drive (VSD) control for PD pumps 00:01:00 Control by stroke adjustment for PD pumps 00:01:00 Compressor control system 00:02:00 Compressor capacity control 00:12:00 Compressor anti-surge control 00:03:00 Heat transfer equipment control 00:02:00 Heat exchanger direct control system 00:04:00 Heat exchanger bypass control system 00:04:00 Reactor temperature control 00:06:00 Air cooler control 00:02:00 Heat exchanger for heat recovery 00:01:00 Heat exchanger back pressure control 00:02:00 Basic fired heater control 00:08:00 Complex fired heater control 00:05:00 Container and vessel control 00:07:00 Container blanket gas control 00:02:00 Safety Instrumented Systems (SIS), Interlocks and Alarms Safety strategies 00:01:00 Concept of Safety Instrumented Systems (SIS) 00:01:00 SIS actions and types 00:14:00 SIS extent 00:02:00 SIS requirement 00:03:00 Anatomy of a SIS 00:02:00 SIS element symbols 00:01:00 SIS primary elements : Sensors 00:03:00 SIS final elements 00:04:00 Switching valve actuator arrangements 00:02:00 Valve position validation 00:02:00 Merging a switching valve and a control valve 00:03:00 SIS logics 00:01:00 Showing safety instrumented functions on P&ID's 00:07:00 Discrete control 00:05:00 Alarm system 00:02:00 Anatomy of alarm systems 00:02:00 Alarm requirements 00:06:00 Alarm system symbology in P&ID's 00:06:00 Concept of common alarms 00:01:00 Fire and Gas Detection Systems (FGS) 00:03:00 Electric motor control 00:07:00 P&ID representation of commands and responses 00:05:00 P&ID representation of inspection and repair 00:05:00 P&ID example of electro-motor control 00:04:00 P&id Examples : Let's Get Some Practice P&ID example #1 : Legend and specifications 00:05:00 P&ID example #2 : Hydrogen delivery station 00:16:00 P&ID example #3 : Acid system 00:13:00 P&ID example #4 : Centrifugal pump 00:09:00 P&ID example #5 : Utility station 00:04:00 P&ID example #6 : Waste water filter 00:08:00 P&ID example #7 : Steam separator 00:15:00 P&ID example #8 : Flare knock-out drum 00:14:00 P&ID example #9 : Centrifugal compressor 00:05:00 P&ID example #10 : Hydrogen production from shale gas 00:11:00 P&ID example #11 : Fired heater 00:07:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Advanced Piping & Instrumentation Diagrams P&IDs
Delivered Online On Demand8 hours 26 minutes
£11.99

Superfood Masterclass

4.7(160)

By Janets

Find out about the superfoods from each food group, and explore how you can add healthy foods to your diet to support a healthy lifestyle. Learn how to get the most out of your diet, and create a healthy eating plan that's delicious and easy to stick to. Avoid the confusion and conflicting information about fad diets, or the expense of pre-packaged diet foods, and learn how to use superfoods to create the perfect, personalised diet for you. Discover which superfoods you already eat and enjoy, and build your ideal meal plans! What You Will Learn on the Superfood Masterclass Course: Learn about the basics of a healthy diet and how to personalise your diet to suit your needs. Study superfood vegetables, fruits, and berries and learn how to include them in your diet. Look at superfood meat, poultry, fish, and seafood and discover the benefits of each. Discover the food you should be eating to achieve specific health goals. Find out which food gives you more energy and the right food to eat for muscle gains. Learn which superfoods will boost your metabolism. Gain an understanding of which superfoods are right for special diets such as high fat or high fibre diet. Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £69. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.

Superfood Masterclass
Delivered Online On Demand3 weeks
£25

Psychology Of Alcohol And Drug Addiction

4.7(160)

By Janets

Explore the intricate web of emotions, behaviors, and neurological processes underlying alcohol and drug addiction. Uncover the psychological mechanisms driving substance dependence and gain insights into effective intervention strategies. Delve into the complex terrain of addiction psychology for a comprehensive understanding of its impact on individuals and society.

Psychology Of Alcohol And Drug Addiction
Delivered Online On Demand
£25

Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide

By Ideas Into Action

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Power Query and Power Pivot in Microsoft Excel: 
A Quickstart Guide
Delivered Online On Demand
£9.99

Home-Based Childcare Course - Level 5

4.7(160)

By Janets

Discover the comprehensive Home Based Childcare Course - Level 5, designed to equip caregivers with advanced skills and knowledge for nurturing young minds. Explore child development, safety protocols, and best practices in a flexible, home-based learning environment. Enroll now to embark on a rewarding journey in childcare excellence.

Home-Based Childcare Course - Level 5
Delivered Online On Demand14 days
£25