• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

3896 Relationships courses

DBT - Dialectical Behaviour Therapy

4.8(9)

By Skill Up

Don't let your emotions rule your life- live like a proactive person. Learn 'What is Counselling & Psychotherapy', 'Treatment by DBT', 'DBT for Psychological Disorders'.

DBT - Dialectical Behaviour Therapy
Delivered Online On Demand2 hours 59 minutes
£25

Operations Management

4.8(9)

By Skill Up

Hone your operational leadership skills and ensure a streamlined business process to increase productivity. Gain mastery of Negotiation Techniques, Supply Chain Management.

Operations Management
Delivered Online On Demand7 hours 51 minutes
£25

Ego Management Training Course

By iStudy UK

Do you feel to control your ego or pride? Does someone tell you that you should need to learn how to manage your ego? Or are you helping people who need to maintain their ego? How does ego impact upon inner peace and disrupt harmony in relationships? Do you want to know how the ego be managed is? If yes, then this course will perfectly suit you. The course is designed for the people who need to control their ego or the individuals who are helping others having ego or pride related issues. Ego Management Training Course is training course that helps the people who are struggling with their ego problems and need to manage their pride so that anyone does not hurt by their behavior. It is equally important to have an ego so that anyone cannot abuse you and at the same time it is also needed to control over ego so that any one may not hurt by you. In this course, you will learn both positive ego development and ego management. By the end of the course, you will be able to decide whether you can manage your ego by yourself or you need counselling. Finally, you will be able to know the dangers of a damaged ego and able to find out the procedure for preventing it. Course Highlights Ego Management Training Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Ego Management Training Course into 6 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 3 hours, 50 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Ego Management Training Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? People who need to control their ego and professional who guides people who have the problem. Ego Management Training Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Ego Management Training Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Ego Management Training Course Why You Need To Develop Your Ego FREE 00:30:00 Work On Honesty FREE 00:30:00 Work On Courage And Exploration 01:00:00 How To Build A Stronger Ego 01:20:00 Staying Engaged With Life 00:15:00 The Dangers Of A Damaged Ego 00:15:00

Ego Management Training Course
Delivered Online On Demand3 hours 50 minutes
£25

Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution - 20 Courses Bundle

By NextGen Learning

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.

Equality & Diversity, Cross-Culture, Leadership, Motivation & Conflict Resolution - 20 Courses Bundle
Delivered Online On Demand33 hours
£79

Professional Editing Mastery Program

By Compete High

🚀 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

Professional Editing Mastery Program
Delivered Online On Demand1 hour 25 minutes
£25

Effective Communication Skills

By Compete High

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

Effective Communication Skills
Delivered Online On Demand3 hours
£25

Dealing With Difficult People

5.0(10)

By Apex Learning

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

Dealing With Difficult People
Delivered Online On Demand
£53

You Can't Teach Me Anything

By Nurturing Neurodiversity

Self Directed Education for Children with a Strong Sense of Autonomy

You Can't Teach Me Anything
Delivered Online On Demand
£145

Microsoft SQL Server Development for Everyone

5.0(10)

By Apex Learning

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

Microsoft SQL Server Development for Everyone
Delivered Online On Demand5 hours 48 minutes
£12

Data Visualization and Reporting with Power BI

5.0(10)

By Apex Learning

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

Data Visualization and Reporting with Power BI
Delivered Online On Demand14 hours 25 minutes
£12