Visualisation Techniques for Real Estate Models

Bayfield Training

Course

In London

Price on request

The best IT Systems courses

See all

See all

Description

  • Type

    Intensive workshop

  • Level

    Advanced

  • Methodology

    Inhouse

  • Location

    London

  • Duration

    2 Days

  • Start date

    Different dates available

Learn how to visualise your real estate investment model in Excel. Visualisations help your proposal stand out, but did you know they can also help you find insights otherwise obscured by sheets of data. This unique course will show you how to effectively communicate Real Estate return metrics with the appropriate images, visual quantities, charts and graphics. You will also learn how to audit yours and others’ cash flow models using visual analytical techniques. All of which can be achieved to a sophisticated degree within Excel. From dynamic dashboards to advanced manipulation of lease data, this course will help delegates create powerful yet meaningful charts for their investment presentations.

Important information

Documents

  • Visualisation Techniques for Real Estate Models.pdf

Facilities

Location

Start date

London
See map

Start date

Different dates availableEnrolment now open

About this course

Understand the power and limits of visualisations
Learn which visualisations are appropriate to which situations
Learn advanced charting tools and work arounds to build the visualisations you need
Build dynamic dashboards to help you explore your data
Learn techniques to visually interrogate your cash flows for actionable insights
Create ‘board ready’ presentations from your financial model
Use maps, images and infographics to tell a story

Real Estate Analysts
Financial Model, Project and Deal Auditors
Real Estate Consultants
Investors who wish to extract meaning from cash flow models
Agents expressing deal information in an appealing way
Lenders analysing risk in cash flow models
Fund Managers looking for actionable insights in their models
Researchers looking for new ways to present their data

We received your request and will get back to you with a response as soon as possible.
If you have any further questions, please contact us by email: R.Augustiniene@bayfieldtraining.com.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Visualisation
  • Cash Flow
  • Investment
  • Real Estate
  • MS Excel
  • Analysts
  • Financial
  • Deal Auditors
  • Consultants
  • Information
  • Agents

Teachers and trainers (1)

Bayfield Training

Bayfield Training

Proviider

Course programme

DAY ONE

Communicating Quantities
• Leveraging the power of the eyes and the brain
• Graphical perception or the science behind choosingthe right graph
• Characteristics of effective graphical displays
• Data Visualisation technologies
• Data Relationships: Linear vs Non-Linear
• Types of Data Sets: Static vs. Dynamic

Visualisation of Real Estate Cash Flows
• Lease Data:
- Property Details, Lease Details and AssetManagement Data
- Units, Limits, Input Ranges and Validations
- Working with names, tables and filters- Cleaning Data and Error Checking
• Summary Statistics for Tenancy Schedules
• Standard Chart Tools- Advanced formatting of Line Pie and Bar Charts
- Scatter and Bubble Charts
• Summary Statistics for Return metrics

Advanced Data Manipulation and Charts
• Pivot Tables
- Pivot Tables and Pivot Charts
- Slicers and Dashboards- Conditionally Formatted Charts
• Specialist Charts and Techniques
- CFS Windows- Leasing Bars
- Icons and Metaphors
- Time Lines and Cycle Charts
- Expressing Relationships
- Sparklines
- Retail Quilts
- Distribution Waterfalls

Adding Context and telling a Story
• Adding dynamic, and context sensitive, images
• Locating Property Portfolios on a map
• Using Infographics to explain a cash flow model
• Using add-ins and other programs to enhance yourpresentation

See related categories

Visualisation Techniques for Real Estate Models

Price on request

The best IT Systems courses

See all

See all