2379 Courses in Cardiff delivered Online

Make your goals and dreams reality in 2023: Create a Vision Board

Duration 5 Days 30 CPD hours Overview Mining data Manipulating data Visualizing and reporting data Applying basic statistical methods Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle CompTIA Data+ is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making. CompTIA Data+ gives you the confidence to bring data analysis to life. As the importance for data analytics grows, more job roles are required to set context and better communicate vital business intelligence. Collecting, analyzing, and reporting on data can drive priorities and lead business decision-making. 1 - Identifying Basic Concepts of Data Schemas Identify Relational and Non-Relational Databases Understand the Way We Use Tables, Primary Keys, and Normalization 2 - Understanding Different Data Systems Describe Types of Data Processing and Storage Systems Explain How Data Changes 3 - Understanding Types and Characteristics of Data Understand Types of Data Break Down the Field Data Types 4 - Comparing and Contrasting Different Data Structures, Formats, and Markup Languages Differentiate between Structured Data and Unstructured Data Recognize Different File Formats Understand the Different Code Languages Used for Data 5 - Explaining Data Integration and Collection Methods Understand the Processes of Extracting, Transforming, and Loading Data Explain API/Web Scraping and Other Collection Methods Collect and Use Public and Publicly-Available Data Use and Collect Survey Data 6 - Identifying Common Reasons for Cleansing and Profiling Data Learn to Profile Data Address Redundant, Duplicated, and Unnecessary Data Work with Missing Value Address Invalid Data Convert Data to Meet Specifications 7 - Executing Different Data Manipulation Techniques Manipulate Field Data and Create Variables Transpose and Append Data Query Data 8 - Explaining Common Techniques for Data Manipulation and Optimization Use Functions to Manipulate Data Use Common Techniques for Query Optimization 9 - Applying Descriptive Statistical Methods Use Measures of Central Tendency Use Measures of Dispersion Use Frequency and Percentages 10 - Describing Key Analysis Techniques Get Started with Analysis Recognize Types of Analysis 11 - Understanding the Use of Different Statistical Methods Understand the Importance of Statistical Tests Break Down the Hypothesis Test Understand Tests and Methods to Determine Relationships Between Variables 12 - Using the Appropriate Type of Visualization Use Basic Visuals Build Advanced Visuals Build Maps with Geographical Data Use Visuals to Tell a Story 13 - Expressing Business Requirements in a Report Format Consider Audience Needs When Developing a Report Describe Data Source Considerations For Reporting Describe Considerations for Delivering Reports and Dashboards Develop Reports or Dashboards Understand Ways to Sort and Filter Data 14 - Designing Components for Reports and Dashboards Design Elements for Reports and Dashboards Utilize Standard Elements Creating a Narrative and Other Written Elements Understand Deployment Considerations 15 - Understand Deployment Considerations Understand How Updates and Timing Affect Reporting Differentiate Between Types of Reports 16 - Summarizing the Importance of Data Governance Define Data Governance Understand Access Requirements and Policies Understand Security Requirements Understand Entity Relationship Requirements 17 - Applying Quality Control to Data Describe Characteristics, Rules, and Metrics of Data Quality Identify Reasons to Quality Check Data and Methods of Data Validation 18 - Explaining Master Data Management Concepts Explain the Basics of Master Data Management Describe Master Data Management Processes Additional course details: Nexus Humans CompTIA Data Plus (DA0-001) 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 CompTIA Data Plus (DA0-001) 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.

Modern calligraphy online workshop by CalligrAbility, for beginners and improvers. Perfect style for stationary, bullet journalling and greeting cards. Three-hour online session with recording available for a month. £40 enrolment fee and a basic calligraphy kit available for an extra £15.

During pregnancy, hypnotherapy fosters a calm mindset, eases discomfort, and aids in preparing for childbirth (hypnobirthing). By harnessing the power of the mind-body connection, hypnotherapy proves advantageous in alleviating challenges when birthing fostering overall women's health and empowerment.

EnergyEdge's course empowers you with in-depth knowledge of deepwater turbidites. Acquire the necessary skills and knowledge to excel in this specialized field of study.

Overview Learn to Make a Winning Marketing Strategy Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Learn to Make a Winning Marketing Strategy Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Introduction Marketing Plan Objectives Explained 00:07:00 Marketing Plan Objectives Aligning Your Marketing Objectives 00:06:00 Guidelines for Creating Marketing Objectives 00:02:00 Types of Objectives 00:08:00 Workshop Workshop - Create Your Marketing Objectives 00:02:00 Introduction to Marketing Programs Marketing Programs Explained 00:01:00 Marketing Programs What types of marketing programs are best for your business? 00:03:00 Your Website 00:05:00 SEO 00:05:00 Advertising Online 00:09:00 Print Advertising 00:03:00 Press Relations 00:06:00 Social Media 00:05:00 Email 00:06:00 Content Marketing 00:06:00 Trade Shows 00:06:00 Retention Marketing 00:05:00 Additional Marketing Programs 00:04:00 Introduction to Thought Leadership Thought Leadership Explained 00:02:00 Be a Thought Leader Stand Out with Thought Leadership 00:01:00 Why Thought Leadership Matters 00:05:00 Thought Leadership Programs 00:10:00 Workshop Workshop: Create Your Thought Leadership Strategy 00:02:00 Introduction to Creating a Marketing Plan Strategic Marketing Plan Explained 00:01:00 Build a Strategic Marketing Plan Choosing a Marketing Program 00:13:00 Case Study: Product and Services Businesses 00:05:00 Evaluate Your Marketing Mix 00:05:00 Objectives, Tactics, and Assumptions about your marketing program 00:09:00 Common Mistakes 00:03:00 Workshop Workshop: Create Your Marketing Action Plan 00:04:00 Additional Materials Resource - Learn to Make a Winning Marketing Strategy 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

Peer Support as an anti-bullying strategy for schools is now routinely recommended by the DCSF and Ofsted. Many schools in the UK have individual schemes which show good practice within their own setting. However, it is rare to find co-ordination of multiple schemes within a Local Authority , or part of a Local Authority, or even within families or clusters of schools. Course Category Behaviour and Relationships Inclusion Peer Support Meeting emotional needs Description Peer Support as an anti-bullying strategy for schools is now routinely recommended by the DCSF and Ofsted. Many schools in the UK have individual schemes which show good practice within their own setting. However, it is rare to find co-ordination of multiple schemes within a Local Authority , or part of a Local Authority, or even within families or clusters of schools. Coordination of schemes provides opportunities for networking, sharing ideas, and mutual support amongst both adults and young peer supporters creates excellent practice. This approach also leads to: Stability and consistency of training A wealth of back up materials for adults and young people Consistent telephone and email support Opportunities for professional development for teachers, Teaching assistants and Learning Mentors Opportunity for national accreditation from MBF Testimonials The Mentoring and Befriending Foundation described this scheme as “a benchmark for Local Authorities Learning Objectives To discover how a centrally led Peer Support scheme enhances and promotes anti-bullying work across a number of schools. To take away from the day the means and the inspiration to set up a local scheme. To deepen insight into impact of strategic approach to peer support To learn about a real way of reducing bullying across a Local Authority Who Is It For ? Suitable for Anti-Bullying Leads Behaviour Support staff CAHMS TAHMS Learning Support and Guidance Staff Childrens Services Support Services Educational Psychologists Course Content The training day will be led by Inclusive Solutions, and a representative from a Local Authority who has successfully managed such a scheme for 10 years. This will be an interactive day with lots of opportunity for questions and exploration. What the day includes: How this work fits with an Inclusive Local Authority Key aspects and issues in running multiple Peer Support schemes from the centre Graphics workshop The 3 legged stool of Peer Support: Selection, Training and Supervision A chance to view and purchase some of the nationally accredited materials successfully used and developed over many years. f you liked this course you may well like: PEER COUNSELLING AS AN ANTI-BULLYING STRATEGY

Program Management Skills: On-Demand Program managers coordinate and give oversight to the efforts of marketing groups, project teams, product delivery, maintenance and support, operations and staff from various functional groups, including suppliers, business partners, and other external bodies. The goal is to ensure that proposed business transformation, through the delivery of complex products and processes, is implemented to realize the organization's strategic benefits and objectives, for which the program was selected. The goals of this course are twofold: To provide participants with key program management principles and techniques, recognized as best practices, to enable more effective program management; and to leverage core elements of the program management life cycle, processes, tools and techniques, to enable program management effectiveness. The participant will learn and apply the principles of program management through discussions, activities, and case study exercises. What You Will Learn At the end of this workshop, you will be able to: Maximize the transformational impact of a program according to the business needs Explain management principles and techniques and apply them within a program context Implement program governance and organization that will produce expected benefits Plan for and manage benefit realization, risks, issues, and quality Manage component projects' interdependencies that are linked to both program and strategic objectives Engage program stakeholders effectively. Improve communication and action planning effectiveness for programs in organizations Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Fundamental definitions and concepts Program challenges and benefits Program best practices and success criterion Stakeholder management Governance: program management office and program boards Standard for Program Management overview Vision, Leadership, and the Business Case What is vision, why, and how? Leadership vs. Management Program business case Program Organization and Governance Program organization Program governance Program board roles and responsibilities Benefits Management Benefits explored Benefits management Benefits realization Program Management Planning Program management plan Program blueprint and roadmap Program component dossier Program tranches Program estimating Program scheduling Program Monitoring and Controlling Program Control - An Overview Program Monitoring and Controlling Monitoring and Controlling Transition Program Risk and Issue Management Risk and issue management overview Program risk management Program issue management Program Quality Management Program quality management overview Program quality management principles Program Stakeholder Management Stakeholder engagement overview Stakeholder engagement planning EI, trust, communication and stakeholder engagement Program Closure and Benefits Sustainment Program closure overview Closing the program Program benefits sustainment Summary What did we learn, and how can we implement this in our work environments?

Getting the most from employees - How to gain an understanding of where your employees/staff/teams are to enable communication and give ease to difficult conversations. Understanding the difference between competitive working and cooperative working where these skills are useful and useless. Discover how to retain your staff and improve performance of staff who are on the verge of underperformance. Gain an insight into what causes behavioural outcomes and how to encourage favourable outcomes over manipulating outcomes based on you meeting your needs.  45-60 min zoom workshop held on the last Wednesday of the month, every month at 7pm (limited spaces) Upon purchase you will be prompted to choose a date. You will receive email confirmation of the event via google calendar plus reminders as the event time approaches. Is your company culture a healthy one? Could you do better? Would you like to be less concerned over staff wellbeing & have more time to focus on CPD & growth? Improve Inductions, Onboarding and Recruitment Try this introductory workshop before committing to day event training options for your business