Thank You for Attending in London

The Power BI World Tour offered in coordination with the local Power BI User Groups visited
London on 23-24 August at County Hall.

The tour stop allowed Power BI users to connect and dive deep with hundreds of peers and industry experts through twenty seven sessions targeted for the Business User, Business Analyst, Power User, or Techie. The event kicked off with a technical roadmap session led by Microsoft, offered a unique Microsoft track specializing in key announcements around Reporting and Analysis Services, served complementary tracks, and concluded with sessions reinforcing the information learned, exposing your new Power BI super power.

Read the London Recap blog.

Stay connected



Join the virtual London Power BI User Group community and continue the conversation and learning.

Visit Community

AGENDAS

Agenda is subject to change without notice.

Tracks below for Newbie/Business Users, Enterprise Business Intelligence Users, and Technical Users are just general guidelines based on interest and experience. An attendee may switch tracks or sit in on any class below at any time.

08:30 - 09:30Registration and Networking Breakfast
09:30 - 10:30General Session: Microsoft Roadmap | Room: County Suite
10:30 - 10:45Session Break (Refreshments)
10:45 - 11:45Essentials for Getting Started with Power BI| Room: Thames 2
Amy Nicholson - Microsoft (UK)
Power BI is a powerful tool that can be used by anyone at all levels of experience. In this session, we will cover the essentials: What is Power BI? What are some functions of Power BI? We will also answer your questions, and see Power BI in action.
12:00 - 13:00Networking Lunch
13:00 - 14:00Project Reporting, Resourcing & Risk Analysis with Power BI at King's College, London | Room: Thames 1
Tony McAndrew - Head of PMO - King's College London
This presentation shows an example of how, with deep domain knowledge, end users can develop and evolve visualizations of the data to meet operational and reporting needs - actively driving better data quality and taking us beyond the "tipping point" - making the maintenance of project status and data worthwhile to the individuals involved.
14:00 - 14:15Session Break
14:15 - 15:15Power BI for Program Managers | Room: Thames 1
Stuart Box - Director & Lead Trainer - Burningsuit Ltd.
This session will present strategies for getting your users on-side with Power BI, enabling them to use Data and Templates created for them, and managing access to data provided as Power BI data models. If you are leading the charge to Power BI within your organization, this session will help you understand how to roll it out to your end users, and what education and support they will need.
15:15 - 15:30Session Break (Refreshments)
15:30 - 16:30Tips and Tricks for Creating Beautiful Reports in Power BI Desktop | Room: Westminster
Will Thompson - Senior Program Manager - Microsoft
Engaging your audience and presenting rich visuals always helps convey the message in your data. Join this session to learn principles, best practices, hints, tips, and hacks to get the most out of your Power BI Desktop reports.
16:30 - 18:00Welcome Reception (Social & Networking)
07:30 - 08:30Networking Breakfast
08:30 - 09:30Sports Analytics - Lionel Messi | Room: Westminster
Tristan Malherbe - Data and BI Consultant - AZEO
This presentation will explain a Power BI dashboard on the football player Lionel Messi. We will be in the eyes of an analyst who wants to get actionable insights from data. The following topics will be covered: Data import & cleansing, Power Query functions, building a data model, analyzing the data with DAX measures, creating user-friendly dashboards. As well as some Power BI tips & tricks.
09:30 - 9:45Session Break (Refreshments)
9:45 - 10:45Build Your First Power BI Dashboard in an Hour | Room: Thames 2
Andrew Fryer- Microsoft (UK)
Power BI can help you uncover insights in your data and prepare reports that help tell the story. In this session you’ll see some examples that will help you be able to produce rich, interactive visualizations that help you find relationships, trends and more in your data.
10:45 - 11:00Session Break
11:00 - 12:00Visualizing & Drilling into Crime Hotspots in the UK | Room: Thames 1
Ben Howard - Consultant - Applepark Ltd.
This presentation will take data from the UK police service and merge it with other geographic data to display regional crime hotspots. Then we will merge it with house price data, and decide if any correlations can be made between the two data sets. This will be an interactive session, demo led, where we will drill into a relevant location by asking the audience for one or more UK postcodes to review.
12:00 - 13:00Networking/Lunch N' Learn - 30-min Sponsor Showcase Session: Get Even More from Power BI with ZAP’s Automated Data Management | Room: Westminster
David Rawling & Timothy Percival - ZAP
Increase trust in your business information and remove inefficiencies and costs related to data preparation and exploration. See how ZAP unifies data from multiple sources automatically and makes it simple to prepare for analysis with Power BI. ZAP’s warehouse automation makes it quicker and more cost-effective to produce a secure, governed hub of business-wide data, which enables richer, more trusted business information to be created more efficiently by Power BI users.
12:00 - 13:00Networking/Lunch N' Learn - 30-min Sponsor Showcase Session: Using Power BI & Excel for Financial Reporting | Room: Thames 1
John Mcneilly - Canarby ERP
• Creating Measures from your Financial System
• Sorting - Getting Lines in right order
• Using Outline to Expand and contract your report
12:00 - 13:00Networking/Lunch N' Learn - 30-min Sponsor Showcase Session | Room: Thames 2
13:00 - 13:15 Session Break
13:15 - 14:15 On-premises Power BI with Power BI Premium and/or Power BI Report Server | Room: Westminster
Prathy Kamasani - MVP & Independent MSBI Contractor
Learn what options are available for On-Premises report publishing. How Power BI Report Server is different from existing SQL Server Reporting Services (SSRS), licensing, benefits of Power BI report server and how to quickly create and deploy Power BI report server to SQL Server Reporting Services Portal / Power BI Report Server portal.
14:15 - 14:30Session Break (Refreshments)
14:30 - 16:00Use What You Learned | Room: Thames 2
If today was a whirlwind of new Power BI knowledge, this session is for you. During the session, we will learn to apply the concepts and methodologies of Power BI, such as visuals, into your real business scenarios to ensure that you walk away from Power BI Thursday with a sound understanding of how Power BI can work for you.

Business Enterprise Intelligence Users

08:30 - 09:30Registration and Networking Breakfast
09:30 - 10:30General Session: Microsoft Roadmap | Room: County Suite
10:30 - 10:45Session Break (Refreshments)
10:45 - 11:45Super Charge Power BI and What is new with Analysis Services | Room: Thames 1
Alejandro Leguizamo - Altius
Analysis Services is an amazingly powerful Business Intelligence tool that enables Power BI scale to global proportions. The latest enhancement was an offering this service from Azure. This session will take a look at what is new and get a deep dive to how you can scale up a Power BI model by migrating it to Azure Analysis Services. This new service enables larger models and allows fine grained control of refresh behavior. We will cover migration, using the gateway for on-premises data, and new connectivity with Power Query and the M Engine for Power BI compatibility and reuse.
12:00 - 13:00Networking Lunch
13:00 - 14:00Go Jump In A Lake | Room: Westminster
Andrew Fryer- Microsoft (UK)
Azure Data Lake is Microsoft approach to big data analytics at petabyte scale. Data Lake has been in use for some time inside Microsoft as the engine behind Bing and MSN, but has only recently been put into preview for public use. The best way to understand what it does is to see how it works in action and so that is what we’ll do rather than use too many slides. So if you’re interested in doing big data rather than spending time spinning up clusters, and managing them you might find this interesting.
14:00 - 14:15Session Break
14:15 - 15:15Power BI Report Server: Self-Service BI and Enterprise Reporting On-Premises | Room: Thames 2
Alejandro Leguizamo - Altius
Love Power BI but need an on-premises solution today? Meet Power BI Report Server -- self-service analytics and enterprise reporting, all in one on-premises solution. Design beautiful, interactive reports in Power BI Desktop, publish them to Power BI Report Server, and view and interact with them in your web browser or the Power BI app on your phone. And since Power BI Report Server includes the proven enterprise reporting capabilities of SQL Server Reporting Services, it can even run your existing Reporting Services reports too. Join us for an overview of Power BI Report Server and demos of its features in action.
15:15 - 15:30Session Break (Refreshments)
15:30 - 16:30Data Management will be Critical for High Performing Businesses of all Sizes | Room: Thames 1
Salam Al-Mosawi & David Rawling - ZAPMore and more data is being generated by businesses of all sizes. IDC research suggests that data doubles every two years and will reach 40 trillion gigabytes by 2020. With this amount of data comes great opportunity, but also potential issues. It is important that businesses of all sizes consider their approach to data management. Not just how they capture and analyze it, but how they manage (integrate, model, etc.) and govern it to ensure it is accurate, secure and accessible. Join this session to find out what you should be considering in terms of the best-practice approaches to managing data to ensure you seize the opportunity it presents and negate the potential issues it can create.
16:30 - 18:00Welcome Reception (Social & Networking)
07:30 - 08:30Networking Breakfast
08:30 - 09:30A Gentle Introduction to Text Analytics | Room: Thames 1
Mark Wilcock - Independent Consultant - Zomalex Ltd.
Mark Wilcock - Independent Consultant - Zomalex Ltd. The analysis of text documents is rapidly growing in importance and not just of social media (tweets, reviews) but also for legal, academic and financial documents. We'll look at the basics of text mining; frequency analysis, finding words and phrases specific to one or a few documents in a collection, and topic modelling. We'll analyze a few documents, then visualize the results. We'll use a variety of tools; R, text analytics web services and Power BI.
09:30 - 9:45Session Break (Refreshments)
9:45 - 10:45Deep Dive on Analytics Challenge Submission | Room: Thames 1
Rishi Sapra - Senior Consultant - Altius
In this session Rishi will run through how he built a winning entry for the Power BI Data Analytics Challenge 2017 - a report on historic visitor numbers to Hawaii based on a series of messy Excel files. As well as the technical implementation (e.g. using M and DAX), Rishi will focus on the conceptual design and story-telling elements of building a Power BI Report which are crucial to ensuring business engagement/adoption.
10:45 - 11:00Session Break
11:00 - 12:00Azure Machine Learning | Room: Westminster
Liam Howlett - Data Platform Technology Solutions Professional - Microsoft (UK)
The ability to analyze historic data in Power BI is incredibly intuitive and supportive, but in this session, we’ll see how we can integrate predictive analytics from Azure Machine Learning into our reports and dashboards to help give us an insight into what will be.
12:00 - 13:00Networking/Lunch N' Learn - 30-min Sponsor Showcase Session: Get Even More from Power BI with ZAP’s Automated Data Management | Room: Westminster
David Rawling & Timothy Percival - ZAP
Increase trust in your business information and remove inefficiencies and costs related to data preparation and exploration. See how ZAP unifies data from multiple sources automatically and makes it simple to prepare for analysis with Power BI. ZAP’s warehouse automation makes it quicker and more cost-effective to produce a secure, governed hub of business-wide data, which enables richer, more trusted business information to be created more efficiently by Power BI users.
12:00 - 13:00Networking/Lunch N' Learn - 30-min Sponsor Showcase Session: Using Power BI & Excel for Financial Reporting | Room: Thames 1
John Mcneilly - Canarby ERP
• Creating Measures from your Financial System
• Sorting - Getting Lines in right order
• Using Outline to Expand and contract your report
12:00 - 13:00Networking/Lunch N' Learn - 30-min Sponsor Showcase Session | Room: Thames 2
13:00 - 13:15 Session Break
13:15 - 14:15 Popular Financial Visualizations in Power BI | Room: Thames 2
Mark Wilcock - Independent Consultant - Zomalex Ltd.
14:15 - 14:30Session Break (Refreshments)
14:30 - 16:00Certification Opportunity | Room: Thames 1
Jen Stirrup, Data Relish
Ready yourself for Microsoft Exam 778 with this preparatory readiness class that will include a review of exam coverage, vital ways to prepare and additional details.
08:30 - 09:30Registration and Networking Breakfast
09:30 - 10:30General Session: Microsoft Roadmap | Room: County Suite
10:30 - 10:45Session Break (Refreshments)
10:45 - 11:45DAX 50 | Room: Westminster
Will Thompson - Senior Program Manager - Microsoft
This session is a real primer for the basic concepts to write simple DAX expressions. With lots of practical examples you will come away with an appreciate of the building blocks to create common DAX measures. You will also see some of the features of Power BI Desktop that make creating measures easier than ever.
12:00 - 13:00Networking Lunch
13:00 - 14:00IoT Streaming Dashboards in Power BI | Room: Thames 2
David Moss - MVP & Power BI Solutions & Azure Consultant - Wottabyte
The Internet of Things (IoT) has already connected billions of devices and machines and is here to stay. Learn how to ingest real time IoT streaming data and integrate device to cloud solutions with the Azure IoT Hub and Cortana Intelligence Suite tools with hot downstream Azure Streaming Analytics sinking data for visualization in Power BI real time IoT dashboards.
14:00 - 14:15Session Break
14:15 - 15:15Open Source Cybersecurity with Power BI | Room: Westminster
Jen Stirrup - MVP & Principal Director - Data Relish, Ltd.
This session will examine some of the metrics involved in cybersecurity, and visualize them using Power BI according to best practice principles for data visualization.
15:15 - 15:30Session Break (Refreshments)
15:30 - 16:30R for Absolute Beginners | Room: Thames 2
Mark Wilcock - Independent Consultant - Zomalex Ltd.
R is to Power BI as a hand is to a glove. You can use an R Script to source data, or transform it in the Query Editor or build that perfect visual. This session is for absolute beginners to R with practical advice and straight-forward examples to help you get started with R and use it to good effect in Power BI.
16:30 - 18:00Welcome Reception (Social & Networking)
07:30 - 08:30Networking Breakfast
08:30 - 09:30Power Apps & Flow with Power BI | Room: Thames 2
Liam Howlett - Data Platform Technology Solutions Professional - Microsoft (UK)
Power BI democratizes analytics by allowing anyone to create their own insights. Similarly, Microsoft have democratized application development by introducing Powerapps. This session will show you how you can create bespoke applications that you can write into and then use Power BI to read and analyze the data produced from your own application.
09:30 - 9:45Session Break (Refreshments)
9:45 - 10:45Power Query in Action | Room: Westminster
Tristan Malherbe - Data and BI Consultant - AZEO
This session will cover in detail the richness of Power Query User Interface & functions through concrete examples. Features include robust data cleansing (unpivot, transpose), combining & appending multiple tables, leveraging functions and parameters.
10:45 - 11:00Session Break
11:00 - 12:00Governance and Deployment Approaches | Room: Thames 2
Anu Suthakaran - Microsoft
12:00 - 13:00Networking/Lunch N' Learn - 30-min Sponsor Showcase Session: Get Even More from Power BI with ZAP’s Automated Data Management | Room: Westminster
David Rawling & Timothy Percival - ZAP
Increase trust in your business information and remove inefficiencies and costs related to data preparation and exploration. See how ZAP unifies data from multiple sources automatically and makes it simple to prepare for analysis with Power BI. ZAP’s warehouse automation makes it quicker and more cost-effective to produce a secure, governed hub of business-wide data, which enables richer, more trusted business information to be created more efficiently by Power BI users.
12:00 - 13:00Networking/Lunch N' Learn - 30-min Sponsor Showcase Session: Using Power BI & Excel for Financial Reporting | Room: Thames 1
John Mcneilly - Canarby ERP
• Creating Measures from your Financial System
• Sorting - Getting Lines in right order
• Using Outline to Expand and contract your report
12:00 - 13:00Networking/Lunch N' Learn - 30-min Sponsor Showcase Session | Room: Thames 2
13:00 - 13:15 Session Break
13:15 - 14:15 An Introduction to Big Data Processing Using Spark and Power BI | Room: Thames 1
Michael Robson - Microsoft (UK)
Join us as we provide a basic introduction to building Spark processing pipelines using HDInsight and Power BI. The session will take a simple use case and demonstrate and discuss an end-to-end architecture from ingestion to visualisation.
14:15 - 14:30Session Break (Refreshments)
14:30 - 16:00Ask The Experts | Room: Westminster
During this session ask the Microsoft team, MVPs, and Industry Experts the questions that you didn't get answered during the regular sessions. This session is always jam packed with information and tidbits from the brightest and the best.

Agenda Icon Legend

  • Registration
  • General Session
  • Session Break
  • Refreshments
  • Newbie/Business User
  • Enterprise Business Intelligence
  • Technical
  • Lunch/Dinner

Thank You to Our London Sponsors

Carnaby-logo.png
Making the complex simple - Independent software provider working in partnership with our clients to deliver even the most challenging projects on time and on budget.

ZAP-Logo.png

Helping Customers get a single, trusted view of their Business. We help hundreds of customers around the world get a single, trusted view of their operational and financial business performance in a simple, cost-effective way. Our aim is to remove the technical effort associated with traditional business intelligence and data warehouse projects. All ZAP solutions are pre-packaged, automated, and easily configurable. The result is faster deployment, quicker time-to-value, and reduced cost and risk for our customers.