SQLSaturday Orlando 564 - Playing With Power! - David Pless
PLAYING WITH POWER: Harnessing the Reporting Capabilities in SQL Server 2016 and Power BI
Prepare for a deep examination of the reporting capabilities in SQL Server 2016 on Enterprise Reporting with Reporting Services, Mobile Reporting in a BYOD world, and finally self service business intelligence with Power BI.
This will be a great addition to an already great discussion on SQL Server 2016 engine improvements. SQL Server 2016 is packed with new capabilities with SQL Server Reporting Services and self-service reporting with Power BI.
We will outline the new features and capabilities of SQL Server 2016 Reporting Services that puts the power of data in the hands of everyone. We will cover the alignment of Microsoft’s cloud and on-premises reporting solutions. We will cover how existing SSRS and PowerBI expertise will transfer across these deployment modalities so you can mix and match on-premises and cloud components, and benefit from unique hybrid scenarios. We will cover paginated reporting, interactive reporting, mobile reporting, KPIs, dashboards, and analytical charting. We will focus on the new capabilities of mobile reporting with the ‘Mobile Report Publisher’ and web based reporting which allows for greater consumption of your report capabilities across the enterprise.
We will cover the new visualizations across the reporting experience and how you can pin report visualizations to a Power BI dashboard and other methods in hybrid-connected reporting. We will cover new capabilities of Power BI embedded for application development. This further allows you to leverage your existing reporting investments in SQL Server Reporting Services and application solutions. Finally, we will cover visualizing and operationalizing data in Power BI with R scripting.
Objectives: In this session we will accomplish the following:
Learn the full capabilities of SQL Server 2016 Reporting Services
Understand the capabilities with a hybrid Power BI solution
Realize the ability of leveraging Microsoft Office with hybrid report solutions
dUnderstand R scripting and embedded report solutions with Power BI
Using SQL Server Reporting Services and Power BI to show how Power BI and R Scripting can be used to prove ‘Moneyball’, The story of how the Oakland A’s were able to use applied data science to win!
Speaker Bio: David Pless is a Technical Solutions Professional at Microsoft Corporation and has been an engineer for the past nine years specializing in SQL Server performance tuning and optimization, Azure Technologies, Power BI and SQL Server Reporting Services, and High Availability solutions. At Microsoft David has worked as a TSP as well as a Premier Field Engineer in CSS. At Microsoft, PFEs teach workshops, conduct performance reviews, complete health checks, and work to resolve reactive cases anywhere in the world.
Before Microsoft, David Pless was a MCS partner consultant with Intellinet and a Database Administrator at CheckFree Corporation in Norcross, Georgia. David is also a Microsoft Certified Master (MCM) and has spoken a SQLSaturdays, SQLPASS, SQLintersection, Tech Ready, and regularly speaks at the local user groups in Florida.
08:00 AM - 08:30 AM - Check In
08:30 AM - 12:30 PM - Seminar Training
12:30 PM - 01:30 PM - Lunch and Networking
01:30 PM - 04:30 PM - Seminar Training