A really useful thing for an analyst to do is to connect directly to a data source
this guided example shows the steps involved to connect Excel to SQL
you can then just right click to refresh the data and the excel sql connection pulls the latest data straight in from the database
Sign up to hear more tips as we add them
Copyright © 2022 Select Distinct Limited - All Rights Reserved.