1988 Courses in Birmingham

Overview 2 day course on scorecards, rating agency frameworks, regulation and integration and quantification of Environmental, Social and Governance (ESG) analysis into equity and credit investing / lending for / to corporates, banks and other financial institutions, applied to many case study companies and industries Who the course is for Investors and analysts – equity and credit; public and private Bank loan officers M&A advisors Restructuring advisors Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview 2 day course on key interest rate derivative products, covering both theory (product mechanics, market conventions and valuation) and practice (wide range of applications for wide range of market participants showcased) Who the course is for Interest rate traders, salespeople and quants Asset-liability management staff with banks and insurance companies Fixed income and credit asset managers / hedge funds / pension funds / insurance companies Corporate treasurers Risk management Anyone using interest rate derivatives Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview The first half of the course will cover all the essential tools of the currency markets – spot FX, forwards, FX swaps and NDFs. We look both at the pricing of these products and also how customers use them. The afternoon session will cover a range of important topics beyond the scope of an elementary course on currency options. We start with a quick review of the key concepts and terminology, and then we look at the key exotics (barriers and digitals) and how they are used to create the most popular customer combinations. We move on to look at the currently most-popular 2nd generation exotics, such as Accumulators, Faders and Target Redemption structures. Who the course is for FX Sales, traders, structurers, quants Financial engineers Risk Managers IT Bank Treasury ALM Central Bank and Government Treasury Funding managers Insurance Investment managers Fixed Income portfolio managers Regulators Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview The objective of this course is to equip professionals with comprehensive knowledge and practical skills in WEB 3 technologies and crypto assets. Participants will gain a deep understanding of the underlying principles of blockchain, the operational mechanics of cryptocurrencies, the potential impact of these technologies on the banking sector and the latest trends. Who the course is for Consultants Analysts Managers C-Level executives People in need of knowledge to develop a blockchain strategy People working with blockchain projects Regulators Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Overview A comprehensive and practical 3 days workshop on pricing, using and managing structured interest rate derivatives. What used to be called exotic interest rate derivatives are now commonplace and an essential part of the financial marketplace either as legacy transactions or embedded in new structures. This intensive course is for anyone who wishes to be able to use, price, manage, market or evaluate standard interest rate derivatives such as Constant Maturity Swaps, Range Accruals and Quantos. We also look in detail at such important products as CMS spread-linked structures and volatility/variance swaps, always from a pragmatic practitioner’s perspective. Who the course is for This course is designed for anyone who wishes to be able to price, use, market, manage or evaluate interest rate derivatives. Interest-rate sales / traders / structurers / quants IT Bank Treasury ALM Central Bank and Government Treasury Funding managers Insurance Investment managers Fixed Income portfolio managers IPV professionals Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview Learn in detail about Exotic Options – Taxonomy, Barriers, and Baskets Who the course is for Fixed Income sales, traders, portfolio managers Bank Treasury Insurance Pension Fund ALM employees Central Bank and Government Funding managers Risk managers Auditors Accountants Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview Learn about contract triggers, including European vs. American style, and variations like one-touch, no-touch, and double no-touch options. Who the course is for Risk managers IT System developers Traders and derivatives teams Consultants and brokers Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview Interest Rate Options are an essential part of the derivatives marketplace. This 3-Day programme will equip you to use, price, manage and evaluate interest rate options and related instruments. The course starts with a detailed review of option theory, from a practitioner’s viewpoint. Then we cover the key products in the rates world (caps/floors, swaptions, Bermudans) and their applications, plus the related products (such as CMS) that contain significant ’hidden’ optionality. We finish with a detailed look at the volatility surface in rates, and how we model vol dynamics (including a detailed examination of SABR). The programme includes extensive practical exercises using Excel spreadsheets for valuation and risk-management, which participants can take away for immediate implementation Who the course is for This course is designed for anyone who wishes to be able to price, use, market, manage or evaluate interest rate derivatives. Interest-rate sales / traders / structurers / quants IT Bank Treasury ALM Central Bank and Government Treasury Funding managers Insurance Investment managers Fixed Income portfolio managers Course Content To learn more about the day by day course content please request a brochure To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

This course looks at the key processes in supply chains and how they interact; the most common supply chain terms and how they are utilised to describe supply chain activities. It will cover the definitions of transport modes and how to select the most appropriate one; the role of logistics partners in the extended supply chain and the definition and use of Incoterms. PARTICIPANTS WILL LEARN HOW TO: Explain the term “Supply Chain” Define main activities in Transport & Freight Management Describe the key principles of Warehousing Interpret INCOTERMS COURSE TOPICS INCLUDE: Freight terminology & global trade terminology Warehouse, logistics and transport operations Transport modes Parties involved in international shipments INCOTERMS Freight calculations