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/