Overview This comprehensive course on Complete Microsoft Power BI 2021 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Microsoft Power BI 2021 comes with accredited certification from CPD, 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 Complete Microsoft Power BI 2021. It is available to all students, of all academic backgrounds. Requirements Our Complete Microsoft Power BI 2021 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 140 lectures • 14:25:00 total length •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 •Creating our initial project file: 00:04:00 •Working with the attached project files: 00:04:00 •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 1 - Exercise Solution: 00:11:00 •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 •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 •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 •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 •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 •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 •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 •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 •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 •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 •Congratulations & next steps: 00:06:00 •The End: 00:01:00 •Resources - Complete Microsoft Power BI 2021: 00:00:00
The Functional Skills English Diploma – QLS Endorsed Course offers a smart and flexible way to boost your core English skills without setting foot in a classroom. Whether you're brushing up for work, study, or daily communication, this online course sharpens your grasp of grammar, reading, writing, and listening – all in a way that fits around your schedule. Think of it as a thoughtful nudge towards better confidence with words, not a lecture in disguise. Designed for those who want to improve their English in a straightforward, engaging way, this course keeps things clear, relevant, and refreshingly nonsense-free. You won’t find fluff or filler here – just purposeful learning built around real, everyday needs. From sentence structure to spelling, it’s all delivered online, at your pace, with no awkward group activities or clunky downloads. A smart choice for anyone who prefers substance over sales talk – and wants their English to sound as polished as their intentions. Our Functional Skills English Diploma course is endorsed by the Quality Licence Scheme - QLS, ensuring you acquire new skills and enhance your professional development. Functional Skills English Diploma QLS Bundle Includes the following Courses Course 01: Diploma in Functional Skills English at QLS Level 2 Course 02: English: Spelling, Punctuation, and Grammar - Practical Demonstration Course 03: GCSE English Course 04: Effective Writing Skills Course 05: Functional Skills Maths Level 2 Key Features of Functional Skills English Diploma Eligibility for QLS endorsed certificate upon successful completion of the Functional Skills English Diploma course Free CPD Accredited Course Fully online, interactive Functional Skills English Diploma course with audio voiceover Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases To become successful in your profession, you must have a specific set of skills to succeed in today's competitive world. In this in-depth Functional Skills English Diplomatraining course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. Assessment At the end of the Functional Skills English Diploma course, we will provide assignment and quizzes. For each test, the pass mark will be set to 60%. Accreditation This Functional Skills English Diploma course is QLS - Quality Licence Scheme Endorsed and CPD Certified, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification CPD Certified: Once you've successfully completed your Functional Skills English Diploma course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). QLS Endorsed:After successfully completing the Functional Skills English Diploma course, learners will be able to order an endorsed certificate, titled: Diploma in Functional Skills English at QLS Level 2, as proof of their achievement. This certificate of achievement endorsed by the Quality Licence Scheme. CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Functional Skills English Diploma basics. Requirements No prior degree or experience is required to enrol in this Functional Skills English Diploma course. Career path This Functional Skills English Diploma Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.
Duration 5 Days 30 CPD hours This course is intended for This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore: The Oracle Database Architecture Query Optimizer Tuning Container Databases and Pluggable Databases Oracle 19c Tuning features Evaluating Execution Plans Oracle Tuning Tools Using Automatic Workload Repository Join Types AWR Using Baselines Additional AWR performance tools Optimizer Statistics Monitoring a Service Bind Variables and database parameters Oracle's Real Application Testing (RAT) SQL Tuning Advisor Automatic Sql Tuning Sql Plan Management Shared Pool Tuning Tuning the database buffer cache Tuning the PGA (Program Global Area) Automatic Memory Management (AMM) Tuning Segment Space Utilization (ASSM) Automatic Storage Management Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more. Overview Oracle Database Architecture Instance Definition Define SGA Define Background Processes Datafile Definition Query Optimizer SQL Parsing Optimizing Terms Optimizing Methods Query Plan Generation Query Plan Control Tuning Container Databases and Pluggable Databases Pluggable tuning parameters Define Container tuning structure Using PDB$SEED Create a new PDB Plug and unplug a PDB Oracle 12c Tuning features Identifying and Using Oracle's Heat Map 12c Compression Levels and Types Evaluating Execution Plans Defining SQL execution plans Automatic Workload Repository Reading execution plans Oracle Tuning Tools Monitoring tools overview Enterprise Manager Dynamic Performance Views Automatic Workload Repository Automatic Database Diagnostic Monitor Sql Tuning Advisor SQL Access Advisor Sql Access Advisor DB operation Tuning DB operation Active Reporting Using Automatic Workload Repository Defining AWR AWR Settings Creating AWR Baselines Metrics, Alerts, and Thresholds Defining Metrics Setting Alerts Setting Corrective Actions User Defined Metrics Metric Dynamic Views Join Types Nested Loops Join Sort Merge join Hash Join and Cartesian Join Equijoins and Nonequijoins Outer Joins Semijoins AWR Using Baselines Creating AWR baselines Creating AWR Repeating baselines Moving Window Baseline Additional AWR performance tools Automatic Maintenance Tasks Segment Advisor Statistics Gathering Automatic Tuning Optimizer Automatic Database Diagnostic Monitor Active Session History (ASH) Optimizer Statistics Optimizer Statistics Overview Table and Index Statistics Statistic Preferences Statistics Gathering e) Locking Statistics, Export/Import Statistics Pending and published statistics Optimizer Hints Optimizer Paths Cost Base Optimization Monitoring a Service Overview of what is an Oracle Service Creating an Oracle Service for Single instance and RAC Monitoring a Service Resource Management and a Service Enterprise Manager and a Service Bind Variables and database parameters Bind variable definition Cursor_sharing parameter Adaptive Cursor Sharing Oracle's Real Application Testing (RAT) Sql Performance Analyzer overview Sql Performance Analyzer Options Database Parameter changes Database version changes Creating SQL Tuning Sets Database Replay Overview Database Replay Configuration Database Replay Options SQL Tuning Advisor SQL Tuning Advisor: Overview SQL Tuning Advisor Limited Mode Sql Tuning Advisor Comprehensive mode Sql Tuning Profiles SQL Access Advisor SQL Access Advisor: Overview Sql Access Advisor options SQL Access Advisor and Sql Tuning Sets Sql Access Advisor and AWR Results and Implementation Automatic Sql Tuning Automatic Sql Tuning Maintenance Task Automatic Tuning Optimization implementation(ATO) Automatic Tuning Optimization Results Enable/Disable Automatic Tuning Optimization Sql Plan Management Sql plan Management and baseline overview Enable sql plan management Loading Sql Plan baselines into the SGA Adaptive plan management Shared Pool Tuning Shared pool architecture Shared pool parameters Library Cache Dictionary cache Large pool considerations and contents Tuning the database buffer cache Database buffer cache overview Database buffer cache parameters Oracle and Dirty reads and writes Automatic Shared Memory Management (ASMM) Buffer Cache goals and responsibility Buffer Cache pools Tuning the PGA (Program Global Area) PGA Overview PGA Database Parameters Temporary Segments Temporary Tablespace Sizing the PGA Automatic Memory Management (AMM) Oracle's Automatic Memory Management Overview Database Auto-tuned Parameters Database Non Auto-tuned Parameters Automatic Memory Management Hints and Sizing suggestions AMM versus ASMM Tuning Segment Space Utilization (ASSM) Overview of Automatic Segment Space Management Defining the DB_BLOCK_SIZE Defining DB_nk_CACHE_SIZE parameter The DB_BLOCK_SIZE Parameter Overview of table compression, block chaining, and block migration Automatic Storage Management Overview of ASM Definition of Grid Infrastructure ASM Instance ASM Diskgroups ASM Diskgroup parameters and templates ASMCMD
Unreal Engine 4: The Complete Beginner's Course teaches you the fundamentals of video game development using Unreal Engine 4. Whether you have prior programming knowledge or not, this course will help you leverage the cutting-edge 3D game design software in developing the video games you always wanted.
Learn to operate Nomad to deploy and manage applications and services across multiple environments, including on-premises, cloud, and hybrid. Learn from the expert who will guide you through lectures, demonstrations, and real-world scenarios, giving you the skills and knowledge you need to succeed with Nomad HashiCorp skillsets.
This course will help you master Spring, Spring Boot, Spring Modules - JDBC, AOP, and Data JPA through a hands-on, step-by-step approach. You will also be introduced to unit testing with JUnit and Mockito and learn how to communicate with the database using the Spring framework.
Description Affiliate Marketing is one of the greatest ways for both the business owner and the digital marketer. Enrol the E-commerce and Affiliate Marketing Certificate Course course and learn the effective ways of promoting your e-commerce business using woocommerce Amazon Affiliate Store. Amazon affiliate store allows you to sell Amazon products as an affiliate and gives you a good commission. The course teaches you the practical ways of building a profitable Amazon Affiliate eCommerce Store including the capability of dropshipping physical products. You will learn to create a woocommerce store including WordPress basics and host, choosing a niche and doing researches, adding Affiliate Plugin Comparison, adding Amazon Affiliate Plugin Comparison, etc. The purpose of the course is to help you to start your woocommerce Amazon affiliate store, and upon completion, you will be confident enough to start your Amazon affiliate business. What will you learn in this course? Getting started with focus and mindset while organising and planning tasks Setting up your eCommerce website the right way Picking a niche and doing keyword research for that niche How to design your site and pick a theme Maximising conversions to get more buyers Basic overview of eCommerce SEO Promoting your eCommerce site with Social Media Using free and paid advertising to promote your site Outsourcing Virtual Assistants to help you build your site faster Learning the basics of Email Marketing for eCommerce Moving beyond Amazon Affiliates - Selling on Amazon & eBay Working with Dropshippers and buying products Wholesale How long is the course? This course is split up into 6 weeks, each week you are provided with homework so you have tasks to complete after watching the modules and reading through the content. It may take longer than 6 weeks to complete the entire program, the course is designed to allow you to create a part-time or even full-time eCommerce store if you choose to do so. Most of the advice I provide allows you to make sales without a tonne of commitment when it comes to purchasing physical inventory. You can start slow and grow as you make progress through the course. Check out these awesome testimonials! 'Found this just as I started work on an Amazon site. Really useful advice on how to set up shop. I'm implementing now and honestly, that alone will save me the next few days of my life at this point in my project. Thats worth the price of entry alone. But the course has a lot more to give: outsourcing tips, sensible approach to promotion. Also heaps of stuff on FBA and other things beyond Amazon affiliate that held no interest and I thought weren't really for me, but I can now see offer a lot of potential for growth of my store down the line. Great stuff. I also appreciate the straight up approach here. No typical marketers fluff, filler, hype or BS. Just laying out what seems solid advice and an action plan that will get you up and running in short order. You know the course is solid, as John walks through the set up of one of his sites, which is a cut above the usual robo-Azon affiliate spam site. Maybe the title shouldn't emphasise passive income so much, as its some work to get up and running. Even outsourcing leaves the hassle of managing workers, as we all know. It'd also be better if the intro gave some idea of the minimum kinds of investment of time and money you should expect to put in to get any result. Of course, you can keep it passive, but consumers are more savvy than they've ever been. So i'd suggest getting into this with a view to build out and up: in which case the the slog begins.' - Paul Andrews 'Start off gently as an as an Amazon Affiliate and then transition into your own eCommerce juggernaut. John will show you how it's done and demonstrate the software that makes it possible, easy and profitable.' - Dr. Phillips 'This course is way more than just about Amazon Affiliates. Anyone starting an online business will also benefit from this course there is so much information in here and very useful information. John does a great job keeping you engaged in what he has to say, he's very knowledgeable and shows proof that he knows his stuff! Thanks for a great course John.' - S Howard 'I've used WordPress for years so when I saw this course focused on the WooCommerce plugin I decided to give it a shot. It really is a comprehensive course covering everything you need to know about starting your own Amazon affiliate store.' - Glen Thomas 'I'm very happy to have subscribed and this is a perfect course if you want to setup your own e-commerce store. John is an expert and his advices are very practical and easy to follow. I thoroughly enjoyed the whole course and i have already started implementing them into my own business.' - Hussain Ahmed What Will I Learn? Understand how to create a WordPress WooCommerce Store Create a profitable Amazon Affiliate Store Understand how to create full time business with an eCommerce store Learn about dropshipping & buying products wholesale Understand how to do keyword research How to do basic eCommerce SEO How to promote an eCommerce site with Social Media & Advertising Understand how to hire Virtual Assistants Learn about Amazon FBA Requirements A good understanding of WordPress CMS Registering a domain and getting it hosted Be able to apply to become an Amazon Affiliate (Some States do not allow this) Google Drive Evernote Who is the target audience? Interested in earning with the Amazon Affiliate Program Interested in running a part time or full-time eCommerce business Interested in selling products with the Amazon FBA program Interested in drop shipping or buying products wholesale to sell online Not for those who are not willing to put time and effort into building a good site If you are not interested in selling products online this course might not be for you Week 1 - Introduction Introduction To The Course FREE 00:02:00 Expectations for Cost of Tools and Resources To Build Your Store 00:03:00 Focus & Mindset FREE 00:02:00 Setting Goals 00:02:00 Week 1 - Recommended Site Setup & Tools Learning about WordPress 00:01:00 WordPress Hosting 00:09:00 Becoming an Amazon Affiliate 00:01:00 Organization With Evernote & Google Drive 00:05:00 Week 1 - Niche Selection Choosing Your Niche 00:02:00 Keyword Research 00:02:00 Using the Google Keyword Tool 00:07:00 Amazon Plugin Comparison WordPress WooCommerce & Prosociate 00:03:00 Amazon Affiliate Plugin Comparison 00:04:00 Introduction to Fresh Store Builder 00:04:00 Week 2 - Site Setup (Using Prosociate) Selecting a WooCommerce Theme 00:06:00 Setting Up Google Analytics & Webmaster Tools 00:05:00 Creating Important Content Pages - Contact, About, Privacy Policy & More 00:05:00 Manually Adding Products To Your Store 00:09:00 How To Add Products With Prosociate 00:13:00 Week 2 - Site Conversions Essential WordPress Plugins for Your Site 00:10:00 Designing Your Site The Right Way 00:08:00 Optimizing Your Site For Maximum Conversions 00:06:00 Getting Advice From Experts 00:06:00 Week 2 - SEO On-Page SEO 00:07:00 Off-Page SEO 00:04:00 Week 3 - Social Media Promotion Intro to Social Media 00:01:00 How To Utilize Pinterest Traffic 00:10:00 How To Utilize Wanelo Traffic 00:05:00 Staying Consistent With Social Media On Your Cell Phone 00:01:00 Week 3 - Paid Advertising, Blogging & Promotion Buying Paid Traffic with BuySellAds 00:04:00 Using Interviews To Get Traffic & Free Backlinks 00:11:00 Blogging With Your eCommerce Store 00:04:00 Week 4 - Outsourcing Help & Hiring Virtual Assistants Outsourcing and Hiring on oDesk (Now UpWork) 00:10:00 Finding Friends and Family To Help With Your Store 00:01:00 Week 5 - Email Marketing Starting Out With Email Marketing 00:02:00 Week 6 - Beyond Being Just an Amazon Affiliate - Phasing Into eCommerce Dropshipping Product & Buying Wholesale 00:08:00 Finding Brands On Other Competitor Sites 00:02:00 Getting Organized by Finding Suppliers & Making Smart Purchases 00:06:00 Dropshipping T-Shirts with Printful 00:06:00 Installing an SSL Certificate & Why You Need One 00:01:00 The Free Amazon Payments Plugin for WooCommerce 00:02:00 Registering a Business LLC with LegalZoom 00:03:00 What is Amazon FBA? 00:04:00 My Amazon Fulfillment Process & My Mini Warehouse 00:03:00 Using FBA Multi-Channel Fulfillment To Sell on eBay and Your Own Site 00:07:00 Week 6 - Homework & Beyond Bonus: My Success With Freelancing on UpWork 00:03:00 Flipping Your Site For Profit Selling Your Site On An Auction Site 00:07:00 Becoming an Etsy Affiliate Checking out the Etsy Affiliate Program 00:01:00 An Example Etsy Affiliate Product On My Store 00:04:00 Etsy Affiliate Dashboard in Affiliate Window 00:03:00
This course covers all the requirements of the Microsoft AZ-300 and AZ-303 exams. You will get a detail-oriented approach to all the important concepts that will help you pass the exams and design solutions for the Microsoft Azure platform.
This course is designed to help you understand the basic and advanced concepts of ethical hacking with ease. The course features interesting examples and coding activities in each video to keep you engaged and guides you effectively through writing programs to hack a system.
Duration 2 Days 12 CPD hours This course is intended for Executives, Project Managers, Business Analysts, Business and IT stakeholders working with analysts, Quality and process engineers, technicians, corrective action coordinators or managers; supervisors, team leaders, and process operators; anyone who wants to improve their ability to solve recurring problems. Overview At the completion of this course, you should be able to:Identify the different types of tools and techniques availableApply change management successfullyReview what to look for when applying business case thinking to Root Cause AnalysisDevelop a process to systematically approach problems Problem determination skills cannot be acquired by reading a book. They mostly come from experience. After this course, you will have a general understanding of a structured problem determination approach, which you can then apply in your daily work. RCA Foundation Concepts and Objectives Section Learning Objectives Discuss Definitions ? IT Perspective Discuss What is a problem and why do they exist? Exercise 1a: Why is RCA important What is Root Cause? RCA Benefits and Approaches Exercise 1b: Why are multiple approaches important? Event and Casual Analysis Exercise 1c: Apply Event and Causal Analysis Event and Causal Analysis: Exercise 1c Worksheet RCA Tools for each approach Exercise 1D: Prepare for Case Study Section Summary and Conclusions Enhance Use of RCA Tools Why use a Particular Method Tool: Change Analysis Change Analysis Examples Exercise 2a: Apply Change Analysis Exercise 2b: Change Analysis Worksheet Tool: How to Resolve Conflict Tool: 5 Why?s Example Learning Management Problem Exercise 2b: Apply 5 Why?s Sequence-of-Events Exercise 2b: Worksheet Tool: Cause and Effect Exercise 2c: Apply Cause and Effect Exercise 2c: Cause and Effect Worksheet Tool: Fault Tree Analysis Why do we use Fault Tree Analysis? How does it work? Fault Tree Diagram Symbols Example #1 of FTA: Car Hits Object Exercise 2D: Apply Fault Tree Analysis Tool: Failure Modes and Effects Analysis (FMEA) Example: Failure Modes and Effects Analysis Exercise 2E: Apply FMEA Tool: Design / Application Review Exercise 2d: Apply Design/Application Review Section summary & conclusions Problem Resolution & Prevention Section Objectives The Secret of Solving Problems A Note about Statistical Control A Note about Fire Fighting Technique: Business Process Mapping Example: IGOE Exercise 3A: Problem as IGOE Exercise 3A: IGOE Template Technique: Lean Six Sigma and DMAIC Lean Six Sigma Benefits Exercise 3B: Apply Lean Six Sigma Importance of Understanding the Business Process The Business Process Mandate Technique: Process Modeling Graphical Notation Standard (BPMN) What is Business Process Modeling Notation (BPMN)? Benefits of BPMN Basic Components of BPMN Exercise 3C: Use BPMN to Document a Current State Technique: Business Process Maturity Model Five Levels of Maturity Exercise 3D: Appraise Business Process Maturity Level Section Summary and Conclusions Capability Improvement for RCA Section Learning Objectives Steps in Disciplined Problem Solving RCA as a RCA Process Key RCA Role Considerations Exercise 4A: Apply RCA to RCA Process Sustainable RCA Improvement Organizational Units Process Area Goals, Practices Specific and General Practices Specific Practice Examples Software Maturity Survey Exercise 4B: Apply Strengths, Weakness, Opportunities and Threats (SWOT) to RCA SWOT Analysis Worksheet Recognize the importance of the Change Management component in your RCA implementation Using the ADKAR Model to Communicate Change Review ADKAR© Model ? Awareness of the need for change Desire to participate and support the change Knowledge on how to change Ability to implement required skills and behaviors Reinforcement to sustain the change Exercise 4C: Create an Ability Checklist The ADKAR Model: Reinforcement Exercise 4D: Find two examples of how ADKAR will be different Section Summary and Conclusions Course Summary & Conclusions Plan the Proposal and Business Case Example: 1 Page Business Case Exercise 5A: Creating Action Plans Resource Guide Questions Additional course details: Nexus Humans BA17 - Advanced Root Cause Analysis 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 BA17 - Advanced Root Cause Analysis 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.