tag:blogger.com,1999:blog-2569772432953120875.post2017963589022346692..comments2024-02-22T19:45:29.872-05:00Comments on Sources And Methods: Introduction To Pivot Tables In Intelligence Analysis (Original Research)Kristan J. Wheatonhttp://www.blogger.com/profile/02566135545863154089noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2569772432953120875.post-52992770032142768172009-07-23T23:45:23.590-04:002009-07-23T23:45:23.590-04:00Thanks for these videos! New crime analysts will a...Thanks for these videos! New crime analysts will appreciate them. It would be great if your students could produce more like these... on various sorts of analytical techniques. Just basics would be great! When I was a crime analyst, pivot tables saved me much time and were my favorite tool of all. I didn't learn how to use them until halfway through my 10 years as an analysts, and they made me much more efficient and productive.Deborah Osbornehttps://www.blogger.com/profile/00559407566100557136noreply@blogger.comtag:blogger.com,1999:blog-2569772432953120875.post-8592096118649511682009-06-24T22:19:29.328-04:002009-06-24T22:19:29.328-04:00In the mid-90's (long before Pen-Link or THREA...In the mid-90's (long before Pen-Link or THREADS), pivot tables were a mainstay of telephone toll analysis. The raw call data was easily cut and paste into the spreadsheet and would allow me to see how many times any number called the target number(s). Even three years ago, while serving as a Military Intelligence Analyst in Afghanistan, we used pivot tables for various analysis. It's only limited by your imagination. Thank you for the great videos!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2569772432953120875.post-7995817466263318732009-05-30T10:15:10.067-04:002009-05-30T10:15:10.067-04:00Pivot tables play a "pivotal" role in some of the ...Pivot tables play a "pivotal" role in some of the data analysis I am doing at my internship. We are analyizing different incentives for our agents and determining who they favor, why, and how we can enhance the incentives to benefit all agents, not just the largest. Without the pivot table tool, much of my analysis would take a large amount of time to complete as the data pool i work with is enormous. However, with this tool, I can easily spot trends and anomalies in the data and create a comprehensive analysis in no time at all. Pivot tables allow me to do all this without compromising the integrity of or having to "massage" the data to find the information I need. I definitely agree that this tool is one of the most underutilized in Microsoft Office and that it has large benefits in the business intelligence realm in addition to the applications in law enforcement as demonstrated by the preceding videos. I can't wait to hear more on this topic!Coreyhttps://www.blogger.com/profile/09025714969565506362noreply@blogger.comtag:blogger.com,1999:blog-2569772432953120875.post-68155846872274176392009-05-29T23:53:01.337-04:002009-05-29T23:53:01.337-04:00Well done video, I can definitely see myself using...Well done video, I can definitely see myself using this.Anonymousnoreply@blogger.com