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, but it’s also 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.

This tutorial will help to guide you in 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 the many other additional features available in Power BI.

At the end of this workshop 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.

Level: Experienced

BI 104 – Business Intelligence – Does SharePoint Matter Anymore?

John White, MVP – Featured Speaker

SharePoint has long been Microsoft’s platform for the delivery of Business and for dashboards on premises. Power BI on the other hand has emerged as the pre-eminent BI platform in the cloud. The release of SQL Server 2016 contains a vastly updated Reporting Services, which is Microsoft’s stated platform for the delivery of reports on-premises, and SSRS Integrated mode is going away. Excel Services has moved away from SharePoint and into Office Online Server. So what role does SharePoint now play for BI? As always, it is an excellent integrating and dashboarding platform.

This session explores all of the ways that SharePoint, Power BI, Reporting Services and Office Online Server work together, both on-premises and in the cloud. Learn how to bring your Power BI reports to your SharePoint users quickly and efficiently, and learn how to report on your SharePoint data using Power BI. We will tie it all together.