Miguel Llopis Program Manager Power BI Team Microsoft Corporation DBIB327 Why Power Query Agenda Whats New in Power Query Coming Soon to Power Query Challenges with Data acquisition ID: 556684
Download Presentation The PPT/PDF document "Microsoft Power Query for Excel: Discove..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1Slide2
Microsoft Power Query for Excel: Discover and Refine Your Data
Miguel LlopisProgram Manager Power BI Team – Microsoft Corporation
DBI-B327Slide3
Why
Power Query?
Agenda
What’s New in Power Query?
Coming Soon
to Power QuerySlide4
Challenges with Data acquisition
- Finding & Connecting
to data is too difficult
- Experiences for data connectivity are too fragmented- Data often needs to be
reshaped before consumption- Any shaping is one-off and not
repeatable- Combining data from multiple sources is difficult- Volume, Velocity & VarietySlide5
Powerful Self-Service BI with Excel 2013
Discover & Combine
Analyze & Model
Search and access internal & external data
Clean, transform, and shape data
Merge and combine data from multiple sources
Lightning fast analytics with xVelocity in-memory technology
Model relationships, custom measures, hierarchies, and KPI’s
Power Pivot
Visualize & Explore
Bring your data to life with interactive visualization
Explore data in new ways to discover hidden insights Slide6
Powerful Self-Service BI with Excel 2013
Discover & Combine
Analyze & Model
Search and access internal & external data
Clean, transform, and shape data
Merge and combine data from multiple sources
Lightning fast analytics with xVelocity in-memory technology
Model relationships, custom measures, hierarchies, and KPI’s
Visualize & Explore
Bring your data to life with interactive visualization
Explore data in new ways to discover hidden insights
Power ViewSlide7
Powerful Self-Service BI with Excel 2013
Discover & Combine
Analyze & Model
Search and access internal & external data
Clean, transform, and shape data
Merge and combine data from multiple sources
Lightning fast analytics with xVelocity in-memory technology
Model relationships, custom measures, hierarchies, and KPI’s
Visualize & Explore
Bring your data to life with interactive visualization
Explore data in new ways to discover hidden insights
Power MapSlide8
Powerful Self-Service BI with Excel 2013
Discover & Combine
Search and access internal & external data
Clean, transform, and shape data
Merge and combine data from multiple sources
Power Query
Analyze & Model
Lightning fast analytics with xVelocity in-memory technology
Model relationships, custom measures, hierarchies, and KPI’s
Visualize & Explore
Bring your data to life with interactive visualization
Explore data in new ways to discover hidden insights Slide9
Current State of the ArtSlide10
The Data tabSlide11
From AccessSlide12
From WebSlide13
From TextSlide14
From TextSlide15
From TextSlide16
From TextSlide17
From SQL ServerSlide18
From SQL ServerSlide19
From SQL ServerSlide20
The Other Data tabSlide21
Importing data into PowerPivotSlide22
Importing data into PowerPivotSlide23
Importing data into PowerPivotSlide24
Even more data sourcesSlide25
Even more data sourcesSlide26
And finally….Slide27
And finally….Slide28
And finally….Slide29
Why Power Query?
Discovery and connectivity to a
wide range of data sources
, including publicly available data of all sizes & shapes.
Highly interactive and intuitive experience for rapidly and iteratively building queries over
any data source, any size.
Consistency
of experience, and parity of query capabilities over all data sources.
Joins
across different data sources; ability to create custom views over data that can then be shared with
others in your organizationSlide30
DemoSlide31
Announcement
Power Query October Update released today!Slide32
New
Transformation: Use Headers as First Row
New
Column Name field in Merge Columns dialog
Quick Access Toolbar in Query Editor Ribbon
Warning for stale preview in new queries (previews older than 24 hours)Function Invocation from SearchPreserve Excel Number formats in the worksheet on query refreshWhat’s New in the PQ October UpdateCheck it out later today in the Power BI Blog: http://blogs.msdn.com/powerbi Slide33
Demo
Coming Soon to Power QuerySlide34
Breakout
SessionsDBI-B211: Interactive Data Visualization with Power View
DBI-B213: Deployment and Best Practices for Power BI for Office 365
DBI-B212:
Connecting SAP ERP and Microsoft BI Platform DBI-B222: Power BI for Office 365 Overview
DBI-B319: Improving Power Pivot Data Models for Microsoft Power BIRelated contentLabs
DBI-IL201:
Exploring the Microsoft Office 365 Power BI Site Slide35
27 Hands on Labs + 8 Instructor Led Labs in Hall 7
DBI Track resources
Free SQL Server 2014 Technical Overview e-book
microsoft.com/sqlserver
and
Amazon Kindle Store
Free online training at Microsoft Virtual Academy
microsoftvirtualacademy.com
Try new Azure data services previews!
Azure Machine Learning
,
DocumentDB
, and
Stream Analytics Slide36
Resources
Learning
Microsoft Certification & Training Resources
www.microsoft.com/learning
Developer Network
http
://developer.microsoft.com
TechNet
Resources for IT Professionals
http://microsoft.com/technet
Sessions on Demand
http://channel9.msdn.com/Events/TechEdSlide37
Please Complete An Evaluation FormYour input is important
!
TechEd Schedule Builder
CommNet
station
or PC
TechEd Mobile
app
Phone or Tablet
QR codeSlide38
Evaluate this sessionSlide39
© 2014 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.