Duration 5 Days 30 CPD hours This course is intended for This course is designed for business analysts. Overview After completing this course, you should be able to:Describe the benefits of implementing an Operational Decision Manager solution, and the collaboration that is required between the business and development teamsIdentify the main user roles that are involved in designing and developing an Operational Decision Manager solution, and the tasks that are associated with each roleExplain modeling concepts and the UML notation that is relevant to modeling for business rules and eventsDefine and implement object models for business rulesSet up the rule authoring environment in Designer by working with decision services and synchronizing across development and business environmentsCustomize the vocabulary that is used in rulesDiscover and analyze business rules for implementationUse the Operational Decision Manager rule editors to author business rules and decision tablesRun tests and simulations in the Decision Center Enterprise console to validate decision logic and rule changesExplain governance issues and work with Operational Decision Manager features that support decision governance This course introduces business analysts to IBM Operational Decision Manager V8.7.1. You learn the concepts and skills that are necessary to capture, author, validate, and manage business rules with Operational Decision Manager. Course Outline Course introduction Introducing IBM Operational Decision Manager V8.7.1 Exercise: Operational Decision Manager in action Modeling for business rules Exercise: Building the model on paper Exercise: Implementing the model Understanding decision services Exercise: Setting up a decision service Working with the BOM Exercise: Working with the BOM Introducing Decision Center Exercise: Exploring the Decision Center Business console Exercise: Exploring the Decision Center Enterprise console Introducing rule authoring Exercise: Understanding the case study Discovering and analyzing rules Exercise: Discovering rules Exercise: Analyzing rules Working with conditions in rules Exercise: Working with conditions in rules Working with definitions in rules Exercise: Working with definitions in rules Writing complete rules Exercise: Writing complete rules Authoring decision tables and trees Exercise: Authoring decision tables and trees Exercise: Authoring rules: Putting it all together Running tests and simulations in the Enterprise console Exercise: Running tests and simulations in the Enterprise console Introducing decision governance Exercise: Working with the decision governance framework Course summary
Duration 2 Days 12 CPD hours This course is intended for Data Modelers Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data. Introduction to IBM Cognos Dynamic Cubes Define and differentiate Dynamic Cubes Dynamic Cubes characteristics Examine Dynamic Cube requirements Examine Dynamic Cube components Examine high level architecture IBM Cognos Dynamic Query Review Dimensional Data Structures Dynamic Cubes caching Create & Design a Dynamic Cube Explore the IBM Cognos Cube Designer Review the cube development process Examine the Automatic Cube Generation Manual development overview Create dimensions Model the cube Best practice for effective modeling Deploy & Configure a Dynamic Cube Deploy a cube Explore the Estimate Hardware Requirements Identify cube management tasks Examine Query Service administration Explore Dynamic Cube properties Schedule cube actions Use the DCAdmin comment line tool Advanced Dynamic Cube Modelling Examine advanced modeling concepts Explore modeling caveats Calculated measures and members Model Relative Time Explore the Current Period property Define period aggregation rules for measures Advanced Features of Cube Designer Examine multilingual support Examine ragged hierarchies and padding members Define Parent-Child Dimensions Refresh Metadata Import Framework Manager packages Filter measures and dimensions Optimize Performance with Aggregates Identify aggregates and aggregate tables In-memory aggregates Use Aggregate Advisor to identify aggregates User defined in-memory aggregates Optimize In-Memory Aggregates automatically Aggregate Advisor recommendations Monitor Dynamic Cube performance Model aggregates (automatically vs manually) Use Slicers to define aggregation partitions Define Security Overview of Dynamic Cube security Identify security filters The Security process - Three steps Examine security scope Identify scope rules Identify roles Capabilities and access permissions Cube security deep dive Model a Virtual Cube Explore virtual cubes Create the virtual cube Explore virtual cube objects Examine virtual measures and calculated members Currency conversion using virtual cubes Security on virtual cubes Introduction to IBM Cognos Analytics Define IBM Cognos Analytics Redefined Business Intelligence Self-service Navigate to content in IBM Cognos Analytics Interact with the user interface Model data with IBM Cognos Analytics IBM Cognos Analytics components Create reports Perform self-service with analysis and Dashboards IBM Cognos Analytics architecture (high level) IBM Cognos Analytics security Package / data source relationship Create Data modules Upload files Additional course details: Nexus Humans B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The UK mobile app market is expected to reach a staggering £20.5 billion by 2025. With the app development industry booming, there's never been a better time to acquire the skills to build your own apps and potentially launch your next big venture. This App Development Advanced Diploma Bundle equips you with the knowledge and tools to create various applications across different platforms and technologies. With this App Development Advanced Diploma course you will get 20 CPD Accredited PDF Certificates, Hard Copy Certificate Flutter & Dart Development for Building iOS and Android Apps and our exclusive student ID card absolutely free. Courses Are Included In This App Development Advanced Diploma Bundle: Course 01: Flutter & Dart Development for Building iOS and Android Apps Course 02: Web GIS Application Development with C# ASP.NET CORE MVC and Leaflet Course 03: Level 3 Creating Web App for iPad Course 04: Web Application Penetration Testing Course 05: Industry 4.0 - Automation & Applications Course 06: Tic-Tac-Toe Clone - The Complete Cocos2d-x C++ Game Course Course 07: Tic-Tac-Toe Clone - The Complete SFML C++ Game Course Course 08: Flappy Bird Clone: SFML C++ Game Course 09: Modern OpenGL 3D Game Course 10: Blender 3D - Create a Cartoon Character Course 11: Developing Game in Unity 3D Course 12: Unreal Engine 4 for Beginners Course 13: Unreal Engine 4 Course 14: Make Cinematics Using Unreal Engine 5 Course 15: Maya & Unity 3D: Modeling Lowpoly Tree for Mobile Games Course 16: Maya & Unity 3D: Modeling Environments for Mobile Games Course 17: Publish Game Assets to the Unity & Unreal Marketplace for Passive Income Course 18: Monetize Your Mobile Game or App Course 19: The Media Crash Course Course 20: Environment Design Using Unreal Engine 5 Each lesson in this App Development course is crafted for easy understanding, enabling you to become proficient in App Development. Whether you are a beginner or looking to sharpen your existing skills, this App Development is the ideal choice. Learning Outcomes of this Bundle Grasp fundamental programming concepts in various languages like Dart, C#, and C++. Master essential app development frameworks like Unity, Unreal Engine, and Maya. Explore web application security principles to protect your creations. Design and develop engaging 2D and 3D games for different platforms. Enrol in App Development Advanced Diploma today and take the first step towards achieving your goals and dreams. Why buy this Bundle? Free CPD Accredited Certificate upon completion of this Bundle Get a free student ID card with this Bundle Lifetime access to the course materials Get instant access to this Bundle course Learn from anywhere in the world 24/7 tutor support with the App Development Advanced Diploma course. App Development Advanced Diploma is an entirely online, interactive lesson with voice-over audio. Start your learning journey straightaway with our App Development Advanced Diploma Training! App Development Advanced Diploma premium bundle consists of 20 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of App Development Advanced Diploma is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. The App Development course is extremely dynamic and well-paced to help you understand App Development with ease. Certification of App Development You have to complete the assignment given at the end of the App Development Advanced Diploma course and score a minimum of 60% to pass each exam. After passing the App Development Advanced Diploma exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This App Development Advanced Diploma course is ideal for: Students seeking mastery in App Development Professionals seeking to enhance App Development skills Individuals looking for a App Development related career. Anyone passionate about App Development Requirements This App Development Advanced Diploma doesn't require prior experience and is suitable for diverse learners. Career path This App Development Advanced Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Mobile App Developer Game Developer Web Developer UI/UX Designer Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.
Overview: Are you ready to elevate your expertise in high-voltage three-phase systems? Our comprehensive course, 'Short Circuit Analysis for HV Three Phase Systems,' is designed to empower electrical engineers, power system professionals, and anyone involved in the design and maintenance of high-voltage electrical networks. Key Benefits: Specialized Knowledge: Gain in-depth insights into short circuit analysis specific to high-voltage three-phase systems. This course is tailored for professionals seeking specialized skills in analyzing and mitigating short circuits in complex electrical networks. Real-world Applications: Dive into practical scenarios and case studies, providing hands-on experience that directly applies to real-world situations. Acquire the skills needed to analyze short circuits in various industrial settings, ensuring you are well-equipped to handle challenges on the job. Cutting-Edge Techniques: Stay ahead of the curve by learning the latest techniques and methodologies in short circuit analysis. Understand how to use advanced software tools to simulate and analyze short circuits, allowing you to make informed decisions in system design and protection. Risk Mitigation: Learn strategies to identify potential risks associated with short circuits in high-voltage systems and implement effective protective measures. Minimize downtime, enhance system reliability, and ensure the safety of personnel and equipment within your electrical network. Expert Instruction: Benefit from the guidance of industry experts with extensive experience in high-voltage systems. Our instructors bring a wealth of knowledge to the table, providing valuable insights and practical tips to enhance your learning experience. Networking Opportunities: Connect with like-minded professionals, fostering valuable networking opportunities. Share experiences, exchange ideas, and build relationships within the industry, enriching your professional network for future collaborations and career advancements. Flexible Learning: Access the course content at your own pace with our online platform. Whether you're a working professional or a student, our flexible schedule allows you to balance your learning with other commitments. Who Should Enroll: Electrical Engineers Power System Designers Maintenance Professionals Utility Engineers Electrical Consultants Students pursuing electrical engineering Don't miss this opportunity to enhance your skills and become a go-to expert in Short Circuit Analysis for HV Three Phase Systems. Enroll now and power up your career! Course Curriculum Introduction To Short Circuit Analysis For Hv Three Phase Systems Course Introduction To Short Circuit Analysis For Hv Three Phase Systems Course 00:00 Short Circuit Fault Analysis Overview Short Circuit Fault Analysis Overview Per Phase Analysis Per Phase Analysis 00:00 Per Unit Analysis Per Unit Analysis 00:00 Change Of Base Change Of Base 00:00 Transformers Per Unit Analysis Transformers Per Unit Analysis 00:00 Symmetrical Components Symmetrical Components 00:00 Asymmetrical Three Phase Fault Analysis Asymmetrical Three Phase Fault Analysis 00:00 System Modeling System Modeling 00:00
Fall into Savings. Enjoy the biggest price fall this Autumn! Give a compliment to your career and take it to the next level. This BIM will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate skills for your next promotion, this BIM will help you keep ahead of the pack. The BIM incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this BIM will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in this job sector. Consequently, you'll sharpen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the BIM, you can equip yourself with the essentials to keep you afloat in the competition. Along with this course, you will get 10 premium courses, an originalHardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This BIM Bundle Consists of the following Premium courses: Course 01: Diploma in Construction Management Course 02: Architectural Studies Course 03: Quantity Surveyor Diploma Course 04: Building Surveyor Course 05: Land Surveying Course 06: Construction Cost Estimation Diploma Course 07: Construction Cost Estimation Using Xactimate Course 08: Construction Estimation using RSMeans Course 09: Construction Industry Scheme (CIS) Course 10: WELL Building Standard Course 11: LEED V4: Building Design and Construction So, enrol now to advance your career! Benefits you'll get from choosing Apex Learning for this BIM: Pay once and get lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum Course 01: Diploma in Construction Management Introduction to Construction Management Project Life Cycle and Success Cost Management Preliminary Site Investigation and Site Organisation Site Management Planning and Management of Equipment Construction Materials Management Vendor Analysis in Construction Management Construction Procurement Stock Control Supply Chain Management The Main Participators Quality Assurance and Customer Care Legal Aspects of Contracting Human Resources Management Risk and Value Management Communications, Information and Documentation of Construction Health and Safety in Construction Management Course 02: Architectural Studies Introduction to Architectural Studies Ancient Architecture Architectural Ideas and Movements Architectural Styles Art Deco Architectural Style Scandinavian Architectural Style Victorian Architectural Style Classical and Early Christian Architectural Style Gothic Architectural Style Baroque and Rococo Architectural Style Eclecticism Architectural Style Modern and Post-Modern Architectural Style Interior Designing Colour in Interior Designing Lighting in Interior Design Part One Lighting in Interior Design Part Two Course 03: Quantity Surveyor Diploma Quantity Survey An Introduction Development of the Quantity Surveyor Quantity Surveying Measurement Cost Management Pricing and Operational Estimation Contract Management and Tendering Procurement and Bill Preparation Predicting Potential Risk and Management Regulation and Control Report Writing Course 04: Building Surveyor Building Survey: An Introduction Building Law Principles Building Procurement and Contract Administration Building Information Modelling Building Technology The Procedure of Building Survey and Surveys of Historic Buildings Beginning of the Survey: Foundation and In-depth Survey in Walls Ground Level Investigation: Floors and Investigation Above the Ground: Roofs and Chimneys Inspection of Joinery and Woodwork Finishes and Surfaces of the Building Services Inspection Building Pathology Building Adaption Understanding Work Breakdown Structure Report Writing Legal Aspects Course 05: Land Surveying Introduction to Land Surveying Land Surveying Basics Land Surveying Instrumentation Land Surveying Methods and Techniques Topographic Surveying and Mapping Boundary Surveying Surveying Health and Safety Course 06: Construction Cost Estimation Diploma Introduction to Construction Management Cost Estimation Role of Cost Estimator and New Aspects of Cost Estimation Elements and Factors influencing Cost Estimation Cost Estimation in Construction Industry Cost Management Management of Material for construction Course 07: Construction Cost Estimation Using Xactimate Introduction to Xactimate Foundation Cost Estimation on Xactimate Wood-frame Structure Cost Estimation on Xactimate Plumbing, Electricity and HVAC Cost Estimation on Xactimate Interior Finish & Cabinetry Cost Estimation on Xactimate Windows, Doors, Roof & Exterior Siding Cost Estimation on Xactimate Course 08: Construction Estimation using RSMeans Introduction Quantity Take Off Cost Estimation using RSMeans Course 09: Construction Industry Scheme (CIS) Construction Industry Scheme (CIS) Coverage of the Scheme Contractors and Registration for the Scheme Verification Process The CIS Returns Record Keeping and CIS Certificates Penalties Involved in CIS Miscellaneous Information Course 10: WELL Building Standard Introduction Air Water Nourishment Light Fitness Comfort Mind Course 11: LEED V4: Building Design and Construction Introduction Integrative Process Location & Transportation Sustainable Sites Water Efficiency Energy & Atmosphere Materials & Resources Indoor Environment Quality Innovation Regional Priority Completion CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this BIM bundle. Requirements This BIM course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Diploma in Construction Management) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
AgileBA® Foundation and Practitioner: Virtual In-House Training The AgileBA® Foundation and Practitioner course takes you through a business understanding of the external and internal forces that underline the project from a business perspective, looks at modeling techniques, (As Is - To Be), and also provides an overview to project management (AgilePM) from an 'Agile' perspective. The course explains the role's relevance and involvement throughout the project. What You Will Learn At the end of this program, you will be able to: Understand business analysis in a project environment and the techniques used, as well as knowing more about the role of the business analyst in a project Business Analysis - Business Environment and Organizational Strategy Overview of AgilePM The Business Case Stakeholder Engagement/Analysis Techniques: Requirements and Estimating Prioritization Timeboxing Iterative Development Planning Facilitated Workshops Modeling - 'As Is - To Be' Making the transition to AgileBA
Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modeling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title. 1 - Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages 2 - Data Modeling Data Modelling Designing a Database Relationship Modeling 3 - Normalization Fundamentals of Normalization Normal Form Denormalization 4 - Relationships Introduction to Relationships Planning Referential Integrity 5 - Performance Indexing Query Performance Concurrency 6 - Database Objects Tables Views Stored Procedures, Triggers and Functions Additional course details: Nexus Humans 55313 Administering Configuration Manager, Part 1: Fundamentals and Asset Management training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55313 Administering Configuration Manager, Part 1: Fundamentals and Asset Management course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
About this Training Course This 5 full-day training course looks at the setup of economic analysis cases, including the estimation of recoverable reserves, production profiles, commodity prices, and project costs - CAPEX, OPEX, taxes, royalties, transportation, depreciation, before-tax (BTAX) cash-flow, after-tax (ATAX) cash-flow and international fiscal regimes (production sharing agreement and concessionary system). The course begins from the basic required parameters of inflation, interest and time value of money. These concepts are then transformed into profitability indicators. Last but not the least, the profitability indicators are then used to make investment decisions. The emphasis of this course is to bridge the gap between theoretical concepts and their practical limitations. The participants will be able to appreciate the amount of information that they never thought of. Another emphasis of this course is also on the use of Excel's financial functions. This understanding is very critical when it comes to building economic cash-flow models. Over the years, we have seen that participants really struggle with using the Excel functions correctly and this leads to mistakes that can be easily avoided. In each session, multiple choice problems are provided to participants to reinforce their understanding of the concepts covered in the course. Many quick or tips not widely known, are also shared with the participants. The concepts covered in this course are not restricted to downstream, upstream or petrochemical projects. These concepts can be used to evaluate any type of investment under consideration. Participants will require access to computers/laptops with Excel to solve problems during the course. Training Objectives Upon completion of this course, participants will be able to fully understand the gas market dynamics and Investment Evaluation. They will be able to: Learn how to reduce exposure and mitigate risks in projects by handling uncertainty Clarify concepts such as time value of money, cash-flow models, capital budgeting, IRR, NPV, income producing investments Maximise the return on investments through good decision-making processes based on the commercial viability of projects Improve their decision process, investment and opportunity analysis Acquire the hands-on experience in building their own economic evaluation models and solving case study-based examples Target Audience The following oil & gas company personnel will benefit from the knowledge shared in this course: Facilities and Planning engineers Project and procurement personnel Oil & gas engineers Geologists Financial Analysts Commercial managers Economists Government officials Business advisors Asset managers E&P managers Product and business development personnel Course Level Basic or Foundation Training Methods Organisational Impact Trainer Your expert course leader is a globally recognised subject matter expert in petroleum/project economics and international gas market analysis. He is a recipient of the 2021 Society of Petroleum Engineers (SPE) International Management Award, an award that recognises individuals who make significant technical and professional contributions to the petroleum engineering profession and to the worldwide oil and gas industry. He has 40 years of diversified experience in petroleum engineering, reservoir engineering, project economics and decision analysis. He had been involved in evaluating multi-billion-dollar oil and gas field development, NGL, LNG, GTL, Aluminum smelter, refinery, petrochemical, power and production sharing projects. He has worked with major oil companies such as Saudi Aramco, ZADCO, Qatar Petroleum and companies in USA. He is a registered professional Engineer in the state of Colorado, USA. He is the author of six books: Petroleum Engineering Handbook for the Practicing Engineer, Vol. I and Vol. II, published by PennWell Books, Tulsa, Oklahoma, USA. Project Economics and Decision Analysis, Vol. I and Vol. II, published by PennWell Books, Tulsa, Oklahoma, USA. These books are used as textbooks in universities worldwide to teach petroleum economics to undergraduates and graduate students. Tip & Tricks in Excel based Financial Modeling, Vol. 1 & 2, published by Business Expert Press, New York, USA. He has also authored several papers in the Oil & Gas Journal, The Log Analyst, World Oil, SPE Journals, and Oil & Gas Financial Journal. He has delivered lectures in more than 25 countries around the globe. He has always received excellent feedback, as an expert presenter, from the participants of his courses. Daily daily_agenda 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
About this training course Transmission lines and sub-stations are essential components in the electrical power systems. Proper design and maintenance are crucial for transmission lines to maintain a continuous operation. The objective of this 5-day training course is to deal appropriately with control systems, design characteristics and electric & magnetic fields. Participants will gain a better understanding on the corona and gap discharge phenomena, constructional features, and optimization of the transmission lines. Training Objectives By participating in this course, you will be able to: Understand transmission line design and its application Examine different types of conductors and electrical characteristics Explore basic and general transmission line parameters Prevent overvoltage through insulation design Determine surge impedance and corona effects Calculate and measure electric and magnetic fields Comprehend the impact of audible noise and electromagnetic interference Identify interference within the transmission line systems Target Audience The course will greatly benefit the following groups but not limited to: Electrical Engineers Civil Engineers Transmission & Distribution Engineers Substation Operators Safety Engineers Reliability Engineers Facility & Plant Engineers Technical Engineers Design Engineers Plant Supervisors Electrical Contractors Course Level Basic or Foundation Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 5 days in total (35 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 25. This course is also available through our Virtual Instructor Led Training (VILT) format. Trainer Your expert course leader is a professional engineer with extensive experience in power system studies, substation design field-testing, and EHS programs settings for Mining and Electrical Utilities sectors. He was formally the Engineering Manager at GE Canada in Ontario. He received his M.Sc. in electrical engineering from the University of New Brunswick and his MBA from Laurier School of Business in Waterloo. He has managed and executed more than 150 engineering projects on substation design EMF audits and power system studies and analyses, EMF audits and grounding audits, for major electrical utilities, mines, oil and gas, data centers, industrial and commercial facilities in Canada and the U.S. He is a certified professional engineer in the provinces of Ontario and Alberta. He has various IEEE publications, has served as a technical reviewer for many IEEE journals in power systems and control systems, and is the chair of the Industry Application Chapter (IAS) for IEEE Toronto Section. He remains a very active member for the IEEE substation committee of IEEE Std. 81 ground testing (WGE6) and IEEE Std. 80 ground design (WGD7). A certified electrical safety trainer by GE Corporate and a Canadian Standard Association (CSA) committee member at the mining advisory panel for electrical safety, he also taught many technical courses all over Canada to industrial customers, electrical consultants as well as to electrical utilities customers. Highlighted Projects: Various Power System Studies for 345/230 kV Stations - Nova Scotia Power (EMERA) RF audits for Telecom tower and antennas - Cogeco/Rogers Mobile Power System analysis - Powell Canada Structural/Geotechnical Design and upgrades - Oakville Hydro Underground Cables testing and sizing - Plan Group Relay programming and design optimization - Cenovus Canada Different Arc Flash Analysis and BESS Design - SNC Lavalin Environmental site assessment (ESA) Phase I/II for multiple stations - Ontario Electromagnetic compatibility (EMC) assessment for Toronto LRT expansion - MOSAIC Battery energy storage system (BESS) installation at City of London - Siemens Canada EMF audits for 500 kV Transmission Lines - Hydro One EMF audits for 500 kV Transmission Lines - Hydro Quebec AC interference for 138 kV line modeling and mitigations - HBMS Mine 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
Practical Excel training that will turn you into a certified Excel master About course Become a master of Excel Learn how to use the crucial Excel functions and tools. Learn from the experts The course is conducted by an Excel specialist with many years of experience. Test your knowledge In the course, you will find tests and practical tasks to consolidate your knowledge and skills. Do you want to master Excel quickly and efficiently? We offer you a unique opportunity to learn all the features of Excel in just a couple of days. The course is purely practical and will teach you the most useful tools included in the app. Whether you do data modeling, work on databases or analysis and reporting, this practical course will show you how to speed up and improve the quality of your work in each of these areas. Through the course, you will have few knowledge repetitions, practical tasks and tests that will help you remember all the information and put into practice the skills you have learned. The training offers access to the training videos and reference materials for an unlimited period. You’ll learn from our Excel expert with many years of experience in the field who will explain every issue step by step and will teach you how to perform your tasks with confidence. This course is available through a multimedia Kemp Center platform. You will learn from the comfort of your own home and at your own pace. You can always stop, return or return to any topic. On top of everything, after completion of the course, you will receive certificate confirming your skills. Join the Excel course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Lewis Hardin Excel expert The Excel course is conducted by an MS Excel expert and trainer. He specializes in financial modeling and data analysis. He can’t imagine life without Excel and till now, he created and implemented dozens of business tools based on this program. Participants of his trainings appreciate him for his pragmatic approach, lightness of message, and an offbeat sense of humor. He is able to convey any issue in an accessible and understandable way. Overview of the course: The Excel course program: I. Module 1 – Editing Basic issues Excel applications; navigating in the program; naming; toolbar; formula behavior; special paste; moving and copying without disturbing file consistency; areas; relative and absolute references; keyboard shortcuts. Editing and formatting Fonts; borders; text layout; wrapping; merging; formats (text, number, currency, accounting, dates and times, percentage, scientific, special); conditional formatting; table formatting; width and height, auto-fit. Graphic and special elements Pictures; shapes; icons; 3D models; SmartArt; text boxes; equations; symbols; headings; comments. II. Module 2 – Analysis and modeling Create charts and tables Charts: column (bar); line; area; statistical; pie; doughnut; scatter; bubble; combination charts. Special charts: cascade; funnel; stock; surface; radar; maps; spark lines; PivotCharts. Filters (Slicer and Timeline): PivotTables and Plain Tables. Use formulas Rules for working on formulas. Review and application of formulas. Formulas: financial; temporal; mathematical and statistical; search; database; text; logical; IT; compliance; networking. Working on data (databases) Sort; filter; retrieve and transform data; import and export data; queries and connections; text as columns; instant fill; remove duplicates; data validation; consolidation; what-if analysis; forecast worksheet; outline (grouping and what-if analysis). III. Module 3 – Review, view and print Review and data protection Checking: spelling; thesaurus; workbook statistics. Accessibility settings; smart search; translator; comments and notes; protect worksheet; ink. View, printing and formats View: sheet views; page break preview; page layout and custom views; show grid view; formula bar and headings; zoom; arrange windows; freeze panes; enter macros. Printing: print area; page settings; margin settings; sheet adjustment. File formats and saving. IV. Module 4 – Advanced issues Advanced features Work with other apps Tools and plugins for professionals V. Tests Tests and repetitions of acquired knowledge The acquired knowledge will be consolidated and checked through tests after each training module. Tests improve the acquisition of knowledge and improve the attention and engagement throughout the training. Final test After completing the final test at the end of the Excel course, you will get certified. VI. Tasks Practical tasks and exercises Each participant of the Excel course will practice the acquired skills. In this way, the participant will assimilate skills for longer and adapt them to his/her style of operation. After completing the tasks and receiving feedback from our experts, the new skills will be fully acquired not only on an intellectual level but also on a practical level. VII. Bonus materials for the course Additional materials for use in everyday workAfter logging in, you will receive additional materials for use in everyday work. You will receive: short keyboards; a list of the best Excel plugins and tricks to improve work and many more. Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor: If you want to become an Excel master, don’t waste your time on boring and ineffective training courses that will teach you only the theory. We have a better solution for you: We are pleased to invite you to the most practical course that will teach you how to use Excel in practice. And guess what? You will master all the features of Excel program within just a couple of days.You will learn how to work dynamically and flawlessly. Data analysis, database manipulation, creating statements and reports won’t be a problem for you anymore. You will learn everything in the shortest possible time and you’ll master the use of the most important and useful functions. You will work on sheets taken from the real life and perform activities independently. In this way you will acquire the ability to use the program at an expert level.Join us today! Learn with us and surprise everyone with your knowledge of Excel! Learning Excel with us is so interesting and never boring. Learn from the best and become one of themLewis HardinExcel course expert