Data Survival Skills

A woman working on a computer.

Using Make Tables to normalize a denormalized data set

Using Make Tables to normalize a denormalized data set We can't always control how we...
A woman working on a computer.

Using Append queries to combine spreadsheets

Using Append queries to combine spreadsheets You may discover that all your data is siloed...
A woman working on a computer.

Using union queries to bring together data sets in SQL

Using union queries to bring together data sets in SQL Unions can be a valuable...
A woman working on a computer.

Build conditional functions to make data

Build conditional functions to make data The ability to create conditional formulas in Power BI...
A woman working on a computer.

Cleaning data from a folder of files in Power BI

Cleaning data from a folder of files in Power BI Each week represents a new...
A woman working on a computer.

Duplicate vs Reference in Power Query

Duplicate vs Reference in Power Query To duplicate or to reference, that is the question....
A woman working on a computer.

Cleaning data from a PDF in Power BI

Cleaning data from a PDF in PowerBI Let's face it- sometimes the only information you...
A woman working on a computer.

Using Unpivot to build data sets from Survey Results

Using Unpivot to build data sets from Survey Results  Surveys are used to capture a...
A woman working on a computer.

Creating aggregated datasets

Creating aggregated datasets  Creating aggregate data sets is vital for effective data analysis and decision-making....
A woman working on a computer.

Using Functions to Mask Data

Using Functions to Mask Data Exploring Different methods to mask data for privacy (because data...