Este curso forma parte de Programa especializado: De Excel a MySQL: técnicas de análisis para negocios

4.7
estrellas
239 calificaciones

97 %

Daniel Egger +1 instructores más

14.029 ya inscrito

Ofrecido Por

Programa especializado: De Excel a MySQL: técnicas de análisis para negociosUniversidad Duke

Acerca de este Curso

8145 vistas recientes

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

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Curso 5 de 5 en

Programa especializado: De Excel a MySQL: técnicas de análisis para negocios

Aprox. 23 horas para completar

Inglés (English)

Habilidades que obtendrás

Data Analysis
Tableau Software
MySQL
SQL

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Curso 5 de 5 en

Programa especializado: De Excel a MySQL: técnicas de análisis para negocios

Aprox. 23 horas para completar

Inglés (English)

Instructores

Calificación del instructor

4,44/5 (19 calificaciones)

Daniel Egger

Executive in Residence and Director, Center for Quantitative Modeling

Pratt School of Engineering, Duke University

1.001.157 alumnos

8 cursos

Jana Schaich Borg

Assistant Research Professor

Social Science Research Institute

692.424 alumnos

7 cursos

Ofrecido por

Universidad Duke

Programa - Qué aprenderás en este curso

Calificación del contenido97%(1,604 calificaciones)

Semana

Semana 1

5 horas para completar

Introduction

5 horas para completar

5 videos (Total 28 minutos), 12 lecturas, 2 cuestionarios

5 videos

Introduction to the Capstone Project7m

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 lecturas

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 ejercicio de práctica

Elicitation30m

Semana

Semana 2

2 horas para completar

Data Extraction and Visualization

2 horas para completar

1 video (Total 2 minutos), 2 lecturas, 2 cuestionarios

Semana

Semana 3

5 horas para completar

Modeling

5 horas para completar

5 videos (Total 20 minutos), 15 lecturas, 5 cuestionarios

5 videos

Creating a Predictive Model for Short-term Rental Rates5m

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 lecturas

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 ejercicios de práctica

First Best-Fit Line30m

Normalization30m

Applying Normalization to the Comparable Properties30m

Optimization Basics30m

Optimizing Watershed Rents30m

Semana

Semana 4

4 horas para completar

Cash Flow and Profits

4 horas para completar

3 videos (Total 12 minutos), 10 lecturas, 4 cuestionarios

3 videos

Estimating Watershed Cash Flow and Profits4m

Distinguishing Cash Flow from Profits and Losses4m

Using the Annual Cash Flows and Profits Spreadsheet3m

10 lecturas

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 ejercicios de práctica

Alternative to Solver30m

Profitability30m

Cash Flow Risk and Total Cash Required30m

Sensitivity Analysis: Measuring Cutoffs at 40% Transaction Fee30m

Semana

Semana 5

1 hora para completar

Data Dashboard

1 hora para completar

6 videos (Total 55 minutos), 2 lecturas

Semana

Semana 6

2 horas para completar

Dashboard for Decision-makers

2 horas para completar

2 videos (Total 15 minutos), 5 lecturas, 1 cuestionario

Semana

Semana 7

4 horas para completar

Final Project

4 horas para completar

2 videos (Total 10 minutos), 6 lecturas, 2 cuestionarios

2 videos

Persuading Decision-makers to Follow Your Recommendations6m

Congratulations on Joining the Exciting Field of Data Analytics!3m

6 lecturas

New Information from Your Project Manager!10m

White Paper Background Information10m

About the Final Project10m

PART I: Tableau Dashboard Instructions10m

PART 2: White Paper Instructions10m

PART 3: Presentation Instructions10m

1 ejercicio de práctica

A Very Important Question!30m

Reseñas

4.7

54 reseña

5 stars
80,75 %
4 stars
13,38 %
3 stars
2,09 %
2 stars
0,83 %
1 star
2,92 %

Principales reseñas sobre INCREASING REAL ESTATE MANAGEMENT PROFITS: HARNESSING DATA ANALYTICS

por JK20 de ago. de 2020

If you have come this far, I would recommend giving it a go! You will be so glad you did

por DL27 de mar. de 2017

It would have been nice to use more complex data analysis, as used in the second course of this specialization, in order to build the final model.

por OO25 de sep. de 2017

Great course! Would definitely recommend those who are interested in data analytics!

por DC29 de jul. de 2017

You will be proud of yourself when you complete this Capstone !

Ver todas las reseñas

Acerca de Programa especializado: De Excel a MySQL: técnicas de análisis para negocios

Formulate data questions, explore and visualize large datasets, and inform strategic decisions.

In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process. The Capstone Project focuses on optimizing revenues from residential property, and Airbnb, our Capstone’s official Sponsor, provided input on the project design. Airbnb is the world’s largest marketplace connecting property-owner hosts with travelers to facilitate short-term rental transactions. 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.

De Excel a MySQL: técnicas de análisis para negocios

Preguntas Frecuentes

¿Cuándo podré acceder a las lecciones y tareas?
El acceso a las clases y las asignaciones depende del tipo de inscripción que tengas. Si tomas un curso en modo de oyente, verás la mayoría de los materiales del curso en forma gratuita. Para acceder a asignaciones calificadas y obtener un certificado, deberás comprar la experiencia de Certificado, ya sea durante o después de participar como oyente. Si no ves la opción de oyente:
es posible que el curso no ofrezca la opción de participar como oyente. En cambio, puedes intentar con una Prueba gratis o postularte para recibir ayuda económica.
Es posible que el curso ofrezca la opción 'Curso completo, sin certificado'. Esta opción te permite ver todos los materiales del curso, enviar las evaluaciones requeridas y obtener una calificación final. También significa que no podrás comprar una experiencia de Certificado.
¿Qué recibiré si me suscribo a este Programa especializado?
Cuando te inscribes en un curso, obtienes acceso a todos los cursos que forman parte del Programa especializado y te darán un Certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.
¿Hay ayuda económica disponible?
Sí. En ciertos programas de aprendizaje, puedes postularte para recibir ayuda económica o una beca en caso de no poder costear los gastos de la tarifa de inscripción. Si hay ayuda económica o becas disponibles para tu selección de programa de aprendizaje, verás un enlace para postularte en la página de descripción.
Will I receive a transcript from Duke University for completing this course?
No. Completion of a Coursera course does not earn you academic credit from Duke; therefore, Duke is not able to provide you with a university transcript. However, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

¿Tienes más preguntas? Visita el Centro de Ayuda al Estudiante.

Increasing Real Estate Management Profits: Harnessing Data Analytics

Acerca de este Curso

Habilidades que obtendrás