2788 Intelligence courses delivered Online

Emotional intelligence is an aspect of you as a whole person affecting your work life and your personal life. Your emotional intelligence is your ability to combine your thinking with your feelings in order to build good quality relationships and to make good authentic decisions. Join me for 21 days of exploration through audio lessons, videos, interactive quizzes and practical activities that help you gain insights into emotional intelligence that will build and grow your emotional intelligence.

Thinking about learning more about Artificial Intelligence? The BCS Foundation Certificate in Artificial Intelligence is the advanced version of our Essentials Course Artificial Intelligence and includes more detail and insights about algebraic equations, vector calculus and schematics used in artificial intelligence and machine learning for you to learn how this new technology works.

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.

Not everyone is born with it, but unlike IQ, Emotional Intelligence can be acquired and improved with practice.

The BCS Essentials Certificate in Artificial Intelligence teaches the general principles of Artificial Intelligence, an introduction to Machine Learning and understand it's potential implications and capabilities. You will learn about human and artificial intelligence, the machine learning process, the different types of agents, the types of machine learning, the benefits, challenges and risks of a machine learning project, ethics in AI and the future of humans and machines in work. This is a great course for any person or organisation who needs to gain familiarity about Artificial Intelligence and Machine Learning before they commence a project; helping ensure the project approach is correct and avoid the common and costly pitfalls of technology projects.

11 in 1 "Business Intelligence" Bundle only at £53 Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Business Intelligence bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Business Intelligence bundle will help you stay ahead of the pack. Throughout the Business Intelligence programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Business Intelligence course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Business Intelligence Bundle Consists of the following Premium courses: Course 01: Business Intelligence and Data Mining Masterclass Course 02: Financial Analysis Course 03: Introduction to Data Analysis Course 04: SAP Controlling (CO) - Product Costing S4HANA Course 05: Basic Business Finance Course 06: Statistics Essentials Course 07: Strategic Business Management Course 08: Data Protection and Data Security Level 2 Course 09: Document Control Course 10: GDPR Course 11: Applied Economics Enrol now in Business Intelligence to advance your career, and use the premium study materials from Apex Learning. How will I get my Certificate? After successfully completing the 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Business Intelligence expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum of Bundle Course 01: Business Intelligence and Data Mining Masterclass Module 01: What is Business Intelligence? Module 02: Starting Case in understanding BI needs in diff phase of business Module 03: Decision Making Process and Need of IT systems Module 04: Problem Structure and Decision Support System Module 05: Introduction to BI Applications Module 06: Dashboard presentation systems Module 07: Different Types of Charts used in 131 Dashboards Module 08: Good Dashboard and BSC Module 09: Examples of Bad Dashboards 1 Module 10: Examples of Bad Dashboards 2 Module 11: Process of KPI Development Module 12: Overview of Data warehouse Module 13: More explaining of data warehouse and steps in processing Module 14: Data Warehouse Architecture -Tiers Module 15: Data Warehouse - components Module 16: Approach to develop data structure and Models of database Module 17: Basics of Data Mining - Meaning Module 18: Basics of Data Mining - Stages of DM Module 19: Data Mining Technique - Classification Module 20: Data mining - Clustering Module 21: Data Mining - Association Rules Module 22: Data Mining Applications - Banking Module 23: Data Mining Applications - CRM Module 24: Data Mining Applications - other industries CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Business Intelligence bundle. Requirements This course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. 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 Business Intelligence and Data Mining Masterclass 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.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

Learn the principles of emotional intelligence about how your emotions influence the way you understand yourself, how you build relationships, how you manage stress and how you make decisions. We all have emotions! You will need an open mind and a willingness to learn about how to positively embrace working with your intelligence and your emotions. You should be committed to developing your ability to manage the emotional dimensions of life.

On this course, we will use case studies to enhance the delegates understanding of Real Estate financial appraisals, and help them fully appreciate the theory behind the numbers.

This highly practical course is unusual because it considers emotional intelligence as a fundamental part of selling. The course doesn't cover prospecting and ways to get a sales appointment, these require the use of emotional intelligence in other ways! The course covers the way that you engage with customers before, during and after a sales meeting through the application of emotional intelligence to make authentic decisions and build quality relationships. The course provides a step-by-step approach to applying emotional intelligence principles to your sales process focusing on working with the emotions of your customer and how these influence their social interactions.