Learning path Overview
Unlock the full potential of data with the Enterprise Data Specialist Learning Path. This comprehensive program will equip you with essential skills in data management, storytelling, and visualization—empowering you to turn raw data into actionable insights that drive business success.
Learning path objective
- Master data management for effective analysis and decision-making.
- Create compelling data stories to communicate insights clearly.
- Build impactful visualizations to simplify complex information.
Recommended for
Professionals who want to master data management, storytelling, and visualization to drive better decision-making.
Courses
Data Management
Master essential data management techniques to organize, analyze, and present data effectively for decision-making.
Data Storytelling
Learn to transform complex data into compelling narratives that communicate insights clearly and inspire action.
Data Visualization
Create impactful visualizations and interactive dashboards to simplify complex data and deliver meaningful insights.
Course Outline
Precision in Data Management
Excel Fundamentals
- Introduction to Excel Interface.
- Customising the Quick Access Toolbar.
- Understanding the structure of an Excel Workbook.
- Saving an Excel workbook.
- Common Excel shortcut keys
1
Entering & Editing Text and Formulas
- Cells, columns, rows & sheets.
- Working with Numeric Data in Excel.
- Entering Date Values.
- Working with Cell References.
- Creating Basic Formulas in Excel.
- Relative Reference vs Absolute Reference
2
Working with Basic Excel Functions
- The structure of Excel Function.
- Working with SUM(), COUNT(), MIN(), MAX(), AVERAGE().
- Using the AutoSum command.
- Using the AutoFill Command to Copy Formulas
3
Modifying an Excel Worksheet
- Moving and copying data in Excel Worksheet.
- Inserting & Deleting rows & columns.
- Hiding & Unhiding rows and columns.
- Renaming & deleting an Excel worksheet.
- Moving and copying an Excel worksheet
4
Formatting data in Excel Worksheet
- Working with Font Formatting.
- Changing the background of cell color.
- Adding borders to cells.
- Number formatting.
- Using Excel;s Format Painter.
- Merging & Centering Cells
5
Inserting Images & Shapes into Excel Worksheet
- Inserting Images.
- Inserting Excel Shapes.
- Formatting Excel Shapes.
- Working with SmartArt
6
Printing an Excel Worksheet
- Viewing your document in Print Preview.
- Changing Margins, Scaling and Orientations.
- Working with Page Layout view.
- Adding Header and Footer.
- Printing a Specific Range of Cells
7
For course customization and further discussion, feel free to reach out to us at marketing@matrixc.com
Course Outline
Persuasive Data Storytelling
Those who tell good stories, rule the world
- What is Data Storytelling?
- Examples of good storytelling
- Bad storytelling
- Examples of bad storytelling
- 3 purposes of Data Storytelling
1
Data Storytelling - 3 steps to success
This section outlines important aspects such as defining the audience, crafting impactful titles, and integrating data effectively into the story.
2
Audience: The Who
- Defining the who as the starting point
- The who determines the what & the how
- Identifying audience from a cultural perspective
3
Story: The What
- 6 most popular Data Story
- Oyster vs Pearl – Show them the pearl
- Hybrid title – how to write impactful title that drives actions
4
Story: The How
- Data is the backbone of our story
- The BET test – Bias, Enough & True and Fair View
5
Defining the one big idea
- Combining the who, the what and the how
- Storyboarding
6
Group exercise using real datasets
7
Graphical Perception
- Why some visuals are better than others
- Choosing the right visual
– What is your Data Type?
– Different type of visual for different type of data types
8
Charts Makeover
- Data to Ink Ratio – why it’s important
- Focusing on what’s important
9
Color Psychology
- Psychology of colors
- Using colors purposely
- Cheat code : how to apply the best color scheme
10
Font Psychology
- Psychology of font
- Using font purposely
- Font pairing and sizing
11
Group exercise using real datasets
12
For course customization and further discussion, feel free to reach out to us at marketing@matrixc.com
Course Outline
Mastering Data Visualization
Conditioning Formating
Learn to apply and customize conditional formatting in Excel and Google Sheets to highlight key data points. Use color scales, data bars, and icon sets to visually enhance your data and make it more readable.
1
Basics of Descriptive Data Analytics
Understand statistical measures such as mean, median, mode, variance, and standard deviation. Use these to summarize and interpret data, identify trends, and make informed decisions.
2
Pivot Table
Master creating and using Pivot Tables to organize, summarize, and analyze large datasets. Learn to configure fields, filter and sort data, and use calculated fields for complex calculations.
3
Dashboards
Build comprehensive and interactive dashboards in Excel. Integrate various charts and tables, use slicers for dynamic filtering, and design layouts that present key metrics clearly.
4
Intro to Statistical Analysis for Data Analysis
Get introduced to basic statistical analysis, including hypothesis testing, correlation, and regression analysis. Apply these methods to analyze data, identify relationships, and make data-driven decisions.
5
For course customization and further discussion, feel free to reach out to us at marketing@matrixc.com
Trainers Profile
Mazlita Mat Hassan
Director / Lead Trainer, MatrixC Academy
Mazlita Mat Hassan, known as “MEM,” is an accomplished IT corporate trainer and data science expert with a BSc in Computer Science from University College London. With over a decade of experience, she has trained more than 10,000 professionals across Southeast Asia, specializing in Microsoft Office, Google Apps, and Tableau.
As the CEO of RECQA, she drives DeLIMA 2.0, Malaysia’s National Digital Learning Platform, and leads MatrixC Academy’s Change Management training with Google Tools. Globally recognized, she is the SEA & Pacific Leader for UNCTAD’s “e-trade for women” initiative and received the 2023 Women in STEM award from Business and Professional Woman Malaysia for her contribution in co-developing DeLIMA 2.0 with MOE and Google Malaysia.
Ikmal Nordin
Data & AI Lead, Matrix Connexion
A distinguished data analytics trainer, data scientist, and AI specialist with deep expertise in data science, AI, and economic analysis. Renowned for architecting cutting-edge data solutions, he translates complex concepts into practical, high-impact training for both corporate teams and individuals.
Ikmal has successfully trained and consulted for leading companies like Proton, Star Media Group, and BE International, empowering professionals across industries to harness the power of big data and AI for significant productivity gains and career advancement.