Coursera – Excel to MySQL: Analytic Techniques for Business Specialization 2020-9

Description

Excel to MySQL: Analytic Techniques for Business Specialization is a training course on data analysis techniques for various professions and businesses. In today's business, data and information are among the most valuable assets. With this tutorial, you will learn how to change the course of your business by identifying and analyzing key metrics in relevant data. You will also learn to transform your professional and work challenges into questions from your job data; In this way, by answering these questions, you can also solve work challenges. Powerful tools and methods such as Excel, Tableau and MySQL are covered in this tutorial.

In this training, you will learn the key and important business metrics in companies that use data analysis for maximum productivity of their technical force, as well as their tools and methods. Using Excel and all its formulas and computational capabilities for data analysis, Tableau software for data visualization and big data management with MySQL are the main tools of this course. The final project of this training is dedicated to analyzing and reviewing Airbnb data; Airbnb is the world's largest marketplace for communication between property owners and travelers looking to rent a holiday property, and with this project, you can put all your learning and skills into real data.

What do you learn?

Binary classification

Data analysis and business

Tableau software, Excel, SQL language and MySQL system

Linear regression

DataViz

Illustration (computer graphics)

And

Excel to MySQL Specifications: Analytic Techniques for Business Specialization

Publisher: Coursera

Instructor: Daniel Egger, Jana Schaich Borg

English language

Level of training: Beginner

Number: 4 courses

Duration of the course: with a suggested time of 4 hours per week, approximately 7 months

Prerequisites

No prior experience with analytics or programming is required. This Specialization is intended for anyone with an interest in data analysis and its applications in business decision-making.

You will need access to Microsoft Excel 2007 (or a more recent version of Microsoft Excel). We will be using the free Solver plugin for optimization problems, and this functionality is not available in alternative online tools such as Google Sheets. The Specialization will also make use of freely-downloadable software packages such as Tableau.

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p