
Publication number: ELQ-78616-1
View all versions & Certificate

MXDataKPI automated data cleansing and KPI dashboards
MXDataKPI is a game changing analytics engine that transforms Excel into a fully automated KPI intelligence system in minutes using raw data files.
Further information
Below is the full list of KPI analysis types included in MXDataKPI.
1. Trend Analysis
Identifies long term direction (upward, downward, stable).
Used when monitoring performance over time.
2. Forecasting
Predicts future values using statistical models.
Used for planning, budgeting, and capacity forecasting.
3. MoM (Month over Month) Change
Measures short term performance shifts.
Used for tactical decision making.
4. YoY (Year over Year) Change
Measures long term growth or decline.
Used for strategic performance evaluation.
5. Volatility Analysis
Measures variability and stability.
Used for risk assessment and operational control.
6. Outlier Detection
Identifies unusual spikes or drops.
Used for anomaly detection and root cause analysis.
7. Category Insights
Breaks KPIs down by category (product, region, segment).
Used for segmentation and prioritisation.
8. Data Quality Analysis
Measures completeness, missing values, and reliability.
Used to validate data integrity before decision making.
9. Forecast Confidence
Evaluates reliability of predictions.
Used for planning and scenario modelling.
10. KPI Dependency Analysis (optional)
Builds composite KPIs from other KPIs.
Used for advanced analytics and executive dashboards.
Technical Requirements
• Microsoft Excel (Windows)
• Macros enabled
• Standard enterprise datasets (CSV, XLSX, SQL extracts, etc.)
