About this Course

461,689 recent views

Learner Career Outcomes

29%

started a new career after completing these courses

29%

got a tangible career benefit from this course

13%

got a pay increase or promotion

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Approx. 9 hours to complete

English

Subtitles: English, Korean, Arabic, Chinese (Simplified)

Skills you will gain

Data AnalysisBusiness AnalysisBusiness AnalyticsBusiness Process

Learner Career Outcomes

29%

started a new career after completing these courses

29%

got a tangible career benefit from this course

13%

got a pay increase or promotion

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Approx. 9 hours to complete

English

Subtitles: English, Korean, Arabic, Chinese (Simplified)

Offered by

Duke University logo

Duke University

Syllabus - What you will learn from this course

Content RatingThumbs Up96%(31,600 ratings)Info
Week
1

Week 1

28 minutes to complete

About This Specialization and Course

28 minutes to complete
2 videos (Total 8 min), 2 readings
2 videos
Introduction3m
2 readings
Specialization Overview10m
Course Overview10m
2 hours to complete

Introducing Business Metrics

2 hours to complete
11 videos (Total 90 min), 1 reading, 1 quiz
11 videos
Distinguishing Revenue, Profitability, and Risk Metrics6m
Distinguishing Traditional and Dynamic Metrics6m
Egger’s Roast Coffee Case Study Part 1 – Definitions13m
Egger’s Roast Coffee Case Study Part 2 – How a Profitable, Growing Company can go Bankrupt12m
Revenue Metrics – Traditional Enterprise Sales Funnel8m
Revenue Metrics - Amazon.com as a Leading Example of Use of Dynamic Metrics - Part 18m
Revenue Metrics - Amazon.com as a Leading Example of Use of Dynamic Metrics - Part 26m
Profitability/Efficiency Metrics: Inventory Management10m
Profitability/Efficiency Metrics: Hotel Room Occupancy Optimization9m
Risk Metrics: Leverage and Reputational Risk4m
1 reading
Egger's Roast Coffee Cash Flow and P&L Statements10m
1 practice exercise
Business Metrics30m
Week
2

Week 2

2 hours to complete

Working in the Business Data Analytics Marketplace

2 hours to complete
15 videos (Total 77 min), 2 readings, 1 quiz
15 videos
The Business Analyst7m
An Interview with Business Analyst Shambhavi Vashishtha6m
Distinguishing the Business Data Analyst and Business Analyst Roles3m
An Interview with Business Data Analyst Tiffany Yu4m
The Data Scientist5m
An Interview with Data Scientist Dai Li4m
The Senior Software Engineer2m
Overview of 5 Types of Companies as They Relate to Big Data4m
Traditional Strategic Business Consulting4m
Bricks-and-Mortar Companies7m
Barnes and Noble Case Study4m
Strategic Business Consulting - Focus on Software/IT Systems Integration3m
Hardware and Software Companies7m
Digital Companies5m
2 readings
Summary of Job Requirements for Data-Centric Roles10m
20-Item Checklist for Evaluating A Business10m
1 practice exercise
Working in the Business Data Analytics Marketplace30m
Week
3

Week 3

2 hours to complete

Going Deeper into Business Metrics

2 hours to complete
7 videos (Total 63 min), 1 reading, 1 quiz
7 videos
Web Marketing - AdWord Metrics7m
Web Marketing - Segmentation5m
Financial Services Metrics - Money Management and Investing13m
The Equivalence of Different Returns –The Sharpe Ratio8m
Four Types of Money Managers and Their Performance Metrics14m
Venture Capital and Private Equity Investors6m
1 reading
Links Cited In AdWords Metric Video10m
1 practice exercise
Going Deeper into Business Metrics30m
Week
4

Week 4

2 hours to complete

Applying Business Metrics to a Business Case Study

2 hours to complete
1 reading
1 reading
A Look Ahead10m

About the Excel to MySQL: Analytic Techniques for Business Specialization

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

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

  • Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project. Learn more.

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

More questions? Visit the Learner Help Center.