6237 Courses

Students who complete PVOL202 will be able to: Define the purpose of the National Electrical Code (NEC®) and NEC® terminology for PV equipment Determine procedures for proper installation of equipment and conductors, including minimum requirements for working space Examine methods for PV wire management and determine where expansion fittings are required Describe and identify electrical services, including split-phase and three-phase Wye (Y) and Delta (∆) Evaluate electrical service details to collect and record during solar site evaluation Identify options for NEC®-compliant PV system interconnection to the utility grid and determine whether a supply side, load side, or additional service connection is appropriate Identify code-compliant methods for connecting an inverter to an existing AC feeder Calculate PV module voltage based on temperature to ensure compatibility with system components and NEC® Section 690.7, and explore other options for maximum PV system DC voltage calculations Identify NEC® requirements and sizing of disconnects and overcurrent protection devices (OCPDs) in grid-direct PV systems Define inverter grounding configurations Evaluate inverter choices and system configurations, including string inverters, central inverters, and module level power electronics (MLPE) Identify requirements for equipment grounding, equipment grounding conductors (EGC), and grounding electrode conductors (GEC), and size the conductors according to the NEC® Identify common causes of ground-faults and arc-faults Describe ground-fault and arc-fault protection devices Describe benefits and appropriate locations of surge protection devices (SPD) Demonstrate the use of sun charts and perform calculations to determine row spacing and minimize inter-row shading Identify how Codes detailing access for first responders impact PV array roof layout Examine fire classifications that affect racking and module selection Detail NEC rapid shutdown requirements and options for implementation Identify load and structural considerations for low- and steep-slope roof-mounted PV systems Calculate wind uplift force and select appropriate lag bolts Review issues related to planning, design, and installation of ground-mount PV arrays Review PV system circuit terminology, definitions, and conductor types Calculate minimum overcurrent protection device (OCPD) size and conductor ampacity using appropriate adjustment and correction factors Calculate voltage drop and verify system operation within acceptable limits Examine requirements for PV system labeling Calculate the maximum and minimum number of modules per PV source circuit, and number of PV source circuits per inverter Determine size of residential grid-direct PV system based on site and customer-specific considerations including the number and wiring layout of modules, conductor and OCPD sizes, and the AC interconnections Determine the size of a large, multiple inverter, grid-direct PV system based on site and customer-specific considerations, including the quantity and layout of modules and inverters and the AC interconnection Define large-scale PV and review associated NEC® allowances and requirements Describe importance of Data Acquisition Systems (DAS) Identify common DAS equipment and hardware Review DAS design, installation, and commissioning processes and common problems associated with DAS Show how reports can be generated and utilized to remotely assess health of system

ICA Certificate in Financial Crime Prevention A practical, introductory course that will give you a solid understanding of core financial crime, fraud, bribery, and corruption risks. This qualification explores: Financial crime - the risks Fraud controls - different strategies, systems, and controls in practice Fraud typologies in banking Bribery & corruption - the risks and international initiatives to combat these risks Fraud response policy - explore the objectives of a plan, the reporting channels and contingencies This course is awarded in association with Alliance Manchester Business School, the University of Manchester. There are many benefits of studying with ICA: Flexible learning solutions that are suited to you Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate Students can expect the following outcomes Understanding of the key risks and controls essential for financial crime prevention. Knowledge to help protect a firm against the continuous threat of financial crime Verifiable evidence of learning ICA Certificate in Financial Crime Following successful completion of the ICA Certificate in Financial Crime Prevention training course, students will be able to use the designation 'Cert. (FCA).' This course is awarded in association with Alliance Manchester Business School, the University of Manchester. This ICA Certificate in Financial Crime Prevention training course develops knowledge and practical skills in the following areas: What is Financial Crime? What Are the Financial Crime Risks? Fraud Controls Banking - Fraud Typologies Identity Theft and Electronic Crime Bribery & Corruption Fraud Response Policy Criminal Offences - exploring the UK system At the end of the course there is a one hour multiple choice examination that is taken online.

Operator License Awaress,

Operator License Awaress,

Operator License Awaress,

Operator License Awareness, OLAT, TM Refresher Course

Operator License Awareness, OLAT, TM Refresher Course

Operator License Awareness, OLAT, TM Refresher Course

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  

Data analysis translates numbers and data into information that can be used to solve problems or track business performance. Data analysis produces graphs, charts, tables and reports. Data analysis is in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education. The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data but be able to provide insight and analysis through clear visual, written and verbal communication. This course provides the knowledge and skills to help you hone your data analysis skills.