687 Courses delivered Online

Our masterclass series goes behind the studio door and explores the processes of globally respected designers.

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.

BRIT Creative Coaching is structured for Performing Arts Students to reach their goals. Discover and build new skills that you need outside the studio.

Duration 1 Days 6 CPD hours This course is intended for Multi-role (consumers, business authors, professional authors, developers, administrators, modelers, project managers) This course provides students with an overview of the IBM Cognos Analytics suite of products and their underlying architecture. Students will examine each component as it relates to an Analytics solution & will be shown a range of resources. IBM Cognos Analytics Describe IBM Cognos Analytics Describe IBM Cognos Analytics components Describe IBM Cognos architecture at a high level Describe IBM Cognos security at a high level Consume Content in IBM Cognos Analytics Where do consumers access BI content? Use published reports Drill through to related data Specify run report options Specify properties of an entry Alerts and Watch Items Create Reports in IBM Cognos Analytics Overview of reporting and report authoring Identify package types, uploaded files, and data modules available for reporting Examine IBM Cognos Analytics - Reporting Examine the interface Explore different report types Create a simple, sorted, and formatted report Create a report view Create a subscription Create an Active Report Import and report on personal data Create Dashboards in IBM Cognos Analytics Describe IBM Cognos Dashboarding Identify the IBM Cognos Dashboarding user interface Add report content and tools to create dashboards Widget-to-widget communication Filter data in the dashboard Sort, group and ungroup, and calculate data Create Metadata Models in IBM Cognos Analytics Define IBM Cognos Framework Manager and its purpose Describe the IBM Cognos Framework Manager environment Describe IBM Cognos Cube Designer Get high-level content from Dynamic Cubes course and/or FM course Web-based Modeling Create Data Modules Extend IBM Cognos Analytics Introduction to IBM Cognos Mobile Key features Examine Cognos Mobile architecture Identify supported products Introduction to IBM Cognos BI for Microsoft Office Describe Cognos Analysis for Excel (CAF) Compare IBM Cognos Analytics & IBM Cognos BI New features in IBM Cognos Analytics Changes from IBM Cognos BI to IBM Cognos Analytics Legacy option Examine Event Studio Examine the role of Event Studio in Performance Management List the benefits of Event Studio Examine Metric Studio Identify scorecards, metrics, and metric types Organize metrics with strategies Track initiatives with projects

Duration 3 Days 18 CPD hours This course is intended for This course is designed for project managers, Scrum masters, business analysts, and team leaders looking to effectively manage their development projects using Team Foundation Server 2017. Overview The course also demonstrates how TFS facilitates the use of storyboards to prototype experiences, request stakeholder feedback, foster team collaboration, and generate reports. The final two modules of the course provide an overview of how testers and developers can work effectively using appropriate tools in the Visual Studio family. In this course, attendees will plan a new software development project and go through the steps to initiate the project using Visual Studio 2017. This includes recording requirements, creating a product backlog, and estimating effort for backlog items. Introducing the Microsoft Visual Studio 2017 Family What?s new in Visual Studio 2017 Overview of the Visual Studio 2017 family Overview of product features Project workflow across the Visual Studio 2017 suite of products Initiating a New Project Organizing projects in TFS Understanding process templates Creating a new team project Setting team project properties Switching between team projects Work Item Primer Overview of work items Traceability between work items Searching and creating custom queries Work item charting and pinning charts Work item tagging Configuring project notifications Creating our Product Backlog Examining requirement types Creating backlog items Creating requirement hierarchies using features The importance of acceptance criteria Agile Estimation Introduction to estimation Using story points Planning Poker and other popular estimation techniques Adding your estimates to TFS work items Working from the Product Backlog Introducing the Kanban board Entering and editing details on the Kanban board Customizing columns, including using split columns and limiting WIP Recording our Definition of Done (DoD) Understanding the Cumulative Flow Diagram Working in Sprints Specifying your sprint schedule and your team capacity Selecting items for the sprint backlog using forecasting Decomposing requirements into tasks Using burndown charts to track progress Monitoring work using the task board Working with unparented work items Retrospectives The importance of retrospectives Conducting an efficient sprint retrospective What you should avoid in your retrospective Working with TFS Teams Configuring teams in our team project Managing work from a master backlog Allocating work to our teams Configuring iterations for TFS teams Enhancing Requirements Using Storyboards Overview of storyboarding capabilities Creating a storyboard to illustrate a requirement Linking a storyboard to a work item Getting Stakeholder Feedback Introducing the Microsoft Feedback Client Using the Microsoft Feedback Client to provide rich feedback to the team Adding continuous feedback into your workflow Fostering Team Collaboration An overview of the various clients The use of email in sharing information Choosing the appropriate client tool Creating and Customizing Reports Overview of reporting architecture Reviewing the out of the box reports Adding new reports Creating ad hoc reports using Excel Overview of Agile Testing The role of the tester in a sprint planning meeting A lap around web-based test management Creating a test plan Creating manual test cases from requirements Overview of Agile Development Using My Work to select tasks from the sprint backlog Understanding the value of linking changesets to work items The importance of unit testing Creating a continuous integration build Additional course details: Nexus Humans Managing Agile Projects Using TFS 2017 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 Managing Agile Projects Using TFS 2017 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.

https://www.instagram.com/masterpeacelondon/

In a world brimming with ubiquitous materials, ceramics possess an unparalleled charm, transcending time and civilisation. 'Ceramics: Pottery & Sculpting Artistry' is a specially curated course that embarks on a fascinating journey through the intricate world of pottery and sculpting. From delving into the heart of various clays to the mesmerising art of wheel throwing, this course encapsulates the essence of ceramic mastery. By the culmination, you'll have explored the techniques, history, and intricacies of ceramic art, granting you the knowledge to mould and shape your creations with both elegance and finesse. Learning Outcomes Understand the diverse types of clay and their optimal utilisation in ceramics. Master hand-building techniques and wheel throwing to shape unique pottery. Apply surface decoration methods to add textures and distinct finishes to your pieces. Comprehend the principles of glazing, firing, and ceramic sculpture for advanced creations. Acquire knowledge on kiln operation and ensure studio safety practices. Why buy this Ceramics: Pottery & Sculpting Artistry? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Ceramics: Pottery & Sculpting Artistry there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Ceramics: Pottery & Sculpting Artistry for? Individuals passionate about exploring the world of pottery and ceramic sculpture. Art students or enthusiasts aiming to augment their skills in ceramics. Individuals looking to express their creativity through a tactile medium. Home décor enthusiasts wanting to craft custom pottery pieces. Those seeking a therapeutic and meditative art form for relaxation. Prerequisites This Ceramics: Pottery & Sculpting Artistry does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Ceramics: Pottery & Sculpting Artistry was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Ceramic Artist - Average salary range: £20,000 - £35,000 Pottery Wheel Thrower - Average salary range: £18,000 - £30,000 Glaze Technician - Average salary range: £19,000 - £32,000 Ceramic Sculptor - Average salary range: £21,000 - £36,000 Kiln Operator - Average salary range: £17,000 - £28,000 Ceramic Designer - Average salary range: £22,000 - £37,000 Course Curriculum Module 01: Introduction to Ceramics Introduction to Ceramics 00:13:00 Module 02: Types of Clay and Materials Types of Clay and Materials 00:14:00 Module 03: Hand-building Techniques Hand-building Techniques 00:15:00 Module 04: Wheel Throwing Wheel Throwing 00:13:00 Module 05: Surface Decoration and Texture Surface Decoration and Texture 00:15:00 Module 06: Glazing and Firing Glazing and Firing 00:15:00 Module 07: Ceramic Sculpture Ceramic Sculpture 00:14:00 Module 08: Ceramic Art and Design Ceramic Art and Design 00:14:00 Module 09: Kiln Operation and Studio Safety Kiln Operation and Studio Safety 00:16:00

Build your audience with professionally designed, UX-friendly apps

By completing this qualification, learners will meet industry requirements to: - Plan, deliver and evaluate Pilates reformer sessions and programmes, including: - Pilates-based group reformer sessions (6+) - One-to-one Pilates reformer sessions and programmes

Embark on a melodious journey with 'Voice Equipment Mastery: Effective Vocal Techniques', where the symphony of knowledge and technology harmoniously intertwines to elevate your vocal production skills. This course orchestrates a comprehensive exploration into the realm of voice-over equipment, ensuring that your vocal renditions are not just heard, but resonate with unparalleled clarity and impact. From the subtle whispers of an intimate narrative to the robust proclamation of an epic tale, your voice, amplified and refined through optimal equipment use, will traverse the airwaves with precision and emotion. Your expedition through the modules will guide you through the meticulous selection and utilisation of microphones, ensuring every nuance of your voice is captured with fidelity. The journey doesn't stop there; it further immerses you into the world of headphones, monitoring, and the pivotal role of audio interfaces and preamps in achieving sonic excellence. With each lesson, you'll unravel the secrets behind crafting a sound that is authentically yours, ensuring your vocal productions are both compelling and emotionally resonant. Learning Outcomes Identify and utilise optimal voice-over equipment, enhancing vocal recording quality. Implement effective microphone techniques to capture varied vocal performances. Establish a proficient studio setup, incorporating suitable acoustic treatments. Navigate voice-over software and editing tools to refine vocal recordings. Execute equipment maintenance and troubleshooting to ensure consistent audio quality. Why buy this Voice Equipment Mastery: Effective Vocal Techniques? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Voice Equipment Mastery: Effective Vocal Techniques for? Aspiring voice-over artists seeking technical mastery in vocal recording. Audio engineers desiring a focused understanding of vocal recording equipment. Podcasters looking to elevate the quality of their vocal productions. Narrators wishing to enhance the clarity and impact of their storytelling. Vocalists aiming to independently record and produce their performances. Career path Voice-Over Artist: £20,000 - £80,000 Audio Engineer: £25,000 - £50,000 Podcast Producer: £20,000 - £40,000 Audiobook Narrator: £20,000 - £45,000 Sound Designer: £25,000 - £55,000 Recording Engineer: £20,000 - £50,000 Prerequisites This Voice Equipment Mastery: Effective Vocal Techniques does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 1: Introduction to Voice Over Equipment Introduction to Voice Over Equipment 00:17:00 Module 2: Microphones for Voice Over Microphones for Voice Over 00:21:00 Module 3: Headphones and Monitoring Headphones and Monitoring 00:22:00 Module 4: Audio Interfaces and Preamps Audio Interfaces and Preamps 00:23:00 Module 5: Acoustic Treatment and Studio Setup Acoustic Treatment and Studio Setup 00:23:00 Module 6: Voice Over Software and Editing Tools Voice Over Software and Editing Tools 00:22:00 Module 7: Equipment Maintenance and Troubleshooting Equipment Maintenance and Troubleshooting 00:22:00