sqlsaturday rheinland 2014 - power query vs. ssis
DESCRIPTION
Is Power Query as powerful as SSIS ? That session will show all the capabilities of Power Query to manipulate data and compare it to SSIS. Warning M-code inside. 100% demosTRANSCRIPT
Power Query vs. SSIS
Which one is the most powerful ?
SQLSaturday Rheinland 201428.06.2014
SQLSaturday Rheinland 2014
Organizer
28.06.2014
SQLSaturday Rheinland 2014
You Rock! Sponsor
28.06.2014
SQLSaturday Rheinland 2014
Gold Sponsor
28.06.2014
SQLSaturday Rheinland 2014
Silver Sponsor
28.06.2014
SQLSaturday Rheinland 2014
Bronze Sponsor and Media Partner
28.06.2014
The SQL Server community (in France)
Webcasts, Conférences, Afterworks
.Pro
Next event : SQLSaturday Paris 2014September 13thTour Montparnasse, Paris
Jean-Pierre RiehlPractice Manager Data & BI – AZEO
MVP SQL ServerPresident at GUSS
David JoubertSenior BI Consultant - CellenzaMVP SQL ServerVP at GUSS
Who we are ?
SSIS
Champion
Power Query Champion
SQLSaturday Rheinland 2014
Disclaimer
This session is an informal comparison between tools
This session isn’t : An exhaustive comparison A “how-to” or a “Best Practices” session
Each of us will be proud of his tool So, we will be dishonest
28.06.2014
SQLSaturday Rheinland 2014
Disclaimer
http://www.youtube.com/watch?v=DSFXTrMzg58
28.06.2014
SQLSaturday Rheinland 2014
Let’s Go !
28.06.2014
demo
Summary
SSIS Power Query
Application Logic OK KO
Data Sources OK OK
Transformation OK OK
Destinations OK KO
Execution OK KO
Winner SSIS
SQLSaturday Rheinland 2014
But…
28.06.2014
SSIS Power Query
Extensibility OK KO
Easiness / Learning KO OK
Real-time / WYSYWIG KO OK
Performances OK KO
Collaboration KO OK
Winner Power Query
SQLSaturday Rheinland 2014
A matter of Philosophy
SSIS : « aimed to industrialize data integration focusing on development and scalability »
Power Query : « aimed to help end users to create and share easily self-service ETL »
28.06.2014
Business User• Document centric• Exploration• Real-time, WYSYWYG• Easy to learn• Collaborative
Developer• IDE / Source Control• Extensibility• Fine tuning• Automation
SQLSaturday Rheinland 2014
Thank you!for sponsorshipfor volunteeringfor participation
for a great SQLSaturday #313
28.06.2014