This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
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 include 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.
Instructor Support – Quick Instructor Support for any queries.
I’m looking forward to see you in the course!
You will also have access to all the resources used in this course.
Enroll now and make the best use of this course.
Excel for Data Analysis
-
1How is Excel important to businesses
-
2Understanding the excel interface
-
3Basic Formatting in Excel
-
4Insertion and Deletion in Excel
-
5Data Types in Excel
-
6Q and A
-
7Thanks for your Support
-
8Quiz on Excel Basics
-
9Quiz Solution
-
10Applying the sort function
-
11Applying the filter function
-
12Applying the advanced filter function
-
13Quiz on Sort and Filter
-
14Quiz Solution
-
15Exercise on Filters
-
16Solution on Filters
-
17Using the UPPER, LOWER and PROPER functions
-
18Using the LEFT, RIGHT and SEARCH functions
-
19Using the TRIM, CONCAT and LEN functions
-
20Quiz on Text functions
-
21Quiz Solution
-
22Exercise on Text Functions
-
23Solution on Text Functions
-
24Using the MIN, MAX AVERAGE functions
-
25Finding the Standard deviations
-
26Find the percentiles of data
-
27Finding the Outliers present in data
-
28Finding the Missing values in data
-
29Quiz on Statistical functions
-
30Quiz Solution
-
31Exercise on Descriptive Statistics
-
32Solution on Descriptive Statistics
-
33Exercise on Data Cleaning
-
34Solution on Data Cleaning
-
35Using the IF function
-
36Using the IF ERROR function
-
37Applying the COUNTIF function
-
38Applying the SUMIF function
-
39Applying the AVERAGEIF function
-
40Quiz on Logical functions
-
41Quiz Solution
-
42Exercise on Logical Functions
-
43Solution on Logical Functions
-
44Using Colorbars for formatting
-
45Using Colorscales for formatting
-
46Quiz on Conditional Formatting
-
47Quiz Solution
-
48Exercise on Conditional Formatting
-
49Solution on Conditional Formatting
Introduction to SQL
-
50Applying VLOOKUP function
-
51Applying HLOOKUP function
-
52Quiz on Lookup Functions
-
53Quiz Solution
-
54Exercise on Lookup Functions
-
55Solution on Lookup Functions
-
56Why to use Index and Match?
-
57Applying Index and Match
-
58Quiz on Index and Match
-
59Quiz Solution
-
60Exercise on Index and Match Functions
-
61Solution on Index and Match Functions
-
62Making Pivot Tables
-
63Making Pivot Charts
-
64Quiz on Pivot Tables
-
65Quiz Solution
-
66Exercise on Pivot Tables
-
67Solution on Pivot Tables
-
68Basics of Data Visualizations
-
69Making Charts in Excel
-
70Making Dashboards
-
71Adding Slicers in Dashboards
-
72Formatting dashboards
-
73Quiz on Dashboards
-
74Quiz Solution
-
75Exercise on Data Visualizations
-
76Solution on Data Visualizations
-
77Exercise on Dashboards
-
78Solution on Dashboards
-
79Goal Seek Analysis
-
80Data Tables
-
81Scenario Management
-
82Quiz on What If Analysis
-
83Quiz Solution
-
84Understanding Regression
-
85Performing Linear Regression
-
86Quiz on Regression
-
87Quiz Solution