I only need the last part of relationship will not take half an hour- data and video how to do it will be provided
The goal of the project is to create a dashboard in MS Excel based on multiple external data sources. The end product will be an MS Excel file that will showcase data pertaining to your area of interest. This file will be the dashboard and it will visualise external workbooks using various charts and graphs in conjunction with Pivot Tables and incorporating the Data Model within Excel.
The completed dashboard will contain, as mentioned above, charts and graphs in addition to having dynamic functionality through the use of MS Excel Slicers.