À propos de ce cours : 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."

Créé par : Université Duke

Enseigné par : Daniel Egger, Executive in Residence and Director, Center for Quantitative Modeling
Pratt School of Engineering, Duke University
Enseigné par : Jana Schaich Borg, Assistant Research Professor
Social Science Research Institute

Informations de base	Cours 5 de 5 dans Excel to MySQL: Analytic Techniques for Business Specialization
Engagement	8 weeks of study, 8-10 hours/week
Langue	Anglais
Comment réussir	Réussissez tous les devoirs notés pour terminer le cours.
Notes des utilisateurs	4.7 étoiles Note moyenne des utilisateurs 4.7Voir ce que disent les étudiants

Programme de cours

SEMAINE 1

Introduction

The goal for this week is to learn about the Capstone Project you are tasked with, acquire background about the business problem, and begin to outline the steps of your analysis.

5 vidéos, 12 lectures

Reading: Course Overview
Reading: Special Thanks!
Reading: About the Course Team
Reading: FAQ (Frequently Asked Questions)
Reading: Lesson Overview
Reading: Elicitation Refresher
Reading: Letter from Your Project Manager
Reading: What are Project Managers, Anyway?
Vidéo: What Watershed Owners Care About
Reading: Background about the Short-term Rental Industry
Reading: Lesson Overview
Vidéo: Elicitation Interview with Your Project Manager
Vidéo: Elicitation Interview with Watershed's Marketing Director
Vidéo: Elicitation Interview with Watershed's Financial Director
Reading: Outlining an SPAP
Reading: Requirements and Assumptions

Noté: Your Three Elicitation Interviews

Noté: Elicitation

SEMAINE 2

Data Extraction and Visualization

The goal of this week is for you to extract the relevant data from the MySQL database you are given access to, and to look at it briefly in Tableau to get sense of what data you have.

1 vidéo, 2 lectures

Reading: How to Meet and Retrieve Your Data
LTI Item: How to Meet and Retrieve Your Data (Jupyter notebook)
Reading: Visualize Your Data to Make Sure You Know What They Are

Noté: Verify You Have Extracted the Correct Data

Noté: Make Sure You Understand What Your Data Mean

SEMAINE 3

Modeling

The goal of this week is for you to create a financial model using Excel to analyze the data you extracted from the database, and to start to predict short-term rents for some of Watershed's existing properties.

5 vidéos, 15 lectures

Reading: Week 3 Learning Goals
Reading: Single Workbook Containing Template Spreadsheets 1-3
Reading: Single Workbook Containing Guide Spreadsheets
Reading: Best Practices for Setting up an Excel Spreadsheet
Reading: Using the First Best-Fit Line Template Spreadsheet
Reading: First Best Fit Line Template (Spreadsheet 1)
Vidéo: Normalizing Rents to Improve Occupancy Forecasting
Reading: Using the Normalized Data and Model Template Spreadsheet
Reading: Normalized Data and Model Template (Spreadsheet 2)
Vidéo: Using the Dollars to Percentile Conversion Guide Spreadsheet
Reading: Dollars to Percentile Conversion Guide Spreadsheet
Reading: Applying Normalization to the Comparable Properties
Reading: Lesson Overview
Vidéo: Optimizing Rents to Maximize Revenues
Vidéo: Using the Solver Revenue Maximization Guide Spreadsheet
Reading: Solver Revenue Maximization Guide Spreadsheet
Reading: Optimizing Watershed Rents
Reading: Solver Rent Optimization Template (Spreadsheet 3)
Reading: Alternative to Solver Template (Spreadsheet 4)

Noté: First Best-Fit Line

Noté: Normalization

Noté: Applying Normalization to the Comparable Properties

Noté: Optimization Basics

Noté: Optimizing Watershed Rents

SEMAINE 4

Cash Flow and Profits

The goal for this week is for you to use your projections about the Watershed properties to estimate cash flows and profits Watershed would experience if it converted properties to short-term rentals.

3 vidéos, 10 lectures

Reading: Week 4 Learning Goals
Reading: Single Workbook Containing Template Spreadsheets 5-6
Reading: Using the Alternative to Solver Template Spreadsheet
Vidéo: Distinguishing Cash Flow from Profits and Losses
Reading: Using the Forecasting Cash Flow and Profits Template Spreadsheet
Reading: Forecasting Cash Flow and Profits Template (Spreadsheet 5)
Vidéo: Using the Annual Cash Flows and Profits Spreadsheet
Reading: Annual Cash Flows and Profits Guide Spreadsheet
Reading: Using the Sorting by Profitability Template Spreadsheet
Reading: Sorting by Profitability Template (Spreadsheet 6)
Reading: The Value of Considering Cash Flow Risk and Total Cash Required
Reading: The Value of Financial Sensitivity Analysis in General

Noté: Alternative to Solver

Noté: Profitability

Noté: Cash Flow Risk and Total Cash Required

Noté: Sensitivity Analysis: Measuring Cutoffs at 40% Transaction Fee

SEMAINE 5

Data Dashboard

The goal of this week and next week is to build an analytical dashboard in Tableau using the data models and assumptions you have discovered in prior weeks.

6 vidéos, 2 lectures

Vidéo: Dashboard for Analyst Use
Vidéo: Dashboard Modification for a Financial Audience
Reading: How to Get Started Making Your Dashboard
Reading: Additional charts for your sensitivity analysis
Vidéo: Bar in Bar Graphs in Tableau
Vidéo: Histograms in Tableau
Vidéo: Tables in Tableau

SEMAINE 6

Dashboard for Decision-makers

This week complete your dashboard and add design elements so the dashboard is ready for stakeholders (Watershed executives, for example) to use it to test your model's assumptions.

2 vidéos, 5 lectures

Reading: Lesson Overview
Vidéo: Jittered Maps in Tableau
Reading: How to Use Jittering to Depict Multiple Data Points in the Same Geographic Location
Reading: Turning Your Sensitivity Analysis into a Recommendation
Reading: Finalizing Your Dashboard
Reading: Tableau Tricks to Try on Your Own (Including R Integration!)

Noté: Sensitivity Analysis

SEMAINE 7

Final Project

This week, design and give a presentation for Watershed executives with your business recommendations, and complete a white paper template. Evaluate 3 peer's dashboards, white papers and presentations.

2 vidéos, 6 lectures

Reading: New Information from Your Project Manager!
Reading: White Paper Background Information
Reading: About the Final Project
Reading: PART I: Tableau Dashboard Instructions
Reading: PART 2: White Paper Instructions
Reading: PART 3: Presentation Instructions
Vidéo: Congratulations on Joining the Exciting Field of Data Analytics!

Noté: A Very Important Question!

Noté: Final Project Assignment Submission

FAQ

Quand aurai-je accès aux vidéos de cours et aux devoirs ?

Que dois-je faire si j'ai besoin de plus de temps pour terminer le cours ?

À quoi ai-je droit si je paie ce cours ?

Puis-je suivre ce cours gratuitement ?

Quelle est la politique de remboursement ?

Une aide financière est-elle disponible ?

Will I receive a transcript from Duke University for completing this course?

Comment cela fonctionne

Trabajo del curso

Cada curso es como un libro de texto interactivo, con videos pregrabados, cuestionarios y proyectos.

Ayuda de tus compañeros

Conéctate con miles de estudiantes y debate ideas y materiales del curso, y obtén ayuda para dominar los conceptos.

Certificados

Obtén reconocimiento oficial por tu trabajo y comparte tu éxito con amigos, compañeros y empleadores.

Créateurs

Université Duke

Duke University has about 13,000 undergraduate and graduate students and a world-class faculty helping to expand the frontiers of knowledge. The university has a strong commitment to applying knowledge in service to society, both near its North Carolina campus and around the world.

Tarification

	Acheter le cours
Accéder au contenu du cours	Disponible
Accéder au contenu noté	Disponible
Recevoir une Note Finale	Disponible
Obtenir un Certificat de Cours partageable	Disponible

Notation et examens

Note moyenne 4.7 sur 5 sur 136 notes

A great way to put the learning into practice. Strongly encourage anyone who started this specialisation course to complete the Capstone project.

Excellent

It was great and I learned a lot. This is making me want to go back to grad school to get my MBA in Finance and a Masters in Business Analytics. :) The only thing I think could be improved is to be more clear on the instructions in certain areas and let students do the analysis part.

Great project to show the skills you learned!

Increasing Real Estate Management Profits: Harnessing Data Analytics

Increasing Real Estate Management Profits: Harnessing Data Analytics