Об этом курсе
4.5
Оценки: 4,727
Рецензии: 961
100% онлайн

100% онлайн

Начните сейчас и учитесь по собственному графику.
Гибкие сроки

Гибкие сроки

Назначьте сроки сдачи в соответствии со своим графиком.
Часов на завершение

Прибл. 14 часа на выполнение

Предполагаемая нагрузка: 4 weeks, 3-5 hours per week...
Доступные языки

Английский

Субтитры: Английский, Арабский, Китайский (упрощенное письмо)

Приобретаемые навыки

Data AnalysisBusiness AnalysisBusiness AnalyticsBusiness Process
100% онлайн

100% онлайн

Начните сейчас и учитесь по собственному графику.
Гибкие сроки

Гибкие сроки

Назначьте сроки сдачи в соответствии со своим графиком.
Часов на завершение

Прибл. 14 часа на выполнение

Предполагаемая нагрузка: 4 weeks, 3-5 hours per week...
Доступные языки

Английский

Субтитры: Английский, Арабский, Китайский (упрощенное письмо)

Программа курса: что вы изучите

Неделя
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 videos (Total 8 min), 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 videos (Total 90 min), 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 videos (Total 77 min), 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 videos (Total 63 min), 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
Рецензии: 961Chevron 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

Часто задаваемые вопросы

  • Зарегистрировавшись на сертификацию, вы получите доступ ко всем видео, тестам и заданиям по программированию (если они предусмотрены). Задания по взаимной оценке сокурсниками можно сдавать и проверять только после начала сессии. Если вы проходите курс без оплаты, некоторые задания могут быть недоступны.

  • Записавшись на курс, вы получите доступ ко всем курсам в специализации, а также возможность получить сертификат о его прохождении. После успешного прохождения курса на странице ваших достижений появится электронный сертификат. Оттуда его можно распечатать или прикрепить к профилю LinkedIn. Просто ознакомиться с содержанием курса можно бесплатно.

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

Остались вопросы? Посетите Центр поддержки учащихся.