/CourseBundles(20005)/1695510-1.png)
Course Overview
Schedule of Classes
Start Date & End Date
Aug 01 2022 - Aug 31 2022
Total Classes
1 Classes
Course Curriculum
4 Subjects
Excel
10 Exercises • 41 Learning Materials
Excel Basics
1.How is Excel important to businesses
External Link
2. Understanding the excel interface
External Link
3. Basic Formatting in Excel
External Link
4. Insertion and Deletion in Excel
External Link
5. Data Types in Excel
External Link
Excel Basics Quiz
Exercise
Sort and Filter
1. Applying the sort function
External Link
2. Applying the filter function
External Link
3. Applying the advanced filter function
External Link
Text functions
1. Using the UPPER, LOWER and PROPER functions
External Link
2. Using the LEFT, RIGHT and SEARCH functions
External Link
3. Using the TRIM, CONCAT and LEN functions
External Link
Text Functions Quiz
Exercise
Statistical functions
1. Using the MIN, MAX AVERAGE functions
External Link
2. Finding the Standard deviations
External Link
3. Find the percentiles of data
External Link
4. Finding the Outliers present in data
External Link
5. Finding the Missing values in data
External Link
Statistical Functions Quiz
Exercise
Logical functions
1. Using the IF function
External Link
2. Using the IF ERROR function
External Link
3. Applying the COUNTIF function
External Link
4. Applying the SUMIF function
External Link
5. Applying the AVERAGEIF function
External Link
Logical Functions Quiz
Exercise
Conditional Formatting
1. Using Colorbars for formatting
External Link
2. Using Colorscales for formatting
External Link
Lookup Functions
1. Applying VLOOKUP function
External Link
Applying HLOOKUP function
External Link
Lookup Functions Quiz
Exercise
Index and Match
Why to use Index and Match?
External Link
Applying Index and Match
External Link
Index and Match Function Quiz
Exercise
Pivot Tables
Making Pivot Tables
External Link
Making Pivot Charts
External Link
Pivot Tables Quiz
Exercise
Dashboards
Basics of Data Visualizations
External Link
Making Charts in Excel
External Link
Making Dashboards
External Link
Adding Slicers in Dashbaords
External Link
Formatting dashboards
External Link
Dashboards Quiz
Exercise
What If Analysis
Goal Seek Analysis
External Link
Data Tables
External Link
Scenario Management
External Link
What -if Analysis
Exercise
Regression
Understanding Regression
External Link
Performing Linear Regression
External Link
Linear Regression Quiz
Exercise
Python
8 Exercises • 69 Learning Materials
About this Course
About this Course
Variable, Data Type, Operator
ZIP
Strings
ZIP
Loops and Conditionals
ZIP
Getting Started
Why Shoul we learn Python
External Link
Installing Python and Jupyter Notebook
External Link
Variables and Data Types
Naming Convention for variables
External Link
Built in Data Types and Type Casting
External Link
Scope of Variables
External Link
Exercise on Variables and Data Types
External Link
Solution on Variables and Data Types
External Link
Exercise on Scope of Variables
External Link
Solution on Scope of Variables
External Link
Variables and Datatypes Quiz
Exercise
Operators
Arithmetic and Assignment Operators
External Link
Comparison, Logical, and Bitwise Operators
External Link
Identity and Membership Operators
External Link
Exercise on Arithmetic and Assignment Operators
External Link
Solution on Arithmetic and Assignment Operators
External Link
Exercise on Comparison, Logical, and Bitwise Operators
External Link
Solution on Comparison, Logical, and Bitwise Operators
External Link
Exercise on Identity and Membership Operators
External Link
Solution on Identity and Membership Operators
External Link
Operators Quiz
Exercise
Strings
String Formatting
External Link
String Methods
External Link
User Input
External Link
Exercise on Strings
External Link
Solution on Strings
External Link
Strings Quiz
Exercise
Loops and Conditionals
If, elif, and else
External Link
For and While
External Link
Break and Continue
External Link
Exercise on Loops and Conditionals
External Link
Solution on Loops and Conditionals
External Link
Loops and Conditionals Quiz
Exercise
Lists and Tuples
Differences between Lists and Tuples
External Link
Operations on Lists
External Link
Operations on Tuples
External Link
Exercises on Lists
External Link
Solution on Lists
External Link
List and Tuples Quiz
Exercise
Sets and Dictionaries
Introduction to Dictionaries
External Link
Operations on Dictionaries
External Link
Nested Dictionaries
External Link
Introduction to Sets
External Link
Set Operations
External Link
Exercises on Dictionaries
External Link
Solution on Dictionaries
External Link
Exercises on Sets
External Link
Solution on Sets
External Link
Sets and Dictionaries Quiz
Exercise
Stacks and Queues
Introduction to Stacks and Queues
External Link
Implementing Stacks and Queues using Lists
External Link
Implementing Stacks and Queues using Deque
External Link
Exercises on Stacks and Queues
External Link
Solution on Stacks and Queues
External Link
Stacks and Queues Quiz
Exercise
Searching, Sorting, and Time Complexity
Time Complexity
External Link
Linear Search
External Link
Binary Search
External Link
Bubble Sort
External Link
Insertion and Selection Sort
External Link
Merge Sort
External Link
Exercise on Searching and Sorting
External Link
Solution on Searching and Sorting
External Link
Exercise on Time Complexity
External Link
Solution on Time Complexity
External Link
Searching, sorting, time complexity Quiz
Exercise
Resources
Lists and Tuples
ZIP
Sets and Dictionaries – Materials
ZIP
Stacks and Queues – Materials
ZIP
Variables
ZIP
Data-Types
ZIP
Operators
ZIP
Strings
ZIP
Loops-and-Conditionals
ZIP
SQL
7 Exercises • 54 Learning Materials
Getting Started
Introduction to SQL
External Link
Build your first SQL query
External Link
Basic SQL queries Part - 1
External Link
Basic SQL queries Part - 2
External Link
Brain Buster Exercise
External Link
Brain Buster Solution
External Link
Getting started Quiz
Exercise
Installation and Set up
Installation
External Link
Interface walkthrough
External Link
Creating Required Databases
External Link
Introduction to DQL
Type of SQL Commands
External Link
The SELECT Command
External Link
Numerical Functions
External Link
String Functions
External Link
Exercises on String Functions
External Link
The Having Clause
External Link
Filtering using the Like Operator
External Link
Introduction to DQL
Exercise
Introduction to DDL and DML
Numerical Datatypes
External Link
String Datatypes
External Link
Constraints
External Link
Creating Databases and Tables
External Link
Alter, Drop, and Truncate Lesson pageSettings
External Link
Insert, Update, and Delete
External Link
Introduction to DDL and DML Quiz
Exercise
Joins, Sub Queries, & Set Operations
Foreign Key
External Link
Joins
External Link
Left, Right, and Outer Join
External Link
Compound Joins, and Multiple Joins
External Link
Star Schema
External Link
Sub Queries Part 1
External Link
Sub Queries Part 2
External Link
Joins, Subqueries, & Set Operations Quiz
Exercise
Accessing Databases using Python
Connecting MySQL through Python
External Link
Loading Tables into a Pandas DataFrame
External Link
Accessing Database using Python Quiz
Exercise
Introduction to Big Query
What is Big query
External Link
How Big query works
External Link
Getting started with GCP and Big Query
External Link
Importing Dataset and Executing your first Big query
External Link
Visualizing using Data Studio
External Link
BI Engine
External Link
SQL exercise on Big query
External Link
Introduction to big query Quiz
Exercise
Big Query for Data Analysis
Use of Big query in Data Analysis
External Link
Exploring Big query dataset on Kaggle kernel
External Link
Connecting Big query to Tableau Desktop for Visualizations
External Link
Data Analysis project - Part 1 (Introduction and Setting up Problem statement)
External Link
Data Analysis project - Part 2 (Exercises and Solutions)
External Link
Data warehouse
What is Data warehouse
External Link
Properties of modern Data warehouse
External Link
Alternatives to Big query
External Link
Data warehouse Quiz
Exercise
Resources
Installation and Set up
ZIP
Introduction to DQL
ZIP
Course PPTs
ZIP
Course PPTs
ZIP
Introduction to DDL and DML
ZIP
Joins, Sub queries and set operations
ZIP
Accessing Databases using Python
ZIP
Course PPTs
ZIP
Statistics and Hypothesis Testing
0 Exercises • 54 Learning Materials
Resources
Statistics and Probability - Materials
ZIP
Hypothesis Testing Material
ZIP
Introduction to Statistics
Why you should learn Statistics and Probability
External Link
Walking through the course Content
External Link
Introduction to Probability
Applications of Probability in Real Life
External Link
Basic Probability
External Link
Conditional Probability
External Link
Bayes' Theorem
External Link
Set Theory
External Link
Permutations and Combinations
External Link
Quiz on Probability
Quiz Solution on Probability
External Link
Descriptive Statistics
Types of Data
External Link
Measures of Central Tendency
External Link
Measures of Spread
External Link
Measures of Dependence
External Link
Quiz on Descriptive Statistics
Quiz Solution on Descriptive Statistics
External Link
Statistical Distributions
Continuous vs Discrete Distributions
External Link
Introduction to Normal Distribution
External Link
Concept of Skewness
External Link
Using QQ Plots to check Normal Distribution
External Link
Quiz on Statistical Distributions
Quiz Solution on Statistical Distributions
External Link
Inferential Statistics
Sample Mean and Population Mean
External Link
Central Limit Theorem
External Link
Bias and Variance
External Link
Maximum Likelihood Estimation
External Link
Confidence Intervals
External Link
Quiz on Inferential Statistics
Quiz Solution on Inferential Statistics
External Link
Introduction to Hypothesis Testing
What is Hypothesis Testing
External Link
Null Hypothesis and Alternate Hypothesis
External Link
Types of Error
External Link
P-Value and Level of Significance
External Link
Quiz on Hypothesis Testing
Quiz Solution on Hypothesis Testing
External Link
Student's T Test
One Sampled T Test
External Link
Two Sampled T Test
External Link
Paired Sampled T Test
External Link
Quiz on Student's T Test
Quiz Solution on Student's T Test
External Link
Z Test
One Sampled Z Test
External Link
Two Sampled Z Test
External Link
Quiz on Z Test
Quiz Solution on Z Test
External Link
ANOVA Test
One Sampled ANOVA Test
External Link
Two Sampled ANOVA Test
External Link
Quiz on ANOVA Test
Quiz Solution on ANOVA Test
External Link
Chi Squared Test
Goodness of Fit Test
External Link
Test of Independence
External Link
Quiz on Chi Squared Test
Quiz Solution on Chi Squared Test
External Link
Course Instructor
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy