Buy Now AED 274.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Increasing Real Estate Management Profits: Harnessing Data Analytics
  • Level Foundation
  • المدة 23 ساعات hours
  • الطبع بواسطة Duke University
  • Offered by

عن

In this final course you will complete a Capstone Project using data analysis to recommend a method for improving profits for your company, Watershed Property Management, Inc. Watershed is responsible for managing thousands of residential rental properties throughout the United States. Your job is to persuade Watershed's management team to pursue a new strategy for managing its properties that will increase their profits. To do this, you will: (1) Elicit information about important variables relevant to your analysis; (2) Draw upon your new MySQL database skills to extract relevant data from a real estate database; (3) Implement data analysis in Excel to identify the best opportunities for Watershed to increase revenue and maximize profits, while managing any new risks; (4) Create a Tableau dashboard to show Watershed executives the results of a sensitivity analysis; and (5) Articulate a significant and innovative business process change for Watershed based on your data analysis, that you will recommend to company executives. Airbnb, our Capstone's official Sponsor, provided input on the project design. The top 10 Capstone completers each year will have the opportunity to present their work directly to senior data scientists at Airbnb live for feedback and discussion. "Note: Only learners who have passed the four previous courses in the specialization are eligible to take the Capstone."

الوحدات

Welcome!

    • 1 Videos
    • 4 Readings
Show info about module content

1 Videos

  • Introduction to the Capstone Project

4 Readings

  • Course Overview
  • Special Thanks!
  • About the Course Team
  • FAQ (Frequently Asked Questions)

Preparing for Elicitation

    • 1 Videos
    • 5 Readings
    • 1 PeerReview
Show info about module content

1 Peer Review

  • Your Three Elicitation Interviews

1 Videos

  • What Watershed Owners Care About

5 Readings

  • Lesson Overview
  • Elicitation Refresher
  • Letter from Your Project Manager
  • What are Project Managers, Anyway?
  • Background about the Short-term Rental Industry

Elicitation Interviews

    • 3 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Elicitation

3 Videos

  • Elicitation Interview with Your Project Manager
  • Elicitation Interview with Watershed's Marketing Director
  • Elicitation Interview with Watershed's Financial Director

3 Readings

  • Lesson Overview
  • Outlining an SPAP
  • Requirements and Assumptions

Getting to Know Your Data

    • 1 Videos
    • 1 Readings
    • 1 Lab
    • 1 Assignment
Show info about module content

1 Assignment

  • Verify You Have Extracted the Correct Data

1 Labs

  • How to Meet and Retrieve Your Data (Jupyter Notebook)

1 Videos

  • Meet Your Data

1 Readings

  • How to Meet and Retrieve Your Data

Visualizing Your Data

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Make Sure You Understand What Your Data Mean

1 Readings

  • Visualize Your Data to Make Sure You Know What They Are

Modeling

    • 1 Videos
    • 6 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • First Best-Fit Line

1 Videos

  • Creating a Predictive Model for Short-term Rental Rates

6 Readings

  • Week 3 Learning Goals
  • Single Workbook Containing Template Spreadsheets 1-3
  • Single Workbook Containing Guide Spreadsheets
  • Best Practices for Setting up an Excel Spreadsheet
  • Using the First Best-Fit Line Template Spreadsheet
  • First Best Fit Line Template (Spreadsheet 1)

Normalization

    • 2 Videos
    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Normalization
  • Applying Normalization to the Comparable Properties

2 Videos

  • Normalizing Rents to Improve Occupancy Forecasting
  • Using the Dollars to Percentile Conversion Guide Spreadsheet

4 Readings

  • Using the Normalized Data and Model Template Spreadsheet
  • Normalized Data and Model Template (Spreadsheet 2)
  • Dollars to Percentile Conversion Guide Spreadsheet
  • Applying Normalization to the Comparable Properties

Optimization

    • 2 Videos
    • 5 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Optimization Basics
  • Optimizing Watershed Rents

2 Videos

  • Optimizing Rents to Maximize Revenues
  • Using the Solver Revenue Maximization Guide Spreadsheet

5 Readings

  • Lesson Overview
  • Solver Revenue Maximization Guide Spreadsheet
  • Optimizing Watershed Rents
  • Solver Rent Optimization Template (Spreadsheet 3)
  • Alternative to Solver Template (Spreadsheet 4)

Alternatives to Solver

    • 1 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Alternative to Solver

1 Videos

  • Estimating Watershed Cash Flow and Profits

3 Readings

  • Week 4 Learning Goals
  • Single Workbook Containing Template Spreadsheets 5-6
  • Using the Alternative to Solver Template Spreadsheet

Financial Modeling

    • 2 Videos
    • 5 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Profitability

2 Videos

  • Distinguishing Cash Flow from Profits and Losses
  • Using the Annual Cash Flows and Profits Spreadsheet

5 Readings

  • Using the Forecasting Cash Flow and Profits Template Spreadsheet
  • Forecasting Cash Flow and Profits Template (Spreadsheet 5)
  • Annual Cash Flows and Profits Guide Spreadsheet
  • Using the Sorting by Profitability Template Spreadsheet
  • Sorting by Profitability Template (Spreadsheet 6)

Risk

    • 2 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Cash Flow Risk and Total Cash Required
  • Sensitivity Analysis: Measuring Cutoffs at 40% Transaction Fee

2 Readings

  • The Value of Considering Cash Flow Risk and Total Cash Required
  • The Value of Financial Sensitivity Analysis in General

Using Tableau Dashboards for Sensitivity Analysis

    • 3 Videos
Show info about module content

3 Videos

  • Using Tableau to Perform Sensitivity Analysis
  • Dashboard for Analyst Use
  • Dashboard Modification for a Financial Audience

Replicate your Excel Results in Tableau

    • 1 Readings
Show info about module content

1 Readings

  • How to Get Started Making Your Dashboard

Make Your Sensitivity Analysis Dashboard

    • 3 Videos
    • 1 Readings
Show info about module content

3 Videos

  • Bar in Bar Graphs in Tableau
  • Histograms in Tableau
  • Tables in Tableau

1 Readings

  • Additional charts for your sensitivity analysis

Visualizing the Location of Watershed Properties using Spatial “Jittering”

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • Preparing Your Dashboard for Decision-makers
  • Jittered Maps in Tableau

2 Readings

  • Lesson Overview
  • How to Use Jittering to Depict Multiple Data Points in the Same Geographic Location

Turning Your Sensitivity Analysis in a Recommendation

    • 1 Readings
Show info about module content

1 Readings

  • Turning Your Sensitivity Analysis into a Recommendation

Preparing Your Dashboard for Decision-makers

    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Sensitivity Analysis

2 Readings

  • Finalizing Your Dashboard
  • Tableau Tricks to Try on Your Own (Including R Integration!)

About

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Persuading Decision-makers to Follow Your Recommendations

2 Readings

  • New Information from Your Project Manager!
  • White Paper Background Information

Preparation for the Final Project

    • 4 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • A Very Important Question!

4 Readings

  • About the Final Project
  • PART I: Tableau Dashboard Instructions
  • PART 2: White Paper Instructions
  • PART 3: Presentation Instructions

Final Project: Remember to have your dashboard URL, completed white paper and presentation URL before proceeding!

    • 1 Videos
    • 1 PeerReview
Show info about module content

1 Peer Review

  • Final Project Assignment Submission

1 Videos

  • Congratulations on Joining the Exciting Field of Data Analytics!

Auto Summary

Unlock the potential of data analytics to boost real estate management profits with this comprehensive course. Led by Coursera, this data science and AI-focused program guides you through a Capstone Project for Watershed Property Management, Inc. Over 1380 minutes, you'll master MySQL, Excel, and Tableau to analyze and present data-driven strategies. Ideal for foundational learners, the course offers Starter, Professional, and Paid subscription options. Top performers may present their projects to Airbnb's senior data scientists. Prior completion of four specialization courses is required.

Daniel Egger
Instructors

Daniel Egger

Jana Schaich Borg
Instructors

Jana Schaich Borg