Training

A woman working on a computer.

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...
A woman working on a computer.

Using Append queries to combine spreadsheets

Using Append queries to combine spreadsheets You may discover that all your data is siloed...
A woman working on a computer.

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...
An intermediate badge showcasing Power Query data skills.

Intermediate Power Query

Intermediate Power Query Are you tired of spending valuable time hopping from one spreadsheet to...
Mastering Power Query for data analysis.

Getting Started with Power Query

Getting Started with Power Query Power Query is a game-changer in Excel. Whether you're currently...
Mastering the art of SQL queries.

Understanding and Building SQL Queries

Understanding and Building SQL Queries In this course, you don't need to grasp the entire...
Getting started with Power BI - data and viz.

Getting Started with Microsoft Power BI

Getting Started with Power BI Dashboards, Smashboards - if you're only surviving with basic pivots...
A woman working on a computer.

Build conditional functions to make data

Build conditional functions to make data The ability to create conditional formulas in Power BI...
A woman working on a computer.

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...
A woman working on a computer.

Duplicate vs Reference in Power Query

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