20746 Other courses

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.

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included

Work Breakdown Structures: In-House Training It's amazing how often project managers begin the project planning process by making an outlined list of every task they believe will be required to complete a project and then proclaim they have created the work breakdown structure (WBS) for the project. The result is a list of hundreds, or even thousands of tasks, many of them having durations of a few days or a few hours. Essentially, what they have done is create a 'to do' list, which they then use as a 'checklist' to measure progress. This approach leads to, and even encourages, micromanagement of the resources working on the project without consideration of more critical aspects of project management such as: requirements management, risk management, procurement management, estimating, scheduling, executing, and controlling. Further, it makes it impossible to see the big picture, at levels of detail, in keeping with the needs of sponsors, clients, project and functional managers, team leaders, and project performers. Join us for this exciting program and learn how to use the WBS to make better-informed business decisions. What You Will Learn You will learn how to: Describe the need for a project WBS Describe the WBS role in the project Gain practical experience in the development, decomposition, and use of the WBS Determine the appropriate level of detail in the WBS. Explain how the WBS integrates with project requirements, risk, procurement, estimating, scheduling, and overall project execution. Provide the basic tools to enhance efficient re-use of key information in your future projects Foundation Concepts Key definitions History of the WBS Importance of the WBS Overall structure Terminology Other breakdown structures WBS tools WBS & Scope Project scope management processes Specification of the project objectives WBS design based on project deliverable WBS decomposition process and 'The 100% rule' Work Packages and Control Accounts WBS & Risk Risk management planning and WBS Risk identification to enhance the WBS Risk analysis and the WBS Risk responses and updating the WBS Implementing risk response and Monitoring risks and the WBS WBS & Estimating Use of WBS in the estimating process Components and work packages Sizing and algorithmic estimates WBS & Scheduling Component Scheduling - High-Level Milestones WBS activity decomposition WBS elements dependencies Work Package Level Schedules Responsibility assignment matrix WBS & Execution and Control Earned Value Management and tracking of work performance Progress reports, forecasts, and corrective and preventive actions used to manage work performance Necessary information to close out a project

Level 3 Assessor course formerly known as A1 TAQA course. Learn More Academy provides all level of Assessor courses in England, Wales and Scotland. This courses was formerly known as TAQA course and this qualification is intended for those who wish to gain an understanding of the principles and practices of assessment without any requirement to practice as assessors. COURSE AIM: This Understanding level consist of: Unit 1: Understanding the principles and practices of assessment D/601/5313 The aim of this unit is to assess the learning and development practitioner’s knowledge and understanding of the principles and practices of assessment. ‘Practitioner’ means anyone with a learning and development responsibility as the whole or a part of their role. Course Outline: • Understanding the legal and good practice in relation to assessment • Developing plans for assessing competence with candidates • Contributing to the internal quality assurance processes • Understanding the principles and practices of assessment • Assessing candidates against agreed learning outcomes • Judging evidence against agreed standards to make assessment decisions • Using a variety of assessment methods • Giving candidates feedback and support on your assessment decisions • Working with other people involved in the assessment process, such as workplace supervisors and other teachers or trainers ENTRY REQUIREMENT: There are no formal requirements for Level 3 Award in Understanding the Principles and Practices of Assessment (TAQA) course, however, candidates should be working in, or working towards a role in quality assurance. COURSE ASSESSMENT: There is no formal examination is required, but at the end of the course you need to submit a portfolio assignment. HOW MUCH THIS COURSE COST? Level 3 Award in Understanding the Principles and Practices of Assessment (TAQA) course will cost for Online Distance Learning £249.99, for Webinar Classroom based course £279.99. There is no any hidden fess/cost.

https://www.transmedia.co.uk/course/figma-introduction Figma is a web-based, graphics editing and user interface design app. You can use it to do all kinds of graphic design work, from wireframing websites, to designing mobile app interfaces, prototyping designs and crafting social media posts. Our two-day course starts with design basics such as typography, colour contrast, fonts, spacing, and more. Then we move on to show you the Figma toolset and how to use it to create text, add images, UI elements, and so on. During the course you will begin working with colours and styles and discover how to add other elements, such as slide-out menus. By the end, you'll be able to create professional mockups and turn your designs into interactive prototypes. All our Figma courses are taught by industry professionals who will share years of their industry experience with you, imparting best practice techniques as well mastery of the tools. Topics covered include Introduction to Figma, Exploring a Figma document, Designing and prototyping, Time-saving techniques and Exporting and sharing designs.

In times of crisis, people are in reaction mode. They work more from “fight vs. flight” than by using reason. When we serve these customers, we need to respond appropriately and help them to achieve emotional control so that we can work to solve problems. In this interactive online class, you will learn the tools needed to get yourself in emotional control. You will also learn why people react on emotion and tools to help them get back in control, too. Attendees will be able to: Focus on others to project a UB4ME, customer-centered attitude; Empower people with respect (acknowledging) and control (offering choices); and Understand customers better and develop emotionally-intelligent methods for managing their fears and reactions. Register for this class and you will be sent ONLINE login instructions prior to the class date.

This one-day course introduces the field of user experience and provides an excellent entry point to our other specialised training courses. UX processes and practices have become a central component of product design, service design and web design.

A simple pattern drafting course for anyone wanting to learn how to make their own blocks from scratch - great for teachers of GCSE & A Level Fashion & Textiles for both Art & Design and D&T.

Much of what you achieve will depend on your ability to persuade other people. In many respects, persuasion is the highest form of communication. This course looks at the ability of persuasion and negotiation in producing successful outcomes and the skill required in moving towards a convergence of opinion and understanding. Like much of leadership, negotiation depends on your attitudes in approach, as well as your ability to devote time to planning.

Proven to be effective and to improve the prospects of quiet, shy, self-conscious and introverted people. Would you love to Express Yourself and let the real you out? Want to play more in life – and have a whole lot more fun? Want to overcome your fear of performing in front of groups In this unique one-day self-confidence workshop you will be discovering the keys to an authentic confidence and how to exude the kind of magic and passion for life that enables you to look and feel good. The workshop provides a context to express yourself in a safe environment with other people who feel in the same boat as you, and are 100% committed in supporting you in making breakthroughs in the area of self-expression, confidence and overcoming your fears of performing/speaking in front of others. This helps to counteract the effects of having your confidence undermined in the past.