Informações sobre o curso
10,196 visualizações recentes

100% online

Comece imediatamente e aprenda em seu próprio cronograma.

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.

Aprox. 26 horas para completar

Sugerido: 8 weeks of study, 8-10 hours/week...


Legendas: Inglês

Habilidades que você terá

Data AnalysisTableau SoftwareMySQLSQL

100% online

Comece imediatamente e aprenda em seu próprio cronograma.

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.

Aprox. 26 horas para completar

Sugerido: 8 weeks of study, 8-10 hours/week...


Legendas: Inglês

Programa - O que você aprenderá com este curso

5 horas para concluir


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 vídeos (total de (Total 28 mín.) min), 12 leituras, 2 testes
5 videos
What Watershed Owners Care About6min
Elicitation Interview with Your Project Manager5min
Elicitation Interview with Watershed's Marketing Director4min
Elicitation Interview with Watershed's Financial Director4min
12 leituras
Course Overview10min
Special Thanks!10min
About the Course Team10min
FAQ (Frequently Asked Questions)10min
Lesson Overview10min
Elicitation Refresher10min
Letter from Your Project Manager10min
What are Project Managers, Anyway?10min
Background about the Short-term Rental Industry10min
Lesson Overview10min
Outlining an SPAP10min
Requirements and Assumptions10min
1 exercício prático
2 horas para concluir

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 vídeo (total de (Total 2 mín.) min), 2 leituras, 3 testes
1 vídeos
2 leituras
How to Meet and Retrieve Your Data10min
Visualize Your Data to Make Sure You Know What They Are10min
2 exercícios práticos
Verify You Have Extracted the Correct Data10min
Make Sure You Understand What Your Data Mean10min
3 horas para concluir


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 vídeos (total de (Total 20 mín.) min), 15 leituras, 5 testes
5 videos
Normalizing Rents to Improve Occupancy Forecasting4min
Using the Dollars to Percentile Conversion Guide Spreadsheet2min
Optimizing Rents to Maximize Revenues5min
Using the Solver Revenue Maximization Guide Spreadsheet2min
15 leituras
Week 3 Learning Goals10min
Single Workbook Containing Template Spreadsheets 1-310min
Single Workbook Containing Guide Spreadsheets10min
Best Practices for Setting up an Excel Spreadsheet10min
Using the First Best-Fit Line Template Spreadsheet10min
First Best Fit Line Template (Spreadsheet 1)10min
Using the Normalized Data and Model Template Spreadsheet10min
Normalized Data and Model Template (Spreadsheet 2)10min
Dollars to Percentile Conversion Guide Spreadsheet10min
Applying Normalization to the Comparable Properties10min
Lesson Overview10min
Solver Revenue Maximization Guide Spreadsheet10min
Optimizing Watershed Rents10min
Solver Rent Optimization Template (Spreadsheet 3)10min
Alternative to Solver Template (Spreadsheet 4)10min
5 exercícios práticos
First Best-Fit Line6min
Applying Normalization to the Comparable Properties6min
Optimization Basics6min
Optimizing Watershed Rents12min
2 horas para concluir

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 vídeos (total de (Total 12 mín.) min), 10 leituras, 4 testes
3 videos
Distinguishing Cash Flow from Profits and Losses4min
Using the Annual Cash Flows and Profits Spreadsheet3min
10 leituras
Week 4 Learning Goals10min
Single Workbook Containing Template Spreadsheets 5-610min
Using the Alternative to Solver Template Spreadsheet10min
Using the Forecasting Cash Flow and Profits Template Spreadsheet10min
Forecasting Cash Flow and Profits Template (Spreadsheet 5)10min
Annual Cash Flows and Profits Guide Spreadsheet10min
Using the Sorting by Profitability Template Spreadsheet10min
Sorting by Profitability Template (Spreadsheet 6)10min
The Value of Considering Cash Flow Risk and Total Cash Required10min
The Value of Financial Sensitivity Analysis in General10min
4 exercícios práticos
Alternative to Solver12min
Cash Flow Risk and Total Cash Required4min
Sensitivity Analysis: Measuring Cutoffs at 40% Transaction Fee2min
1 hora para concluir

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 vídeos (total de (Total 55 mín.) min), 2 leituras
6 videos
Dashboard for Analyst Use11min
Dashboard Modification for a Financial Audience8min
Bar in Bar Graphs in Tableau13min
Histograms in Tableau6min
Tables in Tableau9min
2 leituras
How to Get Started Making Your Dashboard10min
Additional charts for your sensitivity analysis10min
1 hora para concluir

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 vídeos (total de (Total 15 mín.) min), 5 leituras, 1 teste
2 videos
Jittered Maps in Tableau10min
5 leituras
Lesson Overview10min
How to Use Jittering to Depict Multiple Data Points in the Same Geographic Location10min
Turning Your Sensitivity Analysis into a Recommendation10min
Finalizing Your Dashboard10min
Tableau Tricks to Try on Your Own (Including R Integration!)10min
1 exercício prático
Sensitivity Analysis20min
3 horas para concluir

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 vídeos (total de (Total 10 mín.) min), 6 leituras, 2 testes
2 videos
Congratulations on Joining the Exciting Field of Data Analytics!3min
6 leituras
New Information from Your Project Manager!10min
White Paper Background Information10min
About the Final Project10min
PART I: Tableau Dashboard Instructions10min
PART 2: White Paper Instructions10min
PART 3: Presentation Instructions10min
1 exercício prático
A Very Important Question!2min
33 avaliaçõesChevron Right


comecei uma nova carreira após concluir estes cursos


consegui um benefício significativo de carreira com este curso


recebi um aumento ou promoção

Melhores avaliações

por JAOct 19th 2016

Simply awesome, it did not only helped me to develop the required skills, but gave me the security to try greater. Astounding method, totally recommended specialization

por MCNov 1st 2018

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



Daniel Egger

Executive in Residence and Director, Center for Quantitative Modeling
Pratt School of Engineering, Duke University

Jana Schaich Borg

Assistant Research Professor
Social Science Research Institute

Sobre Universidade 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....

Sobre o Programa de cursos integrados Excel para MySQL: técnicas analíticas para negóciosExcel para MySQL: Técnicas Analíticas para Negócios

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....
Excel para MySQL: técnicas analíticas para negóciosExcel para MySQL: Técnicas Analíticas para Negócios

Perguntas Frequentes – FAQ

  • Ao se inscrever para um Certificado, você terá acesso a todos os vídeos, testes e tarefas de programação (se aplicável). Tarefas avaliadas pelos colegas apenas podem ser enviadas e avaliadas após o início da sessão. Caso escolha explorar o curso sem adquiri-lo, talvez você não consiga acessar certas tarefas.

  • Quando você se inscreve no curso, tem acesso a todos os cursos na Especialização e pode obter um certificado quando concluir o trabalho. Seu Certificado eletrônico será adicionado à sua página de Participações e você poderá imprimi-lo ou adicioná-lo ao seu perfil no LinkedIn. Se quiser apenas ler e assistir o conteúdo do curso, você poderá frequentá-lo como ouvinte sem custo.

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

Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.