392 Analyst courses in Downpatrick delivered Live Online

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

Agile Sprint Planning: Virtual In-House Training The goal of the course is to provide you and your team with the ability to develop effective and realistic Sprint plans. Without effective Sprint Plans, iterations are set up for failure. But Sprint Planning cannot be improved on its own, in isolation. The Scrum processes are highly intertwined and influence each other. The surrounding artifacts, events, and roles must be examined closely, and enhanced, in order to improve Sprint Planning. This course will remind you of the theory to reinforce the principles, but will concentrate on next-level skills, so that you and the team are able to create realistic and usable Sprint Plans. This course is not introductory. You are already aware of the Scrum framework and have been implementing Scrum on your projects. Now is the time to improve efficiency and effectiveness, to facilitate successful Agile projects. What you will Learn You'll learn how to: Identify and correlate the key symptoms and root causes of ineffective sprint plans Improve key Product Backlog elements Evaluate Agile roles in sprint planning Appraise key product practices Enhance project transparency The Product Backlog User stories Acceptance Criteria Backlog Refinement Supporting Roles Product Owner (the Backlog) Development Team Stakeholders and SMEs Supporting Product Practices Roadmaps and release plans and story maps Definition of Done Technical Debt Transparency Daily Scrums Information radiators Retrospectives Sprint Planning Capacity and Velocity Sprint Planning Meetings The Sprint Backlog Summary What did we learn, and how can we implement this in our work environments?

Agile Release Plans: Virtual In-House Training While many Agile frameworks provide guidance on a focus on value and iterative development, many do not explain how that value is delivered to the customer. Release Plans have become an accepted and common practice to bridge the gap between the Product Vision and the Product Backlog (Agile requirements). In this course, you will be provided with an introduction to Agile and to Scrum, the most utilized Agile framework. You will also learn how the Vision, Roadmap, and Charter help to establish the Release Plan. The goal of this course is to equip you with the necessary knowledge, skills, and techniques to build Release Plans to ensure you deliver the most value to your customers. What you will Learn At the end of this program, you will be able to: Recall the Scrum framework elements (roles, events, and artifacts) Examine the benefits of Agile Develop a Product Vision and Roadmap Create an Agile Project Charter Prepare a Release Plan Write user stories to support a Product Backlog Foundation Concepts Introduction to Scrum Scrum Overview Agile Benefits Product Definition Business Goals Product Vision Product Roadmap Agile Project Charter Product Scope Project Risks Release Deadlines Sprint Durations Team Norms Release Planning Release Plan Process Select Stories and a Release Date Product Backlog User stories Building the product backlog Product Backlog Refinement Transitioning to the Scrum Team

Agile Practices for All Projects: Virtual In-House Training Agile methods are becoming increasingly prevalent, and have facilitated projects in reducing time to market, being adaptive to changing customer requirements, and increasing value to customers and organizations. These benefits have been implemented in both IT and non-IT environments to help all types of projects. This course will present key Agile techniques and processes that can be readily incorporated into your projects to enable greater flexibility and higher productivity, while maintaining the traditional project lifecycle framework. The overall goal of the course is for learners to be able to integrate appropriate Agile elements and/or techniques into any project in any environment. What you will Learn Course participants will understand the basic Agile approach, and the various methods for achieving agility and will be able to: Recall project management principles and methodologies Explain Agile practices and compare several Agile methods Apply Agile software development techniques in a project lifecycle framework Employ Agile processes in a project management framework Foundation Concepts Project Lifecycles What is Agile? Agile Benefits Agile Methods Agile Roles Agile Requirement Techniques Agile Requirements User Stories Just in Time (JIT) Requirements Agile Software Development Techniques Agile Design Agile Development Agile Testing Agile Deployment Agile Initiating & Planning Processes Agile Initiating Agile Planning Agile Delivery Processes Agile Execution Agile Monitoring & Control Agile Closing Implementing Agile Practices Agile Approaches Outside of Software Development Dispelling Agile Myths Applying Agile Techniques & Processes Summary and Next Steps What did we learn, and how can we implement this in our work environments?

Virtual Agile Teams: Virtual In-House Training Agile teams are a must in this world of intense competition, marketing demands, and changing expectations. Global virtual teaming has become a necessity as organizations become increasingly distributed, with suppliers and clients actively engaged in joint projects. Agile Teams now work across geographical, organizational, and cultural boundaries to deliver solutions and services to global users. Distance and differences may amplify the effect of issues and factors that are relatively straightforward for co-located Agile teams. This workshop delivers practical concepts and techniques that participants will start using immediately with their virtual Agile teams. The goal of the course is to enable you to successfully execute your preferred Agile or Scrum methods in a virtual project team environment. What you will Learn At the end of this program, you will be able to: Explain the characteristics of a virtual team and how they differ from a co-located team Build an effective virtual Agile team using a Team Charter approach Develop Release Plans, including prioritizing user stories, with a virtual Agile Team Construct a Sprint plan, including effective user story estimates, virtually Execute a Sprint, including essential Agile or Scrum ceremonies, virtually Conduct effective virtual meetings in an environment supportive of Agile and Scrum methods Foundation Concepts Agile Mindset and Values Agile Benefits and Methods Scrum Overview Co-located vs. Virtual Teams Forming Virtual Agile Teams Exploring Virtual Leadership Focusing on Virtual Agile Leaders Developing a Virtual Agile Team Charter Meeting Team Challenges in a Virtual Environment Planning Releases with a Virtual Agile Team Planning releases overview Estimating user stories Prioritizing user stories Setting release parameters Getting consensus on the release plan Planning a Sprint for a Virtual Project Sprint Planning Overview Confirming Sprint Scope with Virtual Agile Teams Developing a Sprint Delivery Plan for Virtual Agile Teams Running a Sprint in a Virtual Environment Self-organizing a Sprint for a Virtual Agile Team Using Scrum tools in a Virtual Environment Conducting End of Sprint Meetings in a Virtual Environment Iterating as a Virtual Agile Team Creating an Environment for Success Piloting a virtual Agile team Creating an Agile-friendly virtual environment

Course Overview This comprehensive course is designed to provide a well-rounded understanding of GDPR compliance, data protection frameworks, and key cyber security legislation in the UK and beyond. Covering topics from legal obligations under the General Data Protection Regulation to the implications of cyber crime on modern business, this programme equips learners with the knowledge needed to navigate the increasingly regulated digital landscape. Whether you are responsible for handling sensitive data or advising on compliance procedures, this course offers vital insight into maintaining data integrity and organisational transparency. Upon completion, learners will be able to interpret key legal requirements, identify risk areas, and support best practices within their professional setting. Course Description The GDPR Compliance, Data Protection & Cyber Security Law course explores a range of essential subjects that influence today’s data-driven industries. Learners will gain a strong foundation in legal and regulatory aspects of data handling, including the principles of GDPR, cyber law, and anti-money laundering frameworks. The course also includes modules on commercial and business law to deepen understanding of corporate responsibilities in data management. Ideal for legal assistants, compliance officers, or business managers, this course helps learners enhance their ability to assess data security measures and ensure alignment with current regulations. With a structured curriculum and accessible learning materials, this programme supports learners in achieving a robust legal and regulatory understanding. Course Modules: Module 01: GDPR Module 02: Data Protection Module 03: Paralegal Training Module 04: Commercial Law Module 05: Cyber Law Online Course Module 06: Business Law Module 07: Cyber Security Awareness Training Module 08: Anti-Money Laundering (AML) Training (See full curriculum) Who is this course for? Individuals seeking to understand GDPR and data security regulations. Professionals aiming to improve compliance and data governance within their roles. Beginners with an interest in legal and cyber regulatory frameworks. Business owners, managers, or HR personnel responsible for policy implementation. Career Path Data Protection Officer (DPO) Compliance Consultant Cyber Security Policy Advisor Paralegal in Commercial or Cyber Law Information Governance Analyst Risk and Compliance Coordinator Legal and Regulatory Affairs Assistant

Course Overview The DeepSeek Masterclass: A Complete DeepSeek Zero to Hero! provides a comprehensive exploration of the DeepSeek AI ecosystem, designed to guide learners from fundamental understanding to advanced applications. This course equips individuals with the knowledge to navigate the capabilities of DeepSeek across various domains such as software development, business analysis, and education. Whether you're looking to stay current in a rapidly evolving technological landscape or explore how AI transforms diverse sectors, this course offers a structured pathway. By the end of the programme, learners will be able to understand DeepSeek’s architecture, apply its tools across multiple contexts, and critically evaluate its potential within both technical and professional settings. Course Description This course delves into the foundational principles and progressive applications of DeepSeek, starting from basic concepts in artificial intelligence through to its tailored use in education, business, and software environments. Learners will explore how to configure and interpret DeepSeek outputs, understand the structure of AI decision-making, and evaluate its integration across various workflows. Key modules address the needs of developers, educators, students, and professionals seeking efficient AI-driven solutions. Throughout the course, learners will be introduced to scenario-based uses of DeepSeek, helping them build a contextual understanding of its functions. The curriculum is designed to support strategic thinking, digital literacy, and informed adoption of AI tools in both academic and professional environments. Course Modules Module 01: Getting Started Module 02: Foundations of Artificial Intelligence (AI) Module 03: Setting up DeepSeek AI for Beginners Module 04: DeepSeek for Software Developers Module 05: DeepSeek for Business Professionals Module 06: DeepSeek Smart Solutions for Students Module 07: The Power of DeepSeek Module 08: DeepSeek for Teaching Professionals (See full curriculum) Who is this course for? Individuals seeking to build an informed understanding of DeepSeek and AI. Professionals aiming to implement AI solutions within their field. Beginners with an interest in artificial intelligence and its uses. Educators, students, and technologists exploring innovative learning and working tools. Career Path AI Integration Analyst Business Intelligence Associate Education Technology Consultant Software Solution Strategist Digital Transformation Specialist AI Literacy Educator

Course Overview This comprehensive course in Supply Chain Management, Purchasing & Procurement provides learners with the strategic knowledge and operational understanding needed to navigate today’s dynamic supply environments. It explores the core components of supply chain systems, procurement cycles, and purchasing strategies, offering insight into effective logistics planning, supplier relations, and risk mitigation. Learners will gain the tools to streamline processes, optimise procurement decisions, and align purchasing objectives with broader business goals. Designed to support both career development and organisational efficiency, the course equips participants with a strong foundation in modern supply chain functions—contributing to smarter decision-making and improved supply performance. Course Description This course delves into the critical areas of supply chain operations, from foundational concepts to advanced procurement practices. Participants will study logistic management frameworks, category and inventory management, transport coordination, and supplier relationship strategies. Special focus is given to procurement tools, bid management, and cost reduction techniques that can enhance purchasing functions. Through each module, learners are introduced to effective methods for improving supply accuracy, managing quality, and applying risk assessment across sourcing channels. The course supports learners in understanding the interconnected nature of global supply networks, helping them contribute more effectively to procurement, planning, and supplier engagement in diverse business settings. Course Modules Module 01: Supply Chain Basics Module 02: Supply Chain Drivers Module 03: Introduction to Logistic Management Module 04: Planning Framework for Logistics Module 05: Transport Management Module 06: Role of Procurement in an Organisation Module 07: The Purchasing Cycle Module 08: Purchasing Toolkits Module 09: Managing Competitive Bids Module 10: Quality Management Module 11: Supplier Relationship Management Module 12: Analysing and Reducing Risk in the Supply Chain Module 13: Improving Efficiency and Accuracy Module 14: Category Management Module 15: Inventory Management Module 16: E-Procurement (See full curriculum) Who is this course for? Individuals seeking to build a career in procurement or logistics. Professionals aiming to upskill in supply chain operations. Beginners with an interest in purchasing and supply management. Business owners or team leaders looking to optimise procurement processes. Career Path Supply Chain Analyst Procurement Officer Purchasing Manager Inventory Control Specialist Logistics Coordinator Category Manager Supplier Relationship Manager Operations Executive in manufacturing, retail, or distribution sectors

Course Overview The Computer Maintenance, PAT & Cyber Security course offers a comprehensive introduction to the essential components of modern IT systems, combining core knowledge in hardware setup, system troubleshooting, and security protocols. Designed to build foundational understanding as well as introduce advanced cybersecurity concepts, this course equips learners with the confidence to navigate today’s digital infrastructure. From building a computer to understanding network vulnerabilities, learners will explore a variety of modules that address both traditional and emerging technologies, including IoT and encryption. By the end of the course, students will have developed the skills to identify risks, support device performance, and understand secure systems architecture—essential for any role in technology-focused sectors. Course Description This course blends key topics across computer hardware maintenance, PAT (Portable Appliance Testing), and cyber security to prepare learners for a well-rounded understanding of IT system management. The curriculum begins with assembling and configuring computers, progressing into network security and advanced Windows troubleshooting. Learners are introduced to essential software tools and coding applications like C++ with OpenCV, and gain insights into the Internet of Things and encryption principles. Additionally, the course includes training in cyber security awareness, addressing the latest threats and preventative frameworks. With clear instructional guidance and structured content delivery, the course is suitable for learners aiming to understand technical environments and the protocols behind secure computing. It is ideal for those seeking career progression or looking to explore new opportunities in IT security, maintenance, or systems analysis. Course Modules: Module 01: Building Your Own Computer Module 02: Computer Networks Security from Scratch to Advanced Module 03: Computer Vision By Using C++ and OpenCV with GPU support Module 04: Advance Windows 10 Troubleshooting for IT HelpDesk Module 05: Portable Appliance Testing (PAT) Module 06: Internet of Things Module 07: Cyber Security Awareness Training Module 08: Encryption (See full curriculum) Who is this course for? Individuals seeking to understand IT maintenance and cybersecurity principles. Professionals aiming to broaden their knowledge of system configuration and data protection. Beginners with an interest in computer technology and digital safety. Employers looking to upskill their IT or facilities staff in security and device compliance. Career Path IT Support Specialist Systems Administrator Network Security Analyst Cyber Security Consultant Electrical Safety Compliance Officer Technical Services Coordinator

Course Overview This comprehensive Anti-Money Laundering (AML) Training Level 5 course offers a deep exploration of the UK’s anti-money laundering regulations and reporting requirements. Learners will gain a solid understanding of money laundering typologies, the legal framework surrounding the Proceeds of Crime Act 2002, and the roles and responsibilities of compliance professionals. Through structured learning, this course prepares individuals to effectively identify, assess, and report suspicious activity within financial and non-financial institutions. Ideal for professionals in banking, finance, legal, and corporate sectors, the course builds awareness of AML obligations and supports regulatory alignment. Upon completion, learners will possess the theoretical knowledge required to contribute to financial crime prevention, risk management, and organisational integrity. Course Description The Anti-Money Laundering (AML) Training Level 5 course is designed to equip learners with an in-depth understanding of regulatory requirements, reporting procedures, and due diligence obligations. The course examines key legislation such as the Proceeds of Crime Act 2002, and outlines the development of AML frameworks across sectors. Learners will study the responsibilities of the Money Laundering Reporting Officer (MLRO), the importance of record-keeping, and how to implement a risk-based approach in compliance programmes. Emphasis is placed on identifying suspicious transactions, maintaining regulatory standards, and fostering awareness throughout an organisation. Whether preparing for a role in compliance or enhancing existing knowledge, this course supports learners in aligning with UK regulatory expectations and strengthening their ability to safeguard businesses from financial crime. Course Modules: Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Office Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training (See full curriculum) Who is this course for? Individuals seeking to understand financial crime regulations and prevention measures. Professionals aiming to transition into compliance, audit, or financial regulation roles. Beginners with an interest in anti-money laundering, financial oversight, or legal studies. Employees responsible for ensuring compliance within financial or legal institutions. Career Path Anti-Money Laundering Officer Compliance Analyst Risk and Governance Associate Financial Crime Consultant Internal Auditor Regulatory Affairs Specialist Legal and Compliance Assistant