Making Data Sets
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 Use the Advanced Editor...
Using Remove Duplicates and Distinct Statements
Using Remove Duplicates and Distinct Statements You have a ton of data- it's just not...
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 Valuable Markers
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...
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 from other tables/views in SQL
Using Union Queries to bring together data sets from other tables/views in SQL Unions can...