Microsoft Power Query for Excel is an add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Power Query enables users to easily discover, combine, and refine data for better analysis in Excel. Power Query includes a public search feature that is currently intended for use in the United States only.
With Power Query, you can:
- 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.).
- Discover relevant data using the search capabilities within Excel.
- Combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in Excel and PowerPivot.
Speaker: Matthew B Rager
Location: Microsoft Technology Center, 200 E Randolph St. Suite 200 Chicago, IL 60601
Food will be served at 5:30 and the speaker will start by 6:00 PM.
Please note: Registration ends on Monday, July 15 at noon.