Training
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...
Intermediate Power Query
Intermediate Power Query Are you tired of spending valuable time hopping from one spreadsheet to...
Getting Started with Power Query
Getting Started with Power Query Power Query is a game-changer in Excel. Whether you're currently...
Understanding and Building SQL Queries
Understanding and Building SQL Queries In this course, you don't need to grasp the entire...
Getting Started with Microsoft Power BI
Getting Started with Power BI Dashboards, Smashboards - if you're only surviving with basic pivots...
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....