Data Survival Skills
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...
Using Unpivot to build data sets from Survey Results
Using Unpivot to build data sets from Survey Results Surveys are used to capture a...
Creating aggregated datasets
Creating aggregated datasets Creating aggregate data sets is vital for effective data analysis and decision-making....
Using Functions to Mask Data
Using Functions to Mask Data Exploring Different methods to mask data for privacy (because data...
Model or Merge- and what’s the difference?
Model or Merge- and what's the difference? You may wonder, "When is it best to...
Normalizing data to achieve a data design
Normalizing data to achieve a data design Normalizing data is typically the skill of a...
Working with full outer joins
Working with full outer joins Often times we find as data workers we are trying...
Using anti joins to search for data
Using anti joins to search for data We know that data sets cannot be achieved...
Joining data with common data between two unrelated data sets
Joining data with common data between two unrelated data sets Joining data is part of...