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

5786 Mind courses delivered Online

Collaborative Selling Academy

By Fred Copestake

Designed for professional B2B salespeople to develop a modern approach to winning business

Collaborative Selling Academy
Delivered OnlineFlexible Dates
£124.99 to £1,500

Collaborative Selling Activator

By Fred Copestake

Designed for professional B2B salespeople to develop a modern approach to winning business

Collaborative Selling Activator
Delivered OnlineFlexible Dates
£124.99 to £1,500

In this course you will understand what mentoring is about, understand your roles in the process. Gain self-insight into your own interpersonal style and way of relating to others that may affect mentoring interactions.

The Magic of Mentoring
Delivered in Loughborough or UK Wide or OnlineFlexible Dates
£1,335

Scrum Master Workshop: In-House Training

By IIL Europe Ltd

Scrum Master Workshop: In-House Training A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions. What you will Learn You'll learn how to: Comprehend the Agile Manifesto and mindset Explain the fundamental principles of Scrum Guide the Scrum team in their responsibilities Write requirements in the form of user stories Define Ready and Done Estimate using planning poker and prioritize using MoSCoW Facilitate the team through the 5 Sprint events Fulfill the role of Scrum Master in a Scrum project Create Information Radiators to enable transparency Define the structure of the retrospective Foundation Concepts Agile History, Values, and Mindset Introduction to Scrum Scrum events Scrum artifacts Scrum Roles and Responsibilities Product Owner responsibilities Scrum Master responsibilities The Team responsibilities Cross-functional Teams Building Effective Teams The Product Backlog and User Stories The Product Backlog User Stories Definition of Done Backlog grooming Estimating User Stories Story points, planning poker Prioritizing User Stories The Sprint Team capacity and velocity The Sprint Planning Meeting The Sprint Backlog The Sprint Learning to self-manage, self-organize, self-improve Sprint Review and Retrospective Project Progress and Completion The Daily Scrum The Task Board and The Burndown Chart Information Radiators Closing a Scrum Project Summary and Next Steps Review of course goals, objectives, and content

Scrum Master Workshop: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,495

Scrum Master Exam Prep: In-House Training

By IIL Europe Ltd

Scrum Master Exam Prep This workshop prepares you for the Scrum.org Professional Scrum Master (PSM)™ I certification. A voucher for the exam and the access information you will need to take the exam will be provided to you via email after you have completed the course. NOTE: If you have participated in any of IIL's other Scrum workshops, you can bypass this program and focus on reading/studying the Scrum Guide and taking practice exams from Scrum.org. A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions. The Professional Scrum Master™ I (PSM I) certificate is a Scrum.org credential that enables successful candidates to demonstrate a fundamental level of Scrum mastery. PSM I credential holders will grasp Scrum as described inThe Scrum Guide™1 and recognize how those concepts can be applied. They will also share a consistent terminology and approach to Scrum with other certified professionals. What you will Learn You'll learn how to: Successfully prepare for the Scrum.org PSM I exam Comprehend the Agile Manifesto and mindset Explain the fundamental principles of Scrum, including events, artifacts, and roles Guide the Scrum team in their responsibilities Define Ready and Done Write requirements in the form of user stories Estimate using planning poker and prioritize using MoSCoW Facilitate the team through the 5 Sprint events Fulfill the role of Scrum Master in a Scrum project Create Information Radiators to enable transparency Define the structure of the retrospective Getting Started Introductions Workshop orientation Exam prep preview Foundation Concepts Agile History, Values, and Mindset Introduction to Scrum Scrum events Scrum artifacts Scrum Roles and Responsibilities Product Owner responsibilities Scrum Master responsibilities The Team responsibilities Cross-functional teams Building effective teams The Product Backlog and User Stories The Product Backlog User Stories Definition of Done Backlog grooming Estimating User Stories Story points, planning poker Prioritizing User Stories The Sprint Team capacity and velocity The Sprint Planning Meeting The Sprint Backlog The Sprint Learning to self-manage, self-organize, self-improve Sprint Review and Retrospective Project Progress and Completion The Daily Scrum The Task Board and The Burndown Chart Information Radiators Closing a Scrum Project Summary and Next Steps Review of course goals, objectives, and content Exam prep next steps

Scrum Master Exam Prep: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,495

Scrum Master Exam Prep: In-House Training

By IIL Europe Ltd

Scrum Master Exam Prep This workshop prepares you for the Scrum.org Professional Scrum Master (PSM)™ I certification. A voucher for the exam and the access information you will need to take the exam will be provided to you via email after you have completed the course. NOTE: If you have participated in any of IIL's other Scrum workshops, you can bypass this program and focus on reading/studying the Scrum Guide and taking practice exams from Scrum.org. A Scrum Master helps project teams properly use the Scrum framework, increasing the likelihood of the project's overall success. Scrum Masters understand Scrum values, practices, and applications and provide a level of knowledge and expertise above and beyond that of typical project managers. Scrum Masters act as 'servant leaders', helping the rest of the Scrum Team work together and learn the Scrum framework. Scrum Masters also protect the team from both internal and external distractions. The Professional Scrum Master™ I (PSM I) certificate is a Scrum.org credential that enables successful candidates to demonstrate a fundamental level of Scrum mastery. PSM I credential holders will grasp Scrum as described in The Scrum Guide™1 and recognize how those concepts can be applied. They will also share a consistent terminology and approach to Scrum with other certified professionals. Scrum.org does not require that you take their own sponsored or any preparatory training. However, training can facilitate your preparation for this credential. And this course is based on IIL's Scrum Master Workshop, which is aligned with The Scrum Guide™ and was built based on PSM I credentialed expertise. It will provide you with the information you need to pass the exam and IIL will make the arrangements for your online exam. You will be provided with an exam code and instructions, so that you can take the exam at your convenience, any time you are ready after the course. Passwords have no expiration date, but they are valid for one attempt only. What you will Learn You'll learn how to: Successfully prepare for the Scrum.org PSM I exam Comprehend the Agile Manifesto and mindset Explain the fundamental principles of Scrum, including events, artifacts, and roles Guide the Scrum team in their responsibilities Define Ready and Done Write requirements in the form of user stories Estimate using planning poker and prioritize using MoSCoW Facilitate the team through the 5 Sprint events Fulfill the role of Scrum Master in a Scrum project Create Information Radiators to enable transparency Define the structure of the retrospective Getting Started Introductions Workshop orientation Exam prep preview Foundation Concepts Agile History, Values, and Mindset Introduction to Scrum Scrum events Scrum artifacts Scrum Roles and Responsibilities Product Owner responsibilities Scrum Master responsibilities The Team responsibilities Cross-functional teams Building effective teams The Product Backlog and User Stories The Product Backlog User Stories Definition of Done Backlog grooming Estimating User Stories Story points, planning poker Prioritizing User Stories The Sprint Team capacity and velocity The Sprint Planning Meeting The Sprint Backlog The Sprint Learning to self-manage, self-organize, self-improve Sprint Review and Retrospective Project Progress and Completion The Daily Scrum The Task Board and The Burndown Chart Information Radiators Closing a Scrum Project Summary and Next Steps Review of course goals, objectives, and content Exam prep next steps

Scrum Master Exam Prep: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,495

Baby Care and Nannying Diploma

4.3(43)

By John Academy

Description: Would you like to know how to become a nanny? With the help of this course, take a stepping stone rewarding work in the home based childcare industry. If you were always passionate about supporting the emotional and psychological development of children of the same age, this course is just perfect for you! Employment in this very large occupation rose strongly in the past five years and is forecast to grow strongly in the long-term. Nannies care for children as employees or contractors in private households. Employment can be sought in almost any location nationwide. International work opportunities for professional nannies exist in many countries. Join the course now! Who is the course for? Health Professionals and Workers who are into babies' growth and development Anyone who wants to know how baby care works Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification: After completing the course, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Baby Care and Nannying Diploma is a useful qualification to possess and would be beneficial for the following careers: Child Care Specialist Nanny Infant Massage Therapist Labour and Delivery Nurse Paediatric Nurse Pediatric Physical Therapist Lactation Consultant Midwife. First Baby Care Bonding Time With My First Baby 00:30:00 Communicating With My First Baby 00:30:00 Fashion Tips For My First Baby 00:30:00 How To Change My First Baby's Diaper 00:30:00 My First Baby Essentials 00:30:00 My First Baby Feeding Guide 00:30:00 My First Baby Learning The Basics 00:30:00 My First Baby: Understanding The Crying Game 00:30:00 Nutritious Bites For My First Baby 00:30:00 The Joys And Angst Of Holding My First Baby 00:30:00 Baby Care Basics Baby Products For Bath 00:30:00 Tips To Manage Your Baby Sleeping Schedules 00:30:00 Baby Weaning Difficulties And Tips To Cope With It 00:30:00 Choosing The Right Baby Care 00:30:00 Choosing The Right Baby Formula 00:30:00 Coping With Colic 00:30:00 Diaper Rash Help 00:30:00 Feeding Schedules Tips to Get it Right 00:30:00 How To Get Rid Of A Pacifier 00:30:00 Premature Baby Help 00:30:00 Reading To Baby 00:30:00 Reducing Baby's Risk Of Choking 00:30:00 Safety Measures For Food Borne Illnesses 01:00:00 The Benefits of Breastfeeding 00:30:00 Why Do Babies Cry 00:30:00 Baby Car Seat Buying Tips 00:30:00 When You Spot Something Wrong 00:30:00 Baby Care and Breastfeeding 00:30:00 Baby Care And Television 00:15:00 Baby Hazards: Be Careful Or You May Not Know 00:30:00 Baby Pacifiers: Yes Or No 00:30:00 What's In The Nursery 00:30:00 Baby Bathing Is This Hard To Do 00:30:00 5 Things To Keep In Mind With Baby Care 00:30:00 Babies At Work Good Or Bad 00:15:00 Baby Sleeping Everything You Need To Know About Baby Sleeping 00:15:00 3 Best Organic Baby Sleeping Bags 00:30:00 All About Baby Sleeping Bags 00:30:00 Baby Sleeping and Intimacy 00:30:00 5 Steps To Get Your Baby To Sleep 00:30:00 Organic Baby Sleeping Linens 00:15:00 5 More Tips To Get Your Baby To Sleep 00:30:00 Baby Sleeping and Family 00:15:00 Allergies and Baby Sleeping 00:30:00 Baby Sleeping For You 00:15:00 Baby Sleeping For New Dads 00:30:00 Enough is Enough Baby Sleeping 00:30:00 Refusing to Sleep 01:00:00 3 Great Companies for Baby Sleeping Sacks 00:30:00 Teething and Baby Sleeping 00:30:00 5 Great Habits for Baby Sleeping 01:00:00 Organic Baby Sleeping 00:30:00 Baby Sleeping Techniques 00:30:00 The 5 S's To Baby Sleeping 00:30:00 The Controlled Crying Technique 00:30:00 Home Remedies For Baby Sleeping 00:30:00 How To Put Your Child To Bed Easily 01:00:00 Is Baby's Sleeping Affecting Other Children? 00:15:00 Multiple Bedtimes 00:30:00 SIDS 01:00:00 Nannying What is a Nanny? 00:30:00 Time Management for Nannies 00:15:00 A Day in the Life of Martha, the Nanny 00:30:00 Caregiver and Team Player 00:15:00 It Takes a Village to Raise a Child 00:15:00 The Nanny's Job Profile 00:15:00 Meet the Needs of the Child 01:00:00 Childcare Child Care Guidelines 00:30:00 Outdoor Safety 00:15:00 Plants That Poison 00:15:00 Guidelines for Food Preparation and Handling 00:30:00 Changing Diapers 00:30:00 Symptoms of Illness 00:30:00 Order your certificate Order Your Certificate 00:00:00

Baby Care and Nannying Diploma
Delivered Online On Demand36 hours
£11.99

Workplace First Aid Training - CPD Certified

4.7(47)

By Academy for Health and Fitness

Are you looking to improve your current abilities or make a career move? Our unique Workplace First Aid Course might help you get there! Expand your expertise with high-quality training - study the Workplace First Aid and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This online training course is accredited by CPD with 10 CPD points for professional development Students can expect to complete this training course in around Eight hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course. With this comprehensive Level 3course, you can achieve your dreams and train for your ideal career. This Level 3course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. Theis Level 3course covers everything you need in order to progress in your chosen career. You'll get a free Student ID card by enrolling in this Level 3course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enrolling on the Level 3course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the Level 3 program. Learning Outcomes: Instant access to verified and reliable information Participation in inventive and interactive training exercises Quick assessment and guidance for all subjects CPD accreditation for proof of acquired skills and knowledge Freedom to study in any location and at a pace that suits you Expert support from dedicated tutors committed to online learning Experts created the course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the Level 3course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this Level 3course and take a step toward a brighter future! Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this Level 3 course Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the Level 3 program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** Module 01: First Aid at Work Introduction The Aim Safe Practices at Work Understanding the Role Arriving at the scene The need for recording incidents and actions First-aid equipment Prioritising the treatment of casualties Contacting the emergency services Incident recording and reporting Dealing with a casualty Clearing up after an incident Module 02: Legal Framework Legislative Requirements Duty of Employer to Make Provision for First-Aid Duties of a Self-employed Person Cases Where Regulations Do Not Apply Module 03: Incident Management at Work Introduction Roles and Responsibilities of a worker when an incident occurs Dos and Don'ts in an emergency Questions to Ask Yourself Fires Electrical Incidents Water Incidents Module 04: Primary Survey Scene Survey Primary Survey Casualty Information and Victim's Information The Recovery Position Accident Reporting Module 05: Secondary Survey Definitions and Purpose of a Secondary Survey Steps of Secondary Survey: How to Examine a Casualty When to Call an Ambulance? Module: 06 Basic First-Aid Techniques The Chain of Survival The Do's and Don'ts of Basic First-Aid First Aid Kit How to use face shields? How to put on a dressing How to put on a bandage How to bandage a hand How to bandage a sprain How to make an arm sling How to Conduct CPR? How to Use an AED? Rescuing Someone from Water & Fire Recordkeeping Module 07: Dealing with Minor Injuries at Workplace Abdominal Trauma Allergic Reactions (Anaphylactic Shock) Bites and Stings Burns and Scalds Contusions (Bruises) Crush Injuries Cuts and Scrapes Dislocation Eye Injuries Extreme Cold (Hypothermia, Frostbite, etc.) Extreme Heat (Heat exhaustion, Heatstroke, etc.) Falls and Breaks Foreign Objects Fractures and Broken Bones Grazes Head Injuries Insect Bites and Rashes Small Splinters Spinal injuries Module 08: Secondary Illness: Loss of Responsiveness and CPR What to do When the Patient is Unresponsive and Breathing? What to do When the Patient is Unresponsive and Not Breathing? Module 09: Secondary Illness: Breathing Problems Common Breathing Problems and First Aid Tips for Each Problem: Asthma Attack Choking Croup Drowning Hyperventilation Module 10: Secondary Illnesses and Injuries Common Secondary Illnesses and First Aid Tips for Each Problem: Assessment Module 11: Dealing With Fractures and Dislocations The Human Skeleton Types of Fractures Head injuries Spinal injuries Fractures in children Dislocations Module 12: Call for an Emergency When to call for an emergency Emergency Services When to call which services Waiting for an emergency service to arrive Module 13: Classifications and Abbreviations Every First Aider Should Know Types Principles Golden Rules The ABC Rule Module 14: Emergency Management for a First Aider Emergency First Aid Roles of First Aider during an Incident Tasks during Emergency Steps to Analyse Assessing the Casualty Module 15: Things to Keep in Mind for A First Aider Initial Steps Permission & Consent Removing Clothing First-Aid Myths Module 16: Appointed Persons in the Workplace First Aid Assessment Process Once you have completed all the modules in the Level 3 course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. Show off Your New Skills with a Certification of Completion The learners have to successfully complete the assessment of this Level 3course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? Anyone interested in learning more about this subject should take this course. This will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this Workplace First Aid Level 3course. There are no prerequisites for enrollment, and you can access the course materials from any location in the world. Requirements The program does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your own speed and grow a quality skillset. Career path After completing this Course, you are to start your career or begin the next phase of your career in this field. Our entire course will help you to gain a position of respect and dignity over your competitors. The certificate enhances your CV and helps you find work in the field concerned.

Workplace First Aid Training - CPD Certified
Delivered Online On Demand8 hours
£12

PMI-ACP Exam Prep: Virtual In-House Training

By IIL Europe Ltd

PMI-ACP® Exam Prep: Virtual In-House Training This course builds on the candidates' practical experience of Agile in the workplace to equip them with the broad range of knowledge and skills required for the PMI® Agile Certification exam. It will follow the PMI® requirements and reference the suggested reading list, including the Agile Practice Guide, but will not be limited to those areas. Within the profession and discipline of project management, Agile continues to develop as a significant and important aspect of bringing change to an organization. Where the products of change must be delivered to the business 'on time,' Agile is often the chosen methodology. In addition to equipping candidates for the PMI® Agile Certification examination, this course will also support candidates in taking a more informed and effective role in Agile projects. It will also enable them to take a significant role in encouraging and enabling the organization to become or develop as an Agile environment. What you will Learn You will learn how to: Appreciate the wider aspects of Agile project management tools and techniques Integrate various disciplines within Agile Tailor / customize Agile to suit the needs of different projects Prepare yourself for the PMI® Agile Certification examination Getting Started Introductions Agenda Expectations Foundation Concepts Defining 'Traditional' Project Management Project management parameters The 'traditional' approach to the parameters Strengths and weaknesses of the traditional approach Defining 'Agile' Project Management Project management parameters revisited The 'agile' approach to the parameters Strengths and weaknesses of agile Managing projects with traditional and agile methods Can the two approaches co-exist? Leveraging the benefits of both methods Options for using both methods on a project Avoiding the elephant traps Key aspects of the PMI® Agile Certified Practitioner (PMI-ACP)® Handbook Overview Eligibility requirements Exam information Exam Blueprint Continuing certification requirements Key aspects of the PMI Agile Certification Examination Content Outline Introduction Agile exam content outline Tools and techniques Knowledge and skills Domains and tasks (not examined) An Introduction to Agile and Implementing Agile Definable work vs. high-uncertainty work Project factors that influence tailoring The Agile Manifesto and 12 Principles Agile mindset Agile domains and tasks Agile Tools and Techniques Related to PM 'Hard Skills' Planning, monitoring, and adapting The need for planning, monitoring, and adapting The Agile approach to planning and plans The Agile planning tools and techniques The Agile monitoring tools and techniques The Agile approach to adapting Product quality A definition of 'product quality' Setting the standard for product quality Agile tools and techniques for achieving product quality Risk management A definition of 'risk' What is 'at risk'? The acceptability of risks The Agile tools and techniques for managing risks Agile Tools and Techniques Related to PM 'Soft Skills' The difference between PM 'hard and soft' skills Communications The importance of communications Forms of agile communications Communications within the project Communications from the project Communications to the project Making communications the cultural norm Interpersonal Skills Defining and understanding management Defining and understanding leadership Defining and understanding servant leadership Delegating vs. empowering Playing to people's strengths Overcoming the roadblocks Core Agile Tools and Techniques The philosophy of core Agile tools and techniques Agile estimation Will traditional forms of estimating work for agile? The relationship between estimating and guessing The relationship between estimating and sizing The where, who, and how of agile estimating Agile analysis and design Product analysis and design from a user point of view Product analysis and design from a supplier point of view Product analysis and design from an agile project point of view Value-Based Agile Tools and Techniques The role of value-based tools and techniques in bridging traditional PM with Agile Value-based prioritization Value-based prioritization and agile projects Investment appraisal methods Regulatory driven Customer driven Ranking methods (MMF, MoSCoW) Metrics What should we measure / track? Methods of measuring / tracking Adding value with metrics Process Improvement Value-stream analysis Value-stream mapping Agile Knowledge and Skills Context of Agile Knowledge and Skills vis-à-vis Agile Tools and Techniques Agile Knowledge and Skills Process focused People focused Product focused Project focused Exam Preparation and Course Closure The application process - where are you now? The 'Exam-Focused Journal' - what you still have to do Further preparation - self-study schedule Exam topic review Practice exam Practice exam debrief Course closure

PMI-ACP Exam Prep: Virtual In-House Training
Delivered OnlineFlexible Dates
£1,550

Power BI - introduction (2 day) (In-House)

By The In House Training Company

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Power BI - introduction (2 day) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry