К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Increasing Real Estate Management Profits: Harnessing Data Analytics · LearnSpace
Назад в каталог
courseraАнализ данных

Increasing Real Estate Management Profits: Harnessing Data Analytics

Курс от Duke University
Уровень не указан≈ 22.6 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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."

Навыки, которые вы освоите

Microsoft ExcelFinancial ModelingMySQLData Visualization SoftwareProperty ManagementData AnalysisRevenue ManagementPeer ReviewTableau SoftwareReal EstateFinancial DataSQLProperty and Real EstateRisk AnalysisBusiness ProcessData PresentationFinancial AnalysisDashboard CreationPresentationsProcess Development

Программа курса

7 модулей · 95 учебных материалов

01Introduction20 материалов

Welcome!

Introduction to the Capstone ProjectВидеоCourse OverviewЧтениеSpecial Thanks!ЧтениеAbout the Course TeamЧтение

Учитесь у экспертов

Daniel Egger

Executive in Residence and Director, Center for Quantitative Modeling

Jana Schaich Borg

Assistant Research Professor

Increasing Real Estate Management Profits: Harnessing Data Analytics
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 22.6 ч

7 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бенгальский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
FAQ (Frequently Asked Questions)Чтение
Report a problem with the courseЧтение

Preparing for Elicitation

Lesson OverviewЧтениеElicitation RefresherЧтениеLetter from Your Project ManagerЧтениеWhat are Project Managers, Anyway?ЧтениеWhat Watershed Owners Care AboutВидеоBackground about the Short-term Rental IndustryЧтениеYour Three Elicitation InterviewsВзаимная проверка

Elicitation Interviews

Lesson OverviewЧтениеElicitation Interview with Your Project ManagerВидеоElicitation Interview with Watershed's Marketing DirectorВидеоElicitation Interview with Watershed's Financial DirectorВидеоOutlining an SPAPЧтениеElicitationЗаданиеRequirements and AssumptionsЧтение
02Data Extraction and Visualization6 материалов

Getting to Know Your Data

Meet Your DataВидеоHow to Meet and Retrieve Your DataЧтениеHow to Meet and Retrieve Your Data (Jupyter Notebook)ЛабораторнаяVerify You Have Extracted the Correct DataЗадание

Visualizing Your Data

Visualize Your Data to Make Sure You Know What They AreЧтениеMake Sure You Understand What Your Data MeanЗадание
03Modeling25 материалов

Modeling

Week 3 Learning GoalsЧтениеSingle Workbook Containing Template Spreadsheets 1-3ЧтениеSingle Workbook Containing Guide SpreadsheetsЧтениеCreating a Predictive Model for Short-term Rental RatesВидеоBest Practices for Setting up an Excel SpreadsheetЧтениеUsing the First Best-Fit Line Template SpreadsheetЧтениеFirst Best Fit Line Template (Spreadsheet 1)ЧтениеFirst Best-Fit LineЗадание

Normalization

Normalizing Rents to Improve Occupancy ForecastingВидеоUsing the Normalized Data and Model Template SpreadsheetЧтениеNormalized Data and Model Template (Spreadsheet 2)ЧтениеUsing the Dollars to Percentile Conversion Guide SpreadsheetВидеоDollars to Percentile Conversion Guide SpreadsheetЧтениеNormalizationЗадание

Optimization

Lesson OverviewЧтениеOptimizing Rents to Maximize RevenuesВидеоUsing the Solver Revenue Maximization Guide SpreadsheetВидеоSolver Revenue Maximization Guide SpreadsheetЧтениеOptimization BasicsЗаданиеOptimizing Watershed RentsЧтение
04Cash Flow and Profits17 материалов

Alternatives to Solver

Week 4 Learning GoalsЧтениеSingle Workbook Containing Template Spreadsheets 5-6ЧтениеEstimating Watershed Cash Flow and ProfitsВидеоUsing the Alternative to Solver Template SpreadsheetЧтениеAlternative to SolverЗадание

Financial Modeling

Distinguishing Cash Flow from Profits and LossesВидеоUsing the Forecasting Cash Flow and Profits Template SpreadsheetЧтениеForecasting Cash Flow and Profits Template (Spreadsheet 5)ЧтениеUsing the Annual Cash Flows and Profits SpreadsheetВидеоAnnual Cash Flows and Profits Guide SpreadsheetЧтениеUsing the Sorting by Profitability Template SpreadsheetЧтениеSorting by Profitability Template (Spreadsheet 6)ЧтениеProfitabilityЗадание

Risk

The Value of Considering Cash Flow Risk and Total Cash RequiredЧтениеCash Flow Risk and Total Cash RequiredЗаданиеThe Value of Financial Sensitivity Analysis in GeneralЧтениеSensitivity Analysis: Measuring Cutoffs at 40% Transaction FeeЗадание
05Data Dashboard8 материалов

Using Tableau Dashboards for Sensitivity Analysis

Using Tableau to Perform Sensitivity AnalysisВидеоDashboard for Analyst UseВидеоDashboard Modification for a Financial AudienceВидео

Replicate your Excel Results in Tableau

How to Get Started Making Your DashboardЧтение

Make Your Sensitivity Analysis Dashboard

Additional charts for your sensitivity analysisЧтениеBar in Bar Graphs in TableauВидеоHistograms in TableauВидеоTables in TableauВидео
06Dashboard for Decision-makers8 материалов

Visualizing the Location of Watershed Properties using Spatial “Jittering”

Preparing Your Dashboard for Decision-makersВидеоLesson OverviewЧтениеJittered Maps in TableauВидеоHow to Use Jittering to Depict Multiple Data Points in the Same Geographic LocationЧтение

Turning Your Sensitivity Analysis in a Recommendation

Turning Your Sensitivity Analysis into a RecommendationЧтение

Preparing Your Dashboard for Decision-makers

Finalizing Your DashboardЧтениеTableau Tricks to Try on Your Own (Including R Integration!)ЧтениеSensitivity AnalysisЗадание
07Final Project11 материалов

About

Persuading Decision-makers to Follow Your RecommendationsВидеоNew Information from Your Project Manager!ЧтениеWhite Paper Background InformationЧтение

Preparation for the Final Project

A Very Important Question!Задание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!

Final Project Assignment SubmissionВзаимная проверкаCongratulations on Joining the Exciting Field of Data Analytics!ВидеоShare your learning experienceЧтение
Applying Normalization to the Comparable PropertiesЧтение
Applying Normalization to the Comparable PropertiesЗадание
Solver Rent Optimization Template (Spreadsheet 3)Чтение
Optimizing Watershed RentsЗадание
Alternative to Solver Template (Spreadsheet 4)Чтение