Making Data Sets
Using Remove Duplicates to Find the Latest or Earliest Record in Excel
Using Remove Duplicates to Find the Latest or Earliest Record in Excel You will learn...
Building Data Sets inside of Outlook
Building data sets inside of Outlook Having my data skills means that I look at...
Adding data leveraging cross joins
Adding data leveraging cross joins We use joins in data to effectively report on data,...
Using date functions to create follow up data
Using date functions to create follow up data When you have data; you can use...
Leveraging the Advanced Editor in Power Query to share cleaning routines
Leveraging the Advanced Editor in Power Query to share cleaning routines When you work in...
Using Remove Duplicates to Create Data Sets
Using Remove Duplicates to Create Data Sets You have a ton of data- it's just...
Adding data leveraging cross joins
Adding data leveraging cross joins A cross join in SQL is useful for creating all...
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...