# ParagKar. ## Posts - [India’s Mobile Data Tax Impact Analysis](https://paragkar.com/indias-mobile-data-tax-impact-analysis/): How a ₹1 per GB Data Tax Could Change Mobile Tariffs in India India’s telecom sector is already among the most heavily taxed industries, contributing through multiple channels such as license fees, spectrum usage charges (SUC), spectrum auction payments, and GST. Recent media reports suggest that the Government may be exploring the possibility of introducing a mobile data tax as part of a broader policy discussion around digital usage and screen addiction. But what would such a tax actually mean for consumers? To understand the real impact, I built a data-driven simulation model that estimates how a ₹1 per GB […] - [Satellite Communication Course — Animations, Scripts & Learning Resources](https://paragkar.com/satellite-communication-course-animations-scripts-learning-resources/): This page is continuously updated with animations, scripts, slides and learning material from the satellite communication video series. Module 1 Foundations of Satellite Systems VideoAnimation explorerScript Module 2 Module 2 – Satellite Spectrum Bands VideoAnimation explorerScript Module 3 Module 2 – Satellite Network Architecture — Bent Pipe, Laser Links & Satellite Lifecycle VideoAnimation explorerScript Module 4 Module 4 – Why Satellite Systems Use FDD Instead of TDD VideoAnimation explorerScript Module 5 Module 5 — Satellite Spectrum Sharing & Interference Management VideoAnimation explorerScript Module 6 Module 5 — Satellite Spectrum Sharing & Interference Management VideoAnimation explorerScript - [Spectrum Pricing in India – Data, Models & Distortions (2010–2024)](https://paragkar.com/spectrum-pricing-in-india-data-models-distortions-2010-2024/): Interactive valuation tool, auction datasets, and full 100-page research presentation examining reserve price design and price discovery failures. This page provides a structured, data-driven examination of India’s spectrum pricing framework from 2010 to 2022. Over the past decade, spectrum auctions in India have produced repeated distortions — including artificial price benchmarks, renewal-driven bidding spikes, indexed reserve pricing, and large quantities of unsold spectrum. This research initiative brings together the historical data, analytical tools, and a simplified valuation framework to enable transparent public scrutiny. The objective is not to criticize institutions, but to evaluate outcomes using evidence. This page contains three […] - [India Budget Expenditure Trends Tool (FY2017–FY2027)](https://paragkar.com/india-budget-expenditure-trends-tool-fy2017-fy2027/): Interactive file to analyze 9-year trends in Revenue Expenditure, Capital Expenditure, and Interest Payments across Union Budgets. This interactive tool lets you explore 9-year trends (FY2017–FY2027) in India’s Union Budget expenditure, including Revenue Expenditure, Capital Expenditure, and Interest Payments across major departments. Use it to analyze value terms, percentage shares, and % of GDP with easy-to-use filters and visualizations. Download File:https://paragkar.com/budget-expenditure-trend-tool Online Tool:https://gemini.google.com/share/ff7296b34dd0 - [India’s Budget 2026: What 8 Years of Fiscal Data Reveals About Revenue, Expenditure, and Deficit Risks](https://paragkar.com/indias-budget-2025-what-8-years-of-fiscal-data-reveals-about-revenue-expenditure-and-deficit-risks/): A data-driven analysis of Government of India accounts (FY17–FY25) to understand fiscal constraints ahead of the Union Budget 2026. As India prepares for the Union Budget 2026, it is essential to move beyond headline numbers and examine how government finances have actually performed in the past. Historical data provides critical insight into future fiscal constraints, revenue risks, and expenditure pressures. This analysis uses 8 years of Government of India accounts data (FY17–FY25), sourced from the Controller General of Accounts (CGA), and evaluates performance against Budget Estimates on a month-by-month and year-wise basis, expressed as a percentage of GDP. The focus […] - [TRAI Telecom Subscription Data – Wireless Subscribers Analysis (Feb 2026)](https://paragkar.com/trai-telecom-subscription-data-wireless-subscribers-analysis-nov-2025/): Understanding HLR vs VLR Trends, Net Adds, and Market Share Across Operators and Circles This page presents a focused, data-driven analysis of India’s wireless subscribers using TRAI’s Telecom Subscription Data as of 30 November 2025. Instead of looking only at headline subscriber numbers, the analysis dives into HLR vs VLR trends, net additions, and market share shifts across major operators—Airtel, Jio, Vodafone Idea, and BSNL-MTNL—both at the all-India level and circle-wise. An interactive dashboard is provided to help users visually explore trends over time.To enable transparency and independent verification, the raw data used in this dashboard can be downloaded and […] - [Vodafone Idea Relief Package Explained: Why the Numbers Still Don’t Add Up](https://paragkar.com/vodafone-idea-relief-package-explained-why-the-numbers-still-dont-add-up/): A complete, numbers-driven explanation of Vodafone Idea’s relief package, spectrum debt, and long-term viability — for readers who want the analysis without watching the video. The Government of India has announced a fresh relief package for Vodafone Idea, primarily centred around an AGR moratorium and the formation of a committee to examine dues and possible restructuring. While the announcement has generated optimism, the real question is whether this package actually puts Vodafone Idea on a sustainable survival path or merely postpones financial stress. The answer lies not in intent or headlines, but in the numbers. Vodafone Idea’s government liabilities fall […] - [Indian Mobile Recharge Plans Comparison Dashboard (Airtel, Jio & Vodafone Idea)](https://paragkar.com/indian-mobile-recharge-plans-comparison-dashboard-airtel-jio-vodafone-idea/): Compare prepaid and postpaid mobile plans across operators, data allowances, validity periods, and pricing trends in one interactive view This interactive dashboard consolidates mobile recharge plans from Airtel, Reliance Jio, and Vodafone Idea (Vi) into a single, structured comparison tool. The objective is to move beyond scattered operator websites and enable a transparent, data-driven comparison of mobile tariffs across operators, plan durations, and data allowances. The dashboard captures: Users can filter, zoom, and compare plans to understand how mobile pricing in India has evolved and how operators differentiate their offerings. 📊 What You Can Explore in This Dashboard 📁 Data […] - [BharatNet Project Performance Tracker: Budget, Spending & Ground Reality](https://paragkar.com/bharatnet-project-performance-tracker-budget-spending-ground-reality/): A Data-Driven Assessment of India’s Rural Broadband Rollout Using Public Government Data BharatNet is one of India’s most ambitious digital infrastructure projects, aimed at delivering optical fibre connectivity and high-speed broadband to Gram Panchayats across the country. Over the years, the project has seen significant budget allocations running into lakhs of crores, but questions continue to arise around actual execution, pace of rollout, and measurable outcomes. This page provides a transparent, data-driven view of BharatNet’s performance, based entirely on publicly available government data. Instead of relying on headline announcements, the analysis focuses on what the numbers reveal when tracked over […] - [📊 Interactive Telecom Efficiency Dashboard: Play with the Data](https://paragkar.com/%f0%9f%93%8a-interactive-telecom-efficiency-dashboard-play-with-the-data/): Analyze Circle-Wise Revenue vs. Active Subscriber Trends (Powered by Gemini) Dive deep into the Indian Telecom market dynamics! As demonstrated in my video, I have made this Market Efficiency Dashboard available for you to explore. This tool helps you visualize the “Efficiency Index” of telecom operators (Bharti Airtel, Reliance Jio, Vodafone Idea, and BSNL) by comparing their Adjusted Gross Revenue (AGR) Market Share against their Active Subscriber (VLR) Market Share. Use this dashboard to discover: Instructions: How to Use 🔗 Links 📥 Step 1: Download the Dataset File 🚀 Step 2: Open the Gemini Dashboard - [CPI Inflation Dashboard (Base Year 2024)](https://paragkar.com/interactive-cpi-analysis-explore-the-data-yourself/): Explore Item-Level and State-Wise Inflation Using Official CPI Data To use this interactive dashboard, you will need the raw CPI data file and access to the visualisation tool.Please follow the steps below carefully. How to Access the Dashboard Step 1: Download the CPI Data Download the source file required to power the dashboard. 👉 [ ⬇️ Download CPI_Data.csv ] ⚠️ The file is downloaded in .txt format by default.Please rename the file extension from .txt to .csv before uploading. Step 2: Launch the Dashboard Click the link below to open the CPI Gemini Dashboard in your browser. 👉 [ 🚀 […] - [New Spectrum Sharing, Trading & Leasing Rules 2025: Why One-Way Sharing Is a Game Changer](https://paragkar.com/new-spectrum-sharing-trading-leasing-rules-2025-why-one-way-sharing-is-a-game-changer/): How DoT’s 20 November guidelines unlock new monetisation options for VI, Bharti and even future satellite–terrestrial partnerships. In this video, I break down the new spectrum sharing, trading and leasing rules notified by the Department of Telecommunications on 20 November, and explain why they are far more impactful than they appear at first glance. The biggest shift is the move from pooled, common-RAN sharing (which was almost impossible to implement in practice) to one-way sharing, where the recipient can integrate the shared spectrum directly into its own RAN without any common BTS. This opens up powerful possibilities in low-frequency bands, […] - [Why DoT’s SIM-Binding Order Cannot Work on iOS & Android — And the Only Technical Solution That Exists](https://paragkar.com/why-dots-sim-binding-order-cannot-work-on-ios-android-and-the-only-technical-solution-that-exists/): Why WhatsApp, Signal & Telegram cannot do SIM-binding without OS support — and why GSM Mobile Connect is the only viable path. The Department of Telecommunications (DoT) has ordered messaging apps like WhatsApp, Signal and Telegram to ensure that the app stops working the moment the SIM–app “binding” is broken — SIM removed, swapped, or not present in the same device. On paper this sounds simple. In practice, it collides head-on with how modern operating systems (iOS & Android) are designed. In this video, I break down why DoT’s SIM-binding mandate cannot work in its current form, and what a […] - [6 GHz Band Conflict: Interference, Power Politics & A Practical Way Forward](https://paragkar.com/6-ghz-band-conflict-interference-power-politics-a-practical-way-forward/): Why Wi-Fi Power Demands, IMT Auctions and Filter Design Could Undermine India’s 6 GHz Strategy — and How It Can Be Fixed India’s 6 GHz band has become the centre of an intense policy and technical confrontation between two powerful lobbies — telecom operators and global technology companies. On one side, telecom operators are demanding the entire 1200 MHz band be reserved for IMT (5G and 6G) services and pushed for immediate auctions. On the other, global companies such as Apple, Cisco, Broadcom, Intel and HP are warning that auctioning any part of the band will severely disrupt Wi-Fi innovation […] - [The 26 GHz Wi-Fi Myth: Hidden EMF Risks Explained](https://paragkar.com/the-26-ghz-wi-fi-myth-hidden-emf-risks-explained/): Why 26 GHz Wi-Fi breaches EMF safety limits — and how 5G beam scheduling keeps radiation in check The 26 GHz millimeter-wave band was meant to power India’s 5G revolution — not Wi-Fi. So why are operators seeking to repurpose it? In this video, I break down how 26 GHz Wi-Fi creates EMF compliance risks that 5G avoids through beam scheduling and duty-cycle control. Using simple simulations, I explain what EIRP, power density, and safe distance mean — and why, without dynamic beam management, 26 GHz Wi-Fi can either breach TEC’s 5 W/m² limit or waste valuable spectrum with limited […] - [India’s New Deepfake Rules: Protection or Overreach? A Practical Breakdown](https://paragkar.com/indias-new-deepfake-rules-protection-or-overreach-a-practical-breakdown/): Why blanket AI labelling may backfire — and what India should do instead. India’s Ministry of Electronics & IT (MeitY) has proposed new amendments to the IT Rules, 2022 to tackle deepfakes. While the intent is valid, the draft creates a blanket obligation on platforms to pre-label and verify all “synthetically generated information” — a definition so broad that almost every digitally edited image, video, or reel could qualify. In this video, I break down: 🔹 What the amendment actually mandates (10% visible labels, provenance, loss of safe harbour)🔹 Why the definition of “synthetic content” is too vague and over-inclusive🔹 […] - [Vodafone Idea’s Real Test Begins: AGR Relief Today, Spectrum Debt Tomorrow](https://paragkar.com/vodafone-ideas-real-test-begins-agr-relief-today-spectrum-debt-tomorrow/): Why the Supreme Court’s relief order may solve yesterday’s problem—but not tomorrow’s spectrum crisis The Supreme Court’s latest order has given the Government of India the flexibility to design a relief package for Vodafone Idea—an unprecedented move that breaks free from the strict confines of the 2020 AGR judgment. While this may ease the company’s immediate financial pressure, a much bigger challenge is looming: spectrum debt. This video dissects how Vodafone Idea’s deferred spectrum payments—spanning the 2014, 2015, and 2016 auctions—pose a serious threat to its survival from FY28 onward. With over ₹1.1 lakh crore in outstanding spectrum liabilities and […] - [Jio’s 5G “Reflecting Surface” Experiment: Smart Walls for mmWave Coverage](https://paragkar.com/jios-5g-reflecting-surface-experiment-smart-walls-for-mmwave-coverage/): Why Intelligent Reflecting Surfaces Work Only in High-Frequency 5G Bands Reliance Jio is experimenting with Intelligent Reflecting Surfaces (IRS) — or smart walls — that can bounce and steer radio waves to eliminate 5G dead zones. These engineered surfaces aim to redirect signals into areas with weak coverage, improving indoor connectivity without additional towers.However, this technology is effective only at higher frequencies like 26 GHz (mmWave) — where radio waves travel in straight lines and fail to bend around obstacles. In contrast, India’s current 5G deployments use mid-band spectrum (3.3–3.67 GHz), which already bends and penetrates walls, making IRS largely […] - [Vodafone Idea 5G Coverage Snapshot — City & Circle Reality vs Airtel and Jio](https://paragkar.com/vodafone-idea-5g-coverage-snapshot-city-circle-reality-vs-airtel-and-jio/): What Vi has live today, where spectrum is missing, and how it stacks up against Airtel & Jio In this video I open the DoT/TRAI-directed operator coverage maps and evaluate Vodafone Idea’s 5G footprint city-by-city and circle-by-circle. I show how to filter Vi’s map, then walk through examples (Visakhapatnam, Patna, Chennai, Delhi-NCR, Gujarat’s four cities, Bengaluru/Mysuru, four cities in Kerala, Kolkata, Indore, Pune/Nashik/Aurangabad/Nagpur, Chandigarh, Jaipur, Chennai/Madurai, Lucknow, Meerut/Dehradun, Siliguri). I also identify five circles where Vi has no 5G spectrum (Assam, Himachal Pradesh, J&K, North-East, Odisha)—so deployment there isn’t possible today.For context, I briefly compare with Jio’s nationwide 5G and […] - [DOT’s 5% SUC on Satellite Spectrum — What Does It Translate to in Auction Value?](https://paragkar.com/dots-5-suc-on-satellite-spectrum-what-does-it-translate-to-in-auction-value/): Understanding how DOT’s decision to impose 5% Spectrum Usage Charge (SUC) on administratively allocated satellite spectrum compares with the auction-equivalent value of terrestrial FWA bands — and why the 26 GHz band isn’t the right benchmark. In this video, I decode what the 5% SUC means in monetary terms — if the same satellite spectrum were auctioned like terrestrial 5G/FWA spectrum. Through a simple step-by-step analysis using realistic market assumptions (subscribers, ARPU, and bandwidth), I estimate what the auction-equivalent value of Ku-band satellite spectrum would be. The findings show that DOT’s 5% SUC actually reflects a fair economic value, and […] - [Decoding Jio–T-Mobile 5G Roaming: Why Seamless Connectivity Isn’t That Simple](https://paragkar.com/decoding-jio-t-mobile-5g-roaming-why-seamless-connectivity-isnt-that-simple/): Understanding how 5G SA slicing, local hosting, and regulatory limits shape global roaming. This video explains the recent partnership between Jio and T-Mobile to enable seamless 5G standalone (SA) roaming for international travelers — and why achieving it is far more complex than it sounds.It begins by contrasting traditional 4G/3G roaming, where all users share a “best-effort” internet pipe, with 5G SA slicing, which enables differentiated services like low latency, high speed, and premium security through virtual “pipes.” The video then dives deep into how these slices work only if both operators’ networks are interconnected via a managed intranet, not […] - [VoWiFi Explained: How Wi-Fi Calling Works in India](https://paragkar.com/vowifi-explained-how-wi-fi-calling-works-in-india/): Understanding the Tech Behind India’s VoWiFi Rollout BSNL has rolled out VoWiFi (Voice over Wi-Fi) to help users make and receive calls indoors where mobile signals are weak. In this video, Parag Kar explains in simple terms how VoWiFi differs from VoLTE, and why it matters for India’s poor indoor coverage. India’s limited tower density and lack of sufficient low-frequency spectrum (like 700, 800, 900 MHz) mean that many homes experience signal black spots. VoWiFi bridges this gap by routing your voice calls over your home broadband instead of the mobile network. It uses a secure IPSec tunnel—the same technology […] - [📉 Vodafone Idea’s Crisis: Why Chidambaram’s Foreign Takeover Pitch is a Mirage](https://paragkar.com/%f0%9f%93%89-vodafone-ideas-crisis-why-chidambarams-foreign-takeover-pitch-is-a-mirage/): 🗣️ The Proposal That Sounds Easy… But Isn’t On June 25, former Finance Minister P. Chidambaram reacted to Telecom Minister Jyotiraditya Scindia’s comment that duopoly is bad for the telecom sector. In his tweet, he proposed that the solution to this looming duopoly lies in inviting a “world-class telecom company” to take over Vodafone Idea (Vi), rather than infusing more government funds. On the surface, it sounds reasonable. After all, competition is good. But this suggestion is not just overly simplistic — it’s structurally unworkable. 💰 The Debt That Won’t Go Away As of December 2024, Vodafone Idea’s total liabilities […] - [India’s 5G Ambitions vs Ground Realities: A Critical Look at the Ericsson Mobility Report (June 2025)](https://paragkar.com/indias-5g-ambitions-vs-ground-realities-a-critical-look-at-the-ericsson-mobility-report-june-2025/): Ericsson’s Optimistic Forecast for India Ericsson’s June 2025 Mobility Report paints a highly optimistic picture of global 5G expansion, with India as a central figure in this projected growth. The report forecasts that India will reach 980 million 5G subscribers by 2030, up from 290 million in 2024, and that the average monthly data usage per subscriber will nearly double from 32 GB to 62 GB in the same timeframe. It places significant emphasis on Fixed Wireless Access (FWA) as a game-changing use case, suggesting that India will be a key driver in this trend. The Blind Spot: Lack of […] - [Vodafone Idea's AGR Dues: Why Simple Interest Alone Won’t Deliver Meaningful Relief](https://paragkar.com/vodafone-ideas-agr-dues-why-simple-interest-alone-wont-deliver-meaningful-relief/): Introduction: The Dues and the Dilemma As of March 31, 2025, Vodafone Idea (Vi) owes ₹83,500 crore to the Government of India in Adjusted Gross Revenue (AGR) dues. This figure reflects accumulated liabilities resulting from retrospective policy interpretations and prolonged litigation. With the company continuing to bleed financially and market share slipping, the Government is under pressure to offer some form of sustainable relief — without setting a precedent of fiscal irresponsibility. Recent ET report suggest that the Government is considering shifting from a compound interest model to simple interest for the remaining dues. At first glance, this seems fair: […] - [BSNL’s Quantum 5G FWA: Bold Innovation or Too Little, Too Late?](https://paragkar.com/bsnls-quantum-5g-fwa-bold-innovation-or-too-little-too-late/): Introduction Bharat Sanchar Nigam Limited (BSNL) recently captured attention with the soft launch of its 5G Fixed Wireless Access (FWA) services in Hyderabad. At the heart of the announcement were two bold claims: the use of an indigenous 5G technology stack and a so-called “SIM-less” architecture. While these declarations suggest innovation and self-reliance, a closer examination reveals both opportunities and challenges. This article delves deeper into BSNL’s strategy, places it in context with private sector peers like Reliance Jio and Bharti Airtel, and highlights what’s really at stake as India’s broadband landscape evolves. BSNL’s Spectrum Position: A Competitive Weakness At […] - [The Unscalable Truth: Why Fixed Broadband Can't Follow Mobile’s Path in India](https://paragkar.com/the-unscalable-truth-why-fixed-broadband-cant-follow-mobiles-path-in-india/): India has always been a mobile-first internet market. For millions, particularly in the affordable segment, the internet experience began not on a laptop, but on a mobile phone — a device that is significantly cheaper, requires minimal software investment, and is more personalized and user-friendly. Mobile phones also perform well in low-bandwidth environments and serve as a unified platform for both communication and entertainment. This inherent demand has made India the fastest-growing mobile internet market in the world, offering the cheapest mobile data globally. Today, mobile connectivity underpins every aspect of life in India — from entertainment and education to […] - [Telecom’s Last Stand: Why Letting VI Collapse Will Cost India Dearly](https://paragkar.com/telecoms-last-stand-why-letting-vi-collapse-will-cost-india-dearly/): The Indian telecom industry has undergone a series of dramatic twists and turns since its inception. The shift from a fixed license fee regime to a revenue-sharing model, the entry of WLL (Wireless Local Loop) operators into full mobility in 2003, the influx of new operators at subsidized rates in 2008, and the auction of 3G spectrum in 2010 — culminating in the 2G scam and the Supreme Court’s cancellation of licenses in 2012 — collectively shaped the early disruptions. The industry then witnessed the exit of several new entrants, burdened by high auction fees and the disruptive entry of […] - [AGR Crisis Explained: What Went Wrong, What Remains, and What Can Still Be Done](https://paragkar.com/agr-crisis-explained-what-went-wrong-what-remains-and-what-can-still-be-done/): Among the many regulatory and legal battles that have shaped India’s telecom sector, none has been as far-reaching and destructive as the Adjusted Gross Revenue (AGR) case. The Supreme Court’s 2019 verdict not only reaffirmed the government’s stance but also imposed an unexpectedly harsh liability on telecom operators—effectively pushing the sector to the brink of collapse and wiping out most market competition. Ironically, even the Department of Telecommunications (DoT), which had aggressively defended its position on AGR calculations, appeared taken aback by the ferocity of the judgment. The ruling exceeded the DoT’s expectations, prompting it to file a modification application […] - [Tracing the AGR Saga: Two Decades of Legal Battles That Shaped Indian Telecom](https://paragkar.com/tracing-the-agr-saga-two-decades-of-legal-battles-that-shaped-indian-telecom/): This compilation brings together two decades of landmark documents, judgments, and regulatory decisions that form the spine of India’s Adjusted Gross Revenue (AGR) controversy. From TRAI’s early recommendations in 1999 to the Supreme Court’s decisive 2019 judgment and the final curative dismissal in 2024, this curated archive offers a comprehensive timeline of legal confrontations between telecom operators and the Department of Telecommunications (DoT). It captures evolving interpretations of revenue definitions, jurisdictional tussles between TDSAT and the Supreme Court, and the shifting regulatory stance that ultimately shaped the financial architecture of Indian telecom. Document List Timeline of Events - [The Fragile Future of AI: Why Fair Use Can’t Hold, and the World Must Act Together](https://paragkar.com/the-fragile-future-of-ai-why-fair-use-cant-hold-and-the-world-must-act-together/): On March 18th, the New York Post ran a striking headline: “Google, OpenAI want ‘license to steal’ from publishers with AI proposals, newspapers warn in scathing editorial.” The article captured a rising wave of concern from news organizations and content creators, who believe that tech giants are pressuring the U.S. government to shut down copyright lawsuits through executive intervention. Their argument is based on national urgency: unless these legal challenges are halted, the U.S. risks falling behind in the global AI race — particularly to China. But critics see this effort as a backdoor attempt to sidestep copyright protections and […] - [Vodafone Idea’s Survival: A Tightrope Walk Between Debt, Growth, and Government Backing](https://paragkar.com/vodafone-ideas-survival-a-tightrope-walk-between-debt-growth-and-government-backing/): Yesterday, I wrote an article titled “SUC Waiver: A Boost for Vi, But a Blow to High-Frequency Spectrum Auctions,” discussing the speculation that the Government of India (GOI) is considering waiving Spectrum Usage Charges (SUC) on previously auctioned spectrum. These charges, imposed in addition to the upfront auction payments, are determined by the Notice Inviting Applications (NIA)—a legally binding document that outlines the auction terms, which the GOI must honor for every tranche of spectrum acquired in past auctions. This proposed waiver would be in addition to the existing exemption on all spectrum acquired in auctions held from 2022 onwards. […] - [SUC Waiver: A Boost for Vi, But a Blow to High-Frequency Spectrum Auctions](https://paragkar.com/suc-waiver-a-boost-for-vi-but-a-blow-to-high-frequency-spectrum-auctions/): On March 6th, the Financial Express (FE) reported that the Government of India (GOI) is considering a spectrum usage charge (SUC) waiver for all operators on spectrum acquired in auctions held before 2022. Readers may recall that as part of the telecom relief package introduced a few years ago, the government set the SUC for all spectrum acquired in auctions from 2022 onwards at 0%. The rationale behind this move was simple: once spectrum is purchased through an auction, imposing an additional usage charge on top of the auction outflows lacked economic justification. This policy led operators to aggressively acquire […] - [Satellite Broadband in India: Genuine Threat or Manufactured Fear?](https://paragkar.com/satellite-broadband-in-india-genuine-threat-or-manufactured-fear/): Ever since the Government of India (GOI) announced its intention to allow satellite communication services (satcom) to operate through administrative spectrum allocation instead of competitive auctions, India’s telecom operators have raised strong objections. They argue that satellite operators should not be given spectrum at significantly lower costs, especially if they plan to offer services in urban and semi-urban areas, where they would directly compete with the Fixed Wireless Access (FWA) and fixed-line broadband businesses of terrestrial operators. At the India Mobile Congress 2024, Sunil Mittal, Chairman of Bharti Airtel, underscored the need for a level playing field between terrestrial telecom […] - [The Great OTT Escape: How Regulatory Gaps Are Killing Fair Play in Broadcasting](https://paragkar.com/the-great-ott-escape-how-regulatory-gaps-are-killing-fair-play-in-broadcasting/): Over-the-Top (OTT) platforms have emerged as a dominant medium for delivering content to mobile phones, televisions, desktops, and other converged devices. However, their rapid proliferation has sparked significant contention among traditional service providers who operate under government-issued licenses for broadcasting services, particularly linear TV. These licensed providers—including DTH and IPTV operators—are subject to stringent regulations, such as mandatory license fees, pricing controls, and interconnection requirements, none of which apply to OTT platforms, despite both delivering essentially the same content with slight variations in format. For instance, DTH and IPTV operators must pay an 8% license fee, while MSOs and cable […] - [Global Gold & Forex Reserves Dashboard: Country Trends & Rankings](https://paragkar.com/global-gold-forex-reserves-dashboard-country-trends-rankings/): Track gold and forex reserves trends across countries with dynamic bar charts and heatmaps for comparative insights. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Quarterly U.S. GDP and Growth Trends : Adjustable Timeframe Analysis](https://paragkar.com/quarterly-u-s-gdp-and-growth-trends-adjustable-timeframe-analysis/): Explore U.S. GDP growth trends with an interactive window that lets you adjust the period for analysis. Compare real and nominal GDP fluctuations in the chosen window period. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [CNAP Without Caller Authentication: A Misguided Solution to Telecom Fraud](https://paragkar.com/cnap-without-caller-authentication-a-misguided-solution-to-telecom-fraud/): Recently, TRAI released its recommendations on the “Revision of the National Numbering Plan“, highlighting a critical security issue in India’s telecom infrastructure which is reproduced below (clause 2.38, Page 27). Currently, the Network-Network Interface (NNI) between telecom service providers (TSPs) is built on an assumption of trust, relying on commercial agreements rather than robust technology-based security measures. This outdated trust model, combined with the expansion of interfaces such as SIP trunks for non-TSP entities, third-party SMS gateways, and open 5G architecture, has created major security vulnerabilities. These gaps enable malicious activities like CLI spoofing, IMSI theft, and unauthorized surveillance, which […] - [Vodafone Idea’s Debt Crisis: Can GOI’s Band-Aid Fix Prevent a Telecom Collapse?](https://paragkar.com/vodafone-ideas-debt-crisis-can-gois-band-aid-fix-prevent-a-telecom-collapse/): The moratorium period for the payment of dues on Adjusted Gross Revenue (AGR) and spectrum auctions held before FY21 is set to end on September 25. Previously, on September 15, 2021, the Indian government, through a cabinet decision and press release, provided a four-year payment deferment to the debt-ridden telecom industry. This relief was aimed at easing the financial strain on telecom operators, who were struggling under heavy debt and revenue losses following Reliance Jio’s disruptive entry into the sector. This note will break down, in simple terms, the financial obligations of Vodafone Idea (VI) as the moratorium period ends, […] - [Ministry of Electronics & Information Technology Budget Expenditure Trends](https://paragkar.com/ministry-of-electronics-information-technology-budget-expenditure-trends/): Delve into the financial nuances of Meity with our detailed expenditure trend analysis. Sourced from the latest FY26 budget documents, this visualization offers a comprehensive breakdown of capital and revenue expenditures across various initiatives and projects from FY22 to FY26. Track the allocation and actual spending patterns to understand the strategic fiscal commitments and priority areas within the IT sector. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [India’s Mobile Blocking System: Unveiling the Gaps and the Path to a Smarter, Safer Future](https://paragkar.com/indias-mobile-blocking-system-unveiling-the-gaps-and-the-path-to-a-smarter-safer-future/): In mid-2023, the Department of Telecommunications (DoT) introduced Sanchar Saathi, a service aimed at helping citizens block and trace stolen mobile phones. Having had the privilege of working on this initiative during my stint at Qualcomm in 2014-2016, I see this as the perfect opportunity to revisit and share insights into how the system works and where it falls short. Back in May 2016, I had written an article explaining the mechanics of this system, and for those curious, that serves as a good starting point. In this note, I intend to build on that foundation, delving into the current […] - [Are Telecom Operators Truly Meeting the Spirit of TRAI's Voice-Only Mandate?](https://paragkar.com/are-telecom-operators-truly-meeting-the-spirit-of-trais-voice-only-mandate/): The TRAI recently mandated telecom operators to introduce voice and SMS-only plans tailored for users who do not require data services, particularly those using feature phones. To assess the implications of this move, I previously analyzed the potential financial impact on operators if these plans were priced significantly lower to cater to this segment. Following the mandate, all operators have now introduced their respective plans. In this article, we will focus on evaluating the benefits these plans offer to users, particularly in terms of the cost of voice calls per minute, as calculated from the mobile usage trends (MOUs) reported […] - [Spectrum Refarming: Is It Enough to Unlock True 5G and 6G Value?](https://paragkar.com/spectrum-refarming-is-it-enough-to-unlock-true-5g-and-6g-value/): Recently, all major newspapers and TV channels highlighted a pivotal development for the mobile industry: the refarming of spectrum from government users, including defense, space, and other PSUs, which is set to free up 687 MHz of additional spectrum for deploying 4G and 5G services. This initiative is being celebrated as a transformative step in positioning India among nations striving to unlock the full potential of airwaves—a crucial foundation for adopting next-generation technologies like 5G and 6G. These advancements are anticipated to generate significant financial gains, boost GDP growth, and improve the quality of life for millions. In this article, […] - [Global Currency Movements Unveiled: Analyzing Nominal & Real Effective Exchange Rates Across Broad (64) and Narrow (27) Baskets](https://paragkar.com/global-currency-movements-unveiled-analyzing-nominal-real-effective-exchange-rates-across-broad-64-and-narrow-27-baskets/): This visualization analyzes the Nominal and Real Effective Exchange Rates (NEER & REER) of global currencies across Broad (64) and Narrow (27) baskets, highlighting trends in international competitiveness Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [India’s Inflation Measure Is Misaligned: Time to Revise the CPI with New Survey Insights](https://paragkar.com/indias-inflation-measure-is-misaligned-time-to-revise-the-cpi-with-new-survey-insights/): Yesterday, the Ministry of Statistics and Programme Implementation (MOSPI) released India’s inflation data for December 2024, revealing that inflation remains significantly above the Reserve Bank of India’s (RBI) comfort zone. Persistently high inflation has far-reaching consequences for the Indian economy. It not only fuels expectations of further price increases—potentially altering consumer behavior and pushing inflation even higher—but also limits the RBI’s ability to lower interest rates, which is critical for reviving economic growth. With the economy already slowing, this situation threatens jobs and deepens economic hardships for the common citizen. This raises a critical question: Is India’s method of measuring […] - [India’s Data Privacy Law Promises Control—But Can Consent Managers Deliver?](https://paragkar.com/indias-data-privacy-law-promises-control-but-can-consent-managers-deliver/): In India, after extensive public debate, the Personal Data Protection Act, 2023, received Presidential assent on August 11, 2023. Following a wait of over a year, the Government of India (GOI) has now released the draft rules for the implementation of the Act for public scrutiny and feedback. These rules place significant responsibilities on Data Fiduciaries, who process the personal data of Data Principals (consumers) to deliver various services. According to the rules, data processing must adhere to the principle of necessity, ensuring that personal data is not retained indefinitely without purpose, thereby mitigating the risk of misuse. Both the […] - [India's 5G Reality Check: TRAI Finds Operators Stuck on 4G, BSNL Largely on 3G/2G](https://paragkar.com/indias-5g-reality-check-trai-finds-operators-stuck-on-4g-bsnl-on-3g-2g/): Yesterday, the Telecom Regulatory Authority of India (TRAI) released a comprehensive Independent Drive Test (IDT) report for four cities—New Delhi (Delhi LSA), Jaipur (Rajasthan LSA), Ahmednagar (Maharashtra LSA), and Hyderabad (Andhra Pradesh LSA)—conducted during September to October 2024. The objective of this drive test was to assess the quality of service (QoS) provided by cellular mobile operators for both voice and data services. In this analysis, I will evaluate the report from a perspective different from TRAI’s approach. Specifically, I will focus on the extent of network coverage that the four key telecom operators have achieved in these cities across […] - [Why the 6 GHz Band Needs Stronger WiFi Support to Succeed](https://paragkar.com/why-the-6-ghz-band-needs-stronger-wifi-support-to-succeed/): The Financial Express recently reported that the central government is considering allocating the upper portion of the 6 GHz band for International Mobile Telecommunications (IMT), specifically for the deployment of 5G and future 6G technologies. The 6 GHz band spans from 5925 MHz to 7125 MHz, offering a total of 1200 MHz of spectrum. Of this, the Government of India (GoI) plans to allocate the upper segment from 6425 MHz to 7125 MHz, amounting to 700 MHz—a significant portion but still leaving 500 MHz unallocated. To put this in perspective, the 3.5 GHz band currently allocated for IMT services in […] - [State-Wise DoT EMF Audit: Measured Values vs Prescribed Thresholds](https://paragkar.com/state-wise-dot-emf-audit-measured-values-vs-prescribed-thresholds/): Explore the latest DoT EMF audit dashboard for the financial year 2024-25, showcasing state-wise measured EMF values against prescribed thresholds. The interactive dashboard highlights compliance levels, with insights into power density distributions and safety margins across India’s telecom sites. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Debunking EMF Myths: Are Higher Power Levels a Game-Changer for 5G Coverage and Health Risks?](https://paragkar.com/debunking-emf-myths-are-higher-power-levels-a-game-changer-for-5g-coverage-and-health-risks/): Recently, The Economic Times published a story highlighting that the Department of Telecommunications (DoT) has revised the Electromagnetic Field (EMF) exposure limits for telecom service providers in India, increasing the threshold to five times the previous levels. The article speculates that this move could benefit mobile operators by expanding the coverage of their cell sites, potentially reducing the need for additional sites or improving service quality at the cell edges. This, in turn, could lead to better consumer experiences, including improved data speeds and fewer dead zones. Given that 5G primarily operates in higher frequency bands, such as 3.5 GHz […] - [Why Is BSNL’s 4G Network Coverage So Poor?](https://paragkar.com/why-is-bsnls-4g-network-coverage-so-poor/): Following the recent tariff hikes, many individuals in the affordable segment have gravitated toward BSNL connections, resulting in a significant migration of subscribers from other mobile operators. According to TRAI’s subscription report, between July 2024 and October 2024, BSNL added 6.8 million wireless subscribers, while Vodafone lost an identical number. Meanwhile, Bharti Airtel and Jio gained 3.6 million and 16.5 million subscribers, respectively, reflecting a trend of SIM consolidation. Despite this influx, many subscribers who switched to BSNL have expressed dissatisfaction due to poor service quality and persistent network issues. This article aims to systematically examine why BSNL’s 4G network […] - [Tariff Hikes in Telecom: Boosting ARPU but Straining Usage Trends](https://paragkar.com/tariff-hikes-in-telecom-boosting-arpu-but-straining-usage-trends/): Today, TRAI released the Indian Telecom Services Performance Indicators Report for the period of July–September 2024. This report holds particular significance as it provides the first official insights into the impact of recent tariff hikes on the telecom industry. Below are the key findings from the report. Wireless ARPU Impact: Growth Driven by Prepaid Segment The Average Revenue Per User (ARPU) for the wireless segment of the industry saw a significant increase of 9.5%. The ARPU rose from ₹157.5 in the previous quarter to ₹172.6 in this quarter. Interestingly, the majority of this growth came from the prepaid segment, where […] - [India's Capex Slowdown: Material Concern or Accounting Illusion?](https://paragkar.com/indias-capex-slowdown-material-concern-or-accounting-illusion/): The Indian government has been steadily increasing its budgetary allocation for capital expenditure (capex), a critical move to lay the foundation for the much-needed GDP growth essential for India’s economic progress and prosperity. Reflecting this intent, the capex allocation has seen a remarkable increase from ₹2.72 lakh crore in FY18 to an unprecedented ₹11.11 lakh crore in the FY25 budget. However, recent economic data paints a worrying picture. GDP growth for Q2 FY25 has slumped to an all-time low of 5.36%, the weakest since Q4 FY23, which recorded 6.18%. This slowdown has raised concerns among analysts and investors who have […] - [The Cost of Connectivity: Assessing the Impact of Mobile Tariff Hikes on Indian Households](https://paragkar.com/the-cost-of-connectivity-assessing-the-impact-of-mobile-tariff-hikes-on-indian-households/): Yesterday, the Ministry of Statistics and Programme Implementation released the Household Consumption Expenditure Survey (HCES) for the data collected during the Financial Year 2023-24. This follows the earlier survey released for the Financial Year 2022-23. The survey provides valuable insights into consumption and expenditure patterns, standards of living, and the overall well-being of households. When the FY2022-23 survey was published, I used it as an opportunity to estimate the impact of price increases in mobile services, focusing on the expenditure patterns of households across various categories—particularly the category of consumer services excluding conveyance—for both rural and urban segments of the […] - [India State Wise IGST Settlement Trends - Heat & State Map View](https://paragkar.com/india-state-wise-igst-settlement-trends-heat-state-map-view/): The chart provide a comprehensive view of India’s IGST Settlements Trends, broken down by states. They cover various dimensions such as Adhoc settlements and Regular settlements. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [TRAI’s Mandate on Voice-Only Plans: Challenges and Implications for Telecom Operators](https://paragkar.com/trais-mandate-on-voice-only-plans-challenges-and-implications-for-telecom-operators/): Introduction On December 23, 2024, the Telecom Regulatory Authority of India (TRAI) issued the 12th Amendment to the Telecom Consumer Protection Regulations (08 of 2024). This amendment directed telecom service providers to offer voice and SMS-only packs as an option, aimed at benefiting millions of feature phone users across the country. These users, unable to utilize data due to device limitations, have often found current bundled plans unsuitable. Despite TRAI’s intent to address this digital divide, telecom service providers strongly opposed the proposal during the consultation process. In this note, we will explore the challenges operators are likely to face […] - [From Chaos to Clarity: Preparing Data for Seamless Visualization](https://paragkar.com/from-chaos-to-clarity-preparing-data-for-seamless-visualization/): Data is often not available in a format suitable for immediate visualization. Preparing such data requires extensive processing that goes beyond the capabilities of standard off-the-shelf tools. Over the years, I have focused on visualizing complex datasets to facilitate deep-dive analysis and enable accurate understanding of situations, ultimately supporting better business and policy decisions. During this journey, I have encountered numerous challenges that conventional tools cannot address effectively. For instance, data is frequently provided in PDF format, and while tools like Adobe’s offerings attempt to convert it into Excel, the output often requires significant manual cleanup. One common issue is […] - [Handbook of Statistics on Indian States: Fiscal Indicators and Trends](https://paragkar.com/handbook-of-statistics-on-indian-states-fiscal-indicators-and-trends/): This interactive dashboard provides detailed insights into the fiscal health of Indian states, covering metrics such as Gross Fiscal Deficit, Revenue Deficit, Primary Deficit, Tax Revenues, Non-Tax Revenues, Interest Payments, and Social Sector Expenditures. Users can click on individual states to explore trends and rankings, with options to analyze state-wise liabilities, guarantees, and expenditure patterns. This visualization serves as a comprehensive tool for assessing fiscal sustainability and regional financial performance across India. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Handbook of Statistics on Indian States: State Domestic Product Trends](https://paragkar.com/handbook-of-statistics-on-indian-states-state-domestic-product-trends/): This interactive dashboard provides comprehensive insights into the State Domestic Product (SDP) across various categories and tables, including per capita SDP, gross and net values, and economic activity-based contributions at both current and constant prices. Users can click on any state to view trends, rankings, and sector-wise performance, with options to explore key metrics such as manufacturing, services, and agriculture. This tool offers an invaluable resource for analyzing economic patterns and regional disparities across India. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [TRAI's 700 MHz Spectrum: Leveling the Playing Field Between Bharti and RJIO While Blocking RJIO's Sub-GHz 5G Potential](https://paragkar.com/trais-700-mhz-spectrum-leveling-the-playing-field-between-bharti-and-rjio-while-blocking-rjios-sub-ghz-5g-potential/): Yesterday, the Telecom Regulatory Authority of India (TRAI) proposed allocating an additional 5 MHz spectrum in the 700 MHz band to Indian Railways, intended for safety and security applications. Currently, this band is partially utilized by Reliance Jio (RJIO) for standalone 5G services. The history of the 700 MHz band in India has been marked by controversies since its valuation in 2012, when TRAI set its price at four times the value of the 1800 MHz band. This valuation, made prematurely, disregarded the lack of global adoption and an established band plan—essential prerequisites for effective spectrum utilization. Moreover, TRAI’s methodology […] - [The Unstoppable Ring: Inside India’s Battle Against Spam and Fraudulent Calls](https://paragkar.com/the-unstoppable-ring-inside-indias-battle-against-spam-and-fraudulent-calls/): Are you fed up with calls claiming to be from the telecom regulatory authority, customs officials, or courier services like FedEx—threatening punitive action for suspicious packages supposedly sent in your name? Often originating from international numbers and displaying misleading caller IDs, these calls prey on consumers who may not be tech-savvy or who think they are simply fulfilling their civic duties. In reality, they are scams designed to extract sensitive information, leading to financial losses and fraud. Despite multiple measures implemented by the Department of Telecommunications (DoT) and the Telecom Regulatory Authority of India (TRAI), these fraudulent activities continue unabated. […] - [Handbook of Statistics on Indian States - State-wise Agricultural and Allied Data Dashboard (RBI)](https://paragkar.com/handbook-of-statistics-on-indian-states-state-wise-agricultural-and-allied-data-dashboard-rbi/): A comprehensive interactive dashboard that integrates multiple RBI-published state-wise datasets on agriculture and allied sectors. Users can select specific tables to visualize trends, interact with a map to explore data for individual states, and view rankings through a heat map. This tool provides insights into production, area usage, cropping patterns, irrigation, yield estimates, and related agricultural indicators across India’s states. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Spectrum Wars: Uneven Gains, Rising Strains, and the Path Ahead for Indian Telecom](https://paragkar.com/spectrum-wars-uneven-gains-rising-strains-and-the-path-ahead-for-indian-telecom/): The Indian telecom sector has undergone significant consolidation, shrinking from a multitude of players to just four. Among these, only two can be considered market leaders, while the remaining two are struggling to stay afloat. Over time, the two market leaders have captured a substantial share of both the revenue and subscriber base. This article aims to compare Indian telecom players across key dimensions of business—spectrum holdings, subscriber base, and revenue market share—across their operating circles. Such an analysis provides insights into their relative positions, highlighting the circles they are most focused on. Additionally, we will examine cases where operators […] - [Quantum Key Distribution Made Simple: Understanding India’s Leap into Hack-Proof Communication](https://paragkar.com/quantum-key-distribution-made-simple-understanding-indias-leap-into-hack-proof-communication/): Today’s headlines announce a significant milestone: India is set to join the quantum satellite race, aiming to establish a hack-proof communication network. The satellite will play a pivotal role in building a larger quantum communications network under the National Quantum Mission. To most of us, this might sound like Greek and Latin—a complex technological development seemingly out of reach for those without expertise in encryption, hacking, or communication networks. In this article, I aim to simplify this concept for the layperson, breaking it down in the easiest way possible. You don’t need to be a communication engineer or have any […] - [General CPI Trends for Indian States: Rural, Urban, and Combined](https://paragkar.com/general-cpi-trends-for-indian-states-rural-urban-and-combined/): This interactive dashboard visualizes General CPI (Consumer Price Index) trends across Indian states, offering insights into inflation patterns for rural, urban, and combined areas. Users can explore state-wise inflation rates, compare trends over time, and analyze weighted average contributions. Clicking on a state highlights its inflation trajectory relative to the national average, providing a comprehensive view of regional economic pressures. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Per Capita Net Indian States Domestic Product at Constant Prices](https://paragkar.com/per-capita-net-indian-states-domestic-product-at-constant-prices/): This interactive dashboard highlights the Per Capita Net State Domestic Product (at Constant Prices) across Indian states. Users can navigate state-wise rankings, compare economic outputs (in Rs Lakh), and examine trends adjusted for inflation over the selected financial year. Clicking on a state offers a closer view of its economic stability and growth trajectory in constant terms. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Per Capita Net Indian States Domestic Product at Factor Cost and Current Prices](https://paragkar.com/per-capita-net-indian-states-domestic-product-at-factor-cost-and-current-prices/): This interactive dashboard visualizes the Per Capita Net State Domestic Product at Factor Cost (at Current Prices) across Indian states. Users can explore state-wise rankings, values (in Rs Lakh), and trends for the selected financial year. Clicking on any state highlights its economic performance relative to others, offering a clear view of regional economic disparities. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Net Indian States Domestic Product at Constant Prices](https://paragkar.com/net-indian-states-domestic-product-at-constant-prices/): Explore state-wise trends in Net State Domestic Product (NSDP) across India. This dashboard provides insights into economic performance at constant prices, detailing contributions of different states to India’s economy, using 2011-12 as the base year. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Indian Telecom Operators: Circle-Wise Subscriber Distribution and Market Share Dashboard](https://paragkar.com/indian-telecom-operators-circle-wise-subscriber-distribution-and-market-share-dashboard/): This dashboard offers an in-depth analysis of Indian telecom operators’ circle-wise subscriber data, including Bharti, RJIO, VI, and BSNL. Users can explore absolute subscriber numbers (in millions), circle-based market shares, and distribution across wireline and wireless segments. The interactive interface allows users to view data across different time periods by adjusting the timeline, enabling comprehensive insights into the telecom sector’s regional performance. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [District-Wise Analysis of Outstanding Credit by Detailed Occupation Across Scheduled Commercial Banks](https://paragkar.com/district-wise-analysis-of-outstanding-credit-by-detailed-occupation-across-scheduled-commercial-banks/): This interactive dashboard provides a comprehensive view of the outstanding credit of scheduled commercial banks across major categories and sub-categories of occupation and sectors in India. The dashboard allows users to explore Pan-India data through a state-wise view, zoom into a specific state’s district-level data, and examine trends for both major and sub-categories through date-wise bar charts for selected areas. This enables a detailed exploration of credit distribution across different regions, offering insights into credit patterns at both the state and district levels. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [State-wise Outstanding Credit Analysis of Small Borrowal Accounts by Occupation](https://paragkar.com/state-wise-outstanding-credit-analysis-of-small-borrowal-accounts-by-occupation/): This interactive dashboard presents the state-wise outstanding credit data for small borrowal accounts of scheduled commercial banks categorized by occupation. Users can filter by clicking on the map for a specific state and choose among metrics like absolute values, percentage of GDP, and percentage of total credit. The heatmap reveals detailed insights into the distribution of sub-categories within each state, while the panel on the right highlights Pan-India values for the top 10 states in the selected main category, with ranked metrics. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [State-wise Analysis of Outstanding Credit by Occupation for Scheduled Commercial Banks](https://paragkar.com/state-wise-analysis-of-outstanding-credit-by-occupation-for-scheduled-commercial-banks/): This interactive dashboard offers a comprehensive state-wise analysis of the outstanding credit of scheduled commercial banks categorized by occupation. Users can select a state on the map to filter the main and sub-categories, and view metrics such as absolute values, percentage of GDP, and percentage of total credit. The heatmap provides insights into the contribution of sub-categories to the state’s total credit, while the right panel displays the top 10 states’ Pan-India values for a chosen main category, ranked by the selected metric. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Bank Group-Wise Credit Trends by Occupation: A Comprehensive Analysis](https://paragkar.com/bank-group-wise-credit-trends-by-occupation-a-comprehensive-analysis/): This dashboard provides an in-depth analysis of the outstanding credit of scheduled commercial banks categorized by occupation across various bank groups (private sector banks, public sector banks, small finance banks, and foreign banks). Users can explore credit distribution trends, view metrics such as absolute values in Rs Lakh Cr, percentage of GDP, and percentage of total credit by bank group for a selected date. Clicking on subcategories dynamically updates the top trend chart to display relevant data for better comparison. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Population Group-Wise Credit Trends by Occupation: A Comprehensive Analysis](https://paragkar.com/population-group-wise-credit-trends-by-occupation-a-comprehensive-analysis/): This dashboard provides an insightful analysis of the outstanding credit of scheduled commercial banks across different population groups (rural, urban, metropolitan, and semi-urban) categorized by occupation. Users can explore credit trends by clicking on subcategories, and view data in either absolute values (in Rs Lakh Cr) or as a percentage of GDP. The top trend chart dynamically updates to reflect selected metrics for better comparative analysis. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Analyzing Interest Rate Trends Across Scheduled Commercial Banks in India](https://paragkar.com/analyzing-interest-rate-trends-across-scheduled-commercial-banks-in-india/): This dashboard provides insights into the interest rate range and outstanding loans of scheduled commercial banks in India, represented through histograms for different types of banks, along with a time-series chart for all banks. Users can filter by interest rates and dates, and view either absolute values (in Rs Lakh Cr) or as a percentage of GDP, with interactive features that allow the histograms to update the time-series data accordingly. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Industry-Wise Bank Credit Deployment: Trends & Analysis](https://paragkar.com/industry-wise-bank-credit-deployment-trends-analysis/): Explore industry-wise bank credit deployment with this interactive visualization. The top section provides the aggregated value of credit across all industries in a bar chart format. Click on any industry in the heatmap to see its specific trend reflected in the bar chart above. The heatmap ranks industries based on your selected metric from the dropdown menu, such as absolute value in Rs Lakh Cr, % of GDP, or ratio relative to the first value in the selected time window. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [State-Level Financial Accommodation Analysis: Dynamic Insights into Government Borrowing Trends](https://paragkar.com/state-level-financial-accommodation-analysis-dynamic-insights-into-government-borrowing-trends/): Explore the financial accommodations availed by Indian state governments through a dynamic visualization, providing insights into Special Drawing Facility (SDF), Ways and Means Advances (WMA), and Overdraft (OD) under various facilities during September 2024. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Visualizing Indian Small Savings Trends: A Comprehensive Heatmap Analysis](https://paragkar.com/visualizing-indian-small-savings-trends-a-comprehensive-heatmap-analysis/): Explore a detailed visualization of Indian small savings data, including total savings, heatmap insights, and breakdown by different saving items, with an option to view values in absolute terms, as a ratio to future value, or as a percentage of GDP. Click here for a chart demo Export to PDF Export to PowerPoint Full Screen - [Bridging the Gaps: Exploring the Challenges and Opportunities of Direct-to-Mobile Satellite Connectivity](https://paragkar.com/bridging-the-gaps-exploring-the-challenges-and-opportunities-of-direct-to-mobile-satellite-connectivity/): Mobile phones have become an indispensable part of our lives, transforming the way we communicate, navigate, work, and seek entertainment. This revolution in communication technology is a relatively recent phenomenon in human history, yet it has become so deeply integrated into our existence that imagining life without it feels impossible. Whether it’s talking to loved ones, browsing the internet, shopping online, navigating unfamiliar terrains, engaging on social media, accessing news, or seeking emergency assistance, mobile networks are omnipresent companions. The expectation of seamless coverage, whether at home, work, or even in remote locations, has made the absence of mobile connectivity […] - [Trend Analysis of Government of India Treasury Bills Outstanding](https://paragkar.com/trend-analysis-of-government-of-india-treasury-bills-outstanding/): This dashboard provides a detailed view of the outstanding treasury bills issued by the Government of India, segmented by maturity periods (91-day, 182-day, 364-day) and categories of holders such as banks, state governments, primary dealers, and others. - [RBI Weekly Assets and Liabilities: Trends and GDP Perspective](https://paragkar.com/rbi-weekly-assets-and-liabilities-trends-and-gdp-perspective/): This dashboard presents a weekly snapshot of the Reserve Bank of India's assets and liabilities, including key components like notes issued, deposits, and other liabilities. - [Snapshot of Major Price Indices and Inflation Trends Across Key Categories](https://paragkar.com/snapshot-of-major-price-indices-and-inflation-trends-across-key-categories/): This dashboard provides a detailed overview of major price indices, including the Consumer Price Index (CPI), Wholesale Price Index (WPI), and related categories such as Primary Articles, Fuel & Power, and Manufactured Products. - [Interactive Dashboard for Total AUC, Trend Analysis, and Ratio Dynamics](https://paragkar.com/interactive-dashboard-for-total-auc-trend-analysis-and-ratio-dynamics/): This interactive dashboard provides a comprehensive analysis of Total Assets Under Custody (AUC) trends, ratio dynamics relative to the starting value, and entity-specific performance. - [Indian Telecom Wireless ARPU Dashboard: Revenue Composition and Trends](https://paragkar.com/indian-telecom-wireless-arpu-dashboard-revenue-composition-and-trends/): Explore the detailed breakdown of Indian telecom industry's Average Revenue Per User (ARPU), segmented by revenue streams such as data, calls, SMS, VAS, and rentals. - [Indian Wireless Data KPI Dashboard: Trends in Usage, Pricing, Subscribers, and Technology](https://paragkar.com/indian-wireless-data-kpi-dashboard-trends-in-usage-pricing-subscribers-and-technology/): This dashboard provides a comprehensive view of India's wireless data ecosystem, showcasing key performance indicators like average data usage (GB/month), data pricing (Rs/GB), subscriber base (millions), and technology-wise data distribution (5G, 4G, 3G, 2G). - [Python - Processing TRAI's Subscription Report](https://paragkar.com/python-processing-trais-subscription-report/): Every month, TRAI releases its Telecom Subscription Reports in a notoriously challenging format. I’ve tested numerous paid and free PDF tools, all in vain. Extracting data from these PDF files for processing and visualization has been a time-consuming ordeal. Today, I’m sharing my code that effortlessly retrieves this information swiftly and without the need for external tools. As long as the PDF formatting remains consistent, this code continues to perform seamlessly, which has been the case for quite some time. For the sake of clarity in debugging, I’ve divided the code into straightforward steps, outlined below. Step1 – Converting the PDF file […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 15)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-15/): Introduction The Spectrum Auction of 2021 was a stark indicator of the declining interest in spectrum bidding, reflecting a significant lack of enthusiasm from telecom operators. This auction, held from 1st March to 2nd March 2021, lasted just two days and saw only six rounds of bidding, compared to 31 rounds in the 2016 auction. The diminished bidding activity pointed to deeper systemic issues, primarily driven by unrealistic reserve prices, inadequate demand, and a near-monopolistic market structure. Reserve Price TRAI recommended the reserve prices for the 2021 auction through its recommendations dated 1st August 2018. Much like in previous auctions, […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 14)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-14/): Introduction The Spectrum Auction of 2016 represented another chapter in India’s telecom auction history, with significant developments and recurring issues in spectrum pricing and allocation. The auction began on 1st October 2016 and ended on 6th October 2016, lasting five days with a total of 31 rounds. This was a stark contrast to the 115 rounds seen in the previous 2015 auction, indicating diminishing interest and bidding intensity in the market. The subdued participation pointed to underlying challenges in the auction design, reserve pricing, and market dynamics. Reserve Price TRAI recommended the reserve prices for the 2016 auction through its […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 13)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-13/): Introduction The Spectrum Auction of 2015 marked one of the most intense and contentious auctions in India’s telecom history, often referred to as a “bloodbath” due to the fierce competition among operators. This auction highlighted the immense pressure on telecom companies to secure spectrum for business continuity, particularly for those whose licenses were nearing expiration. The 2015 auction underscored the challenges posed by limited spectrum availability, regulatory inconsistencies, and the use of aggressive bidding tactics by competitors to drive up prices. Reserve Prices – A Continued Complexity The reserve prices for the 2015 auction were recommended by TRAI across multiple […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 12)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-12/): Introduction The Spectrum Auction of 2014 marked a major shift in how the pricing and valuation of telecom spectrum were handled in India. It was a turning point that saw the Telecom Regulatory Authority of India (TRAI) take a more data-driven, nuanced approach to valuation, which deviated significantly from the methods used in earlier auctions. TRAI, for the first time, utilized multiple pricing models to estimate reserve prices, thereby attempting to bring more rationality to the process and prevent the irrational exuberance seen in previous auctions. However, while the approach evolved, certain systemic challenges and inconsistent policies persisted, preventing a […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 11)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-11/): Introduction The Spectrum Auction of 2013 was an unusual event in India’s telecom history. It was held just four months after the 2012 auction, aimed at selling the unsold spectrum and addressing the challenges that arose from the previous auction. However, the outcome revealed ongoing inconsistencies in spectrum pricing, reserve prices, and auction guidelines. This installment delves into the 2013 auction process, the peculiarities of its design, and the key issues that continued to shape the telecom landscape in India. Offered Spectrum The 2013 auction offered the following spectrum for sale: Liberalization of 2G Spectrum The 2013 auction came with […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 10)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-10/): Introduction The Spectrum Auction of 2012 marked a pivotal moment in the history of Indian telecom. Stemming from the Supreme Court’s landmark judgment on 2nd February 2012, the auction was a direct outcome of the cancellation of 122 telecom licenses that had been granted during the controversial 2G licensing process of 2008. The judgment directed the government to hold fresh auctions for spectrum in the 2G bands, similar to the 3G auction held in 2010. This part of the series will explore the intricacies of the 2012 auction, the liberalization of 2G bands, the reserve price controversy, and the key […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 9)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-9/): Introduction The Broadband Wireless Access (BWA) auction of 2010 began just two days after the conclusion of the 3G auction, on 24th May 2010, and concluded on 11th June 2010. This auction marked another critical milestone in India’s telecom history, as it opened the door for 4G technology in the country, albeit under the guise of BWA. Before delving into the auction process, it is essential to understand the background of the availability of the BWA spectrum in the 2300 and 2500 MHz bands, and the dynamics that drove the auction process. The BWA auction would ultimately set the stage […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 8)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-8/): Introduction The 3G auction, initially announced by the Department of Telecommunications (DoT) in 2008, was meant to usher in a new era for mobile services in India. The promise of 3G was to bring faster internet connectivity, improved network efficiency, and advanced features that would drive the digital transformation of the country. However, the auction process was far from smooth. It was marred by delays, regulatory inefficiencies, and a significant mismatch between demand and supply that led to an astronomical increase in auction prices. This part explores the 3G auction journey from its beginning to the auction itself, delving into […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 7)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-7/): Introduction In continuation of the saga of the 2007/08 cellular licenses, this part explores the regulatory responses to the challenges surrounding spectrum availability and the consequences of a flawed licensing and spectrum assignment policy. With the entry of new players and the introduction of dual technology, the existing regulatory frameworks came under immense pressure, exposing weaknesses that led to significant industry disruptions. This part delves into the spectrum availability resolutions, the failure of the First Come First Serve (FCFS) policy, and the broader impacts on spectrum pricing and technology evolution. Spectrum Availability Resolution As mentioned in the previous part, two […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 6)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-6/): Introduction to New Cellular Licenses The year 2007/08 marked yet another turning point in the Indian telecom landscape. Similar to how the “Limited Mobility” battle led to the Unified Access Service License (UASL) guidelines of November 2003, the battle for “Dual Technology” paved the way for the new cellular licenses issued in 2007/08. But what motivated the CDMA operators to seek GSM spectrum? The answer lies in the technology-specific spectrum assignment policies of the government, which had created a distinct disadvantage for CDMA operators. This part of the series delves into the events that led to these new licenses, the […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 5)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-5/): Introduction By 2003, the telecom landscape in India had become increasingly complicated, with numerous players holding different types of licenses. Battle lines were drawn between Cellular Mobile Telephone Service (CMTS) and Basic Telephony Service (BTS) operators. Since BTS operators were given the same quantum of spectrum in similar bands, they were fully capable of offering comparable services at par with CMTS operators. This capability led to innovative yet controversial practices, such as the over-the-air dynamic activation of WLL (Wireless in Local Loop) subscribers outside their Short Distance Charging Area (SDCA), leading to virtually full roaming capabilities. This competition and these […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 4)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part-4/): Basic Service License (1997) In 1995, bids were also invited for basic telephony services with the license fee payable for 15 years. This license empowered operators to provide both fixed-line and wireless-based basic telephony services. Six licenses were granted in the year 1997–98 through a process of tendering. License Fees The Department of Telecommunications (DoT) accepted the bids along with the payment schedules, which are documented in the following picture. Note that for Andhra Pradesh, the values are picked from Tata’s BTS License Agreement dated 4th November 1997. For the rest of the circles, the data has been built based […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 3)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-part3/): Introduction Following the issuance of the initial cellular licenses in 1994, which revealed several structural challenges, the government decided to expand the licensing framework by offering additional licenses in 1995. This time, the licensing process aimed to cover not only the metro cities but also the telecom circles across the country. The approach shifted from a “beauty contest” model to a competitive bidding model. While this change seemed like a logical progression towards more transparency and market-driven allocation, the new process introduced its own set of complexities and issues. The 1995 cellular licenses, granted through a tendering process, marked the […] - [A Deep Dive into the History of Indian Telecom Licensing: Lessons and Failures (Part 2)](https://paragkar.com/a-deep-dive-into-the-history-of-indian-telecom-licensing-lessons-and-failures-2/): Introduction The initial step towards private sector participation in the Indian telecom sector began in 1994 with the introduction of cellular licenses. This was a time when India was opening up its economy and telecommunications was a key area requiring massive investment, which the Department of Telecommunications (DoT) alone could not manage. To address the increasing demand for telephone services, the government introduced policies to bring private players into the market. The foundational policy that set the stage for these changes was the National Telecom Policy (NTP) of 1994. NTP-1994 had a clear objective: to make telecommunication services available to […] ## Pages - [Test Subscribe](https://paragkar.com/test-subscribe/): Test Mounthly ₹5 /1 months Buy - [Subscribe Unlock Post](https://paragkar.com/subscribe-unlock-post/): Monthly ₹399 /1 months Free for 7 Days! Access 400+ premium posts. Regular updates with exclusive insights. Subscribe Quarterly ₹999 /3 months Free for 7 Days! Access 400+ premium posts. Regular updates with exclusive insights. Subscribe Yearly ₹3,499 /1 years Free for 7 Days! Access 400+ premium posts. Regular updates with exclusive insights. Subscribe Unlock 1 Post ₹99/1 posts Unlock Now! Lifetime access to this exclusive post. Expert insights made instantly available. Subscribe Unlock 5 Post ₹349/5 posts Unlock Now! Lifetime access to this exclusive post. Expert insights made instantly available. Subscribe Unlock 20 Post ₹1,299/20 posts Unlock Now! Lifetime […] - [Unlock Post](https://paragkar.com/unlock-post/): Unlock 1 Post ₹99.00/1 posts Unlock Post Unlock 5 Post ₹299.00/5 posts Unlock Post Unlock 25 Post ₹1,999.00/25 posts Unlock Post - [Contact Us](https://paragkar.com/contact-us/): Get in Touch Whether you have questions about our articles, need assistance, or want to connect, we’d love to hear from you. Company: Parag Kar Advisory LLPEmail: contact@paragkar.comLocation: Gurgaon, Haryana, India Have a question? Send us a message below, and we’ll get back to you as soon as possible. - [Terms & Conditions](https://paragkar.com/terms-and-conditions/): Last updated on Aug 27th 2024 For the purpose of these Terms and Conditions, The term “we”, “us”, “our” used anywhere on this page shall mean PARAG KAR ADVISORY LLP, whose registered/operational office is DW 197 Deerwood Nirvana Country Gurgaon HARYANA 122012 . “you”, “your”, “user”, “visitor” shall mean any natural or legal person who is visiting our website and/or agreed to purchase from us. Your use of the website and/or purchase from us are governed by following Terms and Conditions: Disclaimer: The above content is created at PARAG KAR ADVISORY LLP’s sole discretion. Razorpay shall not be liable for […] - [Cancellation and Refund](https://paragkar.com/cancellation-and-refund/): Last updated on Aug 27th 2024 PARAG KAR ADVISORY LLP believes in helping its customers as far as possible, and has therefore a liberal cancellation policy. Under this policy: - [Subscribe](https://paragkar.com/subscribe/): Monthly ₹399 /1 months Subscribe Quarterly ₹999 /3 months Subscribe Yearly ₹3,499 /1 years Subscribe - [About Parag Kar](https://paragkar.com/about-parag-kar/): Telecom, IT, Finance, and Data Visualization Expert - [My account](https://paragkar.com/my-account/) - [Checkout](https://paragkar.com/checkout/) - [Cart](https://paragkar.com/cart/) - [Shop](https://paragkar.com/shop/) - [Privacy Policy](https://paragkar.com/privacy-policy/): Who We Are Our website address is: http://paragkar.com. Comments When visitors leave comments on the site, we collect the data shown in the comments form, along with the visitor’s IP address and browser user agent string to aid in spam detection. An anonymized hash of your email address may be sent to the Gravatar service to check if you use it. You can view the Gravatar service privacy policy here: https://automattic.com/privacy/. After comment approval, your profile picture is publicly visible within your comment. Media If you upload images to the website, avoid including embedded location data (EXIF GPS). Visitors can […] - [Home](https://paragkar.com/): Learn More Authors Message When information is scattered, it can overwhelm. But when curated thoughtfully and presented without bias, it tells the real story. ParagKar.com is dedicated to that mission. Here, you’ll find my articles, carefully organized for easy access, enriched with interactive visualizations, and accompanied by practical tutorials that guide you in designing your own charts for deeper insights. With actionable guidance, step-by-step techniques, and a clear perspective on industry trends and policy shifts, this space empowers you to navigate complexity with confidence and clarity. Featured Data Stories edit post Indian Trade Foreign Trade Performance Analysis: Leading 25 Products […] ## Products - [Unlock 20 Post](https://paragkar.com/product/unlock-20-post/): Unlock Now! Lifetime access to this exclusive post. Expert insights made instantly available. - [Unlock 5 Post](https://paragkar.com/product/unlock-5-post/): Unlock Now! Lifetime access to this exclusive post. Expert insights made instantly available. - [Unlock 1 Post](https://paragkar.com/product/unlock-1-post/): Unlock Now! Lifetime access to this exclusive post. Expert insights made instantly available. - [Quarterly](https://paragkar.com/product/quarterly/): Access 400+ premium posts. Regular updates with exclusive insights. - [Yearly](https://paragkar.com/product/quaterly/): Access 400+ premium posts. Regular updates with exclusive insights. - [Monthly](https://paragkar.com/product/monthly/): Access 400+ premium posts. Regular updates with exclusive insights. [comment]: # (Generated by Hostinger Tools Plugin)