Education

Training Session on Excel Dashboards and Data Visualization 

Lahore, December 01, 2022 (PPI-OT):Excel Dashboard is a reporting tool for Supply Chain Managers used to track supply chain KPIs and metrics in a single display or interface. Supply chain dashboards track inventory levels, logistics management, and warehouse operations.

A procurement dashboard enables purchasing manager to efficiently track, evaluate, and optimize all acquisition processes within a company with the help of procurement KPIs such as the compliance rate, purchase order cycle time, supplier defect rate, and many more.

In order to develop practical understanding of students a training session was organized on the topic “Excel Dashboards and Data Visualization” for BBA students on Wednesday, 23rd November 2022 from 5:00- 700 pm.

Mr. Saif ur Rehman, Deputy Manager Supply Chain, Mughal Steel was invited as trainer. Students from the class of “Transportation and Distribution Planning” (MGMT 4673), Fundamentals of Operations Management, (BAMG 2823) and Supply Chain Sourcing (MGMT 4473)” attended the training session.

Training Details/Outline:

What is an Excel Dashboard and how does it differ from a report?

How to Create an Excel Dashboard?

Things to Do Before You Even Start Creating an Excel Dashboard

Getting the Data in Excel

Outlining the Structure of the Dashboard

Excel Table – The Secret Sauce of an Efficient Excel Dashboard

Important Excel Functions for Dashboards

Interactive Tools to Make Your Excel Dashboard Awesome

Using Excel Charts to Visualize Data in an Excel Dashboard

Use of Pivot Tables

Excel Dashboards Do’s and Don’ts

Dashboard Examples

Excel KPI Dashboard

Learning Outcomes:

This training exposed students with how Dashboards are designed with key pieces of information that are relevant to the goal of dashboard and enable them to present analysis and conclusions effectively. Learning outcomes include

Understand Dashboards in MS Excel

Create and Customize Dashboards

Use Dashboards Visualization Techniques – Charts

Use Interactive Controls in Dashboards

Use PivotTables effectively

Learning Methodology

Instructor-led Training

Group Discussion

Hands-On

Exercises

Training Schedule:

Date: Wednesday, 23rd November 2022

Time: 5:00PM to 7:00 PM

Venue: Computer Lab 402

Trainer’s Profile:

Deputy Manager Supply Chain (Non-Ferrous Division) Mughal Steel · Full-time

Business unit Head Warehouse and Logistics, Supply chain, Non-ferrous division

Section Supply Chain Planning in line with Sales and procurement objectives to manage un interrupted operations

Handling End to end factory, Regional and export support related operations.

Setting KPI’s and monitoring for sustainable operations management

Working with a large volume of cross-disciplinary quantitative data, analysing and deriving way forward accordingly

Deriving way forward for continuous process improvement by applying small changes i.e. KAIZEN, 5S etc. on departmental level

Working effectively with remote/offshore teams

3 PL Management

Driving strategic initiatives in line with company strategy, while engaging and collaborating with multidisciplinary teams and leaders

Leading department technical transformation activity from manual to AX dynamics 365 for operational process improvement and transparency

Dashboard preparation for management reviews and self-appraisals

Monthly performance review reports analysis

M-Phil in Supply Chain Management, with diversified projects in Daewoo Pakistan, MAN diesel and Turbo, service Sales Corporation, and Gul Ahmed retail, all these projects were full of knowledge nourishment. Technically proficient Logistics and Supply Chain Management professionals were always part of these teams to get desired goals, with a broad knowledge and understanding of Supply Chain processes and practices including

Warehouse management mechanism development, implementation and running activities analysis

Inbound and outbound logistics management development

Negotiation with local and international Vendors and Suppliers for the supply of right product

Procurement process from purchase request to goods receiving and billing

Complete warehouse activities from goods receiving to Issuance

Complete Import Process including purchase deals

For more information, contact:
University of Central Punjab (UCP)
Khayaban-e-Jinnah Road, Johar Town, Lahore, Pakistan
Phone: +92-42-35880007
Fax: +92-42-35954892
Email: info@ucp.edu.pk
Website: https://www.ucp.edu.pk/