When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 5 modules in this course
In this course, you will learn best practices for how to use data analytics to make any company more competitive and more profitable. You will be able to recognize the most critical business metrics and distinguish them from mere data.
You’ll get a clear picture of the vital but different roles business analysts, business data analysts, and data scientists each play in various types of companies. And you’ll know exactly what skills are required to be hired for, and succeed at, these high-demand jobs.
Finally, you will be able to use a checklist provided in the course 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.
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!
What's included
2 videos3 readings
Show info about module content
2 videos•Total 8 minutes
About This Specialization•4 minutes
Introduction•3 minutes
3 readings•Total 25 minutes
Specialization Overview•10 minutes
Report a problem with the course•5 minutes
Course Overview•10 minutes
Introducing Business Metrics
Module 2•2 hours to complete
Module details
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.
What's included
11 videos1 reading1 assignment
Show info about module content
11 videos•Total 90 minutes
Metrics Help Us Ask the Right Questions•4 minutes
Distinguishing Revenue, Profitability, and Risk Metrics•6 minutes
Distinguishing Traditional and Dynamic Metrics•6 minutes
Egger’s Roast Coffee Case Study Part 1 – Definitions•13 minutes
Egger’s Roast Coffee Case Study Part 2 – How a Profitable, Growing Company can go Bankrupt•12 minutes
Revenue Metrics – Traditional Enterprise Sales Funnel•9 minutes
Revenue Metrics - Amazon.com as a Leading Example of Use of Dynamic Metrics - Part 1•9 minutes
Revenue Metrics - Amazon.com as a Leading Example of Use of Dynamic Metrics - Part 2•7 minutes
Profitability/Efficiency Metrics: Hotel Room Occupancy Optimization•10 minutes
Risk Metrics: Leverage and Reputational Risk•4 minutes
1 reading•Total 10 minutes
Egger's Roast Coffee Cash Flow and P&L Statements•10 minutes
1 assignment•Total 30 minutes
Business Metrics•30 minutes
Working in the Business Data Analytics Marketplace
Module 3•2 hours to complete
Module details
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.
What's included
15 videos2 readings1 assignment
Show info about module content
15 videos•Total 86 minutes
Roles and Companies as They Relate to Big Data•5 minutes
The Business Analyst•8 minutes
An Interview with Business Analyst Shambhavi Vashishtha•6 minutes
Distinguishing the Business Data Analyst and Business Analyst Roles•3 minutes
An Interview with Business Data Analyst Tiffany Yu•5 minutes
The Data Scientist•5 minutes
An Interview with Data Scientist Dai Li•4 minutes
The Senior Software Engineer•3 minutes
Overview of 5 Types of Companies as They Relate to Big Data•4 minutes
Traditional Strategic Business Consulting•5 minutes
Bricks-and-Mortar Companies•7 minutes
Barnes and Noble Case Study•13 minutes
Strategic Business Consulting - Focus on Software/IT Systems Integration•4 minutes
Hardware and Software Companies•8 minutes
Digital Companies•6 minutes
2 readings•Total 20 minutes
Summary of Job Requirements for Data-Centric Roles•10 minutes
20-Item Checklist for Evaluating A Business•10 minutes
1 assignment•Total 30 minutes
Working in the Business Data Analytics Marketplace•30 minutes
Going Deeper into Business Metrics
Module 4•2 hours to complete
Module details
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.
What's included
7 videos1 reading1 assignment
Show info about module content
7 videos•Total 63 minutes
Web Marketing - Metrics•6 minutes
Web Marketing - AdWord Metrics•7 minutes
Web Marketing - Segmentation•5 minutes
Financial Services Metrics - Money Management and Investing•13 minutes
The Equivalence of Different Returns –The Sharpe Ratio•9 minutes
Four Types of Money Managers and Their Performance Metrics•15 minutes
Venture Capital and Private Equity Investors•6 minutes
1 reading•Total 10 minutes
Links Cited In AdWords Metric Video•10 minutes
1 assignment•Total 30 minutes
Going Deeper into Business Metrics•30 minutes
Applying Business Metrics to a Business Case Study
Module 5•1 hour to complete
Module details
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.
What's included
2 readings1 peer review
Show info about module content
2 readings•Total 20 minutes
A Look Ahead•10 minutes
Share your learning experience•10 minutes
1 peer review•Total 60 minutes
Articulating Business Metrics in a Business Case Study•60 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructors
Instructor ratings
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
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.
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.6
8,477 reviews
5 stars
68.45%
4 stars
25.07%
3 stars
4.77%
2 stars
0.80%
1 star
0.88%
Showing 3 of 8477
J
JJ
5·
Reviewed on Feb 26, 2017
It's the first course from the specification, which makes us better understand the necessary business metrics for data-driven companies, and it is a good entry for following modules. Help me a lot.
J
JH
5·
Reviewed on Jun 13, 2018
I very much enjoyed this course, which helped me build the knowledge foundation of business metrics and other basics. The capstone is very helpful for me to have a taste of business case analytics.
M
MB
5·
Reviewed on Oct 20, 2024
This was really so much fun. The slides and format are exceptional. I'm so highly engaged in this learning experience, it's great to learn from people who are genuinely thrilled by the work they do.
Will I receive a transcript from Duke University for completing this course?
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.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
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.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.