NASIC Airman’s Power BI solution

  • Published
  • By By: Staff Sgt. Samuel Earick
  • National Air and Space Intelligence Center
WRIGHT-PATTERSON AIR FORCE BASE, Ohio --  A new data tool created by a National Air and Space Intelligence Center Airman is projected to save the Center approximately 2,800 man-hours annually by streamlining training reports.

Tech. Sgt. Jared Schweitzer, a NASIC training manager, developed the solution after participating in a Department of War "Power BI for All" event held from Dec. 1-12, 2025.

The event featured a three-week course in which participants learned the software's foundations, advanced analytics and in-production impact. It concluded with a showcase where students presented projects designed to improve processes and support mission outcomes.

“My Power BI project consolidates training reports from multiple sources into a centralized '1-Stop Shop' for tracking,” Schweitzer said. “Previously, our team spent countless hours compiling and filtering endless Excel spreadsheets to report on training completion.”

Schweitzer’s project was one of 36 solutions selected from nearly 100 submissions for a live presentation.

“Schweitzer’s product was simple and easy to follow in the best way possible,” said Daniel McBride, an Air Force Life Cycle Management Center contractor supporting the Enterprise IT and Cyber Infrastructure Division. “We were impressed how the solution was leveraged by all levels of the organization, providing impact in an efficient manner.”

Following the showcase, members from across the DoW reached out to Schweitzer to collaborate and learn how to build their own solutions.

“I've started by sharing my dashboard and conducting virtual, screen-share sessions to explain the development process,” Schweitzer said. “Currently, I am working with NASIC’s Future Capabilities and Assessments Directorate to create a simple method for sharing our foundational data, which will allow other units to easily adapt it.”

For Schweitzer, the motivation behind the project goes beyond fixing a process; it's about empowering others to create their own solutions.

“I want this project to be an example for anyone who feels frustrated with the tools we're given. I used to be that person,” he said. “I decided to change my mindset and put in the effort to learn and create something better. The doors are always there; you just have to be willing to walk through them. No idea is a bad idea, and your idea could be the next big change.”