SQL Saturday Tampa Pre Con - Next Level Power BI Solutions

Paul Turley presents Next Level Power BI Solutions

Gimme an “M” …M. Gimme a “D-A-X”. What does that spell? Ummmm…

Click, drag, drop… getting started with Power BI is fairly easy but preparing for scale, increased data volume, a growing audience and unforeseen requirements takes planning and best-practice design. Learn Power Query “M” and DAX coding techniques that everyone must know to graduate beyond the basics. This session is above beginning level but is also not just for advanced users. We’ll discuss version control, team development, deployment, release management and supporting self-service users with certified data.

You will learn:

• Power Query best practice design

• “M” code essential concepts for building reference and lookup tables

• Parameter techniques to manage dataset size and incremental refresh

• Version control and revision management

• Data modeling patterns for efficiency and optimal performance

• DAX essentials and useful techniques

• Dynamic measures and visualization support

• Bookmarks and drillthrough report navigation

• Report and dashboard design recipes that will always work

• When and how to separate datasets from reports

• Shared and certified datasets

Paul Turley is a Business Intelligence Solution Architect and Principal Consultant for Pragmatic Works. He has been architecting and developing applications and business intelligence solutions for large and small businesses since 1992. He has developed custom database, BI and reporting solutions for many companies in all industries. His expertise includes project lifecycle management, database modeling and design using SQL Server since version 6.5, application development and user interface design using ASP.NET, and enterprise BI solutions using SQL Server Reporting Services, Integration Services and Analysis Services. He teaches, develops training courseware, speaks at industry conferences and has authored and co-authored several technical books published by Wrox Press, Packt and Microsoft Press.

He has been a Microsoft Certified Solution Developer (MCSD) since 1996 and maintains certifications in software architecture and development, database administration (MCDBA) and project management methodologies (MSF & IT Project+.) He holds the current MCTS and MCITP certifications for SQL Server BI.

Paul’s blog site is: www.sqlserverbiblog.com and may be contacted at paul@sqlserverbiblog.com. Paul has authored and co-authored several training courses and books including:

• Designing Reporting Services/SharePoint BI Solutions
• SQL Server Analysis Services 2012 Cube Cookbook
• SQL Server Reporting Services Recipes
• Professional SQL Server 2016 Reporting Services
• Beginning Transact-SQL for SQL Server 2005 and 2008
• Beginning SQL Server 2005 Administration