Power query essentials : managing advanced data connections.

Format:

Video

Contributor:

Simon Sez IT (Firm), instructor, publisher.

Language:

English

Subjects (All):

Querying (Computer science).

Big data.

Physical Description:

1 online resource (1 video file (1 hr., 2 min.)) : sound, color.

Edition:

[First edition].

Place of Publication:

[Christmas, Florida] : Simon Sez IT, 2026.

Summary:

Power Query Essentials: Managing Advanced Data Connections shows you how to stop copying and pasting data by hand and build connections that update themselves. The course covers pulling data from folders, SharePoint, and web pages, then deciding how that data should land in your workbook. You also learn to fix broken links and read error messages instead of dreading them. Once you finish, you will know how to combine dozens of files from a folder into one clean dataset in seconds. Building a single central file means your team stops working from outdated emailed copies. When a source file moves or gets renamed, you fix the connection in a few clicks instead of rebuilding a query from scratch. Loading data into the Data Model lets you skip Excel's row limits and link tables without VLOOKUPs. Setting refresh schedules keeps your Power BI reports automatically up to date. By the end of this course, you will learn how to: • Combine multiple files from a folder into one dataset. • Connect Excel workbooks to live SharePoint and web sources. • Build a central data source to replace emailed copies. • Choose the right load destination for query results. • Fix broken connections using Data Source Settings. • Troubleshoot Power Query errors using Applied Steps. • Load data into the Data Model to skip row limits. • Schedule refreshes to keep Power BI reports current. The following files are included in the Resources section below: Exercise Files - Used to practice and complete the course exercises. Course Files - Used to follow along with the instructor during lessons.

Notes:

OCLC-licensed vendor bibliographic record.

OCLC:

1611140861

Publisher Number:

10338SIMONSEZIT