17409 Other courses in Grangemouth delivered Online

Duration 2 Days 12 CPD hours This course is intended for This course benefits individuals responsible for configuring and monitoring EX Series switches using Junos ELS. Overview After successfully completing this course, you should be able to: Restrict traffic flow within a VLAN. Manage dynamic VLAN registration. Tunnel Layer 2 traffic through Ethernet networks. Review the purpose and operations of a spanning tree. Implement multiple spanning-tree instances in a network. Implement one or more spanning-tree instances for a VLAN. List the benefits of implementing end-user authentication. Explain the operations of various access control features. Configure and monitor various access control features. Describe processing considerations when multiple authentication and access control features are enabled. Describe some common IP telephony deployment scenarios. Describe features that facilitate IP telephony deployments. Configure and monitor features used in IP telephony deployments. Explain the purpose and basic operations of CoS. Describe CoS features used in Layer 2 networks. Configure and monitor CoS in a Layer 2 network. Describe a basic troubleshooting method. List common issues that disrupt network operations. Identify tools used in network troubleshooting. Use available tools to resolve network issues. This two-day course provides detailed coverage of virtual LAN (VLAN) operations. Chapter 1: Course Introduction Course Introduction Chapter 2: Troubleshooting as a Process Before You Begin The Troubleshooting Process Challenging Network Issues The Troubleshooting Process Lab Chapter 3: Junos Product Families The Junos OS Control Plane and Data Plane Field-Replaceable Units Junos Product Families Lab: Identifying Hardware Components Chapter 4: Troubleshooting Toolkit Troubleshooting Tools Best Practices Lab: Using Monitoring Tools and Establishing a Baseline Chapter 5: Hardware and Environmental Conditions Hardware Troubleshooting Overview Memory and Storage Boot Monitoring Hardware-Related System Logs Chassis and Environmental Monitoring Lab: Monitoring Hardware and Environmental Conditions Chapter 6: Control Plane Control Plane Review System and User Processes Monitoring Routing Tables and Protocols Monitoring Bridging Monitoring the Address Resolution Protocol Lab: Control Plane Monitoring and Troubleshooting Chapter 7: Control Plane Protection Protection Overview DDOS Protection Loopback Filter Lab: Control Plane Monitoring and Troubleshooting Chapter 8: Data Plane ? Interfaces Interface Properties General Interface Troubleshooting Ethernet Interface Troubleshooting Lab: Monitoring and Troubleshooting Ethernet Interfaces Chapter 9: Data Plane ? Other Components Definition of a Data Plane Problem Data Plane Components Data Plane Forwarding Load-Balancing Behavior Firewall Filters and Policers Data Plane Troubleshooting Case Study Lab: Isolate and Troubleshoot PFE Issues Chapter 10: Staging and Acceptance Testing Initial Inspection and Power-on General System Checks Interface Testing Chapter 11: Troubleshooting Routing Protocols Troubleshooting OSPF Troubleshooting BGP Troubleshooting Routing Loops and Route Oscillation Lab: Troubleshooting Routing Protocols Chapter 12: High Availability High Availability Overview Graceful Routing Engine Switchover Graceful Restart Nonstop Active Routing and Bridging Unified In-Service Software Upgrade Chapter 13: Network Monitoring SNMP RMON Telemetry Flow Monitoring Lab: Monitoring the Network Chapter 14: vMX Troubleshooting vMX Overview Troubleshooting Lab: Monitoring vMX Chapter 15: JTAC Procedures Opening a Support Case Customer Support Tools The Content of a PR Transferring Files to JTAC Chapter 16: Automated Support and Prevention Overview Service Now Service Insight Lab: Automated Support and Prevention

Dressmaking and Fashion Design Do you want to learn about fashion design? If so, this Dressmaking and Fashion Design course might be just the thing for you. This Dressmaking and Fashion Design course is an excellent place where you may learn how to build amazing outfits and accessories. This Dressmaking and Fashion Design course includes fashion history, sketching, and pattern production. Also. this Dressmaking and Fashion Design course teaches you how to sew, choose fabric, and create patterns. Moreover, the Dressmaking and Fashion Design course also discusses the procedure of selling fashionable works. This Dressmaking and Fashion Design course is all about producing beautiful things and sharing them with others. Enrol this Dressmaking and Fashion Design course to give a wing to your passion! Special Offers of this Dressmaking and Fashion Design Course This Dressmaking and Fashion Design Course includes a FREE PDF Certificate Lifetime access to this Dressmaking and Fashion Design Course Instant access to this Dressmaking and Fashion Design Course Get FREE Tutor Support to this Dressmaking and Fashion Design Course Dressmaking and Fashion Design Discover your creative potential with our Dressmaking and Fashion Design course, designed to help you craft stunning outfits and accessories. This Dressmaking and Fashion Design course covers everything from the rich history of fashion to mastering sketching and pattern production. Gain practical skills in sewing, fabric selection, and pattern creation through our Dressmaking and Fashion Design program. Additionally, the Dressmaking and Fashion Design course explores selling your fashionable works, turning your passion into profit. Elevate your style, refine your talent, and make your mark in the industry with our Dressmaking and Fashion Design training! Who is this course for? Dressmaking and Fashion Design This Dressmaking and Fashion Design course is intended for those who enjoy fashion and want to learn how to manufacture fashionable outfits and accessories. Requirements Dressmaking and Fashion Design To enrol in this Dressmaking and Fashion Design Course, students must fulfil the following requirements. To join in our Dressmaking and Fashion Design Course, you must have a strong command of the English language. To successfully complete our Dressmaking and Fashion Design Course, you must be vivacious and self driven. To complete our Dressmaking and Fashion Design Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Dressmaking and Fashion Design Course. Career path Dressmaking and Fashion Design After completing this Dressmaking and Fashion Design course, you can pursue a variety of fascinating career choices in the fashion industry, such as fashion designer, fashion illustrator, garment technician, fashion merchandiser, stylist, or other similar occupations.

Evernote isn’t just a place for your notes—it’s a digital workspace that, when used right, can streamline your thought process, boost productivity, and help you keep tabs on just about everything. This advanced course takes experienced users beyond the basics, offering clever techniques and thoughtful strategies to use Evernote like a seasoned pro. From organising complex projects to managing an overflowing archive of ideas, you’ll learn how to make the most of every tag, notebook and shortcut without turning your account into a digital labyrinth. Whether you’re building out a knowledge base or creating a more structured system for personal or professional use, this course delivers the insights needed to sharpen your digital organisation. It’s aimed at those who’ve already explored the surface of Evernote and are now ready to do more with less clutter. Expect a smarter, faster way of navigating your ideas—without needing to reinvent your workflow. Learning Outcome Utilise Evernote's business notebooks for content collection and organisation Strategize and organise team projects using templates and shared spaces Collaborate effectively with team members using work chat and shared documents Assign tasks and manage joint team expenses Name documents and artefacts for easy searching and organisation Interface with customers, suppliers, and partners for seamless collaboration Increase productivity and efficiency through advanced Evernote features and tools. Course Curriculum: Evernote Advanced Collaboration Overview Business Notebooks Content Collection Strategize Organize Sharing Assigning Work Chat Shared Documents 28 Voice Messages Personal and Shared Space Naming Documents Artifacts Team Training Center Customers and Suppliers Interface Partners and Team Members Interface Creating Templates For Future Collaboration Utilising Previously Created Templates Managing Joint Team Expenses Conclusion How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Project Manager - £35,000 - £60,000 per annum Marketing Manager - £35,000 - £70,000 per annum Sales Manager - £40,000 - £80,000 per annum Business Analyst - £30,000 - £50,000 per annum Operations Manager - £40,000 - £80,000 per annum Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Whether you're a new dog owner or have years of tail-wagging companionship behind you, facing aggressive behaviour can be unsettling. This course offers a structured and reliable approach to understanding canine triggers and redirecting unwanted behaviours before they escalate. Learn how to read subtle warning signs, implement proven deterrent methods, and calmly manage situations that could lead to attacks — all from the safety and comfort of your own home. By guiding you through practical theory, expert techniques, and behaviour strategies, this course ensures you're better prepared to handle confrontational scenarios with confidence. No fluff, no jargon — just straight-to-the-point, easy-to-follow guidance that makes sense. Whether you’re protecting your own pup or keeping your family safe in the park, this is a solid step towards safer, more positive dog interactions. Learning Outcomes: By the end of this course, you'll be able to: Identify challenging and submissive signals in dogs Prevent dog aggression when walking your dog on a leash Handle a dog attack safely and effectively Understand the importance of socialisation and training in preventing dog attacks Recognize the signs of a potentially dangerous dog and take appropriate action At the beginning of the course, participants will receive an introduction to the challenging and submissive signals that dogs display. They will learn to recognise these signals and understand how to respond appropriately to prevent aggressive behaviour. The course will then delve into the topic of leash pulling and its contribution to dog aggression. Furthermore, the course will provide guidance on how to handle a dog attack. Participants will learn how to interpret a dog's body language and identify signs of aggression. They will also learn practical training methods to prevent and manage aggressive behaviour. Overall, this course aims to equip dog owners and trainers with the necessary skills to ensure their safety, as well as that of their dogs and those around them. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Completing the Dog Training - Stop Dog Attacks course can provide you with valuable skills that can enhance your career in several fields, including: Dog Trainer: £15,000 - £35,000 per year Animal Control Officer: £17,000 - £30,000 per year Dog Behaviorist: £20,000 - £50,000 per year Note: These figures are approximate and may vary based on experience, qualifications, and location. Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Dogs may be man’s best friend, but when instincts take over, even the gentlest pup can become unpredictable. Our Dog Training – Stop Dog Attacks Course is designed to help you understand canine behaviour and how to prevent aggressive incidents before they start. With expert guidance, this course walks you through key triggers of dog aggression, signs of impending attacks, and proven techniques to help manage tense situations calmly and effectively. Whether you're a dog owner, dog walker, pet professional or simply someone who spends time around animals, this course offers crucial insight into keeping both humans and dogs safe. Learn how to read subtle body language, spot early warning signs, and apply strategies to reduce the risk of bites. Packed with expert knowledge and delivered in an easy-to-follow format, this training can help you become more confident, more aware, and far better equipped when faced with a potentially aggressive canine. Ask ChatGPT Learning Outcomes: By the end of this course, you'll be able to: Identify challenging and submissive signals in dogs Prevent dog aggression when walking your dog on a leash Handle a dog attack safely and effectively Understand the importance of socialisation and training in preventing dog attacks Recognize the signs of a potentially dangerous dog and take appropriate action At the beginning of the course, participants will receive an introduction to the challenging and submissive signals that dogs display. They will learn to recognise these signals and understand how to respond appropriately to prevent aggressive behaviour. The course will then delve into the topic of leash pulling and its contribution to dog aggression. Furthermore, the course will provide guidance on how to handle a dog attack. Participants will learn how to interpret a dog's body language and identify signs of aggression. They will also learn practical training methods to prevent and manage aggressive behaviour. Overall, this course aims to equip dog owners and trainers with the necessary skills to ensure their safety, as well as that of their dogs and those around them. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Completing the Dog Training - Stop Dog Attacks course can provide you with valuable skills that can enhance your career in several fields, including: Dog Trainer: £15,000 - £35,000 per year Animal Control Officer: £17,000 - £30,000 per year Dog Behaviorist: £20,000 - £50,000 per year Note: These figures are approximate and may vary based on experience, qualifications, and location. Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Copywriting Level 4 Course Overview The Copywriting Level 4 course offers a comprehensive exploration of the art and science of writing persuasive, impactful copy. Designed for individuals eager to enhance their writing skills for various media, this course covers a wide range of topics, including headline creation, online and print copywriting, and crafting effective advertisements. Learners will gain valuable insights into the techniques used by professional copywriters, mastering the ability to produce compelling content across different platforms. By the end of the course, students will be equipped to create copy that captures attention, promotes engagement, and drives results. Course Description This course delves into the essentials of copywriting, focusing on both the creative and strategic aspects of the craft. Learners will explore topics such as writing eye-catching headlines, creating advertisements that resonate, and mastering the nuances of online, press, and print media copy. Through engaging modules, learners will develop critical copywriting skills, including understanding tone, style, and audience engagement, as well as learning to write for diverse media. By the end of the course, students will have the expertise needed to write clear, persuasive copy that enhances brand messaging and promotes consumer action. Copywriting Level 4 Curriculum Module 1: Introduction to Copywriting Module 2: Basics of Copywriting Module 3: Eye-Catching Headlines Module 4: Attention-Grabbing Advertisements Module 5: Essential Copywriting Skills Module 6: Online Copywriting Module 7: Press Related Copywriting Module 8: Print Media Copywriting Module 9: Copywriting for Mainstream Media Module 10: Copywriting for Other Media Module 11: How to Write Better Copy Module 12: Final Tips (See full curriculum) Who is this course for? Individuals seeking to enhance their writing skills for career growth. Professionals aiming to improve their copywriting proficiency. Beginners with an interest in marketing and advertising. Anyone aspiring to work in the field of content creation and media. Career Path Copywriter Content Writer Marketing Specialist Advertising Executive Media Consultant SEO Content Creator

Hybrid Vehicle Expert Training Course Overview The Hybrid Vehicle Expert Training course provides an in-depth understanding of hybrid electric vehicles (HEVs), focusing on their design, operation, and technology. Learners will explore various types of hybrids, key components, and the degree of hybridisation, enhancing their technical knowledge for the automotive industry. This course equips participants with essential skills to analyse regenerative systems and other innovative features that improve fuel efficiency and reduce emissions. By the end of the course, learners will be confident in identifying different HEV architectures and understanding their functional principles, preparing them for roles in vehicle maintenance, engineering, and technical consultancy within the evolving green transport sector. Course Description This course offers comprehensive coverage of hybrid vehicle technology, beginning with an introduction to hybrid electric vehicles and their classifications. It delves into the degree of hybridisation, explaining how various systems operate to optimise energy use. Detailed study of HEV components provides insight into powertrains, batteries, and control systems. The course also covers regenerative braking and energy recovery technologies that enhance vehicle efficiency. Learners will gain analytical skills required to evaluate hybrid systems and keep pace with developments in sustainable automotive design. The structured learning experience combines theory and technical knowledge, suitable for those aiming to build expertise in green vehicle technologies and contribute to environmental sustainability within the automotive sector. Hybrid Vehicle Expert Training Curriculum: Module 01: Introduction Module 02: Types of Hybrid Electric Vehicles Module 03: Degree of Hybridisation Module 04: Components of HEVs Module 05: Regenerative Systems (See full curriculum) Who is this course for? Individuals seeking to develop expertise in hybrid vehicle technology. Professionals aiming to advance their careers in the automotive or green transport sectors. Beginners with an interest in sustainable automotive technologies. Technicians and engineers preparing for roles in vehicle systems analysis and maintenance. Career Path Hybrid Vehicle Technician Automotive Engineer specialising in green technologies Vehicle Systems Analyst Technical Consultant for sustainable transport solutions Research and Development Specialist in automotive innovation

Hospitality - Concierge Course Overview: This comprehensive course on Concierge Services equips learners with the essential skills and knowledge required to excel in the hospitality industry. Covering a range of concierge services, from customer care to handling emergency situations, it offers valuable insights into the role of a concierge within various service sectors. Learners will gain a thorough understanding of the necessary skills and principles to provide high-quality service, helping them build a solid foundation for a career in hospitality. By the end of the course, learners will have developed the competencies needed to operate efficiently and professionally within the dynamic environment of hotel and hospitality services. Course Description: The "Hospitality - Concierge" course provides a thorough exploration of the concierge service industry. It covers essential topics, including the various types of services offered by concierges, the required skills for success, and key principles for running a concierge service business. Learners will gain a deep understanding of customer service and the etiquettes required in a professional concierge environment. The course also prepares learners for managing emergency situations in the hospitality industry, ensuring they are well-equipped to handle any challenges that may arise. By completing this course, learners will be prepared for roles in customer service, hotel management, and other areas within hospitality, ensuring a high standard of service in their future careers. Hospitality - Concierge Curriculum: Module 01: Understanding the Service Module 02: Types of Concierge Services Module 03: Necessary Skills for Any Concierge Module 04: Principles for a Concierge Service Business Module 05: Delivering Customer Service Module 06: Concierge Work Environment and Etiquettes Module 07: Emergency Measures for a Hotel Concierge (See full curriculum) Who is this course for? Individuals seeking to start a career in hospitality. Professionals aiming to develop customer service and management skills. Beginners with an interest in concierge services or hotel management. Anyone looking to enhance their understanding of the hospitality sector. Career Path: Hotel Concierge Hospitality Customer Service Representative Front Desk Supervisor Concierge Manager Event Coordinator Travel and Tourism Industry Professional

Functional Skills - IT Course Overview: The "Functional Skills - IT" course is designed to provide learners with a comprehensive understanding of essential IT concepts and skills. It covers a wide range of topics, from the basic components of information technology to more advanced areas such as networking, security, and cloud computing. This course is ideal for individuals seeking to enhance their IT skills for personal or professional development. Learners will gain a strong foundation in IT principles, which will support them in various workplace environments and allow them to apply their knowledge to real-world scenarios. Course Description: This course covers fundamental IT concepts, including the core components of information technology, hardware, software applications, and operating systems. Learners will explore topics such as networking, security, database management, and virtualisation. The course also includes an in-depth look at enterprise-level IT systems, traffic flow, and storage solutions. By the end of the course, learners will have a solid understanding of how IT systems are designed, implemented, and managed. They will gain the skills necessary to work effectively in diverse IT roles, enabling them to confidently support organisational IT needs. Functional Skills - IT Curriculum: Module 01: Introduction Module 02: Information Technology Module 03: Components of IT Module 04: Hardware Module 05: Operating System Module 06: Application/Software Module 07: Networking Module 08: Security Module 09: Traffic Flow & Enterprise Level IT Components Module 10: Storage Module 11: Database Module 12: Virtualisation & Cloud Module 13: Management & Other IT Jobs (See full curriculum) Who is this course for? Individuals seeking to develop a strong understanding of IT principles. Professionals aiming to enhance their technical skills for career progression. Beginners with an interest in information technology and related fields. Those looking to pursue a career in IT management, networking, or support roles. Career Path IT Support Technician Network Administrator Systems Analyst IT Manager Cloud Solutions Specialist Database Administrator IT Consultant Cybersecurity Specialist

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