À 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 : Duke University
Enseigné par : Daniel Egger, Executive in Residence and Director, Center for Quantitative Modeling
Pratt School of Engineering, Duke UniversityEnseigné 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 | English |
| Comment réussir | Réussissez tous les devoirs notés pour terminer le cours. |
| Notes des utilisateurs |
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, 14 lectures
- Reading: Course Overview
- Reading: Special Thanks!
- Reading: About the Course Team
- Reading: FAQ (Frequently Asked Questions)
- Reading: Feedback Survey Information
- 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
- Reading: Feedback Survey
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, 3 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
- Reading: Feedback Survey
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, 16 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)
- Reading: Feedback Survey
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, 11 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
- Reading: Feedback Survey
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, 3 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
- Reading: Feedback Survey
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, 6 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!)
- Reading: Feedback Survey
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, 7 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!
- Reading: Feedback Survey
Noté: A Very Important Question!
Noté: Final Project Assignment Submission
FAQ
Comment cela fonctionne
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Créateurs
Duke University
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
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!
Excellent!
Coursera propose un accès universel à la meilleure formation au monde,
en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.
© 2018 Coursera Inc. Tous droits réservés.
SR
Excellent