India telecom subscriber and data usage analysis

The brief

A telecom strategy team wants the real picture of India's mobile market. Extract subscriber and data-usage figures from TRAI reports into a database and show growth by state and operator, and how data use per user has changed. Good looks like: a clean database built from the reports, reconciled SQL queries, and a short illustrated briefing.

What you will build

1. Collect TRAI subscription and performance reports
2. Extract the tables into a database
3. Analyse growth by state and operator in SQL
4. Track data use per subscriber over time
5. Write an illustrated briefing

Free, open data to build it with

• TRAI reports ↗ Telecom Regulatory Authority of India

Check each dataset's licence before you publish your work. Your mentor gives your team its own version of the brief (data, scope or region), so every team's project is its own.