top of page

ChemEnggLife Webinar

Workshop on creating interactive dashboard using Pivot Tables in Excel

Humzaa Imtiaz Ullah

Guest Speaker

11-FEB-2023 | 13:00 (GMT+1)


In any industrial role, everyone and everything is evaluated as per the selected KPIs and these KPIs are calculated from different datasets. But the dataset may include lots of pieces of information and it is neither cost effective nor user friendly to create multiple dashboards from the same data set for different KPIs. Therefore, in situation like these, interactive dashboards come in handy because the dashboard can cover multiple areas and the user can select which data should be displayed on the screen. In this webinar, we will look at creating an interactive dashboard using a dataset and how it can help the user select different options.


You'll learn:

  • How to set up the excel workbook to allow the dashboard to use pivot table to extract key information.

  • How to merge pivot table with the dashboard in the workbook.

  • Benefits and Limitations of using this approach for creating dashboards.


Humzaa Imtiaz Ullah

QMS Engineer

Humzaa Imtiaz Ullah is a Chemical Engineer, with an MS from the Technical University of Denmark. He has been working within the Pharmaceutical Industry, starting as a Supplier Quality Engineer and then taking on the role of QMS Engineer and also working as a Project Manager within Quality. Previously, he has worked as a Procurement Analyst in Cement Industry. He has strong experience in Excel Solutions for KPI Monitoring and creating interactive dashboards.

bottom of page