Midlands SQL Server User Group, BI Masterclass with two of the best!
NEW Location: MAC Birmingham, Cannon Hill Park, B12 9QH. Opposite Edgbaston Cricket Ground.
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
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
7:30pm - 8:00pm Break & Food
8:00pm – 9:00pm Andy Leonard - Using Biml as an SSIS Design Patterns Engine
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're trying out a new venue again! This time we'll be at the Midlands Art Centre (MAC Birmingham), Cannon Hill Park, B12 9QH.
It's directly opposite Edgebaston Cricket Ground in Birmingham
Parking: Lots or free parking, entrance is via Queens Ride, opposite the cricket ground
Public Transport: It's about 2 miles from New Street Station. Short taxi ride, or buses 1, 35, 45, 47, 62 & 63.
Room: When you get there, we're in the 'Pencent Masons 2' room. On the 1st floor, above the main entrance.
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
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.
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