Tutorial on how to make an interactive dashboard in MS Excel linked to a SQL database



How to build an interactive dashboard in MS Excel, based on a link to a SQL Server database.
I walk you through the complete procedure and build FROM SCRATCH.

01 – goal of this video 0:01
02 – SQL: tip on how to find relationship between tables 2:19
03 – SQL: writing SQL query to get the information needed 4:26
04 – Excel: get the data from the SQL server with the query written 21:17
05 – Excel: make pivot table from the related table and make extra table (get pivot data) and make charts…

2 thoughts on “Tutorial on how to make an interactive dashboard in MS Excel linked to a SQL database

Leave a Reply

Your email address will not be published. Required fields are marked *