Course 2: AI for Investigative Analytics

Central Time (CT) Online May 11, 2026 $895.00 + tax

Register Now

Course Overview

This advanced course equips anyone involved in investigations with practical skills to manage and analyse large volumes of data using Microsoft Copilot in Excel. Learn how to transform raw data into actionable insights while maintaining compliance and oversight.

Duration: 6.5 Hours (Full-Day Workshop Online or In Person for Organizations)

Format: Interactive Training with Hands-On Exercises, Case Study, and Group Discussions.

Participants will have:

  • taken Course 1: AI for Investigations: The Fundamentals or have equivalent knowledge and/or experience.
  • access to Copilot (and know what version they have) and Excel/Word

Course Highlights:

  • Import and Prepare Data: Learn to import Teams logs and convert Outlook email data into CSV/XLS formats for analysis.
  • Data Cleaning and Structuring: Use Copilot to remove duplicates, normalise datasets, and prepare data for investigative workflows.
  • Anomaly Detection: Detect irregular login patterns, financial discrepancies, and other red flags using structured prompts.
  • Visualisation and Reporting: Generate charts and visuals that highlight key trends and findings.
  • Compliance and Auditability: Apply human-in-the-loop verification and maintain defensible audit logs.

Key Benefits:

  • Reduce time spent on manual data review.
  • Focus on anomalies and patterns that matter most.
  • Ensure outputs are accurate, neutral, and defensible.

Outcome: Participants will leave with practical skills to quickly identify red flags, streamline data analysis, and focus on relevant evidence.

Course Summary:

Course Objective

Enable anyone involved in investigations to use Microsoft Copilot in Excel to efficiently analyse large datasets, import and structure data from multiple sources, detect anomalies, and generate actionable insights—helping them focus on critical facts and ignore irrelevant noise.

Modules & Timing

Module 1: Introduction & Context (30 mins)

  • Recap of Copilot fundamentals and its role in investigative efficiency.
  • How Copilot helps filter noise and highlight key patterns in large datasets.

Module 2: Importing and Preparing Data (60 mins)

  • Importing logs from collaboration tools (e.g., Teams) into Excel.
  • Converting Outlook email data into CSV/XLS for analysis.
  • Using Copilot to clean and structure imported data for investigative workflows.

Module 3: Advanced Prompt Engineering for Data Analysis (60 mins)

  • Crafting structured prompts for anomaly detection and summarisation.
  • Using constraints and formats for tabular outputs.
  • Hands-on: Write prompts to identify anomalies in access logs.

Module 4: Anomaly Detection & Pattern Recognition (90 mins)

  • Detecting irregular login patterns, financial discrepancies, or unusual behaviours.
  • Using Copilot for trend analysis and risk scoring.
  • Practical exercise: Analyse a large dataset for red flags and prioritise key findings.

Module 5: Visualisation & Reporting (60 mins)

  • Generating charts and dashboards with Copilot.
  • Formatting outputs for clarity and defensibility.

Module 6: Verification & Auditability (45 mins)

  • Human-in-the-loop checks for flagged anomalies.
  • Logging prompts and outputs for compliance and defensibility.

Module 7: Ethics & Governance (30 mins)

  • Privacy safeguards when handling sensitive data.
  • Aligning outputs with retention and organisational policies.

Wrap-Up & Knowledge Check (15 mins)

Daniel Bertrand

Daniel is a highly skilled investigative professional with over 40 years of experience. He has a comprehensive investigative background that includes teaching, managing and conducting complex investigations.

Daniel is a pioneer using and understanding the value of Artificial Intelligence in investigations, intelligence collection and analysis, He has created AI tools and methodologies designed to identify, collect, analyze, and preserve electronic evidence. He is an expert in technologies and techniques that use AI for information gathering, analysis, and interpretation for investigations. He is proficient in social media, cyber, dark web, cryptocurrency and blockchain analysis,

He has multiple certifications in a variety of fields, including in  Artificial Intelligence Developer and Prompt Engineering, MIT Artificial Intelligence for Business Strategy, Digital Forensic Examination and Blockchain Analysis & Cryptocurrency Investigations.

Daniel is fluent in French and English, and is a member of several organizations, including the Council of International Investigators (CII-Certified Member), the Council of Professional Investigators of Ontario (CPIO), the Association of Workplace Investigators (Canadian Chapter – Ottawa), the High Technology Crime Investigation Association (HTCIA – Ottawa Chapter), the Association for Intelligent Information Management (AIIM – Canada) and the Canadian Artificial Intelligence Association (CAIAC). He is also the recipient of the Webber Seavey Award for Quality in Law Enforcement awarded by the International Association of Chiefs of Police (IACP).