À propos de ce cours
10,010

100 % en ligne

Commencez dès maintenant et apprenez aux horaires qui vous conviennent.

Dates limites flexibles

Réinitialisez les dates limites selon votre disponibilité.

Approx. 26 heures pour terminer

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

Anglais

Sous-titres : Anglais

Compétences que vous acquerrez

Data AnalysisTableau SoftwareMySQLSQL

100 % en ligne

Commencez dès maintenant et apprenez aux horaires qui vous conviennent.

Dates limites flexibles

Réinitialisez les dates limites selon votre disponibilité.

Approx. 26 heures pour terminer

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

Anglais

Sous-titres : Anglais

Programme du cours : ce que vous apprendrez dans ce cours

Semaine
1
5 heures pour terminer

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 (Total 28 min), 12 lectures, 2 quiz
5 vidéos
What Watershed Owners Care About6 min
Elicitation Interview with Your Project Manager5 min
Elicitation Interview with Watershed's Marketing Director4 min
Elicitation Interview with Watershed's Financial Director4 min
12 lectures
Course Overview10 min
Special Thanks!10 min
About the Course Team10 min
FAQ (Frequently Asked Questions)10 min
Lesson Overview10 min
Elicitation Refresher10 min
Letter from Your Project Manager10 min
What are Project Managers, Anyway?10 min
Background about the Short-term Rental Industry10 min
Lesson Overview10 min
Outlining an SPAP10 min
Requirements and Assumptions10 min
1 exercice pour s'entraîner
Elicitation20 min
Semaine
2
2 heures pour terminer

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 (Total 2 min), 2 lectures, 3 quiz
1 vidéo
2 lectures
How to Meet and Retrieve Your Data10 min
Visualize Your Data to Make Sure You Know What They Are10 min
2 exercices pour s'entraîner
Verify You Have Extracted the Correct Data10 min
Make Sure You Understand What Your Data Mean10 min
Semaine
3
3 heures pour terminer

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 (Total 20 min), 15 lectures, 5 quiz
5 vidéos
Normalizing Rents to Improve Occupancy Forecasting4 min
Using the Dollars to Percentile Conversion Guide Spreadsheet2 min
Optimizing Rents to Maximize Revenues5 min
Using the Solver Revenue Maximization Guide Spreadsheet2 min
15 lectures
Week 3 Learning Goals10 min
Single Workbook Containing Template Spreadsheets 1-310 min
Single Workbook Containing Guide Spreadsheets10 min
Best Practices for Setting up an Excel Spreadsheet10 min
Using the First Best-Fit Line Template Spreadsheet10 min
First Best Fit Line Template (Spreadsheet 1)10 min
Using the Normalized Data and Model Template Spreadsheet10 min
Normalized Data and Model Template (Spreadsheet 2)10 min
Dollars to Percentile Conversion Guide Spreadsheet10 min
Applying Normalization to the Comparable Properties10 min
Lesson Overview10 min
Solver Revenue Maximization Guide Spreadsheet10 min
Optimizing Watershed Rents10 min
Solver Rent Optimization Template (Spreadsheet 3)10 min
Alternative to Solver Template (Spreadsheet 4)10 min
5 exercices pour s'entraîner
First Best-Fit Line6 min
Normalization6 min
Applying Normalization to the Comparable Properties6 min
Optimization Basics6 min
Optimizing Watershed Rents12 min
Semaine
4
2 heures pour terminer

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 (Total 12 min), 10 lectures, 4 quiz
3 vidéos
Distinguishing Cash Flow from Profits and Losses4 min
Using the Annual Cash Flows and Profits Spreadsheet3 min
10 lectures
Week 4 Learning Goals10 min
Single Workbook Containing Template Spreadsheets 5-610 min
Using the Alternative to Solver Template Spreadsheet10 min
Using the Forecasting Cash Flow and Profits Template Spreadsheet10 min
Forecasting Cash Flow and Profits Template (Spreadsheet 5)10 min
Annual Cash Flows and Profits Guide Spreadsheet10 min
Using the Sorting by Profitability Template Spreadsheet10 min
Sorting by Profitability Template (Spreadsheet 6)10 min
The Value of Considering Cash Flow Risk and Total Cash Required10 min
The Value of Financial Sensitivity Analysis in General10 min
4 exercices pour s'entraîner
Alternative to Solver12 min
Profitability8 min
Cash Flow Risk and Total Cash Required4 min
Sensitivity Analysis: Measuring Cutoffs at 40% Transaction Fee2 min
Semaine
5
1 heure pour terminer

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 (Total 55 min), 2 lectures
6 vidéos
Dashboard for Analyst Use11 min
Dashboard Modification for a Financial Audience8 min
Bar in Bar Graphs in Tableau13 min
Histograms in Tableau6 min
Tables in Tableau9 min
2 lectures
How to Get Started Making Your Dashboard10 min
Additional charts for your sensitivity analysis10 min
Semaine
6
1 heure pour terminer

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 (Total 15 min), 5 lectures, 1 quiz
2 vidéos
Jittered Maps in Tableau10 min
5 lectures
Lesson Overview10 min
How to Use Jittering to Depict Multiple Data Points in the Same Geographic Location10 min
Turning Your Sensitivity Analysis into a Recommendation10 min
Finalizing Your Dashboard10 min
Tableau Tricks to Try on Your Own (Including R Integration!)10 min
1 exercice pour s'entraîner
Sensitivity Analysis20 min
Semaine
7
3 heures pour terminer

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 (Total 10 min), 6 lectures, 2 quiz
2 vidéos
Congratulations on Joining the Exciting Field of Data Analytics!3 min
6 lectures
New Information from Your Project Manager!10 min
White Paper Background Information10 min
About the Final Project10 min
PART I: Tableau Dashboard Instructions10 min
PART 2: White Paper Instructions10 min
PART 3: Presentation Instructions10 min
1 exercice pour s'entraîner
A Very Important Question!2 min
4.7
33 avisChevron Right

31%

a commencé une nouvelle carrière après avoir terminé ces cours

57%

a bénéficié d'un avantage concret dans sa carrière grâce à ce cours

56%

a obtenu une augmentation de salaire ou une promotion

Meilleurs avis

par 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

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

Enseignants

Avatar

Daniel Egger

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

Jana Schaich Borg

Assistant Research Professor
Social Science Research Institute

À propos de 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....

À propos de la Spécialisation De Excel à MySQL: techniques d'analyse pour l'entreprise

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 à MySQL: techniques d'analyse pour l'entreprise

Foire Aux Questions

  • Une fois que vous êtes inscrit(e) pour un Certificat, vous pouvez accéder à toutes les vidéos de cours, et à tous les quiz et exercices de programmation (le cas échéant). Vous pouvez soumettre des devoirs à examiner par vos pairs et en examiner vous-même uniquement après le début de votre session. Si vous préférez explorer le cours sans l'acheter, vous ne serez peut-être pas en mesure d'accéder à certains devoirs.

  • Lorsque vous vous inscrivez au cours, vous bénéficiez d'un accès à tous les cours de la Spécialisation, et vous obtenez un Certificat lorsque vous avez réussi. Votre Certificat électronique est alors ajouté à votre page Accomplissements. À partir de cette page, vous pouvez imprimer votre Certificat ou l'ajouter à votre profil LinkedIn. Si vous souhaitez seulement lire et visualiser le contenu du cours, vous pouvez accéder gratuitement au cours en tant qu'auditeur libre.

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

D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.