Data Analytics: From Zero to Hero - U-learns

Current Status

Not Enrolled

Price

$90

Get Started

Take this Course

Course Description:

Data Analytics: From Zero to Hero is designed to provide a comprehensive introduction to the field of data analytics. This course covers everything from the fundamentals to advanced techniques, ensuring participants develop a solid understanding of data analysis tools and methodologies. By the end of the course, students will be proficient in using Excel, SQL, R Programming, and Power BI to analyze and visualize data effectively.

Course Content

Week 1

Introduction to Data Analysis

Introduction to MS Excel for Data Analysis

VLOOKUP and Advanced Excel Functions

Conditional Formatting

MATCH, INDEX, and DATE Formulas

Week 2

Data Validation

Data Analysis Project Using Excel

Week 3

MySQL installation

Introduction to MySQL

Sorting, Filtering and Working with NULL Values

Pattern Matching

Group by & Having clause

week 4

Date and time funcations

Data Analysis with MySQL

Week 5

Introduction of R programing

R Combining Datasets Using Joins

R_combining Datasets Using Merge

1 of 2