课程信息
4.5
4,727 个评分
961 个审阅
100% 在线

100% 在线

立即开始,按照自己的计划学习。
可灵活调整截止日期

可灵活调整截止日期

根据您的日程表重置截止日期。
完成时间(小时)

完成时间大约为14 小时

建议:4 weeks, 3-5 hours per week...
可选语言

英语(English)

字幕:英语(English), 阿拉伯语(Arabic), 中文(简体)

您将获得的技能

Data AnalysisBusiness AnalysisBusiness AnalyticsBusiness Process
100% 在线

100% 在线

立即开始,按照自己的计划学习。
可灵活调整截止日期

可灵活调整截止日期

根据您的日程表重置截止日期。
完成时间(小时)

完成时间大约为14 小时

建议:4 weeks, 3-5 hours per week...
可选语言

英语(English)

字幕:英语(English), 阿拉伯语(Arabic), 中文(简体)

教学大纲 - 您将从这门课程中学到什么

1
完成时间(小时)
完成时间为 28 分钟

About This Specialization and Course

This Coursera Specialization: Excel to MySQL: Analytic Techniques for Business, is about how 'Big Data' interacts with business, and how to use data analytics to create value for businesses. This specialization consists of four courses and a final Capstone Project, where you will apply your skills to real-world business process. You will learn to perform sophisticated data-analysis functions using powerful software tools such as Microsoft Excel, Tableau, and MySQL. To learn more, watch the video and review the specialization overview document we provided. In the first course of the specialization: Business Metrics for Data-Driven Companies, you will be able to learn best practices for using data analytics to make any company more competitive and more profitable; learn to recognize the most critical business metrics and distinguish those from mere data; understand the vital but different roles business analysts, business data analysts, and data scientists each play in various types of companies; and know exactly the skills required to be hired for, and succeed at, these high-demand jobs. Finally, using a 20-item checklist for evaluating a business, you'll be able to score any company on how effectively it is embracing big data culture. Digital companies like Amazon, Uber and Airbnb are transforming entire industries through their creative use of big data. You’ll understand why these companies are so disruptive, and how they use data-analytics techniques to out-compete traditional companies.To get started, please begin with the video 'About This Specialization.'I hope you enjoy this week's materials!...
Reading
2 个视频 (总计 8 分钟), 2 个阅读材料
Video2 个视频
Introduction3分钟
Reading2 个阅读材料
Specialization Overview10分钟
Course Overview10分钟
完成时间(小时)
完成时间为 2 小时

Introducing Business Metrics

Welcome! This week we will explore business metrics - the critical numbers that help companies figure out how to survive and thrive. Inside every pile of data is a vital metric trying to get out! By the end of this week, you will be able to: distinguish business metrics from mere business data; identify critical business metrics such as cash flow, profitability, and online retail marketing metrics; distinguish revenue, profitability and risk metrics; and distinguish traditional from dynamic metrics. Included in this week’s course materials is a Cash Flow and P&L statement for Egger’s Roast Coffee, as a supplemental document, so be sure to review it carefully and refer to the glossary for key information. ...
Reading
11 个视频 (总计 90 分钟), 1 个阅读材料, 1 个测验
Video11 个视频
Distinguishing Revenue, Profitability, and Risk Metrics6分钟
Distinguishing Traditional and Dynamic Metrics6分钟
Egger’s Roast Coffee Case Study Part 1 – Definitions13分钟
Egger’s Roast Coffee Case Study Part 2 – How a Profitable, Growing Company can go Bankrupt12分钟
Revenue Metrics – Traditional Enterprise Sales Funnel8分钟
Revenue Metrics - Amazon.com as a Leading Example of Use of Dynamic Metrics - Part 18分钟
Revenue Metrics - Amazon.com as a Leading Example of Use of Dynamic Metrics - Part 26分钟
Profitability/Efficiency Metrics: Inventory Management10分钟
Profitability/Efficiency Metrics: Hotel Room Occupancy Optimization9分钟
Risk Metrics: Leverage and Reputational Risk4分钟
Reading1 个阅读材料
Egger's Roast Coffee Cash Flow and P&L Statements10分钟
Quiz1 个练习
Business Metrics30分钟
2
完成时间(小时)
完成时间为 2 小时

Working in the Business Data Analytics Marketplace

Welcome! This week, we will meet some great people - all former students of mine - now working at super-interesting and exciting jobs as business analysts, business data analysts, or data scientists. We’ll explore what they do, how their role relates to big data, and the skills they needed to get hired! Our hope is this information will give you a better understanding of the type of data-related job you might apply for once you've completed this specialization, and a sense of the type of company you would find most appealing to work for. By the end of this week, you will be able to: differentiate among different job roles within a company that work with data; identify how each role works with data; and describe the skills required to perform each job role. You will differentiate how different types of companies relate to big data culture, and rank any company according to a 20-item checklist. You will also learn to differentiate how different types of companies relate to big data culture. Included in this week’s materials is a 20-item checklist to rank companies. This week also includes in-video polls so you can see how others are ranking their businesses....
Reading
15 个视频 (总计 77 分钟), 2 个阅读材料, 1 个测验
Video15 个视频
The Business Analyst7分钟
An Interview with Business Analyst Shambhavi Vashishtha6分钟
Distinguishing the Business Data Analyst and Business Analyst Roles3分钟
An Interview with Business Data Analyst Tiffany Yu4分钟
The Data Scientist5分钟
An Interview with Data Scientist Dai Li4分钟
The Senior Software Engineer2分钟
Overview of 5 Types of Companies as They Relate to Big Data4分钟
Traditional Strategic Business Consulting4分钟
Bricks-and-Mortar Companies7分钟
Barnes and Noble Case Study4分钟
Strategic Business Consulting - Focus on Software/IT Systems Integration3分钟
Hardware and Software Companies7分钟
Digital Companies5分钟
Reading2 个阅读材料
Summary of Job Requirements for Data-Centric Roles10分钟
20-Item Checklist for Evaluating A Business10分钟
Quiz1 个练习
Working in the Business Data Analytics Marketplace30分钟
3
完成时间(小时)
完成时间为 2 小时

Going Deeper into Business Metrics

Welcome! This week we’re going to go deeper into the critically-important metrics for web marketing - metrics every type of business needs to understand in order to survive. We’ll dive into the 'vertical' market of financial services - where digital companies are threatening to take away the market from traditional 'brick-and- mortar' companies.By the end of this week, you will be able to: Identify critical business metrics for all companies engaged in web-based marketing; and identify critical business metrics for financial services companies. You’ll find additional website links that expand some of the course materials covered in this week’s video lectures. ...
Reading
7 个视频 (总计 63 分钟), 1 个阅读材料, 1 个测验
Video7 个视频
Web Marketing - AdWord Metrics7分钟
Web Marketing - Segmentation5分钟
Financial Services Metrics - Money Management and Investing13分钟
The Equivalence of Different Returns –The Sharpe Ratio8分钟
Four Types of Money Managers and Their Performance Metrics14分钟
Venture Capital and Private Equity Investors6分钟
Reading1 个阅读材料
Links Cited In AdWords Metric Video10分钟
Quiz1 个练习
Going Deeper into Business Metrics30分钟
4
完成时间(小时)
完成时间为 2 小时

Applying Business Metrics to a Business Case Study

This week contains the final course assignment, a peer assessment in which you will identify business metrics of interest in a case example, describe those metrics, and propose a business process change that could be supported by the metric chosen....
Reading
1 个阅读材料, 1 个测验
Reading1 个阅读材料
A Look Ahead10分钟
4.5
961 个审阅Chevron Right
职业方向

17%

完成这些课程后已开始新的职业生涯
工作福利

83%

通过此课程获得实实在在的工作福利

热门审阅

创建者 ACNov 3rd 2018

really good bases for business metric if you already have a background you are going to enjoy and refresh you memory and if you don't have previous experiences is really easy to understand the concept

创建者 DGAug 20th 2017

This was a great introductory course. I took this up to get a better perspective of business analysis and i can say with surety that it served a lot of purpose. Thanks Coursera and Duke Professor.

讲师

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

关于 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....

关于 Excel to MySQL: Analytic Techniques for Business 专项课程

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 to MySQL: Analytic Techniques for Business

常见问题

  • 注册以便获得证书后,您将有权访问所有视频、测验和编程作业(如果适用)。只有在您的班次开课之后,才可以提交和审阅同学互评作业。如果您选择在不购买的情况下浏览课程,可能无法访问某些作业。

  • 您注册课程后,将有权访问专项课程中的所有课程,并且会在完成课程后获得证书。您的电子课程证书将添加到您的成就页中,您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容,可以免费旁听课程。

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

还有其他问题吗?请访问 学生帮助中心