169 Business Analytics & Intelligence courses in Banstead delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for The student should be familiar with Excel and the concepts of datasets and basic reporting. Overview Understand and utilize Power BI Online. Understand and examine the differences between Power BI Desktop and Power BI Online. Understand and explore the Power BI Online interface. Understand and perform importing Excel worksheets, CSV, TXT, PBIX. Understand connecting to databases. Understand other forms of data. Understand data refresh. Understand and perform creating a new Power BI report. Understand and perform adding filters to a report. Understand and perform adding KPI's to a report. Understand and perform creating a Power BI dashboard. Understand and perform pinning tiles. Understand sharing reports and dashboards. Understand Power BI Mobile. This Logical Operations courseware is no longer available on the LO Store, but can be purchased by phone orderThis one-day course familiarizes the student with Power BI Online, which allows the student to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources. COURSE OVERVIEW Introduction Course Materials Facilities Prerequisites What We'll Be Discussing INTRODUCTION TO POWER BI ONLINE What is Power BI Online Examining the Differences Between Power BI Desktop and Power BI Online Exploring the Power BI Online Interface IMPORTING DATA Utilizing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files Connecting to Databases Examining Other Forms of Data Understanding Data Refresh CREATING REPORTS Creating a New Power BI Report Adding Filters to a Power BI Report Adding KPI?s to a Report CONFIGURING DASHBOARDS Creating a Power BI Dashboard Pinning Tiles SHARING REPORTS AND DASHBOARDS Sharing Reports and Dashboards Exploring Power BI Mobile

Duration 5 Days 30 CPD hours This course is intended for This course is designed for EDI End Users, Connect: End Users, Web Developers, as well as System Administrators. Overview After completing this course, students should be able to: Run a business process. Create a business process using the Graphical Process Modeler. Explain how to create a service configuration. Explain how to track an executable business process. Discuss the basics of Sterling B2B Integrator. This course provides students with a detailed examination of Sterling B2B Integrator, which provides end-to-end enterprise integration server for dynamic real-time and near-real time business collaboration and commerce automation.This course teaches students techniques, tools and recommended practices that can be used to run a business process, create a business process using the Graphical Process Modeler, explain how to create a service configuration, explain how to track an executable business process, and discuss the basics of Sterling B2B Integrator through a combination of lecture and hands-on labs. About IBM Sterling B2B Integrator Exercise. About Sterling B2B Integrator Basic BPML Concepts Exercise. Basic BPML Concepts XPath Basics Exercise. XPath Basics Graphical Process Modeler (GPM) Exercise. Graphical Process Modeler (GPM) Using the GPM Exercise. Using the GPM Troubleshooting a Business Process Exercise. Troubleshooting a Business Process Introduction to Service Management Exercise. Introduction to Service Management Case Study Sterling B2B Integrator Mapping Exercise. Sterling B2B Integrator Mapping Typing Map Exercise. Typing Map Tracking System Health Exercise. Tracking System Health Best Practices Exercise. Best Practices Case Study Course Wrap Up

Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information. This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines. This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI. You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service. 1 Introduction Power BI ecosystem Things to keep in mind Selecting dashboard colours Importing visuals into Power BI Data sources for your analysis Joining tables in Power BI 2 Working with data Utilising a report theme Table visuals Matrix visuals Drilling into hierarchies Applying static filters Group numbers with lists Group numbers with bins 3 Creating visuals Heatmaps in Power BI Visualising time-intelligence trends Ranking categorical totals Comparing proportions View trends with sparklines 4 Comparing variables Insert key performance indicators (KPI) Visualising trendlines as KPI Forecasting with trendlines Visualising flows with Sankey diagrams Creating a scatter plot 5 Mapping options Map visuals Using a filled map Mapping with latitude and longitude Mapping with ArcGIS or ESRI 6 Creating dashboards High-level dashboard Migration analysis dashboard Adding slicers for filtering Promote interaction with nudge prompts Searching the dashboard with a slicer Creating dynamic labels Highlighting key points on the dashboard Customised visualisation tooltips Syncing slicers across pages 7 Sharing dashboards Setting up and formatting phone views Exporting data Creating PDF files Uploading to the cloud Share dashboards in SharePoint online

Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives  By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting   Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App

Expand your Power BI knowledge and take your reports to the next level. Course overview Duration: 1 day (6.5 hours) This course is aimed at existing users who want to expand their skills to use advanced reporting techniques and use DAX to create calculated columns and measures. Participants should have either attended our Power BI – Introduction course or have equivalent knowledge. You should be able to import and transform data and create simple reports. Objectives  By the end of the course you will be able to: Import and connect data tables Create and use date calendars Create calculated columns Create and use measures Use drill down and drill through Create Tooltip pages Add and customise slicers Add action buttons Streamline your report for use in the Power BI Service Content Review of importing and loading data Importing data Transforming data Adding custom columns Creating data models Building visuals Creating date calendars Building date tables Creating Financial Year information Including Month and Day information Creating calculated columns Power Query custom columns vs DAX columns Creating DAX calculated columns Creating measures Implicit vs Explicit Measures Building measures Using DAX Common DAX functions Drill Down vs Drill Through Review of drill down Creating drill through pages Using drill through Creating ToolTips Pages Adding pages to use for Tooltips Linking ToolTip pages to visuals Using action buttons Adding images Adding buttons Setting actions Working with slicers Adding slicers Changing slicer settings Syncing slicers between pages Showing what has been sliced Setting slicer interactions Techniques in the Power BI Service Hiding the navigation bar Stopping users manually filtering

Duration 3 Days 18 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, Solution Architects, and System Architects. Overview Describe the SAP BusinessObjects Business Intelligence tools.Learn about the use cases and get an overview of basic functions of the most important BusinessObjects reporting tools. In this course, students describe the SAP BusinessObjects Business Intelligence tools and learn about the use cases by getting an overview of basic functions of the most important BusinessObjects reporting tools. Overview of SAP BusinessObjects Business Intelligence (BI) 4.1 Describing SAP Analytics Solutions Identifying the Components of SAP BusinessObjects 4.1 Semantic Layer in SAP BusinessObjects BI 4.1 Describing Semantic Layer Technology Creating a Universe in the Information Design Tool SAP Crystal Reports Creating a Report in SAP Crystal Reports for Enterprise Creating a Report in SAP Crystal Reports 2013 Differentiating SAP Crystal Reports 2013 and SAP Crystal Reports for Enterprise SAP BusinessObjects Web Intelligence Creating Web Intelligence Documents in SAP BusinessObjects Web Intelligence SAP BusinessObjects Analysis, Edition for Microsoft Office Creating a Workbook in SAP BusinessObjects Analysis, Edition for Microsoft Office SAP BusinessObjects Analysis, Edition for OLAP Creating a Workspace with SAP BusinessObjects Analysis, Edition for OLAP SAP BusinessObjects Design Studio 1.2 Creating an Analytical Application in SAP BusinessObjects Design Studio 1.2 SAP BusinessObjects Dashboards Creating a Dashboard with SAP BusinessObjects Dashboards SAP BusinessObjects Explorer Creating an SAP BusinessObjects Explorer Information Space SAP Lumira and SAP Predictive Analysis Visualizing Data in SAP Lumira Forecasting in SAP Predictive Analysis Additional course details: Nexus Humans SAPBI Introduction to SAP BusinessObjects BI Solutions 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 SAPBI Introduction to SAP BusinessObjects BI Solutions 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 Authors Overview Please refer to course overview This course teaches experienced authors advanced report building techniques to enhance, customize, manage, and distribute reports. Additionally, the student will learn how to create highly interactive and engaging reports that can be run offline by creating Active Reports. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Deck Create an Active Report with 11.0 visualizations

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owner/Team Lead/Power Users. Overview Create complex Web Intelligence documents using advanced query and reporting techniques, including:Combined queries and sub-queriesCharacter and date string functionsVariables and calculation contextsLink documents using hyperlinks In this course, students will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. Web Intelligence Core Report Design Reviewing Core Report Design Concepts Comparing the Differences between Java Report Panel (JRP) and WebI Rich Client (WRC) Multiple Data Sources Synchronizing Data from Multiple Data Sources Creating Multiple Queries in a Document Synchronizing Data with Merged Dimensions Interacting with Other Data Providers Advanced Query Techniques Implementing Combined Queries Implementing Subqueries Creating a Query Based on Another Query Changing Data Sources Calculation Contexts Describing Calculation Contexts Redefining Calculation Contexts Implementing Extended Syntax Operators Implementing Extended Syntax Keywords Defining Calculation Context Formulas with Character and Date String Functions Creating Formulas with Character and Date String Functions Implementing the Right() Function Implementing the Replace() Function Implementing the SubStr() Function Implementing the Pos() Function Concatenating Character Strings Implementing Date Functions If Logic Executing If() to Group Data Executing the If() Function to Modify Calculation Behavior Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Documents Managing Hyperlinks in Web Intelligence Desktop and the Rich Internet Application Panel Managing Hyperlinks in the Web Intelligence Interactive Panel Additional Reporting Techniques Implementing Data Tracking Implementing Additional Report Functions

Duration 2 Days 12 CPD hours This course is intended for System administrators Overview Prepare you to perform key administrative tasks in SAP BusinessObjects Business Intelligence platform to manage users, groups, and objects, and to distribute contents to users. In this course, students perform key administrative tasks in SAP BusinessObjects Business Intelligence platform to manage users, groups, and objects, and to distribute contents to users. SAP BusinessObjects Business Intelligence (BI) Platform Identifying the Components of the SAP BusinessObjects Business Intelligence BI Platform Content and Objects in the SAP BusinessObjects Business Intelligence (BI) Platform Viewing and Modifying Objects in the BI Platform Organizing Objects in the BI Platform Searching for Content in the BI Platform User and User Group Security in the SAP BusinessObjects Business Intelligence (BI) Platform Setting Up Users and Groups Administering Rights Application Security in the SAP BusinessObjects Business Intelligence (BI) Platform Managing Access to Applications Securing Applications Content Distribution Using Scheduling and Alerting Scheduling Objects Managing Instances Managing Calendars Managing Events Configuring Alerts and Alerting Publications and Publishing Designing Publications Additional course details: Nexus Humans BOE310 SAP BusinessObjects Business Intelligence Platform - Administration and Security 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 BOE310 SAP BusinessObjects Business Intelligence Platform - Administration and Security 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 geared for Python-experienced attendees who wish to be equipped with the skills you need to use pandas to ensure the veracity of your data, visualize it for effective decision-making, and reliably reproduce analyses across multiple datasets. Overview Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Understand how data analysts and scientists gather and analyze data Perform data analysis and data wrangling using Python Combine, group, and aggregate data from multiple sources Create data visualizations with pandas, matplotlib, and seaborn Apply machine learning (ML) algorithms to identify patterns and make predictions Use Python data science libraries to analyze real-world datasets Use pandas to solve common data representation and analysis problems Build Python scripts, modules, and packages for reusable analysis code Perform efficient data analysis and manipulation tasks using pandas Apply pandas to different real-world domains with the help of step-by-step demonstrations Get accustomed to using pandas as an effective data exploration tool. Data analysis has become a necessary skill in a variety of domains where knowing how to work with data and extract insights can generate significant value. Geared for data team members with incoming Python scripting experience, Hands-On Data Analysis with Pandas will show you how to analyze your data, get started with machine learning, and work effectively with Python libraries often used for data science, such as pandas, NumPy, matplotlib, seaborn, and scikit-learn. Using real-world datasets, you will learn how to use the powerful pandas library to perform data wrangling to reshape, clean, and aggregate your data. Then, you will be able to conduct exploratory data analysis by calculating summary statistics and visualizing the data to find patterns. In the concluding lessons, you will explore some applications of anomaly detection, regression, clustering, and classification using scikit-learn to make predictions based on past data. Students will leave the course armed with the skills required to use pandas to ensure the veracity of their data, visualize it for effective decision-making, and reliably reproduce analyses across multiple datasets. Introduction to Data Analysis Fundamentals of data analysis Statistical foundations Setting up a virtual environment Working with Pandas DataFrames Pandas data structures Bringing data into a pandas DataFrame Inspecting a DataFrame object Grabbing subsets of the data Adding and removing data Data Wrangling with Pandas What is data wrangling? Collecting temperature data Cleaning up the data Restructuring the data Handling duplicate, missing, or invalid data Aggregating Pandas DataFrames Database-style operations on DataFrames DataFrame operations Aggregations with pandas and numpy Time series Visualizing Data with Pandas and Matplotlib An introduction to matplotlib Plotting with pandas The pandas.plotting subpackage Plotting with Seaborn and Customization Techniques Utilizing seaborn for advanced plotting Formatting Customizing visualizations Financial Analysis - Bitcoin and the Stock Market Building a Python package Data extraction with pandas Exploratory data analysis Technical analysis of financial instruments Modeling performance Rule-Based Anomaly Detection Simulating login attempts Exploratory data analysis Rule-based anomaly detection Getting Started with Machine Learning in Python Learning the lingo Exploratory data analysis Preprocessing data Clustering Regression Classification Making Better Predictions - Optimizing Models Hyperparameter tuning with grid search Feature engineering Ensemble methods Inspecting classification prediction confidence Addressing class imbalance Regularization Machine Learning Anomaly Detection Exploring the data Unsupervised methods Supervised methods Online learning The Road Ahead Data resources Practicing working with data Python practice