InsightIQ

Business Intelligence & Data Analytics Platform

InsightIQ is a browser-based Business Intelligence platform designed for exploratory data analysis, statistical profiling, and interactive visualization of CSV datasets. It enables analysts to upload datasets, perform descriptive analytics, explore relationships between variables, and generate business insights through an intuitive dashboard.

Overview

The platform provides an interactive analytics workspace for examining structured datasets without requiring any backend setup. It combines data profiling, statistical analysis, visualization, correlation analysis, and reporting into a single web application.

Features

Dashboard

• Interactive KPI dashboard
• Dataset overview
• Data completeness analysis
• Outlier detection
• Distribution analysis
• Category breakdown
• Time-series visualization

Data Explorer

• CSV import
• Full-text search
• Column sorting
• Paginated data table
• Export filtered dataset

Statistical Analytics

• Mean
• Median
• Standard Deviation
• Quartiles
• Interquartile Range (IQR)
• Box Plot
• Histogram
• Outlier Detection (IQR Method)

Correlation Analysis

• Pearson Correlation Matrix
• Correlation Heatmap
• Correlation Threshold Filtering
• Absolute Correlation View

Reports

• Automated Data Quality Summary
• Column Profiling
• Statistical Insights
• Dataset Summary
• HTML Report Export

SQL Query Console (Coming Soon)

• SELECT queries
• WHERE filtering
• GROUP BY
• ORDER BY
• Aggregate Functions
• Query Result Visualization

Technology Stack

Frontend

• HTML5
• CSS3
• JavaScript (ES6)

Libraries

• Chart.js
• PapaParse
• jStat

Project Structure

InsightIQ/
│
├── index.html
├── styles.css
├── app.js
├── README.md
│
└── assets/

How to Run

1. Clone the repository

   git clone https://github.com/Haridyanshu/InsightIQ.git
   

2. Open the project folder

   cd InsightIQ
   

3. Launch index.html

No installation or server setup is required.

Key Functionalities

• Automatic dataset profiling
• Numeric and categorical column detection
• Missing value analysis
• Descriptive statistics
• Correlation analysis
• Interactive visualizations
• Searchable data explorer
• CSV import/export
• Automated report generation

Future Enhancements

• SQL Query Console
• Calculated Fields
• Custom KPI Builder
• Dashboard Export
• Dark/Light Theme
• Additional Statistical Tests
• Advanced Filtering
• Session Persistence

Author

Haridyanshu

• GitHub: https://github.com/Haridyanshu