Academy
Courses
Contact
Login
☰ View Lessons
Course Lessons
chapter 1 : Data analytics
What is data analytics?
chapter 2 : Data cleaning
Data cleaning?
Missing Values
Duplicate Data
Case Sensitivity
Data Types
Outliers
chapter 3 : Quick Stats (Descriptive Statistics)
Quick Stats
Basic Stats
What Is an Outlier?
How to Practice Basic Stats & Outliers
chapter 4 : Data Variation
1. Variance
2. Standard Deviation (SD)
3. Coefficient of Variation (CV)
4 Practice Variance, Standard Deviation (SD), Coefficient of Variation (CV)
chapter 5 : Data Shape
1. Skewness
2. Kurtosis
chapter 6 : Correlation
Correlation
Why We Use Correlation?
Pearson Correlation (r)
Spearman Correlation (ρ or rₛ)
chapter 7 : Trend Analysis
Trend Analysis
1. Time forecasting
2. Trend Break Detection
3 Moving Average
chapter 8 : Grouping
Grouping
1. Group By Sum
2. Group By Mean (Average)
3. Group By Count
4. Group By Minimum
5. Group By Maximum
6. Group By Median
chapter 9 :AI insights
AI Insights
1. Anomaly Detection
2 .Forecast Suggestion (Predictive Forecasting)
3 Correlation Warning
4 Trend Direction Prediction
5 Seasonality Detection
6 Top Driver / Influencer Analysis
7 Productivity Improvement Prediction
8 Business Risk Warnings
chapter 10 : Certification
CERTIFICATION
Course Lessons
chapter 1 : Data analytics
What is data analytics?
chapter 2 : Data cleaning
Data cleaning?
Missing Values
Duplicate Data
Case Sensitivity
Data Types
Outliers
chapter 3 : Quick Stats (Descriptive Statistics)
Quick Stats
Basic Stats
What Is an Outlier?
How to Practice Basic Stats & Outliers
chapter 4 : Data Variation
1. Variance
2. Standard Deviation (SD)
3. Coefficient of Variation (CV)
4 Practice Variance, Standard Deviation (SD), Coefficient of Variation (CV)
chapter 5 : Data Shape
1. Skewness
2. Kurtosis
chapter 6 : Correlation
Correlation
Why We Use Correlation?
Pearson Correlation (r)
Spearman Correlation (ρ or rₛ)
chapter 7 : Trend Analysis
Trend Analysis
1. Time forecasting
2. Trend Break Detection
3 Moving Average
chapter 8 : Grouping
Grouping
1. Group By Sum
2. Group By Mean (Average)
3. Group By Count
4. Group By Minimum
5. Group By Maximum
6. Group By Median
chapter 9 :AI insights
AI Insights
1. Anomaly Detection
2 .Forecast Suggestion (Predictive Forecasting)
3 Correlation Warning
4 Trend Direction Prediction
5 Seasonality Detection
6 Top Driver / Influencer Analysis
7 Productivity Improvement Prediction
8 Business Risk Warnings
chapter 10 : Certification
CERTIFICATION
chapter 8 : Grouping
5. Group By Maximum
Group by Maximum
finds the
largest value
in each group.
Example Result
Region
Maximum Sales
East
200
West
250
⬅ Previous
Next ➜