FBI Crime Data Explorer
For more info about Internet Explorer, see Internet Explorer help. Although Internet Explorer 11 comes already installed on Windows 10, if you accidentally deleted it, you can download and reinstall it by selecting one of the buttons below. The Environment Canada Data Explorer is a Windows-based application that provides a user-friendly interface to Environment Canada’s HYDAT Database.ECDE allows users to easily browse and extract hydrometric information right from their own desktop.
The interactive online Crime Data Explorer enables law enforcement and the general public to more easily use and understand the massive amounts crime data currently collected through the FBI's Uniform Crime Reporting (UCR) Program.
Video Download
Resources
Recent Video
- 10.08.2019— Wanted by the FBI: Jennifer Lea Settle Sought in Daughter McKenna Butcher’s Kidnapping
- 10.06.2019— Samuel Little Confession: North Little Rock, Arkansas, 1992/1993
- 10.06.2019— Samuel Little Confession: Las Vegas, Nevada, 1993
- 10.06.2019— Samuel Little Confession: New Orleans, Louisiana, 1982
- 10.06.2019— Samuel Little Confession: Miami, Florida, 1972
- 10.06.2019— Samuel Little Confession: Covington, Kentucky, 1984
- 09.26.2019— FBI Tools of the Trade: Riverine Craft (360-Degree Video)
- 09.21.2019— FBI San Diego Think Before You Post PSA
- 09.20.2019— Made in America
- 09.18.2019— My Dynamic Huntsville
- 09.18.2019— My Unique Huntsville
- 09.18.2019— Video Loop of The Killing Fields
- 09.18.2019— FBI Seeking Clues in Texas 'Killing Fields' Murders
- 09.13.2019— FBI Plea for 9/11 Responders to Register for Health Benefits (Social Media Version)
- 09.11.2019— Lori's Story: 9/11 Victim's Sister Recalls 'Very Reverent Moment'
- 09.10.2019— FBI Boston: Armed Robbery of Convenience Store in Dedham, Massachusetts
- 09.06.2019— 9/11 Memorial at Terrorist Screening Center
- 08.22.2019— Echoes of Columbine
- 08.16.2019— FBI Honors Intern Profile: Kendall, Information Management Division
- 08.16.2019— FBI Honors Intern Profile: Anne, Laboratory Division
FBI Weekly Newsletter
Subscribe to our email newsletter for news on the FBI, sent out every week.
Microsoft, some days ago released an add-in for Microsoft Excel called Data Explorer. The free add-in has been designed with the sole purpose for reducing your efforts in searching, shaping and preparing data. You might agree, getting your important personal/official data into analysis-ready format can become a task when using a spreadsheet hence, Data Explorer for Office Excel to overcome this hurdle. You can do it all, from reshaping to importing, filtering and grouping your data in a new ribbon tab interface.
Data Explorer for Office Excel
As mentioned, Data Explorer is a free add-in. What’s cool about Data Explorer is it can impressively handle a wide variety of formats such as CSV, HTML tables, Facebook and more. One can combine data from multiple, disparate data sources and then shape it in order to prepare the data for further analysis in tools like Excel and PowerPivot.
Data Explorer ably imports from multiple databases including MySQL, PostgreSQL, Oracle and IBM DB2 as well as Microsoft’s own SQL Server, Azure and Access too. After installing the add-in, you will see the new Data Explorer tab. Let’s start with the basics first!
The tab if you observe, houses various useful options under the ‘Get External Data’ section. Using this, you can either import any data from
- Web
- File
- Database
- Other sources
My interest lies in importing data from web so, I select the first option.
Simply enter the address of the website in the URl bar and hit Apply.
A query window activates, displaying tables found on the site. You can click one to see what the data looks like.
If required you can re-arrange the data (ascending /descending) order, transform, refresh the data in a single click based on the original data source and do lot more. Simply click on the drop-down arrow and choose the desired action.
Online Search Feature
One of the main highlights of the Data Explorer is its ‘Online Search’ feature. You can enter your query in the online search box and hit enter and get the results relevant to your query, displayed from popular websites like Wikipedia.
Another killer feature of Data Explorer is the ‘Merge’ option. Using this, one can merge or append from multiple sources. Also, you can build stunning visualization using Power View in Excel 2013.
The main Data Explorer Help page has links to various how-to tutorials. you can refer them for your better understanding: It ranges from simple to more complex tutorial that goes step by step through importing data from multiple sources, joining tables on common columns and grouping, sorting and filtering results.
You can download it from here and start exploring its features right away. It supports Microsoft Office 2013 and Office 2010 SP1.
Azure Data Lake Explorer Download
Internet Explorer 10 Download
Related Posts: