28052 Development courses in Birmingham delivered Online

Embark on a journey to become a proficient Learning Disability Nurse. This course offers a deep dive into autism, therapeutic approaches, child development, and effective communication. Learn to create impactful care plans and support the well-being of individuals with learning disabilities.

Description Due to technology advancement and the increasing reliance on data, SQL developers are in high demand. Many find this path relatively easy in comparison to other technical careers. If you have completed SQL Developer 2014 beginner course and want to get more in-depth knowledge of SQL Server, then this SQL Developer 2014 Intermediate is just for you. Through this course, you will understand the structured query language (SQL) for manipulating business data in the most effective and sensible approach. Obtain the power of Microsoft SQL Server and grasp how to maximise the performance of any SQL that you draft. Take your knowledge to the next level to fully to perform the essential tasks within your business or employment to improve your prospects to succeed in the long run. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module: 01 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 02 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 03 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 04 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 05 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 06 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 07 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 08 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 09 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course will let you develop the skillsets needed to guide the delivery of value in a Lean enterprise—and learn about the activities, tools, and mechanics used to manage backlogs and programs. Attending the class prepares you to take the exam and become a certified SAFe® 6 Product Owner/Product Manager (POPM). SAFe Product Owner/Product Manager 6 training course is provided under Scaled Agile, Inc. Partner Program Agreement.

Register on the HR, Payroll, PAYE, TAX today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The HR, Payroll, PAYE, TAX is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The HR, Payroll, PAYE, TAX Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the HR, Payroll, PAYE, TAX, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content HR, Payroll, PAYE, TAX Module 01: Introduction to Human Resource Introduction to Human Resources 00:17:00 Module 02: Employee Recruitment and Selection Procedure Employee Recruitment and Selection Procedure 00:32:00 Module 03: Employee Training and Development Process Employee Training and Development Process 00:22:00 Module 04: Performance Appraisal Management Performance Appraisal Management 00:19:00 Module 05: Employee Relations Employee Relations 00:14:00 Module 06: Motivation and Counselling Motivation and Counselling 00:19:00 Module 07: Ensuring Health and safety at the Workplace Ensuring Health and Safety at the Workplace 00:17:00 Module 08 :Employee Termination Employee Termination 00:15:00 Module 09: Employer Record and Statistics Employer Records and Statistics 00:11:00 Module 10: Essential UK Employment Law Essential UK Employment Law 00:26:00 Payroll Management Course Module 01: Payroll System in the UK Payroll System in the UK 01:05:00 Module 02: Payroll Basics Payroll Basics 00:10:00 Module 03: Company Settings Company Settings 00:08:00 Module 04: Legislation Settings Legislation Settings 00:07:00 Module 05: Pension Scheme Basics Pension Scheme Basics 00:06:00 Module 06: Pay Elements Pay Elements 00:14:00 Module 07: The Processing Date The Processing Date 00:07:00 Module 08: Adding Existing Employees Adding Existing Employees 00:08:00 Module 09: Adding New Employees Adding New Employees 00:12:00 Module 10: Payroll Processing Basics Payroll Processing Basics 00:11:00 Module 11: Entering Payments Entering Payments 00:12:00 Module 12: Pre-Update Reports Pre-Update Reports 00:09:00 Module 13: Updating Records Updating Records 00:09:00 Module 14: e-Submissions Basics e-Submissions Basics 00:09:00 Module 15: Process Payroll (November) Process Payroll (November) 00:16:00 Module 16: Employee Records and Reports Employee Records and Reports 00:13:00 Module 17: Editing Employee Records Editing Employee Records 00:07:00 Module 18: Process Payroll (December) Process Payroll (December) 00:12:00 Module 19: Resetting Payments Resetting Payments 00:05:00 Module 20: Quick SSP Quick SSP 00:10:00 Module 21: An Employee Leaves An Employee Leaves 00:13:00 Module 22: Final Payroll Run Final Payroll Run 00:07:00 Module 23: Reports and Historical Data Reports and Historical Data 00:08:00 Module 24: Year-End Procedures Year-End Procedures 00:09:00 Assignment Assignment - HR, Payroll, PAYE, TAX 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Free QLS Endorsed Certificate | 11 in 1 Exclusive Bundle with Free Certificates | 145 CPD Points | Installment Payment

: The UK job market has faced significant challenges over the last year due to the pandemic and recent conflicts. Finding a niche in this competitive landscape has become tougher, but with the right Project Management skills, you can stand out. Apex Learning presents the Project Management and Operations Manager bundle, designed to guide you toward a stable, successful career. This package, complete with innovative study materials, will provide in-depth knowledge of Project Management through step-by-step lessons and tutor support. Whether you’re new or experienced, this course will help you master Project Management from basic to advanced levels. With Project Management, endless opportunities await. This course gives you a competitive edge, constantly updated to reflect industry changes. You’ll gain the expertise to lead teams, manage resources, and complete projects efficiently. The Project Management skills you acquire will drive your success, boost productivity, and help you overcome challenges. By enrolling in the Project Management bundle, you invest in roles like Project Manager, Operations Manager, and more. This bundle is your one-stop solution for success in Project Management. Whether you’re starting or advancing your career, this Project Management bundle will equip you with the skills to thrive in the field. This 20-in 1 Ultimate Operations Manager bundle consists of the following Courses: Course 01: Project Management Masterclass Course 02: Supervisor Training and Employee Management Course 03: Leadership & People Management Course 04: Decision Making in High Stress Course 05: Six Sigma & Lean Process Course 06: Ethical Leadership Principles Course 07: Strategic Planning Process Course 08: Coaching and Mentoring Course 09: HR and Payroll Administrator Course Course 10: Conflict Management and Crucial Communications Course 11: Self Confidence & Self Esteem Training Course 12: Leadership Styles Course 13: Change Management Course 14: Business Analysis Course 15: Business Law Course 16: Managing Budgets Course 17: Corporate Finance Course 18: Compliance Manager Course 19: Diploma in Management Skills Course 20: Supporting a Grieving Employee Additionally, you will get 5 other career-guided courses in this Operations Manager bundle: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Operations Manager bundle. Why Choose this Project Management & Operation Management with Six Sigma & Lean Process Bundle? FREE Project Management & Operation Management with Six Sigma & Lean Process CPD-accredited certificate Get a free student ID card with Project Management & Operation Management with Six Sigma & Lean Process training (£10 applicable for international delivery) Lifetime access to the Project Management & Operation Management with Six Sigma & Lean Process course materials The Project Management & Operation Management with Six Sigma & Lean Process program comes with 24/7 tutor support Get instant access to this Project Management & Operation Management with Six Sigma & Lean Process course Learn Project Management & Operation Management with Six Sigma & Lean Process training from anywhere in the world The Project Management & Operation Management with Six Sigma & Lean Process training is affordable and simple to understand The Project Management & Operation Management with Six Sigma & Lean Process training is entirely online Learning Outcomes of the Project Management Bundle This career-oriented Project Management bundle will help you to: Gain the ability to excel in the role of Project Management and Operations Manager Know your responsibilities as a Project Management professional and convey your experience to others Gain excellent interpersonal and communication skills vital for Project Management Develop time and risk management skills to ensure efficiency in Project Management Understand the pros and cons of working in Project Management Adhere to the regulations and best practices in Project Management Leverage technological advancements to become more effective in Project Management Maintain high moral standards and set an example for your peers in Project Management Who is this Project Management course for? Anyone from any background can enrol in this Operations Manager bundle. Requirements This Project Management 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 (Project Management Masterclass) 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.

Discover the transformative power of structured conversation and thoughtful guidance with our CPD Accredited Life Coaching Course. This online programme offers a professional framework for those who wish to support others in navigating life’s personal and professional hurdles. With clear, thought-provoking modules, it brings insight into motivation, clarity, and behavioural patterns—helping you assist others in setting goals and moving forward with intention. Whether you're already supporting others in a mentoring capacity or you're drawn to the art of listening and guiding, this course invites you to sharpen your ability to ask the right questions and hold space with purpose. Study at your own pace, wherever you are, and build the confidence to use proven coaching approaches with care and precision. Ideal for those who value meaningful dialogue and seek to support growth without stepping into therapy, this course balances structure and flexibility while keeping things refreshingly jargon-free. Course Curriculum: Module 01: Life Coaching: The Purpose and Fundamentals Module 02: Develop Your Self-Awareness Module 03: The Development of Core Beliefs and Managing Fears Module 04: Life Coaching Types and Key Attributes of a Life Coach Module 05: Understanding Emotional Intelligence Module 06: Body Language and Communication Techniques Module 07: A Structure for Client Work and Goal Setting Module 08: Basic Principles for Business Development and Growth Module 09: The Ethical Coach: Protect Yourself and Your Clients Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Life Coaching - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Life Coaching - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Life Coaching - CPD Accredited training.

***Limited Time Exclusive Bundle*** Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Modern Manufacturing and Quality Management and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Modern Manufacturing and Quality Management bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Modern Manufacturing and Quality Management course that will enhance your skills and prepare you for the competitive job market. Also, our Modern Manufacturing and Quality Management experts are available for answering your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Modern Manufacturing and Quality Management, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Modern Manufacturing and Quality Management Bundle Consists of the following Premium courses: Course 01: Modern Manufacturing Course 02: Cost Control Process and Management Course 03: SAP Controlling (CO) - Product Costing S4HANA Course 04: Level 3- Project Management Course 05: People Management Skills Level 3 Course 06: Operations Management Course 07: Quality Management Course 08: SAP Controlling (CO) - Product Costing S4HANA Course 09: Diploma in Lean Process and Six Sigma Course 10: Compliance & Business Risk Management Course 11: Commercial Law 2021 Course 12: Electrical and Fire Safety Training - Level 2 Course 13: First Aid Training Course 14: Time Management Benefits you'll get choosing Apex Learning for this Modern Manufacturing and Quality Management: Pay once and get lifetime access to 14 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 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 (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum of Modern Manufacturing and Quality Management Bundle Course 01: Modern Manufacturing Introduction Electric Discharge Machining Electrochemical Machining Abrasive Jet Machining Ultrasonic Machining Laser Beam Machining Plasma Arc Machining Electron Beam Machining The Finish Line Course 02: Cost Control Process and Management Introduction & Fundamentals Cost Control process Production Control and Tests Test and Checks in Cost Control Monitoring via reports and Checklist Course 03: SAP Controlling (CO) - Product Costing S4HANA Section 1: Introduction Section 2: Material Master Data and Pricing Controls Section 3: BoM, Activities and Routing Section 4: Overheads in Costing Section 5: Costing Sheet Section 6: Costing Variant Section 7: Routing and Work Centres Section 8: Cost Component Structure Section 9: Execution of Standard Cost Estimation Course 04: Level 3- Project Management Key Concepts (I) Key Concepts (II) Initiation (I) Initiation (II) Planning (I) Planning (II) Planning Tools Executing the Project Maintaining and Controlling the Project Closing Out Course 05: People Management Skills Level 3 Introduction to Human Resources Employee Recruitment and Selection Procedure Employee Training and Development Process Performance Appraisal Management Employee Relations Motivation and Counselling Ensuring Health and Safety at the Workplace Employee Termination Employer Records and Statistics Essential UK Employment Law Course 06: Operations Management Introduction to Operations Management Project Management Business Development and Succession Planning Process Management Supply Chain Management Planning & Forecasting Operations Procurement & Purchasing Management Manufacturing & Delivery Operations Quality Management Managing Risk and Recovery Performance Management Talent Management Communication Skills Negotiation Techniques Conflict Management Stress Management Time Management Business Environment Business Writing Skills Course 07: Quality Management Introduction to Quality Management Total Quality Management Quality Measurement and Improvement Quality Control Understanding Customer Expectations and Needs Six Sigma Supply Chain Management Quality Audits Course 08: SAP Controlling (CO) - Product Costing S4HANA Introduction Material Master Data and Pricing Controls BoM, Activities and Routing Overheads in Costing Costing Sheet Costing Variant Routing and Work Centres Cost Component Structure Execution of Standard Cost Estimation Course 09: Diploma in Lean Process and Six Sigma Understanding Lean The Lean Culture The Five Principles of Lean Value and Waste Value Stream Mapping (VSM) The Principles of Flow and Pull Overview of Six Sigma The Define Phase The Measure Phase The Analyse Phase The Improve Phase The Control Phase Course 10: Compliance & Business Risk Management Introduction to Compliance Five basic elements of compliance Compliance Management System (CMS) Compliance Audit Compliance and Ethics Risk and Types of Risk Introduction to Risk Management Risk Management Process Course 11: Commercial Law 2021 Introduction of Commercial law Business Organisations International Trade: the Theory, the Institutions, and the Law Sales of Goods Law Consumer Law and Protection E-Commerce Law Competition Law Course 12: Electrical and Fire Safety Training - Level 2 Introduction and Basics Introduction to Fire Safety Voltage and Resistance Capacitance and Capacitors Safety Precautions Fire Safety Legislation Measures of Fire Safety Fire Emergency: Evacuation Procedures Course 13: First Aid Training Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing With Fractures and Dislocations Call for an Emergency Course 14: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Modern Manufacturing and Quality Management bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Modern Manufacturing and Quality Management is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Modern Manufacturing) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Modern Manufacturing) 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.

Film and VFX face to face training customised and bespoke. One to One Online or Face to Face

OVERVIEW Prerequisites—DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models. During this course you will review: Writing DAX formulas. Defining calculated tables and columns. Defining measures. Using DAX iterator functions. Modifying filter context. Using DAX time intelligence functions. After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns. COURSE BENEFITS: Understand Analytic queries in Power BI Create calculated tables, calculated columns and measures Use DAX functions and operators to build DAX formulas Use DAX iterator functions Create formulas that manipulate the filter context Use DAX time intelligence functions WHO IS THE COURSE FOR? Analysts with experience of Power BI wishing to develop more advanced formulas in DAX Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable LAB OUTLINE Lab 1 Setup Connect to data and understand the objectives of the future labs Lab 2 Write DAX Formulas For Power BI Create a measure Use variables in the measure definition Lab 3 Add Calculated Table And Columns Duplicate a table Create a hierarchy Create a date table Add calculated columns Lab 4 Add Measures To Power BI Desktop Models Add an implicit measure to a report Add an explicit measure Add a compound measure Add a quick measure Lab 5 Use DAX Iterator Functions In A Power BI Desktop Model Complex summarization Higher grain summarization Create ranking measure Lab 6 Modify DAX Filter Context In Power BI Desktop Models Apply Boolean expression filter Remove filters: use ALL Remove filters: use AllSelected Preserve filters: use KeepFilters HASONEVALUE ISINSCOPE Context transition Lab 7 Use DAX Time Intelligence Functions In Power BI Desktop Models TOTALYTD SAMEPERIODLASTYEAR Calculate new occurrences Snapshot calculations