46 Data Visualization courses delivered Live Online

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/]

The insights gained from data analysis are only truly valuable when you can be clearly expressed to other people – bosses, colleagues, clients, customers, or other stakeholders. In this workshop you’ll learn how to turn raw qualitative or quantitative data into a clear visual story through infographics and data visualization. We'll discuss the key principles for planning an effective visual, look at examples of best (and worst) practice, and learn repeatable and practical design techniques for enhancing the story. We'll also give you an overview of useful tools that will help you turn your idea into a finished infographic or data visualization. You could be conjuring up eye-catching slide decks, building effective reports and dashboards, pitching to investors, or presenting persuasive data to your most important customers.  This is a fully interactive online workshop, so be prepared to join discussions and get hands on with building your own visualisations.  Takeaways * Be able to evaluate the elements that make an infographic or visualization effective. * Learn quick and repeatable visual tricks for ensuring infographics convey a clear message. * Understand how to tailor your approach to different audiences and context.  * Discover a bunch of free tools and resources to help you build your own visualizations.  * Understand how online, interactive visualizations work and how to create them. Delivery  We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets.
 Testimonials "Just to say what a great course this was. I have made my first report employing some of the ideas and tools you showed us – to rapturous responses! The next actions are clear for all and they all understood it! Thank you for helping me to organise my data and thoughts, showing how to present the key message up front, and how to keep it simple and focused. Gearing up for another report now!" Kay Anderson | Head of Finance | Mima "We have been using Tableau to display data for some time but knew we could do more to engage our end users. Alan’s training gave us a framework to start thinking about what we wanted to achieve with our visualisations and analysis, and some great tips on how to display information for maximum impact. Alan was an engaging trainer and we found the workshops very energising."   Ellen Austin | Senior Data Analyst | London School of Economics

Duration 1 Days 6 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who receive Tableau data visualizations from data analysts or from data visualization engineers. These data report recipients want to take advantage of the many Tableau features and capabilities that enable them to explore the data behind the initial analysis, perform additional analysis to ask next-level questions of the data, and to customize visualizations and dashboards to share new insights and create compelling reports. Overview Explore Tableau reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter views. Prepare reports. Troubleshoot, collaborate, and share views and analysis As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Tableau© software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed on to business data-driven decision makers. These decision makers can use Tableau's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets? LESSON 1: EXPLORING TABLEAU REPORTS * Topic A: Data Analysis Workflow with Tableau * Topic B: Explore Views * Topic C: Edit Workbooks LESSON 2: ANALYZING DATA TO GET ANSWERS AND INSIGHTS * Topic A: Configure Marks with the Marks Card * Topic B: Ask New Questions by Changing Aggregation * Topic C: Find Answers with Calculations * Topic D: Answer Questions with Table Calculations LESSON 3: SORTING AND GROUPING DATA FOR ANALYSIS AND REPORTING * Topic A: Sort Data * Topic B: Group Data LESSON 4: FILTERING VIEWS * Topic A: Filter Data to Refine Analysis * Topic B: Create Interactive Filters for Reports LESSON 5: PREPARING REPORTS * Topic A: Format and Annotate Views to Tell Your Story * Topic B: Emphasize Data in Reports * Topic C: Animate Visualizations for Clarity LESSON 6: TROUBLESHOOTING, SHARING, AND COLLABORATING * Topic A: Troubleshoot Data Issues * Topic B: Collaborate in Tableau Online * Topic C: Collaborate with Non-Tableau Users

Duration 2 Days 12 CPD hours This course is intended for This course is relevant to anyone who needs to work with and understand data including: Business Analysts, Data Analysts, Reporting and BI professionals Marketing and Digital Marketing professionals Digital, Web, e-Commerce, Social media and Mobile channel professionals Business managers who need to interpret analytical output to inform managerial decisions Overview This course will cover the basic theory of data visualization along with practical skills for creating compelling visualizations, reports and dashboards from data using Tableau. Outcome: After attending this course delegates will understand - How to move from business questions to great data visualizations and beyond How to apply the fundamentals of data visualization to create informative charts How to choose the right visualization type for the job at hand How to design and develop basic dashboards in Tableau that people will love to use by doing the following: Reading data sources into Tableau Setting up the roles and data types for your analysis Creating new data fields using a range of calculation types Creating the following types of charts - cross tabs, pie and bar charts, geographic maps, dual axis and combo charts, heat maps, highlight tables, tree maps and scatter plots Creating Dashboards that delight using the all of the features available in Tableau. The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to tourism. FROM BUSINESS QUESTIONS TO DATA VISUALISATION AND BEYOND * The first step in any data analysis project is to move from a business question to data analysis and then on to a complete solution. This section will examine this conversion emphasizing: * The use of data visualization to address a business need * The data analytics process ? from business questions to developed dashboards INTRODUCTION TO TABLEAU ? PART 1 * In this section, the main functionality of Tableau will be explained including: * Selecting and loading your data * Defining data item properties * Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations * Creating basic visualizations * Creating a basic dashboard INTRODUCTION TO TABLEAU ? PART 2 * In this section, the main functionality of Tableau will be explained including: * Selecting and loading your data * Defining data item properties * Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations * Creating basic visualizations * Creating a basic dashboard * KEY COMPONENTS OF GOOD DATA VISUALISATION AND THE VISUALISATION ZOO * In this section the following topics will be covered: * Colour theory * Graphical perception & communication * Choosing the right chart for the right job DATA EXPLORATION WITH TABLEAU * Exploring data to answer business questions is one of the key uses of applying good data visualization techniques within Tableau. In this section we will apply the data visualization theory from the previous section within Tableau to uncover trends within the data to answer specific business questions. The types of charts that will be covered are: * Cross Tabs * Pie and bar charts * Geographic maps * Dual axis and combo charts with different mark types * Heat maps * Highlight tables * Tree maps * Scatter plots INTRODUCTION TO BUILDING DASHBOARDS WITH TABLEAU * In this section, we will implement the full process from business question to final basic dashboard in Tableau: * Introduction to good dashboard design * Building dashboards in Tableau

Duration 1 Days 6 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who receive Power BI data visualizations and reports from data analysts or from data visualization engineers. These data report recipients want to use the features and capabilities of Power BI to fully explore the visualizations and initial analyses provided to them in reports, perform additional analysis to ask next-level questions of the data, and to customize and create new visualizations and dashboards in order to share new insights and create compelling reports. Overview Explore Power BI reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter visualizations. Prepare reports. Troubleshoot, collaborate, and share reports. As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings. Prerequisites To ensure your success in this course, you have experience managing data with Microsoft Excel or Google Sheets 1. EXPLORING POWER BI REPORTS * Topic A: Data Analysis Workflow with Power BI * Topic B: Explore Reports in the Power BI Service * Topic C: Edit Reports 2. ANALYZING DATA TO GET ANSWERS AND INSIGHTS * Topic A: Configure Data Visualizations * Topic B: Ask New Questions by Changing Aggregation * Topic C: Find Answers with Calculations 3. SORTING AND GROUPING DATA FOR ANALYSIS AND REPORTING * Topic A: Sort Data * Topic B: Group Data 4. FILTERING VISUALIZATIONS * Topic A: Filter Data to Refine Analysis * Topic B: Create Slicers for Reports 5. PREPARING REPORTS * Topic A: Format and Annotate Reports * Topic B: Emphasize Data in Reports 6. TROUBLESHOOTING, SHARING, AND COLLABORATING * Topic A: Troubleshoot Data Issues * Topic B: Collaborate in Power BI * Topic C: Collaborate with Non-Power BI Users

Duration 1 Days 6 CPD hours This course is intended for The Power BI in a Day course is designed for beginners and intermediate users of Power BI. Overview #NAME? Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Please Note: This workshop is primarily self-directed and students will work at their own pace while having access to an instructor for questions. 1 - ACCESSING & PREPARING DATA * Data Set * Power BI Desktop * Power BI Desktop ? Accessing Data * Power BI Desktop ? Data Preparation 2 - DATA MODELING AND EXPLORATION * Power BI Desktop ? Data Modeling and Exploration * Power BI Desktop ? Data Exploration Continued * References 3 - DATA VISUALIZATION * Power BI Desktop * Power BI Desktop ? Data Visualization * References 4 - PUBLISHING & ACCESSING REPORTS * Power BI Desktop ? Creating Mobile View * Power BI Service * Power BI Service ? Publishing Report * Power BI Mobile ? Accessing Report on Mobile Device * Power BI Service ? Collaboration and Distribution * References 5 - DASHBOARD AND COLLABORATION * Power BI Service * Building Dashboard * References ADDITIONAL COURSE DETAILS: Nexus Humans Power BI: Dashboard in a Day training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Power BI: Dashboard in a Day course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Overview Describe core data concepts Identify considerations for relational data on Azure Describe considerations for working with non-relational data on Azure Describe an analytics workload on Azure In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization. 1 - EXPLORE CORE DATA CONCEPTS * Identify data formats * Explore file storage * Explore databases * Explore transactional data processing * Explore analytical data processing 2 - EXPLORE DATA ROLES AND SERVICES * Explore job roles in the world of data * Identify data services 3 - EXPLORE FUNDAMENTAL RELATIONAL DATA CONCEPTS * Understand relational data * Understand normalization * Explore SQL * Describe database objects 4 - EXPLORE RELATIONAL DATABASE SERVICES IN AZURE * Describe Azure SQL services and capabilities * Describe Azure services for open-source databases 5 - EXPLORE AZURE STORAGE FOR NON-RELATIONAL DATA * Explore Azure blob storage * Explore Azure DataLake Storage Gen2 * Explore Azure Files * Explore Azure Tables 6 - EXPLORE FUNDAMENTALS OF AZURE COSMOS DB * Describe Azure Cosmos DB * Identify Azure Cosmos DB APIs 7 - EXPLORE FUNDAMENTALS OF LARGE-SCALE DATA WAREHOUSING * Describe data warehousing architecture * Explore data ingestion pipelines * Explore analytical data stores 8 - EXPLORE FUNDAMENTALS OF REAL-TIME ANALYTICS * Understand batch and stream processing * Explore common elements of stream processing architecture * Explore Azure Stream Analytics * Explore Apache Spark on Microsoft Azure 9 - EXPLORE FUNDAMENTALS OF DATA VISUALIZATION * Describe Power BI tools and workflow * Describe core concepts of data modeling * Describe considerations for data visualization

Duration 2 Days 12 CPD hours Overview Identify and configure basic functions of Tableau. Connect to data sources, import data into Tableau, and save Tableau files Create views and customize data in visualizations. Manage, sort, and group data. Save and share data sources and workbooks. Filter data in views. Customize visualizations with annotations, highlights, and advanced features. Create and enhance dashboards in Tableau. Create and enhance stories in Tableau As technology progresses and becomes more interwoven with our businesses and lives, more and more data is collected about business and personal activities. This era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Tableau's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets?. LESSON 1: TABLEAU FUNDAMENTALS * Topic A: Overview of Tableau * Topic B: Navigate and Configure Tableau LESSON 2: CONNECTING TO AND PREPARING DATA * Topic A: Connect to Data * Topic B: Build a Data Model * Topic C: Save Workbook Files * Topic D: Prepare Data for Analysis LESSON 3: EXPLORING DATA * Topic A: Create Views * Topic B: Customize Data in Visualizations LESSON 4: MANAGING, SORTING, AND GROUPING DATA * Topic A: Adjust Fields * Topic B: Sort Data * Topic C: Group Data LESSON 5: SAVING, PUBLISHING, AND SHARING DATA * Topic A: Save Data Sources * Topic B: Publish Data Sources and Visualizations * Topic C: Share Workbooks for Collaboration LESSON 6: FILTERING DATA * Topic A: Configure Worksheet Filters * Topic B: Apply Advanced Filter Options * Topic C: Create Interactive Filters LESSON 7: CUSTOMIZING VISUALIZATIONS * Topic A: Format and Annotate Views * Topic B: Emphasize Data in Visualizations * Topic C: Create Animated Workbooks * Topic D: Best Practices for Visual Design LESSON 8: CREATING DASHBOARDS IN TABLEAU * Topic A: Create Dashboards * Topic B: Enhance Dashboards with Actions * Topic C: Create Mobile Dashboards LESSON 9: CREATING STORIES IN TABLEAU * Topic A: Create Stories * Topic B: Enhance Stories with Tooltips

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.

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.