Episode 14 – Dr Cynthia Lum

Dr Cynthia Lum

Dr. Cynthia Lum is Professor of Criminology, Law and Society and Director the Center for Evidence-Based Crime Policy at George Mason University. She researches primarily in the areas of policing, evidence-based crime policy, crime prevention, technology, and translational criminology. Her works in these areas include evaluating the impacts of patrol and detective activities, interventions, and technologies; understanding the translation and receptivity of research in policing; and measuring police proactivity. With Dr. Christopher Koper she has developed the Evidence-Based Policing Matrix (with Cody Telep) and the Matrix Demonstration Projects, translation tools designed to help police practitioners incorporate research into their strategic and tactical portfolios.

Professor Lum is an appointed member of the Committee on Law and Justice (CLAJ) for the National Academies of Sciences (NAS), and has also served on the NAS’s Committee on Proactive Policing as well as its Standing Committee on Traffic Law Enforcement. She is a member of the National Police Foundation Board of Directors, the Research Advisory Committee of the International Association of Chiefs of Police, the Misdemeanor Justice Project at John Jay College of Criminal Justice, and an Executive Counselor for the American Society of Criminology. She is the founding editor of Translational Criminology Magazine and the Springer Series on Translational Criminology, and served as the first North American Editor for the Oxford Journal Policing: A Journal of Policy and Practice. Dr. Lum is a Fulbright Specialist in policing and criminology and is the co-Director of the International Summer School for Policing Scholarship, developed with colleagues at the Scottish Institute for Policing Research and Arizona State University.

Her recent book, with Christopher Koper is Evidence-Based Policing: Translating Research Into Practice (2017, Oxford University Press). Professors Lum and Koper Editors-In-Chief of Criminology and Public Policy, the flagship policy journal of the American Society of Criminology.

Reinventing American Policing

Episode 13 – Andrew Reece

Analyst Andrew Reece

Andrew Reece is a graduate of the University of Maryland with a double major in criminology and government & politics). He jumped into government contract work for the US Dept. of Justice shortly after graduation. He mostly performed financial analysis of USDOJ grant expenditure. He moved to Blacksburg and became a communications officer for the Virginia Tech Police Dept for 2 years. From there, he worked in the financial crimes division of Wells Fargo for a short period of time before taking his current position as a crime analyst for the Roanoke City Police Department, where he recently celebrated his 4th “anniversary” in May. His current position mostly has him focusing on crime series, trends/patterns, hot spot analysis, and various data requests that come from inside and outside the department. He is also one of only a few hundred certified crime prevention specialists in the state of Virginia, and also recently acquired his general instructor certification from the state’s division of criminal justice services.

Roanoke VA Police Facebook page
Andrew’s Roanoke PD email
Andrew’s Music on BandCamp (yes, he writes and plays music too)

NIRO Knowledge – Episode 0.12

My apologies to Andrew Reece for losing my own audio somehow. It did not track but we did get his side of things. Unfortunately, it means the great conversation we had needs to be redone. In the meantime, here is a one off for you. I provide updates on the Access course, upcoming guests, the state of things, my philosophy update and I break down what my logo’s meaning and where it came from.

Free Microsoft Access Beginner’s Course

Episode 0.11

Just a short episode, since I was sick and had to postpone my interview, where I talk about upcoming guests, my new logo that you will start seeing around and how the work is going on the new version of UALE and a little bit more.

Stay tuned for upcoming guests Andrew Reece, Hillary Peladeau and Dr Cynthia Lum.

UALE – the FREE online Microsoft Access course geared towards the criminal justice field

Episode 12 – CrimCon: Dr Andrew Wilczak and Dr Troy Payne

CrimCon – Dr Andrew Wilczak & Dr Troy Payne

Dr Andrew Wilczak received his MA in Criminology and Criminal Justice from Eastern Michigan University in 2006 and his PhD in Sociology from Bowling Green State University in 2011, with a focus in criminology and social psychology. His research interests include examining how violence and exposure to violence influence adolescent development, the history of violence and public policy, and the role of criminological theory in understanding revolutionary action. He is the host of two podcasts focusing on public scholarship: Untenured Tracks, a casual interview series with untenured faculty and graduate students about their research and pedagogy, and Strength Check, a collaborative project with Drs. Joan Antunes, Mike Dando, and Shauna Lesseur, which focuses on narrative storytelling as a teaching tool.

Dr Troy Payne has been at the University of Alaska Anchorage since 2010. Before that, he earned an M.S. and Ph.D. from the University of Cincinnati. His primary interests are translational research, data visualization, crime prevention and policing — but he’s also done work in risk assessment and a handful of other areas over the years. Most recently, as Associate Director of the Alaska Justice Information Center, he has been focused on translational research, on finding ways to communicate his findings to both policy members and the public.

CrimCon (Criminal Consortium)
CrimCon on Twitter

Episode 11 – Trina Cook

An analyst since 2000, Trina gained law enforcement experience as a records specialist for six years before starting at Tukwila PD. Trina became an IACA Certified Law Enforcement Analyst in 2012. In 2014-15, she led the vendor selection process for her department’s new records management system. Trina was relocated in 2017 to her department’s Major Crimes Unit and loves assisting detectives on interesting cases. Trina enjoys being involved in her regional association, NORCAN, and has a special place in her heart for threshold analysis and z-scores. Below is the image Trina and I talk about in the episode.

Trina’s Email
Trina on LinkedIn

Tukwila Police Facebook: https://www.facebook.com/TukwilaPD/
Tukwila Police Twitter: @TukwilaPD

NIRO Knowledge – Episode 0.9

I give a quick apology to you, my audience, for not keeping to my publishing schedule, I give an update of interviews and guests to come (with a name drop for a June episode), and I give you some quick insights on what I have been working on (myself and the Access online course sequel to come) with some resources in these show notes below. Please listen to Dawn Reeby’s and Amy Boudreau’s podcast episodes if you are looking to help grow yourself and want to put yourself first (or even put yourself on your list of things to take care of) since we are the most important part of our lists.

Dawn Reeby’s Rising GENIUSS program
Free consultation call with Dawn to see if the GENIUSS program is right for you

Dawn’s NIRO Knowledge Episode

Amy Boudreau’s NIRO Knowledge Episode (show notes have TONS of links related to personal wellness)

NIRO Knowledge – Episode 0.7

I just wanted to give an update of COVID related matters and a quick comment to the idea of “herd immunity.” A quick thanks to those who downloaded the course, and there were quite a few of you, and to those that let me know that you have had success in building your own databases already from what you learned.

Resources and Links:
Ultimate Access for LE
American Society of Evidence Based Policing
Canadian Society of Evidence Based Policing
NIRO Knowledge on Twitter

NIRO Knowledge – Episode 0.6

Hello everyone and thank you again for lsitening. If you know someone, including yourself, that would like to share something on the show, please reach out to me ____.

Check out past episodes while we wait for this COVID-19 turbulence to clear up and the FREE online Microsoft Access course, Ultimate Access for Law Enforcement (but for anyone in criminal justice that is looking to track data utilizing a data management application).

NIRO Knowledge – Episode 0.5

A quick thank you to those essential personnel that are the out there on the front lines from police to corrections to grocery store staff and so many more. These trying and turbulent times have forced numerous cancellations of in person training and conferences and I have opened up my online course for free. Jump right to learning Microsoft Access and learn how you can apply it to criminal justice usage whether you are an admin, detective, analyst, student, correctional officer or anyone within the industry.

Ultimate Access for Law Enforcement online course

NIRO Knowledge – Episode 10

Dr Joel Caplan

Dr. Joel Caplan is Associate Professor at the Rutgers University School of criminal Justice, Director of the Masters Program, and Director of the Rutgers Center on Public Security. Joel co-developed and continues to advance the spatial crime analysis technique of Risk Terrain Modeling (RTM), now used in over 35 states in the US and over 40 countries worldwide.  He has prior professional experience as a police officer, 9-1-1 dispatcher, and emergency medical technician, and he routinely serves as a research partner and consultant to agencies in the U.S. and around the world on matters of public safety and security. Joel’s latest book titled “Risk-Based Policing: Evidence-Based Crime Prevention with Big Data and Spatial Analytics” brings a lot of his evidence-based practices and experiences together in one place.

RTMDx Gratis Program – the RTM program to download and use
Joel Caplan’s Twitter – for more great analytical insight and more

NIRO Knowledge – Episode 9

Amy Boudreau

A University of Windsor graduate with a Bachelor’s Degree in Sociology, and a minor in Criminology and Psychology, Amy Boudreau has spent the last nine years as a Police Constable with a specialty in Crime Prevention. She holds a Professional Communications Certificate from the University of Toronto, has the International Crime Prevention Specialist (ICPS) designation, and is currently enrolled in a Leadership Certificate Program at the University of Waterloo.

Amy serves as a Mental Health Ambassador, Peer Support Team Member, and is part of the First Responder Mindfulness Network (FRMN) run by the Ministry of the Solicitor General Corporate Healthcare and Wellness Branch. Amy has extensive training in crisis response, crisis intervention, and mental health awareness training. In 2016, she attended the International Meditation Centre located in Chiang Mai, Thailand, for meditation training and in 2017, she began organizing meditation sessions at a local temple for police employees. At the same time, she launched her “@TheYogaCop” social media platforms to advocate, educate, inspire, and spread awareness. She holds a Corporate Yoga Certification, Trauma Sensitive Yoga (TSY) Certification, and uses Trauma Release Exercises (TRE) which assist the body in releasing deep muscular patterns of stress, tension and trauma, to help others in reaching a state of balance.

Occupational Stress Injury (OSI) and Posttraumatic Stress Disorder (PTSD) can develop over time from persistent work-related psychological injury or difficulty caused by traumatic experiences, prolonged high stress, or fatigue during service. Amy’s mission is to assist others in developing self-care, self-compassion, self-belief, and optimism, and to teach others how to maintain individual wellbeing protective factors against burn-out and psychological difficulties through a unique mental resiliency framework. Amy remains involved within the policing community through several activities:

  • Executive Board Member for the International Society of Crime Prevention Practitioners (ISCPP)
  • Community Liaison for the Canadian Society of Evidence Based Policing (CANSEBP)
  • Advancing “We” in Policing (AWIP) Committee Member, Ontario Working Group
  • Crime Prevention Through Environmental Design (CPTED) Level 1 instructor

The Wellness Presentation file is a PDF that we were discussing during the show so you can follow along and also see the visuals that she provided.

The second download of resources contains the below resources as well as others for further research.

First Responder Wellness & Mental Health, with a focus on Yoga and Mindfulness Meditation

First Responder Mindfulness Network (FRMN): a network of officers and researchers across North America collaborating, information-sharing and pioneering to advocate, educate, and bring about change within their first-responder industries as it relates to wellness and mental health through the use of mindfulness modalities, led by the Ministry of the Solicitor General, Corporate Healthcare and Wellness Branch in Toronto, Canada. Co-leads: sarah.easterbrook@ontario.ca & Vicente.Gannam@ontario.ca, if you’re interested in joining the network email Sarah & Vicente.

Healing Heroes Organization: is a holistic mind/body approach to healing trauma and PTSD for first responders and military personnel through Trauma Sensitive Yoga (TSY), Meditation and Breath (pranayama). Their mission is to alleviate the mental and physical symptoms of stress and stress related conditions, including post-traumatic stress. Call: (289) 681-1356, Email: tania@healingheroes.ca or visit their website Healing Heroes

Canadian Institute of Public Safety Research and Treatment (CIPSRT) in partnership with the Canadian Institutes of Health Research (CIHR) has launched a Mental Wellness in Public Safety research project to support the development of new research evidence and tools needed to address existing and emerging gaps in post-traumatic stress injuries (PTSI) as it relates to public safety personnel (PSP) in Canada. Visit www.cipsrt-icrtsp.ca  and follow Twitter: @CIPSRT_ICRTSP for updates, free training, free self-assessment tools, research publications and research participant opportunities.

Fo Guang Shan Temple (Buddha’s Light International Association): Offers FREE meditation training. For Canadian locations visit: www.english.fgs2.ca OR for North American locations visit: www.hsilai.org

MindFit Cop by Oscar Kilo (home of the National Police Wellbeing Service): is a FREE eight-week online mindfulness course. Oscar Kilo provides access to evidence-based research and resources that can be used to help shape wellbeing provision and encourage collaboration and innovation across not just policing, but all emergency services. Visit: https://oscarkilo.org.uk/mindfit-cop/

Center for Mindfulness in Public Safety: offers Mindfulness-Based Wellness & Resiliency professional development training for law enforcement, first responders, corrections, reentry, and treatment professionals. Visit: https://mindfulcorrections.org/

HeartMath Institute: empowers individuals, families, groups and organizations to enhance their life experiences using tools that enable them to better recognize and access their intuitive insight and heart intelligence. HeartMath has also developed Physical, Emotional and Mental Resources For Law Enforcement and First Responders. Visit: https://www.heartmath.org/training/resources-for-law-enforcement-and-first-responders/

Center for HealthyMinds, University of Wisconsin-Madison: conducted a research project on Exploring the Effects of Mindfulness Training on Police Officer Resilience and Well-Being. Visit: https://centerhealthyminds.org/science/studies/exploring-the-effects-of-mindfulness-training-on-police-officer-resilience-and-well-being

NutritionFacts.org: is a strictly non-commercial, science-based public service provided by Dr. Michael Greger, providing free updates on the latest in nutrition research via bite-sized videos. There are more than a thousand videos on nearly every aspect of healthy eating, with new videos and articles uploaded every day. The goal of this website is to present you and your doctor with the results of the latest in peer-reviewed nutrition and health research, presented in a way that is easy to understand. Visit: https://nutritionfacts.org/

NxtGenHealth (MeAwaken): Dr. Mitchell Abrams, a Canadian physician focused on creating healthy minds and connected communities. Meawaken is the result of his journey to the East and his deep immersion in a philosophy and practice that shifted his perspective in understanding the gaps in our Western Healthcare System. Cst. Amy Boudreau and Dr. Mitchell Abrams are currently collaborating on bringing a conscious healthcare model and workshop training to all community sectors. Visit: https://meawaken.com/nexgenhealth/

Evidence-based policing (EBP)

Canadian Society of Evidence-Based Policing (CANSEBP): is an Association of police practitioners, academic researchers, public policy-makers and others, whose mission is to foster the creation and mobilization of quality research in order to make evidence-based approaches a cornerstone of policing in Canada. Join as a member for FREE to gain access to EBP resources: https://www.can-sebp.net/

Center for Evidence-Based Crime Policy (CEBCP): Symposium June 29, 2020 Fairfax, Virginia, USA. Visit: https://www2.gmu.edu/topic/list/all/21066

America Society of Evidence-Based Policing (ASEBP): Conference June 1-2, 2020 Washington, DC, USA. Visit:  https://www.americansebp.org/

The Society of Evidence-Based Policing:

Australia & New Zealand Society of Evidence-Based Policing

NIRO Knowledge – Episode 8

Lorna Ferguson

Lorna Ferguson is a Ph.D. student in the Sociology department at the University of Western Ontario, Canada and is the Director of Operations for the Canadian Society of Evidence-Based Policing (CAN-SEBP). Lorna’s current research focuses on evidence-based policy, policing, and missing persons. Specifically, she examines police responses to missing by conducting interviews with police personnel from across Canada – missing persons coordinators, Search and Rescue members, police detectives, frontline officers, with the hope of filling in knowledge gaps on ‘what works’ ‘what doesn’t work’ and ‘what we still don’t know’ in terms of how to most effectively and efficiently response to missing person reports.

Lorna on Twitter
Lorna’s email: lfergu5 <at> uwo.ca
Lorna’s research on Missing Persons
CAN-SEBP – Canadian Society for Evidence Based Policing

NIRO Knowledge – Episode 7

Dawn Reeby

Dawn Reeby is an energized, subject matter expert, trainer, seasoned, and certified law enforcement analyst with success in leadership training and the development, integration, and growth of data-driven strategies. She partners with a variety of federal, state and local agencies as a law enforcement strategy specialist, designing and delivering training including webinars, nationally certified courses, day- and week-long workshops, and technical assistance.

Dawn is also the CEO of “Excellence in Analytics” and the founder of the “Rising Geniuss Transformation Program”. She is a highly sought-after law enforcement strategist and peak performance coach known for creating skilled, balanced and highly productive professionals in law enforcement analytics. She helps these professionals and rising leaders to achieve a career that gives purpose, financial stability, and impact IN UNISON with a personal life of confidence, balance and joy. She and her team do this with systems, strategies and clarity coaching so that law enforcement analysts can discover and live the lives that they absolutely love, catapulting their careers with leadership of self as a top priority. Her clients become more confident, highly efficient and productive, and deeply valued leaders who thrive personally and professionally.

Schedule a free 30 minute call with Dawn
Dawn’s Rising Geniuss program
Join her Facebook group Tribe of Excellence for free
Check out her website, Excellence in Analytics
Follow Dawn on LinkedIn

NIRO Knowledge – Episode 0.3

What is worse than someone who doesn’t yield when coming onto the highway when they don’t have the right of way at all? I’m not sure but I engage the listeners by wondering if we can come up with various problems to be solved and if we can find out how much of a problem they are. My scenario wonders if those who don’t yield when coming onto the highway create the traffic back up that then causes stress and aggression and might increase road rage incidents.

Take to Twitter and let me know what daily problems you see that would be great to research.


NIRO Knowledge – Episode 0.2

In this episode, I speak about using Twitter as my main source of social media to get out quick messages, interact with the audience and my use of polls. I speak to the difference in using Microsoft Access and Excel and my online course for Access. There is a short Google form for anyone who wishes to fill it out and speak to any issue that they may have with Microsoft Access. These will be addressed and added into my updated online course that will release a little later this year.

I also pay tribute to a great man who we lost recently, Daniel Bibel. I read his biography on his show that was sent out over our MACA listserv. It was an honor to know him and he will be missed.

UALE – Ultimate Access for Law Enforcement online course
Version 2.0 COMING SOON!
Microsoft Access Problems/Issues Form

NIRO Knowledge – Episode 6

Dr Peter Langman

Dr. Peter Langman is a psychologist whose research on school shooters has
received international recognition. His book, Why Kids Kill: Inside the Minds of School Shooters, was named an Outstanding Academic Title and was translated into German, Dutch, and Finnish. His work has been cited in congressional testimony on Capitol Hill and he has been interviewed by the New York Times, The Today Show, 20/20, Nightline, Fox, CNN, the BBC, and over 450 other news outlets in the USA, Canada, South America, Europe, Asia, Australia, and the Middle East. After the Sandy Hook attack, the CEO of the American Psychological Association presented Dr. Langman’s recommendations on school safety to President Obama. He has presented at both the FBI Headquarters in Washington, DC, and the FBI National Academy in Quantico. He has been an invited speaker at the National Counterterrorism Center and was hired by Homeland Security to train
professionals in school safety. He maintains the largest online collection of
materials relating to school shooters at schoolshooters.info, including over 500 documents totaling 65,000 pages. His latest book is School Shooters:
Understanding High School, College, and Adult Perpetrators
. In 2018, Dr.
Langman became a researcher with the National Threat Assessment Center of the United States Secret Service.

NIRO Knowledge – Episode 5

Springfield MA PD: Cristina, Scott and Bill

I talk with Cristina Fernandez, Scott Roberts and William “Bill” Schwarz of Springfield MA Police. They speak with me about their Real Time Crime Center where they perform tactical analysis as calls come in and strategic analysis going in the background among it all. They assist their agency but they also feed their community information about what is happening in their respective areas of town as well. If you are ready to find out how life runs in a crime analysis unit working in real time, give this episode a listen.

Springfield MA Police website
Springfield MA Crime Analysis Email

NIRO Knowledge – Episode 0.1

Nicholas Roy

Hello Knowledge fans! It is me, Nick, today speaking with you about the first 4 episodes of the podcast. I recap where we’ve been and I talk about where we are going. I thank my previous guests: Dr Laura Huey, Lt Glen Mills, Special Constable John Ng and Dr John Shjarback. I give a quick sneak peek, but no names, on two of the upcoming interviews I will be doing and let you in on my online course for Microsoft Access and that it will be revamped and for sale once again in a few months.

Dr Laura Huey
Glen Mills’ Open Source Policing free resources website
John Ng
Dr John Shjarback‘s website
Ultimate Access for Law Enforcement – online Microsoft Access course

NIRO Knowledge – Episode 4

Dr John Shjarback

Dr. John Shjarback is an assistant professor in the Department of Law and Justice Studies Rowan University after spending the last three years as an assistant professor at the University of Texas at El Paso. John’s research interests center on American policing with specific focuses on environmental and organizational influence on officer behavior and attitudes as well as contemporary issues in the field (e.g., the “Ferguson Effect”; de-policing; the “War on Cops” hypothesis; race and officer-involved shootings). He has worked collaboratively with various law enforcement agencies conducting evaluations. His work has appeared in a number of peer-reviewed outlets, such as Criminology & Public Policy, the Journal of Criminal Justice, and Crime & Delinquency, and he has written op-eds for The Washington Post, the New York Daily News, and the El Paso Times.​

John’s Website
John’s Officer Involved Shooting Article – Science Direct
Washington Post dataset
Texas dataset
California dataset

NIRO Knowledge – Episode 3

John Ng

Special Constable John Ng is a divisional crime analyst with the Saskatoon Police Service and has been a law enforcement analyst for over 10 years. He’s a certified law enforcement analyst with the International Association of Crime Analysts and has been an active member having volunteered with their former Methods Subcommittee co-authoring a handful of technical papers on analytical methods including hotspot analysis, prioritizing offenders, and social network analysis and currently volunteers with their Publications Committee.

He’s presented at crime analysis conferences and recently at the American Society of Evidence-Based Policing (EBP) Conference on the role of crime analysts in EBP. He also served as the Analyst Series Coordinator (lead) for the Canadian Society of Evidence-Based Policing’s (CAN-SEBP) Community Engagement Team and continues to volunteer as a Community Liaison for CAN-SEBP promoting the value of law enforcement analysts in EBP. More recently he’s been selected as an NIJ/IACP LEADS Scholar, which is a scholarship that helps support mid-level officers in advancing data and science in policing, he is one of the first crime analysts to received this scholarship.

He’s successfully completed a Master of Science degree in Criminal Justice from St. Joseph’s University in Philadelphia and an Honours Bachelor of Science degree in Psychology from the University of Toronto. His research interests include police culture, police leadership, organizational change, police tactics & strategies, hotspots policing, offender management (and risk assessments), and crime analysis.

CAN-SEBP on Twitter
CAN-SEBP online
John on LinkedIn

NIRO Knowledge – Episode 2

Lt Glen Mills

Glen Mills is a lieutenant with the Burlington Massachusetts Police Department currently assigned to the Administrative Division and oversees community services, training, emergency management, information technology and dispatch. He is involved in a number of community outreach programs and manages his department’s social media, website, Citizens Police Academy, workplace safety and crime prevention efforts.

Glen is also the current president of the Massachusetts Association of Crime Analysts, the first vice president of Police Futurists International and an IACA-certified law enforcement analyst.

Police One article by Glen on disinformation
Burlington MA PD Twitter
OpenSourcePolicing – website loaded with free goodies

NIRO Knowledge – Episode 1

Dr Laura Huey

Dr. Laura Huey is the Director of the Canadian Society of Evidence Based Policing and Professor of Sociology at the University of Western Ontario. She is also a member of the College of New Scholars, Artists and Scientists of the Royal Society of Canada, a Senior Research Fellow with the Police Foundation, and a Research Fellow for the London Police Service. She also formerly sat on the Ontario Association of Chiefs of Police Crime Prevention Committee and was formerly a member of the Board of SERENE-RISC (a Canadian Centre of Excellence on Cybercrime).

In this episode, Laura talks about the relevance of evidence based policing, data, the crime analyst, and how analysts can get involved in performing research.

LEADS Scholars – Canada

**Update 1/10/2020**
Special thanks to Steve Harmon who listened to the podcast and knew the study that escaped me during this show. Here is the Pacific Standard article and here is the link to the academic article about how “stop and frisk” could be creating negative effects on black and Latino juvenile males.

NIRO Knowledge – Episode 0

Nicholas Roy – Episode 0

Link to my college movie: Love Is A Battlefield

Happy Thanksgiving to you and all get ready for more content in 2020!

Who would you like to hear on the show? Add a NIRO Podcast Potential here.

Have a topic you would like to have discussed on the show? Add a NIRO Podcast Programming suggestion here.

If you need some beginner Microsoft Access training, check out my online course, Ultimate Access for Law Enforcement.

NIRO Knowledge Podcast Update 10/30/19

I have three people lined up to interview already for the podcast and about two dozen more on my list. This is great news for us all and I that means some quality NIRO Knowledge coming your way soon.

A piece of unfortunate news is that the logo I want to have done may not be finished in time for the release of the podcast. I am searching for someone to get the logo done up as the first potential artist could not take on the project. All in due time I’d say.

I am hoping to get more for you folks soon and I will keep you posted as it comes to fruition.

Who would you like to hear on the show? Add a NIRO Podcast Potential here.

Have a topic you would like to have discussed on the show? Add a NIRO Podcast Programming suggestion here.

If you need some beginner Microsoft Access training, check out my online course, Ultimate Access for Law Enforcement.

NIRO Podcast Update 10/26/19

Hello everyone! I am excited as the ball keeps moving forward on the start of the NIRO Crime Analysis Podcast. Our goal is a 1/1/20 start date. I have several people already lined up to speak with on the topic of analysis and other matters pertaining to our field.

I have someone working on the intro and outro for the podcast and I am searching for someone to design the logo that I have in mind.

Who would you like to hear on the show? Add a NIRO Podcast Potential here.

Have a topic you would like to have discussed on the show? Add a NIRO Podcast Programming suggestion here.

Are you looking for a beginner’s course to learn Microsoft Access, online and at your own pace and that applies to the criminal justice field? Check out our online course, Ultimate Access for Law Enforcement, and learn how Access works and how you can learn to leverage it to overcome the shortcomings of your CAD and RMS systems.

IACA 2019 Conference

I am a little late getting to this as I just found it in my drafts! Dang it!

It was my first time being at an IACA conference. I was a lucky winner of one of their several scholarships. The scholarship is to get first time conference goers a chance to attend if your agency can’t/won’t afford it. It was quite the experience.

I enjoy networking and learning new things and this was a perfect opportunity. I met the other two scholarship recipients, and we hit it off well so we spent some time chatting and meeting up throughout the week.

I would love to attend future conferences but I am sure that my agency, a very small one, will not be funding my trip across the country on a yearly basis. I do already attend a great annual conference for my regional association MACA.

So, if you have the opportunity to, attend one of the conferences. If you would like to go but cannot get the funds from your agency, ask for their approval and then fill out the scholarship paperwork and hope you are selected. If not, try again the following year. You won’t regret it.

There were plenty of breakouts to choose from, great keynotes and some vendors to round out some of the training and learning opportunities that were made available. It was definitely difficult to choose which ones to attend.

“Everybody counts, or nobody counts.” –Harry Bosch


One thing I find we have today is an overabundance of connectivity. Remember in the old days when you needed to find out the meaning of a word that you would reach for a dictionary and look it up? Remember when you needed to do a presentation on a topic like an animal or country and you went to the library to find a few books and hit up an encyclopedia? Maybe a good old phone book to track down that person you liked in school to find them and work up the nerve to ask them out?

No? It’s just me?

Well, that’s how it used to be until the internet opened the world to so many more resources. With so many resources comes an overload of information. I find myself digging through website listings that Google spits out wondering how they are even keeping up.

That’s great Nick but what does that have to do with automation?

Let’s leverage that over-connectivity. You want to put out a piece of information for your community to consume, but the question is how do you do it so it does not eat up your entire day. I have found automation that is helpful in the quest of efficiency. The two that I have explored are IFTTT and Zapier. Zapier seems a bit limited in what they offer for free but they appear to be very well connected to numerous other apps and social media. IFTTT has much more usage allowance for their free tier but appear a bit limiting as to what the possibilities are across their connected apps and software but the most needed parts are free.

IFTTT can be leveraged by connecting your social media together and make it a one-post-pushed-to-all task. If you use multiple social media platforms to put out your message about scams or community safety or links to other helpful information, then this can make your time on social media much more efficient.

As a quick example, and once you link all of your social media accounts in IFTTT (let’s use the majors like Facebook, Instagram and Twitter), then you could set up automation where once you post something on your FB page, then it will automatically send an IG or tweet for you that then pushes the consumer to the more thorough FB posting. No matter where people follow you, they can gain access to the one repository of information. This allows you to post once with thorough info and have everyone drawn to it instead of figuring out how to craft one piece of information into numerous ways across a variety of platforms.

It can take some work in getting the recipe right in IFTTT, but it is worth it in the long run to reduce your time spent doing something else instead of something that is easy to automate across your social media platforms.

Good luck and remember, “Everybody counts or nobody counts.”

NIRO Crime Analysis

Access vs Excel

There is no contest.  Access wins.  Hands down.  But so does Excel.

Why?  Because they are two separate programs that handle data differently.  Access is a data management system and Excel performs data analysis.  They are different but live within a great dynamic since they are part of the same company.  Both can feed from each other well.

The UALE course allows the user to learn the use and application of Microsoft Access, which can be a little confusing and clunky to muddle through, but with direction it can be a perfect data management tool.  There are best practices that should be considered when putting together a database from inception to creation.  This is part of the course along with going through tables, queries, forms and reports.  Their setup, their usage and why they should be implemented or formatted a certain way.

UALE will give you the knowledge and skills to start leveraging Access as a database management tool and to get the information you need from your data.

Stay tuned as I have some future plans of adding more information and resources to the course.

NIRO Crime Analysis