Udemy - Data Analysis Masterclass (4 courses in 1) 2021-6
Data Analysis

Udemy – Data Analysis Masterclass (4 courses in 1) 2021-6

Description

Data Analysis Masterclass (4 courses in 1) is a training course on data visualization and data analysis skills using Excel, Python, SQL, and Tableau with practical exercises. Data analysis involves the process of auditing, refining, transforming, and modeling data with the goal of discovering useful information, announcing results, and supporting decision-making. This course gives you basic to advanced knowledge in Excel, Python and SQL.

What you will learn in the Data Analysis Masterclass (4 courses in 1):

  • Learn the basics of formatting in Excel
  • Sort and refine functions in Excel
  • Work with UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE functions in Excel
  • Find outliers and missing values ​​in Excel
  • Find standard deviations and percentiles using Excel
  • IF, IF ERROR, COUNTIF, SUMIF, and AVERAGEIF functions in Excel
  • Use the VLOOKUP and HLOOKUP functions to combine databases in Excel
  • Build interactive dashboards in Excel
  • Do What-if analysis
  • Using linear regression
  • Build databases and tables in SQL
  • Work with numeric and string functions in SQL
  • Learn the difference between DDL and DML commands
  • Communicate between Python and MySQL
  • Learn variables and data types in Python
  • Work with Numpy and Pandas libraries
  • Build a variety of charts using Tableau

See Also:

Udemy – Java Data Structures and Algorithms Masterclass 2021-5

Working with React and Go (Golang) 2021-6 Free Course

Learn TradingView Pine Script Programming From Scratch 2020-10

Udemy – Complete VMWare vSphere ESXi and vCenter Administration 2020-11

Complete WordPress Theme & Plugin Development Course [2021] Video

Course specifications

Publisher: Udemy
Instructors: Data Is Good Academy
Language: English
Education Level: Basic
Number of Courses: 204
Duration: 15 hours and 18 minutes

Course topics of 2021/6:

 

Data Analysis

Prerequisites for Data Analysis Masterclass (4 courses in 1):

No prior knowledge required

Pictures

 

Data Analysis

Installation guide

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p

download link

Download section 1 – 3 GB
Download Part 2 – 3 GB
Download section 3 – 3 GB
Download section 4 – 3 GB
Download Section 5 – 924 MB
file password link
Follow On Facebook
Follow On Linkedin
Follow On Reddit