4679 Operations courses

Overview This comprehensive course on Lean Six Sigma White Belt course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Lean Six Sigma White Belt course comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Lean Six Sigma White Belt course. It is available to all students, of all academic backgrounds. Requirements Our Lean Six Sigma White Belt course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so 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 these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 37 lectures • 02:05:00 total length •Introduction: 00:04:00 •Let's set the scene: 00:03:00 •What is quality?: 00:05:00 •Why a focus on quality is important: 00:03:00 •What is Lean?: 00:03:00 •History of Lean: 00:04:00 •The 8 Wastes: 00:01:00 •Defects: 00:02:00 •Overproduction: 00:02:00 •Waiting: 00:02:00 •Non-utilised talent: 00:03:00 •Transport: 00:02:00 •Inventory: 00:02:00 •Motion: 00:02:00 •Extra-processing: 00:02:00 •VA vs. NVA: 00:05:00 •Creating value: 00:04:00 •Process: 00:03:00 •What is Six Sigma?: 00:04:00 •History of Six Sigma: 00:02:00 •Good quality vs. Six Sigma quality: 00:04:00 •DMAIC: 00:05:00 •Belts & roles: 00:03:00 •Six Sigma in action: 00:06:00 •Voice of the customer: 00:06:00 •Critical to quality: 00:04:00 •The 7 tools of quality - a high level reminder: 00:01:00 •Process Map: 00:06:00 •Check sheet: 00:04:00 •Histogram: 00:04:00 •Pareto Chart: 00:04:00 •Fishbone Diagram: 00:05:00 •5 Whys: 00:05:00 •Run Chart: 00:04:00 •Close out: 00:06:00 •Resources - Lean Six Sigma White Belt course: 00:00:00 •Assignment - Lean Six Sigma White Belt course: 00:00:00

Sage 50 Payroll Complete Course Course Overview: The "Sage 50 Payroll Complete Course" is designed to provide a thorough understanding of payroll processing using Sage 50 software. It covers everything from the basics to intermediate-level payroll management, enabling learners to confidently handle payroll operations. This course is ideal for those looking to enhance their payroll skills and streamline processes in line with UK regulations. Learners will gain essential knowledge on managing employee records, tax calculations, and statutory deductions, providing them with the tools to ensure accuracy and compliance. By the end of the course, participants will be equipped to manage payroll functions efficiently, saving time and reducing errors, making them invaluable assets to any organisation. Course Description: This course offers in-depth coverage of Sage 50 Payroll, starting with essential payroll concepts and progressing to intermediate-level skills. Learners will explore topics such as setting up and maintaining employee records, calculating PAYE, National Insurance, and pension contributions, as well as processing holiday pay, sick leave, and other statutory deductions. The course is structured to help learners understand the complexities of payroll management, ensuring they can apply the knowledge in real-world scenarios. Throughout, learners will gain the confidence to navigate Sage 50 Payroll software and understand the payroll process within a UK context, adhering to current laws and regulations. Sage 50 Payroll Complete Course Curriculum: Module 01: Sage 50 Payroll For Beginners Module 02: Sage 50 Payroll Intermediate Level (See full curriculum) Who is this course for? Individuals seeking to gain proficiency in payroll management. Professionals aiming to advance their career in payroll administration. Beginners with an interest in payroll or accounting roles. Anyone looking to understand UK payroll processes. Career Path: Payroll Administrator Payroll Manager HR Officer Accounts Assistant Finance Officer

HR Management Course Overview: This HR Management Course is designed to equip learners with essential knowledge and skills required to effectively manage human resources within any organisation. Covering key aspects of HR management, including recruitment, performance management, employee relations, and legal considerations, the course offers a comprehensive understanding of the core responsibilities of HR professionals. Learners will gain the confidence to tackle HR challenges in the workplace, improve organisational culture, and ensure compliance with employment laws. By the end of the course, participants will be well-prepared to contribute to HR strategy and operational efficiency in various sectors. Course Description: This course delves deeper into HR functions, offering insights into crucial topics such as employee engagement, talent acquisition, workforce development, and conflict resolution. Learners will explore modern HR practices, the role of HR in organisational development, and the application of HR policies within different industries. The course provides a solid foundation in understanding HR operations, helping learners develop the skills needed to manage employee lifecycle processes effectively. Emphasis is placed on understanding legal frameworks, diversity and inclusion, and managing change within the workforce, preparing learners for dynamic HR roles in any business environment. HR Management Course Curriculum: Module 01: Introduction to HR Management Module 02: Recruitment and Selection Strategies Module 03: Employee Engagement and Retention Module 04: Performance Management and Development Module 05: Employment Law and Ethical Considerations Module 06: Compensation and Benefits Management Module 07: Workforce Diversity and Inclusion Module 08: Managing Change in the Workforce (See full curriculum) Who is this course for? Individuals seeking to build a career in HR management. Professionals aiming to enhance their HR skills for career progression. Beginners with an interest in human resources and organisational development. HR specialists looking to update their knowledge and practices. Career Path: HR Manager Recruitment Specialist Employee Relations Manager Talent Acquisition Specialist HR Consultant Learning and Development Coordinator

How to Analyse & Maximize Restaurant Profits Course Overview This course on "How to Analyse & Maximize Restaurant Profits" offers comprehensive insights into understanding the financial dynamics of a restaurant business. It covers key concepts such as revenue analysis, menu optimisation, and cost control strategies to help learners identify areas of improvement for enhanced profitability. By the end of the course, learners will have a thorough understanding of the various factors influencing restaurant performance, from pricing strategies to inventory management. This course provides valuable skills that enable learners to make informed decisions that directly impact the bottom line of any restaurant business. Course Description In this course, learners will explore essential topics such as restaurant revenue analysis, menu engineering, and cost management. The course delves into the principles of profit maximisation, offering strategies to analyse sales data, optimise menu offerings, and manage food and labour costs efficiently. Learners will acquire skills in identifying profitable menu items, reducing waste, and increasing operational efficiency. This in-depth course is designed to equip participants with the knowledge and strategies needed to improve the profitability of a restaurant, ensuring they can make data-driven decisions to drive growth and sustainability. How to Analyse & Maximize Restaurant Profits Curriculum Module 01: Introduction Module 02: Restaurant Revenue Analysis Module 03: Menu Engineering Report Module 04: Cost Analysis & Management (See full curriculum) Who is this course for? Individuals seeking to understand restaurant profitability. Professionals aiming to enhance their skills in restaurant management. Beginners with an interest in the food and hospitality industry. Entrepreneurs looking to improve restaurant financial performance. Career Path Restaurant Manager F&B (Food and Beverage) Operations Manager Menu Analyst Financial Analyst in the hospitality industry Restaurant Owner/Entrepreneur

Leadership and Management Essential Skill Course Overview: The "Leadership and Management Essential Skill" course provides an in-depth exploration of key concepts, strategies, and tools essential for effective leadership and management. Learners will gain a comprehensive understanding of leadership theories, management principles, and the critical differences between the two. Designed for those seeking to enhance their managerial expertise, the course delves into leadership styles, their impact, and the common challenges leaders face. By completing this course, participants will be equipped to lead teams with confidence, make informed decisions, and effectively manage diverse challenges in the workplace. Course Description: This course covers a range of topics that are fundamental to leadership and management. Learners will explore core management principles, including decision-making and organisational strategies, and apply leadership theories to real-world scenarios. The course also examines the differences between leadership and management and provides insight into the obstacles leaders face, such as resistance to change and conflict resolution. Various leadership styles will be discussed, along with their impacts on team dynamics and the importance of mentoring. Upon completion, learners will possess a strong foundation in both leadership and management, enabling them to apply their knowledge to various professional environments. Leadership and Management Essential Skill Curriculum: Module 01: Principles of Management Module 02: Applied Theories on Leadership Module 03: Leadership and Management Differences & Applications Module 04: Obstacles in Leadership and Management Module 05: Different Leadership Styles Module 06: Impact of Different Leadership Style and Mentoring (See full curriculum) Who is this course for? Individuals seeking to develop leadership capabilities. Professionals aiming to advance in management roles. Beginners with an interest in leadership or management. Anyone looking to improve team and organisational performance. Career Path: Team Leader Project Manager Department Head Operations Manager Senior Executive Leadership Consultant

Soar into a dynamic aviation role with our CPD-accredited Air Cabin Crew Diploma – a flexible, online course designed for those with a passion for air travel and passenger service. This engaging programme delivers in-depth knowledge of cabin crew operations, in-flight procedures, aviation safety, and customer interaction – all from the comfort of your own space. Whether you’re aiming for your first role with an airline or simply exploring the industry, this course gives you the confidence to speak the language of the skies. You’ll explore everything from cabin announcements and security measures to emergency protocols and cultural sensitivity onboard. With structured modules and self-paced learning, it's tailored for individuals who prefer the freedom of online study without compromising on quality. No need for boarding passes or travel — just a reliable internet connection and your ambition. Ideal for career-focused learners, jet-set dreamers, or anyone who’s ever looked at a flight attendant and thought, “That could be me.” Ready for takeoff? Let’s get your training underway. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Cabin Crew profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: Introduction to Aircraft Cabin Crew Module 02: Understanding Different Types of Airlines Module 03: Role of Regulatory Bodies and Trade Associations Module 04: Things to Know about a Cabin Crew Life Module 05: Advantages and Disadvantages of a Cabin Crew Career Module 06: Recruitment Preparation for Pursuing a Cabin Crew Career Module 07: Cabin Crew Interview Formats Module 08: Training Procedures Module 09: Aviation Abbreviation and Airport Codes Module 10: The Layout of a Commercial Aircraft Module 11: Cabin Familiarisation for a Cabin Crew Module 12: Departments of Airlines and their Interconnection with Cabin Crew Module 13: Knowledge of Currencies, 24 Hour Clock and Phonetic Alphabet Module 14: Basic Knowledge of Weather Regarding Aviation Module 15: Duties of a Cabin Crew Module 16: Communication with the Passenger Module 17: Aircraft Galley Module 18: Emergency Evacuation System Module 19: Tackling the Event of a Fire Module 20: Medical First Aid Module 21: Personal Grooming of Cabin Crew Module 22: Cabin Crew Fatigue Management Module 23: Crew Resource Management Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Air Cabin Crew Diploma - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Air Cabin Crew Diploma - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 15 CPD hours / points Accredited by The CPD Quality Standards Who is this course for? The Air Cabin Crew Diploma - 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 Air Cabin Crew Diploma - CPD Accredited training.

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) 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 Introduction to MongoDB for DBAs (TTDB4680) 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.

Join our Microsoft Power BI Masterclass course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Power BI Masterclass course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Power BI Masterclass course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Power BI Masterclass. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Power BI Masterclass course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Power BI Masterclass is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Power BI Masterclass course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Power BI Masterclass Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:02:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up - Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Microsoft Power BI Masterclass 00:00:00

Course Overview The Food Safety and Hygiene Level 2 course is designed to equip learners with a strong understanding of the key principles underpinning food hygiene and safety in the UK. Covering essential topics such as microbiological hazards, legislation, allergen control, and hygiene practices, this course prepares learners to contribute effectively to safe food handling environments. Whether you're working in catering, hospitality, retail, or food production, the knowledge gained through this course helps ensure food is handled in compliance with UK standards. By the end of the course, learners will be confident in identifying hazards, understanding legal responsibilities, and maintaining hygienic practices within food premises. It also includes timely guidance for adapting food businesses during COVID-19, supporting learners in meeting current industry expectations. Course Description This CPD-accredited course explores the foundations of food safety and hygiene, including a detailed look into food legislation, storage, preparation, and cleaning protocols. Learners will gain insights into the causes of foodborne illnesses, methods to prevent cross-contamination, and best practices for managing allergenic, chemical, and physical hazards. The course also highlights the importance of personal hygiene, structural cleanliness, and effective waste control within food premises. A dedicated module addresses how food businesses can operate safely during and after the COVID-19 pandemic. Designed to support learners in understanding their responsibilities under food law, this course promotes awareness and compliance in diverse food-handling settings, from small catering units to large-scale food operations. Course Modules Module 01: Food Safety Legislation Module 02: Microbiological Hazards Module 03: Physical, Chemical and Allergenic Hazards Module 04: Food Storage Module 05: Food Preparation Module 06: Personal Hygiene Module 07: Food Premises Design and Cleaning Schedules Module 08: Further Information Module 09: Reopening and Adapting Your Food Business During COVID-19 (See full curriculum) Who is this course for? Individuals seeking to meet UK food safety training requirements. Professionals aiming to develop their food safety knowledge for supervisory or compliance roles. Beginners with an interest in food hygiene and regulatory standards. Business owners and managers in catering, hospitality, or food production. Career Path Food Safety Officer Catering Assistant Kitchen Supervisor Restaurant or Café Manager Food Retail Worker Compliance Assistant in Food Manufacturing

Course Overview The Xero Accounting and Bookkeeping Level 7 course offers a comprehensive understanding of digital accounting using Xero software, tailored for individuals looking to advance in financial management and bookkeeping roles. This course equips learners with essential knowledge to manage sales, purchases, payroll, VAT, and fixed assets efficiently. Learners will also explore how to maintain accurate financial records and ensure compliance with current UK regulations. Whether you are looking to upgrade your skills or step into a new career, this course supports your professional development by building competence in cloud-based accounting practices. Upon completion, learners will have the confidence to work in a variety of finance-related roles and contribute effectively to any business or organisation’s accounting functions. Course Description This course delves into core areas of Xero accounting, starting with an introduction to the software and progressing through key functionalities including sales invoicing, purchase management, bank reconciliation, and payroll processing. Learners will be guided through each section in a structured and accessible way, allowing them to understand how to set up and manage accounts, handle tax returns, and record transactions accurately. Additional topics such as fixed asset tracking and product/service management provide a complete view of digital bookkeeping in a professional context. The curriculum is designed to align with UK financial standards and includes a detailed exploration of VAT return procedures. By the end of the course, learners will develop a strong grasp of Xero’s interface, gain proficiency in managing financial tasks digitally, and enhance their confidence to support accounting operations within various business settings. Course Modules Module 01: Introduction Module 02: Getting Started Module 03: Invoices and Sales Module 04: Bills and Purchases Module 05: Bank Accounts Module 06: Products and Services Module 07: Fixed Assets Module 08: Payroll Module 09: VAT Returns (See full curriculum) Who is this course for? Individuals seeking to develop advanced accounting skills using cloud-based software. Professionals aiming to improve their bookkeeping knowledge and career progression. Beginners with an interest in digital finance and business accounting. Small business owners and administrative staff managing company accounts. Career Path Xero Bookkeeper Accounts Assistant Payroll Officer Finance Administrator VAT Compliance Officer Office Manager (with financial duties) Small Business Accountant