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
3. Group By Count
Group by Count
counts the number of records in each group.
Example
Region
Sales
East
100
East
200
West
150
West
250
West
100
Result (Group by Count):
Region
Number of Orders
East
2
West
3
⬅ Previous
Next ➜