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

8194 Insights courses in Manchester delivered Online

MB-240T00 Dynamics 365 for Field Service

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This course is designed for IT professionals with experience or interest in delivering Field Service solutions for large-scale customers. Overview Identify the key components involved in Field Service Implementations. Define the products and services that will be delivered to customers. Determine which pricing options to use in specific scenarios. Determine which resources are required. Dynamics 365 Field Service helps organizations better position themselves in the market by providing a variety of tools that assist in identifying and scheduling resources and managing workloads for mobile workers. This course will equip students with the skills necessary to identify and configure the key components that are used to deliver Field Service and mobile solutions. Key topics include identifying the organizational considerations that will drive configuration decisions and common configuration aspects. This course helps students better understand the bigger picture and end goals focused around implementations that aid in designing more efficient solutions that align with customer and organizational goals. Configure Field Service Introduction to configuring Field Service Defining products and services Defining tax codes Resource Scheduling Configuration Mapping and location information Configuring resource components Defining account preferences Defining and Configuring Bookable Resources Defining bookable resources Resource pools, crews and facilities Configure Incidents Creating an incident Using service tasks Inventory and Work Order Management Configure Field Service work orders Creating work orders Managing work orders Field Service Agreements Using Field Service agreements Set up bookings Set up invoices Inventory and Purchasing Manage customer assets Manage inventory Purchasing and returns Field Service Mobile Mobile client overview Install and deploy Field Service mobile projects Manage mobile projects Deploy the mobile client Universal Resource Scheduling URS overview and configuration Enabling entities for URS Customize entities for URS Managing Scheduling Options Using the schedule board Schedule items Rescheduling and substituting resources Crew and pool scheduling Customizing the Schedule Board Configure the board Create additional schedule boards Use views to enhance the schedule board Configuring schedule board queries and filters Working with requirement groups Advanced Scheduling Options Working with resource scheduling optimization Defining optimization goals Defining optimization scopes Defining optimization profiles Single resource scheduling Additional course details: Nexus Humans MB-240T00 Dynamics 365 for Field Service training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the MB-240T00 Dynamics 365 for Field Service course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

MB-240T00 Dynamics 365 for Field Service
Delivered OnlineFlexible Dates
Price on Enquiry

BA10 - Understanding Root Cause Analysis

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Executives, Project Managers, Business Analysts, Business and IT stakeholders working with analysts, Quality and process engineers, technicians, corrective action coordinators or managers; supervisors, team leaders, and process operators; anyone who wants to improve their ability to solve recurring problems. Overview Learn how to initiate a root cause analysis and gather data for investigating process and non-process incidentsDemonstrate how to collect data through interviews and analysisApply powerful techniques to identify and know the difference between symptoms and root causesLearn to know when to use the appropriate technique in root cause identification Learn how to avoid future incidents by developing appropriate recommendations to address causal factors and root causes Develop a process to identify systemic problem areas In this course, participants will learn to apply several practical, systematic methods for analyzing incidents and problems to uncover root causes. Understanding of these techniques will be reinforced by classroom exercises. Introduction & Objectives What is a 'Problem?' Why Problems Persist What is A Root Cause? Why Root Causes are important How to Organize for an RCA RCA Roles and Responsibilities Assemble your RCA Team Modes of Communication How to Resolve Conflict Case Study Exercise Select the Problem to Analyze Define the selection criteria Plan and estimate tasks for the team Finalize the plan and gain agreement among your stakeholders Case Study Exercise Define the Problem What to look for - Problem-as-Given (PAG) vs. Problem-as-Understood (PAU) Developing your problem statement Refining the problem specification Case Study Exercise Identify the Source of the Problem Discuss when to use the appropriate analysis technique to determine the problem source Process Diagram Forms & Checklists Statistical Sampling Fishbone Diagram Surveys Charts - Line, Scatter, Bar, & Pie Case Study Exercise Solution Options Analysis & Selecting the 'Best Fit' How to approach different solution options Brainstorming Weighted Evaluation Selecting the appropriate option Hold an Retrospective on your approach Planning the proposal Case Study Exercise Putting RCA into Practice Create a Root Cause Analysis program within your organization How to develop appropriate recommendations to address root causes at various levels to avoid future incidents Additional course details: Nexus Humans BA10 - Understanding Root Cause Analysis training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the BA10 - Understanding Root Cause Analysis course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

BA10 - Understanding Root Cause Analysis
Delivered OnlineFlexible Dates
Price on Enquiry

Control and Administration of Medicines Online Training Course

By IOMH - Institute of Mental Health

Overview of Control and Administration of Medicines In the ever-evolving landscape of healthcare, the control and administration of medicines stand as pillars of patient safety and well-being. The UK's healthcare sector is witnessing a surge in demand for skilled professionals adept in medicine management. With an ageing population and increasingly complex medical needs, the importance of effective medication control cannot be overstated. Recent statistics reveal that medication errors cost the NHS in England over £98 million annually and cause 712 deaths on average per year. This underscores the critical need for comprehensive training in the administration of medicines. Our course on Control and Administration of Medicines addresses this pressing need, equipping learners with the knowledge to navigate the intricate world of pharmacology and medicine management. From understanding the fundamentals of medicine management to exploring the nuances of palliative care, this course offers a thorough grounding in essential concepts. Delve into the four principles of medicine optimisation, unravel common pharmacological challenges, and gain insights into the legal landscape governing medication control. By mastering these crucial aspects, you'll be poised to make a significant impact in healthcare settings, enhancing patient outcomes and contributing to a safer, more efficient healthcare system. This Control and Administration of Medicines Course will help you to learn: Explain the fundamentals of medicine management and administration. Discuss the importance of effective medicine management. Demonstrate how to prescribe medication appropriately. Identify common medication problems and solutions. Recognises commonly used medicines. Apply principles of palliative care medicine. Apply the four principles of medicine optimisation. Manage medication in aged care facilities. Understand relevant laws and legislation. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Control and Administration of Medicines Online Training Course. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Control and Administration of Medicines Online Training Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Caregivers: Enhance your knowledge and confidence in medication administration for loved ones. Healthcare Professionals: Refine your skills and stay up-to-date with best practices in medication management. Pharmacy Staff: Deepen your understanding of medicines and their role in patient care. Community Workers: Equip yourself to support individuals in managing their medications effectively. Aspiring Healthcare Professionals: Lay a strong foundation for a rewarding healthcare career. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Control and Administration of Medicines Online Training Course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Control and Administration of Medicines Online Training Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.  Mental Health Nurse: £22K to £33K/year. Community Nurse: £35K to £45K/year. Pharmacist: £30K to £50K/year. Pharmacy Technician: £18K to £28K/year. Healthcare Assistant: £16K to £28K/year.   Course Curriculum Module 01: Medicine Management Fundamentals Medicine Management Fundamentals 00:37:00 Module 02: Importance of Medicine Management Importance of Medicine Management 00:25:00 Module 03: Prescribing Medication Effectively Prescribing Medication Effectively 00:27:00 Module 04: Common Problems - Pharmacological Management Common Problems - Pharmacological Management 01:05:00 Module 05: Common Medicines to Use Common Medicines to Use 00:18:00 Module 06: Palliative Care Palliative Care 00:24:00 Module 07: The Four Principles of Medicine Optimisation The Four Principles of Medicine Optimisation 00:00:00 Module 08: Managing Medication in Residential Aged Care Facilities Managing Medication in Residential Aged Care Facilities (RACFs) 00:35:00 Module 09: Law and Legislation Law and Legislation 00:25:00 Assignment Assignment - Control and Administration of Medicines Online Training Course 00:00:00

Control and Administration of Medicines Online Training Course
Delivered Online On Demand4 hours 16 minutes
£15

Property Development Diploma in the UK

5.0(3)

By School Of Health Care

Property Development: Property Development Course Online Unlock success with our Property Development course! Dive deep into property development strategies, mastering every aspect of property development. Our expert-led property development course offers hands-on experience and practical insights. Transform your career with the ultimate property development training. Start your journey in property development today and excel in property development! Property Development: Property Development Course includes a wide range of activities and procedures, from purchase of land through the construction and development of infrastructure. Do you want to start a career in Property Development: Property Development Course or improve your abilities in this sector? So, this Property Development course is for you. This Property Development: Property Development Course will provide you with a solid foundation for becoming a confident Property Development: Property Development Course specialist while also assisting you in developing your Real Estate Development knowledge. So, if you want to build a successful career in Property Development: Property Development Course, enroll in our Property Development: Property Development Course today! Main Course: Property Development Course Free Courses Course 01: Estate Agent Course [ Note: Free PDF certificate as soon as completing the Property Development: Property Development Course] Property Development: Property Development Course Online This Property Development: Property Development Course consists of 09 Module. Elevate your skills with our comprehensive Property Development course! This property development program covers all essential property development techniques, ensuring you gain valuable property development insights. Learn from industry leaders in property development and apply advanced property development strategies to real-world scenarios. Enroll in our property development course now and become a property development expert! Special Offers of this Property Development: Property Development Course This Property Development: Property Development Course includes a FREE PDF Certificate. Lifetime access to this Property Development: Property Development Course Instant access to this Property Development: Property Development Course Get FREE Tutor Support to this Property Development: Property Development Course Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Property Development: Property Development Course. Who is this course for? Property Development: Property Development Course Online This Property Development: Property Development Course is suitable for those who want to learn more about property development and wants to make a career in this field, which includes: Estate agents Construction project managers Real estate planners Property brokers Engineers Architects Requirements Property Development: Property Development Course Online To enrol in this Property Development: Property Development Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Property Development: Property Development Course. Be energetic and self-motivated to complete our Property Development: Property Development Course. Basic computer Skill is required to complete our Property Development: Property Development Course. If you want to enrol in our Property Development: Property Development Course, you must be at least 15 years old.

Property Development Diploma in the UK
Delivered Online On Demand3 hours 30 minutes
£12

Twitter Marketing for Profit

By NextGen Learning

Twitter Marketing for Profit Course Overview The "Twitter Marketing for Profit" course equips learners with the knowledge and strategies needed to leverage Twitter as a powerful marketing tool. It covers key aspects such as crafting effective tweets, growing a dedicated following, using analytics to improve engagement, and turning Twitter presence into tangible business profit. Designed for marketers and entrepreneurs, this course delivers real-world techniques and tactics for maximising Twitter's potential in boosting brand visibility and revenue. By the end, learners will have a clear understanding of how to create and manage a successful Twitter marketing campaign that drives measurable results. Course Description This course dives deep into the core principles of Twitter marketing, focusing on audience engagement, content creation, and analytics. Learners will explore topics such as optimising profile setups, developing content calendars, understanding Twitter algorithms, and implementing targeted advertising strategies. The course also introduces the importance of hashtags, influencer partnerships, and trends. Participants will gain insights into how to monitor campaign performance and adapt strategies accordingly. The course is structured to provide learners with a comprehensive understanding of Twitter marketing, helping them to drive engagement and achieve business goals effectively. Twitter Marketing for Profit Curriculum Module 01: Introduction to Twitter Marketing Module 02: Building a Twitter Strategy Module 03: Content Creation and Curation Module 04: Growing Your Audience and Engagement Module 05: Leveraging Twitter Analytics for Insights Module 06: Advertising on Twitter Module 07: Measuring Success and Adjusting Strategies (See full curriculum) Who is this course for? Individuals seeking to enhance their digital marketing skills. Professionals aiming to optimise Twitter for business growth. Beginners with an interest in social media marketing. Entrepreneurs wanting to promote their business via Twitter. Career Path Social Media Manager Digital Marketing Specialist Content Strategist Brand Manager Twitter Marketing Consultant

Twitter Marketing for Profit
Delivered OnlineFlexible Dates
£7.99

Interview Skills: Ace the Interview

By NextGen Learning

Interview Skills: Ace the Interview Course Overview: "Interview Skills: Ace the Interview" is a comprehensive course designed to equip learners with essential strategies and techniques to excel in job interviews. Through this course, learners will gain a deeper understanding of interview dynamics, including how to present themselves confidently, handle common and challenging questions, and leave a positive impression on potential employers. The course is tailored to provide clear, actionable advice that can be applied to interviews across various industries. Whether you are preparing for your first job interview or looking to refine your skills, this course offers valuable insights to ensure you stand out in the competitive job market. Course Description: This course covers key areas of interview preparation, including how to craft a compelling self-presentation, research the company, and effectively answer both standard and tough questions. Learners will explore strategies for handling behavioural questions, demonstrating relevant skills, and creating lasting positive impressions. Each module is designed to progressively build knowledge, offering practical approaches to navigating interviews with confidence. The course also addresses the critical aspect of salary negotiations and provides insights on how to respond to sensitive questions. By the end of the course, learners will have honed their interview skills and be well-prepared for success in their job search. Interview Skills: Ace the Interview Curriculum: Module 01: Introduction Module 02: The Warm Up Module 03: The Core Module 04: Let’s Talk About Money Module 05: General Instructions (See full curriculum) Who is this course for? Individuals seeking to improve their job interview performance. Professionals aiming to advance their career through better interview techniques. Beginners with an interest in understanding the interview process. Anyone looking to refine their approach to job interviews. Career Path: Job Seekers Recruitment Coordinators Career Coaches HR Assistants Interview Preparation Consultants

Interview Skills: Ace the Interview
Delivered OnlineFlexible Dates
£7.99

UK Politics

By NextGen Learning

UK Politics Course Overview This course offers a comprehensive introduction to UK politics, providing an in-depth understanding of its structures, systems, and key political processes. Covering essential topics such as democracy, electoral systems, political parties, and pressure groups, the course offers valuable insights into how the UK’s political system operates. Learners will explore the dynamics between government, society, and international relations, equipping themselves with knowledge applicable to a wide range of professional settings. By the end of the course, students will gain a solid foundation in UK politics, enabling them to engage with current affairs more critically and effectively. Course Description The UK Politics course delves into the core components of the UK political system, exploring the history and functioning of democracy, electoral systems, and the role of political parties and pressure groups. Learners will gain an understanding of the structure and powers of government, the electoral process, and how the UK engages in global politics, particularly in relation to the European Union. The course is designed to provide both theoretical knowledge and practical insights, empowering learners to critically analyse political developments and debates. Key skills gained will include political analysis, problem-solving in political contexts, and an ability to engage with policy discussions. UK Politics Curriculum Module 01: Overview of UK Politics Module 02: Concept of Democracy Module 03: Electoral Systems Module 04: Political Parties in UK’s Representative Democracy Module 05: Pressure Groups in the UK Module 06: The European Union (See full curriculum) Who is this course for? Individuals seeking to understand the UK political system. Professionals aiming to enhance their knowledge of political structures. Beginners with an interest in politics and governance. Anyone looking to improve their analytical skills in political contexts. Career Path Political Analyst Policy Advisor Public Relations Specialist Government Official International Relations Consultant Political Campaigner

UK Politics
Delivered OnlineFlexible Dates
£7.99

Primavera P6 Professional Fundamentals Rel 19

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Analyst End User Implementer Manager Overview Create a Work Breakdown Structure Define roles and resources Assign roles Assign resources Analyze resources Optimize the project plan Understand data structures Create a project Add activities View calendars Create relationships Schedule the project Assign constraints Create reports Format schedule data Execute the project Enrolling in this course will help you understand P6 Professional's basic features and functionality so you can apply them to your organization's project management processes. You'll also learn how to manage projects on time and within budget Understanding P6 Data Describing Enterprise and Project-Specific data Logging In Opening an Existing Project Opening and Customizing Layouts Enterprise Project Structure Describing Components of EPS Creating a Project Create a project Navigating in the Projects Window Viewing Project Details Creating a Work Breakdown Structure Defining a Work Breakdown Structure Creating the WBS Hierarchy Adding Activities Describing an Activity and its Components Describing Activity Types Adding Activities Adding a Notebook Topic Adding Steps to an Activity Assigning Activity Codes Creating Relationships Viewing a Network Logic Diagram Relationship Types Creating Relationships Scheduling Performing a Forward and Backward Pass Describing Float Assigning Constraints Applying an Overall Deadline to a Project Apply a Constraint to an Activity Using Reflection Projects Creating a Reflection Project Merging Changes Formatting Schedule Data Grouping Activities Sorting Filtering Roles and Resources Describing Roles and Resources Viewing Dictionaries Assigning Roles Assigning Roles to an Activity Assign Rates on Roles Assigning Resources Assigning Resources Adjusting Budgeted Units/Time Analyzing Resources Displaying the Resource Usage Profile Optimizing the Project Plan Analyzing Schedule Dates Shortening a Project Schedule Analyzing Resource Availability Baselining the Project Plan Creating a Baseline Plan Display Baseline Bars on the Gantt Chart Project Execution and Control Describing Methods for Updating the Schedule Using Progress Spotlight Statusing Activities Rescheduling the Project Reporting Performance Describing Reporting Methods Running a Schedule Report Creating a report with the Report Wizard Additional course details: Nexus Humans Primavera P6 Professional Fundamentals Rel 19 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Primavera P6 Professional Fundamentals Rel 19 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Primavera P6 Professional Fundamentals Rel 19
Delivered OnlineFlexible Dates
Price on Enquiry

AWS Certified Solutions Architect - Associate

By Nexus Human

Duration 4.5 Days 27 CPD hours This course is intended for This course is intended for individuals who have basic knowledge on cloud computing; on-premise system administrators; IT specialists, interested in AWS and Cloud Technologies. Overview Upon successful completion of this course, students will know how to design and deploy scalable, highly accessible and fault-tolerant systems in AWS. In this course, students will learn the main 'Managed Service' offered by AWS; How to design and deploy scalable, highly accessible and fault-tolerant systems in AWS; How to choose the most appropriate AWS service. Introduction Course overview Exam Blue Print Public clouds & cloud economics AWS Overview & Whitepapers Setting up AWS Account Identity and Access Management (IAM) Local users, groups & roles SAML providers Policies Cross Account Access Best practices & Examples Lab Exam highlights Sample questions Simple Storage Service (S3) & Glacier Buckets Objects Lifecycle Configurations and permissions Custom bucket policies Best Practices & Examples Lab Exam highlights Sample questions Virtual Private Cloud (VPC) VPC Internet gateway vs NAT Gateway Elastic IPs Subnets & Routing tables Security Groups & Network Access Lists VPC Peering & Endpoints Managed VPN Connections Best Practices & Examples Lab Exam highlights Sample questions Elastic Compute Cloud (EC2) Instances Amazon Machine Images(AMIs) Elastic Block Store (EBS) Network & Security Load Balancers (ELB) Auto Scaling Groups (ASG) Instance Management Best Practices & Examples Lab Exam highlights Sample questions Route 53 Hosted Zones Health checks Traffic flow Best Practices & Examples Lab Exam highlights Sample questions Relational Database Service (RDS) Engine types Performance & Resilience Subnet groups Best Practices & Examples Lab Exam highlights Sample questions CloudWatch Dashboard and Metrics CloudWatch logs CloudWatch rules Best Practices & Examples Lab Exam highlights Sample questions Other AWS Services Simple Overview CloudFront DynamoDB Elasticache Redshift SQS SWF SNS Elastic Transcoder API Gateway Kenesis CloudFormation Exam highlights Sample questions Multiple AWS Services exercise Lab 1 - Architecting multi-tier environment Lab 2 - Configure backup and monitoring Practice Exam Additional course details: Nexus Humans AWS Certified Solutions Architect - Associate training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AWS Certified Solutions Architect - Associate course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

AWS Certified Solutions Architect - Associate
Delivered OnlineFlexible Dates
Price on Enquiry

Power BI - introduction to intermediate (2 days) (In-House)

By The In House Training Company

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet 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 use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

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