162 Courses in Cardiff

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

PQASSO (Practical Quality Assurance Standard for Organisations) is a quality standard designed for the voluntary and community sector. Organisations can choose to use the criteria as a self-assessment tool or can go on to external accreditation and gain the Quality Mark at one of three levels, all of which are recognised and approved by the Charity Commission. This half day course provides an excellent introduction to this quality standard, which is now used by some statutory authorities as a pre-requisite for funding.

training at home, fitness, personal trainer, workout, health

Qualsafe Awards has recognised the invaluable experience and training that CFRs bring to the table. As a result, they've introduced a bespoke 2-day FREC3 RPL Course, specifically designed for learners like you who already hold one of the approved qualifications. This course recognises your prior learning, allowing you to fast-track your way to the FREC 3 qualification.

This comprehensive course, developed in line with the esteemed guidelines of the Resuscitation Council (UK), Skills for Health, and the Faculty of Pre-Hospital Care (RCS Ed), is designed to enhance your abilities in delivering superior emergency care across various settings.

R&D work is often carried out in entrepreneurial companies with the aim of developing solutions to scientific or technological problems for a wide range of customers. Projects can include longer term 'frontiers of science' research, medium term product development/manufacturing or more immediate troubleshooting or contract research assignments. In all these contexts, the ability to create innovative solutions in a timely and cost-effective manner is the essence of successful R&D. Whilst R&D groups typically excel in technical expertise, those involved often recognise that there is scope for improving the way that projects are managed. The aim of this training programme is to address this need whilst ensuring that the creative, entrepreneurial spirit that is fundamental to good R&D continues to flourish. MODULE 1: Creating the foundations for success Off-line video tutorials and exercises Total time ~ 1 - 1.5 hours Video 1: Making the most of project management in R&D Characterising R&D projects Applying project management to R&D work Exploiting the potential of project management in R&D Video 2: Promoting success in R&D project management Modelling successful project management Evaluating performance and promoting success The role and skills of the project manager/leader MODULE 2: Initiating and defining R&D projects Live interactive sessions (via Zoom): Session 1: 10:00 - 12:00 Session 2: 14:00 - 15:30 Session 1: Selecting and initiating projects Recognising worthwhile opportunities; initiating projects Identifying stakeholders and their goals Characterising and engaging stakeholders Session 2: Defining goals and agreeing deliverables Establishing the full scope of the project Clarifying and prioritising project deliverables Defining and agreeing deliverable specifications MODULE 3: Planning R&D projects Live interactive sessions (via Zoom): Session 1: 10:00 - 12:00 Session 2: 14:00 - 15:30 Session 1: Identifying and organising activities Creating effective plans; avoiding planning pitfalls Identifying tasks and assigning responsibilities Sequencing tasks and estimating durations Session 2: Developing the timeline and resource plan Identifying the 'critical path'; creating a resource plan Dealing with estimating uncertainty Accelerating the programme MODULE 4: Leadership and teamwork in R&D projects Off-line video tutorials and exercises Total time ~ 1 - 1.5 hours Video 1: Working effectively in project teams Building teamwork in contemporary organisations Recognising each other's skills; building synergy Building good working relationships; handling conflict Video 2: The role of the R&D project team leader Building teamwork: the role of leadership Creating an effective team culture Delegating work and motivating team members MODULE 5: Managing uncertainty in R&D projects Live interactive sessions (via Zoom): Session 1: 10:00 - 12:00 Session 2: 14:00 - 15:30 Session 1: Characterising uncertainty; identifying risks Exploring uncertainty; applying risk management Focusing the risk management process Identifying and defining risk events Session 2: Managing and controlling risks to the project Evaluating risk events Selecting between risk strategies; setting contingencies Updating and controlling exposure to risk MODULE 6: Implementing and controlling R&D projects Live interactive sessions (via Zoom): Session 1: 10:00 - 12:00 Session 2: 14:00 - 15:30 Session 1: Initiating assignments and managing changes Creating a pro-active implementation and control culture Establishing effective implementation and control procedures Assigning work and managing changes Session 2: Monitoring, managing and developing performance Adopting meaningful monitoring techniques Responding to problems; building performance Managing and controlling multiple project assignments

The 2-hour Baby & Child First Aid class covers CPR, Choking, Bumps, Burns, Breaks, Bleeding, Febrile Seizures and Meningitis & Sepsis Awareness and will give everyone who attends the peace of mind they deserve.

Our *NEW* Mini First Aid Baby Proofing class is our second class, designed for parents and carers of babies and children over 3 months. It can be taken after our 2 hour Baby and Child First Aid class, or in isolation for those parents who are starting their weaning journey, or have a baby on the move!

We invite adults, children, complete beginners, and advanced pianists alike to join us at our studio on Baker Street for the finest and most comprehensive piano lessons London has to offer, thanks to a wonderful team of piano instructors. Please contact us for in-person or online lesson availability.

This 3 Days programme will equip you to use, price, manage and evaluate interest rate and cross-currency derivatives. The course starts with the building blocks of money markets and futures, through yield curve building to interest-rate and cross-currency swaps, and applications. The approach is hands-on and learning is enhanced through many practical exercises covering hedging, valuation, and risk management. This course also includes sections on XVA, documentation and settlement. The programme includes extensive practical exercises using Excel spreadsheets for valuation and risk-management, which participants can take away for immediate implementation.