25 Business Data Analysis courses delivered Live Online

Duration 5 Days 30 CPD hours This course is intended for This course is suitable for anyone responsible for configuring, managing or supporting a Veeam Availability Suite v11 environment. This includes Senior Engineers and Architects responsible for creating architectures for Veeam environments. Overview After completing this course, attendees should be able to: Describe Veeam Availability Suite components usage scenarios and relevance to your environment. Effectively manage data availability in on-site, off-site, cloud and hybrid environments. Ensure both Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs) are met. Configure Veeam Availability Suite to ensure data is protected effectively. Adapt with an organization's evolving technical and business data protection needs. Ensure recovery is possible, effective, efficient, secure and compliant with business requirements. Provide visibility of the business data assets, reports and dashboards to monitor performance and risks. Design and architect a Veeam solution in a real-world environment Describe best practices, review an existing infrastructure and assess business/project requirements Identify relevant infrastructure metrics and perform component (storage, CPU, memory) quantity sizing Provide implementation and testing guidelines in line with designs Innovatively address design challenges and pain points, matching appropriate Veeam Backup & Replication features with requirements Veeam Certified Architect is the highest level of Veeam technical certifications. Engineers who complete both Veeam Availability Suite v11: Configuration and Management and Veeam Backup & Replication V11: Architecture and Design programs (courses + exams) will be granted with the 'Veeam Certified Architect' (VMCA) title by Veeam. INTRODUCTION VEEAM AVAILABILITY SUITE V11: CONFIGURATION AND MANAGEMENT * Describe RTOs and RPOs, what they mean for your business, how to manage and monitor performance against them * The 3-2-1 Rule and its importance in formulating a successful backup strategy * Identify key Veeam Availability Suite components and describe their usage scenarios and deployment types BUILDING BACKUP CAPABILITIES * Backup methods, the appropriate use cases and impact on underlying file systems * Create, modify, optimize and delete backup jobs, including Agents and NAS Backup jobs. Explore different tools and methods to maximize environment performance * Ensure efficiency by being able to select appropriate transport modes while being aware of the impact * of various backup functions on the infrastructure BUILDING REPLICATION CAPABILITIES * Identify and describe the options available for replication and impacts of using them * Create and modify replication jobs, outline considerations to ensure success * Introduce the new Continuous Data Protection (CDP) policy SECONDARY BACKUPS * Simple vs. advanced backup copy jobs, how to create and modify them using best practices to ensure efficient recovery * Discuss using tapes for backups ADVANCED REPOSITORY CAPABILITIES * Ensure repository scalability using a capability such as SOBR on-premises and off-site including integration with cloud storage * Ensure compatibility with existing deduplication appliances * Introduce the new hardened repository PROTECTING DATA IN THE CLOUD * Review how Veeam can protect the data of a cloud native application * Review how Veeam Cloud Connect enables you to take advantage of cloud services built on Veeam * Review how Veeam can be used to protect your Office 365 data RESTORING FROM BACKUP * Ensure you have the confidence to use the correct restore tool at the right time for restoring VMs, bare metal and individual content such as files and folders * Utilize Secure Restore to prevent the restoration of malware * Describe how to use Staged Restore to comply with things like General Data Protection Regulation (GDPR) before releasing restores to production * Identify, describe and utilize the different explores and instant recovery tools and features RECOVERY FROM REPLICA * Identify and describe in detail, failover features and the appropriate usage * Develop, prepare and test failover plans to ensure recovery * Disaster recovery from replica to meet a variety of real-world recovery needs TESTING BACKUP AND REPLICATION * Testing backups and replicas to ensure you can recover, what you need, when you need to * Configure and setup virtual sandbox environments based on backup, replicas and storage snapshots VEEAM BACKUP ENTERPRISE MANAGER AND VEEAM ONE * Introduce the concept of monitoring your virtual, physical and cloud environments with Veeam Backup Enterprise Manager and Veeam ONE? CONFIGURATION BACKUP * Locate, migrate or restore backup configuration INTRODUCTION VEEAM BACKUP & REPLICATION V11: ARCHITECTURE AND DESIGN * Review the architecture principles * Explore what a successful architecture looks like * Review Veeam?s architecture methodology DISCOVERY * Analyze the existing environment * Uncover relevant infrastructure metrics * Uncover assumptions and risks * Identify complexity in the environment CONCEPTUAL DESIGN * Review scenario and data from discovery phase * Identify logical groups of objects that will share resources based on requirements * Create a set of detailed tables of business and technical requirements, constraints, assumptions and risks * Review infrastructure data with each product component in mind * Create high level design and data flow LOGICAL DESIGN * Match critical components and features of VBR with requirements * Create logical groupings * Determine location of components and relationship to logical grouping * Aggregate totals of component resources needed per logical grouping * Calculate component (storage, CPU, memory) quantity sizing PHYSICAL/TANGIBLE DESIGN * Convert the logical design into a physical design * Physical hardware sizing * Create a list of physical Veeam backup components IMPLEMENTATION AND GOVERNANCE * Review physical design and implantation plan * Review Veeam deployment hardening * Describe the architect?s obligations to the implementation team * Provide guidance on implementation specifics that relate to the design VALIDATION AND ITERATION * Provide framework for how to test the design * Further develop the design according to a modification scenario

Duration 2 Days 12 CPD hours This course is intended for This course is suited to marketeers, business analysts, and researchers who are interested in increasing their statistical knowledge. Overview After attending this course, delegates will understand how statistics can be used to provide valuable insight into their business, and be able to apply statistical methods to solve business problems. On returning to work delegates will immediately be able to make a difference to the way that their organisations make decisions. This course covers the statistical methods that analysts need to move from simple reporting on business problems to extracting insight to solve business problems. COURSE OUTLINE * The course will explore the following topics through a series of lectures and workshops: * Summary statistics for both continuous data and categorical data * Using and reporting confidence intervals * Using hypothesis tests to answer business questions * Using correlations to explore data relationships * Simple prediction models * Analysing categorical data ADDITIONAL COURSE DETAILS: Nexus Humans Data-driven Business Using Statistical 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 Data-driven Business Using Statistical 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.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS * Topic A: Work with Ranges * Topic B: Use Specialized Functions * Topic C: Work with Logical Functions * Topic D: Work with Date and Time Functions * Topic E: Work with Text Functions WORKING WITH LISTS * Topic A: Sort Data * Topic B: Filter Data * Topic C: Query Data with Database Functions * Topic D: Outline and Subtotal Data ANALYZING DATA * Topic A: Create and Modify Tables * Topic B: Apply Intermediate Conditional Formatting * Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS * Topic A: Create Charts * Topic B: Modify and Format Charts * Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS * Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS * Topic A: Use Links and External References * Topic B: Use 3-D References * Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS * Topic A: Collaborate on a Workbook * Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY * Topic A: Apply Data Validation * Topic B: Search for Invalid Data and Formulas with Errors * Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING * Topic A: Use Lookup Functions * Topic B: Trace Cells * Topic C: Watch and Evaluate Formulas FORECASTING DATA * Topic A: Determine Potential Outcomes Using Data Tables * Topic B: Determine Potential Outcomes Using Scenarios * Topic C: Use the Goal Seek Feature * Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA * Topic A: Create Sparklines * Topic B: Map Data

Duration 2 Days 12 CPD hours This course is intended for Designed for individuals new to the business analyst role or those who supervise and/or work with business analysts. Overview Understand the role of the business analyst Discuss industry standards/resources for obtaining more information about business analysis Acquire a solid understanding of the various tasks/activities that comprises business analysis Recognize the pre and post project business analysis activities Learn how to plan, elicit, analyze, model, and test requirements This is an introductory course designed to provide students with a basic understanding of the benefits, functions and impact a business analyst has within an organization. The course discusses the business analysis process as it is applied throughout a project as well as the pre-project activities that comprise strategy analysis. Students learn how a business analyst supports the project throughout the solution development life cycle, from defining business needs and solution scope to validating that requirements have been met in the testing phase and ensuring the solution continues to provide value after implementation. INTRODUCTION TO BUSINESS ANALYSIS * Business analysis defined * The activities that comprise business analysis * IIBA/PMI and the goals of a professional association * IIBA?s BABOK© Guide and PMI?s Practice Guide in Business Analysis * Exercise: Requirements challenges * THE IIBA? AND THE ROLE OF THE BUSINESS ANALYST * Business analyst defined * BA role vs. PM role * Importance of communication/collaboration * The deliverables produced as part of business analysis * The BA career path * Exercise: Review case Study * STRATEGY ANALYSIS AND CHANGE * The definition of Strategy Analysis * Components of Strategy Analysis * Identifying stakeholders and business needs * Exercises: Business Need development and RACI Stakeholder Identification UNDERSTANDING AND DEFINING SOLUTION SCOPE * Defining Solution Scope * Project scope vs. product scope * Defining a problem statement * Techniques for defining scope * Exercises: Conduct a brainwriting session and create a context diagram * Optional exercise: Create a Use Case Diagram UNDERSTANDING REQUIREMENTS * Define the term requirement * Understand requirement types * Present the requirements process * Requirements vs. specifications and business rules * Exercise: Identify Requirements PLANNING & ELICITING REQUIREMENTS * The Requirements Work Plan (RWP) * Components of the RWP * Identifying good questions for elicitation * Active listening * Categories and types of elicitation techniques * Exercise: Planning for elicitation * ANALZYING & DOCUMENTING REQUIREMENTS * Understanding requirements analysis * The Business Requirements Document (BRD) * The BRD vs. the functional requirements specification * BRD components * The purpose of packaging requirements * Exercise: Analyzing Requirements ELICITATION & PROCESS MODELING * Why models are created * Objectives of modeling * What is process management * Understanding process modeling * Modeling using BPMN * AS-IS vs. TO-BE modeling * BPMN subclasses * BPMN simple structure * Prototyping * Business Process Modeling case study * Exercises: Modeling and create a Prototype of your application VERIFYING & VALIDATING REQUIREMENTS * The difference between validation and verification * Characteristics of good requirements * Risks associated with requirements * Types of testing approaches * Creating a test plan * Requirements traceability matrix * Verified and validated requirements * Exercise: Testing Requirements ADDITIONAL RESOURCES * Helpful links for obtaining additional business analysis information ADDITIONAL COURSE DETAILS: Nexus Humans BA01 - Business Analysis Essentials 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 BA01 - Business Analysis Essentials 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 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 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 primarily for Application Consultants, Business Analysts, Business Process Owners/Team Leaders/Power Users, and Developer Consultants. Overview At course completion students will know- The basic functions and navigation options of BusinessObjects Analysis for Microsoft Office- The special functions and layout design options of BusinessObjects Analysis for Microsoft Office In this course, students learn the basic functions and navigation options of the Analysis edition for Microsoft Office. Students will also learn the special functions and layout design options of Analysis. COMPONENTS AND DATA SOURCES FOR ANALYSIS * Using Analysis Components and Data Sources CUSTOMIZATION FOR WORKBOOK DATA ANALYSIS * Using the Basic Components of Analysis * Sorting and Filtering Workbook Members * Filtering Selected Workbook Members by Measure for Enhanced Analysis * Using Hierarchies for Data Analysis in Workbooks * Using Inserted Components to Add Workbook Functionality * Configuring Filter Components Using Formulas to Enhance the Workbook Layout * Defining Conditional Formatting Options for Workbooks * Using a Prompting Dialog in Workbook Queries * Extending Workbook Display Options with Functions and Microsoft Excel VBA * Using Styles to Customize Workbook Appearance * Setting Preferences to Control Workbook Behavior * Publishing Analysis Documents to the BI Platform Server PRESENTATION OF WORKBOOK ANALYSIS DATA * Presenting Analysis Data for Business Users ADDITIONAL COURSE DETAILS: Nexus Humans BOAN10 SAP BusinessObjects Analysis for Microsoft Office 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 BOAN10 SAP BusinessObjects Analysis for Microsoft Office 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 The course is designed for individuals who want to gain in-depth knowledge and practice in the discipline 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 and application of Business Analysis principles and techniques. Key areas are: The breath of the role of a Business Analyst The processes and techniques of strategy analysis Investigation of an organization's business systems Techniques used within stakeholder analysis and the need for analyzing perspectives Conceptual modelling and business activity models Business improvements through gap analysis The Business case within the business change lifecycle The Business Analyst role analyzes, understands and manages the requirements in a customer-supplier relationship and ensures that the right products are delivered.The course provides in-depth knowledge and practice in Business Analysis COURSE INTRODUCTION * Let?s Get to Know Each Other * Course Overview * Course Learning Objectives * Course Structure * Course Agenda * Introduction to Business Analysis Practice * Exam Details * Business Analysis Certification Scheme RATIONALE FOR BUSINESS ANALYSIS * The role of the BA throughout the stages of the Business change lifecycle * The scope of the BA role within the context of the range of analysis activities * Three areas of competencies UNDERSTANDING THE STRATEGIC CONTEXT * Techniques in practice: * MOST * Resource audit * PESTLE * Porter's Five Forces * SWOT analysis * CSF, KPI and Performance target * Balanced Business Score Card UNDERSTANDING THE CURRENT SITUATION * Identification of stakeholder categories * Identification of relevant investigation techniques * The rationale for taking a holistic view * Rich pictures, Mind Maps and Fishbone diagrams STAKEHOLDER ANALYSIS AND MANAGEMENT * Power/interest and level of interest * Appropriate stakeholder management strategy * Stakeholder perspectives and CATWOE technique ANALYSING AND MODELLING BUSINESS ACTIVITIES * Conceptual models of a business situation * Five types of high level activity * Planning activities * Enabling activities * Doing activities * Monitoring and control activities * Three types of business events * The consensus business activity model IDENTIFYING POTENTIAL SOLUTIONS * Different categories of business rules * Gap analysis (through conceptual business activity model and as-is business situation) * Components of a new business model BUILDING THE BUSINESS CASE * Rationale for the development of a business case * Contents of a business case * Identification of tangible/intangible costs and benefits, risks and impacts * Rationale for the financial case and appraisal techniques * Business case review in the business change lifecycle ADDITIONAL COURSE DETAILS: Nexus Humans Business Analysis - Practice 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 Business Analysis - Practice 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 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 3 Days 18 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients. This course is also designed for professionals who want to pursue the Microsoft Power BI Data Analyst (Exam PL-300) certification. Overview In this course, you will analyze data with Microsoft Power BI. You will: Analyze data with self-service BI. Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Enhance data analysis by adding and customizing visual elements. Model data with calculations. Create interactive visualizations. Use advanced analysis techniques. Enhance reports and dashboards. Publish and share reports and dashboards. Extend Power BI beyond the desktop. As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft© Power BI© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. ANALYZING DATA WITH SELF-SERVICE BI * Topic A: Data Analysis and Visualization for Business Intelligence * Topic B: Self-Service BI with Microsoft Power BI CONNECTING TO DATA SOURCES * Topic A: Create Data Connections * Topic B: Configure and Manage Data Relationships * Topic C: Save Files in Power BI PERFORMING DATA CLEANING, PROFILING, AND SHAPING * Topic A: Clean, Transform, and Load Data with the Query Editor * Topic B: Profile Data with the Query Editor * Topic C: Shape Data with the Query Editor * Topic D: Combine and Manage Data Rows VISUALIZING DATA WITH POWER BI * Topic A: Create Visualizations in Power BI * Topic B: Chart Data in Power BI ENHANCING DATA ANALYSIS * Topic A: Customize Visuals and Pages * Topic B: Incorporate Tooltips MODELING DATA WITH CALCULATIONS * Topic A: Create Calculations with Data Analysis Expressions (DAX) * Topic B: Create Calculated Measures and Conditional Columns CREATING INTERACTIVE VISUALIZATIONS * Topic A: Create and Manage Data Hierarchies * Topic B: Filter and Slice Reports * Topic C: Create Dashboards USING ADVANCED ANALYSIS TECHNIQUES * Topic A: Create Calculated Tables, Variables, and Parameters * Topic B: Enhance Visuals with Statistical Analysis * Topic C: Perform Advanced Analysis ENHANCING REPORTS AND DASHBOARDS * Topic A: Enhance Reports * Topic B: Enhance Dashboards PUBLISHING AND SHARING REPORTS AND DASHBOARDS * Topic A: Publish Reports * Topic B: Create and Manage Workspaces * Topic C: Share Reports and Dashboards EXTENDING POWER BI BEYOND THE DESKTOP * Topic A: Use Power BI Mobile * Topic B: Extend Access with the Power BI API ADDITIONAL COURSE DETAILS: Nexus Humans Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) 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 Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) 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.