Data Analysis Masterclass (4 courses in 1) Free Download Tutorials

What you’ll study

Learn about primary formatting in excel

Advertisements
Learn about sorting and filtering capabilities in excel
Learn about UPPER, LOWER, PROPER, LEFT, RIGHT, SEARCH, CONCATENATE capabilities in excel
Learn methods to discover outliers and lacking values in Excel
Learn methods to discover customary deviation and percentiles in information utilizing Excel
Learn about IF, IF ERROR, COUNTIF, SUMIF and AVERAGEIF capabilities in excel
Learn about utilizing Color Bars and Color scales in excel
Learn making use of VLOOKUP and HLOOKUP capabilities and merge datasets utilizing them in excel
Learn methods to merge datasets utilizing Index and match
Learn making Pivot Tables and Pivot charts in excel
Learn making interactive dashboards in excel
Learn about What-if evaluation in excel
Learn methods to carry out linear regression in excel
Learn about creating databases and tables in SQL
Learn about Numerical, string capabilities in SQL
Learn about filtering utilizing LIKE operator in SQL
Learn about totally different DDL and DML instructions
Learn about Joins and Subqueries in SQL
Learn connecting Python and MySQL
Learn about variables and information sorts in Python
Learn about loops and conditionals in python
Learn about Regular expressions and date time objects in Python
Learn concerning the Numpy and the Pandas library
Learn about creating totally different chart sorts utilizing Tableau

Basic Formatting in Excel

02:08
Insertion and Deletion in Excel

02:07
Applying the kind perform

02:09
Applying the superior filter perform

02:48
Using the UPPER, LOWER and PROPER capabilities

03:16
Using the LEFT, RIGHT and SEARCH capabilities

03:20
Using the TRIM, CONCAT and LEN capabilities

02:46
Exercise on Text Functions

03:27
Solution on Text Functions

06:18
Using the MIN, MAX AVERAGE capabilities

02:13
Finding the Standard deviations

03:03
Find the percentiles of information

02:58
Finding the Outliers current in information

03:38
Finding the Missing values in information

01:49
Quiz on Statistical capabilities

5 questions
Exercise on Descriptive Statistics

03:08
Solution on Descriptive Statistics

04:53
Exercise on Data Cleaning

02:44
Solution on Data Cleaning

07:19
Using the IF ERROR perform

02:12
Applying the COUNTIF perform

02:10
Applying the SUMIF perform

01:55
Applying the AVERAGEIF perform

01:56
Quiz on Logical capabilities

5 questions
Exercise on Logical Functions

03:36
Solution on Logical Functions

07:21
Exercise on Conditional Formatting

03:03
Solution on Conditional Formatting

04:29
Using Colorbars for formatting

01:47
Using Colorscales for formatting

01:39
Quiz on Conditional Formatting

6 questions

Applying VLOOKUP perform

03:32
Exercise on Lookup Functions

02:07
Solution on Lookup Functions

04:55
Why to make use of Index and Match?

02:29
Exercise on Index and Match Functions

02:54
Solution on Index and Match Functions

06:59
Basics of Data Visualizations

02:09
Adding Slicers in Dashboards

02:3
Exercise on Data Visualizations

02:50
Solution on Data Visualizations

03:55

Creating Databases and Tables

09:00
Alter, Drop, and Truncate

03:30
Insert, Update, and Delete

04:48
Left, Right, and Outer Join

06:59
Compound Joins, and Multiple Joins

04:14
Quiz on Joins, Sub Queries & Set Operations

7 questions
Connecting MySQL by Python

06:23
Loading Tables right into a Pandas DataBody

04:12
Quiz on Accessing Databases utilizing Python

5 questions

Why must you study Python?

06:19
Installing Python and Jupyter Notebook

06:27
Understanding the Interface of Jupyter Notebook

06:41
Naming Convention for variables

07:37
Built in Data Types and Type Casting

07:19
Quiz on Variables and Data Types

5 questions
Exercise on Variables and Data Types

02:43
Solution on Variables and Data Types

02:37
Exercise on Scope of Variables

03:57
Solution on Scope of Variables

02:39
Arithmetic and Assignment Operators

08:42
Comparison, Logical, and Bitwise Operators

07:49
Identity and Membership Operators

03:17
Exercise on Arithmetic and Assignment Operators

03:50
Solution on Arithmetic and Assignment Operators

03:21
Exercise on Comparison, Logical, and Bitwise Operators

04:06
Solution on Comparison, Logical, and Bitwise Operators

03:33
Exercise on Identity and Membership Operators

03:26
Solution on Identity and Membership Operators

02:36
Quiz on Loops and conditionals

6 questions
Exercise on Loops and Conditionals

03:52
Solution on Loops and Conditionals

04:32

Exercise on Date and Time

03:32
Solution on Date and Time

03:37
Meta Characters for Regular Expressions

05:17
Built-in Functions for Regular Expressions

02:28
Special Characters for Regular Expressions

02:50
Sets for Regular Expressions

04:19
Quiz on Regular Expressions

5 questions
Exercise on Regular Expressions

03:17
Solution on Regular Expressions

03:31
Array Creation utilizing Numpy

03:35
Mathematical Operations utilizing Numpy

02:53
Built-in Functions in Numpy

02:56
Quiz on Introduction to Numpy

5 questions
Exercise on Built-in Functions in Numpy

03:28
Solution on Built-in Functions in Numpy

03:16
Reading Datasets utilizing Pandas

03:46
Indexing, Selecting, and Filtering Data utilizing Pandas

04:46
Merging and Concatenating DataFrames

04:59
Lambda, Map, and Apply Functions

02:22
Quiz on Introduction to Pandas

5 questions
Exercise on Pandas Plotting

02:38
Solution on Pandas Plotting

03:55
Exercise on Indexing and Selecting

02:52
Solution on Indexing and Selecting

03:07
Exercise on Apply Functions

03:29
Solution on Apply Functions

03:25

Getting Started with Tableau

07:15
Creating Your First Visualization

09:03
Building Your First Dashboard

05:28
Quiz on Creating your First Tableau Dashboard

7 questions
Working with Time Series Data

09:43
Aggregation and Granularity

08:43
Marks playing cards & Level of Detail

13:08
Exercise on Building Blocks of Data Visualization

01:43
Solution on Building Blocks of Data Visualization

14:37
Quiz on Building Blocks of Data Visualization

8 questions
Highlight Table Bar Charts & Sorting

06:14
Pie Chart Exercise Solution

04:21
Exercise on Tableau Basic Visualization (Vietnam War Dataset)

10:33
Solution on Tableau Basic Visualization

22:34
Quiz on Tableau Basic Visualization

5 questions
Theme & Workbook Level Formatting

04:41
Axis Lines and Formatting

08:30
Formatting Pane – Part 2 (Fonts, Alignment & Shading)

08:58
Formatting Pane – Part 3 (Borders & Lines)

05:41
Styling and Customizing a Tooltip

04:48
Section Exercise – Data Ink Ratio

02:16
Section Exercise Solution – Data Ink Ratio

07:38
Quiz on Formatting in Tableau

5 questions

Requirements

No prior information required
Determination and Desire to Learn new issues.
A constructive angle to success.
A willingness to study and follow.

Welcome to one of the best on-line course on Data Analysis and Data Visualization.

Data evaluation is a technique of inspecting, cleaning, reworking, and modeling information with the aim of discovering helpful data, informing conclusions, and supporting decision-making.

Data evaluation has a number of sides and approaches, encompassing various methods underneath a wide range of names, and is used in totally different enterprise, science, and social science domains.

This course is an entire package deal for everybody eager to pursue a profession in information evaluation.

This course provides you full information from fundamentals to superior degree on Excel, Python, and SQL.

You will study to create interactive dashboards utilizing Excel in addition to Tableau.

In this course, we are going to cowl:-

Excel elementary ideas comparable to Sorting, Filtering, Statistical, and textual content capabilities
Excel capabilities for information evaluation
SQL- DDL, DML, and DQL instructions
Python elementary ideas together with Object-oriented programming
Introduction to the NumPy and the pandas’ library
Creating charts and dashboards utilizing Tableau
And many extra

This course is ideal for novices who need to make their profession in information evaluation.

You will get to follow plenty of workout routines and work on some thrilling initiatives.

Instructor Support – Quick Instructor Support for any queries.

I’m trying ahead to see you in the course!

You can even have entry to all of the sources used in this course.

Enroll now and make one of the best use of this course.

Who this course is for:

Data Analysts
Job-seekers
Anyone who needs to discover information science.
Students and professionals who need to enhance the coaching capabilities
This course is for you if you happen to like thrilling challenges
Take your profession to the following degree
Programming novices
Anyone who needs to study probably the most often used Excel capabilities and methods utilized by analysts

An Google, Facebook, Kaggle Grandmasters group

We’re a bootstrapped, “indie” tech training firm. Our imaginative and prescient is to Unlock human potential by reworking training and making it accessible and inexpensive to all.

We are fiercely impartial and proud with a sole focus to make world-class tech training a degree taking part in discipline for anybody on this planet.

Data is Good is on a Mission to create courses that can make our college students study the topic and fall in love with it & turn out to be lifelong passionate learners and explorers of that topic.