3602 Relationships courses delivered Online

Duration 1 Days 6 CPD hours This course is intended for Report authors wanting to develop interactive report content, or content disconnected from IBM Cognos servers. In this course, participants increase their IBM Cognos Analytics experience by building interactive reports using Active Report controls, which can be distributed to and consumed by users in a disconnected environment, including mobile devices. Introduction to IBM Cognos Active Reports Examine IBM Cognos Active Reports Convert an existing report into an Active Report Add interactions in Active Reports using Active Report connections Create a basic Active Report Examine interactive behavior of Active Report controls Save a report in the IBM Cognos Analytics portal Save an Active Report to an MHT file Save an Active Report as a report template Use an Active Report as a prompt page Understand Active Report security Use Active Report Connections Examine Active Report connections Filter and select in controls using Active Report connections Examine variables Use a single variable to control multiple controls Use multiple variables to show different data in different controls Use Active Report controls to support mobile device usage Active Report Charts & Decks Add charts to active reports Understand and optimize chart behavior Examine decks and data decks Optimize use of decks Review Master Detail relationships Examine RAVE visualizations

Get ready for an exceptional online learning experience with the Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. This Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Equality & Diversity package has something for everyone. As part of the Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution package, you will receive complimentary PDF certificates for all courses in Equality & Diversity bundle at no extra cost. Equip yourself with the Equality & Diversity bundle to confidently navigate your career path or personal development journey. Enrol our Equality & Diversity bundletoday and start your career growth! This Equality & Diversity Bundle Comprises the Following CPD Accredited Courses: Equality, Diversity and Discrimination Cross-Cultural Awareness Training Leadership and Management Course Leading and Managing Remote Team The Principles of Ethical Leadership Organisation & People Management Motivation Skills Motivation - Motivating Yourself & Others PR: Public Relations Communication Masterclass Building Strong Relationships Conflict Resolution Dealing With Difficult People Training Course Workplace Confidentiality Public Speaking and Presentation Skill Course Persuasion and Influencing Skills Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: By completing the Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution course, you will: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Equality & Diversity Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Equality & Diversity Bundle. Build a strong knowledge base in your chosen course via the Equality & Diversity Bundle. Benefit from the flexibility and convenience of online learning. With the Equality & Diversity package, validate your learning with a CPD certificate. Each course in Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution, a rich anthology of 15 diverse courses. Each course in the Equality & Diversity bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisEquality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution bundle offers you the flexibility and convenience to learn at your own pace. Make the Equality & Diversity package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol this Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution course. Career path Unleash your potential with the Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Equality & Diversity bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

🚀 Unlock Your Potential with the Professional Editing Mastery Program! 🚀 Are you ready to elevate your editing skills to unprecedented heights and embark on a transformative journey towards becoming a true editing maestro? Introducing the Professional Editing Mastery Program - your key to mastering the art and science of editing like never before!   🔍 What Will You Gain? 🌟 Comprehensive Editing Expertise: Dive deep into the world of professional editing with our meticulously crafted modules. From grammar and syntax perfection to advanced editing techniques, this program covers it all. 🔧 Hands-On Practice: Gain practical, real-world experience with hands-on exercises and real-life editing scenarios. Sharpen your skills through interactive assignments that mimic the challenges faced by professional editors. 🎓 Industry-Driven Curriculum: Developed by seasoned editors and industry experts, our curriculum is designed to meet the demands of the ever-evolving editing landscape. Stay ahead of the curve and position yourself as an industry authority. 🤝 Networking Opportunities: Connect with fellow aspiring editors and industry professionals through our exclusive community forums. Exchange ideas, seek advice, and build valuable relationships that can propel your editing career forward. 📈 Career Advancement: Whether you're a seasoned professional or just starting, this program equips you with the tools and knowledge to take your editing career to new heights. Gain a competitive edge in the job market and open doors to exciting opportunities.   🎯 Who Is This For? 🖋 Aspiring Editors: Kickstart your editing career with a solid foundation and the skills needed to stand out in a competitive market. 📚 Content Creators: Enhance your content quality and captivate your audience with polished, professional editing techniques. 💼 Professionals Seeking Career Growth: Elevate your professional profile by adding advanced editing skills to your repertoire. Become the go-to expert in your field. 👩‍💻 Freelancers: Set yourself apart in the freelance world by offering top-notch editing services. Increase your earning potential and attract high-value clients.   🌟 Enroll Today and Unlock a World of Editing Possibilities!   🚨 Don't miss out on this opportunity to revolutionize your editing journey. Join the ranks of editing professionals who have mastered their craft and are thriving in the industry. Course Curriculum Introduction Course Overview Editing and Proofreading 00:00 Introduction 00:00 In-depth editing or deep editing 00:00 Steps Involved in Editing 00:00 Proofreading strategies 00:00 Understanding the Context and Scope of a Piece 00:00 Content Edit Breaking up individual points 00:00 Making Sense of Individual Points 00:00 Deleting Irrelevant Points 00:00 Eliminating Rambling 00:00 Eliminating Repetition 00:00 Verifying the Facts 00:00 Removing Contradicting Statements 00:00 Finding and Adding Missing Points 00:00 Structure Edit Choosing the Angle 00:00 Creating Categories 00:00 Creating a Narrative Structure 00:00 Ordering Points within Sections 00:00 Creating Narrative Turns 00:00 Making the Piece Read Well 00:00 Clearing Up the Clutter 00:00 Arranging Paragraphs 00:00 Creating a Jazzy Intro 00:00 Creating a Snazzy Ending 00:00 Making the Narrative more Evocative 00:00 Correctly Introducing Every Person and Entity 00:00 Referencing 00:00 Presentations Edit Checking the Spelling, Grammar, and Punctuation 00:00 Replacing Jargons with Simple Words 00:00 Matching the Title 00:00 Fixing Inconsistencies 00:00 Addressing Trip-Ups 00:00 IT Skills Tracking Changes 00:00 Useful Editing and Proofreading Software and Websites 00:00 Choosing Editing and Proofreading as Career Proofreading Best Practices 00:00 Finding Clients 00:00 Marketing Yourself 00:00

Overview: Effective Communication Skills In today's interconnected world, effective communication is an invaluable asset. Whether you're interacting in your personal relationships, navigating professional environments, or engaging with broader communities, the ability to convey ideas, thoughts, and emotions with clarity and precision is essential. The 'Effective Communication Skills' course is designed to equip learners with the knowledge, strategies, and practical techniques necessary to become adept communicators across various mediums.   Chapter 1: Effective Communication The foundation of effective communication lies in understanding its fundamental principles. In this introductory chapter, learners will delve into the core concepts that underpin successful communication. From the basic elements of encoding and decoding messages to the importance of active listening and feedback, participants will gain insights into the dynamics of human interaction. Key topics covered in this module include: The communication process: Explore the stages involved in transmitting and receiving messages, including encoding, transmitting, receiving, decoding, and feedback. Verbal and nonverbal communication: Understand the role of both verbal language and nonverbal cues such as body language, facial expressions, and gestures in conveying meaning. Barriers to communication: Identify common obstacles that hinder effective communication, such as noise, cultural differences, language barriers, and emotional barriers. Active listening: Learn techniques to enhance listening skills, including paraphrasing, clarifying, summarizing, and empathizing with the speaker. Through a combination of theoretical concepts, real-world examples, and interactive exercises, learners will develop a solid understanding of the principles of effective communication and how they can be applied in various contexts. Chapter 2: Effective Verbal Communication Verbal communication plays a central role in interpersonal interactions, presentations, negotiations, and everyday conversations. In this module, participants will explore strategies for mastering the art of verbal communication and fostering meaningful connections with others through spoken language. Key components of this chapter include: Clarity and conciseness: Discover techniques for articulating thoughts and ideas clearly and succinctly to ensure that messages are easily understood by others. Tone and delivery: Explore the impact of tone of voice, pacing, pitch, and emphasis on the interpretation of verbal messages, and learn how to adapt these elements to different situations and audiences. Assertiveness and confidence: Develop strategies for expressing opinions, making requests, and asserting boundaries with confidence and assertiveness, while also respecting the perspectives of others. Effective questioning and feedback: Master the art of asking open-ended questions, providing constructive feedback, and engaging in productive dialogue to foster mutual understanding and collaboration. Through practical exercises, role-playing scenarios, and guided feedback sessions, learners will hone their verbal communication skills and gain confidence in their ability to express themselves effectively in various contexts. Chapter 3: Effective Written Communication In an age dominated by digital communication channels, the ability to communicate effectively in writing is more important than ever. This module focuses on developing proficiency in written communication, from crafting clear and concise emails to drafting persuasive reports and documents. Key themes covered in this module include: Structure and organization: Learn how to structure written communication effectively, including the use of introductions, main body paragraphs, and conclusions to guide the reader through the content. Clarity and precision: Explore techniques for writing clearly and concisely, avoiding jargon, ambiguity, and unnecessary complexity to ensure that messages are easily understood by the intended audience. Tone and style: Understand the importance of tailoring the tone and style of writing to suit the purpose, audience, and context, whether it's formal, informal, persuasive, or informative. Editing and proofreading: Develop strategies for reviewing and revising written work to correct errors in grammar, punctuation, spelling, and style, ensuring that the final product is polished and professional. By practicing writing exercises, analyzing sample texts, and receiving constructive feedback, participants will enhance their written communication skills and become more effective communicators in both personal and professional settings.   Conclusion The 'Effective Communication Skills' course provides a comprehensive framework for mastering the art of communication in today's fast-paced world. By exploring the principles of effective communication, mastering verbal and written communication techniques, and practicing through interactive exercises, participants will develop the skills and confidence needed to succeed in any communication context. Whether you're a seasoned professional looking to enhance your communication skills or an aspiring communicator seeking to build a strong foundation, this course offers valuable insights and practical strategies for achieving your goals. Course Curriculum Chapter 1 Effective Communication Effective Communication 00:00 Chapter 2 Effective Verbal Communication Effective Verbal Communication 00:00 Chapter 3 Effective Written Communication Effective Written Communication 00:00

Give a compliment to your career and take it to the next level. This Dealing With Difficult People will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Dealing With Difficult People will help you keep ahead of the pack. The Dealing With Difficult People incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this Dealing With Difficult People will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Dealing With Difficult People, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Dealing With Difficult People course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This Dealing With Difficult People Bundle Consists of the following Premium courses: Course 01: Dealing With Difficult People Training Course Course 02: Workplace Confidentiality Course 03: Leadership & Management Diploma Course 04: Anger Management Course 05: People Management Skills Level 3 Course 06: Emotional Intelligence and Human Behaviour Course 07: Conflict Management Course 08: Motivation Skills Course 09: Level 2 Mindfulness for Wellbeing Course 10: Stress Management Training Course 11: Effective Communication Skills Diploma So, enrol now to advance your career! Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery inside the U.K. is Free. International students have to pay a £3.99 postal charge. Curriculum of Bundle Course 01: Dealing With Difficult People Training Course Module 01: Difficult Promo Module 02: Fundamentals Module 03: Foundational Tips and Tools Module 04: Difficult People - Relationships Module 05: Difficult People - Solutions Module 06: Problem - Solving Module 07: Final Notes and Tips Module 08: Bonus Video - dealing With Emotions & Anger Course 02: Workplace Confidentiality Module 01: Introduction to workplace confidentiality Module 02: Business Etiquettes and Types of Confidentiality Module 03: The Importance of Confidentiality Module 04: Confidentiality with Co-workers Module 05: Preventing Confidentiality Breach Module 06: How Employers Can Protect Confidential Information Course 03: Preventing Workplace Violence and Harassment Level 3 Workplace Management: Violence Workplace Management: Harassment Course 04: Anger Management Video 1 Video 2 Video 3 content 1 part A Video 4 content 1 part B Video 5 content 1 part C and content 2 Video 6 content 3 Video 7 content 4 Video 8 content 5 Video 9 Course 05: People Management Skills Level 3 Introduction to Human Resources Employee Recruitment and Selection Procedure Employee Training and Development Process Performance Appraisal Management Employee Relations Motivation and Counselling Ensuring Health and Safety at the Workplace Employee Termination Employer Records and Statistics Essential UK Employment Law Course 06: Emotional Intelligence and Human Behaviour Module 01: Human Behaviour and Basic Psychological Process Module 02: Evolutionary Perspective of Human Behaviour Module 03: Human Intelligence Module 04: Intelligence Test and Variations in Intelligence Module 05: Learning and Conditioning Module 06: Language and Communication Module 07: Introduction to Emotion Module 08: Emotion Influences Cognition Module 09: Stress, Anger and Conflict Module 10: Emotional Intelligence Module 11: Self-Leadership Module 12: Neuro-Linguistic Programming (NLP) Course 07: Conflict Management Unit 01: Introduction Unit 02: Understand the Keys to Conflict Unit 03: How Misunderstandings Arise and the Solution Unit 04: Personality Types in Conflict Unit 05: Escalation of Conflict Unit 06: De-escalating Conflict Unit 07: Closing Section Course 08: Motivation Skills Introduction Motivational Skills Motivational Strategies Conclusion Course 09: Level 2 Mindfulness for Wellbeing Introduction & First Concepts Understanding & Beating Anxiety More Anti-Anxiety Skills & Concepts Conclusion Course 10: Stress Management Training Beginning Concepts Specific Stress Management Techniques MORE Stress Reduction Strategies Still MORE Stress Reduction Techniques - Part 1 Still MORE Stress Reduction Techniques - Part 2 Still MORE Stress Reduction Techniques - Part 3 BONUS Video & Wrap Up! Special LIVE Bonus Video! Course 11: Effective Communication Skills Diploma Module 01: Business Communication Module 02: Verbal and Non-verbal Communication Module 03: Written Communication Module 04: Electronic Communication Module 05: Communicating with Graphic Module 06: Effectively Working for Your Boss CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Dealing With Difficult People bundle. Requirements This Dealing With Difficult People course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Self Directed Education for Children with a Strong Sense of Autonomy

Overview This comprehensive course on Microsoft SQL Server Development for Everyone will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Microsoft SQL Server Development for Everyone 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 Microsoft SQL Server Development for Everyone . It is available to all students, of all academic backgrounds. Requirements Our Microsoft SQL Server Development for Everyone 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 6 sections • 31 lectures • 05:48:00 total length •Introduction to SQL Server and Databases: 00:04:00 •Download and Install SQL Server Express: 00:05:00 •Connect to Database Instance and Create a Database: 00:06:00 •Drop or Remove Database: 00:04:00 •What is a Database Table?: 00:02:00 •Create an SQL Database Table: 00:32:00 •Insert Data into the Table with SQL Script: 00:15:00 •Insert Data into the Table with Management Studio: 00:05:00 •Select Data from the Table with SQL Script: 00:09:00 •More Advanced Select Queries Part 1: 00:18:00 •Update Data in the Table: 00:10:00 •Update Data in the Table with Management Studio GUI: 00:02:00 •Delete Data from the Table with SQL Script: 00:06:00 •Delete Data from the Table with Management Studio GUI: 00:01:00 •What are Relationships, Foreign Keys and Normalization: 00:11:00 •Create a Relationship in SQL Server: 00:19:00 •Insert Records in Related Tables: 00:13:00 •Run Queries on Related Tables: 00:19:00 •Left, Right and Full Joins: 00:11:00 •Grouping Data using SQL GROUP BY Clause: 00:12:00 •SQL AVG Aggregate Function: 00:11:00 •SQL COUNT Aggregate Function: 00:04:00 •SQL MAX and MIN Aggregate Functions: 00:04:00 •SQL SUM Aggregate Function: 00:04:00 •Create and Manage Views: 00:23:00 •Scalar Valued Functions: 00:27:00 •Inline Table Valued Functions: 00:09:00 •Stored Procedures: 00:28:00 •Table Triggers: 00:19:00 •Database Scripting, Backup and Restore: 00:15:00 •Assignment - Microsoft SQL Server Development for Everyone: 00:00:00

Overview This comprehensive course on Data Visualization and Reporting with Power BI will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Visualization and Reporting with Power BI 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 Data Visualization and Reporting with Power BI. It is available to all students, of all academic backgrounds. Requirements Our Data Visualization and Reporting with Power BI 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 - Data Visualization and Reporting with Power BI: 00:00:00

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

GRAB the Best SALES EVENT of the Year Train the Trainer course dives deep into the techniques and strategies you need to become an effective trainer. You will not only discover how to motivate adult learners, keep them interested, deal with challenging participants and maximize learning, but you will do it yourself. Train the Trainer Course Learning Outcomes: Upon successful completion of this highly appreciated this Train the Trainer course, you'll be a skilled professional, besides- Concepts introduced by the instructor. Study up on Coach Trainer. Recognize the trainer's influence. Learn to assess fundamental principles for the trainer. Determine the teaching style. Establish deliverables. Make the kick-off meeting's hook compelling. Discover how to be ready for a kick-off meeting. How to Develop Relationships With Your Team. Learn the seven essentials of taking notes well. Discover the four simple steps to classroom observation. Key Highlights for Train the Trainer Course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Curriculum Topics: Module 01: Introduction to Train the Trainer Module 02: Coach Learn About the Trainer Module 03: Recognize the Trainer's Strengths Module 04: Gauge areas for improvement Module 05: Initial Value for the Trainer Module 06: Identify the Trainers Style Module 07: Create Deliverables Module 08: Create a hook for the kick-off meeting Module 09: Prepare for the kick-off meeting Module 10: Make a Good First Impression Module 11: Build Teammate Relationship Module 12: Discuss the Process for Trainer Growth Module 13: Observe the Trainer in the Classroom Module 14: Master 7 Keys to Effective Note-Taking Module 15: Apply 4 Quick Steps to Classroom Oberserations Module 16: Classroom Observation Summary CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course. However, This course particularly effective for- Students Recent graduates Job Seekers in related field Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill Requirements Learners seeking to enrol for the Train the Trainer Course should meet the following requirements; Basic knowledge of English Language, which you have already Basic Knowledge of Information & Communication Technologies for studying online or digital platform Stable Internet or Data connection in your learning devices Career path After completing this course, you can explore trendy and in-demand jobs related to Train the Trainer, such as- Corporate Trainer: £25,000 to £45,000 per year Learning and Development Specialist: £30,000 to £50,000 per year Talent Development Manager: £40K to £60K per year Human Resources (HR) Training Coordinator: £25K to £40K per year Leadership Development Consultant: £35K to £55K per year Certificates CPD Accredited Hard Copy Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 each Outside of the UK: £9.99 each CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate