Gradient Text

Posted Notes

Most of our content is published through our website—primarily within posts where it naturally fits the topic. If you’re looking for a full archive to explore, here it is

A woman working on a computer.

Using Union Queries to Bring Together Data Sets in SQL

Learn how to turn messy order data into clean, usable datasets with Power Query's Remove...
A woman working on a computer.

Build conditional functions to make data

Learn how to create powerful insights from imperfect data by building conditional logic in Power...
A woman working on a computer.

Cleaning data from a folder of files in Power BI

Learn how to clean and combine data from multiple files in Power BI. Managing monthly...
A woman working on a computer.

Duplicate vs Reference in Power Query

Learn how to choose the right approach when reusing datasets in Power Query. In this...
A woman working on a computer.

Cleaning data from a PDF in Power BI

Discover how to turn static PDF files into interactive, analyzable data. In this Data Survival...
A woman working on a computer.

Using Unpivot to build data sets from Survey Results

Learn how to transform messy survey data into powerful insights. In this Data Survival Skills...
A woman working on a computer.

Creating aggregated datasets

Learn how to turn detailed records into aggregated datasets that reveal insights without exposing sensitive...
A woman working on a computer.

Using Functions to Mask Data

Learn how to protect sensitive information in reports and presentations by masking data in Excel....
A woman working on a computer.

Model or Merge- and what’s the difference? 

Learn how to choose between merging data into a single dataset or modeling data across...
A woman working on a computer.

Normalizing data to achieve a data design

Learn how to break down combined datasets into clean, structured tables. In this Data Survival...