About this Course

49,351 recent views

Learner Career Outcomes

27%

started a new career after completing these courses

47%

got a tangible career benefit from this course

50%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Approx. 23 hours to complete
English

Skills you will gain

Data AnalysisTableau SoftwareMySQLSQL

Learner Career Outcomes

27%

started a new career after completing these courses

47%

got a tangible career benefit from this course

50%

got a pay increase or promotion
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Approx. 23 hours to complete
English

Offered by

Placeholder

Duke University

Syllabus - What you will learn from this course

Content RatingThumbs Up98%(1,266 ratings)Info
Week
1

Week 1

5 hours to complete

Introduction

5 hours to complete
5 videos (Total 28 min), 12 readings, 2 quizzes
5 videos
What Watershed Owners Care About6m
Elicitation Interview with Your Project Manager5m
Elicitation Interview with Watershed's Marketing Director4m
Elicitation Interview with Watershed's Financial Director4m
12 readings
Course Overview10m
Special Thanks!10m
About the Course Team10m
FAQ (Frequently Asked Questions)10m
Lesson Overview10m
Elicitation Refresher10m
Letter from Your Project Manager10m
What are Project Managers, Anyway?10m
Background about the Short-term Rental Industry10m
Lesson Overview10m
Outlining an SPAP10m
Requirements and Assumptions10m
1 practice exercise
Elicitation30m
Week
2

Week 2

2 hours to complete

Data Extraction and Visualization

2 hours to complete
1 video (Total 2 min), 2 readings, 2 quizzes
1 video
2 readings
How to Meet and Retrieve Your Data10m
Visualize Your Data to Make Sure You Know What They Are10m
2 practice exercises
Verify You Have Extracted the Correct Data30m
Make Sure You Understand What Your Data Mean30m
Week
3

Week 3

5 hours to complete

Modeling

5 hours to complete
5 videos (Total 20 min), 15 readings, 5 quizzes
5 videos
Normalizing Rents to Improve Occupancy Forecasting4m
Using the Dollars to Percentile Conversion Guide Spreadsheet2m
Optimizing Rents to Maximize Revenues5m
Using the Solver Revenue Maximization Guide Spreadsheet2m
15 readings
Week 3 Learning Goals10m
Single Workbook Containing Template Spreadsheets 1-310m
Single Workbook Containing Guide Spreadsheets10m
Best Practices for Setting up an Excel Spreadsheet10m
Using the First Best-Fit Line Template Spreadsheet10m
First Best Fit Line Template (Spreadsheet 1)10m
Using the Normalized Data and Model Template Spreadsheet10m
Normalized Data and Model Template (Spreadsheet 2)10m
Dollars to Percentile Conversion Guide Spreadsheet10m
Applying Normalization to the Comparable Properties10m
Lesson Overview10m
Solver Revenue Maximization Guide Spreadsheet10m
Optimizing Watershed Rents10m
Solver Rent Optimization Template (Spreadsheet 3)10m
Alternative to Solver Template (Spreadsheet 4)10m
5 practice exercises
First Best-Fit Line30m
Normalization30m
Applying Normalization to the Comparable Properties30m
Optimization Basics30m
Optimizing Watershed Rents30m
Week
4

Week 4

4 hours to complete

Cash Flow and Profits

4 hours to complete
3 videos (Total 12 min), 10 readings, 4 quizzes
3 videos
Distinguishing Cash Flow from Profits and Losses4m
Using the Annual Cash Flows and Profits Spreadsheet3m
10 readings
Week 4 Learning Goals10m
Single Workbook Containing Template Spreadsheets 5-610m
Using the Alternative to Solver Template Spreadsheet10m
Using the Forecasting Cash Flow and Profits Template Spreadsheet10m
Forecasting Cash Flow and Profits Template (Spreadsheet 5)10m
Annual Cash Flows and Profits Guide Spreadsheet10m
Using the Sorting by Profitability Template Spreadsheet10m
Sorting by Profitability Template (Spreadsheet 6)10m
The Value of Considering Cash Flow Risk and Total Cash Required10m
The Value of Financial Sensitivity Analysis in General10m
4 practice exercises
Alternative to Solver30m
Profitability30m
Cash Flow Risk and Total Cash Required30m
Sensitivity Analysis: Measuring Cutoffs at 40% Transaction Fee30m

Reviews

TOP REVIEWS FROM INCREASING REAL ESTATE MANAGEMENT PROFITS: HARNESSING DATA ANALYTICS

View all reviews

About the Excel to MySQL: Analytic Techniques for Business Specialization

Excel to MySQL: Analytic Techniques for Business

Frequently Asked Questions

More questions? Visit the Learner Help Center.