Analytical Techniques for Business Specialization

Description

Excel to MySQL: Analytic Techniques for Business Specialization is a training course on data analysis techniques for different professions and businesses. In today’s businesses, data and information are among the most valuable assets. With the help of this training, you will learn how to change your business process by identifying and analyzing key criteria in related 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.

During this training, you will get to know the key and important business criteria in companies that use data analysis for maximum productivity of their technical force, as well as their tools and methods. The use of Excel and all its formulas and calculation capabilities for data analysis, Tableau software for data visualization and managing huge data with MySQL are the main tools of this course. The final project of this training is also dedicated to the analysis and review of Airbnb company data; Airbnb is the world’s largest marketplace for communicating between property owners and travelers looking for vacation rentals, and during this project, you can apply all your learning and skills to real data.

What you will learn in Excel to MySQL: Analytic Techniques for Business Specialization:

Binary classification
Data and business analysis
Tableau software, Excel, SQL language and MySQL system
Linear regression
Data visualization (DataViz)
Illustration (computer graphics)
And …

Specifications Excel to MySQL: Analytic Techniques for Business Specialization :

Publisher: Coursera
teacher : Daniel Egger , Jana Schaich Borg
English language
Training level: beginner
Number: 5 courses
Duration of the course: with a suggested time of 4 hours per week, approximately 7 months

courses

Course 1

Business Metrics for Data-Driven Companies

Course 2

Mastering Data Analysis in Excel

Course 3

Data Visualization and Communication with Tableau

Course 4

Managing Big Data with MySQL

Course 5

Increasing Real Estate Management Profits: Harnessing Data Analytics

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.