358 Analytics courses in Nottingham delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. Working with Multiple Worksheets and Workbooks Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data Use Formula Auditing and Error Checking Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas Reviewing and Protecting Workbooks Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare a Workbook for Distribution Modify Excel's Default Settings Using Macros to Automate Workbook Functionality Create Macros via Recording Run Macros via Buttons and Shortcuts Assign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code Forecasting and Analysis Data Use Conditional Formatting to Highlight, Sort and Filter Key Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver

Duration 2 Days 12 CPD hours This course is intended for Project Managers, Business Analysts, Business and IT stakeholders working with analysts Overview Provide a solid foundation for applying business process modeling principles and best practices with BPMN Demonstrate how to solve practical business problems using BPMN Business Process Diagrams (BPDs) Students will learn to map business processes easily and efficiently using the industry standard - BPMN which stands for Business Process Modeling Notation from the Object Management Group (OMG). Students will learn the best practices in process mapping using the latest industry standards (BPMN) so that both the business and IT stakeholders will be able to understand the models and map processes consistently through-out their organization. Introduction What is Business Process Modeling? What is Business Process Modeling Notation (BPMN)? Benefits of BPMN An Overview of Governance An overview of governance Key governance questions to ask What happens if you don?t have effective governance? Mapping the Business Problem Define a strategic outcomes map Define a Business model and relevant processes Modeling Simple BPMN Structures When do you use BPMN? What are simple BPMN structures? AS-IS vs. TO-BE modeling Modeling Complex BPMN Structures What are complex BPMN structures When to use complex BPMN structures Analyzing Process Models Identifying poor process models Creating process models that everyone can understand Identify criteria for a well-defined process Process Mapping vs. Process Modeling Determine when to create a process map Determine when to create a process model Asking the four ?Ares? Additional Resources Learning about BPMN 2.0 More useful BPMN links BPMN 2.0 free editors

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 Modelling Business Processes (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 Modelling Business Processes principles and techniques. Key areas are: The role of business process modelling Modelling core business processes at an organizational level Modelling business processes at the process level Documenting and analyzing tasks The use of gap analysis in improving business processes 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 Modelling Business Processes Course Introduction Let?s Get to Know Each Other Course Overview Course Learning Objectives Course Structure Course Agenda Introduction to Business Process Modelling Exam Details Business Analysis Certification Scheme The Context for Business Process Modelling Purpose and benefits of business process modelling Three levels of business process hierarchy (Organization, process and task level) Process view versus the functional view of an organization Assessing the impact of a new process design (POPIT model) Implementation of a business change (Pilot, phased, direct changeover, parallel running) The Organizational Context for Business Processes Construction of an organizational level model of a business process External and internal elements of an organizational model Supporting the value proposition Modelling the Business Processes Construction of a business process model Standard notation Process, task and step OPOPOT External, internal and time-based events Internal performance measures and customer expectations of performance Documenting Tasks A task description UML activity diagram notation and structured english Improving Business Processes task automation, removal of gaps and disconnects, process reengineering business rules and assumptions Unsatisfactory performance Combinations of conditions Gap analysis

Duration 2 Days 12 CPD hours This course is intended for This is an Intermediate and beyond-level Tableau course geared for experienced Tableau users who wish to leverage Tableau's more advanced capabilities. Overview This skills-focused course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, students will learn how to: Understand what data works best with Tableau Desktop and how to shape and clean it appropriately to get Learn how to maximize flexibility from Tableau Desktop. Learn how Tableau Prep folds into the analytic cycle, and when to prep data in Tableau Prep vs. Tableau Desktop. Understand the terminology used in Tableau Prep. Know how Tableau Prep approaches data sampling. Create and understand data prep flows that address common scenarios encountered in data preparation, as applied to common data use cases Know how to view data prepared in Tableau Prep using Tableau Desktop. Understand data exploration and validation in Tableau Prep and Tableau Desktop. Geared for experienced Tableau Users, Tableau Prep Building (Tableau Data Prep) for Experienced Users is a two-day hands-on course designed to provide you with the tools and knowledge of how to prepare and shape data in Tableau Prep. It?s best suited for people who have 3-6 months experience in Tableau Desktop and are somewhat familiar with writing calculations. Throughout the course, our instructors will take you from conceptual data preparation material to creating useful Tableau Prep flows that can be output to Tableau Desktop for analysisNOTE: The Tableau Training Series is independent-format training that can be tuned and adjusted to best meet your needs. Our materials are flexible, comprehensive, and are always instructed by a senior instructor with a deep understanding of Tableau and its most current features, benefits and functionality in a wide array of uses. This is not Official Tableau Training. Course Outline Introduction to the workspace Introduction to the workflow Data literacy concepts Connecting to and configuring data Exploring data Cleaning data Preferred data structures in Tableau Shaping data Combining data Opening a data sample and creating an output file Best practices for data preparation Complex flows Starting with a question Hands-on data preparation Additional course details: Nexus Humans Tableau Prep Building (Tableau Data Prep) for Experienced Users (TTDTAB010) 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 Tableau Prep Building (Tableau Data Prep) for Experienced Users (TTDTAB010) 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.

Better Business Cases™ Practitioner: Virtual In-House Training Better Business Cases™ is based on the Five Case Model - which is the UK government's best practice approach to structuring spending proposals and making effective business decisions. Using this best-practice approach will allow organizations to reduce unnecessary spending and improve the decision-making process which gives you a greater chance of securing necessary funding and support for initiatives. The goal of the practitioner course is to develop a candidate's ability to deliver a comprehensive business case, through encouraging expanded knowledge to guide the practical application of theoretical foundations. Upon the completion of this Practitioner course, a candidate will be able to start applying the model to a real business case development project. What You Will Learn At the end of this program, you will be able to: Develop the lifecycle of a business case and to establish the relationships between the five cases Apply the steps in the business case development framework, in order to support the production of a business case, using the Five Case Model, for a given scenario Overview of Better Business Cases Alignment with the strategic planning process Importance of the Business Case using the Five Case Model Overview of the Five Case Model Purpose of the key stages in the development of a spending proposal Purpose of a Business Justification Case Business Case Development Process Purpose of project / programme assurance and assurance reviews Responsibility for producing the Business Case Determining the Strategic Context and Undertaking the Strategic Assessment Scoping the Scheme and Preparing the Strategic Outline Case Planning the Scheme and Preparing the Outline Business Case Procuring the Solution and Preparing the Full Business Case Implementation and monitoring Evaluation and feedback Making the Case for Change Agree on the strategic context Determine spending objectives, existing arrangements, and business needs Determine potential business scope and key service requirements Determine benefits, risks, constraint, and dependencies Exploring the Preferred Way Forward Agree on critical success factors Determine long list options and SWOT analysis Recommend a preferred way forward Determining Potential Value for Money Revisit the short list Prepare the economic appraisal for short-listed options Undertake benefits appraisal Undertake risk appraisal Select preferred option and undertake sensitivity analysis Preparing for the Potential Deal Determine the procurement strategy Determine service streams and required outputs Outline potential risk apportionment Outline potential payment mechanisms Ascertain contractual issues and accountancy treatment Ascertaining Affordability and Funding Requirement Prepare the financial model Prepare the financial appraisals Planning for Successful Delivery Plan programme / project management Plan change and contract management Plan benefits realization Plan risk management Plan programme / project assurance and post project evaluation Procuring the Value for Money Solution Revisit the case for change Revisit the OBC options Detail procurement process and evaluation of best and final offers (BAFOs) Contracting for the Deal Set out the negotiated deal and contractual arrangements Set out the financial implications of the deal Ensuring Successful Delivery Finalize project management arrangements and plans Finalize change management arrangements and plans Finalize benefits realization arrangements and plans Finalize risk management arrangements and plans Finalize contract management arrangements and plans Finalize post-project evaluation arrangements and plans

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owners/Team Leads/Power Users. In this course, students are enabled to transform Excel workbooks into captivating dashboards for executives and business users. Introduction to Dashboards Creating Interactive Dashboards Using an Embedded Excel Workbook in the Dashboard Data Visualizations with Charts Using Data in a Range Using Data in a Series Preparing Future Data by Ignoring End Blanks Dashboard Distribution Distributing a Dashboard Single Value Components Using Single Value Components Alerts Setting Up Alerts Selectors Using Selectors Setting Default Values for Selectors Selecting Multiple Items Common Components Using Images in a Dashboard Using Tables in a Dashboard Using an Interactive Calendar in a Dashboard Adding a URL to a Dashboard Components Used as Selectors Using the Chart Component as a Selector Using the Map Component as a Selector Format Options Configuring Proportional Size and Position Using Themes to Apply Formats Using Templates to Apply Formats Applying Globalization Dynamic Visability Adding Dynamic Visibility Using Formulas to Create Dynamic Visibility Creating Multi-Layer Dashboards Dashboard Design Optimization Optimizing Dashboard Design Dashboard Connection to Live Data Using Live Data Sources Setting Up an XML Connection Using Web Services to Connect to Data Using the Query Browser to Connect to Data Using the Portal Data Connection to Connect to Data Additional course details: Nexus Humans BOX310 SAP BusinessObjects Dashboards 4.1 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 BOX310 SAP BusinessObjects Dashboards 4.1 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: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL