Further tutorials are listed below for non-Sage users. Tutorial 1: Using MS Query to get Sage data into Excel Microsoft Query only works with packages that are ODBC-enabled. First you will need to ...

Welcome to this short Data Warehouse tutorial. Here we will create a few data sources and centralize that data in the Data Warehouse. We will also make a simple report from the data with PowerBI. The ...

Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. We all know we can use MS Query to get data from a SQL server. Typically though ...