Query Folding and combining Google Forms with SSRS and Power BI

--- Description ---
This evening we'll first take a dive into query folding. This very important but often overlooked feature can make or break the data refresh for your reports. Nicky van Vroenhoven will guide us through the what, how and why of query folding.
Next up is Indira Bandari, speaker at SQL Saturday conferences and an impressive career of already 15 years in BI. She'll be guiding us through an innovative solution she build, combining Google Forms, SSRS and Power BI. This is a session that was also recently selected at a SQL Saturday, so really a must see!
Last but not least, as always, there's time for you to bring your own questions, issues, ideas to the group. You can already start a discussion in the comments and we'll facilitate you during the meetup.

--- Agenda ---
• 18:00 - 18:30 - Free food & drinks, sponsored by Ordina
• 18:30 - 19:15 - Query folding in Power BI
• 19:15 - 19:20 - Break
• 19:20 - 20:00 - (remote) Google Forms meet Power BI via Reporting Services (SSRS)
• 20:00 - ??:?? - Watch the World Cup match: France - Belgium

--- Session 1 ---

• Query folding in Power BI *

Power Query allows you to extract and transform data from a variety of data sources. Have you ever noticed that the importing of data is slower than you expected? In most of those cases, query folding is not happening. Query folding is very important because it offloads data transformations to the source instead of doing them in Power BI. Come learn how you can ensure you get all the performance improvements possible for your reports! As a bonus, you'll also learn when query folding is not your best friend.

Speaker: Nicky van Vroenhoven
(https://twitter.com/NickyvV)
(https://www.nickyvv.com)
Nicky van Vroenhoven is a BI professional focused at the Microsoft stack. He mainly works with SSIS, Biml, T-SQL development and Power BI. After working 8 years in several BI-consultancy jobs in many industries and companies, he is currently working as a Senior BI Developer at the DWH team at Van Lanschot Kempen. In addition he enjoys tweeting, and blogging on http://NickyvV.com about topics like Power BI, DAX and SQL Server in general.

--- Session 2 - Remote Speaker ---

• Google Forms meet Power BI via Reporting Services (SSRS)*

Are you interested in getting to know what your customers are thinking about your services? Empower your business with this end to end solution of creating feedback survey, sending and receving the responses and then finally analysing the same.

In this session I will show you how to
• Initiate customer feedback surveys using Google Forms.
• Send the survey emails to the database contacts through data driven subscriptions of Reporting
Services (SSRS)
• And finally analyse the customer feedback using Power BI

Speaker: Indira Bandari
(https://twitter.com/indupriya9)
(http://mytechlearning.blogspot.co.nz/)
Business Intelligence Consultant with over 15 years experience in designing and developing datawarehouses and analytical solutions. I have a Masters degree in Statistics and am passionate in learning data science. Volunteering and sharing my knowledge is my passion. I am a speaker at the local User Group and SQL Saturday sessions in New Zealand
In my pass time I teach game development for primary school kids.