Power Query Essentials: Managing Advanced Data Connections
Power Query Essentials: Managing Advanced Data Connections
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English (US) | Duration: 1 h | Size: 732 MB
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English (US) | Duration: 1 h | Size: 732 MB
Connect, combine, and auto-refresh data from multiple sources in seconds.
This course includes downloadable course instructor files and exercise files to work with and follow along.
Power Query Essentials: Managing Advanced Data Connections teaches you how to build data connections that update themselves instead of forcing you to copy and paste every week. This course turns Power Query from a mystery button into a tool you use with confidence, in both Excel and Power BI.
You start with the problems that slow down everyday reporting: dozens of separate files, spreadsheets that go stale the moment someone emails a copy, and connections that break the instant a file gets moved or renamed. These are the exact issues that push people back into manual data entry.
From there, you build practical skills. You learn to combine whole folders of files into one dataset, connect to SharePoint and live web pages, and decide whether data should load as a table, a PivotTable, or straight into the Data Model. You also learn to read error messages and fix broken connections using Data Source Settings.
Each skill is grounded in a real situation. You learn how to merge weekly inventory files into one report, split a messy product description into clean columns with Column From Examples, and set up a central file so your team stops working from outdated copies. You also organize source folders so imports stay clean as files pile up.
By the end, you will be able to build a refreshable reporting pipeline from scratch and trust the numbers it produces. This course suits analysts, report builders, and anyone in Excel or Power BI who is tired of rebuilding the same spreadsheet every month.
What You'll Learn:
• Combine multiple Excel files from a folder into one dataset.
• Connect Power Query to SharePoint folders and web pages.
• Create a single source of truth for shared Excel workbooks.
• Separate large raw data files from lightweight dashboard workbooks.
• Import tabular data directly from live web pages into Excel.
• Fix broken Power Query connections using Data Source Settings.
• Apply error handling to address Power Query data type mismatches.
• Locate and fix query references when column names change.
• Load Power Query data as tables, PivotTables, or connections only.
This course includes:
•
65 minutes
of video tutorials
•
10 individual video
lectures
•
Course and Exercise Files
to follow along
•
Certificate of completion
More Info