Data Visualization Mastery:
Building Skills for an Agile Workforce
ABOUT
The 2-day training is for employees across various functions who work with large amounts of data daily. It teaches innovative approaches to using Microsoft Excel to analyze, present, and visualize data, including creating visually appealing infographics and graphs. The course provides the skills necessary to produce professional-grade diagrams and enhance data visualization.
OBJECTIVES
-
To understand the principles of Excel dashboard design.
-
To prepare data for analysis.
-
To understand PivotTables & PivotCharts
-
To create visually appealing interactive Excel dashboards.
-
To identify suitable chart types to display data in the most meaningful way.
LEARNING METHODOLOGY
-
Lecture sessions
-
Hands-on lab practices
-
Group activities
-
Presentation
DURATION
-
Number of days: 2 days
-
Number of hours: 14 hours
-
Breakdown of hours:
-
Day 1 - 7 hours
-
Day 2 - 7 hours
LEVEL
Beginner
​
The course is designed for beginner level participants as it covers the fundamentals of data visualization using popular tools like Excel. The course objectives include understanding the principles of Excel dashboard design, preparing data for analysis, and identifying suitable chart types to display data in the most meaningful way. These are all essential skills that beginners need to learn in order to create effective data visualizations.
MODE OF TRAINING
Virtual or Physical
Topic:
1. Setting Up Dashboard
2. Designing Dashboard
3. Working with Data
4. Useful Excel Formulas
5. PivotTables & PivotCharts
​
Description:
After completing the workshop, the participants will be able to know how
to prepare and analyse data for Excel dashboard design and creation.
Topics cover basic understanding on dashboard design, data preparation
and analysis.
​
Time/Hours:
-
9 am - 1pm
-
2 pm - 5 pm
Total: 7 hours​
Participant Requirement:
-
Computer with Windows 8.1 or Windows Server 2012 R2 or .NET 4.6.2 or later.
-
Familiarity with Microsoft Excel will be an advantage but not compulsory.
Ts Dr Noramiza Hashim
Ts. Dr. Noramiza Hashim is an experienced senior lecturer in the Faculty of Computing and Informatics at Multimedia University, with 15 years of experience in the education sector. She is also a trainer, supervisor, and researcher, with expertise in communicating and engaging with audiences both online and offline. She holds a Ph.D. in Information Technology and is registered as a Professional Technologist under the Malaysia Board of Technologists. Her teaching spans from foundation to postgraduate levels, and her research expertise is in image processing. She has completed several research and industry-related projects in image and video processing, object retrieval, and gesture recognition. Additionally, she has led workshops on online safety and visual programming and provided Power BI Essentials training for various organizations.
Dr. Aziah Ali is a lecturer at Multimedia University who teaches courses such as Web Programming, Computer Graphics, Digital Image Processing and Multimedia Fundamental courses. She is passionate about imparting wisdom and knowledge to students and continuously pursues lifelong learning with the objective of upskilling herself with new technologies and building her research networks. Her research interests include image and signal processing focusing on biomedical field, and she is proficient in MATLAB, Python, PowerBI, Google Looker Studio, SQL, PHP, and HTML. Dr. Aziah is also involved as instructors and content developers for several courses and trainings mainly related to big data, programming, web development and online safety for school students, university students (local and international), and professionals.
TRAINER PROFILE
Dr Aziah Ali