Midlands SQL Server User Group, BI Masterclass with two of the best - Location TBC
Session 1: Chris Webb - Everything you wanted to know about Power BI but were too afraid to ask
Session 2: Andy Leonard - Using Biml as an SSIS Design Patterns Engine
6.15pm – 6:30pm Meet & Greet
6:30pm - 7:30pm Chris Webb - Everything you wanted to know about Power BI but were too afraid to ask
You’ve probably seen a lot of Power BI demos and been wowed by 3D maps, cool dashboards and tales of working with millions of rows of data in Excel. But do you actually know what Power BI is? Where does Office 365 fit in? Does your data have to be stored in the cloud? Which versions of Excel do you need? How does it compare to corporate BI tools like Reporting Services and Analysis Services? This session will answer all of these questions and more, and help you understand whether Power BI is right for you.
7:30pm - 8:00pm Break & Food
8:00pm – 9:00pm Andy Leonard - Using Biml as an SSIS Design Patterns Engine
Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the benefits of BIML in this session. What are the benefits of Biml? Code re-use, automated code-generation from templates, faster delivery, higher quality.
We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know.
If you need any further details or have any requests for this or future Midlands SSUG events, please let me (Alex Whittles) know, either on Twitter (@PurpleFrogSys or @SQLMidlands) or email SSUG@PurpleFrogSystems.com
Chris Webb is an independent consultant and trainer based in the UK. He has over fifteen years' experience with the Microsoft BI stack and has worked in a variety of roles across a wide range of industries. A regular speaker at user groups and conferences around the world, such as the PASS Summit and the PASS Business Analytics Conference, he also is one of the organizers of the SQLBits conference and has received Microsoft's Most Valuable Professional (MVP) award for nine years running. He is the co-author of several books such as "MDX Solutions", "Expert Cube Development with SQL Server Analysis Services", "SQL Server Analysis Services 2012: The BISM Tabular Model" and “Power Query for Power BI and Excel” and blogs about Microsoft BI at http://cwebbbi.wordpress.com. More information about his consultancy can be found at http://www.crossjoin.co.uk and his training courses at http://www.technitrain.com.
Andy Leonard is Chief Servant Officer of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012.