We may earn an affiliate commission when you visit our partners.

Excel to MySQL

Analytic Techniques for Business

Daniel Egger and Jana Schaich Borg

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.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Help others find Specialization from Coursera by sharing it with your friends and followers:

Facebook

Copy Link

What's inside

Five courses

Business Metrics for Data-Driven Companies

(0 hours)

In this course, you'll learn how to use data analytics to make companies more competitive and profitable. You'll recognize critical business metrics and distinguish them from mere data.

View more details for this course

Mastering Data Analysis in Excel

(0 hours)

This course will prepare you to design and implement realistic predictive models based on data. In the Final Project (module 6) you will assume the role of a business data analyst for a bank, and develop two different predictive models to determine which applicants for credit cards should be accepted and which rejected.

View more details for this course

Data Visualization and Communication with Tableau

(0 hours)

One of the skills that characterizes great business data analysts is the ability to communicate practical implications of quantitative analyses to any kind of audience member. Even the most sophisticated statistical analyses are not useful to a business if they do not lead to actionable advice, or if the answers to those business questions are not conveyed in a way that non-technical people can understand.

View more details for this course

Managing Big Data with MySQL

(0 hours)

This course introduces relational databases for business analysis. Learn how they work and use entity-relationship diagrams to visualize data structure. Understand data collection needs and identify features for implementing new efforts. Execute queries and table aggregations for business analysts.

View more details for this course

Increasing Real Estate Management Profits: Harnessing Data Analytics

(1 hours)

In this Capstone Project, you will use data analysis to recommend a method for improving profits for Watershed Property Management, Inc. You will elicit information about important variables, extract relevant data from a real estate database, implement data analysis in Excel, create a Tableau dashboard, and articulate a significant and innovative business process change for Watershed based on your data analysis.

View more details for this course

Save this collection

Save Excel to MySQL: Analytic Techniques for Business to your list so you can find it easily later:

Save

Time

3 hours

Level

Introductory

Via

Coursera

Institution

Duke University

Instructors

Daniel Egger

Jana Schaich Borg

Level

Introductory

Share Specialization from Coursera

Facebook

Link

Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.