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…