Power Query Patterns - Excelerator BI

Power Query Patterns

Appending Multiple Files

Length: 19 minutesComplexity: Standard

In this lesson, you will learn different techniques to combine files (.CSV, Excel) into a single table.

Appending Multiple Tabs

Length: 13 minutesComplexity: Standard

In this lesson, you will learn how to import multiple worksheets (tabs) and how to combine the multiple sheets into a single query.

Creating a Calendar Table from Scratch

Length: 27 minutesComplexity: Standard

In this lesson, you will learn how to create a Calendar table from scratch and generalize it so that it starts from a specified date and ends with the current date.

Adding Comments to Tabular Data

Length: 8 minutesComplexity: Standard

In this lesson, you will learn the concept - Self-referencing Tables. This is used in adding comments to tabular data and retaining them in place when data manipulations are done on the table.

Parameters and Parameter Tables

Length: 17 minutesComplexity: Standard

In this lesson, you will learn how to use parameters in Power BI Desktop and how to use parameter tables in Excel.

Import from PDF

Length: 8 minutesComplexity: Standard

In this lesson, you will learn how to import tabular data from a PDF file to Power BI Desktop, provided the PDF file is not password protected and the data is in tabular format. You will also learn how to combine multiple sets of columns to a single set of columns.

Back to: Power Query for Excel and Power BI
Scroll to Top