Data Analysis & Visualization Masterclass (4 courses in 1)
- Description
- Curriculum
- FAQ
- Reviews
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.
This course is a complete package for everyone wanting to pursue a career in data analysis.
This course gives you complete knowledge from basics to advanced level on Excel, Python, and SQL.
You will learn to create interactive dashboards using Excel as well as Tableau.
In this course, we will cover:-
-
Excel fundamental concepts such as Sorting, Filtering, Statistical, and text functions
-
Excel functions for data analysis
-
SQL- DDL, DML, and DQL commands
-
Python fundamental concepts including Object-oriented programming
-
Introduction to the NumPy and the pandas’ library
-
Creating charts and dashboards using Tableau
-
And many more
This course is perfect for beginners who want to make their career in data analysis.
You will get to practice a lot of exercises and work on some exciting projects.
You will also have access to all the resources used in this course.
Enroll now and make the best use of this course.
-
1How is Excel important to businessesVideo lesson
-
2Understanding the excel interfaceVideo lesson
-
3Basic Formatting in ExcelVideo lesson
-
4Insertion and Deletion in ExcelVideo lesson
-
5Data Types in ExcelVideo lesson
-
6Quiz on Excel BasicsQuiz
-
7Quiz SolutionVideo lesson
-
8Applying the sort functionVideo lesson
-
9Applying the filter functionVideo lesson
-
10Applying the advanced filter functionVideo lesson
-
11Quiz on Sort and FilterQuiz
-
12Quiz SolutionVideo lesson
-
13Using the UPPER, LOWER and PROPER functionsVideo lesson
-
14Using the LEFT, RIGHT and SEARCH functionsVideo lesson
-
15Using the TRIM, CONCAT and LEN functionsVideo lesson
-
16Quiz on Text functionsQuiz
-
17Quiz SolutionVideo lesson
-
18Using the MIN, MAX AVERAGE functionsVideo lesson
-
19Finding the Standard deviationsVideo lesson
-
20Find the percentiles of dataVideo lesson
-
21Finding the Outliers present in dataVideo lesson
-
22Finding the Missing values in dataVideo lesson
-
23Quiz on Statistical functionsQuiz
-
24Quiz SolutionVideo lesson
-
25Using the IF functionVideo lesson
-
26Using the IF ERROR functionVideo lesson
-
27Applying the COUNTIF functionVideo lesson
-
28Applying the SUNIF functionVideo lesson
-
29Applying the AVERAGEIF functionVideo lesson
-
30Quiz on Logical functionsQuiz
-
31Quiz SolutionVideo lesson
-
32Using Colorbars for formattingVideo lesson
-
33Using Colorscales for formattingVideo lesson
-
34Quiz on Conditional FormattingQuiz
-
35Quiz SolutionVideo lesson
-
36Applying VLOOKUP functionVideo lesson
-
37Applying HLOOKUP functionVideo lesson
-
38Quiz on Lookup FunctionsQuiz
-
39Quiz SolutionVideo lesson
-
40Why to use Index and Match?Video lesson
-
41Applying Index and MatchVideo lesson
-
42Quiz on Index and MatchQuiz
-
43Quiz SolutionVideo lesson
-
44Making Pivot TablesVideo lesson
-
45Making Pivot ChartsVideo lesson
-
46Quiz on Pivot TablesQuiz
-
47Quiz SolutionVideo lesson
-
48Basics of Data VisualizationsVideo lesson
-
49Making Charts in ExcelVideo lesson
-
50Making DashboardsVideo lesson
-
51Adding Slicers in DashboardsVideo lesson
-
52Formatting dashboardsVideo lesson
-
53Quiz on DashboardsQuiz
-
54Quiz SolutionVideo lesson
-
55Goal Seek AnalysisVideo lesson
-
56Data TablesVideo lesson
-
57Scenario ManagementVideo lesson
-
58Quiz on What If AnalysisQuiz
-
59Quiz SolutionVideo lesson
-
60Understanding RegressionVideo lesson
-
61Performing Linear RegressionVideo lesson
-
62Quiz on RegressionQuiz
-
63Quiz SolutionVideo lesson
-
64Introduction to SQLVideo lesson
-
65Build your first SQL queryVideo lesson
-
66Basic SQL queries Part - 1Video lesson
-
67Basic SQL queries Part - 2Video lesson
-
68Brain Buster ExerciseVideo lesson
-
69Brain Buster SolutionVideo lesson
-
70Quiz on Introduction to SQLQuiz
-
71Quiz SolutionVideo lesson
-
72InstallationVideo lesson
-
73Interface walkthroughVideo lesson
-
74Creating Required DatabasesVideo lesson
-
75Quiz on Installation and set upQuiz
-
76Quiz SolutionVideo lesson
-
77Type of SQL CommandsVideo lesson
-
78The SELECT CommandVideo lesson
-
79Numerical FunctionsVideo lesson
-
80String FunctionsVideo lesson
-
81Exercises on String FunctionsVideo lesson
-
82The Having ClauseVideo lesson
-
83Filtering using the Like OperatorVideo lesson
-
84Quiz on DQLQuiz
-
85Quiz SolutionVideo lesson

External Links May Contain Affiliate Links read more