43356 Courses delivered Online

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

BGP training course description A study of BGP for non engineers working in the Internet. The course starts with a review of the basics of routers and routing tables and then moves on to a simple overview of how BPG works with a focus on BGP metrics influencing the route traffic takes through the Internet. Hands on with routers follow the major sessions to reinforce the theory. Note these hands on sessions are more demonstrations by the trainer but some can be followed along and done by delegates (e.g. looking at Internet routing tables.) What will you learn Explain how routing tables influence Internet traffic. Describe how BGP works. Explain the methods BGP can use to influence Internet traffic. Use traceroute, peeringdb, route collectors and looking glasses to analyse traffic flows. Explain the difference between bi lateral and multilateral peering using a route server. BGP training course details Who will benefit: Non technical staff wishing to know more about BGP. Prerequisites: None. Duration 1 day BGP training course contents Networks, routers and routing tables What is a network, what is a router, routing tables, static routes, routing protocols. When an ISP uses static routes and when they use BGP. IP addresses, subnet masks, groups of IP addresses. IPv6. Hands on: Showing a full routing table. Seeing traceroute being used. Basic BGP What's BGP? BGP versus other routing protocols, ASs, AS numbers. RIPE database, peeringdb. Hands on: Finding AS numbers. Showing simple BGP configuration and routing tables in an EVENG example. How BGP works Simple walk through of BGP incremental updates and how routes change when links go down. Hands on: Showing packets and route changes when a link goes down/comes up. BGP path selection Transit, peering, routing policy and route filtering. Longest matching rule in routing tables, route selection order, Local preference, AS prepend, MEDs. Hands on: Seeing BGP influencing traffic. Looking at peering policies in RIPE and peeringdb. Route servers What are route servers? LINX route servers, route server policy control and communities, What are route collectors, Looking glasses. Hands on: Seeing the LINX route server details in peeringdb, using a looking glass.

Relationship coaching Talk through emotions and needs Address fears and emotions Ascertain your fears and address them Teaching better relationship strategies Personal dating coaching for 2 months 1 hour per week Dating advice for singles https://relationshipsmdd.com/product/how-do-i-know-partner-is-the-one-package/

Couples therapy assessment calls Gottman method Insight gaining therapy Communication counselling Positive psychology couples therapy Couples therapy effective communication exercises Homework and couples therapy implementation tasks Attachment therapy Resolve serious conflicts Improve trust and honesty Address core issues Dating advice and relationship advice Couples therapy near me https://relationshipsmdd.com/product/m-d-d-couples-therapy-8-session-package/

The purpose of this course is to describe the principles and procedures of Hazard and Operability (HAZOP) Studies. HAZOP is a structured and systematic technique for examining a defined system, with the objective of: Identifying potential hazards in the system. The hazards involved may include both those essentially relevant only to the immediate area of the system and those with a much wider sphere of influence, e.g. some environmental hazards; Identifying potential operability problems with the system and in particular identifying causes of operational disturbances and production deviations likely to lead to nonconforming products. An important benefit of HAZOP studies is that the resulting knowledge, obtained by identifying potential hazards and operability problems in a structured and systematic manner, is of great assistance in determining appropriate remedial measures. The course is designed using the tools and techniques identified by IEC 61882:2016. LEARNING OUTCOMES By the end of this course you will understand how to: prepare for a HAZOP study meeting and programme – including defining the scope of the study and choosing the team choose nodes (parts of the drawings or operation for HAZOP study) estimate the programme requirements for the successful completion of a study use facilitation techniques to motivate the team and keep them on task avoid common problems encountered during study meetings, including challenging behaviours formulate the HAZOP study report fulfil the team leader’s role in implementing recommendations and managing the process FOR WHOM Anyone with experience of the HAZOP technique who is required to lead HAZOP studies Process safety engineers, loss prevention specialists, production engineers, process design engineers, project engineers, process programmers and instrument control engineers Risk Managers COURSE CONTENT Introduction to HAZOPWhat is a HAZOP?What are Hazards and Risk?Limitations of HAZOPsEssential Features of HAZOP Principles of examination Design representation Design requirements and design intent Applications of HAZOP Relation to other analysis toolsFailure Mode Effect AnalysisAs Low As Reasonably Practicable (ALARP)Fail Tree AnalysisEvent Tree Analysis HAZOP study limitations Risk identification studies during different system life cycle stagesConcept stageDevelopment stageRealization stageUtilization stageEnhancement stageRetirement stage The HAZOP study procedure Initiate the study Define scope and objectives Define roles and responsibilities Preparation Plan the study Collect data and documentation Establish guide words and deviations Examination Structure the examination Guidewords and Deviations Causes, Consequences and Safeguards Perform the examination Risk Ranking Documentation and follow up Establish method of recording Output of the study Record information Sign off the documentation Follow-up and responsibilities Case Study and practical application TRAINING METHODOLOGIES Presentation Case Study Individual Exercises Group Exercises DURATION: 4 Days (Examination on day 4)

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Master 2 (PSM II). This is an advanced scrum master training course - designed for experienced Scrum Masters seeking professional growth. Course Description This advanced Professional Scrum Master (PSM II) qualification is designed to elevate you to a level of total Scrum mastery. Deepen your understanding of the Scrum framework and Agile practices while transforming your team into an Agile powerhouse. Gain the skills to teach Agile and support your organisation, regardless of your role. Whether you aim to lead Agile transformation within your organisation or progress your Agile career, this advanced Scrum mastery course is your ideal opportunity. Our Scrum.org certified advanced professional scrum master training course is delivered by industry experts with unrivalled interactivity. We combine real world experience with industry leading practicals that embed key principles. The PSM 2 course if focussed on developing practical skillsets and best practice implementation to achieve tangible results. Through these tried and tested learning techniques, Fractal Systems delivers a 98% first-time pass rate. Learn how to become an advanced Scrum Master: Understand how Scrum principles and values guide decision-making. Enhance servant-leadership abilities. Support Development Teams and Product Owners to improve effectiveness. Foster a conducive environment for successful Scrum Teams with greater agility. Gain tips and techniques for collaboration with the organisation. Improve overall organisational impact as a successful Scrum Master. Address team conflict and remove impediments. Communicate the significance of a "Done" Increment. Grasp how to support the Scrum Team and navigate middle management challenges. Why Train With Us? This immersive two day PSM II course prioritises your growth and success in the industry. We believe in hands-on learning experiences that deliver practical applications that are specific to your individual workplace challenges. This not only helps to frame key principles of an advanced Scrum Master but also enables you to have a more immediate impact in your role. The PSM II training course is led by our Scrum Trainers, all of which have real world industry experience. Gain a deep understanding of advanced Scrum theory, empower your Scrum teams with best practices and be supported by industry professionals throughout - from passing test to implementing learnings into your role. Who Should Attend This Course? The Professional Scrum Master II course is an advanced program tailored for experienced Scrum Masters with a deep understanding of the Scrum framework. We recommend this to individuals with at least one year of Scrum Master experience. Your Professional Scrum Trainer Meet Jay, the founder of Fractal Systems and an experienced Professional Scrum Trainer. With over 20 years in leadership and team roles, Jay excels in delivering practical value. He adopts an interactive teaching style, avoiding PowerPoint in favour of engaging, experience-based learning, using techniques from Liberating Structures and Neuro-Linguistic Programming. Jay specialises in business transformations, providing training, mentoring, coaching, and consulting to drive success through teamwork. For those pursuing the Professional Scrum Master II (PSM II) certification, Jay and the Fractal team are committed to supporting your learning journey with a range of valuable resources: Complimentary Scrum Resource Bundle Access to a PSM Exam Simulator Free PSM II Exam Coaching Sessions Personalised 1:1 Coaching At Fractal Systems, our goal is to ensure you have the support and resources needed for a successful PSM II learning experience. Our Clients Our Testimonials

IP demystified training course description A concise overview course covering TCP/IP with particular emphasis on the addressing and security issues of TCP/IP networks. What will you learn Describe TCP/IP. List the rules of IP addressing. Recognise the impact of the addressing rules on adds/moves and changes. Recognise the use of subnet masks. Explain how firewalls work. Recognise the role of DNS. IP demystified training course details Who will benefit: Anyone, although the course is particularly aimed at non-technical personnel needing some knowledge of TCP/IP. Prerequisites: Network fundamentals Duration 1 day IP demystified training course contents What is TCP/IP? What is IP? What is TCP? What is TCP/IP? Internetworking, protocols, services. The Internet, RFCs, comparison with OSI 7 layer model. Basic configuration IP addresses, subnet masks, default gateways, DHCP, ping. Addressing IP address format, rules of IP addressing, where to get IP addresses, private addresses, subnet masks, How subnet masks are used to determine network numbers. Ranges of addresses. NAT Private versus public IP addresses, NAT, NAPT. IPv6 What is IPv6, IPv6 usage, Why IPv6, 128bit IPv6 addresses, IPv6 migration, dual stack, tunnelling. Routing What is a router? how routers join networks, benefits and disadvantages of routers, default gateways, routing tables, routing protocols. Traceroute. Firewalls What is a firewall, firewall architectures, filtering, DMZ, Proxy servers, stateful packet inspection. DNS How hostnames are converted to IP addresses.

Peering demystified training course description A concise overview course covering The Internet and peering. Particular emphasis is placed on the structure of the Internet, how IXs benefit the Internet, IX architectures, peering and the technical buzzwords behind the IX services. What will you learn Describe the structure of the Internet Explain the role of RIPE, ARIN and IXs in the Internet Explain how IXs connect ISPs and the benefits of using IXs. Describe peering from a technical perspective including the role of BGP and AS's. Peering demystified training course details Who will benefit: Non technical staff working for Internet companies. Prerequisites: None. Duration 1 day Peering demystified training course contents IP and routers IP as glue. What is a router? How routers join networks, benefits and disadvantages of routers, default gateways, routing tables, routing protocols. Addressing IP address format, rules of IP addressing, where to get IP addresses. Subnetting and groups of IP addresses. The Internet What is the Internet? The big picture, IP basics, registering IP addresses, DNS and registering domain names, whois, The IAB, IANA, ICANN, RIPE and other Internet organisations. ISPs Top ISPs, Tier 1, Tier 2 and Tier 3 ISPs, backbone providers, circuit providers, content providers, virtual ISPs, the internal network of ISPs. Customer connections to ISPs (DSL, Leased lines, MPLS…) ISP to ISP connections: Peering points Public peering versus private peering, NAPs, Internet Exchanges, Metropolitan Area Exchanges, LINX, other major peering points, the geography of the Internet. BGP and ASNs. How to peer. IRRs. IX architecture Ethernet switching.

WANs training course description A concise overview course covering Wide Area Networks with particular emphasis on the WAN options available including the use of the Internet. What will you learn Choose and evaluate WAN technologies. Recognise the role of service providers. Describe the benefits of VPNs. Describe how the Internet can be used as a WAN. Describe the equipment needed to connect LANS to WANS. List the speeds of various WAN technologies. WANs training course details Who will benefit: Anyone, although the course is particularly aimed at non-technical personnel needing some knowledge of WANS. Prerequisites: Network fundamentals Duration 1 day WANs training course contents WANS WAN architecture, Common WAN terms, Core vs access, service providers, relationship with 7 layer model, WAN equipment, how to choose a WAN. Layer 1 Copper, phone lines, fibre, coaxial, satellite, wireless. Cabling to the building, CPE cabling, interfaces. Layer 2 Dial up vs. Dedicated vs. packet switched networks and when to use them. Packet switching vs. circuit switching. Point to point and point to multipoint. Dialup access technologies Modems, ISDN, BRI, PRI. Access with dedicated lines XDSL, leased lines. WAN services X.25, SMDS, Frame Relay, CIR, ATM, Internet, MANS, dark fibre and other services. Case study: Selecting WAN technologies. Service provider technologies MPLS, SDH, WDM, DWDM. Routers Network addressing, default gateways, routing tables, routing protocols. Internet architecture Service providers, ISPs, private peering, public peering, core WANs in the Internet. VPNs Private networks, public networks, What are VPNs?, benefits of VPNs, tunnelling, encryption, IPSec. Case study: Specifying WAN connectivity.

LAN training course description A concise overview course covering Local Area Networks with particular emphasis on the use of Ethernet and Wireless LANS. As well as explaining buzzwords we cover how the technology works at a simple level. After defining LANs the course moves onto Ethernet and switching also covering VLANs. WiFi is then covered, with coverage of 802.11 standards and frequencies along with integrating WiFi with Ethernet. The course then covers routers and their role in connecting networks and the course finishes with a comparison of Ethernet vs WiFi and when to use them. What will you learn Describe how Ethernet works (in simple terms) and when to use Ethernet. Explain the difference between a switch and a router. Describe how WiFi works (in simple terms). Describe the role of Access points. Evaluate wireless technologies and when to use them. List the speeds of various LAN technologies. LAN training course details Who will benefit: Sales staff, managers and other non technical staff. Prerequisites: None. Duration 1 day LAN training course contents LANS What is a LAN? LAN standards, LAN choices, choosing the media, copper, UTP, cat5e, fibre, RF, bandwidth speeds, link aggregation, Full/half duplex. Ethernet What is Ethernet? 802.3, parts of Ethernet, Ethernet evolution, MAC addresses, frames, broadcasts. Ethernet switches What are switches, switches versus hubs, how switches work, ways to configure switches, Loops, STP. VLANs What are VLANs? Why have VLANs, impact of VLANs, Tagging (aka trunking), 802.1Q Wireless LANS Type of wireless LAN, RF frequencies, 2.4GHz, 5GHz, others, interference, standards, 802.11 and variants, CSMA/CA. Wireless LANS NICs, Access points, integration with Ethernet, multiple access points, mesh networks, WiFi security. Interconnecting LANs Routers, connecting networks, interconnecting VLANs, IP addressing, Layer 3 switches. Summary WiFi vs Ethernet.