← Back to dashboard
Reports
1 Executive Summary
Dataset
Members_Register_2025-26 (sample).xlsx — sheet “Members”
Total records
1,248
Number of columns
13
Date range
01 Oct 2025 – 27 Sep 2026 (Payment Date)
Complete records
795 (63.7%)
Records with missing information
453 (36.3%)
Possible duplicate records
18 (1.4%)
Data quality score
77 / 100
Numeric summaries
| Column | Count | Minimum | Maximum | Average | Median | Total |
|---|---|---|---|---|---|---|
| Amount | 1,248 | ₹0 | ₹10,000 | ₹2,500 | ₹1,000 | ₹31,20,000 |
Major categories
Gender
Male
660 records · 52.9%
Batch
2011
48 records · 3.9%
State
Delhi
284 records · 22.8%
District
New Delhi
81 records · 6.6%
Membership Type
Annual
696 records · 55.8%
Payment Status
Paid
939 records · 75.2%
Findings
- Missing information: 453 records (36.3%) have at least one missing field. The column with the most gaps is “Payment Date” (309 empty).
- Possible duplicates: 18 records appear to be possible duplicates (repeated values in “Mobile”, “Email”).
- Top state: 9 different values found in “State”. “Delhi” has the most records (284, 22.8%).
- Membership Type split: 55.8% of records are “Annual”, followed by “Life” (24.8%).
- Amount total: The “Amount” column totals ₹31,20,000 across 1,248 entries (average ₹2,500).
- Busiest period: Dec 2025 was the month with the highest total value (₹4,71,500).
- Date range: Records run from 01 Oct 2025 to 27 Sep 2026.
- Inconsistent spellings: “State” has the same value written in different ways (e.g. “Delhi” / “delhi”). A system with fixed choices avoids this.
- Mostly empty columns: 1 column(s) are at least half empty: “Remarks”.
2 Data Quality
| Column | Type | Records | Missing | Missing % | Unique | |
|---|---|---|---|---|---|---|
| Member ID | Identifier | 1,248 | 0 | 0.0% | 1,248 | |
| Name | Text | 1,248 | 0 | 0.0% | 523 | |
| Gender | Category | 1,248 | 0 | 0.0% | 2 | |
| Batch | Category | 1,248 | 9 | 0.7% | 39 | |
| State | Category | 1,248 | 0 | 0.0% | 9 | |
| District | Category | 1,248 | 12 | 1.0% | 28 | |
| Mobile | Identifier | 1,248 | 71 | 5.7% | 1,160 | |
| Identifier | 1,248 | 106 | 8.5% | 1,125 | ||
| Membership Type | Category | 1,248 | 0 | 0.0% | 4 | |
| Payment Status | Category | 1,248 | 0 | 0.0% | 3 | |
| Amount | Numeric | 1,248 | 0 | 0.0% | 5 | |
| Payment Date | Date | 1,248 | 309 | 24.8% | 295 | |
| Remarks | Category | 1,248 | 1,207 | 96.7% | 4 |
3 Duplicate Report
Possible duplicate records: 18.
Repeated values in “Mobile”
17 values appear more than once, creating 17 extra records.
| Duplicate key | Number of occurrences |
|---|---|
| 9725286362 | 2 |
| 9156488703 | 2 |
| 9355191687 | 2 |
| 9165933849 | 2 |
| 9937303825 | 2 |
| 9313297501 | 2 |
| 9625273243 | 2 |
| 9393955992 | 2 |
| 9378641551 | 2 |
| 9365905667 | 2 |
| 9721831535 | 2 |
| 9662663744 | 2 |
| 9619943899 | 2 |
| 9979368768 | 2 |
| 9246195496 | 2 |
| 9504153121 | 2 |
| 9720580166 | 2 |
Repeated values in “Email”
17 values appear more than once, creating 17 extra records.
| Duplicate key | Number of occurrences |
|---|---|
| anjali.jha621@example.com | 2 |
| diya.rao199@example.com | 2 |
| vivaan.patel937@example.com | 2 |
| manish.thakur874@example.com | 2 |
| karan.yadav230@example.com | 2 |
| pooja.singh775@example.com | 2 |
| nisha.sinha438@example.com | 2 |
| neha.joshi681@example.com | 2 |
| rakesh.rao122@example.com | 2 |
| arjun.gupta195@example.com | 2 |
| ritu.das491@example.com | 2 |
| sneha.yadav171@example.com | 2 |
| priya.mishra618@example.com | 2 |
| ritu.rao617@example.com | 2 |
| amit.patel958@example.com | 2 |
| aditya.yadav243@example.com | 2 |
| amit.rao344@example.com | 2 |
4 Category Summary
Gender
| Gender | Records | % | |
|---|---|---|---|
| Male | 660 | 52.9% | |
| Female | 588 | 47.1% |
Batch
| Batch | Records | % | |
|---|---|---|---|
| 2011 | 48 | 3.9% | |
| 2005 | 43 | 3.5% | |
| 2018 | 41 | 3.3% | |
| 1991 | 41 | 3.3% | |
| 2012 | 41 | 3.3% | |
| 1990 | 39 | 3.1% | |
| 2019 | 39 | 3.1% | |
| 1988 | 38 | 3.1% | |
| 2002 | 37 | 3.0% | |
| 1996 | 35 | 2.8% | |
| 2010 | 35 | 2.8% | |
| 2008 | 34 | 2.7% | |
| 2007 | 34 | 2.7% | |
| 2016 | 33 | 2.7% | |
| 2004 | 33 | 2.7% |
Top 15 shown — the Excel report has more.
State
| State | Records | % | |
|---|---|---|---|
| Delhi | 284 | 22.8% | |
| Bihar | 218 | 17.5% | |
| Uttar Pradesh | 187 | 15.0% | |
| Maharashtra | 132 | 10.6% | |
| Karnataka | 114 | 9.1% | |
| Jharkhand | 102 | 8.2% | |
| West Bengal | 78 | 6.2% | |
| Haryana | 70 | 5.6% | |
| Rajasthan | 63 | 5.0% |
District
| District | Records | % | |
|---|---|---|---|
| New Delhi | 81 | 6.6% | |
| North Delhi | 69 | 5.6% | |
| South Delhi | 67 | 5.4% | |
| East Delhi | 64 | 5.2% | |
| Bengaluru | 61 | 4.9% | |
| Mysuru | 52 | 4.2% | |
| Mumbai | 49 | 4.0% | |
| Pune | 48 | 3.9% | |
| Prayagraj | 46 | 3.7% | |
| Darbhanga | 46 | 3.7% | |
| Bhagalpur | 44 | 3.6% | |
| Patna | 44 | 3.6% | |
| Gaya | 42 | 3.4% | |
| Kolkata | 42 | 3.4% | |
| Kanpur | 41 | 3.3% |
Top 15 shown — the Excel report has more.
Membership Type
| Membership Type | Records | % | |
|---|---|---|---|
| Annual | 696 | 55.8% | |
| Life | 310 | 24.8% | |
| Student | 146 | 11.7% | |
| Patron | 96 | 7.7% |
Payment Status
| Payment Status | Records | % | |
|---|---|---|---|
| Paid | 939 | 75.2% | |
| Pending | 251 | 20.1% | |
| Waived | 58 | 4.6% |
Remarks
| Remarks | Records | % | |
|---|---|---|---|
| Will pay next month | 15 | 36.6% | |
| Called | 10 | 24.4% | |
| Address changed | 10 | 24.4% | |
| Lifetime upgrade | 6 | 14.6% |
Preparing reports like these every month?
A small online system can produce them automatically — always current, no copy-pasting.