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
[https://nam11.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqlserverbiblog.com&data=02%7C01%7C%7Cc2b9c1d9bc484034bce108d79d4982a9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637150811364928504&sdata=O8qoNQBEzC0A%2BvPlHsvXqxfCB6Z9tUBqJSye9xt488I%3D&reserved=0]
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_
culture
644
Views
29/02/2020 Last update