Design and development of a data pipeline in SQL Server, using a combination of Azure Functions in C# and SSIS (SQL Server Integration Services) to visualise data in Power BI.
The solution provides quick access to data and the use of show/hide buttons allows users to quickly swap between quantities and dollar values without switching pages or too much information on the screen at one time.
Finally condition formatting allows users to quickly identify areas where action needs to be taken.