6642 Acro courses

Develop essential negotiation skills with EnergyEdge's course tailored for engineers and technical professionals. Enroll in our classroom training now!

Learning Agile or Scrum without the necessary work context is ineffective; more importantly, learning Agile or Scrum without a platform to practice and apply them on an ongoing basis is futile. IIL's Mastering Hybrid Approaches for Projects workshop provides both context and practice across all aspects of the value delivery system including waterfall, hybrid, and Agile approaches. This workshop provides options that span the value delivery spectrum for developing scope, estimating durations, managing schedules, and tracking progress. For example, participants will learn how to organize scope with a WBS and prioritize it with a backlog as well as lead the day-to-day work with a task board. The workshop also covers how to integrate iterations and releases into a high-level predictive schedule. The project team is the heart of the project. This workshop explains various team roles along with key leadership skills such as emotional intelligence and decision making. Key tenets of Agile practices, such as servant leadership and self-managing teams are explored along with the different types of meetings, such as daily stand-ups, iteration planning, and demonstrations. Those who attend will be better prepared to situationally apply agile and hybrid concepts. In addition, this course provides the structure for critical thinking to occur: to know and understand when to apply a predictive approach, when to apply an adaptive approach and when and how to combine them in a tailored and customized hybrid approach that meets the needs and demands of the project and the organization. The learning experience design is rooted in real world perspectives, leveraging team exercises based on a comprehensive case study.

About this Virtual Instructor Led Training (VILT) Asia Pacific is set to be the largest and fastest growing Hydrogen market globally. This growth is driven by decarbonisation of energy-use, ammonia production and rising demand of fuel cell electric vehicles. Hydrogen as a fuel has outstanding energy carrying capacity and many application possibilities ranging from Petroleum refinery, Ammonia and Methanol production, Transportation and Power generation. Although the current petrochemical market segment will remain strongest in the near future, it is the transport and power sector which spurs the vision of a massive market takeoff in the next decade. The ever-rising share of renewable energies require flexible and scalable storage solutions, which in turn offers many additional revenue streams beyond pure electricity sales. Adding to this the strong impetus towards decarbonization of the transport sector from cars, trucks, trains to ships and even airplanes creates the breed for an exciting and yet untapped market potential. This course aims to clarify and assess the hydrogen business case along its value chain and versatile market applications. Training Objectives Understanding current hydrogen market status and recent developments Major drivers and inhibitors influencing the growth of the market Understanding and comparing various production technology processes Challenges and solutions in transport, distribution and storage of hydrogen Mapping the many petrochemical, energy and transport applications Analyse business cases from around the world and understand their economics Target Audience Project developers Equipment Manufacturers Oil, Gas and Petrochemical sector companies IPPs and utilities Transport sector companies and port operators Policy makers and regulators Investors and lenders Course Level Basic or Foundation Training Methods The VILT will be delivered online in 4 half-day sessions comprising 4 hours per day, including time for lectures, discussion, quizzes and short classroom exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end the course. Trainer Your expert course leader is an internationally renowned energy communicator and business educator, focused on the interconnected clean energy transition topics of renewable power, energy storage, energy system electrification and hydrogen. His own independent technology tracking, market assessment and opportunity/risk analysis is delivered to clients through a mix of business advisory work, commissioned content, small-group training (online & in-person), and one-to-one executive coaching (online). In the hydrogen sector, he is currently lead consultant and trainer to the World Hydrogen Leaders network, and writer of their 'This Week in Hydrogen' news column. He is also co-presenter of the 'New Energy Chinwag' podcast, which regularly covers hydrogen-related issues. During more than 15 years as an independent energy expert, he has helped companies from large multinationals to innovative start-ups - totalling assignments in over 30 countries across 5 continents. Most recently, he has presented clean energy training in locations as diverse as Singapore, the UK, South Africa, The Philippines, the USA, Mexico, Spain and Dubai - and, in recent times of course, online to international audiences from across the world. Prior to this, he was Research Director for over 10 years at Informa, a $9 billion business intelligence provider; where he drove new market identification, analysis and project deployment work, and managed teams in the UK and US. He has a strong science background, holding a 1st Class Honours degree in Natural Sciences from the University of Cambridge, a PhD in Earth Sciences and a further Diploma in Economics & Sustainability from the UK's Open University. 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 about post training coaching support and fees applicable for this. Accreditions And Affliations

A two-day programme designed to equip mediators, facilitators, coaches and change agents with the skills and processes that they need in order to resolve team conflicts across a diverse range of industries.

Elevate your expertise in LNG terminal operations safety through our classroom training course. Energyedge provides industry-leading expertise and guidance.

Enhance your prospect risks and volumes assessment skills with EnergyEdge's comprehensive classroom training. Join now!

Discover the future of sustainable energy with EnergyEdge's expert-led training on hydrogen production, CO2 capture, and geological storage. Shape a greener world today!

The Moccasin Manager, The Moccasin Approach, Management Training, Management Development,

Emotional Intelligence, EQ, EI, Moccasin Approach, Moccasin Manager,

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.