where is data analysis tool in excel 2010

One data modeling option within Data Explorer requires the PowerPivot add-on, which in Office 2013 is only available for Office Professional Plus, Office 365 ProPlus or Office 365 Enterprise (PowerPivot also works with Excel 2010). Especially if you're not already a user of other Microsoft analysis products, this may be an issue. For example, my Data Explorer help seemed to only show report formatting advice - font, background color and so on, not my top need when doing data work. There are common date reformats and easy data-type changes as well as pivot-table-style data groupings and filters.ĭrawbacks: Documentation is somewhat limited. In fact, you can even combine queries on a new data source. Data Explorer keeps track of your data-manipulation steps so you can undo back to a certain point or re-use a query with another data set(features enjoyed by users of OpenRefine, the open-source data-cleaning tool formerly known as Google Refine). You can join tables on a common column when importing data (update: that relationship needs to be defined elsewhere, such as SQL Server or PowerPivot), selecting just the columns you'd like to pull into your spreadsheet. You can search and replace, filter, query and re-shape the data before import, such as hiding some columns or 'promoting' some rows to headers.

Data Explorer, on the other hand, neatly lists the tables in a column to the left of your document for one-click import. While you can import HTML tables from 'regular' Excel without an add-on, I didn't always find that to be an elegant process.

It will import from multiple databases including MySQL, PostgreSQL, Oracle and IBM DB2 as well as Microsoft's own SQL Server, Azure and Access and is also designed to help shape 'semi-structured' plain text into a better format for analysis.Įnter a URL and Data Explorer will come back with a list of tables in the Web page select a table and the data will immediately import into Excel. What's cool: This plug-in handles an impressively large array of data formats such as HTML tables, CSV, XML, Hadoop, Active Directory and, yes, Facebook.

Where is data analysis tool in excel 2010