Duke University - Increasing Real Estate Management Profits: Harnessing Data Analytics
- Offered byCoursera
Increasing Real Estate Management Profits: Harnessing Data Analytics at Coursera Overview
Duration | 23 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Increasing Real Estate Management Profits: Harnessing Data Analytics at Coursera Highlights
- 27% started a new career after completing these courses.
- Earn a shareable certificate upon completion.
- Flexible deadlines according to your schedule.
Increasing Real Estate Management Profits: Harnessing Data Analytics at Coursera Course details
- 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."
Increasing Real Estate Management Profits: Harnessing Data Analytics at Coursera Curriculum
Introduction
Introduction to the Capstone Project
What Watershed Owners Care About
Elicitation Interview with Your Project Manager
Elicitation Interview with Watershed's Marketing Director
Elicitation Interview with Watershed's Financial Director
Course Overview
Special Thanks!
About the Course Team
FAQ (Frequently Asked Questions)
Lesson Overview
Elicitation Refresher
Letter from Your Project Manager
What are Project Managers, Anyway?
Background about the Short-term Rental Industry
Lesson Overview
Outlining an SPAP
Requirements and Assumptions
Elicitation
Data Extraction and Visualization
Meet Your Data
How to Meet and Retrieve Your Data
Visualize Your Data to Make Sure You Know What They Are
Verify You Have Extracted the Correct Data
Make Sure You Understand What Your Data Mean
Modeling
Creating a Predictive Model for Short-term Rental Rates
Normalizing Rents to Improve Occupancy Forecasting
Using the Dollars to Percentile Conversion Guide Spreadsheet
Optimizing Rents to Maximize Revenues
Using the Solver Revenue Maximization Guide Spreadsheet
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)
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
Lesson Overview
Solver Revenue Maximization Guide Spreadsheet
Optimizing Watershed Rents
Solver Rent Optimization Template (Spreadsheet 3)
Alternative to Solver Template (Spreadsheet 4)
First Best-Fit Line
Normalization
Applying Normalization to the Comparable Properties
Optimization Basics
Optimizing Watershed Rents
Cash Flow and Profits
Estimating Watershed Cash Flow and Profits
Distinguishing Cash Flow from Profits and Losses
Using the Annual Cash Flows and Profits Spreadsheet
Week 4 Learning Goals
Single Workbook Containing Template Spreadsheets 5-6
Using the Alternative to Solver Template Spreadsheet
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)
The Value of Considering Cash Flow Risk and Total Cash Required
The Value of Financial Sensitivity Analysis in General
Alternative to Solver
Profitability
Cash Flow Risk and Total Cash Required
Sensitivity Analysis: Measuring Cutoffs at 40% Transaction Fee
Data Dashboard
Using Tableau to Perform Sensitivity Analysis
Dashboard for Analyst Use
Dashboard Modification for a Financial Audience
Bar in Bar Graphs in Tableau
Histograms in Tableau
Tables in Tableau
How to Get Started Making Your Dashboard
Additional charts for your sensitivity analysis
Dashboard for Decision-makers
Preparing Your Dashboard for Decision-makers
Jittered Maps in Tableau
Lesson Overview
How to Use Jittering to Depict Multiple Data Points in the Same Geographic Location
Turning Your Sensitivity Analysis into a Recommendation
Finalizing Your Dashboard
Tableau Tricks to Try on Your Own (Including R Integration!)
Sensitivity Analysis
Final Project
Persuading Decision-makers to Follow Your Recommendations
Congratulations on Joining the Exciting Field of Data Analytics!
New Information from Your Project Manager!
White Paper Background Information
About the Final Project
PART I: Tableau Dashboard Instructions
PART 2: White Paper Instructions
PART 3: Presentation Instructions
A Very Important Question!
Increasing Real Estate Management Profits: Harnessing Data Analytics at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?
Data ScienceData Science BasicsData ExplorationIncreasing Real Estate Management Profits: Harnessing Data Analytics