Power BI Technical

The Query Playbook for Power BI Desktop

Wednesday, May 10
10:45 AM - 12:15 PM
Room: Frisco

Format: Deep Dive


This session demonstrates the powerful query capabilities available when creating projects in Power BI Desktop. Attendees will learn how queries created with Power BI Desktop to extract and transform data from unstructured text files, Excel Workbooks, Access databases, SQL Server databases, SQL Azure databases, SQL Server Analysis Services and SharePoint lists. This session also shows how to create queries that merge columns and append rows from multiple data sources into a single output table. Along the way, attendees will also see how to write data extraction scripts in the R programming language which can be used as the underlying data source for a query in Power BI Desktop to solve problems such as extracting data from files inside a zip archive and querying large SharePoint lists.

Ted Pattison

Instructor, Author and MVP
Critical Path Training

Ted Pattison is an author, instructor and owner of Critical Path Training, a company dedicated to in-depth technical education on Power BI and SharePoint technologies. Ted is currently a Power BI Microsoft MVP and a 13-time recipient of MVP award for his expertise and community contributions with PowerBI, SharePoint, Microsoft Auzre and Office 365.

Presentation(s):

Send Email for Ted Pattison


Assets

The Query Playbook for Power BI Desktop



Attendees who have favorited this

Send Email for The Query Playbook for Power BI Desktop