Courses

Become a certified UI designer Learn how to create beautiful, pixel-perfect user interfaces Accelerate your career with an in-demand skillset Get a professional qualification in just 12 weeks Manage your own schedule with our flexible, self-paced online course Expand your career options UI skills are needed worldwide, and demand is growing. With a globally recognised qualification, you’ll become a more valuable, sought-after professional. Design with confidence You’ll understand the ‘why’ of good UI design by knowing the principles behind it. You’ll be able to defend your decisions and design with confidence. Work in a creative, rewarding job UI designers add personality and visual appeal to user interfaces. It’s an enjoyable career that rewards creativity: the perfect entry into tech for visually-minded people. A flexible, university-backed curriculum Our curriculum is university credit-rated and approved by the industry. Over 12 weeks, you’ll learn the principles and skills you need to become a confident UI designer. Study method Online, self-paced Duration 12 weeks Access to content 12 months Qualification Professional Certificate in UI Design Awarded by Scottish Qualifications Authority trading as SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description During this 12 week, online course you will learn: Introduction to UI Design Brand and Personality Layout Design Principles Interactivity Typography Colour, shapes and effects Iconography and imagery Design process Presenting ideas UI design tools You will also work on a project and your portfolio with access to weekly mentor sessions, an active student community, and support from our student success team. Who is this course for? Graphic designers and digital designers who want to upskill to UI design UI designers who want to strengthen their knowledge and craft UX professionals who want to become more rounded product designers Anybody with a design background looking for a creative job in tech Requirements You don’t need experience in design or technology to enrol in our courses, although having one or both is a definite bonus. Our students come from a diverse mix of backgrounds, including project management, development, graphic design, product management, business analysis and so on. You need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. You need to be comfortable learning in English. All video lessons, course materials, webinars, correspondence and the final exam are delivered in English. Career path Students typically graduate into UI Designer jobs. The average UI Designer salary in the UK with 3-5 years experience is £62,500. This is based on data from Payscale, Totaljobs, Indeed, Talent, and Glassdoor

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.

Business Analysis Fundamentals: In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals to pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP™). This course teaches participants the overall process of business analysis and where it fits in the bigger picture of the project life cycle and the business context. The course is interactive and combines discussion, active workshops, and demonstrations of techniques. The goal is bottom-line results that cut through the real-world problems facing people seeking to improve the way they operate to develop new and improved systems and products or otherwise deliver results through project performance. What you will Learn At the end of this program, you will be able to: Define the solution scope Work with the development team in the systems testing stage Ensure the solution is usable in the business environment Foundation Concepts Defining the business analyst (BA) function The role of the BA as change agent An introduction to the BABOK® Guide BA roles and relationships through the project life cycle (PLC) Business Analysis Planning and Monitoring Overview of business analysis planning and monitoring (BAP&M) Business analysis planning and monitoring - process and tools Business analysis planning and monitoring - roles and responsibilities Business analysis planning and monitoring - governance, information management, and performance improvement Elicitation and Collaboration Overview of elicitation and collaboration Elicitation and collaboration techniques Requirements Life Cycle Management Overview of requirements life cycle management Requirements life cycle management task details Strategy Analysis Overview of strategy analysis Analyze current state Define future state Assess risks Define change strategy Requirements Analysis and Design Definition Overview of requirements analysis and design definition (RA&DD) The anatomy of requirements RA&DD task descriptions RA&DD techniques Solution Evaluation Overview of solution evaluation Solution evaluation tasks Solution evaluation in development stages Underlying Competencies Overview of underlying competencies (UC) Underlying competencies

Duco Digital Training's BCS Foundation Certificate in Business Analysis has been designed to provide learners with knowledge and understanding of business analysis concepts, principles and techniques for roles such as business a analyst.

The BCS Foundation Certificate in Business Analysis is a foundation- level certification that provides a broad understanding of business analysis principles and techniques. It is offered by the British Computer Society (BCS), a professional association for IT professionals.

Business Analysis Fundamentals: Virtual In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals to pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP™). This course teaches participants the overall process of business analysis and where it fits in the bigger picture of the project life cycle and the business context. The course is interactive and combines discussion, active workshops, and demonstrations of techniques. The goal is bottom-line results that cut through the real-world problems facing people seeking to improve the way they operate to develop new and improved systems and products or otherwise deliver results through project performance. What you will Learn At the end of this program, you will be able to: Define the solution scope Work with the development team in the systems testing stage Ensure the solution is usable in the business environment Foundation Concepts Defining the business analyst (BA) function The role of the BA as change agent An introduction to the BABOK® Guide BA roles and relationships through the project life cycle (PLC) Business Analysis Planning and Monitoring Overview of business analysis planning and monitoring (BAP&M) Business analysis planning and monitoring - process and tools Business analysis planning and monitoring - roles and responsibilities Business analysis planning and monitoring - governance, information management, and performance improvement Elicitation and Collaboration Overview of elicitation and collaboration Elicitation and collaboration techniques Requirements Life Cycle Management Overview of requirements life cycle management Requirements life cycle management task details Strategy Analysis Overview of strategy analysis Analyze current state Define future state Assess risks Define change strategy Requirements Analysis and Design Definition Overview of requirements analysis and design definition (RA&DD) The anatomy of requirements RA&DD task descriptions RA&DD techniques Solution Evaluation Overview of solution evaluation Solution evaluation tasks Solution evaluation in development stages Underlying Competencies Overview of underlying competencies (UC) Underlying competencies

Free Level 7 QLS Endorsed Certificate | CPD Accredited | 150 CPD Points | Advanced Learning Materials | Lifetime Access

The BCS Foundation Certificate in Business Analysis is a foundation- level certification that provides a broad understanding of business analysis principles and techniques. It is offered by the British Computer Society (BCS), a professional association for IT professionals.

Business Analysis Overview Do you ever wonder how businesses bring amazing ideas to life? Imagine being the secret weapon that turns those ideas into reality! This Business Analysis course is your key to becoming a game-changer in any organization. In plain English, business analysts are the superheroes who take a business idea and figure out exactly how to make it happen. This course gives you all the tools you need to join this exciting field. Through clear explanations and exercises you'll learn the steps involved in bringing a business idea to life, from start to finish. You'll discover how to identify the best solutions and make sure everything gets done on time and on budget. You'll also learn how to talk to everyone involved in the project, from the big boss to the team members, to keep everyone happy and moving in the right direction. This Business Analysis course is your chance to learn the skills that businesses are looking for and launch a successful career as a problem-solving rockstar! Learning Outcomes Gain a comprehensive understanding of the core phases of business analysis, from eliciting stakeholder requirements to evaluating solutions and monitoring project progress. Develop proficiency in key investigative techniques, ratio analysis, and gap analysis to diagnose problems and identify opportunities for improvement. Refine your communication and interpersonal skills to effectively manage stakeholder expectations, gather crucial information, and foster collaboration throughout the project lifecycle. Learn to document business requirements clearly and concisely using industry-standard practices, ensuring project deliverables meet strategic objectives. Explore the diverse career opportunities available to business analysts in the UK and gain insights into the skills and qualifications sought after by employers. Why You Should Choose Business Analysis Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Business Analysis is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Business Analysis is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Business Analysis Module 01: Introduction to Business Analysis Introduction to Business Analysis 00:14:00 Module 02: Business Processes Business Processes 00:44:00 Module 03: Business Analysis Planning and Monitoring Business Analysis Planning and Monitoring 00:25:00 Module 04: Strategic Analysis and Product Scope Strategic Analysis and Product Scope 00:28:00 Module 05: Solution Evaluation Solution Evaluation 00:24:00 Module 06: Investigation Techniques Investigation Techniques 00:45:00 Module 07: Ratio Analysis Module 08: Stakeholder Analysis and Management Stakeholder Analysis and Management 00:22:00 Module 09: Process Improvement with Gap Analysis Process Improvement with Gap Analysis 00:25:00 Module 10: Documenting and Managing Requirements Documenting and Managing Requirements 00:26:00 Module 11: Career Prospect as a Business Analyst in the UK Career Prospect as a Business Analyst in the UK 00:13:00

Overview Objective Understanding the Importance of Business Analysis Model Determining various techniques of Process Modelling Understanding the scope of modelling Efficiently mapping the business landscape Analysing the enterprise structure How to avoid project failures. Learning efficient skills of being a successful business analyst. Understand and document various techniques for the organization delivers value. Successful project conversion Building team, changing the organization and overcoming resistance. Creating an effective Business Case.