3077 Courses delivered Online

About this Virtual Instructor Led Training (VILT)  Electrification of the transportation sector will impact the power system in several ways. Besides the additional load, local impact on the grid needs to be managed by the grid operators. Simultaneously charging of many electric vehicles (EVs) might exceed the limits in specific locations. On the other hand, EVs can provide flexibility and other ancillary services that will help grid operators. This 3 half-day VILT course will provide a complete overview of integrating electric vehicles (EVs) into the power grid. It will cover the whole value chain from grid operations to the car battery. This includes the control room, possible grid reinforcement, demand side management and power electronics. This course will demonstrate the impact on the grid and solutions for a safe & cost-effective grid plan and operation, with examples of successful integration of EVs. The course will also provide vital knowledge about technology used for EVs such as power electronics, demand side management, communication and batteries. In this context, the focus will be on power electronics as it has the highest impact on the grid. The grid planning tool, pandapower, is introduced as an open source tool for power system modelling. The set-up of the training course allows for discussion and questions. Questions can be formulated by the participants upfront or during the training. This course is delivered in partnership with Fraunhofer IEE. Training Objectives At the end of this course, the participants will: Understand the charging options for EVs and its impact on the grid and batteries Identify system services for EVs with regards to voltage quality at the point of common coupling Discover what are the 'grid friendly' and grid supporting functions in EVs Uncover the different applications, standards and data researched on EVs Examine the application of a grid planning tool (pandapower) for power system modelling Be able to develop code snippets with pandapower Apply and execute a code example for power system modelling with pandapower Target Audience EV and grid project developers and administrators Power grid operators and planners EPC organisations involved in grid development EV/ battery manufacturers and designers EV transport planners and designers Government regulators and policy makers Training Methods The VILT will be delivered online in 3 half-day sessions comprising 4 hours per day, with 2 x 10 minutes breaks per day, including time for lectures, discussion, quizzes and short interactive exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end of every session/day. Trainer Our first course expert is Head of Department Converters and Electrical Drive Systems at Fraunhofer IEE and Professor for Electromobility and Electrical Infrastructure at Bonn-Rhein-Sieg University of Applied Sciences. He received his engineering degree in automation in 2008 by the THM Technische Hochschule Mittelhessen (FH Giessen-Friedberg). Afterwards he studied power engineering at University of Kassel and received his diploma certificate in 2010. In 2016 he received the Ph.D. (Dr.-Ing.) from the University of Hannover. The title of his dissertation is Optimized multifunctional bi-directional charger for electric vehicles. He has been a researcher at the Fraunhofer IEE in Kassel since 2010 and deals with power converters for electric vehicles, photovoltaics and wind energy. His current research interests include the bidirectional inductive power transfer, battery charger and inverter as well as new power electronic components such as SiC MOSFETs and chokes. Additionally, our key expert is Chairman of the IEEE Joint IAS/PELS/IES German Chapter and a member of the International Scientific Committee of the EPE Association. Our second course expert is deputy head of energy storage department at Fraunhofer IEE. Prior to this he was the Director of Grid Integration department at SMA Solar Technology AG, one of the world's largest manufacturers of PV power converters. Before joining SMA, our course expert was manager of the Front Office System Planning at Amprion GmbH (formerly RWE TSO), one of the four German transmission system operators. He holds a degree of electrical engineering of the University of Kassel, Germany. In 2003 he finished his Ph.D. (Dr.-Ing.) on the topic of wind power forecasting at the 'Institute of Solar Energy Supply Technology' (now Fraunhofer IEE) in Kassel. In 2004 he started his career at RWE TSO with main focus on wind power integration and congestion management. Our course expert is chairman of the IEC SC 8A 'Grid Integration of Large-capacity Renewable Energy (RE) Generation' and has published several papers about grid integration of renewable energy source and forecasting systems on books, magazines, international conferences and workshops. Our third course expert is Research Associate at Fraunhofer IEE. He is actively working on different projects related to the integration of electric vehicle charging into the electric distribution grid. The focus of this work concerns time series based simulations for grid planning and operation in order to investigate the effect of a future rollout of electric vehicles and charging infrastructure on economics e.g. costs for grid reinforcement. He completed his master degree (MSc.) in Business Administration and Engineering: Electrical Power Engineering at RWTH Aachen University, Germany. Our trainers are experts from Fraunhofer Institute for Energy Economics and Energy System Technology (Fraunhofer, IEE), Germany. The Fraunhofer IEE researches for the national and international transformation of energy supply systems POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals 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 Oracle 12c SQL Fundamentals 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.

The 'Warehouse' course provides a comprehensive understanding of warehouse management, covering essential topics such as functions, benefits, types of warehousing, and the role of technology in modern warehouse operations. Participants will delve into supply chain management concepts, warehouse safety, inventory control, and the pivotal role of human resource management. With a focus on improving efficiency and reducing costs, this course equips learners with the knowledge and skills needed to excel in warehouse management and contribute to the success of supply chain logistics. Learning Outcomes: Grasp the fundamental principles and benefits of warehouse management. Explore various types of warehousing and their functions in the supply chain. Understand the core functions of a warehouse management system. Identify challenges in warehouse management and strategies for overcoming them. Gain insights into technology's impact on warehouse operations. Comprehend supply chain management concepts and their application in warehouses. Learn about essential inventory management techniques and control flow. Enhance warehouse safety protocols and cost management strategies. Why buy this Warehouse? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Warehouse there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Warehouse does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Individuals seeking a career in logistics, warehouse management, or supply chain. Warehouse managers, supervisors, and personnel aiming to enhance their skills. Entrepreneurs or business owners involved in inventory and logistics management. Professionals interested in improving warehouse efficiency and reducing costs. Prerequisites This Warehouse was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Warehouse Manager - Median salary of $50,000 - $80,000 per year. Logistics Coordinator - Median salary of $40,000 - $60,000 per year. Inventory Control Specialist - Median salary of $40,000 - $60,000 per year. Supply Chain Analyst - Median salary of $50,000 - $70,000 per year. Operations Manager (with warehouse focus) - Median salary of $60,000 - $100,000 per year. Course Curriculum Warehouse Fundamentals of Warehouse Management 00:30:00 Warehousing: Function, Benefits and Types of Warehousing 00:30:00 Core Functions Of A Warehouse Management System 00:15:00 Challenges Of Warehouse Management 00:30:00 Technology In The Warehouse 00:45:00 Supply Chain Management Concepts 00:30:00 Warehouse Management Technologies to Adopt 00:15:00 Order Picking in the Warehouse 00:18:00 Managing Warehouse Inventory 00:15:00 Organize the Storage of Inventory in a Warehouse 00:15:00 Inventory Management Techniques 00:30:00 Inventory Control Flow of Processing 01:00:00 Logistics and Supply Chain In A Warehouse 00:30:00 Inventory Classification In The Warehouse 00:15:00 The Role Of Human Resource management In A Warehouse 00:30:00 Warehouse Safety 00:30:00 Warehouse Cost Management 00:15:00 Improve Warehouse Efficiency and Reduce Costs 00:15:00 Mock Exam Mock Exam- Warehouse 00:20:00 Final Exam Final Exam- Warehouse 00:20:00

Level 1 Award in Facilities Management Explore the fundamental principles, strategies, and key services that drive effective facility management. Discover the intricacies of managing facilities for service organizations and the critical aspect of risk management in this dynamic field of study. Learning Outcomes: Explain the fundamentals of Facilities Management concepts. Develop effective Facility Management strategies and plans. Identify key services within Facilities Management practices. Differentiate functions in Facility Management for various contexts. Apply risk management principles to Facilities Management. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Level 1 Award in Facilities Management Course Syllabus Facilities Management Basics: Gain a comprehensive understanding of facilities management, its significance, and its role in modern organizations. Facilities Management Strategies: Learn effective strategies for optimizing facility operations, enhancing cost-efficiency, and ensuring seamless functionality. Facilities Management Services: Explore the essential services encompassed by facilities management, including maintenance, security, and sustainability. Functions in Facilities Management: Dive into the various functions involved in facilities management, from space planning to technology integration. Facilities Management for Service Organizations: Understand how facilities management principles apply specifically to service-oriented organizations, ensuring smooth service delivery. Risk Management: Acquire skills in identifying and mitigating risks associated with facilities management to maintain a safe and compliant environment.

Embark on a journey through the intricate realm of central banking and monetary policy with our comprehensive course. Delve into the captivating history of central banking, tracing its evolution alongside the international monetary system. Explore modern roles and functions, understanding central banks' pivotal role in global economic landscapes. From dissecting monetary policy implementation to unravelling the complexities of money creation in the modern economy, this course offers a nuanced understanding essential for navigating the financial realm with expertise. Unlock the secrets of the monetary policy transmission mechanism and gain insights into maintaining financial stability amidst dynamic market conditions. Navigate through challenges confronting central banking institutions, equipping yourself with the insight to address them effectively. In times of crisis, learn optimal monetary policy operations strategies to mitigate risks and foster economic resilience. Through engaging modules led by industry experts, immerse yourself in a transformative learning experience that equips you with the knowledge and skills to thrive in central banking and monetary policy. Learning Outcomes: Grasp the historical evolution of central banking and its significance within the international monetary system. Understand the multifaceted roles and functions of modern central banking institutions. Analyze the intricacies of monetary policy implementation and its impact on financial markets. Evaluate the mechanisms of money creation in the contemporary economic landscape. Identify challenges facing central banking and develop strategies for effective crisis management. Why buy this Central Banking Monetary Policy Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Central Banking Monetary Policy there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Central Banking Monetary Policy course for? Financial analysts seeking a deeper understanding of central banking dynamics. Economics students aiming to specialize in monetary policy and financial markets. Professionals in banking and finance industries exploring career advancement opportunities. Policy makers and government officials involved in economic decision-making processes. Individuals interested in gaining insights into global economic systems and financial stability. Prerequisites This Central Banking Monetary Policy does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Central Banking Monetary Policy was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Central Bank Economist: £40,000 - £70,000 Per Annum Financial Analyst: £30,000 - £50,000 Per Annum Monetary Policy Advisor: £45,000 - £80,000 Per Annum Risk Management Specialist: £35,000 - £60,000 Per Annum Economic Researcher: £35,000 - £55,000 Per Annum Financial Regulatory Analyst: £35,000 - £65,000 Per Annum Course Curriculum Module 01: The History of Central Banking and International Monetary System The History of Central Banking and International Monetary System 00:09:00 Module 02: Modern Central Banking Roles and Functions Modern Central Banking Roles and Functions 00:12:00 Module 03: Monetary Policy Implementation in Financial Market Operations Monetary Policy Implementation in Financial Market Operations 00:08:00 Module 04: Money Creation in the Modern Economy Money Creation in the Modern Economy 00:09:00 Module 05: The Monetary Policy Transmission Mechanism The Monetary Policy Transmission Mechanism 00:14:00 Module 06: Financial Stability: Monitoring and Identifying Risks Financial Stability Monitoring and Identifying Risks 00:11:00 Module 07: Challenges for Central Banking Challenges for Central Banking 00:10:00 Module 08: Optimal Monetary Policy Operations in Crisis Times Optimal Monetary Policy Operations in Crisis Times 00:08:00

Embark on a journey to master the intricacies of Asynchronous JavaScript and open doors to web development techniques that will set you apart in the tech world. The 'Asynchronous JavaScript Basics' course is a treasure trove of knowledge, meticulously designed for those who yearn to wield the power of non-blocking code with finesse. Begin with a gripping scenario that sets the stage, introducing you to the dynamic realms of synchronous and asynchronous operations. With each module, unlock a deeper understanding of how JavaScript engines handle tasks behind the scenes, enabling websites to perform efficiently and responsively. As you delve into the course, witness the magic of asynchronous JavaScript unfold through engaging workshops and demos. The curriculum promises to transform your coding approach, allowing you to implement features such as 'setTimeout' and 'setInterval', manage 'Promises', and gracefully orchestrate asynchronous flows with 'Async/Await'. The carefully structured roadmap and hands-on demonstrations are not just lessons but stepping stones to becoming proficient in creating smoother user experiences and robust web applications. Learning Outcomes Comprehend the distinction between synchronous and asynchronous JavaScript and the scenarios for their use. Utilize 'setTimeout' and 'setInterval' functions to manage time-controlled scripting tasks. Implement 'Promises' to handle future events and asynchronous operations efficiently. Apply 'Async/Await' syntax for writing cleaner and more readable asynchronous code. Understand and use JavaScript Generator Functions to control the execution flow of functions. Why choose this Asynchronous JavaScript Basics course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Asynchronous JavaScript Basics Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Asynchronous JavaScript Basics course for? Individuals keen on enhancing their JavaScript knowledge for advanced web development. Developers seeking to improve site responsiveness and user experience. Programmers looking to upskill in modern JavaScript practices. Web enthusiasts curious about the execution of non-blocking code. Students or hobbyists interested in the mechanics of JavaScript engines. Career path Front-End Developer: £25,000 - £50,000 Back-End Developer: £30,000 - £60,000 Full Stack Developer: £35,000 - £70,000 Web Application Developer: £28,000 - £55,000 JavaScript Developer: £30,000 - £65,000 UI/UX Developer: £27,000 - £50,000 Prerequisites This Asynchronous JavaScript Basics does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Asynchronous JavaScript Basics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Basic Asynchronous JavaScript An Async Javascript Scenario 00:02:00 Defining Asynchronous / What is Synchronous code? 00:04:00 WORKSHOP -Exploring Synchronicity in JavaScript 00:09:00 All About Asynchronous Code 00:06:00 Course Roadmap 00:01:00 What is setTimeout? 00:05:00 DEMO - Delaying Code Execution with setTimeout 00:10:00 What is setInterval? 00:02:00 DEMO - Repeating Tasks with setInterval 00:07:00 Chapter Summary 00:01:00 What is Async / Await? 00:03:00 What are Promises? 00:02:00 DEMO - Wrapping setTimeout with a Promise 00:05:00 All About Async 00:02:00 DEMO - Performing Asynchronous Tasks Concisely with Async / Await 00:12:00 What are JavaScript Generator Functions? 00:02:00 Demo - Asynchronous JavaScript via generators 00:08:00 Course Summary 00:02:00 Assignment Assignment - Asynchronous JavaScript Basics 00:00:00

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  

***24 Hour Limited Time Flash Sale*** Software and Web Development Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter How about launching your software engineering or web development career through comprehensive training across today's most in-demand programming languages? As technology reshapes industries across the UK, skilled coders are in short supply, with over 300,000 developer roles needed by 2025. This Software and Web Development bundle equips you with the skills to join this exciting field, whether you're a complete beginner or looking to upskill. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Software and Web Development bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Software and Web Development Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Software and Web Development Career Bundle: Course 01: C++ Development: The Complete Coding Guide Course 02: Basic C# Coding Course 03: Computer Vision: C++ and OpenCV with GPU support Course 04: Python Basic Programming for Absolute Beginners Course 05: Python Programming for Everybody Course 06: Data Science with Python Course 07: Need Another ONE COURSE Course 08: Basic Asynchronous JavaScript Course 09: JavaScript Promises Course 10: Learn to Use Python for Spatial Analysis in ArcGIS Course 11: Higher Order Functions in Python - Level 03 Course 12: Javascript Programming for Beginners Course 13: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 14: SQL Programming Masterclass Course 15: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 16: SQL NoSQL Big Data and Hadoop Course 17: Root Cause Analysis Course 18: Business Intelligence and Data Mining Masterclass Course 19: JavaScript Foundations for Everyone Course 20: Microsoft SQL Server Development for Everyone Course 21: R Programming for Data Science Course 22: Data Analytics with Tableau Course 23: Intermediate Python Coding Course 24: Google Data Studio: Data Analytics Course 25: Introduction to Data Analysis Course 26: Level-3 Machine Learning Course with Python Course 27: Complete Google Analytics Course Course 28: JavaScript Functions Course 29: Quick Data Science Approach from Scratch Course 30: JavaScript Masterclass: ES6 Modern Development With Software and Web Development, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. Learning Outcomes Build robust applications and analyse data with confidence. Uncover the secrets of image processing and analysis. Craft interactive web experiences with JavaScript frameworks. Utilise SQL and Python for data manipulation and visualisation. Create dynamic dashboards with Excel formulas and VBA. Understand the world of SQL, NoSQL, and Hadoop. Enrol in Software and Web Development today and take the first step towards achieving your goals and dreams. Why buy this Bundle? Free CPD Accredited Certificate upon completion of Software and Web Development Get a free student ID card with Software and Web Development Lifetime access to the Software and Web Development course materials Get instant access to this Software and Web Development course Learn Software and Web Development from anywhere in the world 24/7 tutor support with the Software and Web Development course. Start your learning journey straightaway with our Software and Web Development Training! The software and Web Development premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Software and Web Development is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Software and Web Development course. After passing the Software and Web Development exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Software and Web Development course is ideal for: Students seeking mastery in Software and Web Development Professionals seeking to enhance Software and Web Development skills Individuals looking for a Software and Web Development-related career. Anyone passionate about Software and Web Development Requirements This Software and Web Development doesn't require prior experience and is suitable for diverse learners. Career path This Software and Web Development bundle will allow you to kickstart or take your career in the related sector to the next stage. Software developer Web developer Data scientist Database admin Business analyst Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Course Description The Hospitality Management and Restaurant Business: Part 2 course is designed to give you a deeper understanding of different aspects of the restaurant business and hospitality management. In this course, you are expected to learn about the arrival chronology, from greeting to check-in and check-out. You will be led through the procedures for the front office communications. In addition to that, the course will explain to you the role and functions of the Housekeeping department. You will also learn about the duties and responsibilities of a food and beverage manager. Doing this course will enable you to explain the importance of service quality in the hospitality sector. If all these sound good, enrol today and start learning!  Learning outcome  Learn about the arrival chronology Understand the procedures for the front office communications Know the role and functions of the Housekeeping department Explore the duties and responsibilities of a food and beverage manager Explain the importance of service quality in the hospitality sector How Much Do Restaurant Managers Earn? Senior - £32,000(Appx.) Average - £29,000(Appx.) Starting - £26,000(Appx.) Requirement Our Hospitality Management and Restaurant Business: Part 2 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Hospitality Management and Restaurant Business: Part 2 Module 01: Management of Front Office Operations 00:16:00 Module 02: Management of Housekeeping, Engineering and Security Operations 00:24:00 Module 03: Management of Food and Beverage Operations 00:17:00 Module 04: Management of Service Quality in Hospitality Industry 00:17:00 Module 05: Creating an Online Ordering System 00:32:00 Module 06: Restructuring Management 00:24:00 Assignment Assignment - Hospitality Management and Restaurant Business: Part 2 00:00:00

**10 FREE QLS Endorsed Certificates and Included with Lifetime Access** People are the heartbeat of every organisation—and managing people takes more than just a smile and a spreadsheet. This Human Resources Management Diploma Level 4 (QLS Endorsed) is built for those who want to understand what truly keeps a team running smoothly. From hiring to handling disputes, building better staff engagement to understanding workplace laws—this course digs into the details HR professionals need to know. If your idea of HR is just holiday requests and interviews, think again. This goes deeper—minus the jargon and fluff.The course is structured to give you solid HR knowledge from all sides, whether it’s recruitment, performance reviews, or handling sticky situations with professionalism. It’s designed for those aiming to lead or support HR functions without needing years of prior experience. Whether you're working in admin, team leadership, or looking to explore a new direction in people management—this course will give you the right kind of knowledge, in the right kind of way. Fully online, flexible, and informative without putting you to sleep. Human Resources Management - QLS Endorsed Bundle Includes the following Courses Course 01: Diploma in Human Resources Management at QLS Level 4 Course 02: Diploma in Change Management at QLS Level 5 Course 03: Certificate in Bereavement and Grief Counselling at QLS Level 3 Course 04: Diploma in Corporate Compliance and Risk Management at QLS Level 3 Course 05: Certificate in Office Admin and Organisation Skills at QLS Level 3 Course 06: Certificate in Public Relations at QLS Level 3 Course 07: Award in Event Management at QLS Level 2 Course 08: Diploma in Career Coaching at QLS Level 5 Course 09: Diploma in Security Management at QLS Level 5 Course 10: Advanced Diploma in Project Management at QLS Level 7 Learning Outcomes Develop event planning expertise for seamless execution. Acquire adept office administration and organisational skills. Master corporate compliance and risk management strategies. Hone public relations techniques for effective communication. Attain advanced proficiency in human resources management. Navigate complex corporate governance principles and practices. Develop security management skills for a secure work environment. Cultivate grief counselling capabilities with sensitivity and empathy. Gain strategic insight into project management at an advanced level. Excel in the integration of diverse skills across various disciplines. Key Features 10 FREE QLS Endorsed Certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Behind every successful sales team is not just a string of impressive numbers, but a thriving workplace culture crafted by our dedicated Human Resources team. In this bundle, we explore how the human element, championed by HR, is a key ingredient in our journey to success. This curated collection of courses spans a range of essential disciplines, empowering you with versatile skills applicable across diverse industries. Dive into the intricacies of Event Management and HR Management, honing your organisational prowess. Explore the nuances of Bereavement and Grief Counselling, fostering empathy and support. Elevate your strategic thinking with Diplomas in Corporate Compliance, Risk Management, and Corporate Governance, ensuring you're equipped to navigate complex business landscapes. Cultivate essential administrative finesse with Certificates in Office Admin, Organisation Skills, and Public Relations. Progress through the tiers, mastering Human Resources Management and Security Management, culminating in an Advanced Diploma in Project Management. This multifaceted bundle is your gateway to a well-rounded skill set, providing a springboard for success in various professional arenas. By doing this bundle you will gain the ultimate understanding in strategic planning, organisational leadership, crisis management, and interpersonal communication. Develop expertise in compliance, risk mitigation, and project execution. Sharpen administrative skills for seamless office operations and public relations finesse. Master the intricacies of human resources and security management, equipping yourself for diverse roles in the professional landscape. This bundle is designed to nurture well-rounded professionals with a holistic understanding of critical business functions. Certificate Once you've successfully completed your course, you will immediately be sent a CPD Accredited PDF certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). After successfully completing the assignment, learners will be able to order FREE QLS Endorsed certificate for Each Courses. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring Health and Safety Professionals Managers and Supervisors Mental Health Care Workers Childcare and Education Professionals Individuals in Substance Control Roles Psychology Enthusiasts Art Therapy Practitioners Those Pursuing Career Advancement Career path Health and Safety Manager Mental Health Care Coordinator Child Safeguarding Officer Substance Control Specialist Psychology Research Assistant Art Therapist Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. QLS Endorsed Certificate Hard copy certificate - Included