Call Detail Records

Written By Joshua Todd

Stop manually formatting CDRs. Automate your Tower Dump analysis in Excel.

Are you still manually merging carrier spreadsheets for your investigations? We’ve outlined a standardized 7-step workflow to streamline CDR and Tower Dump analysis using tools you already have.

From ingesting raw CSVs with Power Query to visualizing sector activity with Pivot Tables and Heatmaps, this workflow turns data into actionable intelligence.

Key Technical Takeaways:
-Power Query: Automate the cleaning and appending of carrier files.
-XLOOKUP: Instantly enrich cell sites with subscriber data.
-SUMIFS: Create fast, condition-based summaries by date or tower.
-Automation: Set it up once, then just hit "Refresh" for new evidence.

Elevate your tradecraft. Join the Adirondack IALEIA chapter for full resources and networking.

Contact us: adiron.chapter@ialeia.org

Joshua Todd
Previous

CDR Analysis