5161 Courses

Join Wildside London in the creative studio at West 16th for a Christmas Wreath workshop on Thursday 5th December at 7pm.  Kick off the festive season by learning to create a gorgeous wreath with an array of seasonal florals. Our workshops are fun, immersive and relaxed and we provide all the materials and instruction to enable you to design and build a fabulous wreath. The evening provides an opportunity to plan a creative Christmas get together that will put you right into the Christmas spirit. Mulled wine and mince pies will be served alongside the wreath making tutorial, or book a table in the restaurant for dinner before and make a night it it.

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.

With an emphasis on intermediate-level abilities, this course covers Oracle Primavera Project Manager P6 PPM Professional Client's advanced features. The tool's database administration and setup instructions are also included. Upgrade your skills in Oracle Primavera Project Manager P6 PPM Professional Client with this advanced course.

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

Fused glass workshop to create unique pieces

BCG, Scar, training

Learn to make your own bright and happy plant hangers, wall mat, table mat etc in this beginner macrame course. No prior experience is needed. In this workshop, instructor Rahamatullah will lead as you learn: • How to begin some macrame piece, including an overview of necessary materials. • How to work several different macrame knots. • How to incorporate a wooden ring and wooden beads. • Leave with a finished products, and the know-how to design and create more pieces on your own. More benefits: no mistakes possible (you can always start over during the process), and great for reflexes and memory!

Level Three, the final learning stage of our professional development courses, aims to bring you to the highest standard of advanced detailing skill through the spectrum of; rotary polisher techniques, wet sanding by machine and refinement, a full understanding of SMAT and DAT polishes and compounds and their role in efficiency and correction on different paint types, a wide selection of pads and equipment such as nano polishers and attachments. Mechanical training in wheel removal and jacking on multiple vehicle styles allowing deep cleaning access to vehicle arch and components, and specialist finishes on carbon fibre, GRP and gel coat are examined, demonstrated and explained. Level Three aims to bring you to the highest standard of advanced detailing skill, through the spectrum of rotary polisher techniques, wet sanding by machine, a full understanding of SMAT and DAT polishes and compounds, a wide selection of pads and equipment such as nano polishers and attachments. Mechanical training in wheel removal and jacking on multiple vehicle styles allowing deep cleaning access to vehicle arch and components, and specialist finishes on carbon fibre, GRP and gel coat are examined and explained. • DAT/SMAT technology • Pneumatic polishers and sanders • Advanced Dual Action technique • Rotary machine polishers • Glass polishing • Wheel removal • Under-arch cleaning • Cleaner chemistry • Time management and planning • Trim and seat removal • In-depth interior detailing • Cloth types • Advanced Dual Action technique • Rotary machine polishers • Mini/nano machine polishers • Wet-sanding • Advanced pad types • GRP, carbon and insulative substrates • Badge and trim removal • Texture levelling • Show preparation • Ceramic coatings • Polymer coatings • Coating troubleshooting • Coatings after-care • Fillers and glazes for show finishes • Business management • Business administration • Safe working practices • Safe vehicle lifting - ramp/jacking • Workshop planning • Advanced chemical knowledge • Risk assessments • Gloss meter usage • PPE • Employee management Following completion of training and ongoing assessment, case studies and exercises will lead to the level three exam and, upon grading, award of our advanced detailing Level 3 Detailing. Course Length 3 Days (0930 - 1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Completion of Level 2 Refreshments or Lunch Refreshments included

Job Placement Program (Vietnam & Cambodia)