So, may as well dive into it & tame the beast. Here are 5 excel Add Ins that every data scientist should install. Microsoft Power Query for Excel, is a new add-in that provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users. Identify the data you care about from the sources you work with (e.g. relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS, etc.).ĭiscover relevant data from inside(*) and outside your organization using the search capabilities within Excel.Ĭombine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in tools like Excel and Power Pivot, or visualization in tools like Power View and Power Map. Share the queries that you created with others within your organization, so they can be easily found via Search.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |