Archives
- By thread 3660
-
By date
- June 2021 10
- July 2021 6
- August 2021 20
- September 2021 21
- October 2021 48
- November 2021 40
- December 2021 23
- January 2022 46
- February 2022 80
- March 2022 109
- April 2022 100
- May 2022 97
- June 2022 105
- July 2022 82
- August 2022 95
- September 2022 103
- October 2022 117
- November 2022 115
- December 2022 102
- January 2023 88
- February 2023 90
- March 2023 116
- April 2023 97
- May 2023 159
- June 2023 145
- July 2023 120
- August 2023 90
- September 2023 102
- October 2023 106
- November 2023 100
- December 2023 74
- January 2024 75
- February 2024 75
- March 2024 78
- April 2024 74
- May 2024 108
- June 2024 98
- July 2024 116
- August 2024 134
- September 2024 130
- October 2024 141
- November 2024 82
-
Re: Odoo Learn online sales
Hi
Just checking in on my previous email about connecting for a quick call to discuss some ideas on generating sales from social media promotions.
When is a good time for you to chat this week?
Thanks
Ian
422 Richards St, Suite 170. Vancouver, BC V6B 2Z4
P.S. Please let me know if you don't want to hear from me again-----Original Message-----
From: Ian Valentine
To: info@learn.odoo.com
Subject: Re: Odoo Learn online sales
Hi
I wouldn't insist on connecting with you if I didn't believe we can add value to Odoo Learn.
Are you available for a quick call in the next day or two?
Thanks
Ian
422 Richards St, Suite 170. Vancouver, BC V6B 2Z4
P.S. Please let me know if you don't want to hear from me again-----Original Message-----
From: Ian Valentine
To: info@learn.odoo.com
Subject: Re: Odoo Learn online sales
Worth a chat?
Ian
422 Richards St, Suite 170. Vancouver, BC V6B 2Z4
P.S. Please let me know if you don't want to hear from me again-----Original Message-----
From: Ian Valentine
To: info@learn.odoo.com
Subject: Odoo Learn online sales
Hi
I came across your website and read about your software.
I work at Wishpond, a lead generation company that helps software development companies attract more clients and grow their business.
We recently launched a marketing campaign for one of our clients and they saw 150 new inquiries in just 30 days.
Can we chat about how we can do the same for you?
Thanks,
Ian
422 Richards St, Suite 170. Vancouver, BC V6B 2Z4
P.S. Please let me know if you don't want to hear from me again
by "Ian Valentine" <ian@all-in-one-marketing.net> - 09:22 - 13 Nov 2024 -
GRAB YOUR SEAT!!! PROCUREMENT MANAGEMENT-MANAGING SUPPLIER SELECTION & NEGOTIATION, SOURCING & TENDERING(20,21 Nov 2024)
GRAB 3 FREE 1 !!!
Please call 012-588 2728
email to pearl-otc@outlook.com
FACE-TO-FACE PUBLIC PROGRAM
PROCUREMENT MANAGEMENT - MANAGING SUPPLIER
SELECTION & NEGOTIATION, SOURCING & TENDERING
Venue :Wyndham Grand Bangsar Kuala Lumpur (SBL Khas / HRD Corp Claimable Course)
Date : 20 Nov 2024 (Wed) | 9am – 5pm By SH Yeo
21 Nov 2024 (Thurs) | 9am – 5pm 5 CPD Points Awarded by MBOT.
.
.
INTRODUCTION:
The key to an efficient procurement function is the ability to manage the proper selection of suppliers. The ability to select new suppliers or vendors which are able to provide the good support to the company operational needs makes the job of purchasing easier to manage.
In order to select the “perfect” supplier, an effective sourcing process + an efficient selection + ability to negotiate the best deal with the supplier is extremely important.
This program desires to bring these values to all the participants who decide to attend this 2 day interactive training program.
. .
TRAINING OBJECTIVES:
The training program was design with the following key objectives of learning to the participants:-
a) Effective Management of Sourcing and Tendering activities
b) Effective Selection Process during Sourcing and Tendering
c) Understand the different type of tendering and common issue in tendering
d) Effective negotiation preparation for supplier negotiation in sourcing and tendering
e) Understand the effective way of supplier evaluation and management
TRAINING METHODOLOGY:
This training will involve the following area to enhance learning:
a) Power point presentation
b) Case studies & Brain storming session
c) Discussion on subject of learning
d) Facilitating by trainer to enhance understanding of subject matter
e) Pre and Post test to evaluate participants understanding
LEARNING OBJECTIVES EXPECTED FROM PARTICIPANTS:
By the end of the 2-day interactive session, the learning curve achieve will enable the following:-
a) UNDERSTAND strategic sourcing and tendering role of procurement in business operation
b) APPRAISE and DISTINGUISH the type of strategy to be in place to manage tendering process to meet the objective of the company
c) MANAGING and carrying out effective negotiation with suppliers and other stake holders during tendering
d) DECIDING type of tendering to use depending on requirement and strategic advantages to the business organization
e) DIFFERENTIATE key differences between Sourcing and Tendering
f) IMPLEMENTING key areas of concern during selection process
PARTICIPANTS GROUP :
This training program is highly recommended for employees involve in the managing of the supply chain function in the company, for example, personnel from procurement, warehouse, logistics and planning department and finance.
OUTLINE OF WORKSHOP
Module 1 - Sourcing and Tendering
- Sourcing versus Tendering
- Type of Tendering
- Sourcing strategies
- Advantages and Disadvantages of Sourcing
- Advantage and Disadvantages of Tendering
- The Tendering Process in Open Tender
- Common term used in Tendering
Module 2 - Challenges in Tendering
- Key Reason why tender fails
- Reducing the risk in tender failure
- Managing conflict of Interest
- Red flag in Tendering and Sourcing
- Sourcing and Tendering best practices
- Case study
Module 3 – Suppliers Selection and Management Process
- Understanding the 10C + 1R selection
- Evaluation strategy for tendering
- Implementing Supplier On boarding and Off boarding system
- Type of Audits to conduct for supplier selection
- Case study
Module 4 – Managing Smart Negotiation
- Integrative Negotiation
- Distributive Negotiation
- Stages of Negotiation
- SWOT analysis
- Deciding red lines in negotiation
- Knowing your opponent traits
- The Soft Negotiator
- The Principled Negotiator
- The Hard Negotiator
- Traits of a good negotiator
- Bad Negotiator habits
- Mistakes made in Negotiation
- Body language in negotiation
- Clear planning of objectives and goals
- Understand when to walk away
- Managing Reject and counter offer
- Dealing with difficult negotiators
- WATNA strategies
- BATNA strategies
- Case study
** Digital Certificate of attendance will be awarded for those who completed the course
ABOUT THE FACILITATOR
SH Yeo
Academic & Professional Qualifications
Certified HRDF Trainer (TTT certificate number 4669)
Certified Professional Trainer and Facilitator (University Malaya, Malaysia)
- Diploma in Human Resource Management (UK)
- Diploma in Production Management (USA)
- MBA in Supply Chain Management (USA)
- 33 year of management experience in supply chain and operation
- Trainer & consultant since 2008
Mr. Yeo is a very experienced supply chain and operational manager. During his working career, spanning over 33 years, he has held various positions as following:-
1987 - with International Paint (later known as Akzo Nobel International Paint) as a Storekeeper
1989 to 1992 @ Warehouse Executive
1992 to 1993 @ Warehouse Manager
1993 to 1998 @ Production Manager
1998 to 1999 @ join Melandas as a Logistics and Purchasing Manager.
1999 to 2004 @ join Dian Creative as a Material Manager
2004 to 2006 @ join Joubert SA Malaysia as Purchasing Manager
2006 to 2008 @ Procurement Manager
2008 to 2019 @ Supply Chain Manager and Company Director
His major achievements include the following:-
a) Increase productivity in the production department by providing intrinsic and extrinsic motivation to the employees from 1993 to 1998.
b) Making major decision to advise a MNC company to drop LMW warehousing scheme and adopting MITI PC1 and 2 exemption system to help company to be more competitive in the local and oversea market in 1998.
c) Co coordinating Kastam licensing and reporting to solve company reporting and licensing issue with Kastam
d) Establishing control and procedure and bringing awareness to employee on important of supply chain control in 2004 until 2019 and achieving 100% shipment performances to customers
e) Involve in negotiating with a major customer from Europe to secure new contract and beside visiting overseas suppliers for performances improvement and selection of new suppliers
f) Carry out new product development by working with engineering and design team and suppliers, including spending on site at supplier premise to solve new product design issue
g) Introduced new procedures in warehouse and operation for better control of operation and reporting system
h) Managing and conducting cost reduction management program from 2008 to 2013 and reduce cost for the company by up to RM6.5 mil.
i) Involve in managing suppliers contract and involving in proposing and drafting new contract and contract renewal for suppliers from 2008 until 2019 (early retirement) by working with suppliers and internal stakeholders with guidance from legal expert.
j) Managing Non Disclosure Agreement with suppliers to protect company intellectual property
He has been conducting training since 2008 and recently retired as a fulltime supply chain manager and company director to concentrate on full time training and coaching.
His areas of training based on his many years experiences in the industry are as following:-
- Inventory and Warehouse Management
- Supply Chain Management
- Cost Reduction
- Strategic Procurement and Purchasing Management
- Import and Export Documentation Process
- International Payment Risk Mitigation
- Negotiation
- Incoterms and Impact on Trade
- Trade Financing
- Risk on Procurement Fraud
- Letter of Credit and Documentary control
- Procurement contract management
- Incoterms 2020 – Benefit, Risk and Cost on Rule of Delivery
(SBL KHAS / HRD Corp Claimable Course)
TRAINING FEE
2 days Face-to-Face Public Program
RM 2,250.00/pax
(excluded 8% SST)
Group Registration: Register 3 participants from the same organization, the 4th participant is FREE.
(Buy 3 Get 1 Free) if Register before 13 Nov 2024. Please act fast to grab your favourite training program!We hope you find it informative and interesting and we look forward to seeing you soon.
Please act fast to grab your favorite training program! Please call 012-588 2728
or email to pearl-otc@outlook.com
Do forward this email to all your friends and colleagues who might be interested to attend these programs
If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type Unsubscribe in the subject area.
We will remove your name from the list and you will not receive any additional e-mail
Thanks
Regards
Pearl
by "sump@otcmarketing.com.my" <sump@otcmarketing.com.my> - 09:11 - 13 Nov 2024 -
GRAB 3 FREE 1 !!! DEVELOPING COMPETENCIES IN COST REDUCTION AND NEGOTIATION FOR PURCHASING ( 9,10 Dec 2024)
GRAB 3 FREE 1!!!
FACE-TO-FACE PUBLIC PROGRAM
DEVELOPING COMPETENCIES IN COST
REDUCTION AND NEGOTIATION FOR PURCHASING
Venue : Hilton Petaling Jaya Hotel, Selangor (SBL Khas / HRD Corp Claimable Course)
Date : 9 Dec 2024 (Wed) | 9am – 5pm By SH Yeo
10 Dec 2024 (Thu) | 9am – 5pm .
. .
COURSE OVERVIEW:
In order to improve company profitability and ability to drive up market share, the demand for an effective and efficient procurement management is a pre requisite. Key competencies in area of cost control, applying strategic strategy to manage supplies and the negotiation of the most advantageous benefits to the company is extremely important.
This program promotes the key competencies to manage procurement and purchasing effectively by delivering the technique of managing cost saving activities and handling effective negotiation.
LEARNING OBJECTIVES:
By the end of the 14 hours by 4 session interactive online session or to 2 FULL day classroom learning, the learning curve achieve will enable the following:-
a) IDENTIFY the type of negotiation strategy to be in place to manage procurement negotiation
b) DEVELOP skills in handling difficult negotiation
c) UNDERSTAND successful negotiator techniques
d) UNDERSTAND the positive trait to develop in order to be a successful negotiator
e) IDENTIFY own and opponent strength and weakness and develop alternatives before going into negotiation
f) UNDERSTAND the correct techniques of cost reduction using the ERRANT methodology
g) DEVELOP competencies in handling cost saving and negotiation
METHODOLOGY:
This training will involve the following area to enhance learning:
a) Power point presentation
b) Case studies & Brain storming session
c) Discussion on subject of learning
d) Facilitating by trainer to enhance understanding of subject matter
e) Case study will be given to all participants on the 1st day of the class for Negotiation and Cost Reduction. Cost reduction case study to be presented by end of day 1 and Negotiation case study by end of day 2.
WHO MUST ATTEND:
This training program is highly recommended for employees involve in the managing of the supply chain function in the company, for example, personnel from procurement, warehouse, logistics and planning department and finance.
OUTLINE OF WORKSHOP
Module 1 – Cost Reduction and Cost Avoidance (4 hours session including 1 hour for case study)
- Cost Reduction versus Cost Avoidance
- Area of Cost Reduction and Cost Avoidance
- Key Factors to consider in Cost Reduction
- Opportunity cost in cost reduction activities
- ERRANT cost reduction and avoidance strategy
- Team setting for cost reduction
- EXCEL spreadsheet reporting on cost avoidance and reduction
- Break out room discussion
Module 2 - Managing Powerful Suppliers
- Problems with powerful suppliers
- Strategies to control powerful suppliers
- Bringing new value to the supplier
- Changing buying strategy
- Create new source
- Play hardball
Module 3 – Understanding Suppliers Traits and Behaviors for Negotiation
- Key suppliers traits that all buyers looking for
- The Leader
- The Innovative
- The Monopoly
- The Follower
- The Complacent
- Understanding the Negotiation Competitiveness Model
- Integrative or Distributive negotiation
- Case study
Module 4 –Key Principle of Negotiation
- What is Negotiation
- Stages of Negotiation
- 5 principles of ethical negotiation
- 7 elements of negotiation
Module 5 –Principled Negotiation
- 4 key principle of principled negotiation
- Generate Option for positive result
- How to use Objective Criteria to Present Argument
- Handling Challenges
- Getting a Yes in negotiation
Module 6 – Understanding your Alternatives
- Definition of WATNA and BATNA
- Steps to develop your alternatives
- Looking for ZOPA
Module 7 – Dealing with Offer and Rejection
- Deciding red lines in negotiation
- Understand when to walk away
- Managing Reject and counter offer
- Dealing with difficult negotiators
Module 8 – Negotiator Profile and Traits
- Negotiation Team
- The Soft Negotiator
- The Principled Negotiator
- The Hard Negotiator
- Traits of a good negotiator
- Bad Negotiator habits
- Mistakes made in Negotiation
- Body language in negotiation
- Bad Negotiator habits
- Mistakes made in Negotiation
- Body language in negotiation
- Dealing with difficult negotiators
- Break out room discussion and role ply
Module 9 - Influencing Strategy
- Why Influencing is Important
- How do you build Influence
- Positive Influencing others
- Key Sources of Influence
- Power strategy versus Influencing strategy
- 3 Rs of Influencing Strategies
- SWOT analysis
- Case study and Role Play
** Digital Certificate of attendance will be awarded for those who completed the course
ABOUT THE FACILITATOR
SH Yeo
Academic & Professional Qualifications
Certified HRDF Trainer (TTT certificate number 4669)
Certified Professional Trainer and Facilitator (University Malaya, Malaysia)
- Diploma in Human Resource Management (UK)
- Diploma in Production Management (USA)
- MBA in Supply Chain Management (USA)
- 33 year of management experience in supply chain and operation
- Trainer & consultant since 2008
Mr. SH Yeo is a very experienced supply chain and operational manager. During his working career, spanning over 33 years, he has held various positions as following:-
1987 - with International Paint (later known as Akzo Nobel International Paint) as a Storekeeper
1989 to 1992 @ Warehouse Executive
1992 to 1993 @ Warehouse Manager
1993 to 1998 @ Production Manager
1998 to 1999 @ join Melandas as a Logistics and Purchasing Manager.
1999 to 2004 @ join Dian Creative as a Material Manager
2004 to 2006 @ join Joubert SA Malaysia as Purchasing Manager
2006 to 2008 @ Procurement Manager
2008 to 2019 @ Supply Chain Manager and Company Director
His major achievements include the following:-
a) Increase productivity in the production department by providing intrinsic and extrinsic motivation to the employees from 1993 to 1998.
b) Making major decision to advise a MNC company to drop LMW warehousing scheme and adopting MITI PC1 and 2 exemption system to help company to be more competitive in the local and oversea market in 1998.
c) Co coordinating Kastam licensing and reporting to solve company reporting and licensing issue with Kastam
d) Establishing control and procedure and bringing awareness to employee on important of supply chain control in 2004 until 2019 and achieving 100% shipment performances to customers
e) Involve in negotiating with a major customer from Europe to secure new contract and beside visiting overseas suppliers for performances improvement and selection of new suppliers
f) Carry out new product development by working with engineering and design team and suppliers, including spending on site at supplier premise to solve new product design issue
g) Introduced new procedures in warehouse and operation for better control of operation and reporting system
h) Managing and conducting cost reduction management program from 2008 to 2013 and reduce cost for the company by up to RM6.5 mil.
i) Involve in managing suppliers contract and involving in proposing and drafting new contract and contract renewal for suppliers from 2008 until 2019 (early retirement) by working with suppliers and internal stakeholders with guidance from legal expert.
j) Managing Non Disclosure Agreement with suppliers to protect company intellectual property
He has been conducting training since 2008 and recently retired as a fulltime supply chain manager and company director to concentrate on full time training and coaching.
(SBL Khas / HRD Corp Claimable Course)
training Fee
2 days Face-to-Face Public Program
RM 2,250.00/pax (excluded 8% SST)
Group Registration: Register 3 participants from the same organization, the 4th participant is FREE.
(Buy 3 Get 1 Free) if Register before 27 Nov 2024. Please act fast to grab your favorite training program!We hope you find it informative and interesting and we look forward to seeing you soon.
Please act fast to grab your favorite training program! Please call 012-588 2728
or email to pearl-otc@outlook.com
Do forward this email to all your friends and colleagues who might be interested to attend these programs
If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type Unsubscribe in the subject area.
We will remove your name from the list and you will not receive any additional e-mail
Thanks
Regards
Pearl
by "sump@otcsb.com.my" <sump@otcsb.com.my> - 06:07 - 13 Nov 2024 -
How can CFOs make better decisions through carbon accounting?
Only McKinsey Perspectives
Beyond “box checking”
by "Only McKinsey Perspectives" <publishing@email.mckinsey.com> - 01:24 - 13 Nov 2024 -
Check out the latest MuleSoft product innovations from Dreamforce 2024
We're bringing Dreamforce 2024 directly to you.Live webinar
MuleSoft: Dreamforce 2024 to You
November
27 11:00 SGT
Live webinar
MuleSoft: Dreamforce 2024 to You
Register now Dreamforce 2024 is here and available to you now — with Dreamforce to You, happening on 27 November 2024, 11 a.m. SGT.
We're bringing you the latest and greatest announcements from Dreamforce, so that you can:
- Build an AI-powered composable foundation
- Tap on Agentforce's capabilities
- Integrate and automate seamlessly
- Develop orchestrated workflows
Explore the latest innovations from MuleSoft and see how a foundation of connected data is critical to the success of AI.
Speakers
Andrew Comstock
VP of Product Management
SalesforceJing Li
Senior Director of Product Management
SalesforceMofeyi Oluwalana
Senior Product Manager
Salesforce© 2024, Salesforce, Inc.
Salesforce.com 2 Silom Edge, 14th Floor, Unit S14001-S14007, Silom Road, Suriyawong, Bangrak, Bangkok 10500
General Enquiries: +66 2 430 4323This email was sent to info@learn.odoo.com
Manage Preferences or Unsubscribe | Privacy Statement
Powered by Salesforce Marketing Cloud
by "MuleSoft from Salesforce" <apacemarketing@mail.salesforce.com> - 09:02 - 12 Nov 2024 -
Simplify learn.odoo.com's global HR today with Remote.
Simplify learn.odoo.com's global HR today with Remote.
Discover the all-in-one solution for learn.odoo.com's HR challenges.Hi MD
Are you tired of juggling multiple tools just to find, hire, manage, and pay your global team? Remote brings everything into one place.
Modern businesses trust Remote to manage their globally distributed workforce—simply and compliantly.
Here’s what some of them are saying:
“Remote gives us the flexibility to build our team with the best people, without worrying about bureaucratic obstacles that slow us down.” - Sophie Brügmann, Lessmore
“Remote operates like an extension of my HR team. We’re continuously growing and operating with pace, all while staying fully compliant. Remote makes it super easy to do.” - Marisol Jimenez, Reverse Tech
5 Ways Remote Helps You Simplify
1. Global Hiring Made Simple: Hire, manage, and pay international teams with ease, thanks to our expert-supported platform.
2. One Seamless HR Solution: A unified platform with all your HR data and one point of contact to simplify everything.
3. Built-in Compliance: Remote’s tools ensure local law compliance, saving you time, money, and reducing risk.
4. Industry-Leading Global Infrastructure: Fully owned entities and banking relationships across key markets worldwide.
5. Modern, User-Friendly Platform: Streamlined workflows, real-time data, and a seamless experience your team will love.
Take the next step toward simplification
Talk with one of experts and delve into how Remote can specifically address your global HR challenges.
You received this email because you are subscribed to News & Offers from Remote Europe Holding B.V
Update your email preferences to choose the types of emails you receive.
Unsubscribe from all future emailsRemote Europe Holding B.V
Copyright © 2024 All rights reserved.
Kraijenhoffstraat 137A 1018RG Amsterdam The Netherlands
by "Remote" <hello@remote-comms.com> - 08:16 - 12 Nov 2024 -
How leaders can tap the power of vulnerability
Build trust Brought to you by Alexis Krivkovich (Alexis_Krivkovich@McKinsey.com) and Dana Maor (Dana_Maor@McKinsey.com), global leaders of McKinsey’s People & Organizational Performance Practice
New from McKinsey Quarterly
This email contains information about McKinsey’s research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to our McKinsey Quarterly alert list.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "McKinsey & Company" <publishing@email.mckinsey.com> - 02:48 - 12 Nov 2024 -
Storing 200 Billion Entities: Notion’s Data Lake Project
Storing 200 Billion Entities: Notion’s Data Lake Project
Data Modeling for Performance: Virtual Masterclass (Sponsored)͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ Forwarded this email? Subscribe here for moreData Modeling for Performance: Virtual Masterclass (Sponsored)
Get battle-tested tips from Bo Ingram, Discord Engineer and Author of ScyllaDB in Action
This masterclass shares pragmatic data modeling strategies for real-time, always-on use cases. To make the discussion concrete, we’ll teach by example with a sample restaurant review application and live monitoring dashboards.
After this free 2-hour masterclass, you will know how to:
Design a data model that takes advantage of the database’s internal architecture
Apply data modeling fundamentals and advanced strategies for performant queries
Measure and monitor the performance impact of your data modeling decisions
Spot and diagnose the manifestations of common data modeling mistakes
This is a great way to discover the strategies used by gamechangers like Discord, Disney+, Expedia, and more.
Disclaimer: The details in this post have been derived from the Notion Engineering Blog. All credit for the technical details goes to the Notion engineering team. The links to the original articles are present in the references section at the end of the post. We’ve attempted to analyze the details and provide our input about them. If you find any inaccuracies or omissions, please leave a comment, and we will do our best to fix them.
The famous productivity app Notion has witnessed a staggering 10X data growth since 2021.
At the start of 2021, they had around 20 billion block rows in Postgres. In 2024, this figure has grown to more than 200 billion blocks. The data volume, even when compressed, is hundreds of terabytes.
Moreover, all of this block data has been doubling every 6 to 12 months, driven by user activity and content creation.
Notion’s engineering team had to manage this rapid growth while meeting the ever-increasing data demands of the core product and the analytics use cases. This required them to build and scale Notion’s data lake.
In this post, we’ll take a look at the challenges Notion faced while doing so and how they overcame those challenges.
What is a Block?
Before going further, it’s important to understand the concept of “Block” in Notion.
Everything you see in the Notion editor (texts, images, headings, lists, pages, etc) is modeled as a “block” entity in the backend. The block types may have different front-end representations and behaviors. However, they are all stored in a Postgres database with a consistent structure, schema, and associated metadata.
See the diagram below for reference:
As Notion started to see data growth, its engineering team opted for sharding to scale the monolithic Postgres instance.
In 2021, the Postgres database was sharded to 32 physical instances with each instance comprising 15 logical shards.
Next, in 2023, they increased to 96 physical instances with 5 logical shards per instance.
In essence, they maintained a total of 480 logical shards while increasing the number of physical instances.
See the diagram below for reference:
In 2021, Postgres at Notion catered to online user traffic as well as the various offline data analytics and machine learning requirements. However, as the demands grew for both data needs, the Notion engineering team decided to build a dedicated data infrastructure to handle offline data without interfering with online traffic.
Build client and partner portals in 30 minutes (Sponsored)
Are your engineering teams spending months building and maintaining customer-facing dashboards and portals?
Join our 30-minute demo to see how you can:
Launch custom portals with minimal engineering resources
Build end-to-end white-labeled, beautiful apps
Add user auth and secure data access
Simplify development with multi-tenant workspaces
Hear why companies are building their products and client-facing tools with Retool: Teachable launched enterprise analytics to 1,000+ customers in just two months, while Ylopo scaled their customer portal from hundreds to tens of thousands of users in weeks by externalizing their Retool apps.
The Initial Data Warehouse Architecture
Notion built the first dedicated data infrastructure in 2021. It was a simple ELT (Extract, Load, and Transform) pipeline.
See the diagram below:
The pipeline worked as follows:
A third-party tool Fivetran ingested data from the Postgres WAL (Write Ahead Log) for all the 480 shards. In other words, there were 480 hourly-run connectors.
Fivetran sent the ingested data to 480 raw Snowflake tables.
Within Snowflake, these tables were merged into a single large table for analytics, reporting, and machine learning requirements.
There were multiple scaling challenges with this approach.
1 - Operational Difficulty
Monitoring and managing 480 Fivetran connectors (one for every shard) was a difficult job.
Activities such as re-syncing these connectors during Postgres re-sharding, upgrade, and maintenance periods created a significant on-call burden for the support team.
2 - Speed and Cost
Ingesting data to Snowflake became slower and costlier, particularly due to Notion’s update-heavy workload.
Since Notion’s primary use is note-taking and managing those notes, users update existing blocks much more often than they add new ones. This results in an update-heavy workload.
However, most data warehouses (including Snowflake) are optimized for insert-heavy workloads.
3 - Support for Requirements
Even more than the first two, the lack of support for certain requirements eventually became a more important challenge.
As Notion grew, the data transformation logic became more complex and heavy, making it difficult to handle using the standard SQL interface offered by off-the-shelf data warehouses.
For example, an important use case was to construct denormalized views of Notion’s block data for key features related to AI and Search. However, constructing permission data for a block was difficult since it wasn’t statically stored in Postgres but constructed on the fly via tree traversal computation.
See the example below:
In this example, the various blocks (block_1, block_2, and block_3) inherit permissions from their immediate parents (page_3 and page_2) and ancestors (page_1 and the workspace itself).
Permission data for such blocks can be built only by traversing the tree up to the root (i.e. the workspace). With billions of blocks, Notion found this computation very costly in Snowflake.
Notion’s New Data Lake
Due to the challenges with scaling and operating the initial data warehouse, Notion decided to build a new in-house data lake with the below objectives:
The data repository should be capable of storing both raw and processed data at scale.
Data ingestion and computation for Notion’s update-heavy block data should be fast, scalable, and cost-efficient.
Support for denormalized data that can unlock critical features like AI and Search.
The diagram below shows the high-level design of the new data lake.
The process works as follows:
Incrementally updated data is ingested from Postgres to Kafka using Debezium CDC connectors.
Apache Hudi, an open-source data processing and storage framework, writes these updates from Kafka to S3. This is the raw data.
Next, the raw data is transformed, denormalized (tree traversal and permission data construction), and enriched.
The processed data is stored in S3 again or in downstream systems to serve analytics and reporting needs.
While the final look of the design seems quite straightforward, Notion arrived at it after making several important design decisions.
Let’s look at a few of them in more detail.
1 - Choosing a Data Repository and Lake
Notion used S3 as a data repository and lake to store both the raw and processed data. Other product-facing data stores such as ElasticSearch, Vector Database, and Key-Value store were downstream of this.
Choosing S3 was a logical choice since Notion’s Postgres database is based on AWS RDS and its export-to-S3 feature made it easy to bootstrap tables in S3. Also, S3 is proven to store large amounts of data and support data processing engines like Spark at low cost.
2 - Choosing the Processing Engine
Notion engineering team chose Spark as the main data processing engine. As an open-source framework, it was easy to set up and evaluate.
There were some key benefits to using Spark:
A wide range of built-in functions and UDFs beyond SQL enable complex data processing logic like tree traversal and block data denormalization.
Existence of a user-friendly PySpark framework for light use cases and advanced Scala Spark for high-performance, and heavy data processing.
Ability to process large-scale data in a distributed manner.
3 - Incremental Ingestion or Snapshot Dump
Based on performance and cost comparisons, Notion went with a hybrid design with more emphasis on incremental ingestion.
During normal operations, they ingest and continuously apply changed Postgres data to S3.
In rare cases, they take a full Postgres snapshot once to bootstrap tables in S3.
This was done because the incremental approach ensures fresher data at a lower cost and minimal delay. For example, the incremental approach takes a few minutes to a couple of hours as compared to the snapshot dump taking more than 10 hours and costs twice as much.
4 - Streamline Incremental Ingestion
The Notion engineering team chose the Kafka Debezium CDC (Change Data Capture) connector to publish incrementally changed Postgres data to Kafka. This was done for the scalability, ease of setup, and close integration with the existing infrastructure.
For ingesting incremental data from Kafka to S3, they chose Apache Hudi. Other options on the table were Apache Iceberg and DataBricks Delta Lake. However, Hudi gave a better performance with Notion’s update-heavy workload along with native integration with Debezium CDC messages.
5 - Ingest Raw Data Before Processing
Another interesting decision was to ingest raw Postgres data to S3 without on-the-fly processing.
This was done to create a single source of truth and simplify debugging across the data pipeline. Once the data is in S3, they perform the transformation, denormalization, and enrichment. The intermediate data is once again stored in S3 and only highly clean, structured, and business-critical data is ingested to downstream analytics systems.
Solving Scaling Challenges of the New Data Lake
Since the data volume at Notion was ever-growing, the engineering team took many steps to tackle the scalability challenges.
Here are a few important ones to understand.
1 - CDC Connector and Kafka
They set up one Debezium CDC connector per Postgres host and deployed them in an AWS EKS cluster.
For reference, the diagram below shows how CDC with Debezium and Kafka works on a high level.
Also, there is one Kafka topic per Postgres table, and all connectors consuming from 480 shards write to the same topic for that table. This approach simplified downstream Hudi ingestion to S3 by reducing the complexity of maintaining 480 separate topics for each table.
2 - Hudi Setup
The Notion engineering team used Apache Hudi Deltastreamer (Spark-based) to consume Kafka messages and replicate Postgres tables in S3. They utilized COPY_ON_WRITE Hudi table type with UPSERT operation to support the update-heavy workload.
Some key optimizations were as follows:
Partitioned data using the Postgres shard scheme (i.e. 480 shards).
Sorted data based on the last updated time (event_lsn)
Set index type to bloom filter.
3 - Spark Data Processing Setup
They used PySpark for the majority of data processing jobs because of its low learning curve and accessibility to team members. For tasks like tree traversal and denormalization, they utilized Scala Spark.
A key optimization was to manage data by handling large and small shards differently. Small shards were loaded entirely into memory whereas large shards were managed through disk reshuffling. Also, to optimize runtime and efficiency, they implemented multi-threading and parallel processing for 480 shards.
4 - Bootstrap Setup
The bootstrap setup works as follows:
To bootstrap new tables, they first set up a Debezium Connector to ingest Postgres changes to Kafka.
They start the AWS RDS export-to-S3 job from a specific timestamp to save the latest snapshot of Postgres tables to S3.
Next, they create a Spark job to read the data from S3 and write them to the Hudi table format.
To maintain data completeness and integrity, all changes made during the snapshotting process are captured by setting up Deltastreamer to read Kafka messages from the specific timestamp.
Conclusion
Notion’s data lake infrastructure project development started in the spring of 2022 and was completed by the fall. It has been a huge success for them in terms of cost and reliability.
Some key benefits have been as follows:
Over $1 million in cost savings in 2022. Proportionally higher savings in 2023 and 2024.
Ingestion time reduced from 1+ day to minutes/hours
Re-sync is possible within 24 hours without overloading databases.
Accommodate Notion’s 6-12 month data doubling rate.
Enabled successful rollout of Notion AI features in the year 2023-2024.
References:
SPONSOR US
Get your product in front of more than 1,000,000 tech professionals.
Our newsletter puts your products and services directly in front of an audience that matters - hundreds of thousands of engineering leaders and senior engineers - who have influence over significant tech decisions and big purchases.
Space Fills Up Fast - Reserve Today
Ad spots typically sell out about 4 weeks in advance. To ensure your ad reaches this influential audience, reserve your space now by emailing sponsorship@bytebytego.com
Like Comment Restack © 2024 ByteByteGo
548 Market Street PMB 72296, San Francisco, CA 94104
Unsubscribe
by "ByteByteGo" <bytebytego@substack.com> - 11:38 - 12 Nov 2024 -
Enhance Your Project"
Dear,
I hope you had a fantastic day!
Are you ready to elevate your project estimating? We offer reliable cost estimating services tailored for general contractors, subcontractors, and more.
If you’d like more information or to see samples, simply reply to this email. I'm here to assist you!
Let’s work together to make your projects a success!
Best regards,
by "Kevin Osborn" <osborn.globalestimatings@gmail.com> - 10:37 - 12 Nov 2024 -
GRAB YOUR SEAT !!! POKA YOKE - YOUR ULTIMATE TOOL FOR ZERO MISTAKES AND ZERO ERRORS (16-17 Dec 2024)
Please call 012-588 2728
email to pearl-otc@outlook.com
FACE-TO-FACE PUBLIC PROGRAM
POKA YOKE - YOUR ULTIMATE TOOL
FOR ZERO MISTAKES AND ZERO ERRORS
Venue : Wyndham Grand Bangsar Kuala Lumpur Hotel (SBL Khas / HRD Corp Claimable Course)
Date : 16 Dec 2024 (Mon) | 9am – 5pm By Bala
17 Dec 2024 (Tue) | 9am – 5pm .
SYNOPSIS:
Mistakes and errors are becoming the talk of every day when something goes wrong. Industries, this elevates to high level as the number of people and number of machines are in large number. Most of the times when mistakes and errors happen, the training and awareness levels are blamed and immediate attention given to training and awareness. however this two only last for a few weeks and the scenario returns back.
In reality, training and awareness cannot eliminate mistakes and errors. This are just temporary actions that will contain problems from spreading. Training and awareness building are just like tonic drink " livita "and will last only fora short period. Therefore hoping on this two will never solve the issue of mistakes and errors.
In 1963, a Japanese statistical engineer by the name of Mr. Shigeo Shingo, proved that :
· People will makemistakes
· People can make mistakes
· Mistakes and errors are un-avoidable
In his study, he found, in-order to eliminate mistakes and errors, one should look for the potential that caused the mistake or error. By eliminating the potential we can prevent mistakes and errors from making. every mistake or error has one or many potentials that are waiting to happen. As long as this are not eliminated, the mistakes and errors are doomed to happen.
Mr. Shigeo Shingo devised a method to eliminate the potential which he named as 'Poka Yoke' that translates to" eliminate unintentional mistakes". This concept spread world wide as a formidable tool for eliminating mistakes and errors. Poka Yoke becoming a well known mistake proofing tool in all manufacturing industries.
OBJECTIVE OF PROGRAM :
Show participants
- Why people make mistakes.
- Why errors happen in machine operation.
- How to find out the potential that lead to making mistakes.
- How to establish the objectives of Poka Yoke.
- How to select the techniques.
- How to apply the detection tools.
- How use the Poka Yoke flow chart.
OUTCOME OF THE PROGRAM :
Participants will know and understand
- How to determine the potential.
- How to select the objective
- How to determine the technique.
- How to apply the detection methods.
- Practically apply the Poka Yoke flow chart
TARGET GROUP :
All Managers, Engineers, Supervisors, Technicians of Manufacturing Group.
OUTLINE OF WORKSHOP
Module 1 : Why Poka Yoke ?
- Errors and mistakes destined or created.
- Common people mistakes.
- Common equipment errors.
- Common design short comings.
- Can all errors and mistakes eliminated - activity.
Module 2 : Introduction to Poka Yoke.
- Definition of Poka Yoke.
- History of Poka Yoke.
- Concept of Poka Yoke.
Module 3 : Poka Yoke approach.
- Determine the purpose.
- Establish the technique.
- Select the detection tool.
- Poka Yoke flow chart.
Module 4 : Eliminate human induced mistakes .
- Why humans make mistakes.
- Understanding the root cause.
- Determine the purpose.
- Techniques for eliminating human mistakes.
Technique 1 : Guide pin / block method.
Technique 2 : Asymmetry principle.
Technique 3 : Counters
Technique 4 : Color codes
Technique 5 : Checklists.
Module 5 : Prevent unexpected equipment errors.
- Why errors occur in equipments.
- Understand the weaknesses.
- Determine the purpose.
- Techniques for eliminating equipment errors.
Technique 6 : contact methods
Technique 7 : contact-less methods.
Technique 8 : condition monitor methods
Technique 9 : operational changes.
Technique 10 : environment changes.
Technique 11 : error detection programs.
Module 6 : Make systems fool-proof always.
- Common system errors.
- Understanding the root causes.
- Techniques for eliminating system errors
Technique12 : asymmetry methods ( shape )
Technique13 : go - no go methods ( fitting )
Technique14 : electronic control methods
Technique15 : early warning methods
Technique16 : immediate shut down methods.
Module 7 : Evaluate Poka Yoke solutions .
- Negative box-paradigm
- Common mental blocks.
- Idea generation for Poka Yoke.
- Guidelines for idea selection.
- Golden rule of Poka Yoke- keep it simple
** Certificate of attendance will be awarded for those who completed the course
ABOUT THE FACILITATOR
MR. BALA
Mr. Bala is a training consultant with over 18 years of experience in manufacturing and 23 years in training. Mr. Bala began his career in the Equipment Maintenance function in Motorola Malaysia and grew steadily to become an Equipment Engineer. He later took on a position as Section Head for a Production Unit which he ran for several years. He moved on to Thomson Audio Electronics in Muar as a Production Manager in 1991 where he spent 2 years. Subsequently, he assumed a position as Production Manager and then as a Training and Education Manager at Samsung Electron Devices, Seremban till 1995 and then became a full-time trainer in July 1995.
Mr. Bala specializes in Equipment Maintenance, Manufacturing and Training. since becoming a manufacturing trainer, he has conducted more than 700 training sessions covering more than 14,000 participants both in-house and public programs in last 23 years. He currently is one of the most prominent maintenance consultants for theoretical and subject matter expertise. He also specializes on TPM and have conducted numerous in-house trainings for the above topic. He is one of the most prominent trainer and consultant for RCM training and consultation.
His vast experience both hands-on and conceptual training makes him a valuable resource person for maintenance Development in the Manufacturing and service sector. He was also invited to speak in Universities and in Maintenance Seminar’s and also trains hospital maintenance staff.
(SBL Khas / HRD Corp Claimable Course)
TRAINING FEE
2 days Face-to-Face Public Program
RM 2,250.00/pax
(excluded 8% SST)
Group Registration: Register 3 participants from the same organization, the 4th participant is FREE.
(Buy 3 Get 1 Free) if Register before 6 Dec 2024. Please act fast to grab your favourite training program!We hope you find it informative and interesting and we look forward to seeing you soon.
Please act fast to grab your favorite training program! Please call 012-588 2728
or email to pearl-otc@outlook.com
Do forward this email to all your friends and colleagues who might be interested to attend these programs
If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type Unsubscribe in the subject area.
We will remove your name from the list and you will not receive any additional e-mail
Thanks
Regards
Pearl
OTC Training Centre Sdn Bhd
by "sump@otcmarketing.com.my" <sump@otcmarketing.com.my> - 04:34 - 12 Nov 2024 -
GRAB 3 FREE 1 !!! BASIC GREENHOUSE GAS (GHG) ACCOUNTING, MITIGATION, AUDIT AND REPORTING TRAINING (4-5 Dec 2024)
Please call 012-588 2728
email to pearl-otc@outlook.com
FACE-TO-FACE PUBLIC PROGRAM
BASIC GREENHOUSE GAS (GHG) ACCOUNTING,
MITIGATION, AUDIT AND REPORTING TRAINING
(6 CPD Approved by EiMAS - EiMAS 2024/CPD0584/MFA)
8 CDP Points Awarded by Suruhanjaya Tenaga
(Claimable CPD MBOT : 12 Points)
Venue : Wyndham Grand Bangsar Kuala Lumpur Hotel (SBL Khas / HRD Corp Claimable Course)
Date : 4 Dec 2024 (Wed) | 9am – 5pm By Shaharuddin
5 Dec 2024 (Thu) | 9am – 5pm . .
INTRODUCTION:
Many organizations are starting to think about how to manage their greenhouse gas (GHG) emissions for a number of reasons: to minimize their impact on the planet, to prepare for regulation and address evolving disclosure requirements, to increase energy efficiency and/or to build their profile as an environmental leader. Building an inventory of your sources and emissions (eg., carbon footprint) is an essential first step to assessing risks, reducing emissions and tracking your performance.
This course aims at professionals responsible for measuring, reporting and managing carbon dioxide and other greenhouse gas (GHG) emissions for their organization. This training course will cover the basics of GHG accounting for organizations. The course materials are based on the WRI/WBCSD GHG Protocol Corporate Standard, while referring to the ISO 14064: Part 1 international standard for GHG inventories.
This course will provide you the latest information regarding GHG emissions accounting and management and focuses on areas such as: background to climate change, developing a carbon accounting system, managing GHG emissions and options for reducing GHG emissions. You will also be equipped to communicate effectively the imperative of reducing the GHG emissions with colleagues.
This training is designed to provide participants with essential understanding of carbon accounting approaches and methodologies based on ISO14064 and the GHG Protocol: Corporate Accounting and Reporting Standards. These standards besides have formed the basis of many local and international schemes, they also provide tools for industries and governments in developing their programs to reduce greenhouse gas (GHG) emissions.
OBJECTIVE:
This programme will enable participants to :-
- Understand the Greenhouse Gas Protocol’s Corporate Standard
- Understand the ISO 14064 Standard
- Enable to identify GHG sources of emissions
- Enable participants to prepared GHG calculations
- Enable participants to determine GHG mitigation
- Understand the assess GHG audit and verification processes
- Understand the learn to prepare reports
WHO SHOULD ATTEND:
Safety committees who are responsible for identifying GHG sources, prepared GHG calculations, determine mitigation, assess GHG audit processes.
LEARNING METHODOLOGY:
This training will involve the use of slides, handout material, practical tools, sharing of actual cases, Q & A and appropriate videos.
OUTLINE OF WORKSHOP
DAY ONE
9.00 am - 10.30 am
- Overview of GHG Accounting
- Introduction to GHG Accounting and Its Value to Businesses & Investors
- Terminology
- Accounting Process Overview
- Current Industry Initiatives
- Interactive Exercise 1
10.30 am - 10.45 am Tea Break
10.45 am - 1.00 pm
- The Science Behind GHG Accounting
- Why Do We Track GHG Emissions
- The Science of the GHG Effect
- The 6 GHGs, Their Impacts, and Sources
- Global Warming Potential (GWP)
- Interactive Exercise 2
1.00 pm - 2.00 pm Lunch
2.00 pm - 3.30 pm
- The Process of GHG Accounting Part 1
- Best Practices from GHG Protocol
- Defining Organizational Boundaries
- Defining Operational & Legal Boundaries
- Identifying Emissions Sources and Collecting Data
- Defining Units and Referencing Emissions Factors
- Common Pitfalls & Considerations
- Best Practices
3.30 pm - 3.45 pm Tea Break
3.45 pm - 5.00 pm
- The Process of GHG Accounting Part 2
- Purpose and Benefits of ISO 14064
Introduction of the ISO 14064-1:2006 Greenhouse gases — Part 1: Specification with guidance at the organization level for quantification and reporting of greenhouse gas emissions and removals
Introduction of ISO 14064-2:2018 Greenhouse gases — Part 2: Specification with guidance at the project level for quantification, monitoring and reporting of greenhouse gas emission reductions or removal enhancements
Introduction of ISO 14064-3:2018 Greenhouse gases — Part 3: Specification with guidance for the validation and verification of greenhouse gas assertions
DAY TWO
9.00 am - 10.30 am
- Example Scope 1 & 2 Calculations
- Interactive Exercise 3
- How to quantify and report GHG emissions
- Step-by-step inventory preparation
- Using the emission factors
- Fuel emission factors
- Stationary combustion fuel
- Transport fuel
- Biofuels and biomass
- Transmission and distribution losses for reticulated gases
- Purchased electricity, heat and steam emission factors
10.30 am - 10.45 am Tea Break
10.45 am - 1.00 pm
- Example Scope 3 Calculations & Challenges
- Interactive Exercise 4
- Fuel emission factors
- Refrigerant and other gases use emission factors
- Indirect business-related emission factors
- Travel emission factors
- Freight transport emission factors
1.00 pm - 2.00 pm Lunch
2.00 pm - 3.30 pm
- GHG Accounting in Corporations & Emissions Reports and Current State of GHG Accounting
- Why Corporations Should Measure GHG Emissions
- Investment Context Use Cases - Mandates & Compliance
- GHG Reductions & Planned Impact (Scope 4 Emissions)
3.30 pm - 3.45 pm Tea Break
3.45 pm - 5.00 pm
- Producing a GHG report
- Interpreting Emissions Reports
- Additional Tools & Resources
- Qualified Assessment
- Verification Procedure with Third Party
** Certificate of attendance will be awarded for those who completed the course
ABOUT THE FACILITATOR
MR MOHD SHAHARUDDIN
- Diploma in Industrial Chemistry, UiTM.
- BEng (Hons) Chemical Engineering, Univ. South Wales, UK
- Master of Environment, UPM
- Certified PSMB Trainer (Exemption)
Shaharuddin is an HSE Consultant and Trainer with more than 22 years of industrial related working experience. He specializes in providing training and consultancy services, especially in Dangerous Goods, Hazardous Chemicals, Hazardous Wastes, Process Plant Safety, Industrial Hygiene and Environmental Management. His HSE consultancies services covering various type of industries such as in oil & gas industries, chemical specialty plant, plastic & rubber based industry, automotive industries, pulp & paper manufacturing, woodworking industries, electroplating and electronic plant, steelmaking industries, food & beverage industries, paint manufacturing, construction industries, healthcare industries, utilities provider for water & wastewater treatment plant ,solid waste management company and an off-site facility for treatment and disposal of scheduled wastes.
Shaharuddin has experience as a registered Safety & Health Officer and as a Competent Person for Monitoring of Noise Exposure at Work with DOSH. He has involved in Dangerous Goods, Hazardous Chemicals or Scheduled Waste towards compliance program under the USECHH 2000 Regulation, UN Dangerous Goods Legislation and Scheduled Waste Regulation. He had a vast experience as a DOSH registered Assessor for Chemical Health Risk Assessment and also as an Industrial Hygiene Technician I & II, both for Testing and examination of Local Exhaust Ventilation and Chemical Exposure Monitoring. With these multiple industrial hygiene competencies, he had successfully conducted a great numbers of hazardous chemical assessment and monitoring projects throughout Malaysia. As a registered trainer with HRDF and DOSH, Shaharuddin has been actively conducting training on HSE particularly on Safe Handling of Hazardous Chemical/Dangerous Goods and Scheduled Waste Management. He has wide experience in conducting training and providing ISO consultancy to guide companies in implementing ISO 14001, OHSAS 18001 ,Carbon Footprint Assessment , Green Productivity Assessment, Life Cycle Assessment and Cleaner Production Program, for various types of industries in Malaysia. He also involve in giving training and consultancy to industries using chemicals in Chemical Management for Product Stewardship Program to comply with International Chemical Laws such as REACH, WEEE and RoHS.
Academically, Shaharuddin hold Diploma in Industrial Chemistry from UiTM. He also holds Bachelor Degree in Chemical Engineering ( Majoring in Process Safety, Environmental & Energy Management) from University of Glamorgan, Wales, UK and Master of Environmental Science from UPM with Project on Hazardous Chemical Management. He also holds Certificate in Indoor Air Quality Assessor from NIOSH, Certificate in Green Building Index Facilitator from Malaysia Green Building Council, Certificate of Green Productivity Trainer & Consultant from Asian Productivity Centre, Japan , a Certificate of Green Industry Auditor & Certificate of Environmental Auditor from Department of Environment, Malaysia and a Certificate of Energy Management System from UNIDO, and a Certificate in Z50 Green Technology Compliance – ILO-CIAST.
(SBL Khas / HRD Corp Claimable Course)
TRAINING FEE
2 days Face-to-Face Public Program
RM 2,250.00/pax
(excluded 8% SST)
Group Registration: Register 3 participants from the same organization, the 4th participant is FREE.
(Buy 3 Get 1 Free) if Register before 22 Nov 2024. Please act fast to grab your favourite training program!We hope you find it informative and interesting and we look forward to seeing you soon.
Please act fast to grab your favorite training program! Please call 012-588 2728
or email to pearl-otc@outlook.com
Do forward this email to all your friends and colleagues who might be interested to attend these programs
If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type Unsubscribe in the subject area.
We will remove your name from the list and you will not receive any additional e-mail
Pearl
OTC Training Centre Sdn Bhd
by "pearl@otcsb.com.my" <pearl@otcsb.com.my> - 02:15 - 12 Nov 2024 -
How can aviation leaders boost production of sustainable fuels?
Only McKinsey Perspectives
Evolving demand for greener energy Brought to you by Alex Panas, global leader of industries, & Axel Karlsson, global leader of functional practices and growth platforms
Welcome to the latest edition of Only McKinsey Perspectives. We hope you find our insights useful. Let us know what you think at Alex_Panas@McKinsey.com and Axel_Karlsson@McKinsey.com.
—Alex and Axel
•
Sustainable fuels’ potential. As organizations take steps to reduce their effects on the climate, leaders are increasingly considering the potential of sustainable fuels—rather than the fossil fuels that contribute to the rapid warming of our planet. For instance, as McKinsey partners Axel Esqué and Daniel Riefer and coauthor Geert Mulder highlight, the SAFs already certified for use in today’s jet engines produce about 80% fewer greenhouse gas emissions than traditional jet fuel.
•
Rising demand. Even though some sustainable-fuel industries are still emerging, McKinsey research projects significant growth for most sustainable fuels—other than clean hydrogen—by 2030. In fact, by 2050, McKinsey expects the demand for sustainable fuels to quadruple, and that sustainable fuels could account for as much as 37% of all energy used in the transportation sector. Read our McKinsey Explainer to learn how aviation stakeholders could help accelerate sustainable-fuel production, and visit our McKinsey at COP29 page to explore our events at the UN’s 2024 climate change conference.
—Edited by Belinda Yu, editor, Atlanta
This email contains information about McKinsey's research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to the Only McKinsey Perspectives newsletter, formerly known as Only McKinsey.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "Only McKinsey Perspectives" <publishing@email.mckinsey.com> - 01:28 - 12 Nov 2024 -
Download zip code data
Download zip code data
Hi MD Abul,
It seems you did register for our 30-day free trial of our Data Explorer already. Curious to understand, in which ways location data is important for you/useful for you?
Maybe you need more time to explore our data, feel free to ask for a trial extension. You will find additional data: 247 countries, 8.7 million zip codes, 3.330.478 cities/localities - 306.000 administrative divisions.
In case you did not find what you were looking for, would you like to talk to an expert?
We are interested in understanding your use case and helping you with geodata.
Best wishes,
Quentin RichelleLocation Data Team+32 472 39 43 17quentin.richelle@geopostcodes.com-------------------------GeoPostcodes.comThe most comprehensive postal database in the worldGeoPostcodes, Bld Bischoffsheim 15, 1000 Bruxelles, Belgium
by "Quentin Richelle" <quentin.richelle@geopostcodes.com> - 06:25 - 11 Nov 2024 -
Sixty years of innovation: Key moments in business technology
Explore the interactive New from McKinsey Quarterly
Access the interactive with a free digital Quarterly membership, which in this commemorative year includes special issues, bonus digital features, and classic articles previously available only in print. Plus, get past digital Quarterly issues and downloads of our 100 most important reports in The McKinsey Insights Store.
This email contains information about McKinsey’s research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to our McKinsey Quarterly alert list.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "McKinsey & Company" <publishing@email.mckinsey.com> - 02:20 - 11 Nov 2024 -
Proposal for Backlink Services by Infinity digital software house
🙋Hello Dear,
I'm an SEO expert and a high authority guest post provider. Are you want to promote your website or want to rank on google,no need for further search
Here you will get google news sites guest posts with permanent do-follow backlinks .
For getting the first position, you need to get high authority guest posts with do-follow backlinks.
Google news approved site is trusted by google. Getting top quality backlinks from google is a million times better than other sites.
We will publish high DA Guest posts on the DA 50 - 50 website with do-follow backlinks.
The backlinks would be permanent and it will be indexed in Google.
Note:
I have many sites for any category
I have many sites that will suit your budget
Let me know I have to wait for your response
Best Regards
by "Sandra Jennifer" <sandrajennifer7778@gmail.com> - 01:20 - 11 Nov 2024 -
SAFE HANDLING OF HAZARDOUS CHEMICAL & CHEMICAL SPILL TRAINING - 1 Day Program
SAFE HANDLING OF HAZARDOUS CHEMICAL & CHEMICAL SPILL TRAINING
This program can be specially tailored and customized to meet your training objectives
Kindly find above attached for the full brochure for this program
We hope you find it informative and interesting, and we look forward to seeing you soon
(SBL Khas / HRD CORP Claimable Course)
1 Day In-House Program By Gadafi
INTRODUCTION:
The handling of hazardous chemicals in workplaces poses significant risks to the health and safety of employees. The Department of Occupational Safety and Health (DOSH) Malaysia enforces strict guidelines to ensure that hazardous chemicals are managed in a safe and responsible manner. This includes chemical labeling, proper storage, risk assessment, exposure control, and employee training under the Occupational Safety and Health (Use and Standards of Exposure of Chemicals Hazardous to Health) Regulations 2000 (USECHH 2000).
PROGRAM OBJECTIVE:
1. Ensure Compliance with DOSH Regulations: Align workplace chemical management practices with Malaysia's USECHH Regulations, particularly focusing on CHRA and chemical control measures.
2. Promote Health and Safety Awareness: Educate employees on the potential hazards posed by chemicals and the importance of safety practices to mitigate these risks.
3. Minimize Workplace Incidents: Reduce accidents, injuries, and occupational diseases resulting from improper chemical handling, exposure, or spillage.
4. Implement Safe Work Practices: Establish safe procedures for handling, storage, and disposal of hazardous chemicals, ensuring minimal risk to employees and the environment.
5. Encourage Use of Personal Protective Equipment (PPE): Emphasize the importance of using PPE when working with hazardous chemicals to reduce direct exposure and related health effects.
WHO SHOULD ATTEND:
· Employer / Senior Manager / Human Resource Manager / Executive directly involved with workplace-related legal responsibilities.
· Occupational Safety and Health Manager / Occupational Safety and Health Officer / Occupational Safety and Health Coordinator.
· OSH Practitioner / OSH Committee Member.
· Supervisors and employees.
Day 1: 9.00am to 5.00pm
Session 1: Introduction to Hazardous Chemicals and Legislation
· Definition and types of hazardous chemicals
· Sources of hazardous chemicals in the workplace
· Overview of OSHA 1994 and USECHH Regulations 2000
· Compliance with Chemical Health Risk Assessment (CHRA)
· Environmental Quality Act 1974 (Scheduled Wastes) and management of chemical wastes
· Overview of Globally Harmonized System (GHS) for classification and labeling
Session 2: Chemical Safety Data Sheets (SDS)
· Understanding the sections of SDS
· Legal requirements for SDS in Malaysia
· How to interpret SDS for safe handling
· GHS-compliant labeling
· Workplace labeling and signage requirements
· Practical session: Interpreting SDS and labeling
Session 3: Practical Demonstration
· Demonstration of proper PPE use for chemical handling
· Hands-on practice in chemical storage and labeling
Session 4: Chemical Spill Containment and Cleanup
· Components of a chemical spill kit
· How to use absorbents, neutralizers, and containment barriers
· Spill kit inspection and maintenance
· Step-by-step guide for handling small and large spills
· Isolating the area, ventilation, and evacuation procedures
· Practical session: Spill containment and use of spill kits
ABOUT THE FACILITATOR
GADAFI is a highly qualified technical trainer in the areas of Engineering, Health, Safety, and Environmental. He believes in interactive, and fun filled training. His method of training is sharing rather than lecturing. With 14 years of experience in the field of Manufacturing Improvement & Project Management covering areas of Design, Product Formulation, Process Engineering, Production and Supply Chain Management, Lean Manufacturing, 5S Management, Process Safety, Risk Assessment and Management, Environmental Impact and Assessment, Gadafi uses lots of real-life examples. Graduated as a Bachelor of Chemical Engineering from Universiti Malaysia Pahang, give an extra edge to him to understand the basic concept of Engineering concept, technical knowledge especially in design and process safety management. Gadafi started his career in 2010 as a Technical Engineer and in 14 years, has worked in 4 MNC companies that are World Class, i.e. Agrifert (Malaysia), COESIA (Italy), Safran (France) and Grobest (Taiwan) up to the level of a Group Corporate HSE Manager. Ahmad is an accredited HRD Corp trainer. His strength is combining the theoretical, practical concept and details of HSE training with highly example anecdotes for maximum training effectiveness.
AMONG HIS NOTABLE ACHIEVEMENTS ARE:
1. Certified Safety and Health Officer – JKKP Malaysia
2. Authorized Gas Tester and Entry Supervisor – JKKP Malaysia
3. Accredited Trainer – HRD Corp
4. Lead Auditor - ISO 45001:2018 OHS Management System
5. Certified Environmental Professional in Scheduled Waste Management Malaysia DOE Registration No: CePSWam/201070
6. Certified Environmental Professional in Scrubber Operation DOE Registration No: CePSO/2112175
7. Professional Technologist (PT22040143) – MBOT Malaysia
8. Member of Institute of Engineer Malaysia (IEM)
9. Member of Board of Engineer Malaysia (BEM)
AMONG HIS NOTABLE IMPROVEMENTS PROJECTS ARE:
1. Group HSE Contract Management Protocol December 2020
Successfully develop the Group HSE Contract Management Protocol; all practicable steps to manage hazards and risks as early as possible before the issuance of the contract. The protocol specifies all OSH requirements, roles and responsibilities of client and contractor, interfaces, and manner in which all OSH hazards and risks should be managed at every stage of the contract.
2. Completion of EIA requirements April-October 2021
Managed to complete all the requirements under the EIA for five (5) operation plant in Malaysia; Sandakan, Klang, Pasir Gudang, Lahad Datu, and Bintulu; activities such as Written Notification and Approval for Local Exhaust Ventillation (LEV), Genset, Chimney system, Environmental Monitoring for water, air, noise, Environmental Audit.
3. Yearly Project (Jan-Nov 2022)
To lead Malaysia site (FlexLink Engineering Sdn. Bhd.) for the certification of ISO 45001 and ISO 14001. Responsible to ensure legal requirements related to HSE being complied by company, training will be conducted to staffs, procedures in place and documentation maintained properly.
4. Gold Standard EHS Audit Safran Group – Bereau Veritas – June 2022
Lead the site team as a Management Representative (MR) for the Group Yearly EHS Audit and achieved a Gold Standard level. The Audit was conducted by third party auditor from Bereau Veritas. The Safran EHS Standard which is equivalent to ISO 45001 and ISO 14001.
5. Registration of PMA & PMT Equipment with DOSH – July 2022
Successfully managed to register 63 unit of equipment’s to DOSH Negeri Sembilan under the PMA and PMT requirements.
6. AXA XL Gaps Audit for Fire Safety System – May 2022
Successfully improved the performance of AXA XL Gap audit specifically for the Fire Safety requirements by the group level from 70% in 2021 to 75% in 2022.
7. Lead Auditor for Group HSE Audit for India site – October 2023.
Responsible for preparation of audit plan, site inspection, opening and closing meeting, daily debriefing, and final HSE Audit report for Executive Chairman
We hope you find it informative and interesting, and we look
forward to seeing you soon.
Please act fast to grab your favourite training program! Please call 012-588 2728
or email to pearl-otc@outlook.com
Do forward this email to all your friends and colleagues who might be interested to attend these programs
If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type
Unsubscribe in the subject area. We will remove your name from the list, and you will not receive any additional e-mail
Thanks
Regards
Pearl
OTC Training Centre Sdn Bhd
by "pearl@otcsb.com.my" <pearl@otcsb.com.my> - 11:53 - 11 Nov 2024 -
Leadership lessons from veterans
Honor and remember New from McKinsey & Company
Why are veterans so valuable to the workforce? Gain deeper insights into the unique skillsets they bring to the table. Revisit a conversation between McKinsey’s Aaron De Smet and Adria Horn, an army veteran and Tilson executive, on the unexpected similarities between reintegrating into civilian life after deployment and navigating the workplace after crisis. And watch senior partner Scott Blackburn’s interview with Nate Boaz, Marine Corps veteran and Microsoft executive, whose leadership and passion for helping others continued in postmilitary life. Then explore more insights to learn about the many contributions veterans make in leadership positions and across all levels of the workforce.
MORE FROM MCKINSEY
To see more essential reading on topics that matter, visit McKinsey Themes.
— Edited by Esther Chung, editor, Atlanta
This email contains information about McKinsey’s research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to our McKinsey Quarterly alert list.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "McKinsey & Company" <publishing@email.mckinsey.com> - 10:53 - 11 Nov 2024 -
A leader’s guide to steering effective transformations
Leading Off
Marry vision with strategy Brought to you by Alex Panas, global leader of industries, & Axel Karlsson, global leader of functional practices and growth platforms
Welcome to the latest edition of Leading Off. We hope you find our insights useful. Let us know what you think at Alex_Panas@McKinsey.com and Axel_Karlsson@McKinsey.com.
—Alex and Axel
Given the breakneck pace of change in the business world, many leaders are wrestling with how to transform their organizations and secure their longer-term future. Business transformations can involve many factors, such as developing new capabilities or products, adopting new technologies, and inspiring employees to embrace changes in the ways their organizations operate. It’s a daunting challenge: McKinsey research shows that less than one-third of transformations meet their goals of both improving organizational performance and sustaining those improvements over time. This week, we explore a few approaches and insights that can help make transformations successful.
Real transformative change goes beyond restructurings or short-term solutions to boost efficiency. It’s about reprogramming an organization’s DNA, according to McKinsey’s Kevin Carmody, Louisa Greco, and Rob Montgomery. They say that the road map to a successful transformation should begin with leaders identifying a strategic “true north” and articulating a bold aspiration for what their company wants to become. This aspiration should then determine a sequence of steps across four work streams: cost optimization, growth, organizational effectiveness, and digital enablement. By embedding their new strategy into day-to-day operations, leaders can establish their transformations as the new business as usual rather than a side project. “When done right, a transformation becomes a source of continual renewal, evolving and even revolutionizing a business over a series of horizons,” the authors say.
That’s how much more likely midsize companies are to execute successful transformations if they involve a broad cross section of employees in the effort. Midcap companies, or those with $200 million to $2 billion in revenue, are only half as productive as large companies. Senior partner Mauricio Janauskas and his coauthors say that “transformation is an imperative” for these companies to catch up with higher-performing competitors. Midsize businesses face resourcing challenges in a range of areas: limited leadership benches, access to capital, and change-management experience, for example. But midcaps can also have advantages over bigger companies in transformations, including greater agility, faster decision making, and loyal, long-term employees who are willing to take on new roles. The authors note that investing in talent early and cultivating an owner mindset among employees are two critical ways that midcaps can reap the full benefits of transformations.
That’s McKinsey senior partner Chris Hagedorn on the use of M&A as a launchpad for transformation in an episode of McKinsey’s Inside the Strategy Room podcast. Hagedorn and partner Alex Liu say that some deals can provide transformation opportunities when executives are under pressure to create more value. One factor for leaders to consider is how a transaction might help them transform their customer strategies. “If you’re trying to access a whole new base of customers, perhaps through a new channel, or you’re thinking about creating an entirely new set of offerings, that would be another marker of transformation because your company’s going to have to do vastly different things,” Liu says.
When he took the helm of the iconic brand, Rolls-Royce CEO Tufan Erginbilgiç realized he needed a strategy for reinventing the 120-year-old manufacturer. In a conversation with McKinsey senior partner Michael Birshan, Erginbilgiç says transformation starts with the understanding that strategic goals aren’t just numbers. They must be translated into clear, relevant initiatives and relentlessly reinforced to give employees direction and purpose. To transform Rolls-Royce, Erginbilgiç emphasized culture change, empowering employees to feel ownership of their roles in turning around the company. “My view is you need to be very consistent—consistent expectations, consistent reinforcement. And use every opportunity possible for performance management,” he says. “You need to continually tell people what good looks like so that there’s a learning process. That’s what changes culture.”
For some companies, transforming their core business may not be enough to achieve sustained growth in the face of new competition, economic disruptions, and other changes in the market landscape. According to McKinsey senior partners Ari Libarikian and Chris Hagedorn and colleagues, those companies can consider building new businesses at the same time to extend their longevity and help them outpace competitors. The value created through a transformation, whether through cost cutting or cash management, can help fund a new business venture. And such new ventures are more than eight times likelier to scale than start-ups, thanks to the advantages of a parent company’s resources and competencies. “The opportunities that emerge when marrying transformation with business building can be powerful,” the authors say.
Lead by developing your transformation strategy.
— Edited by Eric Quiñones, senior editor, New York
Share these insights
Did you enjoy this newsletter? Forward it to colleagues and friends so they can subscribe too. Was this issue forwarded to you? Sign up for it and sample our 40+ other free email subscriptions here.
This email contains information about McKinsey’s research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to the Leading Off newsletter.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "McKinsey Leading Off" <publishing@email.mckinsey.com> - 04:49 - 11 Nov 2024 -
How can leaders ensure that carbon markets effectively address climate change?
Only McKinsey Perspectives
A McKinsey Explainer on decarbonization Brought to you by Alex Panas, global leader of industries, & Axel Karlsson, global leader of functional practices and growth platforms
Welcome to the latest edition of Only McKinsey Perspectives. We hope you find our insights useful. Let us know what you think at Alex_Panas@McKinsey.com and Axel_Karlsson@McKinsey.com.
—Alex and Axel
•
Rising demand. As COP29 kicks off in Azerbaijan, world leaders are focusing on mitigating the effects of global warming. Decarbonization—the removal of carbon dioxide from the atmosphere and the reduction of carbon dioxide and other greenhouse gases that are released into it—is a key response to climate change. With a growing number of companies turning to carbon markets to curb their carbon footprints, the demand for carbon credits is expected to increase 15 times by 2030 and 100 times by 2050, McKinsey partner Sean Kane and associate partner Charles Riesenberg reveal.
•
Getting carbon markets right. Through voluntary carbon markets, companies that make net-zero commitments frequently purchase carbon credits to offset their greenhouse gas emissions. According to McKinsey senior partner Badrinath Ramanathan, voluntary carbon markets are “still nascent”; to contribute effectively to climate action, they need to be significantly scaled. Read our McKinsey Explainer, “What is decarbonization?,” for six ways that organizations can create more certainty in carbon markets, and learn more about McKinsey’s role at the 2024 UN climate change conference.
—Edited by Belinda Yu, editor, Atlanta
This email contains information about McKinsey's research, insights, services, or events. By opening our emails or clicking on links, you agree to our use of cookies and web tracking technology. For more information on how we use and protect your information, please review our privacy policy.
You received this email because you subscribed to the Only McKinsey Perspectives newsletter, formerly known as Only McKinsey.
Copyright © 2024 | McKinsey & Company, 3 World Trade Center, 175 Greenwich Street, New York, NY 10007
by "Only McKinsey Perspectives" <publishing@email.mckinsey.com> - 01:27 - 11 Nov 2024 -
GRAB 3 FREE 1 !!! LIVE ONLINE PROGRAM-USEFUL EXCEL FORMULAS AND FUNCTIONS (9 &10 Dec 2024)
LIVE ONLINE PROGRAM
USEFUL EXCEL
FORMULAS AND FUNCTIONS
8 CPD Points Awarded by MBOT.
Venue : Online Training (Via Zoom) ( SBL KHAS / HRD Corp Claimable Course)
Date : 9 Dec 2024 (Mon) | 9am - 5pm By Siti
10 Dec 2024 (Tue) | 9am - 5pm .
.
INTRODUCTION
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
Every function has the same structure. It's not easy to remember which function and which arguments to use for each task. Fortunately, the Insert Function feature in Excel helps you with this.
BENEFIT
-At the end of this course you will have a greater understanding of building complex formulas using nested functions (such as IF statements).
-You will find quicker ways to customise formulas by taking advantage of the built-in functions available in Excel. Save time by learning more sophisticated search & auditing techniques when working with data-heavy spreadsheets.
WHO IS THIS COURSE FOR?
Our Microsoft Excel Formulas course is suitable for those with an advanced working knowledge of Excel who want a greater understanding of more sophisticated formulas & functions within Excel.
You may also wish to consider one of our finance for non financial managers courses.
OUTLINE OF WORKSHOP
1.0 Building complex formulas
- Using nested IF statements
- Creating compound logical tests using AND, OR, NOT functions with IF statements
- Nesting LOOKUP functions
- Source table structure information using CHOOSE function
- Using MATCH function to locate data
- The INDEX function for retrieving information by location
- Using a nested formula containing INDEX, MATCH and MATCH (two-way lookup)
2.0 Advanced functions in formulas
- Using COUNTIFS, SUMIFS & AVERAGEIFS for tabulating data based on single/multiple criteria
- Statistical functions; MEDIAN, MODE, RANK, LARGE, SMALL, ROUND, MOD
- AGGREGATE function to sum data in ranges with errors
- Use a variety of Financial functions such PMT, FV, IRR
3.0 Data & Text Functions
- Smarter ways to calculate date & time; TODAY
- NETWORKDAYS, WORKDAY, DATEDIF
- Use TYPE to identify data type of existing cell contents
- Text functions; UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, LEN
- TRIM excess space in cells
4.0 Introduction to Array formulas
- Using embedded Excel Array formulas
- Create an Array formula
5.0 Auditing formulas
- Tracing formula precedents, dependents, and errors
- Correcting errors in formulas
- Combining IF with VLOOKUP to suppress error messages
- Using the IS information function
- Error checking functions; ISERR, ISERROR, IFERROR
** Digital Certificate of attendance will be awarded for those who completed the course
ABOUT THE FACILITATOR
Siti
Microsoft Office Specialist (MOS)
Siti started her career as an Information Technology Lecturer in few local colleges and universities back in year 1999. In her 8 years’ experience as a lecturer, she picks up various discipline in IT related subjects. She also involved in giving Microsoft Office Applications training to various companies.
Since 20 March 2006 till present, Siti Suriani decided for a career change. She moved to IT related training. As a Training Consultant, she focused more on Microsoft Office Applications training. She has facilitated training programs in link with broad-ranging groups of training institutes and clients. She is familiar and proficient with Microsoft Office Applications and during her training she will address the day to day issues faced by employees in today’s corporate environment.
In year 2007 till 2008 Siti Suriani had been appointed as one of the Master Trainer for The Teaching and Learning of Science and Mathematics in English (Pengajaran dan Pembelajaran Sains dan Matematik Dalam Bahasa Inggeris - PPSMI). Her role as a Master Trainer was to give training to all the trainers representing different states around Malaysia on how to deliver the training to all the teachers in various schools in Malaysia.
Aside to giving training, Microsoft Malaysia has engaged her to share her expertise on how to fully maximize the usage of Microsoft Office Applications since year 2008 till current. She had done many workshops around Malaysia for major Microsoft Malaysia customers mostly focusing on the Tips and Tricks and also best practices.
Siti was involved as a Handyman in Handyman Project under Shell Global Solutions, Malaysia since 2008 till 2011. To be given the opportunity to give One-to-one consultation with the client by looking, asking and solve problem related to the data provided by the clients. Examples of topics covered for Handyman sessions are E-mail and Calendar, Standard & Mobile Office, Archiving & Back-ups, NetMeeting, Livelink, Live Meeting? and Microsoft Office Applications.
Nov 2010 to Feb 2011 she was being given another golden opportunity by ExxonMobil Malaysiato be the lead trainer in the Migration from XME to GME project to train almost 3000 staffs. This training also includes Microsoft Office 2010 and Windows 7.
Academic Qualification
1999 – Bachelor of Computer Science (Honours) · Computing (Single Major) - USM
2001 – Master of Science · Distributed Computing - UPM
Working Experience
- Cybernetics International College of Technology · Lecturer · (June 1999 to May 2002)
- MARA University of Technology (UiTM Seri Iskandar) · Lecturer · (June 2002 to July 2003)
- Cosmopoint College of Technology · Lecturer · (September 2005 to March 2006)
- Iverson Associates Sdn Bhd · Senior Training Consultant · (March 2006 to February 2011)
- Info Trek Sdn Bhd · Senior Training Consultant· (February 2011 to April 2017)
- Fulltime Senior Training Consultant · (May 2017 to present)
Professional Certification
- Microsoft Certified Application Specialist for Office Excel 2007
- Microsoft Certified Application Specialist for Office PowerPoint 2007
- Microsoft Certified Application Specialist for Office Word 2007
- Microsoft Office Specialist for Office Excel 2016
- Microsoft Office Specialist for Office Word 2016
- PSMB Certified Trainer
( SBL KHAS / HRD Corp Claimable Course)
Online training Fee
14 hours online training
RM 1,296.00/pax (excluded 8% SST)
Group Registration: Register 3 participants from the same organization, the 4th participant is FREE.
(Buy 3 Get 1 Free) if Register before 29 Nov 2024. Please act fast to grab your favorite training program!We hope you find it informative and interesting and we look
forward to seeing you soon.
Please act fast to grab your favorite training program! Please call 012-588 2728
or email to pearl-otc@outlook.com
Do forward this email to all your friends and colleagues who might be interested to attend these programs
If you would like to unsubscribe from our email list at any time, please simply reply to the e-mail and type Unsubscribe
in the subject area. We will remove your name from the list and you will not receive any additional e-mail
Thanks
Regards
Pearl
by "pearl@otcmarketing.com.my" <pearl@otcmarketing.com.my> - 08:57 - 10 Nov 2024