John White
CTO of tyGraph and Evangelist with AvePoint.
Guelph, Canada
John P White is the CTO of tyGraph and Evangelist at AvePoint. He holds a Master’s degree in Engineering from the University of Guelph and has been a Microsoft MVP since 2010 and a dual MVP since 2018 in both Microsoft Apps and Services and Data Platform. He has spent far too long (since 1990) in the Information Technology space, and possesses a skill set that spans both architecture and development. He has been instrumental in delivering projects and applications that have been recognized with both local and global awards from Microsoft and IBM.
John has accumulated a plethora of legacy technologies over the years like Novell, Lotus Notes and Java, and of course Microsoft technologies. This experience has proven invaluable when architecting systems. Over the past decade, he has been focused on the Microsoft collaborative and data platforms and is a frequent speaker on these topics.
He blogs as actively as possible at the White Pages and is the co-host of the weekly https://bifocal.show/ which covers the Microsoft business intelligence space. John lives in the country just outside of Guelph, Canada. He is the father of 3 boys, is an avid scuba diver, gardener, and photographer, both under and above the water (but mostly under).
Awards
Area of Expertise
Topics
Your guide to understanding Power BI
Struggling to understand what Power BI choices are the right ones to make? Confused by the licensing so much that trying to make heads or tails of how to get your project started is a step too far to think of taking? Join us for this introduction to the wonderful world of Power BI. We will begin with understanding the real world decisions around licensing, discuss & demo the options for doing reporting, and finish with dashboards & sharing.
If you are beginning your journey into the Power BI world, this is the session for you. We will set you up for success throughout the rest of the conference and help you look to drive your business using data.
What in the World is Azure Data Explorer and why should I care?
Telemetry data is exploding, and traditional transaction database management systems are simply not designed to for this type of data. Azure Data Explorer (ADX), or "Kusto" is a non-traditional, high-performance, big data analytics platform that makes it easy to analyze high volumes of data in near real time. ADX is the engine behind Azure Monitor and Log Analytics.
This session is an introduction to ADX for users that may be more familiar with traditional database systems, like SQL. It will cover the main features of ADX, where it is, and isn't appropriate, and how to get data in and out of it. After attending this session, you will know if ADX is a good choice for you.
There's No Time Like the Present - real time and low latency data in Power BI
Power BI has many options for keeping your data up to date, but what happens when scheduled refreshes simply aren't enough? What do you do when real time or near real time reporting on your data is necessary? Fortunately, Power BI has you covered here as well. From real-time datasets, to Direct Query and the Aggregations feature, there are more than a few options for accomplishing this goal, but they all do come with a few tradeoffs.
This demonstration laden session will examine all of the techniques available to Power BI for reporting on your data in real time, highlight some of the things to watch out for, and how to design for them. If you need your data more up to date than what refresh schedules can provide, then this session is for you.
Sharing PowerBI Reports with the World - 5 Things to Know
The Power BI Publish to Web feature is a powerful tool for sharing your reports with a wider audience. However, it brings with it a number of difficulties, challenges, and dangers. Before you use this capability, you should know when it is appropriate, what is possible, and how to design for it properly.
This session will explore what the Publish to web feature is all about, and how you can take advantage of it effectively, and most importantly… safely.
Power BI Premium – When Do I Need It?
Power BI Premium is a way to get past many limitations of the shared Power BI service. However, with great power comes great responsibility.
This session will outline exactly what Power BI Premium is, what features it unlocks and what limitations it changes. We will also call out situations where Premium may not be appropriate, and the steps that you need to take to ensure that you get the maximum value from it.
If you’re considering a move to Power BI Premium, you’ll want to attend this session.
Azure Monitor, Azure Data Explorer and Power BI, Oh My!
Log Analytics and Application Insights are increasingly becoming the storage mechanism of choice for telemetry data. At its core is Azure Data Explorer (ADX) or "Kusto", and the KQL language for analysis, which can also be used independently. Power BI is of course the standard for data analysis and reporting in the Microsoft ecosystem.
It's easy enough for Power BI to report on Log Analytics and ADX data, but the devil is in the details. When should you use native KQL Queries? When should you use Direct Query? What about Hybrid tables and aggregations? This session will dive deeply into the nuances of reporting on both Log Analytics and ADX data with Power BI.
Telling data stories with Power BI
Struggling to make your data tell the story that you know is hiding in there? Sick of staring at static spreadsheets and wishing that there was a way to visualize things so that the data could speak for itself? Are you tired of doing the same analytical motions over & over again instead of being able to use a repeatable process that will give you time back to do your actual job?
Welcome to the wonderful world of Power BI where all of these things are achievable. In this session you will learn powerful ways of making your data come to life using Power BI Desktop & the Power BI Service. Whether your data is stored in a Microsofty way in Excel, SQL Server, SharePoint Online lists, CSV files on some old file server, you will learn to unlock the data within & bring to life the stories hidden in the data.
6 Ways to Get Insights on your Microsoft 365 usage
What happened to the document? How did that get here? Is anybody reading this stuff?
You've gotten these questions - how hard was it to answer them? The information is all available, but the best route to the insight is not always obvious. In reality there are multiple ways to report on your usage, each with different strengths and weaknesses. This demo-rich session will highlight 6 different approached to retrieving and reporting on Microsoft 365 usage information.
5 Reasons you want Paginated Reports in your life
You're already familiar with Power BI and the Power BI Desktop PBIX files. These tools are great for analytical reporting, but when it comes to things like printing, and subscriptions, well, it falls a little short. That's where Paginated reports come in.
Paginated reports draw upon the decades of experience in operational reporting from SQL Server Reporting Services, but they work in the Power BI service, enabling many new scenarios and opportunities. This demo-rich session will explain what paginated reports are all about, and demonstrate 5 reasons that you'll want to start using paginated reports immediately.
Deep Dive on Power BI and SharePoint
This demo rich session will explore many of the nuances involved with using a combination of Power BI and SharePoint. SharePoint data can be finicky to retrieve, and this session will show examples and suggest a few best practices for doing so. In addition, connecting Power BI to SharePoint opens up a whole new world for Excel. If it can be done with Power BI and SharePoint, this session will show you how.
Everything you wanted to know about Power BI (but were afraid to ask!)
Monday, May 28 2018. 09am - 5pm CET.
Power BI is the gold standard for cloud based report delivery. It’s very approachable – you can get up and running with it in minutes, at the same time, it’s very robust, secure and extensible. As you might expect, it has many pieces and nuances, and it’s important to understand what is possible, even if you may not take immediate advantage of some features, in order to understand what to use when.
Join John White (MVP) and Jason Himmelstein (MVP) for this all-day tutorial which will help to guide you through building a complete analytical solution, using all the features of Power BI. We will start from nothing, and create queries that import and integrate data from many different sources. You will also learn how to refresh data using the on-premises data gateway and the personal gateway to connect to existing on-premises data from a variety of sources. In addition, you will see an overview of the many other additional features available in Power BI.
At the end of this seminar you will be ready to not only start using Power BI for your projects, but you will also understand which approach is best for different situations. Bring your questions, and we’ll do our best to answer them.
John White
CTO of tyGraph and Evangelist with AvePoint.
Guelph, Canada
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top