Every Friday it was the exact same thing. Log into DTMS, gather the data, redo calculations, and then plug answers into PowerPoint slides for the next Training Meeting. Initially this would take me around 2 hours to do, but eventually I got it down to 1 hour. What if I told you that you could do this in 5 min? Not only that, you could take the same information and with a couple clicks format it to your Company Training Meeting. Your saving grace is the PIVOT table.
PIVOT Tables are a tool in Excel that allow you to quickly analyze your data sets and make decisions off of them. I've included a YouTube example video (see below) working with weapons qualification data from DTMS. What I love most about PIVOT Tables are that once you make a PIVOT Table, you can can updated reports simply by pasting in new sets of raw data. Essentially all you have to do is set up your metrics once and you will always have your results at the push of a button. This will save Commanders/Staff Members/ Training rooms ridiculous amounts of time, allow you to streamline processes, and free up time to focus on more important things..
For more information, here's a link to a quick and easy tutorial: http://www.excel-easy.com/data-analysis/pivot-tables.html . If you've signed up for Lynda, I highly recommend taking their PIVOT Table courses. They will expand your skills so much more.
If you have thoughts on the article you just read, please leave some comments for the group. If you’d like to continue following this blog, sign up for our newsletter or add our RSS Feed to your Feedly account to know when new content is posted .
I've heard many Army Officers get out, get an MBA, and do great things drawing on their experiences in the military. I'm trying to do something a little different. I'm going to earn an MBA, come back to the Army, and do great things for it by drawing on my experiences with the MBA program.
My name is Captain Dan Wagner. I'm an active duty Army Officer and a current student at the Leeds School of Business at the University of Colorado Boulder. I started this program last year right after leaving command at Fort Bliss, Texas. While working on my MBA, I have had a lot of time to reflect on things I did will well and things I failed at. I've also been introduced to multiple new systems and ways of doing things that truly opened my mind. I shared my initial insights with my former Lieutenants to ensure the knowledge could be passed off quickly. However I didn't feel this was good enough. Inspired by various Professional Military Facebook groups, my former Brigade Commander's blog, and empowered by my Digital Marketing class I decided to start my own blog. My hope with this blog is to create a forum where we can share ideas how to make the day to day, extremely unsexy, processes of the Army better and hopefully make many lives a lot less stressful. We all have unique points of view and experiences- I have been very fortunate to have my own and hope they provide some value to you.