37235 Design courses delivered Online

Writing and Managing Requirements Documents - Creating the Acceptable, Approvable Requirements Document: On-Demand This course will enhance the skill set needed for writing and managing the complex readership that business analysts interact with on a day-to-day basis. What You Will Learn Upon Completion, participants will be able to: Write an understood requirements document that is approvable and acceptable Validate a requirements document Manage the changes to requirements documents through the SDLC Foundation Concepts The role of the business analyst An introduction to the BABOK® Guide The business analyst and the product/project life cycle The requirements documentation process Planning for Effective Requirements Documentation Overview of requirements planning Planning for validation Planning for verification: well-formed criteria Planning for verification: understood and usable criteria Writing Effective Requirements Documents Overview of writing requirements documents Using a standard structure / template Applying formatting techniques Meeting the challenge of writing non-functional requirements Baselining Requirements Documents Overview of the requirements baseline process Validation Verification Approval Managing Requirements Change through the Product Life Cycle Overview of requirements change management Establishing a formal change management process Tracing requirements through design and development (build, test, and implementation) Following through to post-implementation (transition and early production) Summary What did we learn, and how can we implement this in our work environments?

Get ready to dive into the exciting world of Unity game development and C# scripting! With a hands-on approach, you will craft a variety of thrilling 2D and 3D games using Unity and C#. Uncover the art of building and exporting games to the Android mobile platform. This course is tailor-made for someone who wants to learn Unity and C# through real-world projects.

Successful communications are all about making the message as simple as possible – but this can be difficult when the subjects we're talking about are inherently complicated.  Academic institutions, tech companies, health organisations, charities and many others have complex ideas, processes and systems at the heart of what they do.  This course is for anybody who needs to distill information down into key messages for important stakeholders, funders and investors, decision makers and members of the public.  You’ll learn proven techniques for grabbing attention and changing minds through presentations and public speaking, infographics and data visualisations, and written reports and online posts.  We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve. Sample learning content Session 1: Understanding your audience Matching your objectives to your audience's motivations. Identifying the right tone and language. Understanding how, where and when your audience wants to be spoken to. Session 2: Refining your objectives  Breaking down strategic aims into tactical steps Metrics and milestones: defining and measuring progress and success. Rapidly building a brief for your communications. Session 3: Telling the story  Using metaphors, visuals, comparisons to frame your narrative. From slide decks to online campaigns - choosing the right formats for delivering your message. Selecting communications channels to maximise reach and impact. Session 4: Keeping it going  Processes and systems for launching and maintaining communications campaigns. Building social proof – creating and curating content. Troubleshooting and preparing for common challenges. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “We’ve now worked with Alan for almost 3 years, and during that time he has continued to deliver the highest quality training for our clients and delegates. Alan’s passionate delivery style has continued to deliver innovative training solutions to over 1500 delegates across the public, private and voluntary sector. Each of our courses with him has always delivered exceptional feedback and satisfaction levels.” Joe Barlow | Head of Programme, Understanding ModernGov

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.

This bundle will transform your approach to the inclusion of autistic children with all of our most effective course modules

Description: This course design targets individuals who are willing to learn in detail about video and light production and also the people with no prior experience. In this course, students will know about different technical aspects of video making like audio production, camera operation, cameras and lighting and production management. Students joining this course will know in detail about skills required to operate a camera, recording sounds etc. Who is the course for? Beginners free lancer videographer production assistant Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Production Assistant Assistant camera operators film or video editor video equipment technician freelancer videographer boom operation. Diploma in Web Video Production Introduction 00:30:00 What You Can Use Video Production For 00:30:00 What You Will Need 00:30:00 Video Production Without Hardware 01:00:00 Planning and Pre-Production 01:00:00 Creating A Script 01:00:00 Filming and Production 01:00:00 Editing 01:00:00 Closing Notes 00:15:00 Mock Exam Mock Exam- Diploma in Web Video Production 00:20:00 Final Exam Final Exam- Diploma in Web Video Production 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Architecture is the art and science of designing and building structures. It is a complex and ever-evolving field that encompasses a wide range of topics, from the history of architecture to the latest building technologies. The course covers a wide range of topics, including the history of architecture, architectural styles, interior design, and lighting design. Learning outcomes of Architecture Bundle: Understand the history and development of architecture Identify and describe different architectural styles Apply principles of interior design Use lighting to create different atmospheres Understand the relationship between architecture and society Analyze architectural drawings and plans Create architectural drawings and plans Communicate effectively about architecture This Architecture Bundle Consists of the following Premium courses: Course 01: Architectural Studies Course 02: AutoCAD VBA Programming - Beginner course Course 03: Mastering Colour-Architectural Design & Interior Decoration Course 04: Revit Architecture Ultimate Interior Design Course Course 05: Revit Architecture Ultimate Exterior Design for Beginners Course 06: Revit Architecture Advanced Exterior Design Course Course 07: Autodesk Revit: Modeling & Rendering Course 08: WELL Building Standard Course 09: LEED V4: Building Design and Construction Course 10: Building Surveyor Course 11: Construction Industry Scheme (CIS) Enroll in the Architecture bundle course today and learn more about the art and science of designing buildings and structures! The Architecture bundle course is an introduction to the art and science of architecture. The course covers a wide range of topics, from the history of architecture to the principles of design. You will learn about different architectural styles, from ancient to modern, and will gain an understanding of the factors that influence architectural design. You will also learn about interior design, including the principles of colour theory and lighting design. The curriculum of Architecture Bundle Course 01: Architectural Studies Introduction Ancient Architecture Architectural Ideas and Movements Architectural Styles Art Deco Architectural Style Scandinavian Architectural Style Victorian Architectural Style Classical and Early Christian Architectural Style Gothic Architectural Style Baroque and Rococo Architectural Style Eclecticism Architectural Style Modern and Post-Modern Architectural Style Interior Designing Colour in Interior Designing Lighting in Interior Design Part One Lighting in Interior Design Part Two Course 02: AutoCAD VBA Programming - Beginner course Introduction VBA Integrated Development Environment (IDE) Understanding AutoCAD Object Model in VBA Using Variables in VBA User Forms and Controls Conditionals and Decisions in VBA Looping and Iterations in VBA Drawings Objects in VBA Code Debugging in VBA Error Handling in VBA Conclusion Course 03: Mastering Colour-Architectural Design & Interior Decoration Introduction The Impact of Fashion and Colour Trends Colour Terminology Colour Basics and Neutral Colours Warm vs. Cool Colours Colour Schemes Colour Ratios and Applications Using Colour to Trick the Eye Conclusion ===> And 8 More Courses <=== How will I get my Certificate? After successfully completing the Architecture bundle course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) PS The delivery charge inside the UK is £3.99, and international students have to pay £9.99. Enroll in the Architecture Bundle course today and learn about the art and science of designing buildings and structures! CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Students who are interested in learning about architecture Professionals who want to brush up on their architectural knowledge Anyone who is curious about the history and development of architecture People who want to develop their critical thinking and problem-solving skills Those who want to pursue a career in architecture, design, or construction Requirements This Architecture course has been designed to be fully compatible with tablets and smartphones. Career path Having this Architecture bundle course will increase the value of your CV and open you up to multiple job sectors. Architect: £25,000 - £75,000 Interior designer: £20,000 - £50,000 Lighting designer: £20,000 - £40,000 Construction manager: £30,000 - £60,000 Urban planner: £25,000 - £50,000 Historic preservationist: £20,000 - £40,000 Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Architectural Studies) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Unleash your creativity with our Adobe After Effects CC course. Master the art of motion graphics and visual effects to create stunning visuals that captivate your audience. Enhance your design skills and bring your ideas to life!

Learn to weave, 'off-loom' with Sarah Ward, via Zoom

Learn to weave, 'off-loom' with Sarah Ward, via Zoom