136 Business Data Analysis 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 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.

Duration 4 Days 24 CPD hours This course is intended for A Dynamics 365 Business Central core Functional Consultant is responsible for implementing core application setup processes for small and medium businesses. Overview Understand use cases for Business Central modules Set up Business Central Configure Financials Configure Sales and Purchasing Configure Operations Understand Integrationa nd Automation scenarios Built and optimized for small and medium businesses, Dynamics 365 Business Central is an application for companies that have outgrown their entry-level business applications. Growing businesses often outgrow their basic accounting software or legacy enterprise resource planning (ERP) systems that are unable to handle increased inventory and transactions, lack integration with other line-of-business systems, and have reporting limitations. Businesses are also challenged with the logistics of providing services that have more scalability, increased mobility, and availability in the cloud. With Business Central, you can manage your financials, automate and secure your supply chain, sell smarter, improve customer service and project performance, and optimize your operations. INTRODUCTION TO BUSINESS CENTRAL MODULES * Introduction to Business Central * Technology overview * Navigate the user interface * Master data for the Sales and Purchase process APPLICATION SETUP * Create and configure a new company * Migrate data to Business Central * Manage Security * Set up core app functionality * Set up dimensions CONFIGURE FINANCIALS * Set up Finance Management * Set up the Chart of Accounts * Set up posting groups * General Journals * Set up Cash Management * Set up Accounts Payables * Set up Accounts Receivables CONFIGURE SALES AND PURCHASING * Set up Inventory * Configure prices and discounts OPERATIONS * Purchase items * Sell items * Process financial transactions * Inventory costing INTEGRATION AND AUTOMATION * Set up and use approvals with workflows * Connect Power Apps * Connect Power Automate * Connect Power BI

Duration 3 Days 18 CPD hours This course is intended for The Foundation course is designed for individuals who want to gain an overview of Business Analysis (Business Analysts, Requirements Engineers, Product manager, Product Owner, Chief Product Owner, Service Manager, Service Owner, Project manager, Consultants) Overview Students should be able to demonstrate knowledge and understanding of business analysis principles and techniques. Key areas are: the role and competencies of a business analyst strategy analysis business system and business process modelling stakeholder analysis investigation and modelling techniques requirements engineering business case development The business analyst role analyzes, understands and manages the requirements in a customer-supplier relationship and ensures that the right products are delivered. The Foundation Seminar gives a good introduction to the spectrum of this responsibility. COURSE INTRODUCTION * Let?s Get to Know Each Other * Course Overview * Course Learning Objectives * Course Structure * Course Agenda * Introduction to Business Analysis * Structure and Benefits of Business Analysis Foundation * Exam Details * Business Analysis Certification Scheme WHAT IS BUSINESS ANALYSIS? * Intent and Context * Origins of business analysis * The development of business analysis * The scope of business analysis work * Taking a holistic approach * The role and responsibilities of the business analyst THE COMPETENCIES OF A BUSINESS ANALYST * Personal qualities * Business knowledge * Professional techniques * The development of competencies STRATEGY ANALYSIS * The context for strategy * The defiition of strategy * Strategy development * External environmental analysis * Internal invironmental analysis * SWOT analysis * Executing strategy BUSINESS ANALYSIS PROCESS MODEL * An approach to problem solving * Stages of the business analysis process model * Objectives of the process model stages * Procedures for each process model stage * Techniques used within each process model stage INVESTIGATION TECHNIQUES * Interviews * Observation * Workshops * Scenarios * Prototyping * Quantitative approaches * Documenting the current situation STAKEHOLDER ANALYSIS AND MANAGEMENT * Stakeholder categories and identification * Analysing stakeholders * Stakeholder management strategies * Managing stakeholders * Understanding stakeholder perspectives * Business activity models MODELLING BUSINESS PROCESSES * Organizational context * An altrnative view of an organization * The organizational view of business processes * Value propositions * Process models * Analysing the as-is process model * Improving business processes (to-be business process) DEFINING THE SOLUTION * Gab analysis * Introduction to Business Architecture * Definition to Business Architecture * Business Architecture techniques BUSINESS AND FINANCIAL CASE * The business case in the project lifecycle * Identifying options * Assessing project feasibility * Structure of a business case * Investment appraisal ESTABLISHING THE REQUIREMENTS * A framework for requirements engineering * Actors in requirements engineering * Requirements elicitation * Requirements analysis * Requirements validation DOCUMENTING AND MANAGING THE REQUIREMENTS * The requirements document * The requirements catalogue * Managing requirements MODELLING THE REQUIREMENTS * Modelling system functions * Modelling system data DELIVERING THE REQUIREMENTS * Delivering the solution * Context * Lifecycles DELIVERING THE BUSINESS SOLUTION * BA role in the business change lifecycle * Design stage * Implementation stage * Realization stage

Duration 2 Days 12 CPD hours This course is intended for This course is intended for intermediate business and requirements analysts who are looking to improve their business case development and presentation skills. This course is also a great fit for project managers and product owners who work closely with business analysts or who perform some form of business case work themselves. Overview Understand the role of the business analyst within the business case process Understand the main professional associations and standards that support business analysts in the industry Discuss the benefits of business case creation Explore how to define the business need Describe the role of the business analyst in supporting the enterprise to determine how to optimally invest in the right project initiatives Explain how to identify stakeholders and the significance to the pre-project activities Discuss the importance of analyzing the enterprise Describe and explore the activities performed to assess the current business environment Explain how a business analyst describes a ?future? state environment including how to identify gaps in enterprise capabilities Present and explore how to define the scope of a solution Describe the activities performed and techniques used to determine viable solution options Explore various techniques for evaluating solution options including feasibility and risk analysis Thoroughly understand the purpose of conducting a feasibility assessment Discuss and practice a number of business analysis techniques that support the business case process Explore the components of a business case Describe how the business case supports decision makers in making go/no-go decisions Demonstrate how to assemble the output from pre-project activities into a well-structured business case Present techniques for presenting business cases to top level managers and obtaining buy-in Discuss methods for preparing for challenges during business case delivery Students learn the steps to effective business case development and support your strategic business recommendations with sound budgeting and financial back-up. The one course you need to make high-impact recommendations and receive full management support for your ideas. INTRODUCTION * Module Learning Objectives * What is Business Analysis * Polling Question * International Institute of Business Analysis * BABOK© Guide Components * Project Management Institute * Business Analysis for Practitioners: A Practice Guide * BABOK© Guide Knowledge Areas * Benefits of Business Analysis * Polling Question * A Business Analyst can Influence Project Success Factors * Challenges of Business Analysis * Polling Question * Purpose of a Business Case * Exercise 1a: What Should a Business Case Include * Define the Business Case Elements * What to Look Out For * Who is Involved * Exercise 1b: Review Business Case Outline * Module Learning Objectives PRE-PROJECT ACTIVITIES & THE BUSINESS ANALYST * Module Learning Objectives * The Definition of a Business Analyst * The Role of a Business Analyst * Responsibilities of a BA * BA Role vs. PM Role * Business Analysis vs. Systems Analysis * Business Analysis Competencies * Polling Question * Business Analyst Role and Stakeholders * Exercise 2a: Review the Case Study * What is a Stakeholder? * The Importance of Stakeholders * Stakeholder Identification * Tips for Identifying Stakeholders * Other Stakeholder Tips * Stakeholder Identification/Analysis * Exercise 2b: Identify Roles and Responsibilities * Stakeholder Map * Stakeholder Matrix & Onion Diagrams * A Stakeholder Map * Onion Diagram * Exercise 2c: Why do we Need to Understand the Enterprise? * Why Study the Enterprise? * What is Enterprise Architecture? * What is Strategy Analysis? * About Strategy Analysis * Purpose of Strategy Analysis * When to Perform Strategy Analysis * Strategic Planning * Module Summary THE NEEDS ASSESSMENT PROCESS * Module Learning Objectives * Business Need Defined * Define Business Need * The Needs Assessment Process * Problem or Opportunity * Exercise 3a: Problem/Opportunity Identification * Understanding Why * Situation Statements * Business Need and Current State * Determine the Stakeholders * Polling Question * Goals and Objectives * Polling Question * Exercise 3b: Give 3 Examples of Business Goals * Define Business Need Techniques * Exercise 3c: Identify the Business Need * Definition of Strategy Analysis * When Business Strategy is not Driving Project Definition * Typical Project Profile * The Executive Paradox * Solution to the Paradox * Exercise 3d: Describe 3 Outcomes You Would Expect from the Case Study * The Four ?Ares? * Understand How to Create a Business Model * Business Model Example * Exercise 3e: Create a Business Model * The Business Case Approach * Financial and Strategic Measurement Tools * Module Summary DETERMINING THE REQUIRED CAPABILITIES & DEFINING SOLUTION SCOPE * Module Learning Objectives * Business Need and Current State * Purpose of Analyzing the Current State * Analyzing Current Capabilities and Process * Capabilities Defined * Techniques for Analyzing the Current State * Define the Future State * Techniques for Defining the Future State * Assess Capability Gaps * Stakeholders Involved when Reviewing Capability Gaps * Discussion: Assessing New Capabilities * Defining Solution Scope * Determining Scope Boundary * How to Define Solution Scope * Defining Solution Scope * Project Scope and Product Scope * Scope Modeling * Techniques Used to Define Scope * Define Scope Boundaries * Modeling Scope: Context Diagram * Exercise 4a: Create a Context Diagram from the Case Study * Communicating Solution Scope to Stakeholders * Stakeholders Participating in Scope Activities * Exercise 4b: Discuss Managing Expectations * Module Summary ASSESSING FEASIBILITY & PROPOSING SOLUTION OPTIONS * Module Learning Objectives * Financial Analysis * Purpose of Financial Analysis * Costs versus Benefits * Financial Models * Timing for Assessing Financial Benefits * Risk * Assessing Risks * Risk Process * Exercise 5a: Identifying Risks * Risk Analysis * Capturing and Categorizing Risks * Risk Strategies * Tolerance for Risk * Determining Solution Options * Solution Option Process * Determining and Analyzing Solution Options * Brainstorming * Conducting an Outcomes Focused Brainstorming Session * Stakeholders Involved in Determining Solution Options * Exercise 5b: Determining Solution Options * Feasibility Analysis * Discussion: Ranking Solution Options * Discussion: Recommending the Most Viable Option * Exercise 5c: Assess the Most Viable Options * Solution Approach Definition * Exercise 5d: Review the Business Case Templates * Module Summary PACKAGING & PRESENTING THE BUSINESS CASE * Module Learning Objectives * Circumventing a Business Case * Documenting the Business Case * Value of the Business Case Process * Business Case Components * Business Case Techniques * Build a Convincing Business Case * Discussion: Identifying Decision Criteria * Exercise 6a: Supporting a Go/No Go Decision * Packaging the Business Case * Planning Business Case Delivery * Discussion: Planning Stakeholder Buy-in * Information and Communication Needs in the Business Case Process * Presenting your Business Case * Exercise 6b: Anticipating and Responding to Challenges * Module Summary COURSE WRAP UP * Course Summary * Questions * Additional Resources * Thank You * ADDITIONAL COURSE DETAILS: Nexus Humans BA03 - Writing Effective Business Cases 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 BA03 - Writing Effective Business Cases 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.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Program/Project Managers, and Users. Overview Learn how to create queries in BEx Query DesignerLearn how to use advanced query functionsLearn how to perform OLAP analysis In this course, students obtain the knowledge to create query definitions using the BEx Query Designer and to make them available for OLAP analysis. DATA WAREHOUSING * Describing Data Warehousing * Describing Data Warehouse Architecture * Using Reporting Tools NAVIGATION OPTIONS IN REPORTS * Using the Navigation Options in Reports * Saving Analysis Views SIMPLE QUERIES * Creating Simple Queries * Finding a Query * Filtering Query Definition Data * Configuring Query Properties KEY FIGURES AND STRUCTURES IN QUERIES * Creating Restricted Key Figures * Creating Calculated Key Figures * Creating a New Formula with Boolean Operators * Configuring Properties of Key Figures * Using Exception and Nested Exception Aggregation QUERIES WITH MULTIPLE STRUCTURES * Creating Structures * Resolving Formula Collision * Designing Detailed Queries with the Cell Editor CHARACTERISTICS AND HIERARCHIES IN QUERIES * Configuring the Properties of Characteristics * Running Display and Navigation Attribute Queries * Adding Hierarchies to Reports * Adding External Hierarchies to a Report * Using Hierarchies and Structures * Creating External Hierarchies VARIABLES IN QUERIES * Using Variables * Creating Characteristic Value and Text Variables in Queries * Creating Hierarchy and Hierarchy Node Variables in Queries * Creating Formula Variables in Queries * Activating Business Content Variables EXCEPTIONS AND CONDITIONS IN QUERIES * Creating Exceptions in Query Design * Creating Conditions in Query Design REPORT-REPORT INTERFACE * Using the Report-Report Interface QUERY PERFORMANCE OPTIMIZATION * Optimizing Query Performance * Configuring Query Read Mode * Use Performance Monitoring Tools QUERIES MANAGEMENT AND AUTHORIZATIONS OVERVIEW * Managing Query Objects * Describing Authorizations REPORTING OPTIONS * Outlining Reporting Options for SAP NetWeaver BW ADDITIONAL COURSE DETAILS: Nexus Humans BW305 SAP Business Warehouse Query Design and Analysis 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 BW305 SAP Business Warehouse Query Design and Analysis 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.

Duration 2 Days 12 CPD hours This course is intended for Executives, Project Managers, Business Analysts, Business and IT stakeholders working with business analysts Overview Learn about the components of Strategic Business Analysis. Understand the importance of defining the business need correctly and pursuing a thorough analysis of the internal and external environments of the enterprise before choosing the solution. Shortcutting the pre-analysis work discussed in this course often results in delivering solutions that are misaligned to the enterprise strategy and to the expectations and needs of the business. Learn how to avoid the pitfall of jumping to a solution prior to a solid understanding of the opportunity or problem needing to be addressed. This course is aimed for experienced practitioners who desire a clear understanding of Strategic Business Analysis, who would like to understand what comprises this work, and the objectives for performing it. FOUNDATIONAL CONCEPTS * Components of business analysis * Business analysis competencies * IIBA/PMI and the goals of a professional association * Purpose for having a BA standard * Exercise: Review the case study INTRODUCTION TO STRATEGY ANALYSIS * Definition and purpose of Strategy Analysis * The timing of Strategy Analysis * Identifying stakeholders and the business need * Discussions: Strategy analysis in your organization, When business needs are not clearly defined, and Strategy Analysis and the business analyst * Exercises: Describe Strategy Analysis, Identify Roles/Responsibilities, and Identify the business need ANALYZE THE CURRENT STATE ENVIRONMENT * The importance of analyzing Current State * Understanding Business Architecture * Techniques for analyzing Current State DEFINE THE FUTURE STATE * Future State description * Assessing impacts to business architecture * Determining Solution Scope * Discussions: Managing expectations with stakeholders, Capturing current capabilities, and How to approach acquiring capabilities ASSESS RISKS * Identifying risks * Risk Tolerance/Categories/risk responses * The concept of positive risk * Techniques for identifying risks * Discussions: Who is responsible for identifying risks? Who captures positive risks today? * Exercise: Identify Risks DEFINE THE CHANGE STRATEGY * Defining change strategy * Components of change strategy * Solution scope, enterprise readiness and change * Techniques for defining a change strategy DEVELOPING A BUSINESS CASE * The purpose of a business case * Business case components * Building a convincing business case * Determining the Recommended Solution * Packaging the business case * Reviewing the business case with stakeholders * Discussions: Evaluating project proposals and anticipating questions for the business case review * Exercise: Create a business case ADDITIONAL RESOURCES * Helpful links for obtaining additional business analysis information ADDITIONAL COURSE DETAILS: Nexus Humans BA02 - Strategic Business Analysis 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 BA02 - Strategic Business Analysis 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.