4712 Courses in Liverpool delivered Live Online

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Identify some of the unique challenges women face in their personal and professional lives, and understand how to support and empower females in the workplace.

Duration 2 Days 12 CPD hours This course is intended for This class is intended for PMP?s looking to earn PDU's, or for Project Managers looking to learn more about Project Scope and Schedule Management techniques. This course provides participants with tools and techniques to help them determine and deliver products, services, and results that meet requirements, expectations, and deadlines. NOTE: This course will earn you 14 PDUs. 1 - PROJECT SCOPE AND TIME MANAGEMENT OVERVIEW Project Scope Management Overview Project Scope Mgt. Processes and Key Outputs Project Time Management Overview Project Time Mgt. Processes and Key Outputs Case Study Selection Requirements, Scope, and Negotiations 2 - PLAN SCOPE AND SCHEDULE MANAGEMENT Plan Scope and Schedule Mgt. Overview The Scope Management Plan The Requirements Management Plan The Schedule Management Plan 3 - COLLECT REQUIREMENTS Collect Requirements Overview Types of Requirements Effective Product/Solution Requirements Other Stakeholders and Requirements Collect Requirements Techniques Voice of the Customer Requirements Traceability Matrix 4 - DEFINE SCOPE Define Scope Overview Project Scope Statement Sections Create a Project Scope Statement 5 - CREATE WBS Create WBS Overview WBS by Deliverable WBS by Phase When to Subdivide a Work Package Further Effective WBSs General Process for Creating the WBS Create a WBS 6 - DEFINE ACTIVITIES Define Activities Overview Practical Considerations for Defining Activities Activities and Steps Milestones Create Activities and Milestones 7 - SEQUENCE ACTIVITIES Develop Schedule Overview Critical Path Resource Optimization ? Resource Leveling Resource Optimization ? Resource Smoothing Resolve Overallocations Critical Chain Schedule Compression Techniques 8 - ESTIMATE ACTIVITY RESOURCES Estimate Activity Resources Overview Resource Breakdown Structure Estimate Activity Resources Assign Resources to Activities 9 - ESTIMATE ACTIVITY DURATIONS Estimate Activity Durations Overview Expert Judgment Ratio Estimating Analogous Estimating Parametric Estimating Forecasting Three Point Estimating and PERT Estimating Reserves Estimate Activity Durations 10 - DEVELOP SCHEDULE Develop Schedule Overview Critical Path Resource Optimization ? Resource Leveling Resource Optimization ? Resource Smoothing Resolve Overallocations Critical Chain Schedule Compression Techniques 11 - VALIDATE SCOPE Validate Scope Overview Verify Scope Best Practices Create a Scope Validation Form 12 - CONTROL SCOPE AND SCHEDULE Control Scope Overview Control Schedule Overview Control Scope Best Practices Change Control Stakeholders Determine Change Control Stakeholders Change Control Process Change Request Form

The Professional Agile Leadership Essentials (PAL-E) is a 2-day hands-on workshop that uses a combination of instruction and hands-on exercises to help managers and other leaders who work directly with agile teams understand how to best support, guide, and coach their teams to improve their agile capabilities. Course Description Professional Agile Leadership Essentials (Scrum.org) Training ONLINE PAL E - Professional Agile Leadership Essentials Agile leadership has a lot to offer businesses today. Organizations have changed a great deal over the years and are no longer the static, structured entities they once were. Agile teams and agile leadership respond to these changes, offering a new way to achieve better results. PAL-E training is designed to help managers, and other leaders, understand how to approach an Agile transformation, and to guide teams to be successful.  Agile teams and leadership bring real benefit Agile organisations and teams thrive in unpredictable and changing environments. They are able to improve efficiency and react quickly to changing markets and customer needs. Achieving this is not something that just happens. The transformation to become an agile organisation is profound, requiring senior leaders, managers, and team members to change how they organise themselves and others, alongside how they work and measure results.  According to consultancy McKinsey: "the key to a successful Agile transformation is for leaders, particularly senior leaders, to develop substantially new mind-sets and capabilities." Scrum Training is a perfect first step in this. Professional Agile Leadership Essentials training The Professional Agile Leadership Essentials (PAL-E) course is a certified 2-day online workshop for team managers and leaders. It will show managers how to effectively develop, support, and guide agile teams to improve their performance. Agile teams are different from traditional structures. There is much more focus on continuous development and learning, as well as self-organisation. The course provides a foundation for managers' and leaders' roles in creating the conditions for a successful Agile transformation. Through detailed instruction and practical exercises, this course will teach leaders and managers how to form, support, and enhance Agile teams. It will guide them through the business, cultural and behavioural changes that must be made to take full advantages of the possibilities of Agile teams. PAL-E Course contents and key objectives The Professional Agile Leadership Essentials course will provide a solid grounding in the background and importance of agile leadership and how to apply it in leading teams.  The main content and learning includes: An understanding of what Agile is, the benefits and impact it can have on business, and the role a manager plays in achieving this. Challenges and techniques of Agile management, and the role management plays in an Agile organisation. How to develop and support Agile teams. How to measure and guide Agile product delivery, and an understanding of core problems in product development. An understanding of how to measure the benefits and impacts of agility in your organisation. Expected Outcomes from a PAL-E workshop PAL-E training highlights how Agile teams perform and the role of leaders and managers in establishing and developing their teams. Agile can help an organisation thrive through a framework that provides a flexible approach to challenges and problem solving. Thje Professional Agile Leadership Essentials course enables you to lead your teams and implement core Agile frameworks that deliver real business benefits. Who Should Attend This Course? Professional Agile Leadership essentials course is designed for leaders and managers in Agile organisations. It is suited to anyone responsible for setting up or establishing Agile techniques and for those managing teams and improving ongoing methods and techniques. After completing the course, participants can obtain industry-recognised certification. This will require passing a rigorous online assessment following the training. There are then plenty more courses that can take you further into Agile techniques. Scrum Master Training, for example, will guide participants through the industry-leading scrum framework for Agile practices. Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free practice assessments for certification success Free resource bundle to master Scrum Free exam revision sheets Free access to an exam simulator Free exam coaching sessions for first-time success Free 1:1 coaching to excel at work Our Clients Our Testimonials

CPD Accredited, Interactive Short Course 2 hr session We will look at what manual handling is, and why it is so important And how we can apply proper manual handling techniques in our daily lives Great as an annual refresher! Course Contents: What is Manual Handling Illnesses and Injures arising from incorrect manual handling Manual techniques How to adapt those to our daily lives Benefits of this Short Course: Boys are around 4 x as likely to have ADHD Manual Handling is one of the main causes of work-related musculoskeletal disorders But manual handling illnesses and injuries do not happen in the workplace alone This means that every single classroom in the UK will have at least one child or young people with Attention Deficit Hyperactive Disorder Learn more about the condition and how you can help them cope and take part in 'normal' life.

This class is designed for people who want to Learn Salsa\Zumba or any Latin Dance rhythm private class on Zoom platform for couples or individuals to achieve a good knowledge of the Salsa, Samba, Bachata, Merengue or Latin dance steps One to One lesson, 4 minimum pack lesson booking. Taught by native instructor You can have this lesson at our premises, on Zoom, Pre-recorded or home visit, the choice is yours!!! The Program includes: 10 or 20 Lesson 1on1 lesson Walking & Leading techniques Female & Male Teachers Footwork & Upper body techniques Steps & routines names (brain method) Body posture and language Tempo & beat music technique Fully equipped dance studio Ownership of your footage work progress & Docs Music library via Spotify & Apple Music Personal online library on Google Drive or Dropbox Salsa or Latin Dance rhythm private class in London for couples or individuals to achieve a good knowledge of the salsa, samba, bachata, merengue or Latin dance steps One to One lesson, 4 minimum pack lesson book Teach by native instructor We have been training people in salsa in london for almost 20 years and still in business as salsa in west london is increasing massively.

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.