Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY
Are you looking to enter the dynamic world of real estate? Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics. At the end of the course, you'll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector. On this course, you will… Become familiar with the players, structure, general terminology and overall needs of Real Estate. Learn what is Real Estate and why it is different from other asset classes Get to grips with the overall size and structure of the UK Real Estate Market Learn and analyse the links between the different parts of the property market Understand who works in the Real Estate Market, their qualifications and their job descriptions Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc… Learn how to read a real estate market report Understand how current affairs, politics and economics affects Real Estate Investment Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector Who will benefit from this course: Graduates or undergraduates studying economics, finance. Professionals working in Marketing or Accounting teams within Real Estate firms. APC students. Anyone interested in Real Estate. School leavers/A-Level Students looking to gain an understanding of Real Estate. Non cognate students who wish to transfer into Real Estate/Finance careers. Course Outline Module 1: What is and why buy Real Estate? The property Market The Size and Structure of the UK property market The impact of Real Estate in the Economy Module 2: The Real Estate Market System The Space Market The Asset Market The Development Market Module 3: How to value Real Estate An Introduction to Financial Mathematics The difference between Price, Value and Worth Property Yield Conventional Valuation Methods Module 4: How to read a Real Estate Market Report Property Market Indicators: Stock Indicators Property Market Indicators: Investment Indicators Module 5: Who works in Real Estate? The build Environment by Cobalt Recruitment Rea; Estate Agents Examples of Real Estate Market Agents CVs Real Estate Network
About this Virtual Instructor Led Training (VILT) This course will provide a comprehensive, foundational content for a wide range of topics in power system operation and control. With the growing importance of grid integration of renewables and the interest in smart grid technologies, it is more important than ever to understand the fundamentals that underpin electrical power systems. This course provides a thorough understanding of all basic terminology and concepts of electrical systems, structure of a power system, transmission line parameters, insulators, high-voltage direct current transmission, substation and neutral grounding, distribution system, circuit breakers, relaying and protection, power system stability, economic operation of power systems, load frequency control, voltage and reactive power control, renewable energy sources, restructuring of electrical power systems, and smart grids. This course is a MUST for practitioners, consultants, engineers of all disciplines, managers, technicians and all technical personnel who need to learn about electrical power systems. Training Objectives Basic Terminology and Concepts of Electrical Systems: Gain an understanding of the basic terminology and concepts of electrical systems and the structure of a power system Transmission Line Parameters: Learn in detail all the transmission line parameters including line resistance, line inductance, transposition of transmission lines, and capacitance of transmission lines Insulators: Understand thoroughly all the various types of insulators, pin type insulators, suspension type or disc insulators, strain insulators, and testing of insulators High-Voltage Direct Current Transmission: Determine the advantages and disadvantages of high voltage direct current transmission, and gain an understanding of all the features of high-voltage direct current transmission Substations and Neutral Grounding: Gain a detailed understanding of all substation equipment, factors governing the layout of substations, station transformers, elements to be earthed in a substation, power system earthing, earthing transformers, bus bar arrangements and gas-insulated substations Distribution System: Learn about the effects of voltage on the conductor volume, distributor fed from one end, distributors fed from both ends at the same voltage, distributors fed from both ends at different voltages, and alternating current distribution Circuit Breakers: Learn about the classification of circuit breakers, plain-break oil circuit breakers, air break circuit breaker, air blast circuit breakers, vacuum circuit breakers, SF6 circuit breakers, rating and testing of circuit breakers Relaying and Protection: Learn all the requirements of relaying, zones of protection, primary and backup protection, classification of relays, electromagnetic relays, induction relays, feeder protection, phase fault protection, reactance relay, static overcurrent relay, differential protection, transformer protection, Buchholz relays, alternator protection restricted earth fault protection, rotor earth fault protection, and negative-sequence protection Economic Operation of Power Systems: Gain an understanding of steam power plants, heat rate characteristics and characteristics of hydro plants Load Frequency Control: Learn about speed governing mechanism, speed governor, steady state speed regulations and adjustment of governor characteristics Voltage and Reactive Power Control: Gain an understanding of impedance and reactive power, system voltage and reactive power, voltage regulation and power transfer Renewable Energy Sources: Learn about solar power, wind power, geothermal energy, biomass and tidal power Restructuring of Electrical Power Systems: Gain an understanding of smart grids, smart grid components, smart grid benefits, and open smart grid protocol Target Audience Engineers of all disciplines Managers Technicians Maintenance personnel Other technical individuals Course Level Basic or Foundation Training Methods The VILT will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom 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 the course. The instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all the delegates gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught to their own organization. Each delegate will receive a copy of the following materials written by the instructor: 'ELECTRICAL EQUIPMENT HANDBOOK' published by McGraw-Hill in 2003 (600 pages) Introduction to Power Systems Manual (500 pages) Trainer Your specialist course leader has more than 32 years of practical engineering experience with Ontario Power Generation (OPG), one of the largest electric utility in North America. He was previously involved in research on power generation equipment with Atomic Energy of Canada Limited at their Chalk River and Whiteshell Nuclear Research Laboratories. While working at OPG, he acted as a Training Manager, Engineering Supervisor, System Responsible Engineer and Design Engineer. During the period of time, he worked as a Field Engineer and Design Engineer, he was responsible for the operation, maintenance, diagnostics, and testing of gas turbines, steam turbines, generators, motors, transformers, inverters, valves, pumps, compressors, instrumentation and control systems. Further, his responsibilities included designing, engineering, diagnosing equipment problems and recommending solutions to repair deficiencies and improve system performance, supervising engineers, setting up preventive maintenance programs, writing Operating and Design Manuals, and commissioning new equipment. Later, he worked as the manager of a section dedicated to providing training for the staff at the power stations. The training provided by him covered in detail the various equipment and systems used in power stations. In addition, he has taught courses and seminars to more than four thousand working engineers and professionals around the world, specifically Europe and North America. He has been consistently ranked as 'Excellent' or 'Very Good' by the delegates who attended his seminars and lectures. He written 5 books for working engineers from which 3 have been published by McGraw-Hill, New York. Below is a list of the books authored by him; Power Generation Handbook: Gas Turbines, Steam Power Plants, Co-generation, and Combined Cycles, second edition, (800 pages), McGraw-Hill, New York, October 2011. Electrical Equipment Handbook (600 pages), McGraw-Hill, New York, March 2003. Power Plant Equipment Operation and Maintenance Guide (800 pages), McGraw-Hill, New York, January 2012. Industrial Instrumentation and Modern Control Systems (400 pages), Custom Publishing, University of Toronto, University of Toronto Custom Publishing (1999). Industrial Equipment (600 pages), Custom Publishing, University of Toronto, University of Toronto, University of Toronto Custom Publishing (1999). Furthermore, he has received the following awards: The first 'Excellence in Teaching' award offered by PowerEdge, Singapore, in December 2016 The first 'Excellence in Teaching' award offered by the Professional Development Center at University of Toronto (May, 1996). The 'Excellence in Teaching Award' in April 2007 offered by TUV Akademie (TUV Akademie is one of the largest Professional Development centre in world, it is based in Germany and the United Arab Emirates, and provides engineering training to engineers and managers across Europe and the Middle East). Awarded graduation 'With Distinction' from Dalhousie University when completed Bachelor of Engineering degree (1983). Lastly, he was awarded his Bachelor of Engineering Degree 'with distinction' from Dalhousie University, Halifax, Nova Scotia, Canada. He also received a Master of Applied Science in Engineering (M.A.Sc.) from the University of Ottawa, Canada. He is also a member of the Association of Professional Engineers in the province of Ontario, Canada. 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
This accelerated Level 3 Diploma in Introduction to Management (fast track) qualification (accredited by Ofqual, UK) has been designed to develop and reward learners who are considering or have already selected a profession in a business-related industry. This programme is designed to equip global learners with relevant new skills and characteristics. This fast track Level 3 Diploma in Introduction to Management programme is designed to foster both academic and professional development, enabling learners to advance toward realising not only their own but also the potential of organisations across a broad range of sectors. The qualification is certified at Level 3 and carries a total credit value of 60. Learners who complete the Level 3 Diploma are expected to continue to a Level 4 qualification. Key Highlights of fast track Level 3 Diploma in Introduction to Management qualification are: Program Duration: 6 Months (Regular 9 months duration course also available) Program Credits: 60 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Undergraduate degree programme. Alumni Status No Cost EMI Option Requirements This fast track Level 3 Diploma in Introduction to Management (Accredited by Ofqual, UK) qualifications has been designed to be accessible without artificial barriers that restrict access and progression. Learners will be expected to hold the following: Learners who have demonstrated some ability and possess Qualifications at Level 2 OR work experience in a business environment and demonstrate ambition with clear career goals; OR Level 3 qualification in another discipline and want to develop their careers in management. Career path Career Progression Learners completing this fast track course can progress to: The First year of an Undergraduate Degree in Business and Management, or BA (Hons) Business Management degree qualification BA (Hons) Management from Anglia Ruskin University, UK Level 4 Diploma qualifications (click here to view) Directly into employment in an associated profession. Certificates Certificate of Achievement Hard copy certificate - Included Qualifi courses: Once you complete the course, you would be receiving a Physical hard copy of your Diploma along with its Transcript which we would Courier to your address via DHL or Royal Mail without any additional charge
We're passionate about equipping churches to respond to domestic abuse. Our Domestic Abuse Awareness course will help you explore key questions around the issue of domestic abuse, like how to recognise the signs of domestic abuse, why domestic abuse happens, and how to start supporting survivors.
Vectorworks Evening Course face to face One to one
Course Overview: Introduction to COPD in Primary CareThese introductory days are tailored for nurses and other healthcare professionals who are new to the realm of COPD care or have not received formal training in this area. Led by Paula Matson, a Respiratory Specialist and Practice Nurse, the program is designed to build a foundational understanding of COPD and empower participants to provide effective care to COPD patients in primary care settings.These introductory sessions offer a comprehensive journey from the fundamentals of COPD understanding to a confident approach in patient review and management, emphasizing the importance of early intervention and holistic care in primary care settings. Learning Outcomes: Upon completion of this Introduction to COPD course, participants will attain the following learning outcomes: 1. Emphasize Early Prevention: Recognize the significance of early prevention in COPD management and its impact on patient outcomes. 2. Grasp COPD Physiology: Develop a foundational understanding of the physiological underpinnings of COPD, aiding accurate assessment and care. 3. Comprehend Medications and Roles: Acquire knowledge about COPD medications, comprehending their diverse roles in managing symptoms. 4. Non-Pharmacological Management: Understand and appreciate non-pharmacological approaches to COPD care and symptom management. 5. Inhaler Proficiency: Gain expertise in managing various types of inhaler devices, ensuring effective medication delivery. 6. Documentation Proficiency: Understand the importance of meticulous documentation, including utilizing templates for streamlined care. 7. Review and Self-Management: Realize the value of regular patient review and supervised self-management plans for COPD patients. 8. Problem Solving and Solutions: Foster discussions to address relevant practice issues and collaboratively discover effective solutions. 9. Commitment to Ongoing Development: Recognize the importance of continuous professional development in the evolving landscape of COPD care These introductory sessions offer a comprehensive journey from the fundamentals of COPD understanding to a confident approach in patient review and management, emphasizing the importance of early intervention and holistic care in primary care settings.
This online Introduction to Communication Skills course aims to empower you to have more effective conversations with your patients, their friends and family and your colleagues at work. In particular, the focus will be on understanding and appreciating communication skills and how to use them more effectively and efficiently.