Data Analysis & Visualization Masterclass (4 courses in 1)

Short Description

Learn how to build your Data Analysis and Data Visualization skills using Excel, Python, SQL and Tableau with exercises

What you’ll learn

  • Learn about basic formatting in excel
  • Learn about sorting and filtering functions in excel
  • Learn about UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE functions in excel
  • Learn how to find outliers and missing values in Excel
  • Learn how to find standard deviation and percentiles in data using Excel
  • Learn about IF, IF ERROR, COUNTIF, SUMIF and AVERAGEIF functions in excel
  • Learn about using Color Bars and Color scales in excel
  • Learn applying VLOOKUP and HLOOKUP functions and merge datasets using them in excel
  • Learn how to merge datasets using Index and match
  • Learn making Pivot Tables and Pivot charts in excel
  • Learn making interactive dashboards in excel
  • Learn about What-if analysis in excel
  • Learn how to perform linear regression in excel
  • Learn about creating databases and tables in SQL
  • Learn about Numerical, string functions in SQL
  • Learn about filtering using LIKE operator in SQL
  • Learn about different DDL and DML commands
  • Learn about Joins and Subqueries in SQL
  • Learn connecting Python and MySQL
  • Learn about variables and data types in Python
  • Learn about loops and conditionals in python
  • Learn about Regular expressions and date time objects in Python
  • Learn about the Numpy and the Pandas library
  • Learn about creating different chart types using Tableau

This course includes:

  • 15.5 hours on-demand video
  • 2 articles
  • 56 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Requirements

  • No prior knowledge required

Description

Welcome to the best online course on Data Analysis and Data Visualization.

Data analysis is a process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, and is used in different business, science, and social science domains.

Checkout: Crypto Mining course

MORE COURSE