Report of Training Session on Excel Dashboards and Data Visualization
Semester: FALL 2022
Department: Marketing Operations and Supply Chain Management
Organizer: Ms. Syeda Uzma Tahira, Senior Lecturer
Introduction:
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 & Distribution Planning” (MGMT 4673), Fundamentals of Operations Management, (BAMG 2823) and Supply Chain Sourcing (MGMT 4473)” attended the training session.
Course Objectives:
Following course objectives were achieved from the session
CO3
(Sourcing) |
Understand different tools and techniques for strategic cost management in purchasing process with respect to different product categories |
CO3 (Transportation) | Discuss the issues with the optimal design of distribution networks, optimal facilities location, warehousing systems, optimal inventory positioning and optimal selection of transportation modes. |
CO7:
(Operations Management) |
Impart knowledge of demand and capacity options and strategies for aggregate planning. |
BBA Program Objectives:
Following course BBA program objectives were achieved from the session
PO2: | Build managerial cognition of the students with a variety of planning, organizing, controlling, leading, and communication skills necessary to effectively manage business and influence society. |
PO3: | Nurture problem analysis and decision-making skills in students, required to handle challenges faced by the modern business world and equip them with quantitative and qualitative tools to evaluate local and global business opportunities and successfully materialize new entrepreneurial ventures. |
Training Details/Outline:
- 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
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 & 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, analyzing 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 & 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