Increasing Real Estate Management Profits: Harnessing Data Analytics
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.
Buy Now AED 274.99 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 23 hours
- Course by Duke University
-
Offered by
About
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."Modules
Welcome!
-
1
Videos
-
4
Readings
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
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
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
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
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
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
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
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
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
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
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
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
1
Readings
- How to Get Started Making Your Dashboard
Make Your Sensitivity Analysis Dashboard
-
3
Videos
-
1
Readings
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
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
1
Readings
- Turning Your Sensitivity Analysis into a Recommendation
Preparing Your Dashboard for Decision-makers
-
2
Readings
-
1
Assignment
1
Assignment
- Sensitivity Analysis
2
Readings
- Finalizing Your Dashboard
- Tableau Tricks to Try on Your Own (Including R Integration!)
About
-
1
Videos
-
2
Readings
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
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
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
Jana Schaich Borg