Data Survival Skills

Edit visual interactions
Edit visual interactions Learn how to create interactive dashboards with a few static items that...

Using Joins and Update Queries to Create Markers in the Data
Using Joins and Update Queries to Create Valuable Markers in the data Joins can provide...

Building Date Tables in Power BI/Power Query
Building Date Tables in Power BI/Power Query Creating date tables is important in data analysis...

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...

Using Append queries to combine spreadsheets
Using Append queries to combine spreadsheets You may discover that all your data is siloed...

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...

Build conditional functions to make data
Build conditional functions to make data The ability to create conditional formulas in Power BI...

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...

Duplicate vs Reference in Power Query
Duplicate vs Reference in Power Query To duplicate or to reference, that is the question....

Cleaning data from a PDF in Power BI
Cleaning data from a PDF in PowerBI Let's face it- sometimes the only information you...