This one day course has been developed to teach essential real estate financial modelling theory, functions and formulas to individuals working in the real estate sector.
An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. OBJECTIVES By the end of the course you will be able to: * Build and customise Pivot Tables * Group and sort information * Filter information * Use slicers and the timeline filter * Add different summary calculations * Create Pivot Charts * Add calculated fields and items CONTENT THE ANATOMY OF A PIVOT TABLE * Using a Pivot Cache * Building a Pivot Table * The Pivot Table interface * Refreshing the Pivot Table * Adding column, row, page and data fields * Changing data orientation * Showing data fields in columns or rows * Drilling down to underlying data SETTING PIVOT TABLE OPTIONS * Format options * Totals and filters options * Display and printing options * Data options CUSTOMISING PIVOT TABLES * Modifying field names * Data formatting * Changing field layout options * Changing summary calculations * Working with subtotals FILTERING AND SORTING * Filtering items * Sorting data * Value and label filters * Creating top 10 reports * Using the Search filter * Using the Slicer tool * Use the Timeline filter GROUPING * Grouping date fields * Grouping numeric fields * Adding your own groups SUMMARY CALCULATIONS * Running totals * Differences year on year, month on month * % Differences year on year, month on month * % of Row, Column, Total and other fields PIVOT CHARTS * Pivot Chart rules * Creating a Pivot Chart * Working with your Pivot Chart CREATING CALCULATIONS * Adding calculated fields * Adding calculated items
OVERVIEW Prerequisites—DIAD training or equivalent working experience This one-day course will cover Power BI report layouts and structure the agile process to creating Power BI data visualizations. It will help attendees to understand the art behind visualizations, the implications behind choosing the right charts, the impact of color, shape, and size, and finally the use of Power BI custom visuals. The course includes various design patterns of dashboards and reports, as well as best practices for authoring great reports and dashboards for business users. The course content is managed by the Power BI engineering team at Microsoft. There is no exam associated with the course. COURSE BENEFITS: * Understand the need for storytelling with data * Understand the agile process to creating Power BI data visualizations * Understand the art behind visualizations * Gain familiarity with Power BI report layouts and structure * Understand implications behind choosing the right charts * Gain familiarity with using Power BI custom visuals WHO IS THE COURSE FOR? * Power BI report developers who wish to improve the aesthetic quality of their reports * Power BI and other BI practitioners who would like to understand more about the theory of data visualization * BI practitioners who wish to create reports that communicate the meaning behind the data more clearly * Power BI users who would like to explore the types of chart and visual available that answer different types of business question COURSE OUTLINE Module 1 What Is Storytelling With Data? * Volume, Velocity and Variety * The importance of business questions * What is a story in this context? Module 2 The Science Behind Data Visualization * Basic problems to avoid * Memory and visualization * Ways to spark iconic, short-term and long-term memory Module 3 The Process Behind Data Visualization * Using an agile approach to report development * Data structure and data grain * Converting the story to a data model Module 4 Dashboards And Reports * Terminology and definitions * Dashboard layout and structure * Report layout and structure * Storyboarding * Drill-through, bookmarks, toggles and tooltips Module 5 Chart Selection * Charts for comparison * Time series * Proportions * Constructing effective tables, cards and slicers * Scatterplots Module 6 Accessibility And Custom Visuals * Report accessibility checklists * Custom visuals * Creating a custom R visual * Charticulator Module 7 Publishing And Formatting * Colour schemes * Making a Power BI theme * Use of fonts, icons and symbols * Sizing dashboard and report tiles * Sparklines, hyperlinks and images Module 8 Report Authoring - Best Practices * Design thought process * The audience * Defining the platform environment * The user experience * Visualization * Implementation and testing * Optimization Module 9 Dashboard And Goals Design * Tips and tricks * Best practices for dashboard design * Tracking business metrics with goals
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
AUDIENCE This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS. PREREQUISITES You should have practical experience with Db2 for z/OS DURATION 2 days. COURSE OBJECTIVES Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS. COURSE CONTENT * Unit 1: Db2 v12 Function Levels: Selected Highlights * Unit 2: Migrating to Db2 13 * Unit 3: Availability & Scalability * Unit 4: Performance * Unit 5: Application Management and SQL Changes * Unit 6: SQL Data Insights * Unit 7: Security * Unit 8: IBM Db2 Utilities * Unit 9: Instrumentation and Serviceability
Bayfield Training and the University of Cambridge Department of Land Economy This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise. If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you. This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses. Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment. ON THIS COURSE YOU WILL: * Become a competent model builder, building Real Estate Financial Models from scratch * Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia * Learn how to use Real Estate Financial Models to make informed investment decisions * Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill THIS COURSE IS SUITABLE FOR: * Chartered Surveyors * Asset Managers * Financial Controllers * Financial Analysts * Investment Managers * Property Managers * Real Estate Students/Recent Graduates Course Outline: Module 1 - Economic Context Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. * Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. * Why Real Estate Asset Modelling is important * Understanding the occupier, asset and development markets and the relevant modelling approaches for each * Real Estate Sub-Sector Key Performance Indicators * Introduction to conventional valuations and financial mathematics * Understanding and minimising errors in Financial Models Module 2 - Cash Flow Fundamentals Constructing a financial model from first principles. * Understanding all the components of a basic cash flow model * Understand why Corporate Finance Models and Real Estate Models are different * Financial Model Design * Making the link between valuations, income mathematics and discounted cash flows * Internal Rate of Return, Net Present Value,Worth and other metrics * Features and techniques to aid fast model building Module 3 - Developing the Cash Flow Adapting financial models for different periodicities and building rent functions for different rent behaviour. * Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc. * Developing the concept of a Rent Function in Excel * Logic mathematics and Logic functions * Projecting rent to adapt to different lease contracts and growth patterns * Alternative solutions to Logic functions * Comparative analysis of lease structures in different jurisdictions and adapting financial models Module 4 - Real Estate Data Understanding the different sources of data, constructing basic time series models and recognising basic patterns. * Key Property market indicators * Characteristics and application of key input metrics for Real Estate Appraisals * Understanding the eight components of Real Estate Price Dynamics * Awareness of the different sources of data * Reading and using general property market reports * Constructing basic time series models and recognising basic patterns Module 5 - Development Appraisals Constructing a development appraisal from first principles and understanding development return metrics. * Understanding the key components of a development project * Understanding the difference between development and investment appraisals * Residual Appraisals and Profit Calculations * Cost orientated cash flows and phased sales * Cumulative construction cost patterns: incidental, fixed, loaded and S-curve * Development return metrics and Modified IRRs Module 6 - Multi-let Cash Flows Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions. * Multi-let and portfolio model design principles * Building complex date functions and date series * The three multi-let rent projection techniques * Perpendicular Rent Functions * Incorporate advanced rent adjustments into the Rent Function * Incorporate sector and period varying rental growth rates * Simplifying OPEX and CAPEX projections * Discounting techniques on complex and volatile cash flows Module 7 - Project Finance Constructing a flexible Real Estate Debt Finance model. * Revision of the Mathematics of amortisation and debt finance * Basic senior debt models and geared net cash flow * LTV, IRR and Interest Rate Dynamics * Flexible term, repayment options and deferred interest * Loan covenant tests * Understanding different tranches of debt * Understanding how complex debt structures impact the returns to different parties Module 8 - Model Interpretation and Risk Analysis Learn how to read, analyse and report on real estate financial models. * Understand how to read models and develop an investment narrative * Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards * Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins * Learn how to construct varied project scenarios in a systematic way * Introduction to Monte Carlo Analysis and VBA * Optimising sale dates and other parameters * Create well written, attractive and persuasive reports Included in the Course * Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge * 64 CPD Hours * 1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee * Course Files * Q&A Webinars and Guest Speaker Webinars * Further Learning Resources (Reading, Files and Videos) * Post Course Support - Two Months of Questions & Answers 2024 Cohort Dates Include: * 3rd June to 29th July * 5th August to 25th September 2024 * 30th September to 25th November For more information, please contact Sam on the Bayfield Training Sales team: E - s.musgrave@bayfieldtraining.com T - 01223 517851 W - www.bayfieldtraining.com [https://www.bayfieldtraining.com/]
This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.
Bitesize Masterclass on AI - facilitated by Fiona Young, Leading Expert and Trainer. Are you a total beginner to AI? Or maybe you've dabbled but found it all overwhelming...or underwhelming? Then this bitesize masterclass on AI is for you! We'll be covering AI fundamentals, what AI means for exec support roles, and practically how to use AI chatbots (like ChatGPT and Copilot) to shortcut admin drudgery. You’ll come away from this session with the confidence and skills to start using AI in your workflow right away, making you more efficient and giving you time back to do more of the human work you love. Note that this is NOT a passive webinar — we'll have demos, discussions and breakouts. You'll get a chance to practice using AI chatbots in the room for real world projects with other forward-thinking assistants like you. Here's a detailed breakdown of session content: AI fundamentals • Defining AI, gen AI and other need to know terms • Key AI risks to be aware of • Exciting tools for assistants right now How AI will change the assistant role • Explore our feelings about AI right now • Some predictions on what AI means for the future of exec support • What you can do to win in the age of AI A practical guide to using ChatGPT and LLMs at work • How to use AI chatbots in your workflow • How to craft great prompts to optimise outputs • A chance to practice & workshop prompting in the room Fiona Young is founder of Carve, a series of live digital courses for executive assistants to learn AI, create capacity and develop into a strategic assistant — carving out their career growth in the process. Before launching Carve, Fiona spent five years leading learning programs at Hive Learning, the b2b peer learning app. She previously ran Learning & Development for Blenheim Chalcot, one of the world’s most successful venture builders, overseeing group learning strategy and programs for 3,000 people across 25 ventures. Fiona started her career as an executive assistant in entrepreneurial businesses.
OVERVIEW -------------------------------------------------------------------------------- This Course is specially designed to enhance communication skills and gain advanced skills in office management. It will help identify key features of the role and will navigate through all the components and techniques for operating an efficient support team. This course will update your interpersonal skills, communication skills and other skills required to have effective office management and gain advanced administrative skills.
MYSQL PERFORMANCE & TUNING TRAINING COURSE DESCRIPTION This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. WHAT WILL YOU LEARN * Develop a monitoring and tuning plan * Use server configuration and status variables. * Identify and improve problem queries. * Make efficient use of indexes. * Monitor and size memory caches and locks. * Tune the MyISAM and InnoDB storage engine. * Evaluate the use of partitioning for performance. MYSQL PERFORMANCE & TUNING TRAINING COURSE DETAILS * Who will benefit: Anyone who wishes to monitor and tune MySQL performance. * Prerequisites: Delegates must have a working knowledge of MySQL Database Administration * Duration 3 days MYSQL PERFORMANCE & TUNING TRAINING COURSE CONTENTS * Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. * MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. * Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. * Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. * Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. * Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. * Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. * The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. * Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. * Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. * Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. * Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.