1 / 8

Big Data Analytics Module 1 – Data Mash-Ups with Power Query and PowerPivot

Big Data Analytics Module 1 – Data Mash-Ups with Power Query and PowerPivot. Saptak Sen, Microsoft Bill Ramos, Advaiya. Agenda. Power Query Excel Add-in Excel PowerPivot Add-in Demos. Power Query. Find and connect data across a wide variety of sources

skyler
Download Presentation

Big Data Analytics Module 1 – Data Mash-Ups with Power Query and PowerPivot

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Big Data AnalyticsModule 1 – Data Mash-Ups with Power Query and PowerPivot Saptak Sen, Microsoft Bill Ramos, Advaiya

  2. Agenda • Power Query Excel Add-in • Excel PowerPivot Add-in • Demos

  3. Power Query Find and connect data across a wide variety of sources Cleanse and merge data to prepare it for enhanced analysis

  4. PowerPivot– Embedded Analytics • PowerPivot • Flash Fill • Data Model Add and integrate large amounts of data in Excel workbooks In-memory data model • Power View • Quick Analysis • Quick Explore

  5. Demo 1: Big Data Mash-Ups Batch Layer Speed Layer Serving Layer Microsoft Excel PowerPivot Flat files (.txt, .dat, .xlsx, etc.) Microsoft Excel Hive ODBC Connection PowerPivot for Excel Windows Azure Marketplace HTTP/HTTPS Connection

  6. Learn more • PowerPivot for Excel http://msdn.microsoft.com/en-us/library/7b70845c-ad05-40e4-b41a-f8215a70298c • Power Query http://blogs.msdn.com/b/dataexplorer/

  7. Questions?

More Related