Learn how to use SQL queries to access and analyze data from different sources, calculate and compare KPIs, drill down into root causes and solutions, and visualize your supply chain data.

To make your queries run faster, you should avoid unnecessary joins that do not add any value to your results. For example, if you only need data from one table, do not join it with another table ...

Fetching data from the database takes a lot time process. eventually when you need to combine multiple tables in order to fetch the data, reducing database calls becomes very meaningful. although in ...

I checked it again recently though and now it does something very handy indeed: it allows you to pass parameters to SQL queries. Before this, if you wanted to use parameters in your SQL, you had to do ...

I was super-excited when, a few days ago, the long-awaited integration of Power Query into Microsoft Flow was announced.I was then gutted when work commitments meant I couldn’t blog about it right ...