Online Course – Certified Professional Internship in Excel to Mysql: Analytical Techniques for Google Business, Duke University

Turn data into value. Drive business process transformation by identifying and analyzing key metrics in four industry-relevant courses.

Suggested by: Coursera (What is Coursera?)

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Formulating business challenges as data questions
  • Using advanced tools such as Excel, Tableau, and MySQL for data analysis
  • Creating forecasts and models
  • Visualization design
  • Business Insights Communication
  • Optimization of income from residential properties
  • Research and improve real business processes
  • Presenting work to senior data scientists

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • Data Scientist
  • Data Project Manager
  • Business model developer
  • Data analysis specialist
  • Data visualization designer
  • Business consultant in the field of optimization
  • Data-driven Marketing Manager
  • Business Performance Analyst
  • Technology Product Manager

Internship – Series of 5 courses

In this specialization, you will learn how to formulate business challenges as data questions. You will use advanced tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights.

Final project

In the final project, you will apply your skills to research and justify improvements to a real business process. The project focuses on optimizing income from residential properties.

Airbnb, our official sponsor, contributed to the design of the project. Airbnb is the world’s largest marketplace that connects homeowners and travelers to facilitate short-term rental transactions.

The 10 finalists each year will have the opportunity to present their work directly to senior Airbnb data scientists live for feedback and dialogue.

Details of the courses that make up the specialization

Business metrics for data-driven companies

Lesson 1

7 hours
4.6 (8,391 reviews)

What you’ll learn

In this course, you will learn the best practices for using data analytics to make any company more competitive and profitable. You will be able to identify the most critical metrics for a business and separate them from mundane data.

Skills you will acquire

  • Category: Data Analysis
  • Category: Business Analysis
  • Category: Business Analytics
  • Category: Business Process

Lesson 2

21 hours
4.2 (3,918 reviews)

What you’ll learn

Important: This course focuses on mathematics—specifically, data analysis concepts and methods—and not Excel per se. The course will prepare you to design and implement realistic predictive models based on data.

Skills you will acquire

  • Category: Binary Sort
  • Category: Data Analysis
  • Category: Microsoft Excel
  • Category: Linear Regression

Lesson 3

24 hours
4.7 (3,197 reviews)

What you’ll learn

In this course, you will learn how to become a tool in the communicative language of a relevant business journey from data processes. You will also learn how to streamline your analyses and effectively highlight their implications using visualizations in Tableau.

Skills you will acquire

  • Category: Data Analysis
  • Category: SQL
  • Category: Tableau Software
  • Category: MySQL

Lesson 4

27 hours
4.7 (4,060 reviews)

What you’ll learn

This course is an introduction to using relational databases in business analysis. You will learn how relational databases work, and how to use entity-relationship diagrams.

Skills you will acquire

  • Category: Data Analysis
  • Category: SQL
  • Category: MySQL
  • Category: Teradata

Lesson 5

22 hours
4.7 (241 reviews)

What you’ll learn

In this final course, you will complete a final project using data analysis to recommend a method to improve profits at your company, Watershed Property Management, Inc.

Skills you will acquire

  • Category: Data Analysis
  • Category: Visualization (Computer Graphics)
  • Category: Tableau Software
  • Category: Data Visualization