Unlock the Future of Intelligence Analysis: Join us for an engaging and hands-on webinar where we explore how ChatGPT, a free and accessible AI tool, can revolutionize your approach to coding across leading analytical platforms like Excel, PowerBI, ArcPro, Tableau, and more. Learn how to generate custom code effortlessly, streamline tasks, and elevate your analysis—without the need for extensive coding knowledge. Discover practical examples from real-world law enforcement scenarios and leave empowered with the tools and techniques to enhance your analytical capabilities, no matter your technical level.
No Code, No Problem: Analysts don’t need to learn to code—they just need ChatGPT.
Unlock the full potential of your analytical toolkit, whether it includes Excel, PowerBI, ArcPro, Access, Tableau, i2, or other intelligence analysis tools. These platforms have always had associated coding languages that analysts could use to exponentially improve their products. However, until November 2022, mastering coding for these platforms required extensive study. Enter artificial intelligence, and the game has changed. This presentation is your guide to leveraging ChatGPT, a free resource that empowers analysts of all technical levels to enhance their capabilities across any analytical tool.
Delving into the most widely used analytical tools and their associated coding languages, we explore the transformative impact of coding in MS Excel, where formulas and Visual Basic unlock powerful data cleaning and automation. In PowerBI, mastery of DAX formulas allows for unparalleled customization. Python and SQL emerge as versatile languages for intelligence analysis tasks, and this presentation introduces these concepts, highlighting how ChatGPT eliminates the need for extensive coding study.
Drawing on real-world examples from the presenter’s experience consulting with local law enforcement agencies, participants will engage in practical demonstrations. Regardless of technical proficiency, every participant will leave with custom code they can use with their preferred tools to streamline various intelligence analysis tasks. More crucially, attendees will gain insights into optimizing ChatGPT as a powerful force multiplier within their analysis units. Elevate your analytical prowess without the coding learning curve—ChatGPT is now your personal developer.
“Details about our special guest panelists.”
Amanda K. Bruner is a crime analysis advisor at CNA’s Center for Justice Research and Innovation, supporting federal programs like Crime Analyst in Residence (CAR) and Project Safe Neighborhoods (PSN). She assists law enforcement agencies across the U.S. and has previous experience as a crime analyst for the Matthews Police Department and as a corporate intelligence specialist at Bank of America.
Bruner is also an adjunct professor at Radford University and UNC Charlotte, President of the Carolinas Crime Analysis Association (CCAA), and a volunteer with the IACA. She holds a master’s degree in law enforcement intelligence and recently received the 2024 IALEIA Individual Award for Excellence.
Charley Giberti is a Solution Engineer contracting with the U.S. Department of Justice’s Money Laundering and Asset Recovery Section (MLARS), specializing in implementing advanced data analysis systems. He has consulted with various U.S. government agencies and provides training to law enforcement through programs like Project Safe Neighborhoods (PSN). Previously, Charley worked as a crime analyst and analyst supervisor for the police departments of Cincinnati and Wichita. A frequent speaker at the IACA, he won the 2018 Innovation Award. He holds a master’s degree from Florida State University and is a certified Microsoft Power Platform Architect.
Save the date for this event, scheduled for 26 September 2024 at 4:00 pm (CEST).
About the series
Meet the Experts is a series of events organized by the European Forensic Institute to connect professionals and students in the forensic science field. This series introduces participants to a wide range of forensic disciplines, including Digital Forensics, Forensic Engineering, Intelligence, Fraud, Counterfeiting, Crime Scene Investigation, and more. Our expert guests will discuss various topics from their fields, sharing insights into their daily work, industry best practices, forensic innovations, and the latest advancements in technology.
