3934 Analyst courses delivered Online

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 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 three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 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 Module 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 Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 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 Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 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 Additional course details: Nexus Humans 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 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.

The course will cover several topics related to project management, including project execution strategies, the four P's of project strategy execution, project execution steps, organization breakdown structure (OBS), project organizational charts, project stakeholders, RACI, RACI matrices, RACI guidelines, role confusion in RACI Matrix, statement of work (SOW) in project management, usage, and the components of a statement of work in project management. By the end of the course, students should be able to understand and apply these concepts effectively in managing projects. This course provides a comprehensive understanding of project management, focusing on project execution strategies, steps, and organizational structures. Participants will learn about the four P's of project strategy execution, the organization breakdown structure, and project organizational charts. The course also covers project stakeholders, RACI matrices and guidelines, and the statement of work in project management, including its usage and components. By the end of the course, students will have gained knowledge of these essential project management concepts and be able to apply them effectively in managing projects. The course will provide practical examples and case studies to enhance learners' understanding of the material. Following main topics will be discuss in this course;  Project Execution Strategies: Four P's of Project Strategy Execution, Project Execution Steps. Organization Breakdown Structure (OBS) as a Function of Project ManagementMeasures and Steps of OBS, Types of OBS, Project Organizational Charts. Project Stakeholders: Identification of Project Stakeholders, Role of Stakeholders in Project Management, Strategies to Manage Stakeholders. RACITypes of RACI, RACI Matrices, RACI Guidelines, Role Confusion in RACI Matrix. Statement of Work (SOW) in Project Management: Usage of SOW, Components of SOW, Importance of SOW in Project Management. This course provides a comprehensive understanding of project management, focusing on project execution strategies, steps, and organizational structures. Participants will learn about the four P's of project strategy execution, the organization breakdown structure, and project organizational charts. The course also covers project stakeholders, RACI matrices and guidelines, and the statement of work in project management, including its usage and components. By the end of the course, students will have gained knowledge of these essential project management concepts and be able to apply them effectively in managing projects. The course will provide practical examples and case studies to enhance learners' understanding of the material. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Project Execution Strategies Self-paced pre-recorded learning content on this topic. Project Execution Strategies Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Project Managers Project Coordinators Project Analysts Business Analysts Team Leaders Department Managers Executives overseeing projects Consultants Engineers IT Professionals Marketing Managers Human Resources Managers Financial Analysts Operations Managers Supply Chain Managers Product Managers. Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Agile Scrum is a highly effective approach for managing and successfully completing even the most complex projects. In this course, you will learn how to train and coach your product owner using Agile Scrum techniques and understand the difference between a traditional project manager and a Scrum Master. No prior experience is required to take this course.

The course helps you learn Snowflake from scratch and explore a few of its important features. You will build automated pipelines with Snowflake and use the AWS cloud with Snowflake as a data warehouse. You will also explore Snowpark to be worked on the data pipelines.

Limited Time Offer On | 11-in-1 Bundle | CPD QS Certified | 110 CPD Points | Gifts: Hardcopy + PDF Certificates + Transcript + SID - Worth 180 | Customer Support | Lifetime Access | Enrol Today

The course is designed to provide participants with an in-depth understanding of contract and quality management in project management. Participants will learn the different stages of contract management and its benefits, types of contracts and contract terms, project document control, project baselines, quality management concepts, quality management tools and techniques, and the concept of total quality management and quality chain. The course will also cover the use of project milestone chart in project management. This course provides participants with a comprehensive understanding of contract and quality management in project management. Participants will also learn about project document control, project baselines, quality management concepts, quality management tools and techniques, and the concept of total quality management and quality chain. By the end of the course, learners will be equipped with the knowledge and skills to effectively manage contracts and ensure quality in project management. After the successful completion of the course, you will be able to learn about the following; Defining the concept, stages, and benefits of contract management in project management. Learning the types of contracts and Contract terms in project management. Understanding the concept of project document control. Understanding the concept of Project Baselines. Learning the concept and process of quality management in project management. Understanding the Quality management tools and techniques. Defining the concept of total quality management and quality chain. Understanding Project milestone chart. This course provides participants with a comprehensive understanding of contract and quality management in project management. It covers the different stages of contract management and its benefits, types of contracts, and contract terms. Participants will also learn about project document control, project baselines, quality management concepts, quality management tools and techniques, and the concept of total quality management and quality chain. The course will also cover the use of a project milestone chart in project management. By the end of the course, learners will be equipped with the knowledge and skills to effectively manage contracts and ensure quality in project management. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Project Documentation and Quality Control Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. Project Documentation and Quality Control Self-paced pre-recorded learning content on this topic. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Project Managers Project Coordinators Project Analysts Business Analysts Team Leaders Department Managers Executives overseeing projects Consultants Engineers IT Professionals Marketing Managers Human Resources Managers Financial Analysts Operations Managers Supply Chain Managers Product Managers. Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

This Professional Certificate Course in Requirements Analysis and Specification provides a comprehensive overview of the importance of analyzing requirements for completeness and accuracy. Participants will learn to employ tools like Use Case Modeling and Data Flow Diagramming, distinguishing between functional and non-functional requirements. The course also emphasizes the significance of prioritizing requirements and defining acceptance criteria for effective project management and successful system development. After the successful completion of the course, you will be able to learn about the following: Discuss the importance of analyzing requirements to ensure completeness and accuracy Explain how to use tools such as Use Case Modeling and Data Flow Diagramming to analyze requirements Understand the difference between functional and non-functional requirements Explain the importance of prioritizing requirements and defining acceptance criteria This Professional Certificate Course in Requirements Analysis and Specification offers a comprehensive understanding of analyzing requirements for completeness and accuracy. Participants will learn to employ tools like Use Case Modeling and Data Flow Diagramming, distinguish between functional and non-functional requirements, and prioritize requirements while defining acceptance criteria. This Professional Certificate Course in Requirements Analysis and Specification provides a comprehensive understanding of analyzing requirements for completeness and accuracy. Participants will learn to utilize tools like Use Case Modeling and Data Flow Diagramming, distinguish between functional and non-functional requirements, and grasp the significance of prioritizing requirements while defining robust acceptance criteria. Gain invaluable skills to enhance your proficiency in effective requirements analysis and specification. Course Structure and Assessment Guidelines Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Requirements Analysis and Specification Self-paced pre-recorded learning content on this topic. Requirements Analysis And Specification Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience, Business Analysts Project Managers Systems Analysts Software Developers Quality Assurance Professionals Product Managers IT Managers Requirements Engineers Solution Architects Anyone Involved in Software Development or Project Management Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Duration 3 Days 18 CPD hours This course is intended for This course is aimed at anyone who wants to harness the power of data analytics in their organization. Overview After completing this course delegates will be capable of writing effective R code to manipulate, analyse and visualise data to enable their organisations make better, data-driven decisions. This course teaches delegates with no prior programming or data analytics experience how to perform data manipulation, data analysis and data visualisation in R. Course Outline Becoming a world class data analytics practitioner requires mastery of the most sophisticated data analytics tools. The R programming language is one of the most powerful and flexible tools in the data analytics toolkit. This course teaches delegates with no prior programming or data analytics experience how to perform data manipulation, data analysis and data visualisation in R. Mastery of these techniques will allow delegates to immediately add value in their work place by extracting valuable insight from company data to allow better, data-driven decisions. The course will explore the following topics through a series of interactive workshop sessions: What is R? Basic R programming conventions Data structures in R Accessing data in R Descriptive statistics in R Statistical analysis in R Data manipulation in R Data visualisation in R Additional course details: Nexus Humans Beginning Data Analytics With R 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 Beginning Data Analytics With R 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 course provides an overview of conflict and crisis management in project management. Participants will learn about the nature, features, and causes of conflict, as well as the contributing factors and types of project conflicts. The course will also cover conflict management, conflict resolution approaches, and strategies for managing conflict in project management. In addition, the course will explore crisis management, including types of project crises, elements and stages of crisis management, and principles for leading through crisis. Participants will also learn about crisis management tools and their application in project management. This course provides a comprehensive understanding of conflict and crisis management in project management. Participants will learn about the nature, features, and causes of conflict, as well as the contributing factors and types of project conflicts. By the end of the course, learners will be equipped with the knowledge and skills to effectively manage conflicts and crises in project management. After the successful completion of the course, you will be able to learn about the following; Nature, features, and causes of Conflict. Contributing factors and types of Project Conflicts. What is Conflict Management? Conflict Resolution Approaches and the Role of the Project Manager. Conflict Resolution Strategies in project management. What Is Crisis Management? Types of Project Crisis. Elements and stages of Crisis M Five Principles for Leading Through Crisis. Crisis Management Tools. This course provides a comprehensive understanding of conflict and crisis management in project management. Participants will learn about the nature, features, and causes of conflict, as well as the contributing factors and types of project conflicts. The course will cover conflict management, conflict resolution approaches, and strategies for managing conflict in project management. In addition, the course will explore crisis management, including types of project crises, elements and stages of crisis management, and principles for leading through crisis. Participants will also learn about crisis management tools and their application in project management. By the end of the course, learners will be equipped with the knowledge and skills to effectively manage conflicts and crises in project management. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Conflict and Crisis Management in Projects Self-paced pre-recorded learning content on this topic. Conflict and Crisis Management in Projects Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Project Managers Project Coordinators Project Analysts Business Analysts Team Leaders Department Managers Executives overseeing projects Consultants Engineers IT Professionals Marketing Managers Human Resources Managers Financial Analysts Operations Managers Supply Chain Managers Product Managers. Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

The aim of the course is to provide learners with an understanding of the fundamental principles and techniques of financial management in the context of health and social care. Specifically, the course will focus on the concepts of double-entry bookkeeping, investment appraisal, and cash flow forecasting. After the successful completion of the course, you will be able to learn the following: The Concept, Characteristics, and Principles of Double-Entry Book-keeping. The Double-entry Bookkeeping Process. The Concepts of Investment Appraisal and its Techniques. The Investment Analysis Techniques. The Concept and Types of Cash Flow Forecasting. This course covers the concepts, principles, and techniques of double-entry bookkeeping, investment appraisal, and cash flow forecasting. It includes an in-depth exploration of the double-entry bookkeeping process, investment analysis techniques, and types of cash flow forecasting. The course aims to equip learners with the necessary skills to document and analyze financial information accurately and effectively. Upon completion of the course, learners will be able to apply double-entry bookkeeping principles, conduct investment appraisals, and prepare cash flow forecasts. The course is designed for individuals who are interested in pursuing a career in finance or accounting within the healthcare industry. This course covers the concepts, principles, and techniques of double-entry bookkeeping, investment appraisal, and cash flow forecasting. It includes an in-depth exploration of the double-entry bookkeeping process, investment analysis techniques, and types of cash flow forecasting. The course aims to equip learners with the necessary skills to document and analyze financial information accurately and effectively. Upon completion of the course, learners will be able to apply double-entry bookkeeping principles, conduct investment appraisals, and prepare cash flow forecasts. The course is designed for individuals who are interested in pursuing a career in finance or accounting within the healthcare industry. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Documenting and Analysing Financial Information - N Self-paced pre-recorded learning content on this topic. Documenting and Analysing Financial Information Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Health and Social Care Managers Finance Managers in Health and Social Care Healthcare Policy Analysts Healthcare Consultants Health Promotion Specialists Public Health Officials Health Economists Healthcare Data Analysts Medical Social Workers Healthcare Quality Assurance Specialists Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.