This two-day virtual instructor led hands-on course equips participants with the skills to transform structured datasets into actionable investigative intelligence.
On Day 1, students learn practical techniques using Microsoft Excel to filter, sort, pivot, and visualize large datasets to identify patterns and build investigative timelines.
On Day 2, students work with SQLite databases extracted from mobile applications or system artifacts, learning to navigate, query, and link information to broader case data.
By the end of the course, participants will confidently process and correlate digital exports to uncover leads and produce court-ready reports.
Topics Covered:
• Understanding structured data formats used in investigations
• Importing and preparing datasets in Excel for analysis
• Filtering, conditional formatting, and formulas for identifying patterns
• Creating pivot tables and investigative timelines
• Visualizing data for investigative reports and presentations
• Understanding SQLite database structure and investigative value
• Using SQLite viewer tools and running basic queries
• Joining tables and correlating app activity with other evidence
• Exporting SQLite results and integrating them with Excel analysis
This two-day virtual instructor led hands-on course equips participants with the skills to transform structured datasets into actionable investigative intelligence.
On Day 1, students learn practical techniques using Microsoft Excel to filter, sort, pivot, and visualize large datasets to identify patterns and build investigative timelines.
On Day 2, students work with SQLite databases extracted from mobile applications or system artifacts, learning to navigate, query, and link information to broader case data.
By the end of the course, participants will confidently process and correlate digital exports to uncover leads and produce court-ready reports.
Topics Covered:
• Understanding structured data formats used in investigations
• Importing and preparing datasets in Excel for analysis
• Filtering, conditional formatting, and formulas for identifying patterns
• Creating pivot tables and investigative timelines
• Visualizing data for investigative reports and presentations
• Understanding SQLite database structure and investigative value
• Using SQLite viewer tools and running basic queries
• Joining tables and correlating app activity with other evidence
• Exporting SQLite results and integrating them with Excel analysis
