|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/analytics-capstone
课程评论：没有评论
课程名称：增加房地产管理利润：利用数据分析 课程概述：在本课程的最后部分，您将完成一个顶点项目，利用数据分析为您的公司Watershed Property Management, Inc. 推荐一种提高利润的方法。Watershed负责管理遍布美国的数千个住宅租赁物业。您的任务是说服Watershed管理团队采取一种新的物业管理策略，以增加利润。为此，您将： (1) 收集与分析相关的重要变量信息； (2) 运用新学的MySQL数据库技能，从房地产数据库中提取相关数据； (3) 在Excel中实施数据分析，以确定Watershed增加收入和最大化利润的最佳机会，同时管理任何新风险； (4) 创建一个Tableau仪表板，向Watershed高管展示敏感性分析的结果； (5) 根据您的数据分析，阐述一项显著且创新的业务流程变更，并向公司高管提出建议。 Airbnb作为本顶点项目的官方赞助商，为项目设计提供了意见。每年完成顶点项目的前10名学员将有机会直接向Airbnb的高级数据科学家展示他们的工作，并获得反馈和讨论。 **课程大纲：** - **第一部分：介绍** - 目标：了解您所承担的顶点项目，掌握业务问题的背景，并开始勾勒分析的步骤。 - **第二部分：数据提取与可视化** - 目标：从提供的MySQL数据库中提取相关数据，并在Tableau中快速浏览数据，以了解所拥有的数据。 - **第三部分：建模** - 目标：使用Excel创建财务模型，分析您从数据库中提取的数据，并开始预测Watershed现有物业的短期租金。 - **第四部分：现金流与利润** - 目标：利用您对Watershed物业的预测，估算如果将物业转换为短期租赁，Watershed将经历的现金流和利润。 - **第五部分：数据仪表板** - 目标：在接下来的两周内，使用此前发现的数据模型和假设构建一个分析仪表板。 - **第六部分：决策者仪表板** - 目标：完成您的仪表板，并添加设计元素，以便仪表板可以供利益相关者（例如Watershed执行人员）使用来测试您的模型假设。 - **第七部分：最终项目** - 目标：为Watershed高管设计并展示您的商业建议，完成一份白皮书模板，并评估三份同行的仪表板、白皮书及演示文稿。
Part: 1
Title:Introduction
Description: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.
Part: 2
Title:Data Extraction and Visualization
Description: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.
Part: 3
Title:Modeling
Description: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.
Part: 4
Title:Cash Flow and Profits
Description: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.
Part: 5
Title:Data Dashboard
Description: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.
Part: 6
Title:Dashboard for Decision-makers
Description: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.
Part: 7
Title:Final Project
Description: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.
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."
