Negotiation Skills - Professional 1 Day Workshop in Hamilton, UK
Managing Performance 1 Day Workshop in Airdrie
Negotiation Skills - Professional 1 Day Workshop in Airdrie
About this Training Course The Oil & Gas E&P industry is evolving from deep sea exploration to renewable sources of energy through windfarms and solar fields offshore. In tandem, OSBs will need to evolve for sustainability and revival from stagnant traditional Supply Base Models. The changing role of OSBs is toward support services for decommissioning projects and LNG Floating Terminals. In addition, the new geographical regions of East and South Africa are coming up at a faster pace. All such operations are dependent upon a complex network of transport and supply in order to deliver the staff, materials, machinery, and crew provisions where and when needed. This 3 full-day course is curated to enhance the skills and competencies of passionate professionals to plan and organise resources, minimise turnaround time for the vessels engaged in support of Offshore E & P operations. Various hands-on exercises can equip the participants to implement viable and feasible approaches for safe and efficient management of OSBs in compliance with continuously evolving international best practices and Oil & Gas standards. This course is specially developed for investors, business owners, senior executives and professionals from the offshore & marine logistics industry, with the following objectives: To provide a firm understanding about the role of an Offshore & Marine Supply Base in support of Oil & Gas E & P fleet operations, in contrast with traditional merchant shipping logistics. To provide an in-depth knowledge about the range and diversity of services being offered by Offshore & Marine Supply Bases ('OSB') in the target regions. To equip with the knowledge and information required for taking investment decisions when venturing in Offshore E & P Sector. To introduce contemporary techniques and tools required to identify target customer segments while developing a new OSB or expanding operations of an existing OSB. To elaborate comparative management methodologies for OSB facilities and services management, based on deployment of ICT solutions so as to deliver value added services to the customers. To learn to identify methodologies for sales and distribution of services to the customers and non-paying users of the OSB. To identify relevant state legislation for licensing & governing an OSB, and enforce through contractual obligations, rights and responsibilities of the parties as clients of an OSB. To develop and implement Business Processes with built-in Performance Evaluation Metrics for achieving competitive advantage over the peers in the OSB segment. To develop and implement integrated OSB's Risk Management framework. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives Upon completion of this course, the participants will be able to: Implement and comply with the QHSSSE regulations and national or Port Controls regime for safe handling of import & export cargo and movements of the vessels. Establish role and responsibilities of the Offshore Supply Base management team. Plan and organise resources so as to minimise turnaround time for the vessels engaged in support of Offshore E & P and Windfarms operations. Plan and organise OSB cranes, vehicles, MHE, spaces and relevant facilities for storage, movement, and custody transfer of various types of solid and liquid cargo, tools, shackles, bulk materials in open yards and ships' gears. Be aware of potential emergency situations and how to respond and coordinate with relevant internal and external agencies. Manage safety of personnel of sub-contractors, stevedores', tenants, and ship crew, when engaged in OSB operations. Differentiate between various ships, technical and functional characteristics, safety requirements and potential hazards of each operation. Build competency in developing and maintaining documentary evidence for traceability for all works executed during the specific period or operation. Develop techniques for performance monitoring and continuous improvements based on lessons learned from each operation at the Base as well as from reports about peers in the similar business. Target Audience This course is intended for: Operations Management personnel from existing OSBs, Ports, Logistics & Warehouses, Offshore Fields, E & P Infrastructure Support services providers. Professionals who are interested in OSB segment of the Offshore & Marine Oil & Gas Industry. Participants who have no prior knowledge about OSB Operations and are new to the Offshore Logistics And highly recommended for: Managers, Engineers, and Professionals assigned to lead new initiatives in Logistics Management of Offshore & Marine Segments of Oil & Gas Industry. Course Level Intermediate Trainer Principal Management Consultant Chartered Valuer and Appraiser (CVA) FACICA | FAMTAC | FAIADR | M.S.I.D | Member, AIEN LL.M. (IP Law), M. Sc. (Maritime Studies), M. Tech (Knowledge Engineering), MBA, First Class CoC (MCA, UK), B. E. (Elect) Your expert course leader during the last 47 year period, has worked and consulted in the industry verticals encompassing: Technology, Oil & Gas Exploration & Production, Petrochemical Process Plants and Power Plant Construction Projects, Logistics & Warehousing, Marine, Offshore, Oil & Gas Pipelines, Infrastructure Development Projects (Ports, Offshore Supply Bases, Oil & Gas Terminals and Airports etc), EPCIC Contracts, and Shipyards, in South East Asia, Africa, Middle East, Americas and Europe. He serves as the Principal Management Consultant with a management consultancy in Hong Kong and Singapore, specialising in the fields of corporate management consultancy, international contracts reviews and alternative dispute resolutions services. He undertakes special assignments for conducting audits and valuation of intangible properties involving proprietary processes for licensed production, and licensing of intellectual property rights (IP Rights) in patents, trademarks, and industrial designs. He is frequently engaged for assignments like due diligence, acquisitions, mergers, resolving various operational issues, technology transfer and agency services contracts reviews, cost controls, and enhancement of Supply Chain Management. He has been conferred the credentials of Chartered Valuer & Appraiser (CVA) by SAC and IVAS, in accordance with the international valuation standards setting body IVSC. His consulting experience includes Charterparty Management, Business Process Re-engineering, Diversifications, Corporate Development, Marketing, Complex Project Management, Feasibility Studies, Dispute Resolutions and Market Research. He has successfully assisted Marine and offshore E & P clients in managing contractual disputes arising from various international contracts for upgrading & conversion projects. He continues to be actively engaged in claims reviews, mediation, arbitration, litigation, and expert witness related assignments, arising from international contracts and Charterparty Agreements. He graduated with a Bachelor's degree in Electrical Engineering, MBA in General Management, Master of Technology in Knowledge Engineering, Master of Science in Maritime Studies, and LL.M. (IP Law). He also holds professional qualifications in Business Valuations and Appraisers for CVA, arbitration, law, and marine engineering, including the Chief Engineer's First-Class Certificate of Competency (MCA, UK). He is further qualified and accredited as Certified International Arbitrator, Chartered Arbitrator, Sports arbitrator under CAS Rules, WIPO Neutral, Australian Communications and Media Authority (ACMA) Bargaining Code Arbitrator, Accredited Adjudicator and Accredited Mediator (Malaysia). He is admitted to the international panels of arbitrators and neutrals with WIPO, Geneva; ACICA, AMTAC and ACMA, Australia; BVIAC (British Virgin Islands); JIAC (Jamaica); HKIAC Hong Kong; AIAC, Malaysia; AIADR, Malaysia; KCAB, Seoul, South Korea; ICA, Delhi, India; ICC (Singapore); SISV, Singapore; SCMA, Singapore; SCCA, Saudi Arabia; VIAC Vienna, Austria; Thailand Arbitration Centre (THAC), and Mediator with AIAC Malaysia, CMC, and SIMI Singapore. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations
Public Speaking 1 Day Training in Hamilton, UK
10 Soft Skills You Need 1 Day Training in Hamilton, UK
Public Speaking 1 Day Training in Paisley
10 Soft Skills You Need 1 Day Training in Paisley
This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access
This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson