Mastering Power BI Solutions - Beyond the Basics

In this Power BI hands-on Workshop, we will quickly review the essentials and learn some advanced techniques to transform, model and analyze business information with Power BI Desktop. Techniques and best practices presented are from several prior workshops and years of field experience. Learn to use self-service and enterprise-scale Power BI capabilities; gain valuable skills to integrate, wrangle, shape and visualize data for analysis.

If you’re just getting started, please pick-up a good book or use online resources to familiarize yourself with Power BI Desktop so you can take your skills to an intermediate level. If you have the basics, be prepared to take your skills to the next level; learn to address data and reporting challenges with advanced design techniques. At the conclusion of the workshop, you will have a complete solution built from real business data, shaped, cleansed & modeled; with a dashboard and interactive report visuals ready for analysis.

Topics & skills include: Power Query/M, modeling and calculations/DAX, standard & custom visuals, R visuals. Data sources: CSV, JSON, SQL Server; query folding, scheduled refresh & DirectQuery.

Attendees should have at least intro-level experience w/Power BI Desktop or Power Pivot. Bring laptop w/latest Power BI Desktop ver. installed (PowerBI.com), 64-bit Windows & 4 GB of RAM (8 GB recommended), 2 GB free storage. Power BI subscription recommended, not require.

Paul has been teaching Microsoft Business intelligence, Data, Analytics and reporting for about eighteen years. He uses Power BI, SQL Server, SSAS, SSRS and related technologies to deliver solutions to consulting clients and businesses. He’s a Microsoft Data Platform MVP, author of Power BI courseware and the author of the recently-released Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports.

b: SqlServerBi.Blog

t: @Paul_Turley