Content

The blog features several series of exercises, which are best appreciated when considered in sequential order, based on your level of experience with the topics.

* indicates post features a Best Practice Tip

---

Getting Started

The Game Changer
Installing Power Query

---

Power Query

Intro to Power Query series, Treasury report

Load Data*
Refresh
Process GL Data*
PowerBI and PowerPivot*
Process Bank Account Listing*
Automation*
Merge: Power Query's VLOOKUP
The Reward Month 2

Power Query tips & tricks

Choose your own Data Adventure*
Remove duplicates
Joins conceptually
Joins illustration*
The Power of Unpivot

M-language

Error Checking

Query Dependencies

Combine Files from a Folder*

Direct Query

---

Power Pivot

Intro to Power Pivot series, Budget vs Actual

2 files, 1 Pivot Table: Power Pivot
Installing Power Pivot
Power Pivot Date Table*
Building Relationships*
2 Data Tables on 1 Pivot Table*

Measures, series

Measures
Measures In-depth*
Measures inside Measures*

Calculated Columns vs Measures

Measures: Right & Wrong

Power Pivot tips & tricks

Distinguishing datasets in Power Pivot

Relationship problems*

---

PowerBI

As mentioned in the post, PowerBI and Power Pivot, PowerBI combines Power Query & Power Pivot with a visualization application. As such, all above posts apply to PowerBI. Below posts are PowerBI specific. 

Convert PDF using PowerBI

Transforming a PDF

---

Excel and other tips & tricks

What's killing my Excel?*
A table is not a Table

Subscribe at bottom of page to get an email when posted.  

(No spam will be sent).